SUMMARY

• Senior Business/Data analyst with a strong technical background, energized by problem identification and resolution.
• Over 6+ years of experience in Business and Systems Analysis working in various domains - Financial, Mortgage and Healthcare.
• Experienced in all phases of Software Development Life Cycle (SDLC) methodology (such as requirement, analysis, design, data modeling, business process modeling, implementation and deployment).
• Experienced in various SDLC methodologies - Agile, Waterfall and RUP
• Capable of managing multiple projects simultaneously.
• Exceptional problem solving and sound decision making capabilities.
• Experience in writing queries/scripts for data analysis ad QA report testing.
• Excellent data analysis skills.
• Managed requirements in Team Foundation Server TFS.
• Extensive experience in gathering Business/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements Document (BRD).
• Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion.
• Excellent knowledge in data warehousing, OLAP operations like rollup, drill down, slicing/dicing, pivoting using BI tools.
• Flexibility in adaption to a wide range of work environments.
• Experienced in requirement gathering including Joint Application Development (JAD) and requirement analysis.
• Ability to inculcate new relevant skills with ease in a time sensitive frame.
• Experience in writing Use cases and Functional Requirement Document.
• Knowledge of ISO, Six Sigma and CMM standards.
• Experience in working with SMEs and interacting across the hierarchy from architects, to data modelers, underwriters and risk analysts to gather requirements.
• Experience in creating User Interface wireframes mock up’s.
• Strong knowledge in importing/exporting data across various database platforms to perform analyses.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/NT/XP, UNIX

Programming Languages: SQL, Unix Shell Scripting

Software Packages: MS Access, Excel, Power Point, VISIO, Project

Databases: Oracle 11g, MS Access, DB2

SAS Tools: SAS/Base, SAS/Access, SAS/SQL

Data Modeling Tools: ER Studio

Requirements Management/Testing Tools: Requisite Pro, DOORS, HP ALM

ETL Tools: Informatica 7.1/6.2 /5.1, Ab Initio 1.15.12

Reporting Tools: Microstrategy 9.3, Xcelsius 2008, Business Objects XI 3.1

Change Management Tools: Rational Clear Quest

Prototyping Tools: Balsamiq, VISIO

Project Management: JIRA, Confluence, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Frederick, MD

Senior Business Analyst

Responsibilities:

• Developed high level process flows and presented them to various business users.
• Organized, set up and facilitated JAD sessions, user story workshops and functional design review meetings.
• Worked with the QA, to help them understand use cases and help them build valid test scenarios and scripts.
• Worked with business partners to seek sign-off approval for production defects validations and UAT testing.
• Updated application specific business specification documentation based on updated to functionality of the systems.
• Coordinated with all project team members to ensure project needs are clearly understood and supportable.
• Managed user stories, requirements, test scripts, and bugs in Microsoft's Visual Studio Team Foundation Server (TFS)
• Conducted peer review meetings periodically to keep track of the project’s milestones.
• Conducted GAP Analysis of current state (As-Is) and proposed state (To-Be) situations and represented in MS Visio.
• Provided assistance with creating data flow diagrams.
• Created source to target mapping documents.
• Generated Requirements Traceability Matrix.
• Analyzed data extracted from different tables to ensure accuracy in the source to target flow documentation process.
• Created Activity Diagrams, and Sequence Diagrams using UML in MS Visio.
• Created the Data Dictionary and updated the Metadata for all the data attributes related to project.
• Reviewed the Data Models and updated Data Mapping Documents as needed.

Environment: Agile, Windows (98/XP/7/Vista/8), MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, SQL Server Services, Tableau, Mockup Screens.

Confidential, Cleveland, OH

Senior Business Analyst

Responsibilities:

• Conduct kick-off and on-going meetings with client management and executives for best course of action, on-going requirements and implementation planning.
• Documentation regarding course of action, responsibilities, meeting minutes and project statistics (on-time, on-budget).
• Created detailedbusinessrequirements and Functional Specification for conversion from multiple departmentalizedsystems, web applications and manual processes into one integratedsystem
• Assigned tasks among development team, monitored and tracked progress of project following Waterfall Methodology.
• Document the requirements in the form of User stories and User scenarios inTeam Foundation Server(TFS)
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Created detailedbusinessrequirement documentation for current and new functionality
• Reviewed initial Program Scope and provided input in to project timeline/milestone, staffing and project work plan
• Create Scope Impact with risk assessment and process documentation detailing requirements and solutions for both phased and full installations, offering alternatives and options to build within budgets.
• Analysis to in corporate the necessary personnel forbusiness, IT, data administration, security and outsidebusinesspartners into the development team.
• Perform data mapping and conversion of data from onesystemto another.
• Conduct training sessions for new processes and new personnel.
• Create large volume test plans that include all related criteria to changes and to ensure unaffected code is stable, detailing expected results and actual results.
• Researched currentsystem, recommending processing andsystemfunctions to enhance ease of systemuse.
• Published test execution status reports and provided additional testing metrics as appropriate
• Delivered and maintained extensive documentation for future extendibility of the system

Environment: Agile Scrum Methodology, Version One, Qlikview,HP QC, My SQL, MY Excel, MS SharePoint, .Net, TFS, JQuery, ASP.Net, C#, MS SQL Server, SSIS, SSRS, SSAS

Confidential, Virginia Beach, VA

Business Intelligence Analyst

Responsibilities:

• Co-ordinated with cross functional teams and conducted in-depth analyses of existing reporting systems and suggested improvements.
• Led requirements review meetings and obtained necessary approvals from all stakeholders and baselined the requirements documents.
• Conducted meetings with Subject Matter Experts (SME’s) on a regular basis to gather requirements and identify KPI’s.
• Responsible for Analyzing, Documenting, Gathering Requirements andProcessDesignfor the new HIPAA 5010 Transaction
• Conducted Gap Analysis and suggested process improvements.
• Participated in white boarding sessions, release prioritization meetings, and team retrospectives.
• Developed UAT strategy and ensured execution of test cases and resolution of defects.
• Conveyed business vision and goals associated with feature sets clearly to the development team in order to ensure that delivery is focused on business value.
• Created Functional Requirements documents from Business Requirements.
• Status reporting - Sent weekly status reports to the client.
• Created various Use Cases, Activity diagrams, Sequence Diagrams and other UML diagrams by using MS Visio.
• Performed GAP analysis and created related GAP analysis document to estimate the project progress by seeing the state of actual and expected state.
• Developed Test approach and Test plan involving all the functional requirements that are been documented.

Environment: Agile, Windows (98/XP/7/Vista/8), MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, SQL Server Services, Tableau, Mockup Screens.

Confidential, Norcross, GA

Business Analyst

Responsibilities:

• Served as a liaison between the business analysis team and the technology services group for the latest release for asset management reporting and systems.
• Utilized System Development Life Cycle (SDLC) to facilitate project fulfillment and delivery.
• Responsible for the identification, analysis and resolution of metadata issues.
• Coordinated User Acceptance Testing/Defect prioritization for incorporating the latest system enhancements.
• Conducted meetings with SME’s and analysts on a regular basis to gather requirements and analyze workflows.
• Created project repository for managing project artifacts and deliverables.
• Communicated project status, escalated issues, and managed timelines and action items.
• Managed any change requests related to the working project daily to meet the agreed deadlines.
• Worked with business in documenting and tracking the enhancements for the system.
• Worked with the QA team helping them create Test Plans, Test Requirements, Test Cases and Test Scripts.

Environment: Agile Scrum Methodology, JIRA, MS Excel, HP QC, MY SQL, MS Access, Spotfire, MS Visio, JAVA, JSP, J2EE, Java Script, Web Services

Confidential, Washington, DC

Data Analyst

Responsibilities:

• Involved in gathering Reporting Requirements for the data warehousing project team.
• Assisted Manager with scheduling meetings and creating agendas.
• Recorded meeting minutes and action items from meetings.
• Interacted with business users and subject matter experts to validate requirements.
• Analyzed existing business requirement documents and identified gaps in requirements to obtain clarification.
• Assisted with creating Meta data for new data elements.
• Created training document to guide business users to update their own metadata.

Environment: Waterfall Methodology, Microsoft Office Suite, MS Visio, Mercury QC, MS SharePoint, JAVA, JSP, J2EE.