Sign in

Data Analyst

New Jersey, United States
February 05, 2018

Contact this candidate



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


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


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

Contact this candidate