Post Job Free

Resume

Sign in

Project Sql Server

Location:
Pittsburgh, PA, 15220
Posted:
July 21, 2013

Contact this candidate

Resume:

SUMMARY

. Over ** years of experience as Developer & Technical Lead including 10

years of experience in analysis, design, development, Customization,

upgrade and Production support projects

. Expertise in PeopleSoft Financials and SCM experience in GL, AP, AM, PO,

and eProcurement modules.

. Expertise in PeopleSoft technical skills such as People Tools

(Application Designer, People Code, Application Engine, Component

Interface, File Layout, Process Scheduler, Workflow, Query, Data Mover,

Integration Broker and Security Administrator), SQR, nVision and Crystal

Reports.

. Participated in all phases of ERP full-life cycle Implementation,

Customization, Development, Production Support and Upgrade.

. Expertise with PeopleSoft Financials / HRMS/ Supply Chain, Performance

tuning, Windows & UNIX administration.

. Experience in Documentation of Technical Specifications, technical

designs and test cases.

. Involved in people tools upgrade, application upgrade and database

upgrade projects.

. Experience in data extraction from legacy systems to PeopleSoft

application database tables and Integration of PeopleSoft system with

various third-party systems.

. Utilized tools and utilities PC Debugger, Application Engine trace for

troubleshooting.

. Excellent troubleshooting, problem-solving skills and good understanding

of business procedures.

. Significant PeopleSoft functional experience from project conception

through roll-out which includes fit gap analysis, configuring application

and setups, creating SOP's, BRD's and UAT Scripts and educating the

functional users.

. Implementing of Business Card functionality, establishing Punch-out

Vendors in procurement.

. Used delivered functionality in providing alternate solutions for

different business problems and avoiding customizations to the maximum.

. Good understanding of PeopleSoft n-tier architecture and technology

infrastructure.

. Sound leadership ability, excellent communications skills, versatile in

the functional and technical and the ability to function productivity in

team environments.

. Provide leadership and technical skills in building & delivering system

solutions with commitment to customer success.

SKILLS SUMMARY

PeopleSoft Applications : Financials, SCM (9.1/9.0/8.8/8.4) : BI, GL, AP,

AR, PO, AM, HRMS, Base benefits, Payroll.

PeopleSoft Development Tools: Tools (8.52/8.50/8.49/8.45): Application

Designer, People Code, Component Interface, Integration Broker/ Application

Messaging, Workflow, File Layout, Data Mover, Import Manager

Programming Languages: People Code, SQL, PL/SQL

Data Bases: Oracle 8i/9i/10g, SQL Server 6.5/7.0,2000, DB2, MS Access

Operating Systems: Windows 98/2000/XP, Unix

Reporting Tools: SQR, PS-Query, XML Publisher, Crystal Reports & PS/nVision

Integration Tools: Component Interface, File Layout

Administration Tools: Security, Mass Change, Process Scheduler, Work flow

EXPERIENCE HIGHLIGHTS

Accenture Services LLP, USA

Jan 2013 - Till Date

Accenture Services Private Limited, India

May 2011 - Dec 2012

Infosys Technologies Ltd, Hyderabad

Jun 2010 - Apr 2011

Franklin Templeton Investments, India

Jul 2008 - Feb 2010

Intelligroup Asia Private Limited, India

Jul 2007 - Jul 2008

Perot Systems, India

May 2006 - Jun 2007

Velodyne Technologies Private Limited, Hyderabad

Aug 2004 - May 2006

Cogent Technosoft Private Limited, Chennai

Sept 2002 - Jul 2003

PROJECT EXPERIENCE

Project PeopleSoft Financials 9.1 Maintenance (AR and Billing)

Client Highmark

Role Technical Lead

Organization Accenture Services LLP, USA

Duration Jan 2013 to Till Date

Environment PeopleSoft Financials 9.1 with Tools 8.51, Oracle 11i, SQL

Server, mainframes JCL, Unix

Team Size 15 Members

Project Description

. Onsite Project Lead and provide onsite offshore coordination and

ensure smooth functioning of the client business in PeopleSoft Finance

during post go live phase by meeting all expectation of the client as

per the Project scope defined.

. Worked closely with the Development team to get the Issues resolved

and the defects fixed for the RICE items.

. Supporting Technical members in executing customization in the

application by performing coordination with technical team members and

unit testing for proper delivery of developments.

. Manage all project activities and tasks, monitor progress and

technical issue resolution.

. Perform quality reviews of work products.

. Co-ordinate development activities with other technical groups and

projects.

Project PeopleSoft Financials 9.1 Production Support and

Maintenance (PRISM)

Client Highmark

Role Technical Lead

Organization Accenture Services, Hyderabad, India

Duration May 2011 to Dec 2012

Environment PeopleSoft Financials 9.1 with Tools 8.51, Oracle 11i, SQL

Server, mainframes JCL, Unix

Team Size 8 Members

Project Description

. Offshore Project Lead and provide onsite offshore coordination and

ensure smooth functioning of the client business in PeopleSoft Finance

during post go live phase by meeting all expectation of the client as

per the Project scope defined.

. Worked closely with the Development team to get the Issues resolved

and the defects fixed for the RICE items.

. Supporting Technical members in executing customization in the

application by performing coordination with technical team members and

unit testing for proper delivery of developments.

. Manage all project activities and tasks, monitor progress and

technical issue resolution.

. Perform quality reviews of work products.

. Lead and manage day-to-day technical activities including planning,

requirements definition and technical components of functional

specifications.

. Manage and report on support activities from offshore.

. Production support includes System testing, training in addition to

the day to day functional support to the client. Responsibility

includes coordination with client, functional analysis of issues

reported, executing scripts, coordination with technical team for

technical issues reported, arranging weekly meeting, providing

feedback to the client.

. Used Integration Broker for setting up the messaging nodes for the

third party systems.

. Work with team in preparing technical design and specification from

functional/business specifications.

. Ensure development adheres to established development standards. Work

with client team leads to review, update and publish development

standards.

. Responsible for presenting Daily status and maintaining logs of CR,

defects raised.

Project PeopleSoft Financials 9.1 Implementation (AR and Billing)

Client DowJones

Role PeopleSoft Consultant

Organization Infosys Technologies, Hyderabad, India

Duration Jan 2011 to April 2011

Environment PeopleSoft Financials 9.1 with Tools 8.51, Oracle 10g, SQL

Server, Quest Load

Team Size 24 Members

Project Description

. Successfully and timely documented (technical designs, test cases,

status reports), built, tested and released major client requirements

of project..

. Application engine for reading multi lingual data from xml file and

updating respective tables in PeopleSoft database. Ultimately data

gets populated in Custom product set up page.

. Worked on multi lingual RTF and XLF templates used by xml publisher.

. Coordinated with the team in understanding the requirements and in

development.

. SQL & People Code tuning to increase the performance of the conversion

processes that handle huge volume of data from legacy system (10

years).

Project PeopleSoft HRMS 9.0 Implementation (HR, Payroll, Benefits)

Client Charming Shoppe Inc

Role PeopleSoft Consultant

Organization Infosys Technologies, Hyderabad, India

Duration July 2010 to Jan 2011

Environment PeopleSoft HRMS 9.0 with Tools 8.49, Oracle 10g, SQL

Server, Quest Toad

Team Size 24 Members

Project Description

. Customized SQR reports, developed new reports and run control pages as

per the client's requirement.

. Developed PS-Queries and Application engines, and used XML publisher

for the report generation as per requirements.

. Created various Components, Records and Pages to include custom

fields, translate values, multi-level scrollbar, menu design,

components and People Code as per the specifications

. Developed a Payroll - GL Interface for the use of the 3rd party

vendors.

. Prepared Unit Test Plans and System Integration Test plans

. Coordinated with the team in understanding the requirements and in the

development.

Project PeopleSoft Financials 8.9 Production Support & Maintenance

(AR, GL, AP, AM, Billing, Procurement)

Client Franklin Templeton Investments

Role System Analyst

Organization Franklin Templeton Investments, Hyderabad, India

Duration July 2008 to Feb 2010

Environment PeopleSoft Financials 8.9 with Tools 8.49, Oracle 10g, SQL

Server, Control-M, Quest Stat, Unix

Team Size 12 Members

Project Description

. Production Support of Day-to-Day Financial and HRMS tasks

. Have fixed many Technical Issues raised in the production environment

within a short period of time

. Reviewing of the interfaces log files for errors

. Customized SQR reports, developed new reports and run control pages as

per the client's requirement.

. Developed and Modified PS-Query Reports, developed Adhoc queries, ran

the same to give the outputs to client as per user requirements.

. Involved in Data Base refreshment and tuning the App Server

performance.

. Addressed Performance issues on production machine.

. Modified existing/Created various Records and Pages to include custom

fields, translate values, multi-level scrollbar, menu design,

components and Peoplecode as per the specifications

. Used Quest STAT as a Change management and version control tool to

lock objects while migrating projects/people tools objects among the

different environments in the system.

. Customized Excel to CI program which helps the users for data entry,

responsible for configuration of the system in certain areas.

. Monitor UNIX and NT Servers and resolve in case of issues like

bouncing and administering.

Project PeopleSoft Financials 8.48 Development Support (AR, AP and

GL)

Client Broadcom

Role System Analyst

Organization Intelligroup Asia Private Limited, Hyderabad, India

Duration Nov 2007 to June 2008

Environment PeopleSoft Financials 8.48, SQL Server, Unix

Team Size 8 Members

Project Description

. Responsible for Customization of People soft objects based on

specifications using People Tools and People Code. Also customized

Reports, search records and pages.

. Have used Component Interface apps engine for data upload thru Excel,

Integration Broker for modifying message sync.

. Preparation and review of detailed design, Test plan and Test result

documents

Project PeopleSoft Financials 8.48 Production Support and

Maintenance (HCM, HR)

Client Gust

Role System Analyst

Organization Intelligroup Asia Private Limited, Hyderabad, India

Duration July 2007 to Sept 2007

Environment PeopleSoft Financials 8.48, SQL Server, Unix

Team Size 8 Members

Project Description

. Customized SQR reports, developed new reports and run control pages as

per the client's requirement.

. Developed Adhoc queries, ran the same to give the outputs to client as

per user requirements.

. Have fixed many Technical Issues raised in the production environment

within a short period of time

Project PeopleSoft Financials 8.4 Implementation (Reporting)

Client Vanguard

Role Technical Consultant

Organization Perot Systems, Bangalore, India

Duration April 2007 to June 2007

Environment PeopleSoft Financials 7.05, SQL Server, Autosys, Remedy,

Unix

Team Size 15 Members

Project Description

. Designed and delivered five variations of Aging report using SQR,

Queries in AP, AR and GL Using Query Manger.

. Customizing the existing nVision Layouts and upgraded to latest

version.

. Created the run control record and Pages, as it is required to run the

Reports.

Project PeopleSoft Financials 7.5 Production Support (GL,AP,AR,

Procurement, Billing)

Client Vanguard

Role Technical Consultant

Organization Perot Systems, Bangalore, India

Duration May 2006 to April 2007

Environment PeopleSoft Financials 7.05, SQL Server, Autosys, Remedy,

Unix

Team Size 10 Members

Project Description

. Analyzed problems resolved issues and participated in root cause

analysis.

. Administered Central knowledgebase and tracking Tool - Remedy to capture,

store and retrieve information and solutions for reuse, coordinated with

Client and Offshore team for issue resolution.

. Have used UNIX, to extract data from 3rd party systems Odyssey (Billing

system), Tune-Up (Ordering system), and Pyramid (Claims System) with

AUTOSYS to schedule batch process.

. Have automated dunning letter process in AR using SQR.

. Developed check layouts using Crystal Reports in AP.

. Automated daily exchange rate feeds.

. Developed custom PS query reports.

. Developed new GL based Matrix type nVision reports using trees, Time

spans, and scope variables and modified existing reports for automated

distribution to users.

. Created a pay cycle for the new Bank Account key, to be picked up by

nightly batch job for posting and payment creation.

Project PeopleSoft HRMS 8.8 Maintenance and Support (HR, Payroll,

Benefits)

Client Metlife Inc

Role Team Member

Organization Velodyne Technologies, Hyderabad, India

Duration Oct 2005 to May 2006

Environment PeopleSoft HRMS 8.8, SQL Server, Unix

Team Size 6 Members

Project Description

. Created new Records, Pages, Menus based on user specifications using

Application Designer

. Customized Records, Pages, Menus based on user specifications using

People Tools and People Code.

. Developed 3SQRs and 2 App Engines that upload data into Peoplesoft tables

. Developed several inbound and outbound SQR interfaces

. Prepared and reviewed compare reports identifying Custom SQR's,

Application Engine, Trees and Queries and analyzed its impact with team

. Prepared a user-training document including all the screen shots and

navigating process

. Customized the delivered SQR programs according to the user requirements

. Registered components with Portal registry. Provided Security through

Portal Registry.

. Designed and developed interface programs to migrate data using SQR as

the primary tool

. Configured Process Scheduler to run SQR reports and Application Engine.

. Used Process monitor to track the process run status.

Project PeopleSoft Financials 8.8 Maintenance and Support ( AP,

AR, Billing)

Client Calpine Corporation

Role Team Member

Organization Velodyne Technologies, Hyderabad, India

Duration Aug 2004 to Sept 2005

Environment PeopleSoft Financials 8.8, SQL Server, Unix

Team Size 8 Members

Project Description

. Involved in preparing initial design specifications.

. Developed new SQRs and modified existing SQRs for GL and AP modules by

conducting design and impact analysis.

. Created new Records, pages, Menus based on user specifications using

Application Designer and used people code for validations.

. Developed an interface SQR which pulls all of the values for each file

and create separate outbound files such as GL Combo Edit File, GL

Deptid File, and GL Account file in the specified path.

. Involved in debugging (to identify the problem), modifying, tuning the

SQR.

. Developed AP Balance Summary Report which generates a report that

contains Details like Invoices closed, Invoices deleted, Total

invoices deleted and added, Discount details, Net Payment and Net

Activity etc.,

. Involved in regular peer review meetings.

Project PeopleSoft HRMS 8.4 Implementation (HR, Payroll, benefits)

Client Alaska Airlines

Role Team Member

Organization Velodyne Technologies, Hyderabad, India

Duration Aug 2003 to Jul 2004

Environment PeopleSoft HRMS 8.4, SQL Server, Unix

Team Size 12 Members

Project Description

. Customizing & Designing Pages, Components and Menus.

. Added new fields to the existing pages and modifying the field

formats.

. HR Data Audit Report is being generated from custom SQR

. Responsible for developing and modifying SQR reports for Base

benefits.

. Developed and modified several Reports for Payroll, Payroll summary by

deptid, location and modified direct deposit report.

. Configured Process Scheduler to run SQR reports and Application

Engine.

. Performed analysis and designing of the technical specifications.

. Modified several custom SQRs.

. Added full-time, part-time fields to the employee vacation balance

report which is generated by an Interface SQR

. Used people code to hide unwanted fields for some pages.

. Developed Run Control Pages and attached to menu to run the SQR

online.

. Responsible for debugging (to identify the problem), modifying, tuning

the SQR.

. Coordinated with developers, users and testing team in various

purposes to improve the quality of the PeopleSoft application

Project Testing

Client Cogent Technosoft

Role Team Member

Organization Cogent Technosoft, Chennai, India

Duration Feb 2003 to Jul 2003

Environment Win Runner

Team Size 4 Members

Project Description

. Understanding of functional specifications and involvement in Test

Planning.

. Reviews of Test Specs, Templates and Documentation.

. Execution of Test Cases and reporting of defects.

. Testing Load and Performance.

. System Testing.

Project Testing

Client Cooper Industries

Role Team Member

Organization Cogent Technosoft, Chennai, India

Duration Sept 2002 to Feb 2003

Environment Manual Testing

Team Size 4 Members

Project Description

. Involved in Designing Test Cases.

. Performed Functional testing, Regression testing.

. Performed System testing, Integration testing to ensure the correct

functionality of the modules.

. Preparing Defect Reports & Test Report Summary documents.

. Sending weekly report to Project Leader regarding the testing and bug

status.

EDUCATION, TRAINING & CERTIFICATIONS

> Andhra University, Andhra Pradesh, India

Masters of Computer Application in 2001

> Andhra University, Andhra Pradesh, India

Masters of Business Administration in 2011

[pic]



Contact this candidate