SUMMARY

• 8+ Years of business and project management experience with in - depth knowledge of business processes in retail, banking and higher education industries.
• Expert knowledge in PeopleSoft campus Solutions with two successful implementations projects.
• A thorough understanding of the Software Development Life Cycle (SDLC) including but not limited to the various concepts such as Requirement Gathering, Experience in the development of Client-Sever and Web-Based Applications.
• Possess a detail-oriented nature with excellent communication, interpersonal, problem solving skills, and recognized for being a valued team leader.
• Successfully implemented BI solutions on oracle and SQL server platforms

TECHNICAL SKILLS

• PeopleSoft Campus Solutions 8.9 9.0
• PeopleSoft FSCM 9.0 9.1 9.2 (AP eSettlements PO)
• PeopleSoft HRMS
• SQL
• PL/SQL
• SQL Server 2008
• SSRS
• SSIS
• SSAS
• Oracle 8i/11g
• XML
• DB2
• Rational Unified Process
• Waterfall Methodology
• Agile
• Rational ClearQuest
• ReqPro
• SAP HANA
• SAP BODS 4.1
• BO Xir2
• JAVA
• J2ee
• JSP
• PHP
• HTML
• CSS
• JC
• VBA
• MS Visio
• MS Project
• HPQC
• MS Office
• VBA
• IMAGENOW
• SharePoint
• UML

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Senior Functional Analyst

Responsibilities:

• Act as a shared resource for PeopleSoft financials upgrade and integration across two different state agencies
• Research a list of various jobs, processes, interfaces and stream lined the process of managing these resources, helped in saving time and faster resolution to any requirement changes or errors.
• Develop system Use cases which describe the intended use of the system, and design logical and physical data models for the unemployment insurance module
• Set up Account Receivables module which is responsible for the entry of accounting transactions and outstanding receivables, handling employer\claimants payments, managing payment vouchers, and creating customer correspondence such as customer statements and dunning letters
• Worked in Accounts Payable application which is used to enter payment vouchers (online or batch) and make payments to vendors or employer
• Gathered requirements for enhancing the General Ledgers to record actual (periodic financial data), budgets, forecasts, statistics
• Created an Excel to CI interface for inputting multi line vouchers information on to the PeopleSoft Financials
• Re-Engineer and Decompose business and user functional requirements into system and software functional and non-functional requirements
• Determine data m migration scenarios and identify possible risks
• Perform data validation activities and resolve any issues. Investigate data integrity questions and coordinate resolution. Perform GAP Analysis, to identify any gaps and suggest improvements
• Facilitate and lead the JAD sessions with SME’s Developers and conduct focus group studies
• Work with architects to define XML schemas, for data exchanges with external vendors
• Independently negotiated and defined realistic expectations (internal and external) with project team and stakeholders. Created Traceability and priority matrix
• Manage a team of 4-business analyst and a QA; assist them in various projects by getting resources and knowledge as needed. Manage projects using a SDLC and PM approach.
• Compiled a list of 5000+ critical reports for the employer domain in order to kick-start the migration from legacy mainframe systems to new MS SQL environment. Conduct testing such as developing test plans (i.e., integration, stress, and UAT) and schedules, test scripts, test data, use cases, and roles and responsibilities
• Defined project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders. Estimate the resources and participants needed to achieve project goals
• Develop and deliver progress reports, proposals, requirements documentation and presentations

Confidential, Brooklyn, NY

Senior Business Analyst/Project Manager

Responsibilities:

• Lead the Student System Integration from NYU-POLY Graduate admissions, as the institute is merging with NYU as of Jan 1 2014. Both campuses are on People Soft Campus Solutions 9.0
• Led functional fit/gap sessions with upgrade from PeopleSoft 8.X Student Admissions implementation team in preparation for a PeopleSoft 9.0 upgrade. Identified and documented current AS-IS business processes. Documented, proposed, and recommended possible solutions to identify (FIT-GAP) gaps in functionality.
• Experience implementing the AAWS for Polytechnic Institute and mapping data as needed.
• Fully integrated the academic advisement module onto the current business process and assisted in training faculty on academic advisement functionality
• In depth knowledge in Admission, Student Records, Financial Aid, and Academic Advisement modules
• Gathered business requirements for application functionality enhancements using the Accounting Module
• Created an Excel to CI interface for inputting prospect information on to the PeopleSoft Campus Solution system of records
• PeopleSoft HRMS experience on analyzing, gathering, testing, and maintaining applications and modules that improve processes.
• Worked and Supported PeopleSoft ERP upgrade (Benefits, Accounting Module)
• Reverse engineered, created and developed project documentation including: entity relationship diagrams, use cases, data flow diagrams, data dictionaries, business processed, project scope, business fit assessment and targeted presentations. Created Traceability and priority matrix
• Created BRD, FRD’s, Process Flows, Swim Lane Diagrams etc., as part of extensive project documentation for app sys
• Conducted Gap analysis to understand new business model and additional functionalities to be incorporated in to the new application. Defined various test cases and performed UAT testing
• Have shown exceptional operational workflow efficiency improvements in the effect of 30% improvement, which had a direct impact on improving revenues by 20%
• Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
• Create proof of concepts and ability to analyze project needs and determine resources needed to meet objectives and solve problems. Create training material and planning the sessions.
• Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
• Documented various documents including the Business Requirement Documents and the Use Case Specification Documents. Extensive use of Visio, Excel and PowerPoint
• Created job-aid and training materials using PeopleSoft UPK
• Set up, defined and managed SharePoint sites, and trained end users in effectively utilizing the shared sites.
• Used Rational Requisite Pro as requirement gathering tool. Facilitated various JAD sessions
• Conducted analysis and prototyping, implement external data loads, as well as assist in identifying customization, interface and conversion requirements

Confidential, Brooklyn, NY

Business Analyst

Responsibilities:

• Led all aspects of a 24-month PeopleSoft campus solutions 8.x implementation from the planning stage to post go live. The scope of this implementation included almost all of the Student Admissions functionality also including self service payments, payment plans, third party sponsors, billing, accounts payable refunding, enrollment cancellation and General Ledger interface. Documented, proposed, and designed many solutions to identify gaps in functionality
• Created new enrollment reports showing trend and growth, also to estimated financial aid expenditure
• Configured the 3C’s in PeopleSoft Campus Solutions - Admissions and recruitment, configured and setup custom pages to show data from 3rd party services
• Modified and developed SQR & Crystal Reports. Created & executed unit test plans
• Created job-aid and training materials using PeopleSoft UPK
• Did system testing, setting up of run-control and process scheduler routines, performed unit and integrated system testing and validated all system functions before and after Regulatory updates were applied.
• Developed new module for financial aid application for PeopleSoft Campus Solution 9.0, which involves creating new objects, People code and Application Engine program to process Entrance and Exit aid counseling data from Central Repository.
• Created an Excel to CI interface for inputting multi line vouchers information on to the PeopleSoft Financials
• Identified all use cases components including basic, alternate and exception flows. Facilitated various JAD sessions and documented the meeting minutes, set goals and follow through goals.
• Participated in various architectural development sessions to provide technical teams with a better understanding of the requirements. Define testing plans for regression testing and co-develop scripts for the same
• Gathered business requirements for application functionality enhancements using the Accounting Module PeopleSoft FMS experience on analyzing, gathering, testing, and maintaining applications and modules that improve processes.
• Designed/implemented extensive custom interface to PeopleSoft's Accounts Payable.
• Gathered, Analyzed requirements and created use cases, use case diagrams, activity diagrams using MS Visio
• Gathering business requirements with SME’s and converting them into functional requirements specifications and user requirement specifications. Created Traceability and priority matrix
• Carried out detailed and comprehensive business analysis with the RUP Methodology.
• Prepared Business Process Models, which included modeling of all activities of the business from conceptual to procedural level. And Create functional specifications to support people soft modules.
• Organized and led Change control meetings recommending appropriate action after analysis and re-engineering of changing requirements.
• Conducted multiple interviews to clarify requirements in order to identify use cases and document UC Specifications. Manage a version control tool for all codes and documents
• Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements. Provided training to users, and involved in conducting UAT sessions to gain user confidence and approval.
• Performed requirement walkthroughs with the Dev. And QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs.
• Created and managed a report repository of 60 various reports engaging all levels of the management and wrote complex SQL Queries and procedures to generate these reports
• Hands on work experience with data warehousing project for building a reporting module and also for students information system, working with various data sources and making use of SQL SSIS to perform ETL, and SQL SSRS and SSAS to perform various reporting tasks and data analysis

Confidential

Business Analyst

Responsibilities:

• Performed Gap Analysis, conducted walkthroughs and acted as a liaison between the business users, stakeholders and the team to perform requirements, quality and risk analysis.
• Managed and mentored a team of 4 software developers.
• Developed UML models and use cases
• Designed and developed a data warehouse, for the analytical reporting module.
• Involved in all phases of Software Development Life Cycle (SDLC).
• Used MS VSS for version control system and excel based Issue Tracker for bug tracking.
• Developed applications using Java, J2EE, EJB, Struts, JSP and Servlet.
• User Training-worked with user community closely to train them and explain various features to them. Conducted online webinars and demo’s to train the end users.
• Developed database schema and SQL queries for querying database on Oracle 9i.
• Designed and developed application using Java; Developed SQL queries and stored procedures for the application; Worked with JDBC and modified SQL Queries for better performance; Worked with front end using JSP, HTML, JavaScript and CSS; Involved in code Review and documentation as per company standards.
• Comfortably worked on oracle 8i based data warehousing project for business objects reporting and made use of Oracle stored procedures to map data together to a central repository.
• Designed and developed a web based single sign on java application.