Summary |
Dynamic and result oriented individual with leadership qualities and over 17 years of experience in various fields of Information Technology, Project management and Accounting. Possess excellent blend of business analysis, technical expertise, functional competencies and interpersonal skills. Areas of expertise include but not limited to PeopleSoft Financials, PeopleSoft Security Design and implementation, PeopleSoft HCM, PeopleSoft CRM, PeopleSoft Portal, Relational Database Analysis, Relational Database Modeling/ Design/Architecture, Web Development, SDLC, GAAP, SOX and Agile Methodology SCRUM . Eager to share and apply extensive knowledge in diverse areas of ERP System Upgrades, EDI, Project Management/Control, Data Analysis, Databases designs, Finance and Accounting. Possess strong sense of project ownership and commitment. |
essential skills |
- Active Secret Security Clearance from Department of Defense.
- Possess end-to-end Implementation/Upgrade experience gained over the years.
- Strong blend of Technical and Functional expertise in FSCM and HCM modules. Configure most PeopleSoft Financials modules. In depth knowledge of Business practices, accounting and GAAP principles. Interact with technical and functional staff at all levels.
- Act as the module functionality expert in planning, requirement collection, Fit/Gap Analysis, design documents, build, test scripts, training manuals, deploy and support phases of a project. Modules included but not limited to PO, AP, OM, INV, Manufacturing, BI, eBill, AR, GL, EXP, CM, PC, Cash Mgmt., AM, Payroll, Ben Admin, HR, Absence Mgmt., ELM, Time and Labor, Security etc.
- Integration specialist using Web Services leveraging HTML protocols. Utilizing REST, SOAP, WSDL. Extensive knowledge of transferring XML, CSV and JSON files between systems. Led many integration projects. Experience working with external vendors and teams on integration of PeopleSoft with 3rd party applications.
- 13 years of PeopleSoft development skills using tools like Application Designer, Application Engine, Component Interfaces, SQR, Crystal Reports, PeopleCode, App Packages, ExcelToCI, nVision, XML Publisher and PeopleSoft Query. Develop effective and feasible business area solutions.
- PeopleSoft decommissioning activities e.g. data transfer activities, security access changes, develop training manuals using UPK. Extensive knowledge of PeopleSoft Test Framework.
- Extensive experience in Project Management and Project Control activities using state of the art software and Agile Methodologies SCRUM .
- Full understanding of project life cycle and development SDLC methodologies.
- Ability to Research existing software components and technology, explore design and infrastructure options, and recommend solutions based on customer requirements
- Formal training on Web Services, SOA, BPEL, Composites, Database Adapter, Mapping
- Translate business requirements into functional specifications
- Extensive Data Modeling /Data Design / Data Analysis / Data Extraction/ Data Transformation expertise. Create Cubes via OLAP approach.
- Experience planning and designing data conversions and re-populating of operational databases
- Data warehouse design using star and snow flaked schemas.
- Relational Database Design ERD expert based on business requirements.
- Experience in PeopleSoft Applications - 7.5 to 9.2
- PeopleSoft Tools - 7.5 8.45 8.5x
- Relational databases ERD, SQL, PL/SQL and database applications such as MS Access, Oracle, Ms SQL Server and SSIS Packages.
- Computer Networking, TCP/IP, Network Administration/ management, Trouble shooting.
- Operating systems such as 95, 98, NT, 2000, XP, UNIX
- Web design, HTML, ASP. Proficiency in tools such as Front page, Flash and Dreamweaver
- XML, XSLT
- Programming in C, C , Visual Basic, Visual Basic for Apps, VB Script, Java Script
- Other general-purpose applications such as MS Word, Erwin, Excel, lotus 123, Word Perfect, PowerPoint, Microsoft Projects, Primavera Project Planner and Visio.
- Practical experience with book keeping and managerial accounting
- Strong inter-personal, presentation, writing and communication skills.
|
AREAS OF Experience |
Confidential PeopleSoft Principal Consultant Technical /Functional Lead Extract, Analyze, integrate/Load US Air Force data into PeopleSoft HCM 9.2 and Tools 8.53. Old legacy systems will be decommissioned gradually as data moves over. These activities involve utilizing state of the art IBM InfoSphere ETL tools. Large volumes of data is being staged and analyzed. Data modeling activities are in process for uploading data into PeopleSoft HCM via SQR, ExcelToCI, Component Interface technologies and flat files like CSV, text and XML payloads. Complex Business rules/logic is required to transform data that resides in legacy and disparate systems. The goal is to standardize Air Force Personnel day to day operations with minimal manual intervention and eliminate potential errors. PeopleSoft Workflow will be incorporated /developed for multi-level authorizations. This PeopleSoft HCM solution will integrate many existing personnel and pay processes into one self-service system. HCM will undergo heavy customization over time as USAF data is unique and massive. |
Confidential PeopleSoft Integration Lead Techno Functional Role Heavily involved in integration and conversion activities since Radiant System's acquisition by NCR in August 2011. Decommissioning of PeopleSoft led me to complete Customer, Purchasing, Cost and Pricing conversion from PeopleSoft 9.1 into Oracle Financials eBiz while demonstrating abilities in the areas of Business Analysis / Technical Leadership. Initially I had integrated PeopleSoft with home grown .NET applications and PeopleSoft Vantive Non-Web based utilizing Integration Broker Services and Service Operations Web Services . Large volumes of data had flowed between systems in real time via multiple Web Services. Activities also involved translating Business Rules into technical specifications encompassing writing complex extraction scripts. Large flat files and complex stored procedures were also used to carry data between systems. In addition to the above we were utilizing SOA Service Oriented Architecture to integrate PeopleSoft Product manufacturing Module with Radiant Systems' home grown applications. I was the sole individual creating PeopleSoft Web Services for all integration points and assisted SOA team with mapping activities. Home grown applications were .NET based. Vantive was another application that was integrated with PeopleSoft via Web Services. I have successfully completed this project with flying colors. During the process of Integration I have acquired a great deal of Oracle eBusiness suite knowledge including functionality and data structure in the areas mentioned above. PeopleSoft Security was modified along different phases of the project as modules of it were decommissioned gradually. |
Confidential PeopleSoft Technical/Business Analyst / Security Admin - Actively led several modules during upgrade of PeopleSoft 8.0 to 9.1 application along with tool to 8.5x. Responsibilities include Technical Design Specs, Security Requirements and implementation, Workflow, Data Conversion and mapping, identification of tools needed for conversions, Creation of scripts, training and Go Live Activities .
- Successfully developed and implemented various applications utilizing cutting edge technology like XML Publisher and Web Services. Created complex Invoicing system that helped finalize, print and email invoices in a single run.
- Command over Row level, Permission list based and process based Security methodologies. Established several security models including dynamic security processes during my career. Highly proficient in revamping existing security to business needs.
- Integrated web-based and non-web-based applications to PeopleSoft via Web Service and Service Operation calls.
- Provided expertise in functional and technical areas of PeopleSoft especially in Quote to Cash, Procure to Pay, Inventory and GL. Currently responsible for Quote to Cash applications and production support.
- Worked with PeopleSoft BI, OM, AR, INV, AP, PO, CM and GL modules.
- Day to day activities include designing and Implementing complex applications and solutions using PeopleCode, App Engines, SQRs, XML messaging and IScript.
- Provided functional and technical advice to peers and subject matter experts in various modules.
- Undertook challenging assignments and projects and delivered them in timely manner.
|
Confidential PeopleSoft Technical Project Lead At UHS Pruitt, I solely led an integration project that required patient information to be pulled in from disparate databases into PeopleSoft. The project demanded that patients who were added into other systems be seamlessly converted into PeopleSoft customers on the fly. I successfully completed that project within the required timeline and within the budget allocated, proving my skills of data analysis, database design, command on PeopleSoft Integration tools and project management. PeopleSoft Application Engine and Component Interface technology was utilized to accomplish the above. PeopleSoft Security enhancements were made to make sure processes were run by certain roles in the business. |
Confidential PeopleSoft Techo-Functional Lead - Developed complex JavaScript hover over menu to replace PeopleSoft Portal delivered menu and implement it by modifying HTML objects, App Packages, delivered JavaScript and IScripts. Also, added multiple pagelets and footers and then use HTML, JavaScript and IScript to give it a custom look. Introduced custom Templates to replace some delivered ones.
- PeopleSoft lead solely owning and managing PeopleSoft Security, HR, Payroll, Benefits, BI, AR, Expenses, GL, AM, PO and AP Modules. Experience with multiple upgrades.
- Modified Billing Interface from flat files XML and Excel spreadsheet into Billing via Component interfaces, File layouts and App engines.
- Made multiple enhancements to existing Expenses module using PeopleCode and Workflow to make expense processing smooth and seamless. Added email notifications via workflow as well.
- Worked on ACH Check Processing and printing of expenses in AP. It is comprised of complex PeopleCode, SQL and App Engines.
- Modified multiple crystal reports and nVisions across modules e.g. Customer reports, 1099 processing, Accounts Payable and Billing invoicing .
- Managed daily check processing Positive Pay Process , check printing in AP, Billing interface with AR and GL. Troubleshoot failed processes in most of the financial modules.
- Worked closely with Local and International accounting groups to ensure smooth accounting and helpdesk operation. Good understanding of CRM helpdesk functional and technical .
- Assisted users in nVision trouble shooting and reporting.
|
Confidential PeopleSoft Programmer Analyst - Responsible for several PeopleSoft modules including but not limited to AM, GL, HCM Payroll, Benefits, HR, Time Labor , BI, AR, PO and AP. Functionally very strong in most financial modules.
- Revamped PeopleSoft security and build it from ground up. Emphasized on component and row level security approaches.
- Designed, developed and modified PeopleSoft applications using complex SQR, App Eng, App Designer, PeopleSoft Query, Workflow, nVision, object oriented PeopleCode.
- Analyzed and evaluated user requirements against system capabilities and provide recommendations to successfully meet business objectives. Apply strong functional and analytical business knowledge.
- Wrote application code and translate business functional documentation into technical work plans. Demonstrate strong analytical and programming skills.
- Analyzed and created nVisions - GL reporting drilldowns and pivot tables
- Searched for new avenues of improvement in diverse areas and suggest its potential benefits.
|
Confidential PeopleSoft Technical/Business Analyst /Security Administrator - Involved in upgrade from PeopleSoft 7.5 to 8.42 and then to 8.8.
- Involved in Full-Life-Cycle implementations of PeopleSoft.
- PeopleSoft Security administrator.
- Designed and developed user applications utilizing PeopleSoft Tools App Designer, PeopleSoft Code as well as relating tools like SQR, SQL, App Engine, nVision, Workflow
- Modified existing applications in environments like - 7.5,8.42 , 8.8
- Developed ad-hoc queries for users that help in smooth execution of their everyday job
- Troubleshot several different modules in PeopleSoft Financials on daily basis
- Payroll, Benefits, Accounts Payable, Purchasing, Inventory, Asset Management, Projects, Billing, Accounts Receivable, General Ledger, Order Management, Costing and Production Management
- Trained new employees to utilize PeopleSoft modules for smooth execution of their daily activities
- Queried raw data to formulate meaningful reports using Seagate Crystal Reports
- Involved in extensive testing of all the above mentioned modules, associated business functionality and processes
- Created procedures/notes for end users and answer their questions regarding PeopleSoft applications - 7.5 ,8.42, 8.8
- Monitored EDI and trouble shoot transmission problems.
- Designed databases ERD / Administration / write SQL scripts and schedule
- Designed and implemented PeopleSoft 7.5, 8.4, 8.8 user security.
Web/ Ms Office Application Developer - Led and developed web applications for company Intranet/Internet using ASP, JavaScript, HTML and DHTML.
- Experience in layout and logical workflow of reporting systems
- Demonstrated Accurate project and time tracking ability
- Developed and managed Software business applications for company portal
- Ability in software architecture design and maintenance with security operations
- Build/design Relational databases for applications in Microsoft SQL Server and Oracle Data modeling
- Translated user requirements into meaningful information for software application development
- Created stored procedures and use it in variety of applications
- Wrote complex SQL queries that help in smooth execution of daily activities
- Analyze and compile data into pertinent information
- Utilized state of the art tools like Visual Interdev, Dreamweaver, flash, Erwin, FrontPage,
- Create procedures/notes for end users and answer their questions regarding applications
- Undertook responsibility of heavy testing and implementation of applications
- Monitored progress and provide useful input. Solid verbal/written communication skills
|
Confidential Project Monitoring and Controls Specialist - Handled Project Management, Project Control and IT support activities during different projects, relating new construction and upgrade of Fossil Fuel and Nuclear Power Plants. Mastered most state of the art project management software tools including Primavera Project Planner P3 , Ms Project and SureTrack.
- Regularly analyzed critical reports relating project progress and costing. Assisted senior management by providing analytical information regarding current and past performances of the projects vis- -vis Targets critical analysis/evaluation .
- Assisted management in tracking costs associated to daily activities through project tracking and scheduling.
- Worked as an efficient team member with our client Carolina Power and Light on issues concerning project management, project control and Technology infrastructure. Helped resolve pertinent issues.
- Helped prepare schedules, forecasts and estimates for time and material jobs.
|
Confidential Senior Accounts and Technical Officer - Responsible for Company Accounting Books, internal audits and procurement processes.
- Handled imports of IT equipment such as personal computers, mainframe computers, printers, digital copiers and fax machines from Japan, Taiwan and Hong Kong.
- Computer Network support specialist
- Manage an average team of 15 members technical support and implementations of LANs
- Marketed and Physically installed LANs for small to mid-size businesses
- Troubleshoot and configured computer networks
|
|
- Service Oriented Architecture SOA WSDL, BPEL, SAOP, Database Adapters
- Agile Methodologies SCRUM
- Oracle User Productivity Kit UPK
- PeopleSoft Application Designer Tools - 7.5 8.45 8.5x
- PeopleSoft Query and Security
- PeopleSoft Application Engine
- MCSE Training
- Project Management certification.
- PeopleSoft PeopleCode - Object Oriented
- PeopleSoft SQR
- PeopleSoft Integration Tools Integration Broker
- PeopleSoft Workflow
- PeopleSoft Order Management Functional Setup
- Item, Product , Order Management, Billing and Customer setup
|
|
- Honored to be a member of Habitat for Humanity Atlanta.
- Traveling, Fishing, Camping and social work.
- Cooking multi-ethnic food.
|