We provide IT Staff Augmentation Services!

Systems Analyst Resume

5.00/5 (Submit Your Rating)

Summary

  • Over 12 years of IT experience in analysis, design, implementation, testing and application support of various business systems in Client-Server environment.
  • Over 6 years of experience on Customization, development and support of PeopleSoft 8.x Financials applications, using Application Designer, Peopletools, Peoplecode, Application Engine, Component Interface, File layouts, PS Query, SQR, Crystal Reports, Tree manager, Workflow, and Process Scheduler.
  • Over 5 years Experience in Oracle 7.x, 8i, 9i, Developer/2000(R1.3, 2.0), Developer 6i (Forms6.0) PL/SQL.
  • Involved in requirement gathering, Designing and preparing documents and prototype which where inline with CMM processes.
  • Involved in writing the Test Plans, Test Cases and scripts for regression, system, integration, functional and performance Testing.
  • Interacted with users to understand requirement, implement the same and give training if required.
  • Excellent in problem solving, logical and analytical abilities and self-learning attitude.
  • Performed End-User training and prepared training documents for the end users.
  • Ability to work in an independent or team environment.
  • Strong attention to detail and ability to meet deadlines.
  • Results oriented, analytical, exceptional organizational skills.
  • OCP for Application developer track.
Education

Master of Computer Applications (M.C.A)

Skills

Operating System: Windows XP, Windows 9X, Windows NT, AIX, SCO UNIX, MS-DOS
ERP: PeopleSoft - PeopleTools, PS Query, Application Designer, Component Interface, Apps Engine, Tree manager, Process Scheduler, File Layouts & Workflows.
Report Tools: Developer Reports 2.5 & 3.0, Crystal Report 8.0
Databases: Oracle8.x, Oracle 7.3.4, Oracle 7.1, DB2
GUIs: Developer/2000 (Forms 4.5 & 5.0), Developer 6 (Forms 6i), Delphi 2.0, Power Builder
Language: SQL, PL/SQL 2.3.4, 8.1.7.2, HTML, XML.
Tools: Visual Source Safe, Toad, SQL Navigator.
Package: Oracle Clinical.

Trainings attended

  • Oracle 9i DBA in Dec 02: Duration: 3 weeks
  • Peoplesoft Payables Rel 9.0 in Oct 07: Duration 4 days.
  • PeopleSoft Receivables Rel 9.0 in Mar 09: Duration 5 days.

Professional Experience

Confidential, LaFox, IL, USA May 2007- Aug 2009
System Analyst
PeopleSoft Financials 8.9

Richardson electronics have Peoplesoft financials, SCM and HRMS implantation.
My responsibilities here incorporate doing production support for financials modules which includes Payables, Receivables, GL, Asset Management, Treasury. Have exposure of purchasing module while working on payables.

  • Coordinating with the end users for Requirement and Change Requests.
  • Participate in 7X24 rotation of the Production Support for PeopleSoft systems. Resolve technical problems when required, monitor Magic Incidents queue and assist Information Systems Help Desk in solving application system problems
  • Provide users with operational overview and options for requested system enhancements
  • Design additions, enhancements and modifications to current systems
  • Write specifications outlining steps required to develop or modify programs and follow approval policies
  • Identify, analyze and install fixes from the PeopleSoft Global Support Center.
  • Participate in the deployment of purchased PeopleSoft modules and System Upgrades.

Technologies: PeopleSoft 8.9, People Tools 8.48 (Application designer, Maintain security, Process scheduler, Application engine, Workflow).

Confidential, Deerfield, IL, USA Feb 2007- April 2007
Sr. Software Engineer
Oracle Clinical Interfaces

TAP Pharmaceutical have Oracle Clinical implementation, which have modules and various interfaces between them.
My responsibilities here incorporate working on ACCS/OC Interface.

  • Coordinating with the end users for Requirement and Change Requests.
  • Providing post production support
  • Customized the forms and procedures implemented for ACCS/OC integration
  • Developing and enhancing Interface (Inbound and Outbound) for loading data to and from the OC databases
  • Customize and develop Report as per the requirement.

Technologies: Oracle 9i, PL/SQL, Oracle Developer 6i(Forms and Reports 6i)

Confidential, IndiaSept 2003-Oct 2006
Project Leader
ERP Implementation - eMBT

eMBT is an initiative to automate & integrate MBT's MIS, Business Processes, and operations across all functions and locations. Following are few of the operations which eMBT tries to focus on Business Development, Recruitment, Delivery Management, Finance, HR, Training, Admin, People & Skill Development, Technical infrastructure, etc.
My responsibilities here incorporate working on Operation's, Contract, Projects, and Billing, AR modules.

  • Coordinating with the end users for Requirement and Change Requests.
  • Providing post production support
  • Customized the Pages and Components to incorporate the new functionality in PeopleSoft Contract ,Billing, Projects modules
  • Developed several Interfaces (Inbound and Outbound) for loading data to and from the PeopleSoft database.
  • Developed several Run Control pages in CA, BI, and PC modules to trigger online processes.
  • Customized and developed new Crystal Report as per the requirement.
  • Developed extensive peoplecode to incorporate the business rules involved Contract modules as per user needs.
  • Developed several Profit and Loss reports for the Profit and Loss analysis of the client based on Region, YTD and MTD.
  • Designed developed and implemented a new module sales force automation using peopletools which was integrated with contract module and used for pre sales activity.
  • Conducted user trainings

TechnologiesPeopleSoft 8.0, People Tools 8.15 (Application designer, Maintain security, Process scheduler, Application engine, Component interfaces, Workflow ,File Layout, data from CSV files).

Confidential, (India) Sept. 1999 - Aug 2003
Sr. Developer
Jackson and Nicholson Insurance, USA

Scope of the project was to convert 250 SP of Sybase to DB2, in phase I. Make Application IO calls compatible with DB2. Volume of project was to big so the biggest challenge of the project was configuration management, which was performed by me.
My responsibilities: As a Team Leader, was responsible for following

  • Analyzing Sybase SP's and converting the same in DB2.
  • Converting Sybase DDL to DB2 DDL's.
  • Converting Sybase triggers code in to DB2
  • Performing code review and testing.

Configuration Management Responsibilities.

  • Identifying and managing the configuration items (C.I.)
  • Exercising version control, identifying baselines.
  • Controlling change management
  • Controlling release and delivery management.

Technologies DB2 UDB, AIX Conversion tool.

City Of Portsmouth, Portsmouth, VA
City of Portsmouth (COP) projects had Finance, Payroll, Collections, Real Estate, Receivables, Public Utility and Department of Social services.
Scope of COP projects was re-engineering. Primarily it's COBOL to oracle conversion. For department of social services it was Forms3.0 to Forms 6i conversion.
The primary objective of COP DSS project was to develop the screens, reports for GUI based Client Server Environment and keep the functionality as of in current Legacy system.
Finance keeps the invoice, Purchase Order, Journal Voucher, Accounts and posting of JVs. Payroll System keeps the Employee payroll check, Employee account Distribution, Employee job History, Employee pay adjustment, Leave transaction, pay transaction and Employee Retirement History. Public Utility was used for Billing Consumers of Utility Services provided by City of Portsmouth. The services provided by the Utilities Department include Water, Sewage, and Refuge. Real Estate was related to assessment of Property and tax calculation.
My responsibilities I was core member of the COP team.
Worked as a Team Member for Finance, Payroll, Public Utility and collections module, and was responsible for following:

  • Understanding Unisys COBOL programs and converting the code in PL/SQL.
  • Writing Stored Procedures, Functions Involved in creation of reports and testing.
  • Responsible for preparation of Design documents, Test Plans.

Worked as a Team Leader for Real Estate and Department of social services and was responsible for following:

  • Client interaction
  • Design & Development of Templates for User screens (Forms 6.0) and Reports (Reports 6i)
  • Preparing design document and getting them approved.
  • Writing test plans.
  • Understanding Unisys COBOL programs and converting the code in PL/SQL.
  • Understanding forms 3.0 code and converting it to Forms 6i.
  • Writing Stored Procedures, Functions Involved in creation of reports and testing.
  • Real Estate involved 4 complex Cobol programs that were meant for plotting sketch and had 4000 lines of code for each program. I converted all 4 programs and delivered.

Technologies Developer 2000(Forms4.5, Reports2.5, Forms6i, Reports 6i), Oracle 7.3, Windows NT

Confidential, USA
Valuation is a Land assessment process used during calculating value of a property.
My responsibilities: Worked as a Team Leader and was responsible for following:

  • Understand the business
  • Preparing High level design docs and getting the design approved
  • Write stored procedures using oracle XML
  • Testing and matching the data with legacy results.

Technologies PL/SQL, Oracle with XML

Confidential, USA
Catawba is a reengineering project includes enhancements in existing C++ version and conversion of existing Word documents to HTML reports.
My responsibilities :Worked as a Team Leader and was responsible for following:

  • Was responsible of making of HTML reports and testing.
  • Configuration Management Responsibilities.
  • Identifying and managing the configuration items (C.I.)
  • Exercising version control, identifying baselines.
  • Controlling change management
  • Controlling release and delivery management

TechnologiesBorland C ++ 5.0, HTML, SQL Server 2000

Abacus (SPECTRUM)
Abacus is Ratemaking Process. System gets Unit Statistical Report (USR) from Spectrum. Data is processed, to create reports and files. These files and reports serve, as the input for the bureau's to calculate experience MOD.
On the basis of experience MOD employers are rated as experienced and non-experienced.

My responsibilities Worked as a Team Leader and was responsible for following:

  • Preparation of Design documents, Test Plans, coding.
  • Involved in Elaboration and integration testing phase.

Technologies Developer 2000(Forms6i, Reports6i), Oracle 7.3, Windows NT

Confidential, Indore (India). Dec 1997-March 1999
Software Engineer

Kriti Online
Kriti online is an Online Integrated Management System developed to fully computerize the function of the corporate office and factories located at different locations of a Soya Industry. This system consists of 13 modules i.e. Finance, Machine Maintenance, Purchase, Quality assurance, Material management, Logistic, Sales, DOC export, Personnel payroll, User Security. It had 200 data screens.

  • Purchase module handles the activities related to the purchase of Soya seed through the commission agents. This module calculates the payment for seeds, agent's commission, deduction if any based on seed quality, fright payments etc.
  • Sales module handles the activities related to sales of Soya oil dealers. Involved in development, testing & implementation of system. Responsible for management of coding schedule and user training.
  • Financial Management System keeps track of various functions like Cash and Bank Accounting, Accounts Payables Receivables, General ledgers, Purchase Accounting, Sales Accounting, Material Accounting, Export Accounting, Finalization of account and MIS Reports. Financial Management. System is linked to other modules of the system viz Costing, Budgeting, Material Management, and Raw Material Purchase, Personnel Payroll, DOC Export, Quality Assurance, Marketing & Sales and Maintenance system.

My responsibilities Worked, as a module leader for purchase module, user security and was also involved in development of other modules Also was responsible for maintaining common objects, library templates, which was used for complete project. Involved in Coding, Testing, and Implementation at client site.
Technologies Developer 2000(Forms5.0, Reports3.0) with Oracle 7.3 under SCO Unix 5.0.

We'd love your feedback!