PROFESSIONAL SUMMARY:

• 7+ years of Industry experience as a Business Analyst/Subject Matter Expert with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design
• CAPM qualified Project Manager with over 2000 hours of project related experience
• Extensive experience with state, county school systems, and K12 BI metrics definition and dashboard development
• Experience in analysing the business needs; Identifying business problems and proposed solutions, and translating those needs into units of work that the agile software development team can deliver as working software
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members
• In depth knowledge Rational Unified Process (RUP) methodology using Rational Rose, Requisite Pro, Use Cases, Software Development Life Cycle (SDLC) processes
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams
• Experience designing high level ETL process and data flow from source system to EDW and other downstream systems
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases, Expertise in designing and developing Test Plans and Test Scripts
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS:

UML, SDLC, Waterfall, QA, MS Access, MS Excel, SQL Server, MySQL, PL/SQL, Oracle DBA, OBIEE 11g,APEX, SAS, Informatica, Windows 98/2000/XP, HTML, basic DHTML, basic XML, MS Office Suite - Excel Macros, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore

Project Manager/Business Analyst/Subject Matter Expert

Responsibilities:

• Assisted MLDS Development Team in collecting requirements for business intelligence reporting systems and Business rules from key stakeholders
• Assisted the Confidential Divisions to design and develop accountability and performance reports, dashboards, and al KPIs using Oracle OBIEE
• Facilitated project meetings as needed and provided weekly status reports to Sr. PM
• Created and executed project plans using MS Project 2003
• Revised and updated tasks and deliverables for scheduled implementations and quarterly releases of new products
• Established a critical path for multiple program and course level projects using MS Project, while allocating the appropriate project resources necessary to successfully develop the program/course
• Analyzed the business needs; Identified business problems and proposed solutions, and translated those needs into units of work that the agile software development team can deliver as working software
• Engaged with internal customers to identify and qualify reporting opportunities
• Consult with key stakeholders to define detailed reporting requirements, including reporting mock-ups
• Scope and directly managed requirements process for larger initiatives, including workshop facilitation and roadmap development
• Engaged with data stewards of EDW source systems to enhance understanding of EDW data
• Supervised and developed project schedules, budgets, and resource plans for new programs and courses
• Worked with Sr. Project Management to set release plans and prioritize scope
• Worked directly with customers to define scope and value for new developments
• Facilitated backlog reviews and scope estimation with the team
• Manage structure of iterations for agile development
• Support agile software development team with scope considerations throughout the development cycle.
• Managed a cross-functional, multi-stakeholder team in the development of programs
• Prepared Visio diagrams, FRD’s requirements documents, and design specifications documents
• Prepared functional scope change requirements
• Performed detailed data analysis to understand the source system data
• Participated in designing the data warehouse data model
• Designed high level ETL process and data flow from source system to EDW or other downstream systems
• Developed source to target data mapping design document for ETL processes.
• Verified software developed by the MLDS team meets requirements and specifications
• Worked with the DAADS MLDS project team, Confidential Divisions, and Maryland LEAs to identify, design, and develop al business accountability and performance metrics, reports, and dashboards for the Oracle OBIEE BI suite
• Worked as K12 SME/Business Analyst with the Division of Accountability and Assessment’s Race to the Top (RTTT) and P-12LDS project team, Confidential Divisions, and Maryland LEAs to identify, design, and develop al business accountability and performance metrics, reports, and dashboards(36) which support specific areas listed below
• Assisted RTTT/P-12LDS/P-20 Project Team in implementing various tasks as outline in each RTTT/MLDS project
• Provided reporting assurance required by the RTTT/P-12LDS grant
• Assisted the Project Team Confidential Divisions to design and develop implementation requirements for the LEA’s
• Used Confidential Portal for the purpose of managing documents and to access shared work spaces and documents
• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead
• Assisted in building business process analysis model using MS Visio
• Thoroughly studied the requirements for the process re-engineering
• Conducted Joint Application Development ( JAD ) sessions with IT groups
• Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion
• Extensive experience with SharePoint as part of the analytic work. Travestied SharePoint infrastructure to collect information about existing site collections and to contacted those site collection and site owners( Government and Private) to understand how they are using the tool(Data) to fill their business requirements
• Prepared graphical depictions of State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams using Microsoft Visio
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
• Designed and developed Project document templates based on DOIT SDLC methodology
• Worked extensively on developing Master Test Plan, Test Cases, Defect Report, Test Analysis Report
• Developed User Manuals and Manuals as per Project Specifications and timelines

Environment: Microsoft Word, Project, Excel, PowerPoint, Visio, Oracle 10g/11g, Informatica, APEX, OBIEE, SAS, SQL, MS SharePoint, Java, Unix, Adobe PageMaker, Adobe Frame Maker, Adobe Illustrator, Quark Express

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Involved in Preparing Visio diagrams, FRD’s requirements documents, and design specifications documents
• Followed up with the expeditors to track the student information and valid them against the DC STARS database.
• Responsible for all the data mappings between the Blackman Jones Data base (SWAT team database) and DC STARS.
• Maintained accurate and compliant special data and administered diagnostic assessments as needed
• Completed all special paperwork accurately, according to regulations, and maintained compliant files
• Conducted JAD sessions to discuss the requirements for the dashboard. Implemented RUP recommended visual models to draft business requirements by using Use Cases
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs
• Designed workflows and allocated permissions within SharePoint
• Used Query Analyser, Execution Plan to optimize SQL Queries
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing
• Enhanced the job properties for performance tuning

Environment: Microsoft Word, Project, Excel, PowerPoint, Visio, Windows NT 4.0,UNIX, Oracle 8i, PL/SQL, DOS and UNIX Sequential Files, MS Access, XML File.

Continental, Houston, Texas

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Assisted in building business process analysis model using MS Visio.
• Thoroughly studied the requirements for the process re-engineering
• Create and implement Customer Service plans. Use MS Project to monitor and track progress.
• Involved in creating PNR records, passenger records, with unique number.
• Developed models to project revenue and costs to support budget forecasting and strategy development. Prepared standard monthly reporting.
• Ensured financial statements are accurately stated via in-depth review/analysis of system generated revenue and expense activity reports.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP
• Conducted Joint Application Development ( JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio .
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML .
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Recommended the necessity for a discussion board to facilitate real - time discussions for the sales team.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: MS Office Suite, MS Visio, MS Project, MS Excel, MS Access, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, MS SharePoint

Confidential, Memphis, TN

Business Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Utilize Excel in conjunction with ERP and POS systems to maintain accurate inventory levels
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Manuals as per Project Specifications and timelines.

Environment: Rational (Rose, Requisite),Microsoft Office Suite, MS Visio, MS Project, Windows XP, SQL, PLSQL, XML, Adobe Photoshop, MS SharePoint