SUMMARY

• An excellent communicator with over 6 year of experience as Business System Analyst, Data Analyst, and Business Intelligence Developer (Tableau / MSFT) with Google Analytics certification.
• Strong understanding and experience with various domains, Systems, and technology such as Healthcare, Insurance, Retail, eCommerce, Business Intelligence, Data Visualization, Database, Google Analytics, Web Development, Healthcare Payer and Claims system.
• Expertise with data reporting, data visualization, data analysis and ETL with large volume of data by using Microsoft Business Intelligence Suites (SSIS, SSRS&SSAS), Tableau, SAS and Python.
• Experienced in Requirement Gathering, working as communication liaison between various stakeholders including Senior Management, leading meeting, Conducting / facilitating JAD sessions, requirement workshops, brainstorming, surveys, and usability test, sprint planning meeting, sprint review meeting and daily scrum meeting.
• SQL Development - T-SQL(complex query, database objects, stored procedures, packages, views, tables, user defined functions, triggers, data modeling, query optimization and distributed transactions).
• Development and Analysis of BI Suites - SSIS, SSRS, SSAS, SSMS, OLAP cubes, MDX, Star and Snowflake Schema, Tableau and Power BI.
• Good understanding of DataWarehouse Concept and experience with Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Strong process modeling using UML diagrams - Use Cases Diagrams, Activity Diagrams, Class Diagrams etc. in MS Visio and authoring various documents such as BRD, FSD, RDD, Use Case documents and Gap Analysis Documents.
• Exposure to Eliciting requirements using interviews, business process descriptions, scenarios, and analysis, develop it in the form of Features, User Stories, Workflows, Process Flow diagrams, and built UI MockUps, Wireframe and Prototypes using various tools.
• Strong experience in preparing User Acceptance Testing (UAT), and documenting of test cases.
• Experienced in various SDLC methodologies such as waterfall, iterative Waterfall and agile.

TECHNICAL SKILLS

Requirement Management Tool: Microsoft Office Suites, Jira, SharePoint, Google Doc

Project Management Tool: MS Project, Jira, Team Foundation Server

Business Modeling Tool: MS Visio, UML, Axure RP

Business Intelligence Tool: SSMS, SSIS, SSAS, SSRS, Tableau, SAS EM

Database: SQL Server, MS Access, Oracle

SDLC Methodologies: Waterfall, Agile, Scrum

Programming Languages: T-SQL, SQL, SAS, JAVA, Python, HTML 5, JavaScript, CSS, Visual Basic

Web Analytic Tool: Google Analytics, Google AdWords, Tableau Website Analytics

IDE Tools: Visual Studio, Eclipse, Notepad++

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Business Analyst / Analytics

Responsibilities:

• Engaged executives, SMEs and other business users to gather and document report requirement specifications for internal, external, and compliance related reports, dashboards, and data extracts.
• Responsible for translating the Business requirements into conceptual and Tableau models to enable technical dashboard development.
• Attended and facilitated JAD sessions, and technical review sessions, and other project meetings as required.
• Transformed every business requirement to implementable user stories. (Epic, Feature, Product Backlog Items).
• Developed different visualizations using pie chart, bar chart, map and histograms based on the requirements using Tableau.
• Work on extracting, transforming and loading data using SSIS Import/Export Wizard, and create report using SSRS.
• Reviewed SQL queries and edited inner, left, and right joins in Tableau by connecting live/dynamic and static datasets.
• Added filters on website using Google Analytics to generate data.
• Providedad hoc assistance in outside situations, assisting with project management and data analysis
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using MS Excel, SAS, Tableau and SQL Server.
• Conducted GAP analysis, feature mapping, built Wireframe and designing prototypes and UI for eCommerce application using Axure RP.
• Used MS SharePoint to management requirement document and track requirement.

Environment: Agile, Jira, Retail, Business Intelligence, Tableau, Data Visualization, Data Mart, Data Model, Dashboard, SQL, SSIS, SSRS, Java, JavaScript, UAT, XML, DataWarehourse, Test Cases, SharePoint, JAD Session, Wireframe, Google Analytics, User Interface, Requirement Traceability Matrix

Confidential, MO

Sr. Business Analyst / Business Intelligence Developer

Responsibilities:

• Gathered requirements from the business side through multiple meetings, personal interviews, brainstorming and teleconferences.
• Formulate requirements for billing, encounter, patient record management, provider access and other healthcare related features based on new compliance specification.
• Involved in the physical and logical design of database and the analysis of existing database structures, authored BRD, including the database solutions and the requirements of new database objects.
• Used SQL profiler to view indexes performance, translated it into business requirements to guide the developer on creating clustered, non-clustered indexes and indexed views to mostly eliminate table scan and improve the performance.
• Used SQL metadata queries to investigate the database structure to determine the indicators and columns that should be used in the report, and included that in the business requirements.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes, Tables and Views using T-SQL with SSMS and Visual Studio.
• Designed and deployed ETL packages for extracting and loading the data into appropriate tables in the database using SSIS.
• Responsible for translating the Business requirements into conceptual and Tableau models to enable technical dashboard development.
• Used TFS (Team Foundation Server) for version control and team project and documentation tracking.

Environment: Waterfall, MS Office Suites, BRD, FSD, SQL Server 2012, TFS, SSMS, Visual Studio, SSIS, XML, ETL, Tableau, Datawarehouse, JAD, SSRS, OLAP, OLTP

Confidential, IA

Sr. Business Analyst / Data Analyst

Responsibilities:

• Organized meetings and ensured both business parties and engineering’s involvements and inputs.
• Studied extensively project related documentations and prepared questions/agenda for requirement gathering.
• Managed user stories, epics and feature groups with JIRA in the Agile environment
• Work in Scrum team as Product Owner and facilitate Sprint Planning, Sprint Review, and participate in Daily Scrum.
• Wrote SQL queries to generate data reports related to marketing, perform Data Analysis and resolved database issues.
• Collaborate with UI/UX, API and System teams to support development initiatives.
• Used MS Visio to develop UML diagrams, activity diagrams, sequence diagram, Wireframe and Models.
• Monitored, tracked and documented the progress of the project by use requirement traceability matrix
• Performed baselinebusinessanalysis by analyzing strategy, performance, metrics, organizational structure, resources, core work activities, existing documentation and supported technology related to businessprocesses.
• Integrated reading in data from an external source into SAS datasets and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.

Environment: Agile, MS Office Suite, UML, API, Axure RP, MS Visio, Requirement Traceability Matrix, Wireframe, HTML, XML, SQL, Agile, Java, Data Analysis, Content Management System (CMS), JavaScript, Android, Data Model, SQL Server, UAT, HTML5, JIRA, Tableau, SAS

Confidential, MD

Business Analyst

Responsibilities:

• Involved in requirement gathering, project documentation, conducting sessions and various meetings.
• Interacted with client user teams at various associate levels to analyze current processes and to designbusinessprocesses utilizing UMLdiagrams (Use Case, Sequence and Activities Diagrams) as well as documented process flow diagrams utilizing MS Visio.
• Added filters on website using Google Analytics to generate data.
• Conducted GAP analysis, Feature Validation and Competitive analysis, and provided actionable recommendations to senior management.
• Wrote expressions in SSRS. Created many Drill through and Drill Down reports using SSRS.
• Participated in UAT, including writing test scripts and updating testing scenario flows.

Environment: Waterfall, BRD, UML, Google Analytics, Gap Analysis, Competitive Analysis, UAT, T-SQL, SSRS, Data Mapping, OLAP, ETL, .Net

Confidential, PA

Business Analyst

Responsibilities:

• Translated business needs into system requirements following Agile methodology, worked in short Sprints to achieve goals and created the User Storied based on the project charter and the Project Request Form (PRF).
• Conducted JAD sessions utilizing a variety of techniques including but not limited to: walkthroughs, surveys, questionnaires, interviews and brainstorming.
• Participated in Scrum meeting and discussed the open issues and status.
• Performed Workflow analysis and task Analysis for various operational teams in the company.
• Created Release Tracking Document in order to track the necessary changes.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes, Tables and Views using T-SQL with SSMS and Visual Studio and perform Data Analysis.

Environment: Agile, JAD Session, User Story, PRF, SQL Server, Visual Studio, SSMS, JavaSciprt, HTML, CSS, SQL, Competitive Analysis, UI, UX, Java

Confidential

Associate Consultant

Responsibilities:

• Studied extensively project related documentations and prepared questions/agenda for requirement gathering
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL join queries and scripts for the database.
• Conducted and Facilitated JAD sessions and updated the whole team each time on the action items and follow-ups.
• Developing and extending the cubes in SSAS with around 35 dimensions, about 10 measures, and 25 calculated members, Design Dimensions and using the MDX expressions for the various Optimizations like Optimizing cube schema.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.

Environment: Waterfall/Agile, MS Office Suite, SQL, T-SQL, Stored Procedure, Visual Studio, SSMS, MS Excel, MS Access, SSAS, SSRS, Data Mapping, UAT, Test Cases, ETL