We provide IT Staff Augmentation Services!

Project Leader Resume

Dallas, TX

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

Production Support Leader

Responsibilities:

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

Hire Now