SUMMARY

• 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
• 6+ Years of strong Data Warehousing ETL experience of using Informatica Power Center 8.6/8.5/8.1/7.1/7.0/6.2 Informatica Power Mart 6.2/5.1.2/5.0/4.7 (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Manager), Power Connect, Power Analyzer, Power Exchange MS SQL Server 2000 Analysis Services, IDQ(Informatica Data Quality), IDE(Informatica Data Explorer), Informatica Real time Suite, Metadata Manager, OLAP,OLTP, Autosys 4.5, Control M,TWS(Tivoli Workload Scheduler), Maestro, OLAP, OLTP, MOLAP, ROLAP, ETL, ETI, Data marts, Data mining.
• 4+ years of Dimensional Data Modeling experience using Data modeling, Erwin Modeling (ERwin 4.5/4.0, Oracle Designer) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling and. Hands on experience in Star and Snowflake schema design in relational, dimensional and multidimensional modeling and De - normalization techniques. Thorough understanding of Kimball and Inmon methodologies.
• 7+ years of Database experience using Oracle 11i/10g/9i/8i/7i, Sybase, IBM DB2 UDB 8.0/7.0, MS SQL Server 2000,2005,2008, MS Access 2000/2007, Oracle Report Writer, flat files, IMS Data, XSD files, XML files, COBOL files, Netezza, Teradata (BTEQ, Fast-Load, Multi-Load, Fast Export), SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Windows 3.x/95/98/2000, Win NT 4.0 and Unix, AIX, Sun Solaris 2.x. Proficient in working with PL/SQL to write stored procedures, packages, and triggers. Worked with testing team to create test cases for unit and integration testing. Expertise in WinSQL, TOAD (Tool for Oracle Application Developers)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Upgraded Informatica Power Center Repository from 6.2 to 7.1.1
• Upgraded Informatica v7.1.3 to v8.6.1 applying hot fix patches.
• Expertise in User Acceptance Testing Consultation with SME’s.
• Extracted data from ERP source systems using SAP power connect.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical, Analytical, Communication and Organizational Skills.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Efficient team player with excellent communication skills and good interaction with users.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6/8.5/8.1/7.1.3/6.2 , Informatica Power Mart 6.2/5.1.2/5.0/4.7 (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplets, Transformations, Work flow Manager, Task Manager), Power Connect, Power Analyzer, MS SQL Server 2000 Analysis Services, Mappings, Mapplets, Transformations, OLAP, IDQ(Informatica Data Quality), IDE(Informatica Data Explorer),Informatica Real time suite, Metadata Manager, Autosys, Control M, TWS(Tivoli Workload Scheduler), Data Stage, Maestro, OLAP, OLTP, MOLAP, ROLAP, ETL, ETI, Data marts, Data mining, Data Cleansing, Data Profiling.

Data Modeling: Dimensional Data Modeling, Erwin Modeling (ERwin 4.5/4.0, Oracle Designer) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling, Star & Snowflake schema Relational, dimensional and multidimensional modeling and De-normalization techniques, Kimball & Inmon Methodologies.

Business Intelligence Tools/Utilities: Siebel Analytics/OBIEE, Business Objects XI/ 6.5/6.0/5.1/4.1 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Report Net 1.1, MS Access Reports, SQL, PL/SQL, SQL*Loader, TOAD 7.x/8.x/9.x, Win SQL, SQL Navigator, Ultra Edit 32, Winscp, Harvest, MS Project 2000, Visio, MS Source Safe, Brio 6.2, ERP, Win runner, Load Runner, Test Director.

Databases: Oracle 11i/10g/9i/8i/7i, Sybase, IBM DB2 UDB 8.0/7.0, MS SQL Server 6.5/7.0.2000 , MS Access 7.0/2000, Oracle Report Writer, flat files, XSD files, XML files, COBOL files, Netezza, Teradata (BTEQ, Fast-Load, Multi-Load, Fast Export)

Languages/Web: PL/SQL, SQL*Plus, HTML, ASP, Java, Perl, Shell Scripting and MS-Excel, Power Builder, XML, XSLT, HTML, Unix Korn Shell Scripting

GUI: Developer 2000, Forms 6i, Reports 6i, Visual Basic 6.0/5.0/4.0/3.0 , FrontPage 97/98/2000

Servers: Oracle 9iAS, BEA Web Logic 5/6.

Environment: HPUX 10:20/11, AIX 4.5, Solaris 2.x, UNIX SVR 4.0, Linux, SCO UNIX, MS Windows, Windows NT. Red Hat Linux 7.2, SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Senior ETL Informatica Developer

Responsibilities:

• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Created repository services and repository contents. Restored the repository contents from the backups using Admin console.
• Extensive experience working with repository manager.
• Was responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders etc.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Responsible for creating repository folders and giving access to the users.
• Played a role of Informatica Architect, Developer & Administrator.
• Upgraded Informatica power center 8.1 to version 8.6 on servers.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Extracted data from various sources to targets like DB2, Flat files, Oracle, Teradata; Transformed and Loaded the data in to target database using Informatica Power Center.
• Database upgrade from 9i (9.2.0.6) to 10g.
• Cleansing data using Trillium, RTRIM and LTRIM.
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Worked on SQL server integration services, analytical services and reporting services.
• Configured High Availability Domain that uses one Primary node and two backup nodes (servers). Also configured a Primary and backup Repository database.
• Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
• Managed the privileges of users and folders using Repository Manager and used Informatica Administration Console for Admin activities such as starting / stopping server, upgrading the repository etc.
• Created target definition in oracle which was the target database.
• Responsible for maintaining repository backups and their restorations.
• Implemented lookups and different transformations in the mappings.
• Created ODBC connection for importing the source and target definitions.
• Developed unit test cases and did unit testing for all the developed mappings.
• Developed Unix Shell scripts and Perl Scripts to Migrate data from different legacy systems in databases.
• Provided production support by monitoring the processes running daily.
• Worked closely with reporting team and helped them whenever they had any ETL issues.

Environment: Informatica Power Center 8.6.1, Teradata, Oracle 10g, Erwin 4.5, Business Objects xi, TOAD 8.6.1, SSIS, Transact-SQL, DTS, DB2, UNIX AIX 5L version 5.1, Autosys, Windows XP Professional, Transact-SQL, UNIX AIX4.2, Windows XP/2000.

Confidential, Charlotte, NC

Senior ETL Informatica Developer

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Informatica Power Center was used to extract, transform and load data from different operational data sources like Oracle, SQL server, DB2, Flat files in to Data staging area (Oracle).
• Worked with Financial end users to gather the Functional Specifications.
• Involved in analyzing existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse.
• Partitioned tables which have frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• Maintained development, test and production repositories using repository manager. Also used Repository manager and Metadata Manager to maintain the metadata, Security, Backup and Locks.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Extensively used Transformations like Router, Lookup (connected and unconnected), Update Strategy, Source Qualifier, Joiner, Expression, Stored Procedures, Aggregator and Sequence generator Transformations.
• Worked on IDQ file configuration Confidential user’s machines and resolved the issues.
• Worked extensively with dynamic cache with the connected lookup Transformations.
• Designed and optimized the Mapping to load the data in slowly changing dimensions.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Worked with other teams on Facets Data model design and Facets batch processing.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Teradata Utilities BTEQ, FastLoad, Confidential -pump, Multi Load utilities for loading bulk data.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Developed batch Scripts to execute OWB (Oracle Warehouse Builder) sessions to automate, using PMCMD utility.
• Designed and created Oracle Database objects, tables, Indices, Views, Procedures, Packages, and Functions.
• Configured the session so that Power Center Server sends an Email when the session completes or fails.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Determined various bottle necks and successfully eliminated them to great extent.
• Extensively worked in the performance tuning of the programs, PL/SQL Procedures and processes.
• Provided production support by monitoring the processes running daily.
• Wrote and modified Korn Shell scripts to handle dependencies between workflows and log the failure information.
• Scheduling and monitoring automated daily and weekly jobs in Maestro.
• Developed UNIX Korn shell scripts to execute workflows sequentially.
• Involved in performing (UAT) Unit testing and Integration testing.

Environment: Informatica Power Center 7.1,PL/SQL, Teradata, Unix Korn Shell Scripting, Business Objects, Crystal Reports, Maestro 4.0, Toad, Trillium, IDQ, Oracle 10g/9i, DB2-UDB, SQL Server 2000, SSIS, XML, Unix AIX 5.2, Windows XP.

Confidential, Jersey City, New Jersey

ETL Consultant

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner, Normalizer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Consumed a Web Service to retrieve user credentials from an LDAP server.
• Used .Net Data Access application blocks for optimized data access and reusable code.
• Setting up Batches and sessions to schedule the loads Confidential required frequency using Power Center Workflow manager.
• Implemented recovery solutions by writing stored procedures and cursors using Sybase SQL to undo mistakes made by traders.
• Created sessions, database connections and batches using Informatica Workflow Manager. Developed mappings to load data in slowly changing dimension.
• Created mappings/workflows to extract data from SQL Server, Sybase and Flat File sources and load into various Business Entities and Transaction Data Sets for Automatic Position Reporting.
• Used Primary and Secondary indeces in Teradata to improve the performance of the load process.
• Created complex SQL, PL/SQL, stored procedures, functions.
• Insured that all enterprise procedures are followed such as system testing, change management, project prioritization, promotion to production, time entry, etc
• Draft, institute and continually refine required processes. Actively participated in user acceptance and sign-off process. Worked effectively with assigned project managers.
• Participated in the review and maintenance of data security standards to protect information assets.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Involved in designing Business Objects Universes, Queries, and Reports.

Environment: Informatica Power Center 7.1, Teradata, Oracle 8i/9i, MS SQL Server 2005/2000, SSIS, DB2, Business Objects, XML, Web Services, Sun Solaris 2.6 and Windows NT

Confidential, Columbus, OH

ETL / Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Extracted, transformed data from various sources such as Oracle, Flat files, MS SQL Server, COBOL, and loaded into the target data warehouse Oracle.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Created mappings with heterogeneous sources like flat files, DB2, Oracle databases and created targets in Oracle using Informatica Mapping Designer 7.1.4 .
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Created Stored Procedure, Functions and Triggers as per the business requirements.
• Developed Shell Scripts and SQL Queries.
• Used SQL * Loader for bulk loading.
• Scheduled jobs using Control - M scheduler.
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading.

Environment: Informatica Power Center 6.x, Oracle, Flat file, SQL Server 2000, SSIS, COBOL, SQL* Loader, PL/SQL, Control - M, DTS Packages, UNIX, Windows 2000.

Confidential

Developer-Solution/Production Development

Responsibilities:

• Actively involved in gathering requirements from Business Users, and converting them into system requirement specifications and creating detailed use-cases and design documents
• Designed, developed, and managed the workflow processes to reflect business requirements with several adapters, exceptions and rules
• Was involved in data modeling. Designed data flows using UML.
• Designed and developed User Group Management modules to implement complex business rules for permissions.
• Coordinated in setting up the development, test, production and contingency environment
• Designed, developed, managed database star schema, with various hierarchical and lookup tables
• Developed and maintained complex stored procedures
• Involved in setting up of application server clustered environment
• Underwent training in Standard Software Process in implementing CMM level 5 in an enterprise organization

Environment: Oracle 8i, Shell Scripts, UML, Test Director, SunOS

Confidential

Oracle Developer

Responsibilities:

• Developed Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
• Designed the user interface screens using Oracle Forms 4.5 and generated reports using D2K reports 2.5.
• Developed Program Libraries for storing of Procedures that were used frequently in the System and user security package, integration and user acceptance testing.
• Prepared technical documentation and user specifications.
• Involved in creation of Schema Objects like indexes views, and stored procedures. Involved in the Analysis of how the purchase order process is organized.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Identifying integrity constraints for tables.
• Involved in writing the Triggers which internally calls procedures and functions.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire process.
• Involved in Implementation and Testing phases of the system.

Environment: Windows 98, UNIX, Oracle 7.x, PL/SQL, SQL *Plus Reporting, SQL *Loader, Forms & Reports, LINUX