SUMMARY

• Over 7 years of experience in Information Technology in Analysis, Design and Development of software applications. Expertise in development of Data warehousing solutions using Informatica Power Center 7.x /6.x /5.x and Power Mart 7.1.1 /6.2 / 5. x,Power connect.
• Expertise in Implementation of Enterprise Data warehouses using Informatica Power Center 7.1.1/6.2.1 / 5. x and Power Mart 7.1.1/6.2.1 / 5. x, and Decision Stream
• Extensively worked on overall SDLC implementation that includes requirement gathering, development, testing, debugging and deployment as well as Documentation, Production Support.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER - Studio.
• Extensive Knowledge on the development life cycle process from requirements gathering to deployment ofcodeto production and good knowledge on the Dimensional modeling.
• Troubleshooting and problem solving applications withInformaticaDebugger and performingcodemigration from Dev to Test.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in UNIX Shell Scripting, windows batch scripting for applying data fixes and automation of ETL jobs.
• Experience working with advanced transformations like Java transformation, Web services transformation, Normalizer, xml sources and targets.
• Good knowledge in Power exchange for salesforce and loading data into salesforce environments through Informatica using BULK API.
• Good knowledge in Informatica cloud for performing Data synchronization, replications and transferring binary files across environments.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x. Informatica Power Exchange, Informatica Power Mart, Informatica Data Quality, Informatica cloud.

Data Bases: Teradata V2R6/12, Sybase 12.5, DB2 8.2, Oracle 11i/10g/9i/8i, SQL Server 2005/2000, MS-Access

Database Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

Programing Tools: C,C++, Java, SQL, PL/SQL, T-SQL, Shell scripting, Perl

Web Technologies: HTML, CSS, XML

Other tools: MS-Word, Excel, PowerPoint 2003/2007.

Operating System: Unix, Windows 95/98/NT/2000/XP/7/8

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles - CA

Sr Informatica/Report Developer

Responsibilities:

• Design and Development of ETL routines, using Informatica Power Center 9.5.1 Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, connected and unconnected Lookups, and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done also designed and reported using power connect informatica from external systems like SAP,DB2.
• Gathered requirements from Business users and created a Low level technical design documents using high level design document.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Involved in the preparation of High level design documents and Low level design documents.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Using Ralph Kimball approach individual data marts were developed to provide 360 degree views into organizational data
• Developing ETL mappings and workflows to implement the business logics for standardizing the data.
• Involved in developing PL/SQL procedures and Shell scripts.
• Performingcodereview, formal testing, optional testing, and specification review using Test Director.
• Performing unit testing, Integration testing and quality checks.
• Responsible for the documentations of the different processes carried out like design documents and mapping documents, share point for the version control of the documents and star team for the version control of sourcecodefor all the interfaces in the Interface Project.
• Documented Design Documents and Unit Test plans for Informatica mappings, design and validation rules.
• Documenting mappings, sessions, workflows and procedure related information.
• Involved in performance tuning by following best practices.
• Providing Knowledge share to production teams on new developments (workflows/jobs).

Environment: Informatica Power Center 9.1,Oracle 9i, SQL, PL/SQL, SQL*Plus, Sybase, XML files, Sun Solaris 5.8, Windows NT/2000, TOAD 7.0, PL/SQL Developer, Crystal Reports XI, MS Excel, Import Wizard, Central Management Console, Info View, True Task Scheduler, SQL Server Management Studio, SQL server 2008R2, Infohub,HTML, JavaScript.

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Worked with Data Architects and Business Analysts to understand the data flow, existing logic and creation of Business Requirement Documents on the business logic involved in creation of feeds.
• Performed multiple roles such as building extensible, robust, maintainable systems participating in all stages of Software development life cycle using Agile Scrum/ Kanban.
• Created technical specification for the development of Informatica extraction, transformation and loading (ETL) mappings in order to load data into classified tables in DATA Marts and defined ETL standards.
• Optimized mappings, sessions/tasks, source, and target databases as a part of performance tuning.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Engaged in designing and developing test cases, error control routines, data validation, load processes, audit and log controls using PL/SQL, SQL.
• Worked extensively on Source Analyzer, Mapping designer, Warehouse Designer.
• Schedule, Run and monitor sessions by using Informatica Server Manager.
• Configured and used secured FTP by the Informatica Server to access source and target files.
• Developing ETL mappings and workflows to implement the business logics for standardizing the data.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively to migrate thecodefrom dev to production and compared bothcodes.
• Created, launched & scheduled sessions. Involved in the Performance Tuning of Database and Informatica.
• Migration ofcodebetween the Environments and maintaining thecodebackups.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from Oracle, MS SQL Server 7.0.
• Involved in developing PL/SQL procedures and Shell scripts
• Performing unit testing, Integration testing and quality checks.
• Involved in communications with client and Business analysts for gathering requirements.
• Involved in performance tuning by following best practices.
• Worked with production support in finalizing scheduling of workflows and database scripts using Tidal Scheduler.

Environment: Informatica5.2/6.2, ORACLE 8i/9i, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, Business Objects 4.7, TOAD Quest Software, Business Objects XI R3.1/RI 2.0, Web Intelligence, Cognos, Designer, Business View Manager, Desktop Intelligence Crystal Reports, Xcelsius 2008, MS Excel, Live Office, Import Wizard, Central Management Console, Info View, Neoview, ORACLE 10g

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica PowerCenter 6.2 / 7.1.1.
• Extracted source data from flat files, XML, Teradata, Oracleand loaded to a relational warehouse.
• Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Created Cronjobs and Maestro scripts for automation of ETL processes.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: InformaticaPowerCenter, Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9iDB2 6.1, Erwin, TOAD,Unix- SunOS, PL/SQL,SQL Developer

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Interacted with Business Analysts to translate Business requirements into technical specifications.
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center 6.2.
• Extracted source data from Sybase, flat files, XML, Teradata, oracle, IMS and VSAM and loaded to a relational warehouse.
• Implemented SCD methodology including Type 1, Type 2 and Type 3 changes to keep track of historical data.
• Involved in creations of transaction level snapshots, periodic snapshots and Accumulated Snapshots.
• Implemented Aggregate, Sorter, Router, Filter, Joiner, Expression, Lookup and Update Strategy, Normalizer, Sequence generator transformations.
• Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used the Workflow manager to create workflows, worklets and tasks.
• Implemented pipeline partioning concepts like hash-key, round robin, key-range, pass-through techniques in mapping transformations.
• Created UNIX shell scripting and automation of ETL processes using Crontab.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used pmcmd, pmrepagent and pmrepserver in non-windows environment.
• Used debugger to test the mapping and fixed the bugs.
• Worked closely with DBA in performance tuning of queries using ANALYZE Tables and SQL Trace.
• Documented Informatica mappings, design and validation rules.
• Involved in design of logical and physical data models using ERWin.
• Generated simple list reports, Grouped list, cross tab, grouped cross tab reports using CognosImpromtu and Power Play.
• Created Multi-Dimensional cubes using Power Play Transformer.

Environment: Informatica Power Center 6.2, Cognos Impromptu 7.2, Power Play, Transformer, Oracle 8i, MS SQL Server 2000, Sybase, Teradata V2R4, XML, IMS, VSAM, SQL Plus, PL/SQL, MS Visio 2002, Toad 7.0, SCO Unix 5.0.5, Windows 2000.

Confidential

Data Warehouse Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Involved in System Analysis and worked on Design, Coding and implementation.
• Written many routines (as functions), which were called from other procedures.
• Developed user interface screens, master detail relations and Reporting screens.
• Developed various Reports for the end users as per their requirements and created many report to suit preprinted format of the company.
• Designed and developed different reports and forms.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.

Environment: Informatica Power Center 7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL