Professional Summary

• More than 23 years of IT experience US with specialization in the field of Data Warehousing, Business Intelligence and Business Analysis.
• Over 6 years of experience in Business Objects Enterprise Suite, Broadcast Agent Server, Publisher, Supervisor, import wizard and Info view.
• Involved in full life cycle BW implementations along with other Post-Implementation and Post Maintenance projects in SD MM and FI/CO functional areas.
• Extensively worked on Customer generated application specific generic extractors LIS, LO, CO-PA and standard SAP BW/BI business content.
• Worked extensively on Administrative Workbench AWB /Data Warehousing Workbench DWB for Data Modeling, Scheduling and Monitoring data loads.
• Proficient of various data design models - Entity Relationship ER , Multi Dimensional/Star Schema and Extended Star Schema models.
• Extensive experience in SAP BW/BI components like InfoCubes, Multi-Cubes, InfoSource, InfoPackage, Data source, InfoObjects, ODS DSO , Update rules, Update routines, Transfer rules, Transformations, DTP.
• Expert in Performance tuning using Aggregates, Rollup, collapse, Partition, Repartition and Compression.
• Strong hands-on experience in BW/BI front-end and back-end development with a deep understanding of the SAP BW/BI tools and techniques.
• Expertise in designing Universes, WebI Reports, Deski reports, and Full Client Reports.
• Experience in installation and configuration of Business Objects and Web Intelligence, creation of repositories with user groups and security implementation.
• Expertise in Business Objects XI R2/3 CMS, Universe design, Scheduling, Import wizard, Publish wizard, Lifecycles manager, Desktop Intelligence, and Web Intelligence.
• Extensively worked on Business Objects 3.1, Business Objects XI R2,Crystal reports XI R2, Xcelsius2008, Dash Board builder.

Professional Experience

Confidential

Role: BOBJ lead Developer/Data Modeler/Functional.

Environment: BO 4.0,Web I, sap Hana studio, SAP BW 7.30

• Description: It a Fortune 500 services provider company based in Confidential is a specializes in services sector provider, providing SD services to Numbers company like HP, Apples, SanDisk.andservice provides to millions of customer around the world.
• Gathered requirement, analyze sap standard BI content and data models, and performed Gap Analysis and added new functionality in the areas of Finance Controlling, sales Distribution, Material Management.
• Walk through end-to-end scenario with the client showing how you can combine your Business Objects business intelligence tools with sap BI financial management report to optimize the organization's financial situation.
• Explore SAP BI reports, Spending Analytics to delve into your procurement activities and pinpoint how much you're spending, with which suppliers, and on what materials. Establish procurement key performance indicators KPIs , conduct in-depth analyses of your procurement spend, and generate meaningful business intelligence that will help you identify your biggest cost savings opportunities and determine where you have the greatest negotiating power with your supplier.
• Explore SAP BI/BO reports, on Sales Distribution and Material Management analysis, Base on Sales order, Delivery's, Return's Billings, MAP, POD, Fulfillments.
• Design comprehensivereport that shows you how to incorporate financial, sales, and purchasing data in the same SAP BW report to glean the overall business implications of your financial activities and decisions.
• Involved in performance tuning of infoset multi-provider and also in enhancement features of info-cube like partitioning, Indexing, maintaining aggregates and compression.
• Extensively worked on BEx-Analyzer and create BEx-Queries, Exceptions, Conditions, Calculated Key Figures, and Restricted Key Figures.Generate universe on Top of BEx Query, DevelopedWebI report,and Implemented Process Chain to automated Entire system including data load, BEx broadcaster.
• Given expert recommendations for how to incorporate more comprehensive SAP BI slice-and-dice capabilities directly building advance feature in WebI report. Build, execute, and link complex calculations so that your reports generate more detailed analyses and results.
• Work on KPI Metrics, formulas, both simple and complex, for rolling up granular income statement data into higher level intercompany balance sheets using SAP BW. Move from standard balance sheet and income statements to detailed reports that include financial ratios and KPIs such as return on assets, inventory turns, and return on investments.
• Provide a better understanding of how best to generate month-end financial reports, including cash flow reports, Balance-sheet, income statement.
• Created universe using star schema data model.
• Designed Universe by creating the Business Objects data model selecting and providing joins between the tables, Indicating cardinalities.

Confidential

Role: Tech-lead/BO Developer/Universe Designer

Environment: BO XI R3 Import Wizard, WebI, Teradata, sap BI.

• Description: It a Fortune 500 health care services company based in Confidential. specializes in health care supply chain services, providing pharmaceuticals and medical products to more than 40,000 locations each day.
• Lead the team as Tech-lead, design and architect universe and WebI reports, address performance and capacity issue, and carry out upgrades and patches, resolved data issue migrating from ECC to SAP BI, to Teradata.
• Follow SAP best practices in model design, universe creation, and business object report development.
• Implemented Row Level Security in Business Objects. And provided the security access management by creating users/groups/folders, and given the access rights to the available set of users based on their profile Based on Sales hierarchy .
• Worked on Business Objects universe-designer base on Kimball methodologies, creating semantics Layers on-top-of Teradata, with Class objects having business naming conventions, hierarchies, aggregate awareness, Cascading LOV, creating new derived objects, shortcut joins, defined alias tables and Contexts to resolved loops, fan and charms trap.
• Worked with scope of analysis to give more details on the results returned by each of the objects in a query.
• Extensively used Formula Variables, and Used the Slice and Dice feature.
• Design/build combinedqueries on the same/different universe, build union/ intersection/ minus Query between Combined Query.
• Design functionalities like Breaks, Filters, Query Prompts, Conditions, Alerts, Ranking, Sorts and highlighting data.
• When designing the Universe and building WebI report all care was taken of performance.
• Wrote complex freehand SQL in Teradata and Compare report test result.
• Created universe using star schema data model.
• Designed Universe by creating the Business Objects data model selecting and providing joins between the tables, Indicating cardinalities.

Confidential

Role: BO lead Developer/Universe Designer/Data Modeler

Environment: BO XI R3 Import Wizard, Lifecycle Manager, Web I, Visio, Rational Rose, Oracle 10.2

• Description: Confidential project is for State of New Jersey, purpose to bring is decentralized legacy system in centralized consolidated system, The current systems were designed to support many of the existing public assistance programs and meet the objectives established for these programs at the time these programs were implemented. Current systems cannot accommodate the increased diversity, complexity, and mandates associated with the administration of public assistance programs since theimplementation of welfare reform.
• Conduct Business Users Interface, participated in the business meetings and prepared business requirement documents BRDs , detail design document DD . During the BRDs development period, certain outstanding critical issues, decision not made for items were resolved thru email and extra business meeting were conducted.
• Gathered business requirements from each individuals and prepared conceptual data model and technical High Level design documents in MS Visio.
• In design Data modeling build structures and relationships between them, created data elements using in rational Rose 7.0
• Expertise and hands-on in advanced data modeling techniques, including star schemas, Kimball methodologies ETL strategies.
• Studied existing reports Legacy system from different system, and consolidate those reports in different category, with help of existing reports build functional technical model.
• Build indexes, primary foreign key and joint relation with DIM and Fact Tables.
• Allocated and manage Table spaces with data volume and the traffic load.
• When designing the modeling all care was taken for performance.
• Worked on Business Objects universe-designer suite including, creating semantics Layers, with Class objectshaving business naming conventions,hierarchies, aggregate awareness,Cascading LOV, creating new derived objects, shortcut joins, defined alias tables and Contexts to resolved loops, fan and charms trap.
• Follow SAP best practices in model design, universe creation, and business object report development.
• Have experienced in Designing/developing/maintaining Business Objects Universes.
• Created advanced and complex Business Objects WebIreports using Universes, Used the Drill Down/Up functionality to analyze data in Web I. Used Drill filters statement with open document.
• Wrote complex freehand SQL in Oracle Plus and used EXPLAIN PLAN to fine tune the query.

Confidential

Role: BO Developer/Universe Designer

Environment: BO XI R3 Import Wizard, Lifecycle Manager, Designer, WebI, Crystal.

• Description: Confidential, formerly Cebridge Connections, is a top-10 cable broadband services provider in the United States with approximately 1.3 million subscribers.Sudden link operates in 19 states in primarily medium-sized communities. Design Universe and developer WebI reports for aIDL module which is a part of IDO and ICOMS system.
• Designed and developed universe using universe designer for ICOMS system, and tested and fixed issues identified and know with prior universe.
• Experience creating advanced and complex Business Objects reports using Universes,Used the Drill Down/Up functionality to analyze data in WebI. Used Drill filters statement with opendocument, Added Hyperlinks with Drillfilters parameters for master/detail report analysis.
• Created complex reports using the multiple data providers and join and synchronized the data providers by linking the common objects to create the common report.
• Done the report format changes and fixes issue which were prior WebI and Crystal reports. And documented the universes/report changes and fixes.
• Created, managed format standard, master/detail reports with Crosstabs, Vertical/ Horizontal Tables. Work with advance features like set Section and subsections, merge dimensions, add Query and Combined Query.
• Worked with scope of analysis to give more details on the results returned by each of the objects in a query.
• Extensively used Formula Variables, and Used the Slice and Dice feature.
• Design/build Combined queries on the same/different universe, build union/ intersection/ minus Query between Combined Query.
• Design functionalities like Breaks, Filters, Query Prompts, Conditions, Alerts, Ranking, Sorts and highlighting data.
• Troubleshoot and provided quick resolutions to development and production issues.
• Implemented Row Level Security in Business Objects. And provided the security access management by creating users/groups/folders, and given the access rights to the available set of users based on their profile.
• Maintained development and Production BOE environment and used import wizard Lifecycle manager, formoving the objects from development box to production box. Overcome the Issue of CUID in different Landscapes.
• Done performance in WebI, universe designer and fine tune query performance, with help of Explain Plan in oracle.
• Wrote complex freehand SQL in Oracle and used EXPLAIN PLAN to fine tune the query.

Confidential

Role: SAP BI/BO Developer

Environment: BO XI R3 Import Wizard, Lifecycles Manager, BO IntegrationKit , Universe Designer.

Description:Confidential international portal, leader in cosmetics and beauty : make-up, coloration, fragrances Patents and innovations from the scientific. The effort required a staff of 18 - including team leaders, data base technicians, programmers, test region coordinators and administrators at multiple locations. Projects were delivered on time, within budget, and with a high degree of accuracy as measured by ever-improving client satisfaction evaluations.

Responsibilities:

• Successfully Integrated Business Objects BOBJ XI R3 with the SAP Business Intelligence 7.x SAP R/3 with development and Production environment using SAP Integration Kit.
• Developed KPI reports for management to make intelligent decision about their business and scheduled operational reports for Operation team to monitor day-to-day business activities.
• Create Designed BO Universes on sap Bex query and InfoCubes, created WebI dashboards and published reports on the SAP BI portal.
• Analyzed and documented existing business process steps and recommended new or improved processes utilizing BI as reporting solution.
• Gathered Business intelligence requirements and client reporting needs/specifications in area of SD, MM FI, performed technical installation and integration of Business Objects XI 3.x with SAP ECC/SAP BW.
• Designed and developed architecture with logical data models, Info cubes and Multi cubes for Sales and Distribution, Purchasing, Material Movements, Plan Independent Requirements, Profitability Analysis COPA , Inventory Valuation and Point of Sales POS .
• Used the Drill Down/Up functionality to analyze data in WebI.
• Created, managed format standard, master/detail reports with Crosstabs, Vertical/ Horizontal Tables. Work with advance features like set Section and subsections, merge dimensions, add Query and Combined Query.
• Worked with scope of analysis to give more details on the results returned by each of the objects in a query.
• Extensively used Formula Variables, and Used the Slice and Dice feature.
• Design/build Combined queries on the same/different universe, build union/ intersection/ minus Query between Combined Query.
• Design functionalities like Breaks, Filters, Query Prompts, Conditions, Alerts, Ranking, Sorts and highlighting data.
• Done Dashboard Builder with Interportlet communication capabilities and exchange information betweenXcelsius, and WebI Documents.
• Create Xcelsius dashboard using FS-command and Flash variable to configure an Xcelsiusdashboard for linking source Target in dashboard builder.
• With Live office and QAAWS Query as a Web Service used dynamic variable forXcelsius Dashboard creation.
• Implemented Row Level Security in Business Objects. And provided the security access management by creating users/groups/folders, and given the access rights to the available set of users based on their profile.
• Maintained development and Production BOE environment and used import wizard Lifecycle manager for migrating the objects from development box to production box. Overcome the problem of CUIDin different environment.
• Used extractors New General Ledger FI-GL , Segment Reporting FI-GL , Profit Center Reporting FI-GL , and flourished financial management reports high level Balance sheet, income statement, cash flow statement, and G/L Account Balance Analysis , analyzes G/L account balance basis on opening, debit, credit, total using sap standard BEx, Crystal 2008, Live office and dynamic data refresh Xcelsius 2008 dashboard.
• Generate Business Objects universes info cube 0OPA C30 and 0OPA C20 analysis report like Orders: Actual/Plan/Variance - Statistical Key Figures, Cost Elements, Breakdown by Period and partner, Actual/Plan/Variance Totals, Budget/Actual/Commitments and Actual Line Items.
• Designed the architecture and lead the development of data providers and reports on the CO-PA Transaction Data in BI 7.0
• Used extractors CO-PA Transaction Data S GO 0CO PA 10 , and generate reports like PA Net sales Analysis , Contribution Margin I and II, Operating Profit Analysis CM I II and published WebI reports on enterprise portal environment.
• Done performance tuning in all stages of BI developments from Extractor to implementation.
• Done SAP BI performance in area query performance, data load performance and web application performance and DB-Specific Performance.

Confidential

Role: SAP BW Developer

Environment: BW 3.5, Oracle 9i, UNIX, BEx, WAD, BEx Query, BEx Analyzer

Description:Confidential is a Pharmaceutical Company base in Indianapolis, As a leading innovation-driven corporation, Confidential is developing a growing portfolio of pharmaceutical products to meet some of the world's most urgent medical needs. Some of the product like Cancer, Cardiology, Cardiology/Pulmonary, Diabetes, Neuroscience.

Responsibilities:

• Core responsibility is Preparation of Data flows, functional feasibility analysis, Business Blue Print, activity execution, Preparation of cutover activities and Post go live support.
• Gathered requirement, analyze and translate business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Develop and maintain project schedules including activities, resources, hardware, internal and external partners. Produce and deliver presentations to executives concerning project progress, issues, and risks.
• Performed Gap Analysis after studying existing system and gathering Business Requirements from end-user for Sales Distribution SD and Account receivable AR .
• Responsible for gathering requirement and performed Gap Analysis after studying existing system contract AR alternation to Business content, and added new functionality in Dunning and FI-CA: Open Items. Line Item Extractor for General Ledger Accounting.
• Develop Design document in area of extractor alternation A/R line, A/R transaction, and payment history.
• Designed and maintained Sales InfoCube, DSO, InfoObjects, and Data source. Enhanced Business Content Data source as per requirements. Extracted Sales data using Logistics Cockpit LO Cockpit , and Scheduled data loads, both for delta and full uploads.
• Created enhanced existing transfer rules, transfer routines, update rules, start routines to maintain data consistency.
• Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals.
• Implemented CO-PA for profitability analysis to meet use requirements.
• Created MultiProvider for logical integration of Sales Distribution InfoCube and ODS.
• Implemented Process Chain to automated Extraction of Data from R/3 to Sales and Distribution SD InfoCube and ODS in BW.
• Worked extensively on both-end of Enterprise Data Warehousing bank-end and front-end, worked on enhancement of Data source, done enhancement using user-exit badi, created view and sql query and pull information from the other table to the enhanced Data source.
• Extensively worked on Bex Analyzer and to create Queries, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, and web templates.
• Designed and optimized queries top customers, monthly incoming orders, product analysis, returns and created reports using Bex Analyzer.
• Created Jump Queries using RRI Report to Report Interface to give facility to drill down Report from summarized format to detailed format. Used Web Application Designer to develop web reports.

Confidential

Role:PeopleSoft Developer

Environment: People Tools, People Code, COBOL, SQR, Oracle 8.x, SQL server.

• Worked and Utilized PeopleSoftfinancials8.9 SQR, People Code, Crystal reporting, and Application Engine to develop program in the People Soft financials. Have good understanding of Integration Broker Workflow. Work on experience in all listed modules BI, AR, GL, PC, PO and AP.
• Strong knowledge of the PeopleSoft People Tools, PeopleSoft Portal Architecture, SQL, SQR and Application engine. System enhancements experience in terms of customization, business process improvement and implementation using PeopleCode reports/Query creation and modifications using PS-Query/ SQR/ Crystal and various PeopleSoft tools. Good understanding of PeopleSoft security setup in PeopleSoft 8.9.
• Utilized SQR, People Code, and COBOL to develop program in the People Soft, Used DBlink for database links then COBOL and SQR program to transfer data across applications.
• Worked on Interfaces like Clients, Vendors, Accounts Receivable, Gen Ledger, Engagements project costing, and Voucher. Global Data Conversion on 8.9 environments. All the interfaces were written using Application Engine and SQR's. Most of the process was execute on UNIX environment and monitor using the Process Scheduler.
• Developing Design Documents, Configuration Documents, Test Scripts. Fit Gap of Billing, Accounts Receivable and Gen Ledger functionalities for version 8.9. Data Modeling.
• PSAE debugging tools was used to debug the AE program and debugger for PeopleCode.
• Developed technical standards procedure guidelines related to coding, configuration management, change management, object migration and environment maintenance
• Participated in numerous technical projects, including security reorganization, infrastructure improvement, interface development, tuning, and data maintenance Configured and coordinated.
• Designed and developed a system to accomplish an in-place conversion of setup and transactional data SetID, Business Unit, Account, Department, Location and other key fields
• Designed and developed a program to modify employee IDs and other information while preserving data relationships.
• Install and upgrade the Oracle Server and application tools, Allocate system storage and plan for future storage requirements for the database, Manage logical and physical database structures, manage privileges and security features. Used DBlink to connect various Oracle 8.9 databases across regions.
• Install Unix Operating system and load Oracle Database, Wrote shell scripts to run batch and background process, know all UNIX and shell commands for day to day operations.
• Worked as a PeopleSoft 8.9 financial functional architect, performed fit/gap analysis for Support, for existing AR, General Ledger, Clients, Vendors and design EDI AP to load data in the system. Wrote Test Plans and Test Specifications and Test Templates.
• Overall in-depth analysis of the existing Account Receivables, Account Payables and Gen Ledger Conduct Business Process Reengineering of Financial and related processes in preparation to the implementation of the PeopleSoft Financial Management System software. Managing and deploying a successful strategy for transition to the new system. Lead teams through fit / gap, functional and technical documentation, build and construct phases through transition and deployment
• Implemented BI, AR, GL, and AP. And creating collaborative application that enables a paperless application process from start to finish. Setting up business process for workflow implementation. For AR and AP subsystems in version PeopleSoft 8.9
• Worked and changed existing AE the Contracts/Billing Interface Process CA BI INTFC where Contracts and Projects related billing activity sent to PeopleSoft Billing Also Worked with Finalization process BIIVC000 on the real bills The Finalization process performs a variety of tasks including calculating taxes, setting the invoice date, and calculating the due date Worked on Projects/Contracts Interface process BIPCC000 process updates PeopleSoft Contracts and PeopleSoft Projects with the final bill information from PeopleSoft Billing. where reports where generated where user displays details of billing plans, including the events associated with those plans the status of the events and the amount of future billings balance. In GFIS Billing Work build Processes to suite Global Financial Manual Auto Reverse, Currency Conversion Process BICURCNV , Pre-Load process BIPRELD , Correct combination edit process errors, Load AR Pending Items process BILDAR01 Load GL Accounting Entries process BILDGL01 AP Vouchers process BIGNAP01 Billing Interface, Invoice Generation process, Consolidation Invoice process, Unbilled Revenue Accrual Process.
• In GFIS Account Receivables build and work on Payment Predictors, Receivable Update process, Auto Reserve, AR2PC, Payment processing, aging process, changes were made to existing AE ARupdate to need requirement of the for Global Financial, VAT was used for VAT countries, necessary changes were made to calculate foreign and base currency enhancement were made to calculate Auto Reverse Amount to adjust the entry-amt at payment processing.
• In GFIS Project Cost Revenue Recognition, Estimated Realization Percent ERP Calculation, Cost Apportionment, Cost Allocation were Key concepts Time and expense transactions are recorded in the project costing module Fee revenue is calculated by multiplying hours by the bill rate, including applicable surcharges. ERP reserves are created as part of the revenue calculation to adjust revenue in the net realized value. Net revenue is the application of ERP reserves, fee adjustments, accounts receivable reserves and write-offs to fee revenue. Expense revenue is calculated based on expense amount and surcharges. Base Cost Calculation use actual hours submitted to the engagement to calculate costs. Seasonal Cost Adjustment Calculation was introduce in the system. Work and build on processes AR2PC, Revenue recognition, Clear ERP reserves, Cost Allocation, Cost recognition
• In Gen. Ledger Global Financial GLedit, Document Sequence, and Glpost process were changed to meet the Global Counties requirement statistical setup was introduce to maintain statistical data to facilitate financial analysis and reporting. Alternate Account feature was set for some countries were statutory requirements was compulsory and to achieve the statutory report for governments. All above processes Chartfields were changed to meet the requirement of the global Financial. VAT Codes was set in order to calculate VAT tax.
• In PS General Ledger, involved in setting of control table and setup tables , Chart fields, Combo Edits, Budget Checking VAT/GST functionality Document sequence numbers Electronic banking for AP, AR, and transaction reconciliation Multi-currency functionality Local language requirements Alternate Accounts Withholding
• Processes involved were Matching Process, Voucher Build AP VCHRBLD , Voucher Edit APVCHREDIT , Voucher Posting AP PSTVCHR , and Payment Posting AP PSTPYMNT in Account Payables System.

Confidential

Role: PeopleSoft Developer

Environment: People Tools, People Code, COBOL, SQR, Oracle 8.x, SQL server.

• Strong knowledge of the PeopleSoft People Tools, PeopleSoft Portal Architecture, SQL, SQR and Application engine. System enhancements experience in terms of customization, business process improvement and implementation using PeopleCode reports/Query creation and modifications using PS-Query/ SQR/ Crystal and various PeopleSoft tools. Good understanding of PeopleSoft security setup in PeopleSoft 8.4.
• Utilized SQR, People Code, and COBOL to develop program in the People Soft, Developed database links in COBOL and SQR to transfer data across applications.
• Worked on Interfaces like Customer, Parent Customer, Sales Rep, Ledger, Voucher, Aging, Vendor and many others along with Data Conversion on 8.4 environments. All the interfaces were written using Application Engine and SQR's. Created complex Crystal reports, which were developed to be executed from the Process Scheduler. Created new tables and pages to implement the business functionality.
• Worked on both inbound and outbound interfaces to load data from a legacy system into the PeopleSoft System. Technical specification and design documentation for Project and Financial modules. Prepared and executed unit, system and user acceptance test plans and Scripts for the interfaces and conversions. Developed File Layout Definitions with different formats to write the interface output to the Flat file. Wrote inbound interfaces to get data from legacy system into PeopleSoft using Application Engine. Created row sets to get the data from the file layout and insert it into the PeopleSoft tables. Developed SQR's to convert data coming from legacy system into PeopleSoft System.
• PeopleCode/Portal development on Quick Customer Create web front-end customization. PeopleCode debugger on the portal to check the functionality. Also having hands on system enhancement experience in terms of customization, business process improvement and implementation using PeopleCode reports/Query creation and modifications using PSQuery/SQR/Crystal and various PeopleSoft tools. Good understanding of PeopleSoft Portal Architecture.
• Developing Design Documents, Configuration Documents, Test Scripts. Fit Gap of Accounts Payable functionalities for version 8.4. Data Modeling. Interaction with PeopleSoft Global Support Center Customer connection. Test scripting. Unit Testing, String Testing System Integration Testing and User Acceptance Testing. Reporting requirements using Seagate Crystal Reports.
• PSAE debugging tools was used to debug the AE program and debugger for PeopleCode.
• Developed SQR Interface Program, which loads Vendors into PS VENDOR TYPE, PS VENDOR, PS VENDOR INVOICE, PS VENDOR 1099, PS VENDOR ADDR, PS VNDR ADDR SCROLL, and PS VENDOR PAY tables. Voucher into PS VOUCHER, PS VOUCHER LINE, PS PYMNT VCHR XREF, and PS VCHR ACCTG LINE tables. Assets into PS ASSET, PS ASSET TYPE, PS ASSET DEPR tables. Finalize the mappings for AR Open Items. Loads AR Open Items into PS PENDING ITEMS, PS GROUP CONTROL tables.
• Project data into PS PROJECT, PS PROJECT DESCR, PS PROJECT STATUS, PS PROJ LOCATION, PS PROJECT MGR, PS PROJ ACTIVITY, PS PROJ ACT LOC, PS PROJ ACT DESCR, PS PROJ ACT STATUS tables. Loads AP WIP data into PS FH AP CHG and PS PROJ RESOURCE tables. Loads Time WIP data into PS FH TIME CHG and PS PROJ RESOURCE tables.
• Worked as a PeopleSoft 8.x financial functional architect, performed fit/gap analysis for Support, for existing BI, AR, AP system. Wrote Test Plans and Test Specifications and Test Templates.
• Overall in-depth analysis of the existing Account Receivables, Account Payables and Billing systems. Conduct Business Process Reengineering of Financial and related processes in preparation to the implementation of the PeopleSoft Financial Management System FIN software. Managing and deploying a successful strategy for transition to the new system. Lead teams through fit / gap, functional and technical documentation, build and construct phases through transition and deployment
• Implemented AR, GL, BI, and AP. And creating collaborative application that enables a paperless application process from start to finish. Setting up business process for workflow implementation. For AR and AP subsystems in version PeopleSoft 8.4.
• Processes involved were Billing Interface, Invoice Generation process, Consolidation Invoice process, Pending Items process, GL Accounting Entries Process, Vouchers Process, Unbilled Revenue Accrual Process, Unbilled Revenue Accrual Process, Receivable Update process, Payment processing, aging process In PeopleSoft Billing and Account Receivables.
• Processes involved were Matching Process, Voucher Build AP VCHRBLD , Voucher Edit APVCHREDIT , Voucher Posting AP PSTVCHR , and Payment Posting AP PSTPYMNT In Account Payables System. With Online Page Vendor - Vendor Pay Group Codes, Maintain Vendors, Vendor User Setup. Vouchers Vouchers Entry, Quick Invoice Entry, Voucher unpost, Voucher Approval. Payments Express Payments, Manual Payments, Payment term Options, Voucher Contracts Schedule recurring Payments, Build Recurring Vouchers.
• Team lead of 25 consultants, written Program Specifications, explain Design Documents, Test Plan created, Quality Assurance were done. Program standards were check program testing was done to a first level, integration testing system testing was done for the data flow.
• Install and upgrade the Oracle Server and application tools, Allocate system storage and plan for future storage requirements for the database, Manage logical and physical database structures, manage privileges and security features. Used Dblink to connect various Oracle 8.x databases across regions.
• Install Unix Operating system and load Oracle Database, Wrote shell scripts to run batch and background process.

Confidential

Environment: Vax COBOL, TDMS, Vax RDB/SQL, COBOL Writer.

• Change existing Sql routine, which was poor performances or execution, was slow and/or Sql routines were not written properly. Involved in changing existing Rdb database, created new tables, indexes and change existing view. And done fine-tuning to the database.
• Prepared unit test plan, done data creation, program testing. Responsible for development and maintenance of Financials systems. Lead technical group for the upgrade Financials System. Involved in designing the system also directly interacted with the customers. Lead the Team, written detail program documentation and hand-over to teammates. Explain the flow of the system and program to teammates.
• Involved in first level of program testing. Involved in implementation of the financial system. System was developed in Vax COBOL using TDMS as a Client and Vax RDB/SQL as Server. Reports were developed using Vax COBOL Writer.

Confidential

Environment: Vax COBOL, ACMS, DECFORMS, Vax RDB/SQL, COBOL Writer.

• Involved in writing Business Documents and program specifications. Prepared unit test plan, done data creation, and program testing. Active role in implementation of the system. Involved in study existing system, draw Data flow diagram. Interaction with end-users and management to finalize interfaces.
• Utilized VAX COBOL, Decforms, Record Management System. Migration from sn73 COBOL to Vax COBOL. Converted forms FMS to Deforms screen. Utilized Vax FORTRAN, VaxRdb, and VaxVms.
• Involved in studying business documents which was written by third party Labin , contacted Labin for further clarification of business document. Helpful Tips was shared with teammates, working in Database administration for creation of tables, indexes building, views data creation.