SUMMARY

• 7 years of IT experience in Business Intelligence, Data warehousing, ETL, Reporting and Data analytics using Business Intelligence and Documentation Tools to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Experienced in Requirement Analysis, Design, Test Preparation, Test Execution, Defect Management, Documentation and Management Reporting.
• Worked with Subject Matter Experts to define functional and technical gaps between existing and desired software state in Data warehousing in - house, and then prompted team members to assess the complexity of work needed to achieve fulfillment of the requirement.
• Experience partnering with business users in identifying, prioritizing & resolving numerous data issues, high level ETL and Reporting Project Plans, design of summary and aggregate tables.
• Designed and Created report models for ad-hoc reports using SSRS. Developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports, dynamic sortingusing various features like Charts, graphs, pie, filters etc.
• Experienced in developing Data Mapping design documents and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Experience on Meta data definition, new business rules identification and implementation to data rules.
• Strong understanding of data quality assurance processes and procedures in software development life cycle (SDLC).
• Implement best practices and methodologies in data analysis, design and modeling.
• Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.
• Strong understanding of Data Modelling in data warehouse environment such as star schema and snow flake schema.
• Management and implementation of database model designs, data flow diagrams, database schemas, DB scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
• Experienced in BI Reporting and ETL tools
• Excellent teamwork skills, good oral, written communication and presentation skills.

TECHNICAL SKILLS

Databases: Oracle, SQL Server, MS-Access

BI Reporting Tools: SSRS,SSAS- Tabular, Advanced Microsoft Excel Services, Crystal Report, Business Objects XI R3.1/4.0,Web Intelligence/ Info view.

ETL Tools: SSIS, Informatica.

Modelling Tools: Erwin

Client Server Technologies: VB, VBA

Programming Languages: C

Operating Systems: Windows, Unix, Linux

Design Tools: Rational Rose, MS-Visio, Erwin

Other Utilities: SQL Agent, Control M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

Sr Data Analyst

Responsibilities:

• Worked closely with HomecareCRM, Saleslogix and internal teams on HomecareCRM application data upgrades.
• Worked on Provider and Harvest data upgrades and activities for HCRM (HomecareCRM) and SHP (Strategic Healthcare Programs) application.
• Generating SSRS reports from SHP database for E-health reports.
• Generated periodic reports based on the statistical analysis of the data using SSRS
• Automating the integration process between Allscripts and HomecareCRM.
• Developed and maintained reports using SSRS and published as PDF, Excel, and CSV formats.
• Used SQL Agent Jobs for scheduling SSIS package, SSRS reports and alerts.
• Performed Data Analysis and Data Cleansing activities using various SSIS tasks such as Conditional Split, Derived Column, and Data validation checks during staging, and before loading the data into Data warehouse.
• Used ETL to implement slowly changing transformation to maintain historical data in Data warehouse.
• Performed Multi File Imports, Package configuration, Debugging Tasks and maintaining SSRS reports.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Worked closely with Security and IRM teams to fix existing vulnerabilities found in PEN and Vulnerability tests for HomecareCRM application.
• Performed Entitlement reviews and Audits for HCRM and SHP applications as part of UHG annual process.
• Coordinated and resolved issues faced during data integration, data updates and application inconsistencies.
• Worked and coordinated with SQL Server DBA teams in resolving DB collation conflicts for SQL server.
• Defined data transfer process (ECG) and created CFT scripts for data migration between different environments.
• Performed both support (HPSM) and development activities for HCRM Native client project.

Environment: SQL Server 2012, SSIS,SSRS, HomecareCRM, SHP - Strategic Healthcare Programs.

Confidential, Minneapolis

Sr Data Analyst

Responsibilities:

• Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Understanding the existing systems and identifying Automation at areas where manual work can be eliminated
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Design documentation for the implementation of the data migration and profiling methodology for different client data using ETL process.
• Efforts included team coordination, strategy, preparation, analysis, and presentation of technical solutions on claim processing data and data movement.
• Defining team responsibilities in resolving priority production tickets.
• Automate the process of gather data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format and enter the data in several data analysis software
• Working on enhancing existing system for secure data migration between different departments..
• Handling risks, problems and working on areas of improvements for process optimization.

Environment: SQL Server 2012,SQL Profiler, SSIS, SSRS, Power Pivot, MS-Excel, SQL Server

Confidential, Milwaukee

Sr Data Analyst

Responsibilities:

• Created and maintained System Use Cases, Activity Diagrams for the assigned modules as part of the requirements deliverables, traced the use cases to detail functional and validation rules.
• Maintained and enhanced existing SSRS reports.
• Acted as liaison with the technology department to define data modeling of new and modified systems, data feeder systems, and data marts for POS department in CCV reporting.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Implemented physical schemas in data warehouse using SSAS - Tabular Model.
• Guided development team for OLAP schema for the CCV database. .CSV format was used in the model in order to ensure proper mapping of data feeds coming in and going out of the database.
• Translated business requirements into system requirements and functional design specifications.
• Created technical and functional requirements documents for reporting needs.
• Performed source-system analysis, transformation analysis and related systems.
• Extensively generate adhoc reports and pull dataset for each R&D, used SSIS, SSRS,SQL, MS Access, MS Excel pivot tables, Charts and functions.
• Identifying suitable reporting Tools to Various Reporting needs.
• Developed and presented analytical reports to the higher management. Handling risks, problems and working on areas of improvements for process optimization.
• Extensively involved in client communication, exploring further options to optimize and use multiple tools and technologies to enhance maximum capabilities.

Environment: SQL Server 2012, SSIS, SSAS - Tabular, Power Pivot, Data Tools, Business Object XI R4.0, INFOVIEW, Web Intelligence, MS-Excel.

Confidential

Data Analyst/Consultant

Responsibilities:

• Actively handled sessions for gathering requirements
• Organized review meetings with various stakeholders and preparing the Business Requirement Document
• Prepared the Functional Requirement Document by coordinating with software team
• Expertise with Agile & waterfall methodology
• Prepared Process Flow Diagram using Microsoft Visio
• Conducted the project meetings successfully by coordinating all users, technical staff and support personnel.
• The stage and target star / snowflake schemas are being designed and modeled using ERWin.
• Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models. Interacted with cross functional teams to facilitate gathering of business requirements.
• Responsible for maintaining and enhancing systems including OLTP, data feeder systems, and data warehouses.
• Trouble shooting issues with business users and Technical teams related to SQL, SSIS and SSRS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
• Involved in Reporting requirements gathering by meeting with the business User’s and base lining the details and translate those requirements into a Data warehouse design.
• Was part of Team’s Design Review meeting’s and other Production issue meetings to discuss and finalize on the Design approach.
• Experienced in Reporting/ DW Data analysis and Data validation process which will overcome maintenance overhead.
• Worked with Data Engineering team to design Facts, Dimensions, Dimensional data Model, Data Structures (relational and OLAP) and Hierarchies of the business model.
• Worked on test cases for testing newly developed reports.
• Worked with different Database systems for Operational and Analytical reporting (Teradata 12, Oracle 10g,, SQL Server 2008).
• Performed extensive data analysis and provided possible reporting solutions for DSS.
• Worked with other ETL Teams to enhance data flow process.
• Successfully managed and co-ordinate Offshore teams.

Environment: BIDS, SQL Server 2008, SSIS, Business Object XI R3.1, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, SQL Server 2005, DB2, ERWin.

Confidential

Data Analyst/Consultant

Responsibilities:

• Worked closely with Project Team, SME and Internal Business Patners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Involved from beginning of the project such as of Statement of Work (SOW) to post implementation of SDLC process.
• Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
• Analyzed Autosys job flows and created JIL’s for data validation process such as pre and post load SQL checks.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Defined target load order plan and constraint based loading for loading data correctly into different target tables and Performed impact analysis for DB2 tables that needs to be compressed and archived to implement the lower cost storage mechanism.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Coordinated with offshore vendor and established offshore teams and processes for code development.
• Coordinated with execution team to define the batch flow for data validation process.
• Involved in all execution phases such as Pre-Mock, Mock1, Mock2, and Mock3 before implementing the conversion data into live event.
• Involved in the front data quality issue for further analysis and resolving root cause issue for data failure.

Environment:, T-SQL, DTS,SQL Server 2008, Oracle 10g,Business Object XI R3.1, INFOVIEW, Web Intelligence, MS-Excel, MS- Word.

Confidential

Systems Engineer

Responsibilities:

• Responsible for defining the scope and business rules of the project, gathering business requirements, and document them textually or using models. Interacted with cross functional teams to facilitate gathering of business requirements.
• Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into technical specifications.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Ensured all production changes complied with change management policies and procedures.
• Developed a Troubleshooting Documents which listed all the support related activities and day-to-day issues encountered every day.
• Coordinated with all the concerned parties (Database team/Project Teams/Application Team) in trouble shooting issues and worked with P1 team for major business critical production issues.
• Designed Informatica mappings such as pass through, split, Type 1, Type 2 and used various transformation such as Lookups, Aggregator, Ranking, Mapplets, Connected and Unconnected lookup, SQL overrides etc.
• Validated ETL mappings and tuned them for better performance and implemented various Performance and Tuning techniques.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Performed Data Analysis and Data validation by writing SQL queries.
• Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting.

Environment: Business Object XI R3.1, INFOVIEW, Web Intelligence, Informatica 9.0, MS-Excel, SQL Server 2005.

Confidential

Systems Engineer

Responsibilities:

• Extensively worked with the client and the infrastructure to analyze available resources for reporting and Analysis.
• Recreated Static reports in Business Objects XI R3.1 and Scheduled the reports to Inbox.
• Created different types of reports, such as: Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations, etc for the Business needs.
• Developed WEBI reports for the mass generation of customer’s utility billing.
• Formatted reports as per the specifications.
• Created report templates for the standardization of reports.
• Developed Pie, Bar charts from the MS Access data base.
• Involved in change and release management Process.
• Involved in Test Plans and Test Cases for Unit and Integration Testing of reports
• Executing and testing reports for data Analysis.
• Validating Oracle SQL’s generated by reports against database.
• Working with the existing application team to fix hyperlinks in reports so that the reports are integrated to Portal.
• Prepared Checklist for all mappings of ETL.
• Trouble shooting failed ETL jobs.

Environment: Business Object XI R3.1, Informatica 9.0, Crystal Reports XI/10, INFOVIEW, Web Intelligence, SQL Server.