Experience

County of Chester

• Government Administration
• 400 - 500 Employee

• Peoplesoft Developer

  • Nov 2010 - Present

  Peoplesoft development projects related to Financial and HR departments of the County of Chester. As FSCM application developer:Modules: Customers (All), eProcurement, Billing (All), Account Receivable (All), Set Up Financials/SupplyChain (All), General Ledger (Journal Entry), Reporting Tools(Query/BI Publisher), Peopletool(Portal/Process Scheduler)As HCM application developer:Modules: Self Service (Pension), Manage for Results (Plan/ Activity Data Collection)1. Coordinate with business analysts understand the business needs and requirements. I usually get an IR or RFC followed by a meeting.2. Provide practical technical solutions to business problems. Perform a comprehensive analysis of the data and presents options and recommendations to obtain the desired results.3. Responsible for the design, development, and delivery of various components of PeopleSoft application development such as SQR and XML reports, Application Engine, Peoplecode, Component Interfaces, Custom Queries, Data loading and Retrieval processes, Peoplesoft Tables/Views/Records definitions and Database objects, Pages, migration documentations and more. 4. Upgrade and modify old financial modules as per business needs.5. Assist in preparing technical and functional documentation.6. Perform SQR and Peoplecode reviews and recommend process improvements.7. Provide application and process testing and bug fixing.8. Involve in AR/Billing investigations and production resolve issues. During year 2020 have been done a lot of modifications in Customer, Account Receivable and Billing modules related to Coved-19. Show less

• Sr. Database developer/analyst

  • Dec 2003 - Oct 2010

  SKILLS: Project Strategy Development, Physical and Logical Data Modeling, SQL - Complex Query Writing; Performance Tuning, SQL Loading; ETL process, Oracle Application Development 11.0.3[HRUS] HR employee and benefits module; Based HR Reports development; PL/SQL based development; Forms and Reports Development, Database Design, Creation and Configuration, Security Management, .NET based development, Change Control, Data Warehousing, Systems Development Life Cycle (SDLC), Peoplesoft Development SOFTWARE: SQL, SQL*PLUS 3.X,8.X, 9iDS, 9iAS, PL/SQL 2.X, 8.X, 9.0.1,10g Developer 2000 (Forms 4.5,6i,9i,10g / Reports 2.5,6i,9i,10g), , Oracle Designer 6X,9X,10g, SQL Developer, Erwin3.5,4.0, Oracle Application 11.0.3 [HRMS], SQL Loader, Oracle Warehouse 8.0.1, 9.0.2, Interactive SQL, Oracle Enterprise Manager Console 9.2.0.1, FTP, UNIX Shell Scripts, Microsoft Office 97, SQL Modeler 6.1 , Toad 5x,6x,7x, Powerbuilder 4.X, 5.X, Visual SourceSafe ver.6.0 , Crystal Report 4.,6.,7, XI Release 2 , Peoplesoft 8.4, 8.52., SQR, Peoplecode, QueryReporting, XML Publisher, App. Designer(People Tools) 8.XResponsibilities: (2010 - Present)As Peoplesoft Developer During last five years responsible for work related to Financial and HR departments of the County of Chester. I have been involved with Customers, Purchasing, Procurement Contracts, Billing, Accounts Receivable, Accounts Payable, Asset Management, Manage for result, Supply Chain and General Ledger business development processes. I created a lot of Custom Queries, modified and created a lot of pages, peoplecodes, loading and FTP processes and reports.(Peoplesoft , SQR, Peoplecode, QueryReporting, XML Publisher, People Tools, Crystal reports)(2003 - 2010) As Database and application developer • Responsible for designing the project model and creating Logical and Physical Schemas, loading scripts (ETL), creation set of applications .......... Show less



VerticalNet Horsham PA

• Oracle Developer / Analyst

  • Jan 2001 - Jan 2002

  • Experience in designing, developing, and implementing client/server Object-Oriented business applications. • Responsible for designing the project model and creating functional design specifications. • Responsible for creating Employee Benefit, Turnover, Compensation and Employment Statistics Reports for HR and Financial Departments. [Oracle Application 11.0.3 / HR Module, PL/SQL, Developer2000] • Registering Oracle Reports, and SQL* PLUS Concurrent Programs into the Concurrent Manager, setting up input parameters and creating schedules. Analyzing business processes and developing requirement specifications. Creating Membership Electronic Transfer Systems according to customer requirements, troubleshooting, generating reports and loading into the UNIX Box. Responsible for creating crontab file and UNIX Shell Scripts to handle execution processes. Clients included: Eckerd, Independence Blue Cross, DeltaDental, VSP, Cobra, Hartford Inc. (Oracle 8i, PL/SQL, Toad, Report 6i, Oracle Application 11.0.3 [US HRMS], FTP, UNIX) • Responsible for developing all stored procedures for updating the Oracle 8i database (APPS Schema). • Responsible for creating control files for SQL*Loader. Migrating HR data from spreadsheets into Oracle database using SQL*Loader Utilities. • Portal configuration • Customizing existing Oracle Applications using Developer 2000 (Forms 6i and Reports 6i), Discoverer, Toad, SQL and PL/SQL programming. • Involved with the technical aspects of Oracle Financial Applications, including customizing Reports for Financial Reporting. Show less



ASI Business Solutions Inc. King of Prussia PA.

• Consultant

  • May 1998 - Jan 2001

  Clients/Projects: ‘ASI e-Pharma’ • Participated as a team member in the development of a new product designed specifically for a pharmaceutical company. • Tools used in the development of the product included Internet Information Server (IIS), HTML, Java Servlet, Java AWT, JDBC , Oracle 8i and Oracle Forms and Reports Builder 6.i. ‘BetzDearborn’ • Responsible for analyzing schema and developing Invoices, Sales, History, Order, Inventory, Profitability, Delivery and Contract reports. Developed required documentation. Used: (Crystal Reports 7.0, Access 97 as a Front-end and Access 97, Oracle 8.0.5, Sybase Central 6.X as a Back-end. ) Responsible for creating main Views , Triggers and PL/SQL Procedures. Required to make data population and Unit tests. Modified Electronic Order System (Oracle 7.1 and VB 6) ‘ GlaxoSmithKline’ • Participated in Enterprise Data Warehouse design and development of front-end reporting system , complex database triggers and stored procedures for GSKDW Data Warehouse project. (Oracle8.0.5, Oracle Warehouse 8.0.1,PL/SQL, Oracle Report 6.1) ‘Unisys for VWR‘ • Designed Oracle customer service database and application using Designer and Developer 2000. Participated in design [Erwin] Oracle customer service database, development and implementation of client-server based applications including Purchase Request Authorization, Exception and Order Reporting. Systems were developed using Developer 2000 (Reports 2.5, Forms 4.5 ) as a Front-end and Oracle 7 as a Back-end. Responsible for coding and creating Applications and Menus. Developed complex database triggers, stored procedures, functions and packages using PL/SQL. Data population (SQL*Loader ), performance, modification and unit tests. Show less



Comp Serv. Consulting Company. Southampton PA

• Programmer

  • May 1994 - May 1998

  • Participated in design, development and implementation of client-server based applications including Report Manager Information Systems and a group of base reports for MaxNet insurance company. The systems were developed using Powerbuilder 4.5, Access 2.0 as a Front-end and Oracle 7 as a Back-end. Logical Part: PL/SQL Procedures, Triggers. Created graphical user interfaces for a simulated small business accounting management system. Participated in the Visual Basic programming for modules of Employees and Payroll. • Learned to use ErWin to create data models. • Participated in a group of developers responsible for Conversion Y2K Project. Investigated and implemented Data Conversion Project from FoxPro to ORACLE database employing ErWin and SQL*Loader Utilities. • Responsible for modifying and testing existing Reports for Niko System Inc. [Customers, Order, Delivery, Sales and Invoices] (Oracle 6., PL/SQL, Reports 2.0) Show less



AzerElectroPribor Inc. Azerbaijan USSR

• Engineer

  • Jan 1993 - Dec 1993

  • Worked as a support programmer on automatic data control systems, which included troubleshooting, customer education and support, technical reports and routine testing procedures • Worked as a support programmer on automatic data control systems, which included troubleshooting, customer education and support, technical reports and routine testing procedures