SUMMARY

• About 8 Years of experience in Analysis, Development and Maintenance of Business Intelligence solutions using Informatica PowerCenter 9.6/9.5/9.1,/8.6,8.1 and Informatica PowerExchange 9.6/9.5/9.1.
• Developed various mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.
• 4+ Years experience working on Teradata version 13/14.
• Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, power exchange, Workflow and Worklet Designer.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Worked with Oracle, PL/SQL Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization.
• Extensively used tools ofMLoad, BTeq, Fast ExportandFast Loadto design and develop dataflow paths for loading transforming and maintaining datawarehouse.
• Good Understanding of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake and Operational Data store (ODS).
• The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.
• Over 2 years in Sybase Database Administration, Support of which 2 years in Database Development and 1 year are in Database Administration of huge databases on Sybase ASE on SUN, MS-SQL Server on Windows NT in multiple locations. Supported multiple server and database on 24 X 7 environments. Responding to users and developer issues.
• Experience on Create, update and maintain project documents including business requirements, functional and non-functional requirements, functional design, data mapping.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes.
• Ensure smooth transition of work to offshore team. Transfer ETL requirements and ensure timely completion of deliverables with offshore.
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the new Telematics capabilities.
• Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions.
• Strong working experience with Scheduling tools like Maestro, Autosys.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Experience with industry Software development methodologies like Waterfall, Agile within the software development life cycle.
• Good understanding of Business Intelligence tools like Business Objects, Cognos.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6/9.5/9.1/8.6/8.5 , Informaitca PowerExchange 9.6/9.5/9.1, IDQ 9.5/9.1

Business intelligence: OBIEE 11g,QlikView 9

Databases: Oracle 11g/10g, SQL*Plus, SQL*Loader, DB2 UDB 8.1/7.0, MS SQL Server 2008, Teradata 14/13, Sybase, MS Access 7.0/2000.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7

Tools: Toad, PL/SQL, Dbvisualizer, BTEQ, Microsoft Visio, Autosys, Tivoli Work Scheduler, Putty

Languages: SQL, PL/SQL, UNIX Shell Scripting, pearl, C, Visual Basic, XML.

Operating Systems: Windows NT/2000/2003, UNIX(AIX, Sun Solaris)

Protocols: HTTP, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements. Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
• Architected and developedFast LoadandMLoadscripts in control file,developedBTEQ scriptsto process the data in staging server.
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, tablespaces, tables using Datapump (11g) as well as traditional export/import. Knowledge of Cold/Hot backups and RMAN backups.
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.
• Created Cognos Impromptu reports utilizing existing Oracle views and tables.

Environment: -: Informatica PowerCenter 9.6.1, Informatica PowerExchange9.6.1, BTEQ, PL/SQL, Oracle 11g, UNIX Shell Scripting, Cognos, Sybase, Teradata 14, DB2, OBIEE, CDC, LINUX(Sun Solaris), Tivoli Work Schedular.

Confidential, KS

Informatica Developer

Responsibilities:

• Created detailed Technical design documents for BDW SQL extracts and shell scripts.
• Created detailed ETL technical design documents
• Used BTEQ andSQL Assistant(Query man) front-endtools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Responsible for design and development of the Oracle and DB2 structured query language (SQL) Extracts and UNIX shell scripts, Common functions and utilities.
• Review and understand the ETL processes, functionality & identify test requirements and coverage
• Involved in tuning performance of ETL mappings and SQL extracts and unit test related changes.
• Involved in Analyzing & Debugging, Sorting out time-to-time technical problems
• Involved in gap and impact analysis.
• Involved in Fine-tuning SQL overrides for performance Enhancements.
• Assisting in QAT and UAT in preparing and executing Test cases.
• Responsible for scheduling production jobs using scheduling tool autosys.
• Responsible to support data integration projects code promotion process and post implementation support.
• Responsible to set up NDM connections and configurations between various wells Fargo applications for receiving and sending files.
• Responsible to work with wells Fargo data transmission services (DTS) to set up net work configurations such as user file and net map between internal and external customers for inbound and outbound file deliveries.
• Responsible to work with various customers for indentifying file format, Type and File transfer protocol methods such as NDM (Connect direct: Secure plus), FTP, SFTP, and Copy.
• Managing Project documents in SharePoint site.
• Supporting BDW, ODS and CFD production batch.
• Involved in analyzing merchant data warehouse exception process and business needs.
• Involved in wring various merchant data warehouse exception process rules.
• Involved in debugging and changing existing exception process rules.
• Involved in daily manual merchant data warehouse exception process.
• Involved in supporting merchant data warehouse exception process batch cycle.
• Involved in translate functional specifications into technical specifications.
• Coordinated offshore and onsite team with a total of 7 ETL developers
• Prepared a production monitoring and support handbook for ETL Process.
• Involved in design and development of Reporting System using Business Objects

Environment: Informatica PowerCenter 9.1/8.6, Informatica PowerExchange 9.1, DB2, SQL, UNIX Shell scripting, Teradata13, Auto Sys Job Scheduler, Harvest version control system, Anthill Pro, UNIX, Oracle, Toad.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.
• Involved in the SDLC process beginning with the design of dimensional modeling in buildingthe data warehouse
• Worked with Data Architects during Design Stages.
• Created design specification documents and developed functional and technical specification documents.
• Extracted data from oracle, flat file and xml sources.
• Used BTEQ andSQL Assistant(Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into the dimension, facts, and lookup tables simultaneously from different source systems.
• Created scripts for automating table partitions.
• Created a global repository, groups, users and assigned privileges using repository manager
• Implemented rolling window method for deleting the old data.
• Created sessions and workflows.
• Worked with email, command tasks, Mapplets, Reusable Transformations and worklets.
• Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Involved in performance tuning of the sessions.
• Extensively used PL/SQL for database related functionality.
• Used Pmcmd commands to run the Informatica mappings using Unix Scripts.
• Used Crontab for scheduling.
• Created UNIX Scripts for creating the indexes, altering the default table spaces and analyzing the tables.
• Created UNIX shell scripts for data cleaning.
• Involved in unit testing and documentation of the ETL process.
• Involved in creating the run book and migration document from development to production.
• Involved in Data warehouse month end loads and support activities.
• Prepared a production monitoring and support handbook for ETL Process.
• Coordinated offshore and onsite team with a total of 7 ETL developers
• Involved in design and development of Reporting System using Business Objects.

Environment: -:Informatica PowerCenter 8.6,Oracle 10g, PL/SQL, BTEQ, TOAD, Windows NT, Unix Shell Scripting, ERWIN 4.0,SQL loader, OBIEE 10g,LINUX,UNIX.

Confidential, St. Louis, MO

Informatica Developer

Responsibilities:

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Developed Technical Specifications of the ETL process flow
• Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.
• Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy
• Worked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Using Informatica Repository Manager maintained all the repositories of various applications, created users, user groups, and security access control.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Created Stored Procedures for Audit and Error Balancing.
• Used Crontab for scheduling.
• Validated Data to Maintain Referential Integrity.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Worked on back end programming such as PL/SQL procedures, functions and packages.
• Prepared a production monitoring and support handbook for ETL Process.
• Coordinated offshore and onsite team with a total of 7 ETL developers
• Involved in design and development of Reporting System using Business Objects.

Environment: -:Informatica PowerCenter 8.6, Oracle 10g, DB 2 8.1.6/8.2.0 , UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, T-SQL, SQL*Loader, BCP, TOAD Quest Software.

Confidential

Jr Informatica Developer

Responsibilities:

• Analysed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow
• Designed and developed Informatica mappings, workflows to load data into Oracle ODS.
• Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.
• Extensively used Informatica to load data from Oracle, XML and Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Used debugger to test the mapping and fixed the bugs.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Scheduled and executed batch and session jobs on Autosys.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined.
• Involved in developing reports using Business Objects.

Environment: -:Informatica PowerCenter 8.1, Oracle 10g, PL/SQL, Business Objects XI R1, Crystal Report, Windows NT, HPUX 10.20, Erwin 3.5.2, Autosys.