PROFILE:

• 9+ Years of Total IT Experience
• 9 Years of DW (ETL) Informatica
• 7+ Years of Oracle
• 6 Years of SQL Server

SUMMARY:

• 9+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
• 9 Years of strong Data Warehousing ETL experience of using Informatica Power Center 10.2/9.5/8.6/8.5/8.1/7.1/, 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.
• 3 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 11g/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, 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)
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Installation of Hot fixes, Service Packs, or EBFs provided by Informatica.
• Expertise in User Acceptance Testing Consultation with SME’s.
• Extracted data from ERP source systems using SAP power connect.
• 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.

SKILLS SUMMARY:

Data Warehousing: Informatica power Center 10.2/9.5/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: Siebel Analytics/OBIEE, SSIS, SSRS, 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 11g/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, Washington, DC/Baltimore

Senior ETL Developer

Responsibilities:

• Worked on Developing the code for Confidential Business Intelligence Warehouse (CBIW) project for multiple streams such as Claims, Benefits, Member, Group data using Informatica, Oracle and Unix server to load the data into CBI Warehouse from different source systems.
• Design and Develop ETL processes using Informatica PowerCenter and Informatica Developer tools.
• Develop and support Informatica Power Exchange mapping to capture data in real-time into Data Warehouse systems.
• Worked on developing several mappings using various transformations according to the source to target mapping and business specifications.
• Created the reusable and non-reusable sessions for all the mappings developed and created workflows.
• Create mainframe JCLs in CA7 and schedule the jobs through Mainframe JCL to run the workflows according to business requirements for all daily, weekly and monthly jobs.
• Created ZMF packages in mainframes to deploy the JCL jobs to production
• Worked on performance tuning the code by implementing the partitions at the informatica source and target level based on different source system codes and Performance tune SQL queries to improve the performance and reduced the load time.
• Worked on implementing the persistent cache for the lookups to reuse the data and improve performance.
• Worked on masking the PHI data in test environments if any production data is loaded or copied over to test environments for any defect fixes and test validations.
• Worked on fixing the defects for the incremental daily loads and provide the test data to validate for business consumers and migrating the code to production.
• Worked on performing the scrubs for the historical data for all the defects fixed in production and automate the historical update for all the tables accordingly.
• Responsible for all the claims data applications and work with business consumers and external vendors on new requirements and making the code changes accordingly and fixing the historical data.
• Worked on developing the shell scripts to validate the fixed length of Cobol and other source files before starting of the load and fail the jobs if mismatch occurs and follow up with vendors to get the files in correct format.
• Worked with state of Maryland business consumers to generate the weekly claims reports according to the requirements and work on ad-hoc requests to generate historical reports.
• Created the audit and logical balancing process to validate the counts in source and target and generate the reports and work on analyzing the issue if any mismatch occurs and inform the business and fix the issues.
• Monitor the ADT (Admit Discharge Transfer) data that is sent from the vendor using Tibco Business connect and verify the data is loaded into ODS and notify the vendor if any messages not loaded because of data issues and turn off the feed in case of Tibco downtime or maintenance.
• Worked as the main SME for the Benefit Detailed Data Store (BDDS) project. In this capacity worked with the benefits business team to load new benefits details into the data store. In addition, responsible for fixing any errors that may arise in the process.
• Responsible for data profiling benefits data as part of the Enterprise Benefits Solution (EBS) project. In this role runs database queries to compare the data in EBS against expected values and works with the business to remediate any discrepancies.
• Perform legacy system analysis, Source to target mapping, data extraction, transfer and loading. Coordinate Unit, Integration, System, User Acceptance and Performance testing at various stages of the project life cycle using HP ALM.

Environment: Informatica PowerCenter 10.2/9.5, Informatica Developer, Informatica BDM, HadoopOracle 11g, SQL Server 2008R2/2012, Unix, Mainframes, Reflection FTP, SQL Developer, HP Quality Center, Tortoise Subversion, TIBCO Business connect 6.0, Tibco Business Works 5.7, Windows.

Confidential, Sacramento, CA

Senior ETL Informatica Developer

Responsibilities:

• Involved in Analysis and documenting Technical specifications.
• Developed several mappings to load data from different source systems into Enterprise warehouse.
• Extensively used Transformations like Router, Filter, Lookup, Update Strategy, Source Qualifier, Joiner, Expression, Stored Procedures, Aggregator and Sequence generator Transformations.
• 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.
• Involved in design and loading of hash current tables to capture change records (Determine insert else update)
• Created all reusable sessions for all the mappings developed.
• Worked on batch files which are used to copy source files, validate manifest process, clean the source folders and prepare multiple files to start the load.
• Developed mappings to create and update parameter files with updated parameter values before starting the load.
• Created, scheduled, and monitored workflow sessions based on execute on demand, scheduled on time, using Informatica Power Center workflow manager.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Worked on creating the packages using SSIS tool to load the data in Audit, Stage, Base and Dale.
• Worked on providing solution to defects logged in Test Director.
• Identified bottle necks in the existing processes and successfully eliminated issues to great extent.

Environment: Informatica PowerCenter 8.6.1, SQL Server 2005/2008 R2, SSIS (Integration Services), Windows.

Confidential, Carlsbad, CA

Senior ETL Informatica Developer

Responsibilities:

• Involved in gathering requirements from Business and converted them it into Technical documents.
• Extensively worked on Informatica Designer, Workflow Manager, Workflow Monitor
• Worked on Source Analyzer, Warehouse designer, Mapping Designer & Mapplet Designer
• Involved in extracting data from ERPs like SAP, ENTERPRISE 1 (Oracle) into EDW (Oracle 10g) and developed Transformation logic using Informatica.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Created ETL mappings and mapplets to extract data from ERPs like SAP, ENTERPRISE 1 (Oracle) and load into EDW (Oracle 10g)
• Knowledge of various transformations like Source Qualifier, Lookups, Expression Editor, Update Strategy, Filter, Router, Joiner and Sequence generator.
• Used the Aggregator transformation to load the summarized data for Sales and Finance departments.
• Knowledge of connected and unconnected lookups
• Developed Error handling process incase Fact record gets submitted without corresponding dimension record
• Created multiple sessions for all the existing mappings.
• Used the Informatica Workflow Manager to create and run the Workflows, Worklets and Sessions for loading the data using the logic from mappings.
• Scheduled Informatica Workflows/Sessions to execute on a timely basis and create backup for source files.
• Used CDC logic to load incremental data from source to Data warehouse (EDW).
• Developed UNIX shell scripts, Perl scripts to format the source files and to extract the information from error logs

Environment: Informatica 8.1.5, Cognos8, Oracle 10g, Teradata, Erwin 4.5, TOAD 8.6.1, Enterprise1 (E1), SAP, DB2, Tomcat 5.1 application Server.

Confidential Wilmington, DE

ETL Informatica Developer

Responsibilities:

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• 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.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Partitioned tables which have frequent inserts, deletes and updates to reduce the contention and to improve the performance.
• 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 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.
• Created, scheduled, and monitored workflow sessions based on run on demand, run on time, using Informatica Power Center workflow manager.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Configured the session so that Power Center Server sends an Email when the session completes or fails.
• Debugged and sorted out the errors and problems encountered in the production environment.
• Determined various bottle necks and successfully eliminated them to great extent.
• Involved in performing (UAT) Unit testing and Integration testing.

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