• Over 14 years of experience in IT industry especially in client/server business systems analysis, design, development, testing, implementation, maintenance and support.
• 11 years of experience in PeopleSoft technologies, working in various applications like PeopleSoft HR, PeopleSoft Financials as Techno-Functional Consultant, PeopleSoft Enterprise Performance Management EPM as Techno-Functional Consultant, PeopleSoft CRM Technical, OBIA.
• 8 years of experience with a strong knowledge base in Extraction Transformation Loading ETL applications for Data Warehouses using IBM Infosphere Datastage v8.x, Informatica v8.6/v9.1 , Oracle Data Integrator ODI 11g .
• Experience in deploying, Configuration and implementation of various Data Warehousing applications like Oracle Business Intelligence Applications OBIA Campus Solutions, HR Analytics, and Financials , Oracle Business Intelligence OBIEE , Fusion Middleware, PeopleSoft Enterprise Performance Management, IBM Cognos.
• Experience as BI consultant in OBIEE 11g: Worked on Dashboards, Reporting, Repository Development/administration RPD , Security, Deployment.
• Experience in IBM Cognos v10.x Framework manager, Power play, Administration .
• Experience in full life cycle implementation from requirements gathering to post-production. Extensively involved in developing Technical design documents, preparing Test Cases Test Plans.
• Experience in PeopleTools sustenance.
• Experience in Teradata sustenance that included bug-fixing and enhancements to Parallel Database extensions in Unix/NT environments.
• Team lead experience that included managing project tasks, resource management, work allocation, sizing and scoping, application.
• Demonstrated success managing multiple and simultaneous projects to completion within constraints of time, scope and budget.
• Excellent communication and leadership skills, including ability to work effectively with managers from widely varying disciplines and regions.

Technical Skills:

Professional Experience:

Confidential

Role: DW BI Architect/Tech Lead

Responsibilities:

• Designing the high availability architecture for the OBIA and OBIEE setup using Oracle 11g suite.
• Working with the Systems and Weblogic team during the installations and configurations.
• Setting up of OBIA, ODI and OBIEE environments. Configuration of OBIA for Source, Targets and Load plans.
• Working with Golden Gate implementation team for integrating Golden Gate with ODI.
• Configuring and setting up of ODI Load plans for loading data from PeopleSoft HCM/CS/FS into the warehouse. Development/Customizations of ELTs. Configuring Physical Schemas, Logical Schemas, Models.
• Development of Projects, Packages, Interfaces, Scenarios and Load plans.
• Configuring the OBIEE security at Fusion Middleware and Repository level. Setting up of authentication and Session variables.
• Repository RPD development and customizations for the Reporting.
• Dashboard development, Catalog Management, OBIEE web security user/roles/groups , Development of various Reports and Analyses.
• Preparing Technical design documents and Test plans.
• Setting up Migration path for implementing SDLC model.
• Maintenance of BI ODI cluster using Fusion Middleware.

Environment: IBM Oracle Business Intelligence Applications OBIA 11g, Oracle Data Integrator 11g, WebLogic 11g, Oracle Business Intelligence Enterprise Edition OBIEE 11g, Oracle Golden Gate 11g, PeopleSoft HCM/Campus Solutions/Financials 9.x, Fusion Middleware 11g.

Confidential

Role: ETL BI Consultant

• Implementation and sustenance of General Ledger and Commitment Control Datamart in EPM.
• Core-Development Activities include development of the models, ETL processes, automation of processes, batch using IBM Infosphere 8.x.
• Performance tuning of processes, Warehouse, ETLs, Models, various reports SQLs etc.
• Worked on various dashboards for Organizational wide Analytical reporting that includes:
• IRMF International Resource Management Framework Reports
• UNDP Management Reports
• UNCDF United Nations Capital Development Fund Budget overview reports
• IPSAS International Public Sector Accounting Standards Indicators
• OFA Office of Financial Administration Reports
• Worked on data integrations between PeopleSoft FSCM, PeopleSoft HCM, PeopleSoft EPM, MS SQL Server, using ETLs.
• Extensively worked on developing complex ETLs jobs, Sequencers, scheduling and migration related activities.
• Worked on Repository design, development and deployment of OBIEE RPD Physical/Business/Presentation Layers.
• Worked on creating Dashboards, reports, views, Subject Areas, Analysis, and also configuring the Catalog Security using OBIEE Administration.
• Worked with the Production Support team on various activities like Performance tunings, bug fixes, Migrations and deployments.

Environment: IBM Infosphere DataStage v8.x, OBIEE 11g, PeopleSoft EPM v9.1, PeopleTools v8.5x, Oracle 11g, SQL Developer, Toad

Confidential

Role: Technical Lead

Responsibilities:.

• Developing and Review of Technical Design documents, providing LOE level of estimates , planning and work distribution.
• Core-Development Activities include development of the models, ETL processes, automation processes, batch processes and online features using People Tools .
• Performance tuning of processes, Warehouse, ETLs, Models, various reports SQLs etc.
• Design the warehouse includes Metadata, TableMaps, DataMaps, Filters, Constraints, Rules, and Drivers etc.
• Informatica v.8.6/v9.1 Designer, Workflow Manager, Workflow Monitor, Repository Manager , IBM Infosphere Datastagev7.x/v8.x Designer, Director, Administrator, Version Control
• Worked with Business teams to build Cognos projects, cubes and monitoring of the Cubes. Provided administration support to Cognos services and involved in upgrades.
• Worked with business teams in preparation of OBIEE dashboards and reports. Integration with PeopleSoft FSCM and Enterprise Performance Management systems.
• Prepare Source to Target mapping design documents for ETLs, automation of Data loads, Tree imports/exports from Finance , Model runs etc., and also enhancing existing applications using People Tools: PeopleCode, Application Engine, SQRs, nVision, Component Interface, shell scripts and Perl.
• Development of interfaces for integrating EPM systems with Corporate Treasury Systems.
• Worked on reporting requirements for Daily Assets under Management and Actuals to Budget Management Reports.
• Enhanced and maintained 3rd party reporting application Gray Sparling for building, executing and distribution of reports to departments across organization.
• Involved in the design and implementation of automation of various daily/monthly tasks and preparation of monthly calendars.
• Coordinated with offshore teams and ensured in timely delivery of the project deliverables.
• Provided technical support to the team in various activities like Development, Unit testing, Migrations, Support and Knowledge transitioning.

Environment: PeopleSoft Enterprise Performance Management EPM v8.8, PeopleTools v8.49, Informatica v.8.6/v9.1, Datastagev7.x/v8.x, Oracle 11g, SQL, Toad, UNIX/PERL Shell Scripts, Cognos B.I

Confidential

Role: Technical Lead

Responsibilities:

• Designed Treasury inbound systems' Source to Target mappings.
• Used Informatica to develop jobs to extract, transform and load data from external systems into the Treasury systems.
• Used Application Engine and component interfaces to load data from external systems that deliver files onto the PeopleSoft servers.
• Worked on enhancements to Treasury Deal Management and Cash Management modules using Application designer, PeopleCode.
• Worked on Worked on Intergration broker, setting up inbound/outbound Messages for Financial Gateway, setting up Nodes, Monitoring.
• Designed Treasury outbound systems' programs using PeopleCode and Component interface.
• Designed Datastage maps to load Treasury data from PeopleSoft Financial systems to PeopleSoft EPM systems.
• Responsible for unit test documentation, design documentation, build-to-run transition documents, deployment and post production job monitoring.
• Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
• Worked on setting up IBM MQ and SWIFT for Franklin Treasury systems.

Environment: PeopleSoft Financials 8.9, PeopleTools 8.49, Informatica 8.6, Datastage7.x, Oracle 10g, SQL, PL/SQL, Toad.

Confidential

Role: Sr. PeopleSoft Developer Sr. ETL Developer

1. Timesheet entry for employees for recording hours spent on various funded/base activities on a day-to-day basis.

2. Project Management dashboards that gives insight into the various Project related metrics and analysis.

3. Weekly/Monthly/Yearly timesheet reporting with adhoc/automated posting of reports to the document repository.

4. Integration with Project costing module.

5. Integration with Enterprise warehouse and TCO Total Cost of Ownership modules.

6. Reports for Project related analysis, Project Cost analysis, Missed Timesheets, Hours allocations for various Funded/Non-Funded projects, Project estimates, etc.

7. Single Signon access through Intranet for all the employees.

In This project, worked as Senior Software engineer developing the NGTE system from the scratch, which includes building the panels, menus, business logic, application engines, component interfaces, application packages, reports, developing ETLs using IBM DataStage for loading data into EPM systems , bug fixing and enhancements reported through user stories .

Responsibilities:

• Full development cycle of the feature using PeopleSoft Tools, PeopleCode, Application Packages, Application Engines, Component Interfaces, XML publisher, PS Queries, SQRs.
• Used IBM DataStage to develop jobs to extract, transform and load data from Project Costing/NGTE to PeopleSoft Enterprise Management Systems.
• Used CONTROLM to schedule DataStage jobs and Reports on Daily/Monthly basis.
• Used Application Engine and component interfaces to load data from/to Project Costing module.
• Worked on bug-fixing and enhancements, reported in the form of user stories. Features are added using Sprint releases.
• Responsible for unit test documentation, design documentation, build-to-run transition documents, deployment and post production job monitoring.

Environment: PeopleSoft Financials 8.9, PeopleTools 8.49, Datastage 7.x, Oracle 10g, SQL, PL/SQL, Toad.

Confidential

Role: Sr. PeopleSoft Developer ETL Developer

Responsibilities:

• Paper Models design/review, mapping Source Requirements to Functional/Technical requirements, Project Kick off meetings.
• Developing and Review of Technical Design documents, providing LOE level of estimates , planning and work distribution.
• Core-Development activities include development of the models, ETL processes, automation processes, batch processes and online features using People Tools .
• Performance tuning of processes, Warehouse, ETLs, Models, various reports SQLs etc.
• Design the warehouse includes Metadata, TableMaps, DataMaps, Filters, Constraints, Rules, and Drivers etc.
• Prepare Source to Target mapping design documents for ETLs, automation of Data loads, Tree imports/exports from Finance , Model runs etc., and also enhancing existing applications using People Tools: PeopleCode, Application Engine, SQRs, nVision, Component Interface, shell scripts and Perl.
• Involved in the design and implementation of automation of various daily/monthly tasks and preparation of monthly calendars.
• Responsible for assignment and delivery of tasks from offshore. Involved in review of Project plans and timesheet entries with Project manager.
• Provided technical support to the team in various activities like Development, Unit testing, Migrations, Support and Knowledge transitioning.

Environment: PeopleSoft Enterprise Performance Management EPM v8.8, PeopleTools v8.49, Informatica v.8.6/v9.1, Datastagev7.x, Oracle 11g, SQL, Toad, UNIX/PERL Shell Scripts

Confidential

Role: Sr. PeopleSoft Developer

Responsibilities:

• Understand the System Requirement specifications.
• Present the prototypes to the customers.
• Works on the functional/technical design.
• Designed complete technical solution for the system.
• Core Application development using PeopleTools 8.42, FSCM 8.4
• Develop Reports using Crystal/Vision.
• Develop automated processing for email notifications/reports.
• Work involves Unit testing, System testing and post-implementations support.
• Requirements Analysis and High Level Design.
• Detailed design.

Environment: PeopleSoft Financials 8.4, PeopleTools 8, PeopleCode, SQRs, Application Engine, Crystal Reports, Oracle10g/9i, UNIX, SQL, TOAD.

Confidential

Role: Sr. PeopleSoft Developer

Responsibilities:

• Review of System requirements specifications/enhancements.
• Designing Technical design documents.
• Core application development using PeopleSoft 8.3 HRMS, People Tools 8.x.
• Developed automated processes using PeopleTools Application engine to generate reports on the systems usage and availability.
• Testing life-cycle: Unit System testing. Post-implementation support.
• Used STAT version control tool to migrate changes through Development, Test and Production environments.

Environment: PeopleSoft HRMS v.8.3, PeopleTools v8.x, Oracle 9i, TOAD.

Confidential

Role: Sr. PeopleSoft Developer

Responsibilities:

• Gathering System Requirement specifications, designing Functional/Technical Design documents, preparing MOMs.
• Core Application development using PeopleSoft CRM 8.8/People Tools 8.45, Used People Tools like Application designer, PeopleCode, Application Engine, Component Interface, Security Component, Portal etc.
• Unit testing, System testing, Integration testing and User acceptance Testing, bug fixes and enhancements..
• Testing life-cycle: Unit System testing. Post-implementation support.

Environment: PeopleSoft CRM v.8.8, PeopleTools v8.x, Oracle 9i, SQL Navigator.

Confidential

Role: PeopleSoft developer

Responsibilities:

• Develop SQR programs to transfer data between Time and Labor tables.
• Generate data in a flat file with the details for Employee pays, which in turn would be used by the Payroll to distribute the Salaries for the Employees.
• Interact with the client for clarifications related to Time and Labor or for any technical clarifications.
• Requirements Analysis and High Level Design.
• Detailed design.
• Code walk-through of complex programs.
• Review of System Test Plans.
• Completion of Integration testing.

Environment: PeopleSoft HRMS 8.3, SQRs, Oracle 8i, SQL Navigator.

Confidential

Role: PeopleSoft Developer

Responsibilities:

• Fixing Bugs that are identified/reported at the customer site or in-house through online Bug tracking system ICE .
• Understand the application and suggesting/making improvements and enhancements to PeopleSoft EPM modules like BAM Business Analytical Modeler .
• Setup and installation of BAM server.
• Bug fixing in PeopleSoft budgeting Tool.
• Maintain the modules required by the client.
• Perform Quality Analysis of the Bugs fixed offshore.
• Interact with the client for clarifications related to incidents or for any technical clarifications

Environment: PeopleSoft EPM v8.x, PeopleTools 8.x, Visual C .

Confidential

Role: PeopleSoft Developer

Environment: PeopleTools 8.x, Visual C .

Confidential

Role: Software Engineer

• Development of new tools as per business requirements.
• Enhancement to existing services kernel and user mode or adding new features to PDE.
• Fixing Bugs that are reported at the client site GSC or in-house.
• Understand the application and suggests improvement and enhancement.
• Develop and maintain the modules required by the client.
• Interact with the client for clarifications related to Discrepancy Reports DR or modules.

Environment: Visual C , Windows SDK, GNU Debugger, Windows NT, Unix MP-RAS, Sun Solaris, Linux, Rational Clear Case.