Process-oriented Senior Data Analyst having 4.9 years of experience in data analysis and ETL technologies under demanding AGILE environment. Experienced in interpreting and analysing data to drive the growth of the company. I am a conscientious person who works hard and pays attention to detail. I am an effective communicator with excellent interpersonal relationship and management skills. My greatest strength is strong analytical thinking, which enables me to furnish insights and analyse data to support the business to guide their decisions.
-
Experience
Employment History
Senior Data Analyst - AUG 2018 – AUG 2019 (1 Year):
Rural Education and Development Society (READS), India.
• Applied analytical techniques using SQL to help READS, a non-profit organisation to set cost-spending priorities and inform the officers to direct their funds to target communities.
• Involved in ETL process using SSIS in SQL server to manage the vast amount of financial data coming from various sources.
• Analysed the loan distribution and repayment data to reduce fraud losses and to enable smooth transactions to and from NABFINS LIMITED (Central government of India).
• Performed impact analysis to identify the target group eligible for receiving loan using Tableau 2018.1.
• Reported their Financial data metrics in the form of easily understandable visual representations using Dashboards.
• Conducted workshops related to data literacy to upskill the technical team of the organisation.
Business Data Analyst - MAR 2016 – AUG 2018 (2 years 5 months):
Infosys, India.
• Handled Data warehousing application using Informatica PowerCenter 9.6.1 & 10, Teradata 14, IBM-DB2, Informatica data quality 10.1, AWS and Tableau 9.3 for client: SYSCO, USA.
• Led a team of 4 people in the successful deployment and maintained the system “Demand Planning and Replenishment” to forecast the client’s retail business for each week.
• Communicated with clients and gathered the requirements and translated them to align with our project’s technical capacities. Created BRD & UML diagrams to enhance the functionalities within the DPR system.
• Created data mappings using transformations like Expression, Lookup, and stored procedures.
• Individually developed an automation system “Mass Upload Tool” which helped business users to make data uploads for Forecast, Stock keeping units, plan Purchase and Demand.
• Received appreciation from business users for managing IMS applications and developing the automation process to sync up the Master Data and Inventory updates at DPR and SUS.
• Documented the results from the DPR system and represented the descriptive statistics to clients using Tableau 9.3.
• Played the role of Scrum Master within the team and facilitated the Scrum meetings.
Data Analyst - DEC 2014 – MAR 2016 (1 year 4 months):
Infosys, India.
• Gained technical knowledge required for Data analysis by working on technologies such as Informatica PowerCenter 9.6, Microsoft SSIS, IBM-DB2 and SQL.
• Worked in Inventory Management System (IMS) sector which primarily include Data gathering and analysis of Operating Company’s (Opco) sales data.
• Collaborated with SAP (EAI) teams for data collection, data cleansing and formatting in migration activity projects for “Open PO conversion” (Purchase order) using TSQL.
• Performed data cleansing, filtering and aggregation using advanced excel functionalities.
• Applied the slowly changing dimensions (SCD type 1 and type 2) in data warehouse for the purchase history data.