Sr. DW BI Informatica Consultant

PROFESSIONAL SUMMARY

• A Seasonal professional with over 11 years of experience in information technology, providing business data solutions to clients of various domains like HealthCare, Automobile, Banking, Pharmacy, Insurance and Manufacturing.
• Extensive experience with expertise in the field of Enterprise Data Warehousing, Data Integration and Data/Code Migration.
• Extensive exposure to Business Intelligence projects with experience in building Enterprise Data Warehouse, Data Marts and Operational Data Stores.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Experience in using Informatica PowerCenter ETL tool v8.6.1/8.1.1/7.1.3/6.2/5.1 , Informatica PowerExchange 8/8.6/9.1 with industry best practices and experience in Reporting tools like Business Objects
• Solid understanding of Ralph Kimball Bill Inmon's Methodologies
• Experience in dimensional modeling Star Schema Snow Flake Schema .
• Expert on various UNIX AIX, SUN, HP - UX and SVR systems and Scheduling tools like AUTOSYS CONTROL-M.
• Hands on with Oracle RDBMS v10g/9i/8i with proficiency in writing SQL queries and PL/SQL procedures.
• Experience in writing ksh UNIX scripts.
• Team player, self starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS

• DW BI : TeradataV13.10,InformaticaPowerCenter8/7.x/6.x/5.x,OLAP,OLTP
• Databases : Oracle 9i/8.x/7.x, MS SQL Server, MS Access, DB2, Teradata V2R5/V2R6
• Programming : C, C , UNIX Shell Scripting, PL/SQL
• Operating Systems : UNIX, Windows, Mainframes
• Other Tools : WinRunner, Test Director, Quality Center, QTP, Toad 8.5, SQL Navigator, control M,
• AUTOSYS, Tivoli, Vmware, ALM
• Web Servers : IIS 6.0, Apache 1.3.x, Sun One Web server, Tomcat

PROFESSIONAL EXPERIENCE

Confidential

Sr. DWBI ETL Developer

The Confidential initiative requires participating payers to supply information about their enrolled membership on a regular basis. This information will be matched with other membership information in CAQH system to identify whose benefits may need to be coordinated. These members with COB are then returned to the payers for use in their internal process.

Responsibilities

• Worked with systems analysts to understand source system data to develop accurate ETL programs.
• Experience on data analysis field validation for source, Staging DW.
• Developed INFA mappings, sessions, workflows in line with industry best practices and standards.
• Developed load control table based technique to incrementally load data from EDW into the data mart.
• Designed and developed a number of complex INFA PowerCenter mappings using various transformations like Source qualifier, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner, Union, App Multi-Group Source Qualifier, Application Source qualifier.
• Created EDW dimension table load programs as Slowly Changing Dimensions SCD with Type II logic.
• Implemented code re-usability by creating re-usable transformations.
• Implemented the Change Data Capture extensively to send only the delta records to the target systems.
• Loading facts and dimensions from source to target data mart
• Resolved memory related bottleneck issues like DTM buffer size, cache size to optimize workflow/session runs.
• Performance tuning through SQL tuning, indexes and INFA mapping and session level .
• Created Migration documents Informatica documents.
• 24x7 On-call production support.

Environment

ALM, Teradata V13.10, Informatica Powercenter 8.6.1, Informatica Powerexchange 8, Unix, Oracle 10g, Toad 9.5, Power Exchange 8, Microsoft Office, Windows 7.

Confidential

Sr. Informatica ETL Developer

Paul, Minnesota, with significant operations in Hartford, Connecticut, provides commercial Property-Casualty Insurance, Personal-Casualty Insurance and asset management services. There are field offices in every states of USA, plus operations in UK, Ireland, Canada and Mexico.

Responsibilities

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets
• Analyzed application requirements and provided recommended design and Studied the current system to understand the existing data structures
• Participated actively in user meetings and collected requirements from users
• Used Informatica Power Center 8.1 for extraction, transformation and loading ETL of data in the Data Warehouse and used velocity methodology
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup Connected unconnected , Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter
• Involved in design and development of ad-hoc data load or business critical code enhancement
• Wrote on stored procedures, functions, views.
• Developed data Mappings between source systems and warehouse components
• Created workflows and tested mappings and workflows in development, test and production environment
• Developed re-usable transformations, mappings and mapplets confirming to the business rules.
• Used Debugger to test the mappings and fix the bugs.
• Actively involved in Performance improvements of Mapping and Sessions and fine tuned all transformations
• Performed Informatica code Migration from Development/ QA/ Production and fixed and solved mapping and workflow problems
• Developed and maintained optimized SQL queries in the Data Warehouse

Environment

Informatica 8.1.1, UNIX Scripting, Toad, Oracle 11g, Sql, Pl/sql, COgnos 10.1

Confidential

ETL Developer

• The Development of EDW is the strategic phase on the Swiss Banking IT Platform SBIP for all reporting and analytic applications over historical and end of-day data.
• Data to be analyzed are obtained from various data sources, integrated and historized. Data obtained from the source systems are loaded into so-called subject databases. As the name suggests, each such database collects data about one specific subject such as payments or credits .

Responsibilities

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Collecting new requirements from client.
• Meeting with user groups to analyze requirements, proposed changes in design and specifications by the reports development group.
• Prepared user requirement documentation for mapping and additional functionality.
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.
• Analysis of the requirements and translating it into Informatica mappings.
• Used Repository Manager to create user groups and users, and managed users by setting up their privileges.
• Extensively used ETL to load data using PowerCenter from source system into staging tables and to load the data into the target database.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created PL/SQL Scripts and Stored Procedures for data transformation on the data warehouse.
• Testing Informatica Mappings for data accuracy.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Creating / Updating and Running / scheduling Batches and Sessions.
• Developed PL/SQL stored procedures for pre and post session commands.
• Analyzing specifications for various applications enhancements for compatibility within the system.
• Involved in various discussions with end user.
• Monitoring Data Loads.
• Performed Unit testing.
• Designed and developed UNIX shell scripts.
• On call Production Support.
• Tuned performance of Informatica session for large volumes of data by increasing data cache size and target based commit interval.

Environment

Informatica Power Center 7.1.3, Unix Scripting, Oracle10g, Pl/Sql, DB2, Autosys.

Confidential

Informatica Developer

Confidential is a leading global investment bank with a strong and profitable private client's franchise. Its businesses are mutually reinforcing. A leader in Germany and Europe, the bank is powerful and growing in North America

Responsibilities

• Participated in business meetings and Involved in design and development and identifying data sources and targets
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle9i
• Created business documents for existing Mappings and created INPUT, OUTPUT documents
• Translated business processes into mappings for building Data Ware house by using Informatica 7.1.3
• Created workflows for mappings and tested mappings and workflows
• Extensively used most of the transformations like FILTER, Router, Joiner, Lookup Connected Un-Connected , Aggregator, Expression, NORMALIZER and Update Strategy
• Scheduled code reviews with team lead and Unix shell scripts are used for scheduling to automate the load process While testing extensively used pmcmd to schedule and execute
• Involved in the Upgrade project from Informatica 5.1.1 to Informatica 7.1.3 in all phases of Development, Test and Production Environments and actively involved in Performance improvements and enhancements
• Actively involved in design, development of CAREMARK Mail Order pharmacy/On-line pharmacy project and created Mappings and Workflows
• Involved in testing of CAREMARK mappings and workflows and performance tuning of mappings and sessions
• Used Autosys for CAREMARK application to scheduling sessions
• Used debugger to test data flow from Source to Target and fix problems and used test load options
• Wrote Stored Procedure, tested and used in Pre Session to validate Pharmacy names
• Extensively worked in the performance tuning of the mappings, ETL Procedures and processes.
• Worked with the front-end developers for Cognos Impromptu for designing and developing catalogs for the reporting purpose.
• Performed other administrative tasks like User Authentication, Creating new users/user profiles etc.
• Developed reports by retrieving the data from .cat file to make list of cross-tab reports.
• Developed queries, which were used to develop cubes.
• Assisted the client in the deployment of IWR and secured reports on the web.

Environment

Informatica 7.1.3/ 5.1.1, UNIX Sun Solaris 8 , Autosys, Oracle9i, Pl/Sql, COBOL, DB2, UNIX Scripting, TOAD 7.6, Cognos 7.x

Confidential

ETL Developer

Confidential

together with its subsidiaries and affiliates, is a leading diversified international family entertainment and media enterprise with five business segments: media networks, parks and resorts, studio entertainment, interactive media and consumer products. Disney is a Dow 30 company with revenues of 36.1 billion in its most recent fiscal year

Responsibilities

• Extraction, Transformation and Load was performed using Informatica Power Center to build the Data Warehouse
• Creation of Transformations like Sequence generator, Lookup, joiner and Update Strategy transformations in Informatica designer
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, variables and Dynamic Cache
• Wrote stored procedures for dropping and re-creating indexes for efficient Data Load and used Pl/Sql
• Worked on Data Modeling by involving in the design of the Subscription Data Mart, Staging Customer Contact Model
• Extensively used Pl/Sql to load and implement business rules before transforming data to Target Database.
• After cleansing data used Informatica tool to extract, transform and load the data from MS SQL Server, Flat Files to load Target
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica Workflow Manager
• Created Migration Documentation and Process Flow for mappings and sessions

Environment

Informatica Power Center 5.1, Erwin 4.1, oracle 9i, PL/SQL, SQL Server 2005, Db2, Xml, Microsoft Reporting Services, Test director, Unix, Unix Shell Script, VSS, Itemfield Content Master data Transformation Tool.

Confidential

ETL Quality Analyst

Receivables, Payables, General Ledger, Vendor Management, Suppliers, Customers, and Items is collected into the target database. Periodic reports are also generated to monitor the financial activities. Source database was a combination of flat-files, Oracle tables and XML files.

Responsibilities

• Creation of test data request to cover all the scenarios identified.
• Extraction of data from source and validation in each of the ETL layers.
• Ensured that the data required for testing is present/created in all the source systems
• Debugging of issues and identifying the root cause of the issue and working with the development team on its resolution
• Worked on System Integration testing involving the billing, PeopleSoft, CDR data
• Debugging of the jobs failed and analyzing the reason for the failure in the DataStage Designer

Environment

Oracle, MS Word, MS Excel, Test Directory