PROFESSIONAL SUMMARY:

• Result oriented professional with over 8+ years of experience in Information Technology in requirement gathering, data analysis, design, development and expertise in Data warehousing solutions using Informatica Power Center.
• Involved in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Extensively used Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Strong knowledge in all phases of Software Development life Cycle (SDLC) with experience in Educational, Financial, Manufacturing, Insurance and Telecom domains.
• Developed complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Experience in developing complex Mapplets, Worklets and re-usable Tasks, re-usable mappings.
• Functional and technical expertise in TOAD to analyze the tables, create indexes and import data from different schemas.
• Worked on SQL, PL/SQL Stored procedures, Functions, Packages, Triggers, Cursors.
• Worked on UNIX shell scripting, automation of ETL processes using Autosys
• Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mapping, target and sessions.
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets.
• Experience in handling initial (i.e. history) and incremental loads in target database using mapping variables.
• Knowledge on business Intelligence reporting tool, Business Objects 6.5/6.0 and Cognos as Report Net Report\Query Studio, Framework Manager.
• An excellent team member with an ability to perform individually with strong verbal, interpersonal and written communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.6.1/ 9.5.1/9.1.0 /8.6.1 / 8.1.1/7.1.2 , Power Exchange, Informatica Data Quality(IDQ), IBM Info sphere DataStage 8.5,Data Mining,Analytical and Transactional systems

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5, Oracle Designer

Business Intelligence: Business Objects 6.5,OBIEE, Cognos Series 7.0, SQL Server Reporting and Analysis, Web focus

Programming: Unix Shell Scripting, SQL, PL/SQL, ISQL, ANSI SQL, Transact SQL, SQL * Loader, SQL*Plus 3.3/8.0

Databases: Oracle 10g/9i/8i,Netezza,XML,SQL Server,SAP,Mainframe DB2, MS Access 7.0

Environment: Sun Solaris 2.6/2.7, HP-UX, IBM AIX 4.2/4.3, OS/390, MS-DOS 6.22, Win 95/98, Win NT 4.0

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Sr ETL Informatica Consultant

Responsibilities:

• Worked to resolve the data/logical issues after the recent go live.
• Worked with ETL Architect/ Data modelers to design new ETL for jobs with performance issues.
• Used SAP Exchange for Informatica to integrate and get real time source data using SAP ALE IDoc Reader Domain transformation.
• Created new ABAP extractors for new custom contracts needed from source depending on Delta/Full load as needed.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Worked on Informatica IDQ mappings to complete data profiling and matching/removing duplicate data.
• Dealt with mostly General ledger/finance and product side of the data and reports to fix the amounts and get right annual profits for business users.
• Two Informatica provided SAP extractors for logistics and finance to be run 24/7 to get OLTP data.
• Working on analyzing performance of individual transformations and optimizing the performance for both Informatica jobs and Databases where applicable.
• Responsible for unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing) to get user approval and move changes to QA/PRD.
• Involved in Cognos report unit testing after the changes blasted out in frame work model.
• Worked on Confidential website customer and product data updates which is populated in cloud using AWS RedShift.
• Used Skybot scheduling tool to run the Individual/Member jobs or Job suites to run as a batch.Member jobs are used to not miss any data dependencies between dim and fact tables.

Environment: Informatica Power Center 9.6.1,ABAP Extractor/SAP Exchange for Informatica,XML,AWS RedShift,IBM Cognos Report Studio 10.2.2.0,SkyBot,PL/SQL,SQL Server 2012,StarTeam,Microsoft SQL Server Management Studio 11.0, flat files.

Confidential, Brea, CA

Sr. BI ETL Informatica Developer/ Data Analyst

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts and users to get specific requirements to build Data Marts as per ETL standards.
• Worked on developing Functional design, Detailed level designs and Mapping documents as per the business requirements.
• Used Informatica B2B data transformation studio to read unstructured and semi structured data and load them to the target.
• Developing complex Mappings using Informatica Power Center Transformations - Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA).
• Adopt existing UNIX shell legacy scripts and modify them as per required data process and for better performance.
• Creation of client specific linux perl modules that stage/parse raw client data from a variety of formats and render documents into postscript and/or pdf formats.
• Creation of stand-alone, browser based and command line, perl utilities that run on windows and linux.
• Prepare test data files using Linux Shell scripts, Perl script as per the business requirements.
• Involved in writing NZSQL scripts to load fact and dimension tables..in Netezza using Aginity Workbench.
• Used unix scripts to create parameter files and workflows in Informatica to load data from Audit layer to Datamarts.
• Worked on analyzing performance of individual stages and optimizing the performance by adopting standard Performance tuning methods for both Informatica and Databases.
• Wrote unix shell/kshell scripts to search a big flat file using commands like grep, tar for image manipulation. Involved in shell scripting for required file manipulations/sending email notifications once user received the required reports.
• Resolving complex production support issues by cleansing data or fixing the jobs as per requirement and made sure SLAs are met.
• Use Active batch to schedule and monitor jobs.
• Responsible for unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing)

Environment: Aginity Work bench for NETEZZA,NZSql,SQL Plus, Netezza,Unix shell scripts,Linux Perl 5.8, Putty/Winscp, Informatica Power Center 9.5.1/9.1.0 , Informatica B2B Data Transformation Studio/Dataexchange,IBM Cognos Report studio 10.2.2,Active batch,PL/SQL,UNIX scripting, Oracle 10g/11g,SQL Server, StarTeam, SQL Developer, flat files.

Confidential, Naperville,IL

Sr. ETL Production Suppport Engineer

Responsibilities:

• Involved in understanding business processes and coordinated with business analysts and users to get specific requirements to build Data Marts as per ETL standards.
• Worked on developing Functional design, Detailed level designs and Mapping documents as per OMX business requirements
• Adopted existing UNIX directories and scripts and modified as per required data process and for better performance enhancements.
• Develop the Perl and Shell scripts to automate the finance billing file.
• Developed and implemented the new flow of Component trades which includes loading the feed file in Perl/Unix shell, applying the business rules through stored procedures and generating the report in Perl for the end users for and adhoc report.
• Experienced working on databases like Oracle,Mainframe,Flatfiles and SAP as sources.
• Was involved in resolving complex production support issues by cleansing data or fixing the jobs as per requirement and made sure SLAs are met.
• Created fix workflows to load data after a failure in job due to data issue.
• Analysed jobs which were running from many years to improve the performance of jobs as per the increase in data volume according to season and sales.
• Developed custom item file jobs to provide customers with special price on the products to specific customers with bulk orders all around the year.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Mixed Field matcher.It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Used different Parallel job stages like Join, Merge, Lookup, Filter, Col and Row generator, Transformer, Modify, Aggregator, Remove Dup, External Filter, External Source and Target Stages, Oracle and ODBC Stages, Stored Proc Stages etc.
• Created Master sequencers using User variable Activity, Job Activity, Execute Command Stage, Start Loop Activity, End Loop Activity, Nested Condition, Exception Handler Stages
• Designed and developed the DataStage server as well as parallel jobs for extracting, cleansing, transforming, integrating and loading data using DataStage designer.
• Created UNIX shell scripts to utilize the DataStage Parallel engine to handle large volumes of data
• Built store procedures and used SQL Loader Utility for bulk and faster loading data in oracle tables
• Used UC4 to schedule and monitor jobs.
• Paraccel is used for reporting purposes for Business Objects team.
• Responsible for unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing).
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Used Quality center for tracking and resolving defects.

Environment: SQL Plus, Unix shell scripts, Putty,Informatica Power center/IDQ 8.6.1,IBM Info sphere DataStage 8.5, UC4 scheduler, SQL Loader Utilities, PL/SQL,Perl Scripting, Oracle 10g/11g,SQL Server,Toad for Oracle 10.0,IT Remedy, SQL Developer, flat files, Business Objects enterprise 11.5,Paraccel.

Confidential, Monroe, LA

ETL Informatica Developer/Data Analyst

Responsibilities:

• Migration of data from Confidential system to Qwest server as a part of merging of the two companies.
• Worked on developing Functional design, Detailed level designs and Mapping documents.
• Involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Datamart.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Wrote UNIX scripts to run and schedule workflows on Production server for the daily runs.
• Used different transformations like Source Qualifier, Expression, Filter, Lookup transformations for transformation of the data and loading into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and look-ups to improve the performance as the volume of the data was heavy.
• Wrote scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control/auditing of different processes.
• Automated the Informatica process to update a control table in database when maps are run successfully.
• Developed Informatica mappings, enabling the extract, transport and loading of the data from DB2 database to flat files and into target tables in Oracle.
• Developed PL/SQL procedures/packages to kick off the SQL Loader control files/procedures to load the data into Oracle.
• Prepared documentation for business data flow from source to mart and also for the changes made to the mappings/sessions existing to eliminate the errors.
• Defined file provisioning process (DW Preprocessing Steps). 100% automation of file provisioning process using UNIX, Informatica mappings and oracle utilities.
• Responsible for migrating project between environments (Dev., QA, Prod)).
• Solely responsible for the daily loads and handling the reject data.
• Worked on Adhoc reporting and wrote new pl/sql packages and procedures for maintaining the business(MTB)

Environment: Informatica Power Center 9.1/8.6.1/8.6.0 , Teradata SQL Assistant 12.0,Oracle PL/SQL developer 8.0,Greenplum 3.1,Oracle 10g,SQL Plus, Unix shell scripts, Web focus, Linux, Putty, EDW scheduler

Confidential, Reston, VA

ETL Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis of the specifications provided by the clients and updating Report Descriptions, Software Requirements Specification documents.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Developed mappings using reusable transformations.
• Generated SQL loader scripts and shell scripts for automated daily load processes.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write stored procedures to increase the performance.
• Modified UNIX scripts to monitor systems and automation of daily tasks and customer requests.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources (Flat files, Oracle, SQL Server, XML) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Union and Update Strategy to load the data into the target.
• Worked with Memory cache for static and dynamic cache for better throughput of sessions containing Lookup, Joiner, and Aggregator and Rank transformations.
• Worked on Incremental Aggregation for Improving Performance in Mapping and Session level.
• Created Mappings for Populating data to dimensions and fact tables.
• Performed Informatica administrative tasks such as stopping/starting Informatica Repository and Server processes.
• Provided Production Support for business users and documented problems and solutions for running the workflow.
• Moving the mappings and workflows to staging and then production environment and testing the process at every level.
• Create support documents for the mappings and sessions.

Environment: Informatica Power Center 8.6.1, Power Exchange 8.6.1,Oracle 11g/10g,Clear Case, Clear quest, Cognos 8, XML, PL/SQL, Toad 9.6.1.1,Unix Korn-shell scripts, Perl scripts, SQL Server Query Analyzer, Erwin, Linux.

Confidential, Irving,TX

ETL Developer

Responsibilities:

• Met with Business Users, identified business requirements of the organization and documented these requirements into processes required for attaining those requirements.
• Participated in build of Data Warehouse which includes the Design of the Data warehouse using Star Schema
• Created Repositories, users and provided permissions for each.
• Handled various types of sources like flat files, Oracle, SQL Server, Teradata
• Extracted SAP HR data into informatica using SAP power connect and application source qualifier to get data from SAP system into source analyser.
• Worked extensively with complex mappings using transformations like update strategy, expression, aggregator, stored procedure, filter, lookup.
• Created reusable transformations and mapplets in the designer using transformation developer and mapplet designer tools.
• Scheduled Sessions to run at specified time intervals and optimized the mappings and reduced running time.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Configured and used FTP by the Informatica Server to access source files
• Extensively used SQL and PL/SQL Procedures and Worked in both UNIX and Windows Environment.
• Worked on UNIX shell Scripts.
• Appropriate tuning was performed to improve performance and provide maximum efficiency.

Environment: Informatica Power Center 8.6.1/8.5/7.1 , Power connect 8.6.1, Oracle 11g/10g,SAP HR, MS SQL Server 2005, XML, PL/SQL, Toad 8.1, Teradata V2R6,Unix shell scripts, Perl scripts, Business Objects 6.5, MS Visio 2002, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Designed and developed data tables to store employee payroll information.
• Interacted with end users to prepare system requirements.
• Identify the data and activities that need to be maintained.
• Designed and developed all the tables, views for the system in Oracle.
• Created indexes, sequences, constraints.
• Developed Application programs using Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
• Supported technical teams involved with Oracle issues and operations.
• Involved in Implementation and production Support of the system.

Environment: Oracle 8i/7, MS SQL, Developer 2000, Forms and Reports, SQL Plus.