SUMMARY:

• 10+ years of IT experience in Software Analysis, Design, Development, data analyst and Implementation of business applications for Financial, Insurance verticals.
• 10+ years of strong Data Warehousing and ETL experience in using Informatica Power Center 9.5,9.1.0.,8.6, 8.1,7.1, 7.0, 6.2, 6.1, 5.2, 5.1 including Designer, Repository Manager, Repository Server, Workflow Manager & Workflow Monitor, OLAP, SQL*Plus.
• 10+ years of Dimensional Data Modeling experience using Data modeling, Erwin Modeling (ERwin 4.0/3.5.5/3.5.2 ), Star Schema/Snowflake modeling, Slowly Changing Dimensions (Type I & II), FACT & Dimensions tables, Physical & logical data modeling
• Highly analytical and process - oriented Data Analyst with in-depth knowledge of database types. Adaptable Data Analyst skills in recording, interpreting and analyzing data in a fast-paced environment.
• Business Intelligence experience in Cognos 8 BI.
• 10+ years of strong database experience using Oracle 11g/10g/9i/8i, UDB DB2,Sybase 15, Netezza, SQL Server 2000,Erwin 4.0/3.5.5, SQL, PL/SQL, SQL*Plus, TOAD, Sun Solaris 2.x, Linux.
• Good team player and ability to learn new tools and technologies quickly.
• Excellent communication, interpersonal skills and a team-worker with good customer interaction.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5,9.1,8.1,7.1.4, Data Profiling, Data cleansing, OLAP, ROLAP, MOLAP, AutoSys 3.1/1.1, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.5.5/3.5.2

Databases: Oracle 11g/10g/9i/8i/8.0,DB2, MS SQL Server 2000,Sysbase 15.

BI & Reporting Tools: Business Object, Cognos 8 BI Reports

GUI: Oracle Forms 6.0, FrontPage 97/98/2000, Visio and TOAD 6.0/5.0, Oracle Designer, VC++, Visual Basic 5.0/6.0

Programming: SQL, PL/SQL,SQL*Plus 3.3/8.0, Java, HTML, DHTML, C,C++, UNIX Shell Scripting, N Tier

PROFESSIONAL EXPERIENCE:

Confidential, NJ

ETL Lead

Responsibilities:

• Played the role of a Program Technical Lead and was responsible for designing the ETL Strategy of the Project.
• Responsible in managing tasks and deadlines for the ETL teams Onsite
• Act as point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues..
• Worked on WBS to break up the work into task list and estimate based on simple, medium and complex methodology
• Involved actively in requirement analysis, business requirement, detailed analysis and design sessions of various phases of the project and contributing to the business and stakeholders .
• Involved in the functional and technical design document sessions with Technical team and business users team.
• Contributed to the development of ETL mappings including joiner, sorter, router, aggregator, union, lookup and filter transformations etc . involving facts/dimension tables, using Informatica Power Center 9.5
• Actively involved in frequent peer design and code reviews to ensure that the coding is strictly in accordance with that of the Business and Technical requirements and also to ensure the code interdependencies across the modules are met.
• Contributed to the different facets of DWSLC in data loading, scheduling, T his involved the facts and dimension data into the data warehouse.
• Involved in loading the data from the source systems such as flat files, DB2 mainframe to Oracle to target database then to the CORE, data warehouse and then back to the reporting systems for reports .
• Responsible for designing and implementing the ETL process from multiple source systems to Staging tables and then to respective CORE tables.
• Created extracts from core database to provide files for downstream systems .
• Worked on N tier Reconciliation tool to Reconcile end to end data loaded by ETL process . Recon report generated using N tier front end for each track to show breaks at multiple hops such as stage, core, mart and reporting database.
• Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment

Environment: Informatica Power Center 9.1,UDB DB210.5,Oracle 11g,SQL Server, Toad, Mainframe, ERWin 4.0, Windows 2000, Tidal, Business Object, Sun Solaris 2.6, UNIX

Confidential, NJ

Sr. Program Analyst

Responsibilities:

• As the Primary ETL Tech Lead for the Data Warehousing Project. Involved in the design, analysis of Predictive modelling projects for Property, WC Recast.
• Led business requirement analysis by applying techniques such as business process modelling, Dimensional modelling, star and snowflake schema, Enterprise data dictionary.
• Contributed to the detailed study of the existing data warehousing model and to the documentation for improvements of the BI Data warehouse in the project.
• Involved actively in requirement analysis, business requirement, detailed analysis and design sessions of various phases of the project and contributing to the business and stakeholders .
• Involved in the functional and technical design document sessions with Technical team and business users team.
• Contributed to the development of ETL complex mappings including joiner, sorter, router, aggregator, union, lookup and filter transformations etc . involving facts/dimension tables, using Informatica Power Center 9.1
• Actively involved in frequent peer design and code reviews to ensure that the coding is strictly in accordance with that of the Business and Technical requirements and also to ensure the code interdependencies across the modules are met.
• Extensively worked in the performance tuning of programs, ETL procedures and processes .
• Contributed to the different facets of DWSLC in data loading, scheduling, T his involved the facts and dimension data into the data warehouse.
• Contributed as team lead and Sr. Program analyst with proven track record of dealing with Oracle 9i/10g/11gand UDB DB2 versions .
• Worked on analysing the ETL Business requirements for Informatica
• Involved in loading the data from the source systems such as flat files, DB2,mainframe to Oracle to target database then to the ODS, data warehouse and then back to the reporting systems for reports .
• Developed several testing strategies - unit, integration, system testing
• Developed the UNIX scripts to automate the process of running jobs/ batches.
• Worked on designing and analysing the ETL requirements for PM projects . Helped the ETL developers in the coding and testing phase and processes.
• Worked on Extracts for external vendors such as Opera and Actuarial . Generated weekly and monthly basis as per business requirement.
• Created multiple standard and how-to documents for Informatica/UNIX shell and uploaded all documents to share point.
• Involved in Performance tuning of multiple Informatica mappings to improve performance as the volume of claims, policies into entered the system on a daily basis. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.
• Responsible for designing and implementing the ETL process from multiple source systems to Staging tables and then to respective ODS tables.
• Developed stored procedures, triggers, SQL and UNIX shell scripts for the business logic and the interface between UNIX and Informatica.
• Highly analytical and process-oriented data analyst with in-depth knowledge of database types.

Environment: Informatica Power Center 9.1,UDB DB2 9.0, Oracle 11g,Toad, Netezza, PL/SQL, ERWin 4.0, Windows 2000, Control-M, Cognos, Sun Solaris 2.6, UNIX, Aginity

Confidential, Prime Brokerage, NY

Sr. Informatica Developer

Responsibilities:

• Worked closely with the business teams to analyze the business requirements and developed ETL specifications for source data validation, transformation and loading into the target data mart.
• Involved actively in requirement analysis, business requirement, detailed analysis and design sessions of various phases of the project and contributing to the business and stakeholders .
• Extensively used Informatica tools. Also involved in daily production issues and production support.
• Designed and developed Informatica mappings by translating the business requirements, enabling extraction of the source data, transformation of the data and implementation of the business rules using Informatica transformations and loading the data into the target tables.
• Extensively used look up, router, filter, joiner, source qualifier, aggregator and update strategy transformations.
• Created sessions, workflows and tasks using Workflow manager. Also, used Workflow Manager for session management, database connection management and scheduling of jobs.
• I have created elaborate unit testing plans. I created proper test environment by copying appropriate claims data in BD for each production problem. I performed ST by running historical and daily CP network.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in Performance tuning of multiple Informatica mappings to improve performance as the volume of trades entered the system on a daily basis. The factors involved were bulk loading and also adding indexes on the staging tables.
• Responsible for designing and implementing the ETL process from multiple source systems to Staging tables and then to respective ODS tables
• Created UNIX shell scripts to automate Informatica sessions, pre and post session processing, archiving log files etc.

Environment: Informatica Power Center 8.1.1, Sybase 15, PL/SQL, ERWin 4.0, Windows 2000, Control M, Business Object, Sun Solaris 2.6, UNIX

Confidential, Cherry Hill, NJ

Informatica Developer

Responsibilities:

• Involved actively in requirement analysis, business requirement, detailed analysis and design sessions of various phases of the project and contributing to the business and stakeholders .
• Actively participated in meetings and shared information and ideas which helped while table design and code design.
• Document project plans for all projects. Also created document for issues came across in different phases including problems, result.
• Extensively used Informatica tool such as Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Workflow Manager to implement the ETL process.
• Extensively worked with Informatica to Load data from Oracle, SAP, Peoplesoft to target database.
• Created most of the transformation including Source Qualifier, Aggregator, Filter, Expression and Unconnected and connected Lookups, Update Strategy.
• Created Mapplets and used them in different mappings
• Improved mapping performance by using SQL overrides
• I made sure that the system meets SLA while adding making changes to existing objects in daily process by tuning sqls which are added as part of change.
• Used partitioning to improve the performance of the ETL process

Environment: Informatica Power Center 8.1, 7.1.4,Oracle 10g, Toad, SQL, PL/SQL, ERWin 4.0, Windows 2000, Tidal, Cognos 8, Sun Solaris 2.6, UNIX