PROFILE SUMMARY:

• Around 7years of Experience with data analytic in Logistics, Health, Financial and insurance industries
• Adept at preparing Business requirements documents(BRDs), Functional requirements documents (FRDs), defining project plans and delivering project reports
• In depth knowledge of Iterative Software Development Life Cycle (SDLC) process, Agile Software Development and Waterfall models
• Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design.
• Strong experience in data extraction, manipulation, Analysis using claims data.
• Experience in analyzing the claims data, future trends and summarized results to generate recommendations for management.
• Worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.
• Developed new or modified existing SQL server programs to load data from the source and create study specific datasets
• Thorough grounding in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Demonstrated good Experience in Statistic Data analysis and creating Reporting in health care, finance and marketing sectors.
• Experience in data analysis using Python (Pandas, NumPy)
• Good working experience loading Data Files in AWS Environment and Performed SQL Testing on AWS redshift databases.
• Hands on experience in T - SQL programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables
• Written SQL queries for checking the Data Migration, Data transformations and Database Integrity in Teradata.
• Extracted data from various data sets using Unions and Joins involving databases like MS SQL Server, Oracle, Teradata, DB2 and MS Access
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Strong ability to write SQL queries
• Experience in Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly
• Effective team player with strong communication and interpersonal skills
• Skilled in using Statistical procedures like advanced excel, R

TECHNICAL EXPERTISE:

Data Analysis Software : MS SQL, R, Tableau, python

Reporting Tools : SSRS, Power BI, Tableau

Database : MS-Access, SQL server

Other Technologies : Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook), Asana agile software, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Designed and developed quarterly and annually reports for various Pilot programs and developed analytical models for customer engagement programs using SQL Server
• Extensive experience developing reports using Data from multiple sources and experience
• Performed gap analysis and data analysis on various datasets using SQL Server
• Performed Data Cleaning and exploratory data analysis to understand data and used statistical techniques to identify relationship among data
• Worked in mapping and migrating reports from legacy data source to strategic data source with sound knowledge on Medical Claims, Eligibility, Members and providers data
• Extensively used Teradata Studio for data analysis and T-SQL for data processing and created visualizations and dashboards by using tools such as Looker and Tableau
• Developed Python programs for manipulating the data reading from various Teradata Tables and convert them as one CSV Files, update the Content in the database tables.
• Developed end-to-end reporting based on business requirements
• Converted programs from SQL Server to T-SQL to automate the monthly production processes
• Worked in Agile environment and has experience in using rally as tracking tool
• Validated 100+ tables from source to 3 different layers and ensured that the transformations are as met as per the requirements.

Confidential

Data Analyst

Responsibilities:

• Performed Analysis, system testing and Validations of Reports and the underlying tables
• Analysed the code and the tables using data manipulation techniques for various Reporting End dates.
• Validated the data and system tested the enhancements on the Release day/code move up
• Worked with the developers closely to identify the issues in the code and to debug the issues
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document.
• Designed Test Cases, Test Scripts and Test Scenarios based on use case docs, Functional requirement docs. Prepared Test Plan, Effort Estimation
• Worked on hot fixes to resolve the gaps/ issues found during the analysis on the data.
• Worked with Production support teams to support the tickets created by the users
• Groomed user stories, helped with creating user stories and acceptance criteria
• Worked on Claims, Alignment, Events, Member Alignment, Data
• Developed T-SQL Scripts to test the reports and validated the data
• Used Python modules like Pandas and NumPy and date time to perform extensive data analysis.
• Experienced in handling tickets and debugging the issues

Confidential

Data analyst

Responsibilities:

• Developed QA scripts to test the tables for counts, data types and values
• Meet with stakeholders to get the requirements for the tables and the columns to be consumed
• Done Source to target mapping and analysis on key Column elements of data.
• Worked with production support teams to handle the updates and changes in the tables
• Worked with developers in debugging the issues in production
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes using SQL.

Confidential

Data analyst

Responsibilities:

• Performed analysis of complex claims within the claims processing system. Resolved problem claims and prepared claim status reports for the department.
• Analysed various tables using data manipulation techniques like Merging, Appending, Concatenating and Sorting. Analysis and Report Creation:
• Developed SQL queries to retrieve required data from servers. Completed extensive data processing and validations using T-SQL datasets.
• Developed programs using T-SQL/Macros to extract data and create datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Used Style attributes and altered formats, fonts, foreground colors, background colors in Proc Reports
• Created customized reports using compute blocks and Call Define statements.
• Wrote Output delivery system (ODS) layout and SQL procedures to create HTML and PDF reports. Created XLS, CSV and PDF reports
• Experience in error handling by using MACRO OPTIONS, MACRO Applications.
• Worked with team members to develop standards for graphical and tabular reports
• Prepared PowerPoint presentations using data from SQL programs to explain the results to management at monthly progress meetings.
• Wrote T-SQL code to report various customer management metrics such as customer category, customer demographics, Service delivery

Environment: VB.NET, SQL, MS-Excel/Word, Windows, Mac OS