Swathi. V

**** **** ****, *****, **-*****

Email: ac30nr@r.postjobfree.com

Contact No: 773-***-****

Summary

BI Analyst & Tableau Report Developer with SQL having 3.5 years of experience in developing BI Solutions for various companies to monitor their Sales growth, Operational activities and numbers in Finance.

Experienced in managing multiple projects simultaneously to meet the rapid phases of development cycles and ability to work under pressure to meet tight deadlines.

Involved in all the stages of Software Development Life Cycle including Requirements Gathering, Analysis and Design, Implementation, Integration and testing, deployment and maintenance.

Good Knowledge on SDLC models like Waterfall, Agile-Scrum and Jira.

Experienced in analyzing and documenting Business Requirements (BRD) and System Functional Specifications.

Experience in Test Planning, Traceability Matrix, Test Scenario, Test Case Preparation, Executing Test cases and Defect Tracking.

Expertise in Use Case Diagrams and Activity Diagrams using MS Visio.

Prepared & Executed Test Protocols for System Integration Testing (SIT) and User Acceptance Testing (UAT).

Experienced in documentation of end user requirements for data capture, data analysis, understanding internal functionality of the system.

Worked extensively with different Industries like Health Care, Logistics and Construction.

Hands on experience in various BI tools like Tableau Desktop, Tableau Server, SSRS, SSRS Server.

Good Knowledge of Relational Database Management Systems (SQL Server 2012/2014) experience in Database Design and Development (Developing Transact SQL queries, Stored Procedures, Views)

Experience in Creating Tables, Views, Stored Procedures, Rank Functions, User Defined Functions and Other T- SQL statements for various applications.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, user defined functions.

Proficient in Tuning T-SQL queries to improve the database performance and availability.

Experience in taking Backup and Restore the database.

Generated multiple Enterprise reports using Tableau/SSRS from SQL Server Database and included various reporting features such as group by, drill downs, drill through, Quick filters, sub-reports, parameterized reports.

Experienced in Creating the Reports as per client’s requirement in the form of Table, Matrix, List, Chart and Gauge.

Major strengths are familiarity with multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments.

Work Experience

Working with Seanergy Analytics & Intelligence Inc ( formerly known as Seanergy Consulting Service Inc) as BI Developer since 3rd Aug 2014 to till date.

Skill Set Summary

Reporting Tools : Tableau Desktop 8.3/9.1.2/9.2.2/10, Tableau Server 8.3/ 9.1.2/ 9.2.2/10,

SSRS 2012/14, SSRS Server 2012/14

Data Bases : SQL Server 2012/2014, MySQL, Oracle.

Web Technologies : Knowledge on HTML, CSS.

Operating Systems : Windows 2000/2003/XP/Win 7/ Win 8/Win10.

Others : C, MS-Office

Educational Background

Master’s in Business Administration (MBA)

P.G. Diploma in Computer Applications(PGDCA)

Bachelor of Science (B.Sc)

Project Details

Project Name : Buyers BI

Client : Buyers Barricades, Richland Hills, Texas, United States

Environment : SSRS 2014, SQL Server 2014, SSIS. (July 2017-Jan 2018)

Description : Buyer’s BI is a BI Framework that consists of different modules to access different dashboards with multiple functional KPI’s such as Sales Pipeline, Top 10 Customers, Cash Flow, Profit & Loss Report, Income & Expenses Statement and Pay to Revenue etc., which plays prominent role in Transit Industry.

Responsibilities:

Designed the dashboard with different analytical KPI’s to improve the analysis.

Developed POC (Proof of Concept) and with production data.

White boarded KPI’s into graphs with perfect visualization.

Developed Dashboards for Finance, HR and Sales Departments in SSRS

Writing SQL queries & Stored Procedures using SQL Server 2014.

Project Name : Medi Code BI

Client : MediCode Medical Coding Solutions (MMS) India

Industry : Health Care

Environment : Tableau Desktop 9.1.2, Tableau Server 9.1.2, SQL Server 2012. (May2016-July 2017)

Description : It is designed for Indian Health Care and Insurance Sector. (i.e. Manpower Consultancy for Healthcare Professionals). Developed BI Solution for maintenance and care of health records in hospitals, ACO’s, physician's office clinics, health departments, health insurance companies, and other facilities that provide health care or maintenance of health records. This is used to identify current and future information needs; in addition they may apply the science of informatics to the collection, storage, use, and transmission of information to meet the legal and administrative records-keeping requirements of health care delivery.

Responsibilities:

White boarded KPI’s into graphs.

Developed Finance Dashboard, Executive Dashboard, Doctors Score Card

Designed and modified the data architecture for building KPI’s.

Developed different KPI’s like Avg wait time by Physician, Readmission by Diagnosis, Readmission by Gender, Charged Hours, Charged Amount, Patient Load by Physician etc including drillthrough with

filters and necessary tool tips

Writing Queries for Summary Tables, Stored Procedures using SQL Server 2012.

Scheduling the data refreshes in the Tableau Server with respect to ETL’s timing in the Database.

Project Name : Empire BI

Client : Empire Truck Lines, Inc, Hutchins, Texas, United States

Industry : Shipping

Environment : Tableau 9.1.2, MySQL 5.0. (Jan2015-May2016)

Description :

Empire BI is an enterprise BI solution for Empire Truck Lines Management. It includes the modules like

Shipping Dashboard, Finance Dashboard. Revenue vs Profit Margin, Revenue Share by Shipment, Dispatcher information, Miles Travelled, Orders Dispatched in different Terminals kpi’s

Responsibilities:

Designed the dashboard with different analytical KPI’s to improve the analysis.

White boarded KPI’s into graphs.

Developed different KPI’s like Shipping Cost w.r.t Shipping Modes, Shipments by Region, Service Failure, On time delivery, Total Miles, Commission Paid to name a few.

Analyzed the MySQL Data base, written queries and retrieved data with respect to required KPI’s.

Created Drilldown reports in the Tableau with respective filters and tool tips.

Scheduling the data refreshes in the Tableau Server with respect to ETL’s timing in the Database.

Project Name : HESS Construction

Client : HESS, Gaithersburg, MD, United States.

Industry : Construction (Aug2014-Jan2015)

Environment : Tableau 8.3, SQL Server 2012.

Description : Planning, design, building and improvement of innovative learning institutions. Included are universities, research and development facilities, training centers, primary and secondary schools, fine arts spaces, and athletic facilities located throughout the Mid-Atlantic region. HESS BI consists of different reports with both analytical and detail information. Developed Finance Dashboard, Project Status Dashboard.

Responsibilities:

Written queries using SQL databases and retrieved data from it for building the reports.

Developed different KPI’s Completed Projects, Current Project Reports, Customer Satisfaction,

Actual vs Estimated Cost, Working Days Available to name a few.

Developed drill through and Drill down reports as add on to the requirement.

Added different parameters to the reports to filter for ease and flexibility to use the report.

Scheduling the data refreshes in the Tableau Server with respect to ETL’s timing in the Database.

Contact this candidate