Data Project

AnushaReddy.Vr

E-mail: ac8aoz@r.postjobfree.com

Mobile: 425-***-****

PROFESSIONAL SUMMARY:

* ***** ** ********** ** IT industry in Design, Development, Implementation for Financial,Insurance,US Health Care Industry

Excellent understanding of US Health care domain, Insurance Domain and extensive knowledge of US Health care Provider, Member, Claims.

Expertise in ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution ETL tool and build Data-warehouse, Operational Data Stores and Data marts.

Actively involved in Dimensional Data Modeling, FACT & Dimensions tables, Physical & logical data modeling.

Worked exclusively in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema

Extensively used Informatica Power Center Designer to develop Mappings, used transformations and workflow Manager to create Tasks and run the workflow.

Strong work experience in performing ETL techniques to load data from different sources

(Oracle, SQL server, Flat files, XMLs and Excel files) into data marts and data warehouse using ETL tool.

Strong experience in implementing SCD

Extensively worked in Oracle, DB2,PL/SQL programming, SQL, Visionplus, flatfiles

Strong computational, analytical, and design skills.

Excellent communication skills and strong team player EDUCATIONAL SUMMARY :

Bachelor of Technology in Information Technology from Patnam Rajender Reddy Memorial College (PRRM) Affiliated to JNTU, Hyderabad, India Board of intermediate education

Sri Chaitanya Junior College, Hyderabad, India

Board of Secondary Education

Vignan Vidyalayam High School, Nizampet, Hyderabad, India TECHNICAL SKILLS:

Database : SQL Server, DB2, Oracle,MS Access

Data Modeling : Dimesional Modeling and Relational Modeling (Datawarehouse)

Operating Systems : Vista,Window7/XP Professional,Linux, Unix

Programming : PL/SQL, SQL, Unix

ETL Tools : Informatica Power center (9.6.1)

Scheduling Tools : Tivoli workload Scheduler (TWS)

Utilities : Putty

DB Tools : Aqua Data Studio, Oracle SQL Developer, DB Visualizer, Toad Project: Lower Cost Alternatives & Advocate4Me

Client: OPTUM Inc. (Product Unit of United Health Group) Company: United Health Group

Roles & Responsibilities

The project main objective is to create a central database for data and provide a set of standard reports basic

Operational Reporting- Strategic Development. The Operational Reporting Strategic Development, from which it

extracting the data through Flat files, Oracle, Various Source Systems into the staging and transforming the source

data using Business logics and Loading it into Oracle target database or the respective data marts and Data

Warehouse using Informatica Power Center. This project will provide a high performing data warehouse platform,

load sales, claims, customer orders and information from master data sources, customer purchase history and

customer knowledge warehouse.

Responsibilities:

Interacted with end-users and functional analysts to identify and develop business requirements and transform

them into technical requirements.

Involved in the SDLC process beginning with the design of dimensional modelling in building the data

warehouse

Worked with Data Architects during Design Stages.

Chalking plans for the development and implementation to ETL data.

Prepared logical flow diagram for requirements and LLD Preparation.

Created low level designs for mapping logics from High level designs provided by client side resource.

Extensively involved in developing the ETL logic to do the Auditing and Error Handling for the loads happening

across different projects using Informatica.

Extracted data from oracle, flat file and xml sources.

Used Informatica Power Centre to create mappings, sessions and workflows for populating the data into

the dimension, facts, and lookup tables simultaneously from different source systems.

Created scripts for automating table partitions.

Created a global repository, groups, users and assigned privileges using repository manager

Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to

Dimensions and Fact tables in the data warehouse.

Involved in performance tuning of the mappings, sessions and workflows.

Made use of post-session success and Post-session failure commands in the session task to execute scripts

needed for clean-up and update purposes.

Extensively used PL/SQL for database related functionality.

Used TWS for scheduling.

Created UNIX shell scripts for data cleaning.

Involved in unit testing and documentation of the ETL process.

Involved in creating the run book and migration document from development to production.

Involved in Data warehouse month end loads and support activities. Project: eSync Health Portal (eHP) Clinical System Delivery Client: UHG Inhouse

Company: UHG Information Services Pvt. Ltd.

Roles & Responsibilities

Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact

Present and defend product designs and architecture to clients

Coordinate and communicate tasks with developers

eHP Healthcare and Clinical System is a powerful Analytic and Reporting Environment that helps health care professionals to better understand and manage Health care for their patients no matter where they are in their health journey.

eHP Healthcare and Clinical System application quickly aggregates all information available to properly diagnose and treat patients, clinical services, provide incentives to respective member based on improvement of their health, health diagnostic and cure program claims as well as prevent future adverse events.

Ensure that development is performed as per requirements

Work with QA to create test scripts and scenarios for enhancements and customizations to the core product

Communicate activities/progress to project managers, business development, business analysts and clients

Involving in analyzing the Functional spec and preparing low level design based on impact analysis

Developing Views (Materialized views which runs dynamically) based on Business requirement

Performance tuning for Informatica mappings

Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.

Creating connection strings for connectivity with database.

Involved in production deployment planning and implementation.

Worked on Production Tickets created by users for their critical requirements. Project: eHP Healthcare & Clinical Assessments, Heatlh Tracker Client: UHG Inhouse

Company: United Health Group

Roles & Responsibilities:

Implemented several change requests to customize functionality in Baan Finance, Manufacturing and Order Management packages, in full conformance with Boeing’s software engineering processes and P+ documentation standards

Providing capability to users to access the information and applications they need throughout their day to support medical decisions. eHP Healthcare and Clinical System application is designed to help providers communicate and collaborate more effectively to improve health outcomes, while improving efficiency and reducing costs.

Designed and developed interfaces to legacy systems

Provide provision to access eHP application and this eHP Healthcare and Clinical System is responsible for develop and support of information management assets for Health Care amenities, Clinical Service Delivery, serving Optum Health Care Solutions, United Healthcare Medicare & Retirement, United Healthcare Community & State and United Healthcare.

Project: Retail to Mail Order(RMO)

Client: OPTUM Inc. (Product Unit of United Health Group) Company: United health group

Roles & Responsibilities

Retrieve the Data needed for the application OptumRX, UHG and Clinical application from different domains such as Datafabric(bigdata), OGM, OptumRx, Optum and UHC and also from external applications

Design and formulate the process of Archiving the retrieved data for different modules of the application OptumRx and Clinical application and assist different enterprise systems which get referred to check for the eligibility of the member (CDB- Consumer Database) and provider data (NDB-Network Database)

Deliver new and complex high quality solutions to clients in response to varying business requirements

Responsible for managing scope, planning, tracking, change control, aspects of the project.

Responsible for effective communication between the project team and the customer.

Provide day to day direction to the project team and regular project status to the customer.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Created Data Models based on the Requirement analysis and provide solution to Business to perform data load within different tables based on Dimension/Relational Modeling theory.

Data integrity between the various source tables and relationships.

Designing scripts, Flowcharts and data flow diagrams.

Populated slowly changing dimensions tables using type 2-dimension changing and maintaining the full history of the data.

Created Unix Scripts for some of the ETL’ s as per the requirement.

Design Informatica Jobs scheduling in Autosys and IBM TWS based on business flow.

Involving in analyzing the Functional spec and preparing low level design based on impact analysis

Performance tuning for SQL queries and Informatica mappings.

Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.

Involved in production deployment planning and implementation

Worked on Production Tickets created by users for their critical requirements.

Responsible for the On-boarding process Knowledge Transfer and code walk-through. Project: Zurich Financial Services

Client : ZURICH Switzerland & UK

Company :Computer Science Corporation

Roles & Responsibilities:

Involved in the Requirement gathering as per the business need.

Worked in team environment in finalizing the Data Warehouse modeling.

Identified the facts and dimensions and designed the relevant dimensions and fact tables.

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

Involved in design, development and maintenance of database for Data warehouse project. Designed the ETL processes using Informatica tool.

Created complex mappings that involved implementation of Business Logic to load data into staging area.

Developed mappings/sessions using Informatica Power Center 9.1 for data loading.

Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, Sequence generator etc.,

Developed Workflows using task developer, Worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Implemented slowly changing dimension methodology for accessing the full history of accounts.

Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.

Analyzed data with discrepancies through Error files and Log files further data processing and cleansing and proper communication with code review team

Participated in weekly status meetings, and conducting internal and external reviews as well.

Project: IFRS(International Finance Reporting Standards) Client : Zurich UK

Company: Computer Science Corporation

Roles & Responsibilities:

Developed mappings/sessions using Informatica Power Center for data loading.

Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, Sequence generator etc.

Development and modification of new and existing ETL mappings for performance enhancement.

Good knowledge in Root Cause Analysis of the failure and document the findings.

Handling effectively daily production batch on occurrence of any failure.

Creating data fix SQL scripts for DBA’s as per requirement.

Analysing production maps, session to fix any critical issue within SLA.

Monitoring the Production jobs in Informatica Workflow Monitor.

Interacting will all the stake holders on business status and needs.

Perform unit testing of maintenance changes and small enhancements.

Working with Analysts/Business for new changes and implementations.

Analysis of Stored Procedures during any failure of calculation of daily inputs to system.

Interacting with different source system in case of delay or error in source data. Declaration

I hereby declare that the above written particulars are true to the best of knowledge and belief.

AnushaReddy.VR

Contact this candidate