SUMMARY

• Over 8 years of experience and expertise in analysis, design, development and implementation of Data Warehouses, Data Marts and Decision Support Systems (DSS) involving RDBMS like Oracle, Teradata, MS SQL server on Windows and UNIX platforms.
• Adept at combining business - driven objectives with technology, using the best practices, integrating solutions into corporate systems and deliver on time, creating strategic and tactical direction focused on realistic solutions.
• Expertly plan and coordinate detailed tasks within quality standards and established deadlines.
• Understand the business process and help turn technology into solutions that provide effective results.
• Interacting with clients and users to gather requirements.
• Experience in the Extraction, Transformation, and Loading of data from various sources into data warehouses and data marts using Informatica PowerCenter.
• Extensively used Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor, Data Integration Hub.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like Oracle, Flat files, XML and MS SQL Server into Oracle, XML and SQL server targets.
• Over 3+ years worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Developing mappings, reusable objects, transformations, and mapplets using Mapping Designer, Transformation Developer, and Mapplet Designer in Informatica PowerCenter 9.5.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, shortcuts, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Creating complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Union, Lookup, Joiner, XML Source Qualifier, and stored procedure transformations.
• Creating ETL mappings using Informatica PowerCenter to move data from multiple sources such as XML, DB2, Teradata, MS SQL Server, flat files, MS Excel and Oracle into a common target area such as data marts and data warehouse.
• Extensive Knowledge on the development life cycle process from requirements gathering to deployment of code to production and good knowledge on the Dimensional modeling.
• Implementing performance tuning methods to optimize developed mappings.
• Experienced in Erwin data modeling, Star-Schema design, Logical data modeling, Normalization, Physical design, Data Analysis, Data Modeling, Reports and Report Design.
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Experienced in various data sources like SQL Server, Fixed Width and Delimited Flat Files.
• Working Knowledge in Database Programming (Stored procedures, Triggers, Packages, PL/SQL) using SQL Server 2000.
• Experienced in leading and managing onsite/off shore team.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Data warehousing expertise.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Experience in Health, Retail, Investment Banking, Insurance and Manufacturing domains.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica PowerCenter 9.5/8.6/8.1/7.1/6.2

Programming: SQL, PL/SQL, HTML, C, C++, and Unix Confidential Scripting

Operating Systems: Unix, MS Windows.

Databases: Oracle 10g/9i/8.x, Teradata 13.x, MS SQL Server 2000, UDB DB2 8.x/9.x and MS Access 7.0/97/2000, MS Excel, SPSS.

Tools: Advanced Query Tool, Teradata SQLA, BTEQ, Fastload, Mload, Toad, SQL Navigator, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Addison, IL

ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases DataStage, Oracle, Db2 UDB, SQL Server and XML Files.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy
• Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked on PowerExchange bulk data movement processes by using PowerExchange Change Data Capture (CDC) method.
• Used PowerExchange connectivity for GreenPlum database.
• Designed Mappings using B2B Data Transformation Studio.
• Good knowledge in Unix Confidential scripting.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Employing the Informatica Data Quality (IDQ) and Master Data Management (MDM) to help identify data issues and implementing the cleansing procedures with existing interfaces/migrations.
• Written and used UNIX Confidential scripts extensively for scheduling and pre/post session management.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used SQL Loader to load huge flat files into Oracle database.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Worked with PowerCenter parameter file which is a list of parameters and variables and their associated values, includes information for multiple services, service processes, workflows, worklets, and sessions in a single parameter file.
• 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.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Extensive knowledge on Analysing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like water fall and agile methodologies.
• Developed a UNIX Confidential scripts which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Executed Informatica workflows using PMREP files and PMCMD utility thru UNIX scripts.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.
• Wrote SQL Queries as part of Data validation in the Target tables.

Environment: Informatica PowerCenter 9.5/8.x, Flat Files, DB2, Oracle 10g, Toad 9.1, SQL, PL/SQL, and Unix Confidential Scripting, MDM.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.
• Worked on various data sources such as Oracle, SQL and flat files.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, and 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.
• Created the Scripts to process the business logic from the Landing Zone to the Common Staging Area(CSA)
• Created the Email task notifications to notify the error messages and also used the command task to run the BTEQ scripts in the workflow monitor.
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Used utilities of FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Imported Metadata from Teradata tables.
• Created mapplets and reusable transformations.
• Designed and developed UNIX Scripts to automate the tasks.
• Conducting debugging sessions and fixing invalid mappings.
• Strong in UNIX Confidential and PERL scripting. Developed UNIX scripts using PMREP files and PMCMD utility and scheduled ETL load using utilities like CRON tab, Control-M.
• Creating sessions and batches to run with the logic embedded in the mappings using Informatica PowerCenter Workflow Manager
• Used the different types of transformations in Informatica such as Source Qualifier, Look up, Router, Joiner, Union, Aggregator etc.
• Done the Unit testing after successfully loading the data into Landing Zone (LZ) area.
• Wrote SQL Queries as part of Data validation in the Target tables.

Environment: Informatica PowerCenter 9.1/8.5, Oracle 10g, Flat Files, Toad, SQL, PL/SQL, Unix Scripting.

Confidential, Raleigh, NC

Informatica Developer

Responsibilities:

• Testing ETL workflows involving Informatica, Mainframe, Peoplesoft and Teradata.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ 8.6.1 application for matching and merging process.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Develop Informatica workflows, CCD, SQL scripts and jobs for End to End testing of ETL process.
• Data Mining Activities including data set up for the whole R6 Testing including SIT and UAT.
• Test environment set up by replicating Production databases in Test environment.
• Coding and Providing Automated test data sheets and graphical reports of Testing status.
• Coordination with the various business groups to gather requirements and translate into Test Plans for the ETL processes.
• Excel Reporting on various Testing artifacts by accessing the Quality center database.
• Leading the team for Test case creation and Execution effort.

Environment: Informatica Powercenter 8.5,JCL, DB2, Oracle, SQL server, Teradata SQL Assistant, Teradata utilities(BTEQ, Multiload, FastLoad), MS Excel with VB scripting, Quality Center, DB Visualizer, Securenet and Putty.

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Gathering requirements and creating technical specifications based on client functional specifications.
• Creating interfaces from existing global systems to the new JD Edwards enterprise one system and vice versa.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Experience with high volume datasets from various sources like Oracle, Text Files.
• Working with business units to identify mapping specifications.
• Created the ETL test plans and implemented the Code Review, Formal Testing, and Specification Testing using the Test Director.
• Implementing the standardized process to archive flat files and for loading indicator files
• Also used the Informatica Data Exchange to connect to the Main frames source and extract the data from GreenPlum database.
• Utilizing the MS Access database for the conversions that are (one time data conversions) for translations that are in Excel or CSV format
• Following a standard approach to create shortcuts for sources in the shared folder and targets in the shared folder, naming conventions, and abbreviations
• Creating mapplets and reusable transformations.
• Implementing the error handling strategy process for all interfaces to avoid errors during the live environment and migrated the objects from the Dev, QA to Production Environment.
• Used the Informatica B2B Transformation to integrate the semi structured data and transformed into Usable format.
• Implementing Data Steward Notifications by creating the mapping template that is used to provide the high level and low level notification errors of workflows.
• Responding quickly and effectively to production issues and taking responsibility for seeing those issues through resolution
• Creating E-Mail tasks to notify low level error messages and command tasks for archiving the data
• Performing code review, formal testing, optional testing, and specification review using Test Director
• Implementing performance tuning methods to optimize developed mappings

Environment: Informatica PowerCenter 7.1, DB2, Flat Files, PDF Files, XML, MS Access 2003, MS SQL Server 2005, Oracle 10g, Toad 3.2, SQL, PL/SQL, and Confidential Scripting.

Confidential, Houston, TX

ETL Developer

Responsibilities:

• Interacted with business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Developed Confidential scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Created complexity mappings using Aggregator, connected, unconnected and dynamic Lookup, Joiner and created reusable transformations and mapplets in the mappings.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Troubleshoot the issues by checking sessions and workflow logs.
• Conducting debugging sessions and fixing invalid mappings.
• Created the Data Flow Diagrams to check the dependency.
• Developed unit testing, systems testing and post-production verification.
• Involved in writing the test cases and documentation.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems. This led to better session performance.
• Participated in weekend reviews with team members and Business People.

Environment: Informatica Power Center 6.2, Oracle 10g, Oracle SQL * Loader, Flat Files, UNIX Confidential Scripting, TOAD.