Business Analyst Resume Profile
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
Project Manager/Business Analyst/Subject Matter Expert
Confidential is responsible for revising the PreK-12 Maryland State Curriculum, assessments, and accountability system based on the Common Core Standards to assure that all graduates are college and career-ready, redesigning the model for preparation, development, retention, and evaluation of teachers and principals and fully implementing the innovative Breakthrough Center approach for transforming low-performing schools and districts.
Responsibilities:
- Assisted the MSDE Divisions to design and develop accountability and performance reports, dashboards, and educational KPIs using Oracle OBIEE
- Assisted MLDS Development Team in collecting requirements for business intelligence reporting systems and Business rules from key stakeholders
- 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 education programs
- Prepared functional scope change requirements
- Prepared Visio diagrams, FRD's requirements documents, and design specifications documents
- 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, MSDE Divisions, and Maryland LEAs to identify, design, and develop educational 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, MSDE Divisions, and Maryland LEAs to identify, design, and develop educational business accountability and performance metrics, reports, and dashboards 36 which support specific areas listed below
- Used MSDE Portal for the purpose of managing documents and to access shared work spaces and documents
- Assisted the Project Team MSDE Divisions to design and develop implementation requirements for the LEA's
- Provided reporting assurance required by the RTTT/P-12LDS grant
- Assisted RTTT/P-12LDS/P-20 Project Team in implementing various tasks as outline in each RTTT/MLDS project
- Schools Profile
- S T E M
- Requirements for Multi agency crosswalk discovery phase and dashboard development
- Educator Effectiveness
- Formative Assessment and/or
- Test Item Banks and Computer Adaptive Testing
- Student Growth
- 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 Training 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
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 education data and administered diagnostic assessments as needed
- Completed all special education 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.
