SUMMARY

• A Business Data Analyst with over 8+ years of experience inHealthcare, Financial, Banking and Retail domain.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process, and Agile Scrum methodology.
• Extensive experience in visualizing the design of the system usingUML diagrams, Activity diagrams, and Web page mock - ups.
• Facilitated collection of Functional Requirements from system users, and prepared Business and Functional Requirement Specification documents.
• Extensive experience of building stakeholder relationships, managing communications plans, tracking, assessing, and reporting on the analysis process.
• Performed writing tasks on complex documentation/online help projects that require effective planning, scheduling, research and writing skills. Address functional and technical issues surrounding development of documentation, online help and training material.
• Gathered and researched functional/technical information and interview subject matter experts, business analyst, system analysts, software engineers and software system engineers to determine user documentation, online help and training materials are needed to support the users’ ability to use the software effectively.
• Strong expertise in building, Templates, Graphical analysis charts and Statistical reports using MS Excel and also expertise in MS Word, MS PowerPoint.
• Used MS Visio to carry out the business modeling, data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
• Experience in Joint Application Development (JAD) sessions as facilitator with end-users, Subject Matter Experts, Development and QA teams.
• Excellent presentation skills in preparing contingency plans, review logs, forecasting and planning work schedules with excellentcomfort level in using Microsoft Project.
• Functioned as theprimary liaison between the business line, operations, and the technical areas throughout the project cycle. Experience in working with business users as well as senior management.
• Strong in analytical and problem solving skills, excellent planning and multi-tasking abilities with proven experience in utilizing people and process knowledge to help enterprise make critical decisions.
• Experience in Data warehousing concepts like star/snowflake schema and slowly changing dimensions.
• Knowledge in design and creation of database and database schema.
• Experience writing SQLQueries for Data Validation and Data Integration.
• Served as web analytics technology expert related to tagging and tracking enhancements, solution design and reporting - participating in various web & toolintegration projects.
• Excellent working knowledge of Data Warehousing concepts including Metadata and Data Marts. Experience in creation of data source and transform them into custom created datamarts.
• Performed data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
• DevelopedExcel applications (pivot tables, VLookups) to streamline processes for analysis and reconciliation.
• Experience in SQL extraction on MS SQL Server, and Oracle platform.
• Proficient in Data mining and OLAP with extensive use of RANK, ROLLUP, CUBE, QUALIFY.
• Proficient in data import/export from diverse sources and excellent knowledge of Database Backup and recovery.
• Experience with Tableau in analysis and creation of dashboards.
• Proficient in Data Quality Management techniques like Data Profiling, Data Cleaning, Data Integrity and Data Mining.
• Involved in Functionality, Smoke, Adhoc, System and Regression Testing.
• Prepared Test Plans, Test Conditions, Test Cases, Test Data Guidelines & Traceability Matrix for the mapping requirements.
• Designed, documented and maintained moderate to complex testing strategies for use by the Quality Assurance team.

TECHNICAL SKILLS

• Agile
• Waterfall
• RUP
• OOAD
• UML
• Business Modeling Process Modeling and Data Modeling
• Microsoft Office
• MS Visio
• Erwin
• IBM Doors
• HP ALM
• CMMI
• Total Quality Management (TQM)
• C
• Java
• SQL
• PL/SQL
• HTML
• XML
• MS Access
• SQL Server 2000/2005/2008/2012
• Oracle 9i/10g/11g
• Bugzilla
• HP ALM
• JIRA

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for gaining a good understanding of user needs and accurately representing them in a well-documented software functional specifications document.
• Assisted Project Management with deliverables, such as Vision Document, Project Scope document to help outline the timeline and capacity for the project.
• Interacted with the users, designers and developers, project manager and QA team to get a better understanding of the Business Processes and to gather and prioritize business requirements.
• Initiated Release Planning, Sprint Planning, User Stories Estimation and Backlog grooming sessions to discuss the business requirements to analyze the scope of the Project.
• Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review)
• Supported the testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing and maintaining the Mercury Quality Center with the latest updates on the defects.
• Documented the Business Requirements Document (BRD) and the Functional Specification Document (FSD) and heavy involvement in the Acceptance of the User Stories and Defects.
• Interacted with the Clinical Stakeholders and End Client by interviewing them, and by preparing appropriate questionnaire to better understand end-user needs and the business process.
• Interacted with the Client Implementation team to explain and clarify product functionality based on client’s needs.
• Supported Test Management and Planning such as, supporting in the Automation strategy, cross team planning and issue resolution activities and acting like an SME on the overall product.
• Supported creation of the Performance testing scripts to check the overall product for performance benchmarks.
• Supported in the creation of End-to-End Integrated test plans to close any quality gaps.
• Created traceability matrix from requirements to test cases to ensure appropriate coverage and quality of the end product with respect to the business requirements.
• Conducted End of Release Quality Summary to ensure improvement in future releases.
• Participated in walk-throughs, inspections, reviews and user group meetings for quality assurance.
• Worked with business users, system analysts, designers and programmers to create and analyze various required project documents.
• Conducted walkthroughs and code reviews with developers, project managers and stakeholders and users to comprehend business workflow of applications.
• Performed GAP analysis as needed at various stages to understand the difference between our current situation and end goals.
• Created and maintained data mapping documents

Environment: / Tools: Windows XP/NT, UNIX, C++, Java, HTML, XML, Java Script, Oracle, UMLWin Runner, Load Runner, Test Director, Mercury Quality Center, Rally.

Sr. Business Analyst

Responsibilities:

• Extensively used MS Project 2007 for a Project Management project and applied concepts of work breakdown structure, resource allocation, risk management, network flows, cost and schedule variance
• Evaluated and analyzed variances in deadlines, tasks, milestones and resource loading
• Facilitated project meetings including scheduling, recording and distributing minutes, and following up on action items
• Experienced in interacting with business users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Project Charter and Project Approach Documents
• Understood the Business Logic, User Requirements and test-objectives to develop Use Case Scenarios
• Facilitated and conducted Joint Application Development (JAD) sessions with Business Clients to identify business rules, functional and non-functional requirements
• Conducted the AS-IS and TO-BE analysis of the business process using GAP analysis.
• Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System), WMOS (Warehouse Management Open System) and complete processing till final delivery to customer
• Analyzed restock/destock for inventory optimization from Access Database and generated report from Cognos tool
• Analyzed JDA for inventory to find out BOH of CASE, BREAK PACK and EACHES, to identify the demand of SKUs for FULL CASE shipping
• Identified the issue involved in Supply Chain and suggested the best way to mitigate it
• Worked closely with FC (Fulfillment Center) managers for better understanding of risk/issues involved in Supply Chain
• Created monthly/weekly status reports to update the project schedules & deliverable plan to Business and Portfolio Project Manager

Environment: .Net, RUP, HTML, UML, MS Office, Use Cases, Rational Requisite Pro, Quality Center, MS Visio

Data Analyst/Systems Analyst

Confidential, Monterey Park, CA

Responsibilities:

• Gathered and translated business requirements, worked with Business Analysts, source SMEs and DBAs for requirements gathering, business analysis,and testing and project coordination.
• Dealt withconflicting scenarios when requirements and the reverse engineering communicated different cleansing rules.
• Assisted the PM in developing comprehensive schedules, reflecting appropriate time-phased completion of projects and application of required resources utilizing MS Project.
• Prioritized and coordinated deliverables and inter-dependencies among the various IT Teams.
• Recordand documented effective communication with project sponsors, management and project team members.
• Maintained project SharePoint site by setting up project document repositories, modification and upload of documents, enabling user access and advising users on SharePoint access.
• Conducted logical data model walkthroughs and validation.
• Conducted team meetings and JAD sessions.
• Developed data mapping documents for integration into a central model and depicting data flow across systems.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Involved in performing extensive Back-End Testing by writing SQL queriesand PL/SQL stored procedures to extract the data from SQL Database using SQL Developer.
• Assisted in developing and maintaining the central repository and helped populate it with the metadata.
• Used Tableau forvalidating the metadata and testing the data of reports.
• Designed and developed reports for the data in the Data Warehouse using Tableau/Excel.
• Analyzed data using Slice/Dice and Drill up/Drill down to analyze data to meet the end user's requirements.

Business Systems Analyst

Confidential, Boston, MA

Responsibilities:

• Prepared Business Requirement Document (BRD), Functional Requirement Document (FRD) and other customer facing deliverables; Prioritize requirements with customers and business owners
• Developed user interfaces,workflowdiagrams, designed datastructuresaccording to requirements for WebApplication
• Coordinated efforts between multiple teams to build, deploy and test application on portal; prepared project status reports encompassing milestones, ongoing tasks and upcoming risks for weekly status updates
• Conducted workshops for user acceptance testing, training and support
• Gathered Productinformationby inspecting Product documentation, data analysisand user interviews;
• Acted as a liaison between thebusiness units and the technology teams.
• Facilitated Sprint planning, Stand-ups, Demos and Retrospectives to maintain the transparency
• Participated in JAD sessions and act as the lead facilitator for variousprojectsfrom start to finish through the SDLC.
• Prepared BRD to ensure high-level design, updated BRD and FRD through working with the Desk heads andtheir different business units (Investment Grade, High Yield, and Distressed Debt).
• Participated in vendor contracts review and wrote specifications and standards for RFPs and RSAs to outsource work to third party subcontractors and have done effective technical evaluation in the selection procedure, to efficiently manage the project budget and timeline.
• Automated Batch Jobs to Load the Consolidated Data warehouse at scheduled times to run on a daily, weekly and monthly basis in Job Scheduling Console.
• Developed test cases and test scripts for System and UAT testing.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Extensively used Quality Center for Test Management needs.
• Involved in end user training and support for new system.

Business Data Analyst

Confidential - Hartford, CT

Responsibilities:

• Worked with data experts in various countries like United States, Panama, Trinidad, Mexico and the Caribbean to understand the methodology employed in acquiring and reporting of data metrics.
• Worked closely with Data Architect to understand the data sources. Sampled numerous data sources and worked with ETL teams to ensure accurate data was utilized for reporting.
• Worked with the Data Architect to evaluate the scope of the project. Addressed the business needs by validating data marts against reporting requirements.
• Scheduled and attended status meetings for requirements review and demonstration of reports. Coordinated Data Mart releases with Database Development staff and Business Users including schedule and report content.
• Analyzed and documented the flow of data from the source systems, to ETL staging/production and to DWH.
• Assisted the senior executive management in understanding the flow of data as well as business logic being applied to data.

Data Analyst- Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Identify and provide recommendations for data fields that can be extracted from ScriptMed (pharmacy dispensing system) or the Data Warehouse prior to pharmaceutical manufacturer contract execution.
• Create business requirement documents to support data reporting needs in collaboration with IT.
• Routinely manage data issues including, but not limited to, missing data fields, report transmission, data integrity issues, exception reporting items, etc. and work with Trade, IT, Specialty Pharmacies, and/or other necessary groups to remedy the data reporting issues.
• As a data subject matter expert, liaise with manufacturer IT designees for data kickoff calls, routine programming discussions, transition from development to production stage, troubleshooting issues, etc.
• Collaborate with internal ScriptMed subject matter experts to identify and recommend system enhancements to support data reporting requirements.
• Continually identify opportunities to enhance reporting efficiencies in ScriptMed to meet data reporting needs for pharmaceutical manufacturer contracts.

Business Analyst

Confidential, Falls Church VA

Responsibilities:

• Interface effectively with business and technical staff and SMEs of the various applications to gain an understanding of the business process and available functionality of the individual applications and subsequently document and support requirements clarifications requested by the Client staff.
• Conduct meetings with end user clients to gain a better understanding of the requirements.
• Handle multiple projects simultaneously, raise issues, identify dependencies, and manage issues to resolution.
• Responsible for writing business requirements and documentation based on high level requirements from end user clients or as a result of changes from the source systems that feed the applications.
• Responsible for translating business requirements to functional, technical specifications and analyzing and documenting meta-data requirements for a highly data centric application.