PROFESSIONAL SUMMARY:

• Over 8+ years of experience in data warehouse development lifecycle management projects.
• Extensive experience in analyzing and documenting business requirements,system and functional specifications with various stakeholders and end users.
• Extensive experience indata profiling, data migrationfrom various legacy sources and relation alsystems to OLAPand decision support targetsystems.
• Experience in working with business analysts to identify,study and understand requirements and translate them into ETLdesign.
• Exceptional skills in the analysis, design, development, customization, implementation and testingof data warehousing applications.
• Experience in Agile, Waterfall methodology
• Strong knowledge in Business Intelligence concepts and working knowledge of Business Objects, NET.
• Good understanding of Informatica Servers, Repository Services - Installation, configuration, maintenance & administration in Dev, Test & Prod environments.
• UsedInformaticareal time using Webservices, Salesforce.com and Change Data Capture.
• Strong knowledge in working with Informatica Power Exchange for CDC from SQL Server databases as well as Oracle databases.
• Hands on experience in Pentaho Business Intelligence Server Studio.
• Excellent understanding of business process modeling, process improvements, and developing process flows.
• Extensively used Pentaho report designer, Pentaho kettle, Penatho BI server, BIRT report designer.
• Worked in conversion projects from Informatica to Pentaho.
• StrongData Modeling experience and Entity-Relationship design modeling, Dimensional/Hierarchical data modeling, Star and Snowflake schem adata modeling.
• Strong skills in the evaluation and recommendation of ETL best practices to varioust echnical groups including data modelers and developers.
• Experience in creatingHigh Level Design and Detailed Designin the Design phase.
• Extensively worked on theETL mappings, analysis and documentation ofOLAP reportsrequirements. Solid understanding of OLAP concepts especially with large data sets.
• Experience in integration of various data sources including Oracle, SQL server,DB2, Sybase,and MS access andnon-relational sources likeflat filesinto staging area.
• Experience in integrating SFDC sources and targets with Enterprise data marts - Oracle, SQL Server, and Teradata.
• Experience in creating data maps using Power Exchange Navigator version 5.2.2
• Experience in configuring and customizing SFDC data stores and implementing CDC from SFDC sources using Apex triggers, classes and PowerCenter Web Services hub.
• In-depth knowledge in PowerCenter web services hub configuration and maintenance.
• Experience in writing, testing and implementation ofPL/SQL stored procedures,triggers,functions, packagesusing Oracle and stored procedures and triggers using SQL Serverand T-SQL.
• WorkedonTeradata data sources and targetsfor very large data marts.
• Experienced inUNIXwork environment,file transfers,job scheduling and error handling.
• CreatedUNIXshell scriptsto automate and implement workflows, sessions and dynamic source/target databases.
• Proficient in the use of ORACLE (PL/SQL) SQL Loader, ETL Design and programming, Shell Scripting.
• Worked onPerformanceTuning,identifyingandresolving performance bottlenecksin variousaspects of the data warehouse infrastructure including but not limited to sources, targets, mappings and sessions.
• Created Perl Scripts and called in Pre session and Post session commands.
• Excellent analytical/communication skills and good team player.
• Excellent leadership skills with experience inmentoringand managing a team ofdevelopers.
• In depth knowledge of computer operating systems, networks, database technologies as well strong knowledge of interoperability between multiple hardware and software environments.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Power Center 9.5/9.1/9.0/8.1/7. x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, pentaho,Metadata, Data Mart, FACT & Dimensions tables, Physical & logical data modeling, Power Connect, Power Plug, Power Analyzer, Power Exchange.

Databases: Oracle 11g/10g/9i MS SQL Server, Teradata

Programming: SQL, PL/SQL, SQL*Plus, SQL*Loader, Unix, Web Services, Perl Scripting

Tools: TOAD, Excel, Word

Database tools: SQL*Plus, TOAD, SQL

Environment: Windows 95/98/2000/XP, UNIX, MS DOS

Scheduling tools: Autosys,control-M

PROFESSIONAL EXPERIENCE:

Confidential, Mooresville, NC

ETL Informatica Developer

Responsibilities:

• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst
• Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
• Handled huge volumes of data at Enterprise Data Warehouse about 25 Tera Bytes.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Design and development of multi-layer Web Based information systems using Web Services including Java and JSP.
• Created mainframe data maps using Power Exchange Navigator for the sources and targets.
• Created and modified COBOL copybook to connect source data using Power Exchange Navigator
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Used Power Exchange Data Change option (CDC) to capture modified records.
• Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors.
• Developed reusable transformations, mapplets, sessions, worklets to make code very modular and reuse as required
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
• Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unschedule workflows, get status of workflows.
• Performed Informatica administration like user, privilesges, migrations, starting, stopping pmrep/pmserver. Backup and restore repository service.
• Supported Informatica upgrade process from 6.2.2 to 8.1.1 by validating regression testing results and providing all application details for upgrade consultant to perform application upgrade in Informatica.
• Written Teradata SQL queries to join or any modifications in the table.
• Written scripts to extract the data from Oracle and load into Teradata.
• Written Teradata BTEQ scripts to implement the business logic.
• Transfer of large volumes of data using Teradata FastLoad, MultiLoad and T-Pump.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD)
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: - Informatica PowerCenter 9.5 /9.1/9.0./8.6, Teradata, Repository Manager, Designer, Work Flow Manager, Oracle 11g/10g, SQL Server 2008/2005, DB2, Flat Files, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), UNIX, Toad

Confidential, Arlington, TX

Informatica Developer

Responsibilities:

• Designed, Developed and maintaining Socrates project end to end and got best performance, this application has high management visibility at confidential organization.
• Centre point of contact for multiple high visible projects with high complex business functionality.
• Worked on Informatica 9.1 Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Developed data maps to extract data from SAP using Informatica Power Exchange.
• Filtered Changed data using Power exchange CDC and loaded to the oracle target.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used UNIX scripts to access Teradata & Oracle Data.
• Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, IBM DB2, Oracle, and SQL Server and loaded into Oracle and Teradata DW.
• Worked on Teradata SQL Performance Tuning and optimization and Teradata Manager.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Designed and developed advanced reusable UNIX shell scripts for ETL auditing, error handling and automation.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Power Exchange to source copybook definition and then to row test the data from data files etc.
• Developed workflows for Informatica/Pentaho to accommodate the new email campaigns as per business requirement.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets & reusable transformations to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Involved in development of reports using pentaho.
• Developed advanced reusable mapplets for SCD and fact loading.
• Unit testing, code reviewing, moving in UAT and PROD.
• Handling Development and production support.

Environment: - Informatica Power Center / 9.5/9.0.1/8.6.1, Teradata, Power Exchange, Pentaho, PL/SQL, Oracle 10g/9i, Erwin, Control-M, SQL Server 2008, DB2, UNIX and V-SAM.

Confidential, San Diego CA

Informatica Consultant

Responsibilities:

• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading (ETL) Process
• Extract data from different Data marts for creating strategic Reports
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, Sequence Generator, Stored Procedure, Expression, Filter and Rank transformations
• Used Unix Shell script for Oracle to automate the server start and shutdown process
• Involved in creating various metadata types, including legacy source and data warehouse target data definitions and ETL jobs
• Implemented mapping forslowly changing dimensions(SCD) to maintain current data as well as historical data
• Createdreusable TransformationsandMappletsand used them in mappings in case of reuse of the transformations in different mappings
• Extensively used SQL overrides at Source Qualifier and Lookup Transformations while extracting data from multiple tables
• Created parameter files with workflows and sessions
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance
• Identified Bottlenecks and executed Performance tuning
• Tested the target data against source system tables by using test load

Environment: -InformaticaPower Center 8.6, TOAD, Erwin 4.1, Oracle 10g, Windows 2000, Unix

Confidential, Holtsville, NY

InformaticaDeveloper

Responsibilities:

• Assisted in the dimensional database design (Star schema). Reviewed multiple data source systems and recommended data acquisition and transformation strategy
• Using Informatica ETL tool created detailed mappings to load data from multiple source databases (SQL server, Oracle) and flat files to target Oracle Database. Implemented Aggregator, Joiner, Sorter, Router, Lookup, Update Strategy and Stored procedure transformations to optimize mappings.
• Responsible for data modeling using ERwinin 3.5.2
• Designed data warehouse and data marts from scratch and fine tuned existing data warehouses.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Created and monitored Sessions and Batch jobs to execute the mappings. Provided primary support for divisional DataMart applications.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed and recommended solutions within an Enterprise Data Warehousing environment
• Analyzed, designed, developed, deployed, and maintained the Multidimensional OLAP Cubes, drill-through targets for the Cubes, Impromptu Web Reports, PowerPlay Portable Reports and ReportNet Reports
• Created reports like Cross Tab, Stored Procedure, Invoices and many more reports in Impromptu.
• Created cubes and published cubes using PowerPlay Transformer and created explorer & reporter reports using PowerPlay
• Wrote stored procedures, functions. Occasionally Extracted data from other Oracle databases using Database Links.

Environment: Informatica Power center 9.0.1/8.1.1, SQL Server 2008/2005, Oracle 10g, Flat Files, XML Files, Windows 2008 R2, Data Integration Scheduler (DIS), Microsoft Visual studio 2008, Hp Quality centre.