ANJALI SHARMA

Authorized to work in Canada on Contract

Business Analyst Data Analyst BI Developer ETL developer Data Integration Developer Master Data Management

SKILLS SUMMARY

Reporting, Power BI, SAP BO Web Intelligence ETL, SSIS, Talend Informatica MDM, IDD Data Analysis Requirement Gathering Team Management SQL Agile Data Management Data Warehousing Oracle, SQL Server RDBMS

PROFESSIONAL EXPERIENCE

EXL Services

BI Developer/Data Analyst

Jan 2019 – Jun 2019 Crewe, United Kingdom

• Worked as a Power BI developer and Data Analyst to analyze the claims for an Insurance client.

• Requirement Gathering and data analysis to generate the SQL scripts required to load data to Power BI.

• Document the SQL scripts to explain the details in the SQL script.

• Load the data in Power BI to create basic dashboards which show the claim count per year-month, dealer and product type.

• Analyze the reports generated through Power BI to minimize the Average Cost of Claims.

• Create the data model, staging, target and work tables to load the data from SSIS Tool. EXL Services

ETL Developer / BA

Sep 2017 – Jan 2019 Bangalore, India

• Requirement Gathering and data analysis to create the mapping documents for Source-Target mapping.

• Create the data model, staging, target and work tables to load the data from SSIS Tool.

• Develop the ETL solution to load the data from API/Flat Files to target by pre-staging the data, transforming it and removing dupes.

• Add checksums to ignore the already existing data and update the fields if required. Used Type 1 and Type 2 to update the tables in case of updated records and maintain the history wherever required.

• Create Unit Test cases to test the solution and deploy the solution to higher environment.

• Create Jobs to schedule full data load and monitor the data load activity in UAT.

• Handle JIRA tickets and tasks for everyday updates. Tata Consultancy Services

MDM Developer / Data Analyst

Apr 2016 – Sep 2017 Gurgaon, India

• Worked as an MDM HUB and IDD developer for a Shipping client to create an application which helps them create/edit and search for master data using Informatica Data Director.

• Handled two MDM projects simultaneously with a team of 2 people and delivered defect free applications in a short span of three months.

• These applications helped the customer maintain a single source of data and eliminate the possibility of storing redundant and duplicate data in the Database.

• It reduced manual efforts of maintaining/filtering duplicate data in excel sheets and database by 70% and increased data authenticity.

• Requirement Gathering and Analysis along with suggestion of data model changes to incorporate the requirement as per MDM and IDD limitations.

• Implementation of the requirement in MDM HUB by creating the Data Model using Base Objects, Landing, Staging tables and Mappings.

• Creation of UI screens in IDD using MDM components like Packages and Match Paths. ac919x@r.postjobfree.com +1-647-***-**** Toronto, Canada

• Handling the validations during create and edit. Tata Consultancy Services

SAS Developer/BI Developer

Apr 2015 – Apr 2016 Gurgaon, India

• SAS Code Development: Used customer data to create the top 7 best possible cost-effective corridors/routes to ship the empty containers around the world from different ports.

• SAP Universe Design: Designed a Universe taking care of Business Objects, Qualifiers, Loops, Contexts, Aliases. Created derived tables to incorporate complex requirements and joins. Published the Universe to use the Objects in Web Intelligence tool for report creation. Created prompt filters for dynamic reports.

• Web Intelligence Report Generation: Generated custom reports with graphs and internal linking to display the data in a readable format for Business Users. Generating counts and percentages dynamically using WEBI inbuilt formulae which helped the user group their reports based on the required parameters. Tata Consultancy Services

Developer/Data Analyst

Dec 2012 – Apr 2015 Pune, India

• Requirement Gathering and Analysis along with identification of the technical and functional challenges and limitations beforehand to establish the delivery timelines.

• Developed reports on R to identify defect count. Prepared Power Pivot dashboards to view the reports graphically and in an interactive interface enabling the user apply filters and view the data in groups.

• Developed an R based UI tool using Shiny application and other algorithms to combine customer data and extract useful information by analyzing the data on different scales like Geography, Time Period, Manufacturer, Product etc. It was highly appreciated by the customer and helped the company convince another client to get their data analyzed using R Studio.

• Created automated scripts and processes to reduce the manual task of weekly report creation to 90%. It saved the effort and time reducing the risk of manual errors while report generation.

• Algorithm Identification: Analysed the requirement and mapped it to the already existing algorithms or created an algorithm or formula to get the desired results. Used Weibull algorithm to predict the failures over time scale. EDUCATION

Bachelor of Technology – Electronics and Communication Banasthali University

Jul 2008 – May 2012 Jaipur (Rajasthan), India

CERTIFICATIONS

• SAS Certification in Base Program for SAS 9 certification.

• Oracle in Oracle Database 12c: SQL Fundamentals.

• Coursera Certification in R programming at John Hopkins University.

Contact this candidate