PROFESSIONAL SUMMARY

Senior Business Analyst with over 13 years of experience in Business Analysis, Data Analysis, Business Process Management, and Data Management. Worked in Transportation, Educational Services, Accounting, and Consulting Services Industries. Managed/Developed/Implemented/Analyzed Grant Management Systems, Student Records Management Systems, Integrated Tax Systems, Payroll Systems, Accounting Systems, DOT Delphi Financial Management System, Procurement Management Systems PRISM PASS , Public Debt Bilateral and Multilateral Management Systems, and Content Management Systems.

PROFESSIONAL EXPERIENCE:

Confidential IT Program/Portfolio Manager,

• Improved Project Management, SDLC Methodology, Requirement Development, Requirements Management, Configuration Management and Project Management Artifacts of the Washington Metropolitan Area Transit Authority WMATA , Enterprise Web Portal and GIS EWPG Group.
• Managed in collaboration with Senior Web Program Manager, the enhancement and maintenance of the WMATA's public and mobile websites developed using Adobe ColdFusion and MS SQL Server.
• Managed the Servers Upgrade Project, ColdFusion 8 to 10 Migration Project, Silver Line Web Updates Project, WMATA Website Redesign Project, and Metro Alert Mobile App Project.
• Improved the implementation of Agile/Scrum Framework. Collaborated with Senior Web Program Manager in creating, prioritizing and updating the Product Backlog. Facilitated sprint planning and release planning meetings between the Senior Web Program Manager and Development Team. Facilitated sprint review with client, Senior Web Program Manager and Development Team.
• Authored Project Charter, Stakeholder Register, Requirements Documents, Test Plans, Test Cases, Integration Plan, Deployment Guide, and Checklists.
• Elicited and managed requirements for the Metro Alert Mobile App Project. Documented Solution Requirements Specification SRS for the Silver Line Web Updates Project
• Catalogued the interfaces between the WMATA public and mobile websites, and other applications that interfaced through ODBC, SOAP, XML, and JSON.
• Outlined the CMMI Decision Analysis and Resolution DAR process that could be used in determining if cloud computing and which Cloud Computing Service Model IaaS, PaaS, SaaS should be used for hosting of the WMATA website.

Confidential IMS Project Task Lead/Scheduler,

NextGen is the Federal Aviation Administration's FAA vision of the National Airspace System NAS over the next 15 years. In order to understand NextGen's vision, goals, objectives, and implementation plan, conducted document analysis of the NextGen Concept of Operations ConOps , FAA Flight Plan, National Airspace System Enterprise Architecture NASEA , the NextGen Segment Implementation Plan NSIP , NAS Capital Investment Plan CIP , and FAA National Aviation Research Plan NARP . OST Inc. is CMMI Level 5 certified.

FAA NextGen Integrated Master Schedule IMS Schedule Support

• Developed and managed 5 portfolio schedules in Primavera P6 PPM, for FAA's 11 billion NextGen Implementation Plan, in collaboration with Portfolio Managers, Project Managers, Schedulers, and other Vendors.
• Developed with NextGen Portfolio Performance Measures and Metrics Working Group, a more quantifiable data driven metrics, measures and criteria to assess portfolios performance.
• Participated in the migration from the NextGen Integrated Master Schedule Portal IMS to the Corporate Work Plan Portal CWP .

Business Intelligence/Customization of Primavera

• Commercial-of-the-shelf COTS technology solution, Primavera, was customized to develop business intelligence product.
• Successfully implemented NextGen Solution Set Projects' Financial Reports that provided information on the Commitments, Obligations, Expenditure, Obligation Rate, Expenditure Rate, Cost Variance and Schedule Variance.
• Led the development of Business Intelligence BI Reports, and Dashboards Desktop and Mobile . Applied Waterfall methodology.
• Led Joint Application Development/Design JAD sessions. Elicited reporting requirements from vendor and client's staff actively engaged in generating reports. Authored Functional Requirements Documents using the traditional approach. Obtained approval of reporting requirements.
• Led two 2 Crystal Report Developers, in developing reports and dashboards for the IMS Portal that interfaces with Primavera, DOT Financial Management System Delphi , NAS EA Portal, and SPIRE.
• Led two 2 Business Objects Developers in the development of Mobile Dashboards for IMS.
• TOAD and Oracle SQL Developer were utilized to create and review packages, procedures, functions, and views. Visio was utilized to create mockups.
• Developed User Acceptance Test UAT Plan, Traceability Matrix, and Test Cases. Performed internal testing. Responded to UAT findings.
• Coached, and mentored team members in creating using ERWIN to create Data Models, and developing Design Documents
• Created draft Data Warehouse Bus Matrix in preparation for requirements elicitation.

IMS Project Schedule Update Workflow - Workflow Improvement

• Commercial-of-the-shelf COTS technology solution, Primavera, was customized to develop the IMS Portal. The IMS Portal was developed using Java/J2EE Architecture and Oracle 10g.
• Developed and managed requirements to improve the Project Schedule Update Workflow for NextGen Integrated Master Schedule IMS .
• Led Joint Application Development/Design JAD sessions. Elicited, analyzed, documented, and obtained approval of the Functional Requirements. Created and reviewed business process maps, and activity diagrams. Facilitated Workshops, Peer Reviews, Client's Requirements Structured Walkthroughs, and Design Reviews.
• Clarified and developed process logic for Java Developers to ensure correct interpretation and coding.
• Utilized IBM Rational Clear Case, Subversion and SharePoint for configuration management, and versioning control. Utilized Visio to create business process maps and activity diagrams.

Program Management Office PMO Support

• FAA Acquisition Management System has evolved over a period of time. Various groups have introduced specialized tools to meet the needs of some of the processes and some of the processes are still manual and paper-based. FAA's intent is to implement a Unified Contracting System UCS .
• Authored Functional Requirements Document FRD of PRISM using Object-Oriented Analysis and Design Approach. PRISM's functional requirements were incorporated into the Statement of Work SOW , used in evaluating and deciding whether to purchase a commercial-of-the shelf COTS Unified Contracting System or develop a custom solution.
• Analyzed and gained in-depth knowledge of the FAA Acquisition Management Policy and Guidelines, Procurement Guidelines, Procurement Management System PRISM and DOT Financial Management System Delphi . Elicited and analyzed the Requisition, Solicitation, Award, Post-Award and Closeout stages of the FAA's contract/acquisition life cycle.
• Participated in Business Process Improvement workshop, conducted to review 'as-is' business model and 'to-be' business model of the FAA Contracting System, with stakeholders from different line of business LOB and different locations.
• Used Microsoft SharePoint for configuration management. Used Lombardi Blueprint to model business processes. Requirements were documented in Requisite Pro.

Confidential RPTA Business Process Management Project Business Process Improvement

• Analyzed the current business and technical processes of the Assessment Division and Assessment Services Division of the Real Property Tax Administration of the Office of Tax and Revenue, District of Columbia, with the objectives of developing a roadmap to improve and streamline its operations and replace its existing integrated tax system.
• Applied Six Sigma Process Improvement Methodology DMAIC .
• Facilitated workshops, conducted one-on-one interviews, distributed questionnaires, observed business activity in operation, researched existing documentation, and analyzed existing applications.
• Led and motivated cross-functional teams. Interacted with executive and senior leadership, and tactfully offer suggestions for improvement and alternatives. Key stakeholders from cross-functional administrations within the Office of Tax and Revenue OTR included the Information Systems Administration ISA , Revenue Accounting Administration RAA , Returns Processing Administration RPA , and Real Property Tax Administration RPTA .
• Mapped current state against future state processes. Utilized UML artifacts such as Context Diagrams, Business Process Maps, Activity Diagrams, and Use Cases to document the Business Model, Business Rules, and Business Requirements.
• Identified issues that need to be addressed, and existing business processes that should be improved. For example identified the reason for loss of payment data during batch updates.

Tax Sale Integration Project System Integration

• Analyzed the Tax Sale business processes of the Real Property Tax Administration and developed functional and non-functional requirements for integration of the Client-Server Tax Sale applications with the Integrated Tax System ITS on the mainframe.
• Collaborated with Directors, Managers, Developers and End-users to analyze the Tax Sale Module.
• Led joint application development JAD sessions, conducted one-on-one interviews, distributed questionnaires, researched existing documentation, and conducted systems analysis of applications.
• Used workflow analysis, cause-effect analysis, affinity diagram, and gap analysis to analyze the business processes.
• Analyzed the data structure, and data quality of the DB2 database and FoxBASE database.
• Documentation of the end-to-end Tax Sale process did not exist. Mapped current state against future state processes. Utilized Visio to create the 'as-is' and 'to-be' business models Utilized use case specifications to document the operating procedures.
• Documented the business rules and data requirements documented the business requirements, using UML artifacts such as use cases and class diagrams, for integration of the stand-alone applications into the Integrated Tax System.
• Prepared the Functional Requirements Specifications which was used to prioritize, estimate duration, estimate resource requirements, develop schedule, and prepare costs estimate for the integration of the stand-alone applications into the Integrated Tax System on the mainframe.

Confidential Project Management/Business Analysis/Quality Assurance

• Managed the Development of a web-based Grant Programs Evaluation, Analysis and Report System GEARS to improve DCPS LEA's Budget Development, Financial Management and Program Management business processes for the management of federal grants issued under the No Child Left Behind Act NCLB . Conducted document analysis of the No Child Left Behind Act NCLB . Received in-house training in COGNOS and R-STARS. Analyzed the DC Government's System of Accounting and Reporting SOAR , which comprises of a suite of financial application to manage its revenue, grants, expenditure, and budget. R-STARS one of the applications, has Cost Accounting, Financial Management, Cash Management and Fixed Asset Management modules GRAMS, which is used to maintain a repository of the grants both private and federal. PASS, which is used to process requisitions, purchase orders, invoices and payment for goods and services CFO ource developed using COGNOS and Oracle , which is an Executive Information System, used for financial reporting, querying, and analysis Both PASS and CFO source are integrated with R-STARS.
• Deployed the Budget Development Module of GEARS and provided post-implementation maintenance and support. GEARS was developed using the .NET Framework and MS SQL Server.
• Applied the RUP methodology. To address scope creep, an agreement was reached to apply the RUP Methodology, which accommodated iterative and incremental software development. Product Backlog, grouped by modules was created.
• Managed client engagement and communications. Performed stakeholder analysis to identify and create the Stakeholder Register. Worked in collaboration with the Project Sponsor, Office of the LEA Grants Programs OLGP , Office of the Chief Financial Officer OCFO , Office of Contracts and Acquisition OCA , Office of Financial Operations and Services OFOS , and Office of Information Technology OIT .
• Led Joint Application Development/Design JAD sessions. Conducted one-on-one interviews, distributed questionnaires, facilitated requirements gathering sessions, reviewed existing documentation and applications, and observed business process in operation. Documented the 'as-is' and 'to be' business model. Documented the business requirements, data requirements and business rules using use cases. Documented the Functional Requirements using UML.
• Created state and class diagrams. Created Conceptual, Logical and Physical Data Model using MS Visio. Created Database Schema Tables, Synonyms, Views, and Indexes in MS SQL Server.
• Developed data mapping, ETL, and staging area for system interface between GEARS and the DC Students Information System DC STARS DC STARS, the Educator Licensing Information System ELIS , Comprehensive Automated Payroll and Personnel System CAPPS , and DC Comprehensive Assessment System DC CAS .
• Developed and managed a team of two 2 .Net Developers.

Confidential Project Manager,

• Managed enterprise projects such as the Payroll System Implementation Project, Meeting Integration Project, Publications and Membership websites. Worked in a PMO environment.
• Collaborated with management in determining the acquisition method that should be used to acquire and implement a COTS Event Management System.
• Managed requirements and testing using Mercury Test Center now HP ALM
• Prepared business case, level of effort LOE estimates, and project cost estimates.
• Prepared Project Management Plan. Tracked project progress, and prepared weekly report.
• Participated in the preparation of IT budget for next fiscal year.
• Presented project status reports at bi-monthly IT managers' meetings.
• Generated monthly reports to the PMO Director on projects' status, cost variance and schedule variance.
• Developed and managed a team of three 3 comprising of a Business Analyst, Java Developer, and Database Developer.

Confidential System Integration

• Analyzed the Tax Sale business processes of the Real Property Tax Administration and developed functional and non-functional requirements for integration of the Client-Server Tax Sale application with the Integrated Tax System ITS on the mainframe.
• Collaborated with Directors, Managers, Developers and End-users to analyze the Tax Sale Module.
• Led joint application development JAD sessions, conducted one-on-one interviews, distributed questionnaires, researched existing documentation, and conducted systems analysis of applications.
• Used workflow analysis, cause-effect analysis, affinity diagram, and gap analysis to analyze the business processes.
• Analyzed the data quality, consistency and integrity of the data in the DB2 database and FoxBASE database. Used Command Editor to analyze the DB2 Database.
• Use case specifications were used to describe the current operating procedures.
• Mapped current state against future state processes. Use Microsoft Visio to create the 'as-is' and 'to-be' business models
• Documented the business rules and data requirements documented the business requirements, using UML artifacts such as use cases and class diagrams, for integration of the stand-alone applications into the Integrated Tax System.
• Prepared the Functional Requirements Specifications which was used to prioritize, estimate duration, estimate resource requirements, develop schedule, and prepare costs estimate for the integration of the stand-alone applications into the Integrated Tax System on the mainframe.

Confidential, Data Quality Improvement Project

• Managed and worked with project team in data profiling, data analysis, data cleaning, and data verification activities, which involved determining data quality, identifying and collapsing duplicates and resolving discrepancies. Project budget was 20 million for a period of 5 years.
• Completed analysis of the Receipt and Referral, Committee Management, Grants Management, and Training business processes.
• Managed the development of data analysis, data cleaning and tracking applications, developed using SAS, Java/J2EE Architecture and Oracle 10g. Applied the Waterfall methodology.
• Facilitated meetings with the Data Analysts to review and revise data correction guidelines.
• Presented to the client, when necessary Business Case for change in data correction business rules.
• Met weekly with project team to review progress made, reviewed risks and addressed issues.
• Generated weekly reports to Program Director on the status of the data cleaning population.
• Generated monthly reports to the Program Director on project's cost variance, and schedule variance.
• Developed and managed a team of 10 comprising of SAS Developers, Data Analysts, Java Developer, and Oracle Developers, with one team member working offshore.
• Center for Disease Control Nation Prevention Information Network CDC NPIN Data Migration
• Created a Data Migration Plan for migrating the CDC NPIN database from MS Access to MS SQL Server

COMPUTER SKILLS AND TRAINING:

Web Programming Language: HTML, XHTML, CSS, XML, JSON, PHP, PHP MVC Framework, JavaScript and Macromedia ColdFusion Operating System: Windows, Novell Netware, UNIX, z/OS Database Technologies: Oracle, DB2, MS SQL Server, MySQL, Access Database Programming Language Tool: PL/SQL, T-SQL,TOAD, Oracle SQL Developer Business Intelligence: Crystal Reports, Business Objects, Cognos Project Management Tool: MS Project, Oracle Primavera, CA Clarity PPM, Asana, Version One Business Modeling Tool: MS Visio, Lombardi Blueprint, IBM Rational Rose Other Applications: Tax Administration System TAS , CFO ource, eRA/IMPACII, PRISM, Delphi, IBM Rational Clear Case, IBM Rational Requisite Pro, MS SharePoint, Win CVS, MS Visual SourceSafe, Tortoise SVN, HP ALM, Erwin Data Modeler.