We provide IT Staff Augmentation Services!

Peoplesoft Time Resume Profile

Houston, TexaS

EXPERIENCE SUMMARY

  • 10 years of diverse experience in Business Process Analysis, Business Requirements Gathering, Gap analysis, Process Implementation and Quality Assurance.
  • Comprehensive experience with Object Oriented Analysis and Design using UML, Rational Unified Process RUP , the Waterfall life cycle, Agile, Rational Suite Rational Rose, Rational RequisitePro
  • Performed Data analysis at various levels, created Use Cases and Activity diagrams using UML tools such as Rational Rose and Microsoft Visio
  • Experience in conducting Joint Application Development JAD sessions to converge early towards design acceptance to the customer
  • Expertise in writing Complicated PL/SQL procedures and triggers in Oracle
  • Experience in creating scripts and automating tasks to process input files using process scheduler
  • Expertise in creating defect logs for various environments
  • Ability to define, document business user requirements and translate those requirements and objectives into business/technical requirements based on project scope parameters
  • Extensive experience in Manual, Automated and Load testing of integrated applications
  • Good Experience in Excel Add Ins XLA technology
  • Comprehensive experience in business analysis, gap analysis, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors
  • Experienced in handling Change Management and Release Management
  • Proficient in Microsoft technologies, with special expertise in MS Excel, MS Access, MS Project, MS Word and other MS technologies
  • Ability to perform UAT, Integration, Functional and Parallel Testing
  • Extensive experience successfully evaluating, selecting, and implementing medium to large scale projects
  • In depth experience with small, mid-size, and large organizations
  • Experience working with Oracle and SQL Server databases

TECHNICAL SKILLS

Operating Systems

Windows

ERP

PeopleSoft 8.X

Programming Languages

VBA, Peoplecode, VB 6.0, C, C ,VBA, Java

RDBMS

Microsoft SQL Server, Oracle, MS Access

Tools

Expert in MS Office, PeopleSoft tools

Certification

Bloomberg certified in Equity

PeopleSoft 8.X certification

PROFESSIONAL EXPERIENCE DETAILS

Confidential

Role: PeopleSoft Time

  • Developed complex mappings to extract source data from heterogeneous databases SQL Server, Oracle and flat files , applied proper transformation rules and loaded data from Legacy system into PeopleSoft.
  • Assisted in setting up workgroups, Time and Labor Pay-rules, leading the customization effort, working with Project Costing team to publish the estimate and actual to Project Costing, Re-Configuration of new earning Codes, Processing Timesheets, Payroll and testing.
  • Wrote high level test plans and detailed test scripts for Time and Labor and Payroll.
  • Created Time and Labor functional and technical specifications and worked in tandem with the technical team on implementation of all customizations including page changes.
  • Instrumental in the creation of Custom TRC mapping table/page which drives the list of available TRC's on the Time reporting page
  • Heavily involved in the development/testing of banking and de-banking rules for Canada T L Module
  • Analyzed the logical model of the databases and normalizing it when necessary

Environment

PeopleSoft 9.1, Oracle 11g, Toad for Oracle, SQL Developer

Confidential

Role: Senior PeopleSoft Business Analyst Payroll and Time systems

Project Details:

  • Involved in integrating data from Kronos into PeopleSoft system
  • Involved in the production support of time and payroll systems
  • Lead the transition of payroll and time systems from PeopleSoft to SAP
  • Worked as Liaison between user community and project team
  • Prepare the forecasting and capacity planning of resources in the project
  • Developed a Proof of concept for a data archival model outside of PeopleSoft using MS Access
  • Involved in complete post-tax-update testing and support of all HR and Payroll modules
  • Worked on creating interfaces between PeopleSoft and ADP to enable ADP to scan paychecks sent from Tenaris.
  • Responsible for Configuration and setup of PeopleSoft HR, Payroll, Base Benefits and Benefits Administration configuration tables based on enterprise and workforce structure
  • Provide statuses to the client on the operations on a weekly basis
  • Identify areas where project can grow

Environment

PeopleSoft 8.8, Oracle 11g, Toad for Oracle, SQL Developer

Confidential

Role: PEGA BPM Business Analyst

Project Details:

  • Work with a team of 23 people on executing the PEGA roadmap strategy for NEW clients
  • Understand new areas of business in the extended warranty space and assist in documenting Business Requirement Documents
  • Work with Business users in prioritizing tickets in the JIRA tracking system for each monthly cycle
  • Assist in client conversions from the Oracle system to the Pega environment
  • Gather business requirements for incorporating enhancements to the functionality of the existing system and translate these business requirements to system specification documents
  • Provide functional assistance to the IT team during the development phase
  • Assess the capabilities of the IT system and perform fit gap analysis
  • Create, design, and format technical specifications including descriptive text, process flows using Microsoft Visio , and other information needed to describe required system changes for development, QA, and other units and co-ordinate the accomplishment of these functions
  • Provide support to applications in production by tracking production problems and assist in troubleshooting them to sustain the application in the production environment
  • Develop use case scenarios and user acceptance testing UAT documentation in MS Word and MS Excel during each monthly bundle release cycle
  • Coordinate User Acceptance testing with frontline agents and supervisors during the UAT cycle
  • Provide Post Install Validate PIV scripts at the end of each production release to ensure system stability post monthly bundle release
  • Interact with end users to understand their issues and identify potential areas for system enhancement
  • Clarify any questions with regards to the functionality of the system with business and system users
  • Document business rules for sales load files SLR Data received from clients and Identify issues and suggest alternatives/solutions for issues identified in these sales load files
  • Understand and document the business operations of clients to implement the same in the Pega environment
  • Work with reporting team to scope out reports required while migrating from legacy system to the new system
  • Take part in the meetings with managers and understood various process plans, business process, and functionality in detail

Environment PEGA V6.1,5.5 , Oracle 11g, Toad for Oracle, JIRA tracking system

Confidential

Role: Business Analyst

Project Details:

  • Developed an advanced quality data management application in MS Access
  • Oversaw large project teams and ensured all functions are fulfilling the necessary requirements and projects are driven to scheduled completion. Worked closely with lead engineers, Product Development Managers, Marketing Managers, Vendors, and Customers' lead project managers
  • Performed GAP analysis for the modules in production, conducted feasibility study
  • Streamlined the supply chain processes followed at Siemens as part of a six sigma/lean initiative
  • Prepared Project Plan using MS Project
  • Conducted testing, created defect logs and fixed bugs in the Applied Quality Data Management AQDM application
  • Conducted Risk Analysis to identify the risks associated with developing the new system
  • Interfaced with field engineers and service engineers of the Generators division and collecting data from different quality control systems
  • Interfaced with generator experts in analyzing and mapping data
  • Created reports for process improvements and trend analysis
  • Assisted in documentation of Functional Requirement and Functional Specifications for data mapping
  • Developed Business Requirement Specification BRS documents and designed and developed all Use Cases and UML diagrams using Microsoft Visio
  • Established a Business Analysis methodology using the Rational Unified Process RUP by following business process models in it to document existing and future business processes
  • Developed a user friendly input system that is used to input all quality control mapping data
  • Performed system data reconciliation and generated reports
  • Generated reports by fiscal year to identify key problem areas in generator production
  • Key contributor in requirements gathering, development, implementation, training and maintenance of the Strategic Data Management SDM tool
  • Conducted several group Joint Application Design JAD meetings to determine scope and requirements of product
  • The SDM tool developed in MS Access revamped the processes followed in the Generators quality department
  • Acted as a liaison between Engineering, Procurement, internal and external Manufacturing teams to insure that all required hardware components were defined, ordered, and delivered on time
  • Monitored and tracked projects, ensuring project utilization of project resources
  • Conduct data reconciliation in MS Excel
  • Integrated the purchasing, load management, commodity management and tendering departments of the Generators department
  • Gathered and analyzed UAT requirements from key stakeholders, and subject matter experts SME's from the existing system

Environment MS Access 2003,Lotus Notes, MS Office 2007 suite, SQL, Windows 2000 Advanced Server

Confidential

Role: Business analyst

Project Details:

  • Engineered, designed and developed MEDUSA - built in MS Access prototype in MS Excel as an inexpensive alternative to expensive ERP based admission tracking applications
  • Gathered functional requirements of the business users and built tool from scratch
  • Conducted several group Joint Application Design JAD sessions and follow up meetings with business stakeholders and users
  • MEDUSA Managed Education System Application MEDUSA runs independent of a database
  • MEDUSA is capable of data storage, retrieval and running reports
  • Documented requirements and training for users of MEDUSA
  • Interfaced MEDUSA with legacy system Sunguard
  • Wrote elaborate system and Business Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams
  • Identified and documented issues, risk and Gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements
  • Prepared Logical Data Models that contains set of diagrams and supporting Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level
  • Participated in and documented the design of new or changing mappings and workflows and producing requisite specifications
  • Documented Use Cases using UML standards
  • Documented Business Process flows and Functional specifications
  • Created graphical sales summary reports using MS Excel, by importing data from the Oracle database

Environment MS Access 2003, Lotus Notes, MS Office 2007, SQL, Sunguard, Oracle 9i

Confidential

Role: Business Analyst

Project Details:

  • Part of 10 member team involved in developing a five year strategic plan for warehouse operations to support company growth
  • Created a supplier management software system in MS Access
  • Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes
  • Interacted and interviewed internal SME's to define, analyze, and deliver Customer requirements and lead meetings for validation of models
  • Used Rational Unified Process RUP as the Software Methodology
  • Analyzed and optimized the process, Prepared Business Requirement Document and then converted the business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite pro
  • Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams DFDs , ER Diagrams using Rational Rose, thus defining the Business Process Model and Data Process Model
  • Assisted in technology selection for the application, based on Cost-Effectiveness and Quality with an eye towards the future
  • Performed Feasibility, Adaptability and Risk Analysis to identify the high-risk areas of the application
  • Communicate with design, development and test team using MS exchange Messaging and Defect Tracking System
  • Used the Unified Change Management UCM tool, Rational Clear Quest, to maintain and track the Stakeholders requested enhancements and changes
  • Worked with Operations departments with goal of improving warehouse operational efficiency
  • Created financial forecast models in Excel for the Accounting Department
  • Created a software system to track the customer returns implementing closed loop supply chain concepts
  • Created processes and procedures to increase efficiencies with warehousing, delivery, human capital, and forecasting for product ordering
  • Conducted cost analysis for 250K operations efficiency budget
  • Determined inventory variance to improve efficiency necessary to support delivery and fleet operations
  • Refined inventory logistics to achieve revenue growth and support warehouse operations
  • Conducted presentations for the management and training workshops for the clients
  • Assisted with user testing of systems

Environment MS Access 2003, MS Office 2007, MS Visio, MS Project, Share Point

Confidential

Role: Business Analyst

Project Details:

  • Gathered and synthesized detailed Business Requirements for Business Rules Engine
  • Documented Business Rules
  • Developed As-Is and To-Be Process Flow Diagrams
  • Created an inventory management system for HP, Singapore in MS Access
  • Created Functional Requirement Specifications FRS based on User Requirement Specification
  • Derived Systems Requirement Document based on Functional Requirement Specifications
  • Used guidelines and artifacts of RUP to strategize the implementation of Rational Unified Process effort in different iterations and phases of software development life cycle
  • Documented the use cases and prepared the use case, activity, logical, component and deployment diagrams using MS Visio for a clear understanding of the requirements by the development team
  • Coordinated with the offshore development team in France during Construction phase
  • Liaised with the technology team to derive Functional Requirements
  • Created reports for process improvements and trend analysis
  • Conducted Risk Analysis to identify the risks associated with developing the new system, and formulated a Mitigation Plan to eliminate or reduce risks of high severity and major financial effects
  • Conducted individual and group JAD sessions with business stakeholders and technical units
  • Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
  • Developed wireframes for UI screens
  • Applying Lean Engineering techniques and tools to achieve gains in process efficiency and quality improvement in business processes
  • Develop detailed ETL project plans, conversion/transformation specifications and data mappings based on requirements
  • Developed Project Plans using MS Project and identified potential areas of automation
  • Created Use Case specifications, Business flow diagrams Activity / State Transition / Collaboration and Sequence Diagrams using Rational Rose and UML
  • Defined and documented Interface specifications for system comprising mainframe, client-server and web applications
  • Perform Code reviews to ensure is compliant with the architecture and does not disrupt existing functionality
  • Troubleshoot issues encountered during release installations and recovered systems in case, a release had to be reverted
  • Provide management updates regarding SOX activities, test results, and remediation activities
  • Assure all documentation is captured and maintained for future reference and retrieval

Environment MS Access 2003, MS Office 2007, MS Visio, MS Project, Share Point

Confidential

Role: Business Analyst

Project Details:

  • Part of the HRMS/ Global Payroll implementation for NTUC Fairprice, Singapore with over 5000 employees
  • Conducted several group JAD sessions and follow up meetings with business stakeholders and technical partners to gather UAT related requirements
  • Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements
  • Established a Business Analysis methodology using the Rational Unified Process RUP by following business process models in it to document existing and future business processes
  • Designed and developed a Database system in MS Access creating a repository for all our UAT test data and also our Expected Results
  • Gather and analyze UAT requirements from key stakeholders, and subject matter experts SME's from the existing Legacy systems
  • Created Test Conditions, Test Matrix and Traceability Matrix for Test scripts in the PeopleSoft HR module and MS Excel
  • Created Test scripts and Test Cases based on Test Conditions for the critical functionalities
  • Developed excel models to calculate payroll reconciliation
  • Extensively worked and analyzed requirements of the HR team
  • Extensively involved in creating expected results for Screens, Interfaces, and Disclosure Reports for our downstream and upstream partners
  • Worked closely with the development team to understand the database architecture and the mapping between Logical Data Model LDM to Physical Data Model PDM
  • Written PL/SQL queries using TOAD to extract data from the Payroll database and store procedure to validate extracted data with expected results
  • Created reports for expected results and charts for analysis using Crystal Reports and Structured Query Reports
  • Queried multiple databases using PL/SQL to create executive level graphs for daily status meetings
  • Used Clear Case VOB for all our check-in and check-out activities for the UAT artifacts
  • Extensively used ICE Incident Change Enhancement for raising tickets
  • Prepared and provided 24/7 support in order to meet the deadlines and on-time completion of the tasks

Environment Oracle 10g, SQL Server 2003, MS Access 2003, Visual Basic, Clear Case, Clear Quest, Crystal Reports, TOAD, MS Office 2003, Share Point

Confidential

Role Business Analyst

Project Details:

  • Conducted individual and group JAD sessions with business stakeholders and technical units
  • Created PeopleSoft upgrade laboratory documentation database in MS Access
  • Established the business analysis methodology using Rational Unified Process
  • Helped develop use cases, project plans and to manage project scope
  • Assisted in building the business process model using Rational Rose
  • Performed GAP analysis of business rules, business and system process flows, and requirements
  • Queried database using SQL queries to extract data for analysis
  • Developed various reports for user verification like Cross Tab Reports and Sub Reports in MS Access , various charts and graphs like Bar charts, Line graphs, and Pie charts by using Crystal Reports
  • Provided key project inputs by working with users in defining the project and system requirements
  • Played a key role in the planning, testing, and implementing system enhancements and conversions
  • Assisted testing team for successful completion of Unit Testing, Integration Testing and Requirements Testing
  • Blend technical and business knowledge with communication skills to bridge the gap between business and technical objectives
  • Develop Data flow diagrams, Process models, ER diagrams, Dimensional data models, Context models, Event and State models, Activity diagrams, Process decomposition and Use Case Scenarios, using UML and RUP methodologies

Environment Windows, MS Office MS Word, MS Excel, MS PowerPoint, MS Visio , J2EE Technology, JAVA, RUP, UML, SQL, SWOT analysis, GAP Analysis

Confidential

Role: Business Analyst

Project Details:

  • Gathered and synthesized business requirements and translated into functional requirements to be used as input
  • to the design
  • Prepared project requirement tractability through project lifecycle
  • Created and managed project templates, Use Case templates, requirement types and traceability relationships in
  • Rational RequisitePro
  • Organized and managed business and functional requirements and design review sessions
  • Supported and contributed to functional testing
  • Analyze and update change requests and the impact
  • Created a detailed Project Plan, identifying the various milestones, the associated success criteria and the critical
  • path analysis
  • Followed the UML based methods to create use case, activity/state chart diagrams
  • Coordinated and prioritized outstanding defects and enhancement system requests
  • Gathered training and user documentation requirements
  • Modeled Test Cases based on STLC Software Testing Life Cycle
  • Assisted in documentation of Functional Requirement and Functional Specifications for Bulk Import and Bulk
  • Mapping functionality
  • Created use case and activity diagrams for Bulk Mapping and Bulk Import functionality
  • Conducted review meetings with Business SME to get signoff on Data Elements to be displayed on screens and reports
  • Constantly monitored scopes, issues, and resolution identifications to ensure timely deliverables of all action items
  • and adherence to the overall project goal and milestone
  • Supported high level requirements documentation and the development of the configuration requirements,
  • Integration requirements, data requirements, and user interface requirements
  • Developed processes, process flows and narratives including the identification of data needs and controls
  • Conducted Risk Analysis to identify the risks associated with developing the new system, and formulated a
  • Mitigation Plan to eliminate or reduce risks of high severity and major financial effects
  • Reviewed integration test plan for integration between modules
  • Provided guidance to Project team to implement change request methodology, requirement traceability
  • matrix, maintenance of issue and risk log
  • Identified application control types of each requirement based on business functionality

Environment

HTML, VB, RUP, UML, SQL, MS-Office, MS Project, MS Visio, Test Director

Hire Now