SUMMARY

• ABusiness Data Analystwith 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 teh design of teh 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 teh analysis process.
• Performed writing tasks on complex documentation/online halp projects that require TEMPeffective planning, scheduling, research and writing skills. Address functional and technical issues surrounding development of documentation, online halp 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 halp and training materials are needed to support teh users’ ability to use teh software TEMPeffectively.
• 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 teh business modeling, data modeling, and object modeling efforts to develop teh 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 teh business line, operations, and teh technical areas throughout teh 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 halp 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.

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 halp outline teh timeline and capacity for teh project.
• Interacted with teh users, designers and developers, project manager and QA team to get a better understanding of teh Business Processes and to gather and prioritize business requirements.
• Initiated Release Planning, Sprint Planning, User Stories Estimation and Backlog grooming sessions to discuss teh business requirements to analyze teh scope of teh Project.
• Created test cases for System Testing (Development Environment), Integration Testing (UAT) and Production (Post Implementation Review)
• Supported teh testing team with Defect Management, Requirement Analysis and SQL development for back-end and regression testing and maintaining teh Mercury Quality Center with teh latest updates on teh defects.
• Documented teh Business Requirements Document (BRD) and teh Functional Specification Document (FSD) and heavy involvement in teh Acceptance of teh User Stories and Defects.
• Interacted with teh Clinical Stakeholders and End Client by interviewing them, and by preparing appropriate questionnaire to better understand end-user needs and teh business process.
• Interacted with teh Client Implementation team to explain and clarify product functionality based on client’s needs.
• Supported Test Management and Planning such as, supporting in teh Automation strategy, cross team planning and issue resolution activities and acting like an SME on teh overall product.
• Supported creation of teh Performance testing scripts to check teh overall product for performance benchmarks.
• Supported in teh 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 teh end product with respect to teh 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 teh 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 teh 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 teh AS-IS and TO-BE analysis of teh business process using GAP analysis.
• Analyzed teh 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 teh demand of SKUs for FULL CASE shipping
• Identified teh issue involved in Supply Chain and suggested teh 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 teh 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 teh reverse engineering communicated different cleansing rules.
• Assisted teh 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 teh various IT Teams.
• Recordand documented TEMPeffective 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 teh 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 teh data from SQL Database using SQL Developer.
• Assisted in developing and maintaining teh central repository and halped populate it with teh metadata.
• Used Tableau forvalidating teh metadata and testing teh data of reports.
• Designed and developed reports for teh data in teh Data Warehouse using Tableau/Excel.
• Analyzed data using Slice/Dice and Drill up/Drill down to analyze data to meet teh 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 teh technology teams.
• Facilitated Sprint planning, Stand-ups, Demos and Retrospectives to maintain teh transparency
• Participated in JAD sessions and act as teh lead facilitator for variousprojectsfrom start to finish through teh SDLC.
• Prepared BRD to ensure high-level design, updated BRD and FRD through working with teh 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 TEMPeffective technical evaluation in teh selection procedure, to efficiently manage teh project budget and timeline.
• Automated Batch Jobs to Load teh 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 teh 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 teh Caribbean to understand teh methodology employed in acquiring and reporting of data metrics.
• Worked closely with Data Architect to understand teh data sources. Sampled numerous data sources and worked with ETL teams to ensure accurate data was utilized for reporting.
• Worked with teh Data Architect to evaluate teh scope of teh project. Addressed teh 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 teh flow of data from teh source systems, to ETL staging/production and to DWH.
• Assisted teh senior executive management in understanding teh 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 teh 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 teh 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.
• Interface TEMPeffectively with business and technical staff and SMEs of teh various applications to gain an understanding of teh business process and available functionality of teh individual applications and subsequently document and support requirements clarifications requested by teh Client staff.
• Conduct meetings with end user clients to gain a better understanding of teh 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 teh source systems that feed teh applications.
• Responsible for translating business requirements to functional, technical specifications and analyzing and documenting meta-data requirements for a highly data centric application.