Project Sql Server

Professional Summary:

* ** years of extensive experience in Systems Analysis, Design,

Development and Implementation of various applications.

* 9 years of experience with strong Functional/Technical expertise in

the PeopleSoft Financials/SCM/CRM/HRMS modules General Ledger,

Accounts Payables, Receivables, Billing, Inventory, Purchasing,

eProcurement, Asset Management, Commitment Control, Expenses,

Project Costing, Grants, Contracts, Cash Management, PeopleSoft

CRM(Customers/Sales/Order Management) and PeopleSoft HRMS.

* Proficient with Internet Architecture, Portal Technology, and

Development tools such as Application Designer, Application Engine,

Workflow, PeopleCode, Integration Tools like Application Messaging

using Integration Broker, Component Interfaces and Business

Interlinks. Administrative Tools like Process Scheduler, Process

Monitor, Data Mover, Import manager, Tree Manger for Security and

Reporting Tools like nVision, PSQuery, Crystal Reports and SQR.

* Worked in developing front-end/web applications using VB 6.0/. NET,

Java having excellent knowledge in RDBMS concepts including writing

stored procedures and performance tuning SQL.

* Outstanding Communication, interpersonal skills and excellent team

lead/player, good independent performer, Organized and Hardworking.

Training & Certifications:

Corporate Training in People Tools

Corporate Training in Accounting and Financial Reporting

Certified People Tools 8.4 from Brainbench. Transcript ID #:2771552

Technical Environment:

Operating Systems Windows XP/2000/2003/NT/98, Unix/Linux.

Software PeopleSoft 8.x/ 7.x, People Tools 8.x/ 7.x,

Visual Studio 6/. NET, MS Project.

Databases MS SQL Server 2000, Oracle 10g/9.x/8.x/7.3,

AS400/DB2, MS-Access.

Integration Tools Application Messaging, Component Interfaces,

Business Interlinks, Integration Broker, STAT

(Quest Software).

Reporting Tools Crystal reports with Crystal Enterprise

8.5/9.0/10.0, nVision, SQR.

Programming Languages Pascal, COBOL, C, C++, C#, Java, Visual Basic,

SQL, PL/SQL, People Code.

Tools & Scripts HTML, XML, JavaScript, VBScript.

Application Servers BEA Tuxedo/Jolt, Weblogic, IIS.

Professional Experience:

Cushman & Wakefield Inc, NY

Dec'08 - Till Date

PeopleSoft Financials Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.9 (GL, AP, Banking, Cash

Management, AR, AM, Expenses and Project Costing), AS400/DB2, Outlooksoft

CPM 4.2, PeopleTools 8.47, Crystal Reports, SQR, SQL Server 2000 and

Windows 2003.

Major Assignments:

Production Support:

> Worked as Lead Analyst in gathering the requirements and prepare the

functional/Technical specifications for the enhancements/fixes and

assign it to the technical team.

> Provided Funtional/technical support and assists the user groups in

better utilization of the system and assist the technical team to

troubleshoot and resolve the issues.

> Communicate changes, enhancements, and modifications - verbally or

through written documentation to the project team.

> Establish practices and procedures that work towards the continuous

improvement of ongoing application support and functional aspects of

the software development life cycle.

> Implemented control groups in AP and conducted user training for batch

invoice processing.

> Provided functional support to Expenses Issues with multi currency

transactions, AP user group in payment processing (Paycycles) and ACH

related issues.

> Worked on closing the history open vouchers in Accounts Payables

module by running pay cycles and generating journals to cleanup and

improve the performance of month end activities.

> Implemented GL achieving along with resolving the functional issues

related to open items resulting huge performance gain in GL posting

and also on nVision Reports.

> Lead the implementation and customization of Journal Workflow with

Inter unit processing.

> Involved in troubleshooting Spreadsheet Journal Import tool JRNL1.xls.

> Extensively worked on troubleshooting the delivered allocation

application engine program (FS_ALLC) and also FS_JGEN, the journal

generator in GL.

> Developed and modified nVision layouts for new reporting requirements

and also changed the visual basic macros in the Excel layouts.

> Designed and developed the Migration strategy and documentation and

suggested the long term plan.

Treasury (Banking & Cash Management):

> Configured the Banking module and setup of bank accounts, payment

forms and Bank reconciliation.

> Follow up with bank and troubleshoot the BAI file format issues with

the bank and setup scheduling of external transactions download to

Banking Module.

> Setup and reconfigured the statement accounting, accounting rules and

accounting entry templates for Bank Statement accounting.

> Implemented Treasury module for external bank transactions and setup

of automated treasury accounting to create accounting entries.

> Created and configured the Journal Generator templates to integrate

Treasury with General Ledger Module.

Cushman & Wakefield Inc, NY

Mar'07 - Nov'07

PeopleSoft Financials Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.9 (GL, AP, AR, AM, Expenses and

Projects), AS400/DB2, Outlooksoft CPM 4.2, PeopleTools 8.47, Crystal

Reports, SQR, SQL Server 2000 and Windows 2003.

Major Assignments:

Integration with ADP and Outlooksoft CPM:

> Designed and developed the strategy and plan to integrate the General

Ledger with Outlooksoft CPM (Global Consolidation and Reporting

system). Involved in reconciliation and fixing the configuration

issues on both the systems.

> Configured the outlook soft CPM database/analysis server for server

maintenance jobs for performance and sync with other systems.

> Involved in integration of PeopleSoft HRMS payroll with ADP. Worked on

ADP connector and also Payroll Changes Report.

Major Bundles Update & Infrastructure Upgrade

> Lead the team to review Compare reports for analyzing the

customizations and PeopleSoft changes in the bundles environment.

> Designed the strategy/plan for update the bundles from bundle 5 to

bundle 15 and involved in assisting DBA in developing DMS/SQL scripts

for specific objects.

> Re-engineered the existing interfaces To/from PeopleSoft General

Ledger, AR, AP and Projects modules to AS400 commission system.

Assisted the DBA.

> Assisted the team in reapplying and reengineering the customizations

in the bundled environment.

> Did analysis, design and development of various customizations using

Application designer.

Cushman & Wakefield Inc, NY

Mar'06 - Feb'07

PeopleSoft Financials Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.4/8.9 (GL, AP, Banking, AR, AM,

Expenses and Project Costing), AS400/DB2, PeopleTools 8.45/8.47, Crystal

Reports, SQR, SQL Server 2000 and Windows 2003.

Major Assignments:

Upgrade from 8.4 to 8.9

> Involved in discussions with the team to review Compare reports for

analyzing the customizations and PeopleSoft changes in the upgrade

environment.

> Designed the strategy/plan for Upgrade from 8.4 to 8.9.

> Redesigned the applications to accommodate the complex business

process needs.

> Conducted fit-gap sessions with the user group and identified the

issues related to the features previously implemented and the delta

features with upgrade.

> Constructed testing team in preparation of Test Plan, Test Case for

Module - General Ledger, Accounts receivable and Project Costing.

> Designed the new enhancements for existing interfaces To/from

PeopleSoft General Ledger, AR, AP and Projects modules to AS400

commission system. Assisted the DBA in troubleshooting the

ODBC/connectivity issues between PeopleSoft and AS400 DB2 Server.

> Designed the interface from Commissions to Project Costing module to

load the project transactions.

> Reconfigured and troubleshoot the Expenses to Project Costing

(PC_EX_TO_PC), Accounts Payables to Project Costing (PC_AP_TO_PC)

Interface programs.

> Involved in setup/configure PERSON_BASIC, WORKFORCE synch with HR

application using Integration Broker. Worked on troubleshooting and

documenting the configuration changes. Developed the log term

maintenance plan to clean up Integration Broker messages queue to

improve performance.

> Reconfigured the AP Pay cycle and Crystal Check, Check printer for

digital Signatures also configured and customized the EFT and Positive

Pay File/report to generate unique files to send to bank.

> Reconfigured & troubleshoot the 1099 withholding setup (Withholding

class, codes and IRS withholding entity) and 1099 reporting.

Redesigned the 1009 report SQR program APY1099 as per the

requirements.

> Reconfigured the Allocation configuration steps to fix the post

upgrade issues.

> Assisted the team in reapplying and reengineering the customizations

and helping the team in understanding the new features in the upgrade

environment.

> Designed the component interface/app engine programs to load assets

and also for Expense reports status changes for pre and post upgrade

process.

> Extensively worked on troubleshooting and customizing the AP to AM

interface and Transaction loader program in Asset Management.

> Resolved tree related issues with nVision layouts/reports and report

books in GL. Used the tree audit/repair utilities to correct the tree

levels/nodes.

> Improved the performance of nVision reports drastically by changing

the tree options/Layouts and views. Created new indexes on GL Tables

to further improve the performance of nVision Reports, Drill downs and

designed a long term plan for nVision reports performance.

Time Inc, NY

Apr'05 - Feb'06

PeopleSoft FIN/CRM Reporting Consultant

Environment: PeopleSoft Financials/CRM 8.0/8.8 (AR and Billing), ADMARC,

PeopleTools 8.21/8.45, Crystal Reports, SQR, Oracle 9i, HP UNIX, Windows

2000.

Major Assignments:

AR and Billing:

> Worked on Technical Designs on Customizations and Reports in Accounts

Receivables and Billing Modules.

> Developed and customized Aged receivables Summary/Detail by unit SQR

reports in Accounts Receivables.

> Involved in Customization of the SQR interface program to generate GL

accounting entries and generate the summary report for each invoice in

Billing Module.

> Developed and Customized the Customer Statement SQR program and

customized the run control records, pages, components and menus

accordingly.

> Developed SQR programs to convert customer set up data from legacy

system to PeopleSoft in Accounts Receivables.

> Involved in developing conversion programs and customizing the

interfaces for open/miscellaneous payments into Accounts Receivables.

> Involved in troubleshooting AR_UPDATE process, which is used to

process and update customer balance and history information,

corresponding item information, and item activity.

> Developed and used extensively data mover scripts to migrate customer,

item balances and information between different environments in

Inventory and AR modules to sync all environments.

> Involved in Upgrade Fin Tools/Application from 8.0 to 8.8. Extensively

worked on re-migrating the customizations, comparing the objects,

troubleshooting the reports (SQR, Crystal, PS Query).

> Extensively used STAT (quest software) for migrating the

customizations and fixes.

CRM:

> Worked on Technical Designs, Data Mapping and Test Conditions for

validation of converted data from the legacy system ADMARC to

PeopleSoft tables.

> Designed the complex validation Reports (PSQuery, SQR) for CRM orders

and sales.

> Developed complex records/views to validate the order capture and

sales information for multiple currencies.

> Implemented row level security at Business Unit Level for PeopleSoft

Queries by defining row class, permission lists.

> Created and customized the Query Access Groups and Security Trees for

Business Office users.

> Extensively used the database links to PS Financials from CRM for the

detail payments information of the billed orders.

> Developed the SQR report for Revenue Cash-flow report for any

accounting period for all Publications.

> Extensively worked on performance issues by analyzing/ modifying the

existing Records, Pages and also implemented the right execution plan

across all the environments.

> Prepared Design document and the user/technical documentation and also

the migration/upgrade documentation.

Turnpike Project 2B1, NJ Sep'04 -

Mar'05

PeopleSoft FIN/SCM/HRMS Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.8 (General Ledger, Commitment

Control, Inventory, OM, Purchasing, eProcurement, AP, AR and Asset

Management), PeopleSoft HRMS(Benefits Administration, Time & Labor, Base

Benefits and Position Management-recruit) PeopleTools, Crystal Reports,

SQR, nVision, Oracle 9i, HP UNIX, Windows 2000.

Major Assignments:

Financials/SCM:

> Worked on Functional/Technical Designs, Data Mapping and Test

Conditions for converting the legacy data into PeopleSoft tables in

GL, AR, AM, AP.

> Designed SQR Programs to convert General Ledger Balances from Legacy

system and generated Journals to accommodate the year-end closing

process in GL. Used extensively the Journal import batch process using

xml.

> Designed the reports for Balance sheet, Detail GL transactions using

nVision, crystal and SQR.

> Used Integration Broker to define and troubleshoot Gateway nodes,

Connectors and FTP/HTTP Nodes to set up Flat file import and

processing for Bank Statements and Commitment control Budgets.

> Setup and Configuration of the Commitment Control to deal with Budget

Transfers/Adjustments, Revised Budget, Actual Expenses, Encumbrances

and the corresponding Budget Balance.

> Developed the Test Plan, Test Case for Module - General Ledger and

Commitment Control.

> Designed Component Interface/Application Engine programs with file

layouts for Vendor, Item conversion in Inventory module using flat

files.

> Developed SQR programs to convert customer set up data from legacy

system to PeopleSoft in Accounts Receivables.

> Resolved connectivity and performance issues with nVision reporting

and report books in GL.

> Resolved tree related issues with nVision layouts/reports and report

books in GL. Used the tree audit/repair utilities to correct the tree

levels/nodes.

> Customized the Pay Cycle by defining new steps and including them into

Pay Cycle. This included the process, which I developed to generate

the positive pay file for the payments.

> Customized the PeopleSoft delivered SQR process for Depreciation

calculation and involved in troubleshooting copy asset functionality

for owned assets in Asset Management Module.

> Worked extensively in setting up FTP, flat file import and customized

accordingly the Budget Import Application Engine process KK_JRNL_IMP

in General Ledger/Commitment Control.

> Involved in setting up importing Bank statements and Bank

reconciliation in Accounts Payables and also involved in

troubleshooting with formatting issues in BAI, BAI2 and PSBD1.

> Customized the delivered crystal AP checks, advices and positive pay

file crystal reports and resolved the issues for printing digital

signatures and micro font on checks.

HRMS:

> Involved in developing conversion programs and customizing the

interfaces for open payments from PeopleSoft HR Benefits module into

Accounts receivable.

> Involved in customization and configuration of PeopleSoft HRMS system.

> Involved in customizing the Base Benefit plan, programs Involved in

changes like adding customized translate values, modifying People

Code, adding fields to pages and modifying Components, menus and used

PS Query to fetch data according to Requirement

> Worked on interfaces between Benefits and Time & Labor, Designed /

developed interface from PeopleSoft to Benefits Provider and from

Benefit Providers to PeopleSoft using SQR's.

> Wrote People Code as per the requirement on different events to

implement the Business rules and validations.

FHCRC Seattle, WA

Nov'02 - Jul'04

PeopleSoft Technical Consultant

Environment: PeopleSoft Financials 8.42 (Grants and Contracts, Commitment

Control, Project Costing, GL, AP, AR/ Billing, Purchasing and eProcurement)

PeopleTools, Crystal Reports 8.5/9.0/10.0, Crystal Enterprise

8.5/9.0/10.0,VisualBasic.NET, SQR, nVision, MS SQL Server 2000, Windows

2000.

The Project is aimed at the implementation and customization of PeopleSoft

Financials 8.4 and Crystal Enterprise 8.5/9.0.

Major Assignments:

Grants, Contracts and Projects:

> Involved in configuring the contacts structure and customizing Notes

page for Internal Contract Components.

> Customized the milestone page to trigger email notifications and

implemented security using milestone classifications in grants and

contracts.

> Configured linking Projects with Budgets and General Ledger. Worked on

Billing and Internal Charge Backs with Project Costing.

> Developed Crystal Reports for Award Details, Project Monitoring,

Commitment Control Budget Transactions and Milestones.

General Ledger, Commitment Control, AP, AR, Billing and Purchasing:

> Customized the Application Engine GL_EXEL_JRNL, the journal import

process, Journal

Generator to modify the default chart fields.

> Configured the delivered nVision templates by modifying Chart fields,

Trees, Tables, Views, PSQuery objects and adjusted nVision layouts

according to the changes.

> Extensively worked on Commitment Control to deal with Budget

Transfers/Adjustments, Revised Budget, Actual Expenses, Encumbrances

and the corresponding Budget Balance.

> Developed the Crystal Reports for Commitment control status /

commitment control detail transactions.

> Developed complex stored procedures for crystal reports and

implemented system security.

> Customized the delivered AP Checks, Advices, Trial register and Match

Exceptions report.

> Developed and customized crystal invoices in billing module according

to the functional specifications.

> Customized the delivered grants invoice SQR process to modify the

company logo, the format changes and also fixed the calculation of

cumulative amounts by contact number.

> Customized Crystal Enterprise Reporting Portal and developed aspx

parameter pages using VB.NET to facilitate the complex parameters

mechanism.

> Proposed design of Data warehouse to develop OLAP reports to meet the

wide range of requirements

> Prepared design and technical documentation.

Saras America, Inc. Farmington Hills, MI

Jul'00 - Sep'02

PeopleSoft Consultant

Environment: PeopleSoft Financials 7.0, PeopleTools 7.0, nVision, Crystal

Reports 8.0, SQR, SQL Server 7.0, Windows NT Server.

Major assignments:

> Gathered software development requirements. Performed analysis, design

and implemented various projects floated by Saras America Inc.

> Designed and developed the programs, ETL scripts necessary to migrate

data from legacy system into the database using SQL/PL SQL Scripts and

data mover scripts.

> Performed customization of multiple PeopleSoft 7.0 Financials

(Inventory, AR, GL, AP, PO, and Billing) modules.

> Created panels, records, menus, interface/conversion programs, and

reports using PeopleTools, PeopleCode, SQR and nVision.

> Modified and customized the delivered SQRs for interface reports in

the Asset Management, Inventory, Account Receivables, Account Payables

and Purchasing modules

> Modified the conversion reports using SQR in the General Ledger,

Accounts Receivables, Billing, Asset Management, Inventory, and

Purchasing modules

> Created Security Options and Security Views, as well as applied

Security Setups Performing customization of Row-Level Security.

Institute of Health Systems India

Nov'98 - May'00

Software Developer

Environment: Microsoft Visual Basic, Java, MS Excel, IBM Lotus Spreadsheet,

MS SQLServer, MS Access, Windows 95/98.

Institute of Health Systems is a Professional organization with multi

disciplinary experience in the computer software field in Industries such

as banking, cement, Hospital. PRISM project was developed for the research

and analysis of the Cause of Death Study, which forms an important part of

the various faculties of research, being carried out at The Institute of

Health Systems (IHS).

Major assignments:

> Involved in Designing, Coding, Documentation and Planning Technical

implementations.

> Implemented with a wide range of user requirements and also enables

functionality using several data sources.

> Written the procedures and functions to import data from platforms

such as Fox Pro databases and also from medical software such as EPI

Info developed by the World Health Organization, Geneva.

> Implemented the sections such as sections like Dictionary Maintenance,

Acquiring Data, Investigation of Data, Review of Records and

Statistics Generation.

> Created reports according to RGI Format and various Age Groups and

Online Help, which span across several menu items in the application.

> Incorporated the decentralized mode of operation, where various users,

generating statistics, printing reports or inputting data to the same

database, stored centrally in the IHS Server, can use it.

> Prepared Design document and the user/technical documentation.

Education:

> Bachelor of Science in Electronics.

> Mater in Computer Applications.

Contact this candidate