MFG/PRO Business Analyst/Developer

VISHNU PRATAP SINGH

SUMMARY

Over Eighteen years of experience as a Systems Analysis / Programmer in Software development and implementation using Structured System Analysis and Design Methodology.

Ten years in MFG/PRO Enterprise Resource Planning application with emphasis on Manufacturing and Distribution modules.

Software Application and Database knowledge includes MFG/PRO, eB2, eB, 9.0, 8.5, 8.6e, 8.3e, 7.4h 7.3 and PROGRESS 10i, 9.1d.

Also worked on BAAN IV, SYBASE 11.5, ORACLE8.0, INFORMIX and SQL 7.0.

Over TEN years of experience in client/server application development with over Nine years of experience in PROGRESS RDBMS / 4GL application development. Have worked on MFG/PRO eB2, eB, 9.0, 8.5, 8.6e, 8.3e, 7.4h 7.3, on PROGRESS 9.1d, 8.3b and ORALCE databases.

Experience in migration strategies (Intra-Configuration, Transitional and Add-in migrations) of MFG/PRO and PROGRESS.

Excellent experience with the Distribution, Manufacturing and Financial modules of MFG/PRO as well as the technical details of the MFG/PRO tables and fields.

Proficient in Developing and implementing various Interfaces with MFG/PRO, in-house local databases, as well as business trading partners’ systems/databases, such as contract manufacturer, and contract service provider.

EDUCATION

Allahabad University India

Bachelor of Science

Computer Point India Bombay

Post Graduate Diploma in Computer Science,

TECHNOLOGY

Internet Technologies: Enterprise Java Beans (EJB), JSP, Servlets, RMI, Java Beans, Java Script, Applets, AWT, Swing, JavaScript, HTML, XML, Web Sphere 3.5, Web Logic, MQ Series 5.1, Openlink, WebSpeed 2.0, 3.0, 3.1

Middleware: Progress AppServer 10i, 9.1B & 9.1d

Languages: Java 2/1.x, C, SQL, PL/SQL, MS COBOL

Servers: IIS 4.0, Java Web Server 2.0, and JSDK 2.0

RDBMS: PROGRESS 4GL V6.3, 7.3, 8.3b, 9.1d, 10i, ORACLE 3.0, 7.0, 8.0, SYBASE 10, MS SQL 7.0, DB2, UNIFY

Tools: Developer 2000, ERWin 2.0, 3.5.2 and Turbo Analyst

Operating System: MS-DOS, UNIX, HP_UX, Win 95/98, Novell NetWare 4.11, and Win NT 4.0

EXPERIENCE

July 2006 Quicken Loans Livonia, MI

To Present PROGRESS LAKEWOOD DEVELOPER

Quicken Loans is America's #1 Online Mortgage Company, and one of the largest home loan lenders nationwide. They were rated number one in IT Company to work for.

• Interacted with Sales and Marketing Team to gather the requirements and developed adhoc reports.

• I was mainly responsible for Sales & Marketing team to define the detailed requirements, analyze the business needs, and validate the solution with the end user and participated in user acceptance test.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• I was responsible for development and implementation of various projects from FNMA and Loan Platform Projects.

• Design and development of new screen, interface and reports. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• Production Support.

Environment: PROGRESS 10b, HP-UX version 11.

May 2006 Satyam Computer Services Ltd.

To July 2006 MFG/PRO CONSULTANT

Caterpillar, CORIANTH

Caterpillar is the world’s leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines.

• Meeting with users to gather the requirements and understand the business needs and design and develop the solution across the company.

• Interacted with Sales Team, Purchasing Team, Shop Floor team to gather the requirements to automatic receive and update the inventory at given site and location.

• Owner of the solution through out the development life cycle.

• Interacted with users after implementation to improve upon the business process.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• I was responsible for development and implementation of MFG/PRO rollout at CORIANTH, MS plant.

• Design and development of new screen, interface and reports. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• EDI eCommerce Gateway, setting up trading partners, mapping, transformation and production support.

• Production Support.

Environment: MFG/PRO eB, PROGRESS 9.0, HP-UX version 11.

December 2005 NCR Dayton, OH

To May 2006 SR SYSTEM ANALYST

National Cash Register (NCR) was inventor in front office cash register. They are based in OHIO and leaders in Business Media and Publications and ATM Machines.

• Interacted with Sales and Marketing Team to gather the requirements and developed adhoc reports.

• I was mainly responsible for Sales & Marketing team to define the detailed requirements, analyze the business needs, and validate the solution with the end user and participated in user acceptance test.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• I was responsible for migration project from PROGRESS based home grown application to ORACLE Financials.

• Written new interface to send and receive the data from webMethods in Sales area.

• Design and development of new screen, interface and reports. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

Environment: PROGRESS 9.0, HP-UX version 11, Oracle Financial

December 2004 Solo Cup Company Highland Park Chicago, IL

To December 2005 SR. SYSTEMS ANALYST/DBA

Solo Cup is a leading manufacturing company involved in making paper plates, cups and lids.

• Interacted with Sales and Marketing Team to gather the requirements and developed adhoc reports.

• I was mainly responsible for Sales & Marketing team to define the detailed requirements, analyze the business needs, and validate the solution with the end user and participated in user acceptance test.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• I was responsible for development and implementation of Project called Direct ship, it uses, PROGRESS, wGet, webMethods, Oracle and JAVA technology.

• Written new interface to send and receive the data from webMethods.

• EDI eCommerce Gateway, setting up trading partners, mapping, transformation and production support.

• Design and development of new screen, interface and reports. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• Production Support.

Environment: MFG/PRO 8.6e, PROGRESS 8.3a, HP-UX version 11, webMethods, Oracle 11i, PeopleSoft.

July 2004 Sherwin Williams Cleveland, OH

To December 2004 SR. SYSTEMS ANALYST / PROGRAMMER MFG/PRO EB 2 IMPLEMENTATIONS

• Revamping and migration of MFG/PRO Application 7.4h, 8.6e, eB2 Service Pack 3

• Interacted with Sales and Marketing Team to gather the requirements and developed adhoc reports.

• I was mainly responsible for Sales & Marketing team to define the detailed requirements, analyze the business needs, and validate the solution with the end user and participated in user acceptance test.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• Manage and written new interface to help Mexico Plant for Inventory Counting.

• Responsible for implementing eB2 at Mexico.

• EDI eCommerce Gateway, setting up trading partners, mapping, transformation and production support.

• Analysis and modification of existing Interface for eB2 environment.

• Written new Interface Program for MESS, AOM.

• Develop functional and detail Systems Requirement document.

• Design and development of new screen, interface and reports. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• Co-Ordination with Business Owners and Team for Cross Functional requirements.

• Involve in Business Process Mapping and GAP Analysis.

Environment: MFG/PRO eB, eb2, 7.4h, PROGRESS 9.1d, MESS, AOM, HP-UX version 11 Model 5740.

January 2003 Columbian Chemicals Atlanta, GA

To June 2004 SR. SYSTEMS ANALYST / TEAM LEAD / PROGRAMMER/ DBA, MFG/PRO

eB Implementations. Revamping and migration of MFG/PRO Application 7.4h, 8.6e, 9.0 into eB Service Pack 5 and eB2.

• Develop CRIME (Conversion Reporting Interface Modification and Enhancement) Project Plan.

• Co-Ordination with Business Owners and Team for Cross Functional requirements.

• Involve in Business Process Mapping and GAP Analysis.

• Meeting with users to gather the requirements and understand the business needs and design and develop the solution across the company.

• Interacted Subject Matter Experts across the company to gather the requirements and arrive one solution across the board.

• Owner of the solution through out the development life cycle.

• Interacted with users after implementation to improve upon the business process.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• Developed and executed CIM Load Programs to Upload Item Master, Customer Master, Item Cost Data, Purchase Order, Sales Order, and Unplanned Receipts, Product Line Maintenance, Sales Accounting Maintenance.

• EDI eCommerce Gateway, setting up trading partners, mapping, transformation and production support.

• Converted more than 200 programs into eB version.

• Analysis and modification of existing Interface for eB environment.

• Written new Interface Program for MLS and ADEXA.

• Interpret the organization's information requirements and do Business Process Re-Engineering.

• Develop functional and detail Systems Requirement document.

• Design and development of new screen, interface and reports.

• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

Environment: MFG/PRO eB, eb2, PROGRESS 9.1d, ADEXA 4.02, MLS, EDI, HP-UX version 11 Model 5740.

August 2002 Alpharma is leading Pharmaceutical Company Alpharma, NJ

To December 2002 SYSTEMS ANALYST/ PROGRAMMER, MFG/PRO IMPLEMENTATION

Project involved migration from BPCS II to MFG/PRO 9.0.

• Systems Analysis and coding using PROGRESS 8.3b as per the customer specification.

• Developed and executed CIM Load Programs to Upload Item Master, Customer Master, Item Cost Data, Purchase Order, Sales Order, and Unplanned Receipts, Distribution Order, Shipments.

• Developed and maintained plans outlining steps and timetables for development, testing and installation procedures. Created test transactions and validated test scripts to find errors and confirm program meets specifications.

• EDI eCommerce Gateway, setting up trading partners, mapping, transformation and production support.

• Analyzed business process and codes to find causes of errors and revised programs or process.

• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• Involved and in User Training, Business Process Mapping, Gap Analysis and post implementation Support. Preparation of Detailed Program Documentation for Future Reference.

• Wrote Test Scripts to validate migration process.

• Owner of the enhancement throughout the entire life cycle.

Environment: MFG/PRO 9.0, 8.6e, PROGRESS 8.3b, SQL 92, ORACLE 7.0, RIMS 3.5, EDI, GENTRAN, X12, BPCS II, CRIME and Windows NT.

June2002 Advance Business Graphics Ontario, CA

To July 2002 SYSTEMS ANALYST/ PROGRAMMER, HAGEN OA IMPLEMENTATION

• Systems Analysis. Coding as per the Design and Specification.

• Development of programs for synchronization of data in PROGRESS and SQL Server Database using ODBC connection from PROGRESS to SQL Server.

• Coded EDI Programs for all EDI customers in different layout as per the customer specification.

• Created reports using Crystal Report.

• Testing of Code & documentation.

Environment: Progress 9.1c, Provision Plus 9.1c, SQL 92, SQL Server 2000, WebSpeed 3.1, Hagen OA 6.0 (ERP), Windows 2000 Pro, CorVu 4.5, Crystal Reports 8.5.

August 2001 General Electric Lighting, NC

To June 2002 SR. SYSTEMS ANALYST / PROGRAMMER

MFG/PRO, WebSpeed Application and RIMS Application customization

• GE Lighting Systems is a world known manufacturing company in light fixtures. GE Lighting Systems uses QAD Product MFG/PRO 9.0 for their business. My team was responsible for monitoring and improving and implementing the changes in a speedy manner.

• System Analysis, Design, Coding, Testing and Implementation of solution across the databases.

• Developed and executed CIM Load Programs to Upload Item Master, Customer Master, Item Cost Data, Purchase Order, Sales Order, and Unplanned Receipts etc.

• Mapped and TEST EDI documents. Co-ordinate with trading partners for new documents.

• Developed Customized Reports as per the requirements of the Users.

• Developed detailed Project Plan, Effort Estimation. Project Analysis, Risk Analysis.

• Tracked and scheduled the task.

• Developed and maintained plans outlining steps and timetables for development, testing and installation procedures.

• Created test transactions and validated test scripts to find errors and confirm program meets specifications. Provided technical assistance by responding to inquiries regarding errors, problems, or questions with program or business process.

• Trained end user. Business Process Mapping. Gap Analysis and post implementation Support.

• Prepared detailed Program Documentation for Future Reference.

• Solved user queries regarding MFG/PRO functions. Programming, Testing and Implementation of new solutions.

• Worked closely with product and development teams, analysis for other systems.

• Owner of the enhancement throughout the entire life cycle.

February 2001 AT&T Morristown, NJ

To July 2001 SR. SYSTEMS ANALYST, NLP/LOS FEASIBILITY & REQUIREMENTS

• Developed PROGRESS Interface between SYBASE and PROGRESS database to interact with billing applications.

• Developed Time & Costs, time-lines, and system requirements and detail-level design documents.

• Worked closely with product and development teams for other systems Impacts.

• Identified and a resolved issues and reports status to team.

• Developed test approach/plan and test cases/scenarios in support of end-to-end testing.

January 2000 Unilever/Hindustan Lever Ltd. Chicago, IL

To January 2001 PROJECT LEADER / ANALYST / PROGRAMMER

• Developed project plan and effort estimations.

• Requirement Analysis and Design, development and deployment of Mobilitee Application.

• Integrated Web AppServer and back-end UNIX/PROGRESS database using MQ Series to provide secure messaging. Wrote user interface in JSP, used Java Script, VisualAge for Java and DHTML.

• MFG/PRO module of Finance and Distribution were Web enabled for the two clients mentioned.

June 1999 Protégé Systems Inc. Chicago, IL

To December 1999 PROGRAMMER / ANALYST, CLIENT MANAGEMENT SOFTWARE

CMS is a Sales management client / server application, which offers sales call management with all activities and their notes.

• Wrote interface between PROGRESS and SQL7.0 Database.

• Data migration between 8.3 b to PROGRESS 9.0.

• Developed Systems Requirement and Detail Design document.

• Conversion of CMS Application into Salesforce.com ORACLE 8.0 Database.

• Progress Help Desk Support.

• Provided DBA support to project teams involved in creating database solutions in MS SQL Server 7.0.

• Installed and configured SQL 7.0 database on NT 4.0 servers.

• Created databases and suggested design changes for performance tuning.

• Monitored memory, processor, Disk I/O and user connections.

• Performed backup, recovery and automation of backups.

All Previous roles were in India

Batten Field India Limited, India

Godrej Soaps India Ltd., India

Morarji Mills, India

Nicholas India Limited (Piramal Health Care), India

TandonInformationSolutions,India

Balsara Hygiene Ltd., India

Lupin Laboratories Ltd., India

C. M. Gabhawala & Co, India

Contact this candidate