SUMMARY:

• 5+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• 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.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• 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.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• 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.
• 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.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• 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 all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Worked on Agile Development methodology.
• Good Troubleshooting and debugging experience on production issues
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Operating Systems: HP-UX v11.x/10.x, IBM AIX 5.x, Windows 2000/NT 4.0/98/95.

Databases: Teradata v2r6, Teradata v2r12, Oracle 11g,10g, 9i/8i/8.0/7.x, MS SQL Server 7.0/2000, DB2 UDB v9.7/9/.1/7.1.

Languages: PL/SQL, UNIX Shell Scripting(Korn, perl), C, Java.

GUI Tools: Oracle Forms 4.5, Oracle Reports 2.5, Visual Basic 6.0

PROFESSIONAL EXPERIENCE

Confidential, Mcclean,VA

Informatica Developer

Responsibilities:

• Worked on Dimensional modeling to design and developStarSchemas, identified Fact and Dimension Tables.
• Identified and tracked theSlowly changing dimensions, heterogeneoussourcesand determined the hierarchies in dimensions.
• Createdusers, Groupsand assigned users to groups and grantedprivileges and permissionsto groupsandFolders.
• Extensively usedTransformationslike Router Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation, Aggregator Transformations and Sequence generator Transformations.
• Used workflow manager forsession management, database connection management and schedulingof jobs to be run in the batch process.
• Designed and developed transformations, mappings and sessions in Informatica to load target database and tuned mappings for improving performance.
• Managed requirements completely, upgraded internal processes and methodologies to deliver faster results using Agile Development methodology.
• Tuned performance of Informatica sessions for large data files by increasingblock size, data cache size, sequence buffer length and target based commit interval.
• DevelopedShell Scripts, PL/SQL procedures, table and Index creation scripts.
• CreatedPipeline partitioningto improve Session performance.
• Created andScheduled sessions & Batchesusing workflow Manager to load the data into the Target Database.
• Involved in massivedata cleansingof the production data load.
• Scheduled Sessions and Batch Processesbased on demand, run on time, run only once using Informatica Server Manager.
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Responsible totune ETLprocedures andstar schemastooptimizeload andquery Performance.
• Worked withdifferent Sources such as Oracle, SQL Server, Excel, FlatandCOBOL files. Used Informatica to extract data into Data Warehouse.
• Designed and developeduniverses and reportsaccording to the user requirements.
• Developedcomplex reportsthat involved multiple data providers, master/detail charts, complex variables and calculation contexts.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.
• PerformedUnit testing and System integration testing.

Environment: Informatica Power center 9.1, Business Objects 6.5, DB2 7.2 UDB, SQL Server, SQL* Plus, PL/SQL, Oracle 11i, Teradata, WindowsNT/2000, UNIX

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment:Informatica 8.6 .1,Oracle 11g, SQL Server 2005, HP-UX.

Confidential

Informatica Developer

Responsibilities:

• Involved in requirement gathering, analysis and designing technical specifications for the data migration according to the Business requirement
• .Developed complex mappings and SCD type-I, Type-II and Type III mappings into load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank, Router and SQL transformations. Created complex mapplets for reusable purposes.
• Involved in optimization and performance tuning ofobjects and Database objects to achieve better performance.
• Created Mapplets with the help of Mapplet Designer and using these Mapplets in various mappings Troubleshooted connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Coordinated with the Quality Assurance team for component, unit and integration test environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• .Performed Unit and Integration testing and wrote test cases.
• Worked extensively in defect remediation and supported the QA testing.

Environment: Informatica Power Center 7.1, Power Exchange, Oracle 9i, SQL Server, Solaris 2.7, Control-M