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.
ETL Tool: Informatica Power Center 8.1 & 9.1
Reporting Tool: Business Object XI R2/R3.1
RDBMS: Oracle 9,10 g, SQL Server 2008
Change Management Tools: Service Desk, Support Central
Operating Systems: Windows, UNIX, Linux
Confidential, Dallas, TX
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.
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