SUMMARY OF QUALIFICATIONS:

• Have been working with ERP packages, ETL and BI tools in technical and functional lead roles for Over 7 years.
• Product experience includes PeopleSoft EPM 8.9/9.0 Planning and Budgeting, PeopleSoft EPM Financials / HCM warehouse, PeopleSoft HCM 8.9, PeopleSoft FSCM 9.1, IBM InfoSphere Information Server V8.1 Suite DataStage and QualityStage 8.1/7.5 and OBIEE 11g/10.
• Extensive experience using InfoSphere DataStage 8.1/7.5 Administrator, Designer and Director .
• Excellent experience in ETL analysis, designing, developing, testing and implementing ETL process including performance tuning and query optimizing of databases.
• Extensive experience in upgrading and migrating ETL DataStage Environments from DataStage Server Edition 7.5.2 to IBM DataStage 8.1.
• Experience in OBIEE 11.1.1.5, OBIEE 10.1.3.4 which include building and configuring repository, creating and managing Oracle Intelligent Dashboards, oracle Answers.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management, Performance tuning.
• Experience in System Analysis, Design and Development in the fields of Data Warehousing, Data Integration, Data Migration and developing Client Server applications using InfoSphere Data Stage 8.1/7.5 , Quality Stage, Oracle, SQL, PL/SQL, PeopleTools 8.50/8.48/8.46, Application designer, SQR, Crystal reports 10, PS Query, Data Mover.
• Excellent knowledge and experience on Financial Data models which include General Ledger GL , Commitment Control KK , Asset Management, Purchasing, Accounts Payable, e-Procurement, Project Management, Accounts Receivable, Billing.
• Experience in Financial, Government and Education sectors.
• Strong PeopleSoft technical skills ranging from analysis and design to coding and unit testing.
• Experience in business process analysis, systems analysis, systems design, development, testing, deployment and support.
• Excellent knowledge of studying the data dependencies using Metadata of Data Stage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Experience in writing complex queries to facilitate the supply of data to other teams.
• Responsibility includes gathering business requirements, analysis, design, data modeling, development, Client Interaction and Compiling Specifications from client, Modification and Testing.
• Extensive experience in providing critical integration and post production support.
• Excellent communication and Interpersonal skills. Versatile team player with proven problem solving skills, User Interface UI work and motivated to learn more.
• Ability to work effectively both independently and with team members, as well as with varying levels of technical and non-technical personnel, to achieve appropriate solutions
• Excellent experience in extracting source data from XML files, Sequential files, Flat files, transforming and loading it into the data warehouse.

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft EPM 9.1 IPSAS Dashboards

Responsibilities:

• Working as PeopleSoft EPM/ETL OBIEE Technical lead.
• High Level and Detail Design for PeopleSoft's Financials Data Warehouse.
• Configuring the PIA, setup tasks and running Business Unit wizard for warehouse implementation.
• Working directly with UN agencies and managing their requests, and then translating these functional requirements into technical specifications through hands-on analysis identifying user needs and matching them to appropriate solutions, monitoring on-going developments and anticipating problems, ensuring that agencies are informed of progress or setbacks in projects, meeting timelines for delivery of products of services.
• Transforming Functional Logic into ETLs and loading Facts and Dimension tables with the required data.
• Designing, migrating and Deploying OBIEE rpd following best practices, performing Admin activities through OBIEE EM, migrating Web Catalogue, reports Dashboards across environments and recommending strategies to ensure smooth systems transitions.
• Testing functionally, validating the data in warehouse and analysing the results on the dashboards.
• Preparing design document, technical document, user guide etc. and end user support.

Confidential

PeopleSoft EPM 9.1 Finance Warehouse Implementation

This project is to develop an Enterprise Data Warehouse and Data Mart applications to maintain the General ledger and Profitability data mart. It involves in data cleansing, demoralization, and data extraction into the staging database, applying business rules in the transformations carried out using IBM infoSphere DataStage and reporting through OBIEE 11g.

Responsibilities:

• High Level and Detail Design for PeopleSoft's Financials Data Warehouse.
• Developing and Running IBM information server DataStage for the warehouse implementation OWS and MDW for GL and profitability mart.
• Identifying priority activities and assignments adjusting priorities as required allocating appropriate amounts of time and resources for completing work foreseeing risks and allowing for contingencies when planning monitoring and adjusting plans and actions as necessary.
• Worked extensively on different types of stages such as Sequential file, Data set, Lookup stage, Aggregator, Transformer, Copy, Merge, Join, Filter, Column Generator.
• Identifying and fixing the bugs in the ETL jobs and building functional logic.
• Configuring the PIA, setup tasks and running Business Unit wizard for warehouse implementation
• Played a key role in designing an entire RPD design following best practices.
• Deployment of rpd and doing administrating activities like New ID creation, Account modification of existing users, Password reset and Deletion of accounts through OBIEE EM.
• Migrating Web Catalogue, Reports Dashboards across environments through Catalogue Manager.
• Automated Aggregate Table creation utilizing Persistence Aggregate Wizard.
• Implemented Oracle BI/Database Performance Tuning Techniques.
• Responsible for planning and deployment activities, including providing analysis and recommending strategies to ensure smooth systems transitions
• Designed Created and Tested Report in the Dashboard and created the adhoc report according to the client needs.
• Getting Functional requirements from UN agencies, discussing various methods to produce the results, developing functional and process Maps.
• Designed, Developed and Tested Data security and Dashboard security in OBIEE
• Migrated the Tested Code from Development to QA and QA to Production of Repository, Dashboard Reports and OWB mappings and workflows.
• Development of reports PSQUERY, SQR crystal reports .
• Preparing design document, technical document, user guide etc.

Confidential

PeopleSoft EPM 8.9 Planning and Budgeting FSCM Warehouse

Responsibilities:

• Developing and Running various Ascential Jobs for the warehouse implementation OWS and OWE .
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.
• To obtain better performance, tuned Data Stage jobs by creating Data Stage Hash files for staging the data and lookups
• Worked with DataStage Manager to import/export metadata, DataStage jobs and routines from the repository
• Ensuring that PeopleSoft EPM system-related production errors are diagnosed and resolved quickly to maintain the accuracy of business-critical systems
• Implemented logic for Slowly Changing Dimensions Type 2 SCD's .
• Identifying and fixing the bugs in the ETL jobs and building functional logic.
• Mapping different Peoplesoft Source FSCM and HCM to EPM 8.9 involved in the developmental activities of Planning and budgeting.
• Interacting with database administrators, security analysts and business system users in this effort
• Developing dashboards for various modules in Oracle business Intelligence Enterprise Edition OBIEE
• Development of reports PSQUERY, SQR crystal reports .
• Gathering requirements and coordinated with the client business users for the project related activities.
• Created Test Plans and Test Scripts for unit testing and Integration Testing and created implementation plans and implemented projects.
• Development of Budget override monitoring tool.

Confidential

PeopleSoft 9.0 Planning and Budgeting and Warehouse implementation

Responsibilities:

• Developing and Running various Ascential Jobs for the HCM/FSCM warehouse implementation OWS, OWE and MDW .
• Identifying and fixing the bugs in the ETL jobs or functional logic.
• Mapping different Peoplesoft Source FSCM and HCM to EPM 8.9 involved in the developmental activities of Planning and budgeting Scorecard and Multidimensional Warehouse
• Co-ordinated with Database Administrator to create appropriate indexes for faster execution of jobs and performed Performance Tuning.
• Used DataStage Director to run and monitor the Data Stage jobs
• Extensively wrote user SQL coding for overriding for generated SQL Query in DataStage.
• Created job sequences and job schedules to automate the ETL process
• To obtain better performance, tuned Data Stage jobs by creating Data Stage Hash files for staging the data and lookups.
• Development of reports PSQUERY crystal reports .
• Gathering requirements and coordinated with the client business users for the project related activities.
• Preparing design document, technical document, user guide etc.

Confidential

PeopleSoft EPM 8.9 Warehouse

Responsibilities:

• Analyzed and validating the form of data which are available in the existing systems.
• Extracted the data from various systems by designing ETL jobs and populated the data to the target databases.
• Implemented SCD Type-1 and SCD Type-2 while loading the data into the target databases.
• Created Sequence jobs for each set of tasks and tested all the jobs and checked the improvement of the performance from the existing system.
• Used Lookup, Sort, Merge, Filter, and Transformer and Sequencer stages.
• Used Transformer stages with stage variables to map data create expressions and constraints to match the business transformations.
• Wrote background PL/SQL functions, procedures and packages for reports.
• Created user defined SQL queries based on requirements.
• Used job sequencer and job parameterization.
• Created AUDIT Tables to enable business users to understand and access the data with great flexibility.
• Resolving the data issues reported by the business people and analysing, resolving, assisting Data Analyst on impacted areas.
• Supported Testing team providing different test plans and test cases to get best product Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the DB2 database in UNIX environment
• Used TOAD Software for Querying ORACLE.

Confidential

PeopleSoft HRMS NA Payroll Upgrade from 8.4 to 8.9

Responsibilities:

• Analyse the person model and table structure changes
• Prepare Technical Design Documents
• Apply customizations to Programs and perform Unit Testing.
• Upgrade and Enhance the SQR Reports, Application Engine programs
• Development of reports PSQUERY crystal reports .
• Gathering requirements and coordinated with the client business users for the project related activities.
• Preparing design document, technical document, user guide etc.
• Understanding of client's HRMS system and the business needs of different customizations.
• Understanding and Mapping the person model changes.
• Preparation of Technical Specifications based on functional requirements of the client.
• Reapplication of 8.3 customizations to Reports, Interfaces and On-line Objects - Records, Pages, Components and Menus.
• Preparation of Unit Test Plans and carrying out the unit testing.