Bindu Athota

acp6fi@r.postjobfree.com

267-***-****

Summary:

Over 7+ Years of extensive experience in Informatica (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager and Workflow Manager) and implementation of Data warehouse and DataMart using Power Center with Oracle, DB2, SQL server and Teradata Databases.

Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.

Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse

Usage of Informatica mapping variables/parameters and session variables where necessary

Experience in implementing update strategies, incremental loads.

Experience in coding using Oracle 11g/10g/9i/8i, Teradata, SQL Server 2000 / 2005/08, SQL, PL/SQL procedures / functions, triggers and exceptions. Good experience in Relational Database Concepts, Entity relational Diagrams.

Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins.

Experience in scheduling the batch jobs using workflow designer, Zena, Cron Tab.

Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings using Ralph Kimball methodology

Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.

Excellent in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions, and Triggers.

Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience for requirements gathering, creating data mapping documents, writing functional specifications, queries.

Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.

Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.

Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Zena.

Expertise in OLAP/OLTP System Study, Analysis and E-R Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.

Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.

Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

Technical Skills:

ETL Tools

Informatica PowerCenter9/8.x/7.x

RDBMS

Oracle11g/10g/9i, SQL Server 2000/2005/2008,Teradata

Operating System

Windows NT/2000/XP/7

Job Scheduling Tools

Zena, Cron Tab, Tivoli

Languages

SQL, PL/SQL, Unix Shell Scripting

Database frontend tools

Oracle PLSQL Developer, SQL Assistant, Oracle TOAD.

PROJECTS DELIVERED:

Client Name: Dominion Richmond, VA July’14 – Till Date

Role: Informatica Sr. Consultant

Project: Enterprise Operational/Supply Analytics (EDW/DM)

Description:

Dominion is one of the largest producers and transporters of energy, with a portfolio of approximately 24,600 megawatts of generation, 12,400 miles of natural gas transmission, gathering and storage pipeline and 6,455 miles of electric transmission lines.

Below are the different Projects which are being executed/executing as a part of assignment.

VOP Data Store (ODS)

Enterprise Operational Analytics(ODS, Staging, EDW and DM Layers)

Enterprise Supply Analytics

Router Reporting (ODS, Staging, EDW and DM Layers)

The various steps that are involved in these processes are:

Extract all required data from various source systems located at different countries includes data collection from different social media sites(Face book, Twitter and others)

Building Staging and Data Store layer for next layers

EDW Development based on business logic

DM Development for Dimensions and Facts.

Responsibilities:

Requirement collection from Business users and Reporting team

Giving work estimates for the Informatica Development based on requirements

End-to-End Development/Testing for the Data warehouse using Informatica.

Worked on Informatica Power Center 9.1 tool- Source Analyzer, Target designer, Mapping Designer, Transformation Developer, Mapplet Designer.

Involved in the development of Informatica mappings and also tuned for better performance.

Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to the source system up gradation.

Extracted data from legacy systems and uploaded into Oracle Data warehouse.

Assisting Data Model development team based on Informatica dev requirements

Working with DB Team to address concerns on load related issues

Coordinating Onsite/Offshore team for final delivery

Environment: Informatica Power Center 9.1/8.6, Shell scripting, MS SQL server 2005, Oracle 10g, Quality Toad, PL/SQL (Stored Procedures, Triggers, Packages)

Client Name: BCBSNC Jan'14 –Jun’14

Role Name: Informatica Module Lead

Project: Selective Insurance (SI DW)

Description:

The project is about knowledge management in data warehouse using Informatica 8.x, 9.x. The client needs to maintain historical and live data about their policies and their rates so that can be viewed in the form of reports on day to day and monthly basis. The project consists of different modules comprising of data cleansing, processing and data orientation as per the report requirements.

The various steps that are involved in these processes are:

Extract all required data from various source systems and KM Data Mart.

Calculate the pre-capped variables related to each model from the data.

Provide any additional information required to perform neutralizations, normalizations, and other calculations.

Balancing of data is done at various stages (i.e. source to staging, staging to variable & variable to ODS) to ensure that there is no data leakage when data moves from one state to another.

Responsibilities:

Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model

Worked on Informatica Power Center 9.1 tool- Source Analyzer, Target designer, Mapping Designer, Transformation Developer, Mapplet Designer.

Used most of the transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Joiner, Expression as per the Business requirement.

Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data

Extensively used debugger to troubleshoot logical errors.

Worked with the Business analysts for requirements gathering, business analysis and testing.

Requirement gatherings with the Internal Users and sending requirements to our Source System Vendor.

Used Teradata SQL Assistant to run the SQL queries and validate the data.

Used Teradata and Oracle as sources for building the datamarts to analyze the business individually.

Worked on Data Quality to proactively monitor and cleanse the data for all applications and maintain its clean state.

Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.

Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Working in Agile methodologies and participating daily scrum meetings for providing status reports to team regarding project status, task and issues

Environment: Informatica Power Center 8.1, Teradata, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Client Name: BCBSNC Jan '13 - Dec'13

Role Name: Developer

Project: CLAIMS FRAUD ANALYTICS MART

Description:

The goal of the Claims Fraud Analytics project is to identify the fraudulent claims from the information available from internal and external sources. In order to identify fraud, Selective Insurance has developed models based on a certain set of variables to score the claims. The Data is presented to the User to do mining on the data. This process also includes the scoring of all the current open claims on a daily basis.

Responsibilities:

Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.

Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.

Study of detailed requirement of end users of system & their expectations from Applications

Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.

Business process re-engineering to optimize the IT resource utilization.

Integration of various data sources like Oracle, SQL Server, Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.

Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.

Environment: Informatica 8.x, Oracle 8i, SQL, PL/SQL, SQL*Loader, TOAD, Windows 2000.

Client Name: GEICO Mar '12 – Nov”12

Role: Developer

Project: Central Data Repository

Description:

GEICO is one of the fastest growing Auto Insurance Company. It serves its customers by offering a range of innovative products to individuals and group customers at more than 600 locations through its company-owned offices.

The primary objective of this project is to capture different Customers, Policies, Claims Agents, Products and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Power center and generated various reports on a daily, weekly monthly and yearly basis. These reports give details of the various products of GEICO Insurance products that are sold. The reports are used for identifying agents for various rewards and awards and performance, risk analysis reports for Business development Managers.

Responsibilities:

Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.

Experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables

Designed and developed schema model for target database using Erwin Data modeling.

Involved in pre and post session migration planning for optimizing data load performance.

Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.

Used packages to load the base tables in the Oracle database from the flat file sources and XML sources.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Report generation using PERL and Microsoft Excel spreadsheet.

Used SQL tools like TOAD to run SQL queries and validate the data.

Wrote stored procedures and triggers in Oracle for managing consistency and referential integrity across data mart.

Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.

Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.

Scheduled the batches to be run using the Workflow Manager.

Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Have developed a level of competency, which helps to anticipate issues solve them in advance.

Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process

Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Client Name: Medco Healthcare Mar'10 - Feb'12

Role: Informatica Developer

Project: Analytics Data store

Description:

Medco Healthcare is one of the largest healthcare organizations providing healthcare services. It provides a comprehensive range of inpatient, clinical and diagnostic services in more than 70 areas of medical specialties and subspecialties. During this project I have worked closely with the data warehouse development team, customers, business analysts and other colleagues in the ITS department to analyze operational data sources, determine data availability, define the data warehouse schema and develop ETL processes for the creation, maintenance, administration and overall support of the data warehouse.

Responsibilities:

Involved in design, development and maintenance of database for Data warehouse project.

Involved in Business Users Meetings to understand their requirements.

Involved with business to understand Healthcare standards like HIPAA, HL7 and many other rules

Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.x

Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.

Worked extensively with the connected lookup Transformations using dynamic cache.

Worked with complex mappings having an average of 15 transformations.

Created and scheduled Sessions, Jobs based on demand, run on time and run only once

Monitored Workflows and Sessions using Workflow Monitor.

Performed Unit testing, Integration testing and System testing of Informatica mappings

Coded PL/SQL scripts.

Wrote UNIX scripts for the business needs.

Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process

Created Universes and generated reports on using Star Schema.

Environment: Informatica Power Center 8.1, Oracle10g, Teradata, Cron Tab

Client Name: ICICI Apr '08 - Feb '10

Role: Developer

Project: EDW

Description:

EDW, Enterprise Data warehouse is designed to provide single image of information across Client business and support units. The architecture is flexible, extensible and integrated. The scope of EDW is Organization wide and with vertical, horizontal scalable and high available architecture, all Organization Support and Business units will be included in EDW. This project involves extracting the data from different source system- to integrate in the data warehouse. Dimensional Modeling is base critical phase of this EDW

Responsibilities:

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

Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

Develop the mappings using needed Transformations in Informatica tool according to technical specifications

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

Used Informatica reusability at various levels of development.

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

Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

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

Building Reports according to user Requirement.

Extracted data from Oracle and SQL Server for data warehousing.

Environment: Power Center 8.6, UNIX scripting, MS SQL server 2005

Contact this candidate