SUMMARY

• Over 8+ years of working experience as a Data Analyst in the domain of Healthcare with high proficiency in requirement gathering and data modelling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Hands on experience in importing, cleaning, transforming, and validating data and making conclusions from the data for decision - making purposes.
• Expert in Using SQL profiler, execution plan to log the performance of the application and tracking the deadlocks.
• Experienced in Performance Analyzing and tuning of T-SQL Queries.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Experienced in report writing using SQL server reporting service and creating various types
• Skilled in visualizing, manipulating and analyzing large datasets and also has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Hlook UP, Vlook Up, CountIf, etc) and also experienced with Tableau, MS SQL Server.
• Well verse with Data Migration, Data Profiling, Data Extraction/ Transformation/ Loading.
• Solid understanding of statistical analysis, predictive analysis, machine learning, data mining, quantitative analytics, multivariate testing, and optimization algorithms.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Extensive knowledge on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Expert level knowledge in data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snow flaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
• Expertise in creating and developing Power BI Dashboards into rich look
• Experience in creating different Visualizations in Tableau using Bar charts, Line charts,

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Analyst

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Created, documented and maintained logical & physical database models.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Perform in depth data analysis and load customer details from data warehousing to analyze, generate comprehensive reports to decision makers and other affected by the results.
• Developed strategies and loading techniques for better loading and faster query performance.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling batch jobs.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Extensive knowledge working with ETL tools like Informatica Power centre, IBM Infosphere Data Stage, Microsoft SQL Server Integration Services and reporting tools like Tableau, MS SSRS and MS Power BI.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Model.
• Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, Histograms.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.

Confidential

Data Analyst

Responsibilities:

• Worked with Data Architect and SMEs in identifying the solution for reporting issues found while comparing existing data model in ISR and that developed for ASM.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use - case realizations using RUP tools in Agile.
• Actively involved in analyzing the order management and supply chain management process, managing inventory process and documenting the process.
• Assisted in developing plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD 10 Code set and ANSI X12 5010 formats.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping, ETL tools like Informatica for loading data into the staging tables in the database.
• Involved in designing logical and physical Data models and wrote Business and technical metadata as well as prepared source to target data mappings documents in excels.
• Coordinated with data stewards / data owners to discuss the source data quality issues and resolving the issues based on the findings.
• Worked on SSRS and Microsoft Power BI reports to dynamically present client data in useful and efficient ways.
• Facilitated meetings with business users, data architects, data modellers, business analysts, QA and multiple delivery teams to define the data quality and profiling requirements.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Confidential

Data Analyst

Responsibilities:

• Participate in Requirements Analysis meetings with Data Analysts & users to understand requirements.
• Create High Level Design Document and reviewed with Architects & Data Analysts.
• Analyze and change existing mappings as per the logic mentioned in the mapping document.
• Prepared Business Requirements Documents, Functional Requirement Documents.
• Worked extensively with developing business rules engine enabling the business rules such as referral, prior authorization, eligibility, claims processing and billing essential.
• Utilized Agile Software Methodology using Scrum framework. Actively participated in creating the user stories and prioritizing user stories along with tracking of burn up, burn down charts to estimate sprint delivery
• Performed GAP analysis by performing the system analysis between the scheduling systems and documented the gap items.
• Conducted JAD sessions, meetings, workshops to gather requirements from various stakeholders and SMEs.
• Designed and developed SSIS Packages to import and export data from MS Excel, MS SQL Server and Flat files.

Confidential

Data Analyst

Responsibilities:

• Prepared the Business Requirement Document BRD and Functional Requirement Document FRD for the enhancement of the existing services.
• Conducted JAD sessions with business units and stakeholders to define project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
• Ensured all artifacts compiled with HIPAA 5010 policies and guidelines.
• Worked on EDI transactions like 270,271,834,837 and 835.
• Gathering requirements and preparing functional documents for Facets 4.71.
• Involved in Facets Output generation, Interface development and Facets Migration Projects.
• Create internal and external reports using stored procedures from the Reporting Data Warehouse.
• Utilizing Business Objects to create implement data query templates to efficiently gather data.
• Worked with the client and the database administration team to design database structure for different modules. Use pivot tables in Excel to replicate the reports that can be expected.
• Perform conversion on Excel files created on different versions of Excel. Enhance the Resourcing Reports using power pivots, slicers and spark lines.
• Provide ad - hoc data and reports as needed from resourcing tools and databases.
• Involved in data mapping, logical data modeling, created class diagrams and ER diagrams and using SQL queries to filter data within the database