SUMMARY:

• Over 8+Years of total IT experience specialized in Data warehousing/ Business Intelligence.
• Has worked for clients in various domains such as Supply Chain, Finance.
• Has vast experience in design, development, productionize and maintenance of various data marts such as Orders, Sales, Inventory, Purchasing, Payables etc.
• Extensively worked on Informatica Power Center Components - Power Center Designer, Workflow Manager to create workflows and sessions, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Designer Components - Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure and Sorter.
• Good expertise in Performance Tuning at Database and Informatica side like Source, Target, Mapping, Transformation and Session to make them more efficient in terms of session performance.
• Having Good knowledge of using Business Objects tools R2, R3.1. Worked on Universe development to Report building, Scheduling and migration.
• Extensively worked with Oracle database (9,10g).Have good knowledge of Oracle PL/SQL Stored Procedures, Functions and involved in Query Optimization.
• Worked on Unix/Linux/Windows platforms. Have good knowledge of Unix Shell scripting.
• Experience in Data Extraction from and Load into heterogeneous Data Sources such as Oracle, MS SQL Server, Main frames, Flat files.
• Experience with Dimensional modeling such as Star schema
• Knowledge of Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting.
• Having good experience in large volume of data, Complex business logic and Aggressive deadline environments.
• Excellent verbal / written communication skills coupled with strong Organizational & Analytical Skills with the ability to perform effectively in a Team and also capable of communicating with highly technical engineering teams.
• Highly disciplined and yet flexible approach to software development.
• Proactive and self-starter with the great ability of leadership.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.1 & 9.1

Reporting Tool: Business Object XI R2/R3.1

Languages: PL/SQL

RDBMS: Oracle 9,10 g, SQL Server 2008

Change Management Tools: Service Desk, Support Central

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Project Leader

Responsibilities:

• Part of this role need to work on projects tasks which take more than 15 days effort.
• Gathering requirements from end users.
• Responsible for build and maintenance of the ETL (Extract, Transform and Load) processes.
• Designed and developed the Informatica workflows/sessions to extract from different Data Bases and files, transform and load the data into oracle. Used indirect method for extracting from multiple source files.
• Developed mappings for both full refresh and incremental load and used Change Data Capture to perform incremental loading.
• Created sessions and workflows to help schedule nightly loads and process data from source tables.
• Created re-usable E-mail task for alert mechanism and Command task for file handling.
• Preparing Low level design documentation and High level design documentation.
• Coding as per the specs using different tools such as Informatica Power center, Business Objects, PLSQL.
• Coordinating with Offshore team for development. Brainstorming with offshore team for various logics.
• Code reviews and passing suggestions/defects to offshore team.
• Coordinating with UNIX and DBA teams during staging and Production releases.
• Coordinating with Business Users for User Acceptance Testing (UAT) and documenting queries in Query Tracking sheet (QTS) and then fix all reported Issues.
• Sending Release notifications to Client leads and IT managers.
• Part of this role need to work on enhancement requests which comes under 15 days effort
• Gathering requirements from end users/client leads on RTS requests
• Preparing functional and technical specifications
• Developed outbound interfaces which will feed data to different downstream systems.
• Mapping/Session/Workflow Development
• Coordinating with Offshore team for development and QA team for QA testing
• Announcing releases in change control meetings and coordinating with Administrators to release the code to production
• Coordinating with other applications and source systems in case of dependency of any RTS ticket.
• Coordinating with UNIX and DBA teams during staging and production releases
• Sending Release notifications to Client leads and IT managers after release of RTS requests
• Documenting pre-release & post-release defects and discussing with offshore developers to preventing them in future developments.
• Conducting training on Business Objects Reports to end users in case of new users
• Coordinating with storage teams to ensure backups are happening on time
• Sending out IT-command center notifications in cases of outages
• Production support during US timings and coordination with Offshore prod support person for IST timings
• Documenting day to day issues, failures and incidents
• In case of issues, root cause analysis, finding out work around and permanent solutions
• Analyzed various fact and dimension tables.
• Coordinating with source systems in case of late arrival of files or missing of files
• Sending out daily status email on data marts uptimes to IT directors& client managers
• Documenting daily up times of data marts and SLAs
• Providing support on maintenance activities on DWH servers

Confidential

Responsibilities:

• Initial Analysis & Estimates.
• ETL development as per the requirement
• Production Testing
• Unit Testing
• Development of Reports using Business Object