SUMMARY

• A Business Data Analystwith over 6+ years of experience inFinancial, Banking and Healthcare domains using Oracle 11g/10g, MS SQL Server.
• 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

Methodologies: Agile, Waterfall, RUP, OOAD, UML, Business Modeling Process Modeling and Data Modeling

Office Tools: MS Word, MS Excel, MS Power Point, MS Access, MS Project, MS Outlook

Process/Modeling: MS Visio, Erwin, IBM Doors

Quality Management: HP ALM, CMMI, Total Quality Management (TQM)

Languages: C, Java, SQL, PL/SQL, HTML, XML

Database: MS Access, SQL Server 2000/2005/2008/2012 , Oracle 9i/10g/11g

Defect Tracking Tools: Bugzilla, HP ALM, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Business Data Analyst

Responsibilities:

• Documented data feeds coming in from new sources - AHA to existing AEDW.
• Documented current staging data feeds going to AHA EDW (Enterprise Data Warehouse) that will be leveraged as the main feeds to IBC’s AEDW.
• Collect universe of required fields, find gaps in fields between the universe and existing file feeds going into EDW.
• Assist ETL team in identify fields from supplemental files based on documents created.
• Create initial Business Requirement Documents per subject area (CGP - Client, Group, Product; Membership; Enrollment; Medical/Pharmacy Claims) with required fields (existing and supplemental files)
• Created AEDW core data model using IBCs modeling templates.
• Created AHA to AEDW mapping documents using IBCs modeling templates.
• Create AHA to AEDW Functional Requirement Documents using IBCs modeling templates.
• Conducted complete gap analysis of AHA reports/extracts against AEDW versions. Performed SQL based data validation and verification to confirm data quality check and mapping rules.

Confidential, New York, NY

Business Analyst/ Data Analyst

Responsibilities:

• Identified and established communication with all key stakeholders, contributors, business, operations and technical resources surrounding assigned projects.
• Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements.
• Developed system process flows and User Requirements Specificationsthrough surveys and interviews.
• Converted Business specification in Functional Specification documents.
• Conducted Use-Case reviews to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Participate in Joint Application Development (JAD) sessions with business users, technical team, DBAs, testing team to analyze and validate the requirements and application lifecycle.
• Utilized tableau for dashboard creation. Worked closely with the Tableau development team to make sure they understood the reporting requirements and that the Data Marts developed met those requirements.
• Performed UAT on the Data Marts and validated the models against the business requirements.
• Prepared theETL mapping specifications toextract data from the existing sourcesystemsto the Data marts.
• Assisted ETL developers withthe design and development of ETL workflows for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.
• Created and granted access to limited views for BAs across departments to share useful data without compromising customer data confidentiality.
• Documented data sources and transformation rules required populating and maintaining data warehouse content.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Conducted the Data Analysis and identified the Data quality issues using Data profiling methodologies.
• Prepared Data Cleansing methodologies by relating them to DQ issues.
• Developed strategies with Quality Assurance group to implement Test Cases in Quality Center for stress testing and UAT(User Acceptance Testing).
• Wrote Test Plan and created Test cases and scenarios for the various Reports and Dashboards in accordance with the business requirements. Was responsible for writing and updating test plan documents for every version update to the Data Mart.
• Prepared/Reviewed weekly testing status and reports. Presented program-level testing information at meetings as requested.

Confidential, Monterey Park, CA

Data Analyst/Systems Analyst

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.

Confidential, Boston, MA

Business Systems Analyst

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.

Confidential - Hartford, CT

Business Data Analyst

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.

Confidential, Schaumburg, IL

Data Analyst- Consultant

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.

Confidential, Falls Church VA

Business Analyst

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.