HIMA
Sr. Data Analyst
***************@*****.***
Professional Summary:
Over 3 years of IT experience in the field of Business/Data Analysis, Process Improvement and Data Integration
Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services
Strong understanding of Data Modeling concepts, Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Models
Ability to collaborate with peers, in both business and technical areas, to deliver optimal business process solutions in line with corporate priorities
Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design, and Testing
Experience in developing accurate business process requirements for Insurance, Banks, and Health care projects.
Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
Worked on various domains like Banking, Finance, Insurance and Health Care.
Strong experience on gathering business requirements from business/user, source to target mapping, creating source to target mapping document, creating process flows, and DFD.
Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
Proficient experience as a Data Analyst in gathering data from different sources, data profiling, data definition, and loaded the data to business warehouse.
Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Informatica Power Center and Data Stage.
Worked with heterogeneous relational databases such as Teradata, Oracle, MS Access and SQL Server.
Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x/9.x - Power Center, Power Mart, Client tools – Mapping Designer, Workflow Manager/Monitor and Server tools – Informatica Server Manager, Repository Server Manager, and Power Exchange.
Solid understanding of adherence to Six Sigma, Agile, Waterfall, RUP, Spiral methodology.
Good Data Warehousing concepts including Metadata and Data Marts.
Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams
Extensive experience in project management best practices, processes, & methodologies, including Rational Unified Process (RUP) and SDLC.
Experienced to work as a Data Analyst to perform complex Data Profiling, Data definition, Data Mining, validating and analyzing data and presenting reports.
Ability to handle and interact with Business users, collect and analyze business / functional requirements.
Professional Experience:
United Health Group, Basking Ridge, NJ Jan 2016 – Current
Sr. Data Systems Analyst
Responsibilities:
Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.
Created draft data models for understanding and to help Data Modeler.
Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
Manipulating, cleansing & processing data using Excel, Access and SQL.
Responsible for loading, extracting and validation of client data.
Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.
Created the conceptual model for the data warehouse using Erwin data modeling tool. Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
Expertise in implementing Data modeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
Communicating to various business stakeholders and understand their vision and ensuring this achieved in the course of the project. Key tasks also include performing LOE impact analysis, ROI analysis, user experience analysis
Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
Tested the data using the Logs generated after loading the data in to Data warehouse.
Prepared Traceability Matrix with requirements versus test cases.
Worked on Master Data Management (MDM) for maintaining the customer information also for the ETL rules to be applied.
Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
Involved in building database Model, APIs and Views utilizing Python, in order to build an interactive web based solution.
Participate in partitioning of VLDB source system.
Tools and Environment: -UNIX,Python,Informatica 9.1, Oracle 11g,MySQL, SQL Server 2012 and 2014, SSIS 2008, PL/SQL, Erwin 4,Splunk,TOAD, MS Access, MS Excel
Apollo Hospitals, India. Jan 2014 – Dec 2014
Data Analyst
Responsibilities:
Gathered requirements, analyzed, and wrote the design documents.
Planning, design and migration of Client data centers between buildings after accessing all requirements and using current hardware and new hardware.
Remediation and patching of Linux Servers.
Analyzed the customer behaviors on progressive website.
Analyzed different versions of the site and the traffic for each month, quarter and year.
Created documentation and updated them so as to reflect the most current process.
Involved in developing many Dash Boards for home, rental and auto insurance.
Worked on different Segmentations such as Email Segmentation process.
Coordinated with several managers in linking information and data within the financial departments.
Involved in user trainings during system upgrades and enchantments.
Compiled reports such as Marketing reports, Brand reports and branch reports
Creating SQL files indexes and calculated the table spaces for each table, tuning the SQL queries (based on the plan tables).
Grant and revoke table access to users.
Created Control files to load data into databases by help of ETL tool (Extract Transform Load Process)
Provided End-user Training and documentation for customer reporting services
Attended JAD sessions and created reports for Budgeting, Finance and Project Management
Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department
Performed data analysis and data profiling using complex SQL on various sources systems
Wrote SQL queries on the databases, wrote test validation scripts and performed system testing
Wrote SQL scripts to test the mappings and developed traceability matrix of business requirements mapped to test scripts to ensure any change control in requirements leads to test case update
Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues
Worked with the developers during coding and while doing the remediation of the software
Worked with the users to do the User Acceptance Testing (UAT)
Documented all data mapping and transformation processes in the functional design documents based on the business requirements.
Created technical specifications documents based on the functional design document for the ETL coding to build the data mart
Created data trace map and data quality mapping documents.
Performed data profiling and data quality
Designed and implemented report layouts according to reporting standards of the department.
Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report
Took initiative to drive the report development process
Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF
Responsible for making the report available for scheduling or viewing on demand
Worked with Technical Experts to Improve Report Performance and performed System testing
Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Informatica, and creating ETL jobs in Informatica.
Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling techniques
Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
Environment: Share Point, PowerPoint, MS Project, Windows XP, UML, SQL, Test Director, MS Outlook, Linux, IBM Web sphere 6.0, Erwin, SQL Server 2000/2005, Crystal Reports 9.0, HTML, Data Stage Version 7.0, Oracle, Toad, MS Excel, PowerPoint, Teradata V2R6, BTEQ, FLOAD, UNIX, SQL, Windows XP, SAS