SUMMARY:

• Around 8 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data warehousing Software Applications.
• Over Six years of experience on Informatica Power Center and Power Exchange with strong business understanding and knowledge of Financial, Marketing, Consumer and inventory management projects. Hands on experience in all aspects of Software Development Life Cycle SDLC .
• Expertise in Informatica PowerCenter7.x/8.x/9.1/9.5 Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in Extraction, Transformation and Loading data for data warehousing using Informatica Power Center, Power Exchange from heterogeneous source systems like Flat files, Excel, XML, UDB DB2,Teradata, Mainframe Files, Oracle etc.
• Experience with Relational and Dimensional Modeling, Created Star and snow flake models for Dimensional and fact tables in Data warehousing application, using Erwin.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, reusable transformations using transformations like Source qualifier, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc .
• Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7.x.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Expert in implementing Type 1 and Type 2 Slowly Changing Dimensions as per the requirements.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, Targets, mappings and sessions.
• Expertise in Session partitioning, tuning of lookup, aggregator and joiner caches for performance enhancements
• Strong in database programming using PL/SQL and SQL with creation of packages, stored procedures, functions, triggers, materialized views, cursors and performance tuning of SQL.
• Practical knowledge of Data warehousing concepts and principles Kimball/Inman - Star Schema, Snowflake schema, Surrogate keys, Normalization/Denormalization, FACT and Dimensional Tables.
• Strong in scheduling ETL load using job scheduling utilities like ESP and Austosys.
• Good experience in performing Unit testing, System Integration testing SIT , User acceptance testing UAT and experience production support for issues raised by application users.
• Ability to work effectively working as a team member as well as an individual. Experience in working and co-ordinate with offshore and On-site models.
• Experience working with Teradata Stored Procedure, Macro and its utilities Multiload/Fastload/BTEQ to load data from flat files/database to the Teradata database.

Work Experience

Confidential

Centralized Licensing CL is the project where we are integrating the complete Licensing information to one system Nationwide has different systems for such as few bought over's and few the way business is done. So here we are trying to integrate the all system so we don't have the duplicate data and the we have only one source of truth.

Responsibilities:

• Involve in the discussion with Business to clarify the requirement
• Involve in the discussion with testers to get the scenarios checked
• Created the HLD and then LLD and get it approved with TL and then the Architect
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with other development team to make sure we are in right direction and checking the progress time to time
• Develop the mapping and workflows based on requirement

• Involved in Development, unit, performance and integration testing for the jobs
• Creating the Implementation plans and reviewing with team before the implementation date.

Environment/Tools/Technologies: AQT DB2 , UNIX, Informatica

Confidential

Commercial Credit and Risk Analysis CC RA is the project where in we were trying to match up the requirement from the Business to have our Credit and the Risk team able to run ahead of other market players. Here we have different types of project running together to match the business requirement and have the Business team enabled for more accurate decisions.

Responsibilities:

• Meet with Business to get the requirements , improvements and suggestion
• Meet with the Source System teams to get the changes and replicate to ETL side as required
• Gathering requirements, understand and sharing the details with development team.
• Data profiling , Data modeling and then creating the Technical Specs
• Preparing documentation for requirements, design, install and Unit testing
• Keeping in touch with development team to make sure we are in right direction and checking the progress time to time

• Involved in Development, unit, performance and integration testing for the jobs
• Develop test cases and review the Unit testing.
• Creating the Implementation plans and reviewing with team before the implementation date.
• Knowledge of US Financial and Credit and Risk team with in it.

Environment/Tools/Technologies: AQT DB2 , UNIX, Datastage

Confidential

Responsibilities:

• Gathering requirements, understand and sharing the details with support team and users.
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements for loading data into database tables.
• Worked on Slowly Changing Dimensions Type 2, Type 3 and Type 1.

• Involved in tuning SQL queries.
• Handled system utilization issues, performance statistics, capacity planning and recovery of databases.
• Developed test cases and Involved in Unit testing and system integration testing.
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Provide post-production support and Performance tuning.
• Provide status reports to the Core Team and Stakeholders including progress, milestones and issues.

• Keeping track of the scheduled jobs of the Supervalu DWH through scheduling tools Autosys ESP Tool and Ticketing tools HPOV CA
• Troubleshooting problems in Informatica, Teradata, Unix and Oracle code.
• Worked with Teradata utilities Fload/Mload/BETQ to load files into Teradata tables
• Doing data-fixes on request or on necessary basis depending upon the job failures.
• Involved in training and mentoring of new joiners in process and technical areas.
• Worked in different, most critical secure subject areas like CDMA, Marketing, Pharmacy where we need to work with extra precision alert
• Used CA and SCM tool to promote the development work into the production
• Communicate efficiently with clients in weekly meetings and whenever it was necessary for the schedule updates during outages environment migrations.
• Co-ordinated with different support teams in Tier 1, Tier 2 levels.

Confidential

Responsibilities:

• Developed High Level Technical Design specification and Low-level specifications based on business requirements.
• Maintain,Enhance and support the IP telephoney/Lan network.

Environment/Tools/Technologies: Oracle 10g, PL/SQL, Teradarta SQL Assistance, Sun Solaris, PL/SQL Developer, INFORMATICA, CA Service Desk, HPOV, SCM