We provide IT Staff Augmentation Services!

Principal Peoplesoft & Etl Consultant Resume

New, JerseY

OBJECTIVE:

Seeking a position as a techno functional PeopleSoft consultant & ETL Data Architect, wherein my expertise in the field of PeopleSoft implementation & Data modeling can make a good contribution in an established organization.

SUMMARY:

  • Overall 14+ years of IT experience with 12 years of experience in PeopleSoft Financial environment (techno - functional consultant) and Data modeling (ETL Data Architect).
  • Team-leader for the upgrading PeopleSoft FSCM GL from 8.9 to 9.2 using PeopleSoft Upgrade Manager PUM on PeopleTools 8.53.12.
  • Strong expertise in RDBMS SQL, PS Query and PS tools Application Engine, Integration Broker and Data Mover, Integration tools like Application Messaging and Component Interface, interface design, data mapping and data conversions .
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.
  • Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2005, DB2 9.7 and MS Access.

TECHINICAL SKILLS:

ERP: PeopleSoft FSCM 9.2 & PeopleTools 8.53.12 (People Code, Application Engine, Component Interface & Data Mover)

ETL Tool: Informatica Power Center 9.1 & 10.2

Databases: Oracle 10g, 11g, SQL Server & DB2 9.7

Reporting Tool: Hyperion Reporting

Programming Languages: Visual Basic & VB Scripting

Operating Systems: Windows NT/XP/2000/2003, UNIX & Linux

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Principal PeopleSoft & ETL Consultant

Responsibilities:

  • Worked closely with Finance/Accounting personnel and technical support and other personnel to troubleshoot and resolve system issues related to PeopleSoft Financials.
  • Maintain and ensure the appropriate PeopleSoft security for end users.
  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.
  • Coordinated and facilitated with development team for change requests and defect fixes.
  • Work with technical team on technical documentation and develop conversion strategy
  • Provide post-production support across all deployed modules.
  • Manage User Acceptance Testing and deliver training to end-users.
  • Mentor users in system use, monitor move to production and tandem operations.
  • Work closely with the General Ledger subject matter experts and technical team in ensuring the suites flow and fit together with the client’s requirements.

Environment: s: PeopleSoft 9.2 - PeopleTools 8.50, 8.53.12, Oracle 11g, UDB 9.7.0.3, Informatica 9.1 & 10.2 Power Center, Autosys Scheduling & UNIX scripting.

Confidential, New Jersey

Sr. PeopleSoft & Informatica Analyst

Responsibilities:

  • Led system upgrade effort to 9.2 FSCM environment in where I performed GAP Analysis on the current system's capabilities, created new requirements, and built test cases/scripts to confirm expected system performance.
  • Managed configuration and installation of PeopleSoft Financial Chain Management FSCM system using PeopleSoft Upgrade Manager PUM and all associated middleware and third party products like Tuxedo, Web Logic etc. on a Unix REHL 6.
  • Spearheaded an optimized technique to slash down the processing time by 50% - Year End Close and Revaluation process.
  • Enforced PeopleSoft delivered Data Archival and Mass Update functionality.
  • Utilized Data Warehouse experience in use of Informatica Power Center (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle/UDB databases.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Built several reconciliation analysis interfaces between PeopleSoft General Ledger 8.9/9.2, legacy system, data ware house and various point solutions using ETL tool.
  • Executed processes to analyze the quality of the data imported from the old system using business rules and analyzed the errors to perform configuration and data conversion changes to eliminate them.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Favored as a single point of contact as a Subject Matter Expertise for migrating PeopleSoft project using Quest Stat tool.
  • Administered on-going end-user production support and training to technical and functional staff via classroom discussions, conference calls and net-meetings.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations. Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Environment: s: PeopleSoft 9.2 - PeopleTools 8.50, 8.53.12, Oracle 11g, UDB 9.7.0.3, Informatica 9.1 Power Center, Autosys scheduling & UNIX scripting.

Confidential, New Jersey

Sr. PeopleSoft & Informatica Analyst

Responsibilities:

  • Pioneered as a Senior PeopleSoft Consultant for PeopleTools upgrade for PeopleSoft General Ledger.
  • Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g,DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Managed application builds, test planning, execution and deployment activities.
  • Steered data migrations from other systems to PeopleSoft using ETL Tool Informatica.
  • Achieved organizational goals by acquiring ownership for new and distinctive requests while exploring opportunities to add value to job resources.
  • Lead a team of Software Developers and Functional Analysts in providing support for PeopleSoft systems.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  • Responsible for troubleshooting Web Server, Application Server, Process Scheduler & Application Designer problems in 2-tier, 3-tier & PIA environments.

Environment: s: PeopleSoft 8.9 - PeopleTools 8.4, 8.50, Oracle 10g, UDB 9.7.0.3, Informatica 8.6.1 & 8.5 Power Center, Autosys Scheduling & UNIX scripting.

Confidential

Sr. PeopleSoft Developer

Responsibilities:

  • Actualized employee massaged time sheet data from legacy system to PeopleSoft Time & Material module using Integration Broker.
  • Executed Change request related to the project from the legacy system to the PeopleSoft project and contract module using Integration Broker.
  • Analyzed product impact through the scope of customizations and interfaces with legacy systems providing specifications and functional design documents.
  • Designed a work plan for the Build and System Integration Testing Phases (involving Unit Testing).
  • Provided effective solutions to production issues.

Environment: s: PeopleSoft 8.4 & Microsoft SQL Server 2000.

Confidential

Application & SQL Developer

Responsibilities:

  • Spearheaded technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements and created fact sheets to analyze business data.
  • Played a one-point contact leader for initiating ideas, developing new tasks, delivering and testing software prototypes for system improvements and resolving defects in the system for onsite team members.

Environment: s: Visual Basic 6.0, Visual Source Safe and Microsoft SQL Server 2000.

Confidential

Application Project Lead

Responsibilities:

  • As a Team leader, developed project plans, adhered to project milestones, monitored project progress and management reporting.
  • Spearheaded assembling of client requirements, preparing specifications and functional design documents for enhancements and customization thus analyzing product impact.
  • Supervised and trained new recruits in the team providing technical guidance in the accomplishment of their duties.
  • Administered test and development team activities with respect to defect resolution management.

Environment: s: Visual Basic 6.0, VB Designers, Crystal reports 8.0, Visual Source Safe and MSDE.

Confidential

Application & SQL Developer

Responsibilities:

  • Developed a customized tool based on the client need to manage the sales transactions in the Boutique while providing support in UAT and bug fixing activities.

Environment: s: Visual Basic 6.0, VB Designers and MS-SQL Server 2000.

Hire Now