CURRENT ROLE:

Sr. BI Data Analyst

PREVIOUS ROLES:

BI Data Analyst

SAS Developer

TOOLS / METHODS:

Tableau 7.X, 8.X, 9.X, 10.4.

QlikView & QlikSense Cloud

Apache Hive,

Oracle 10.X, 12C

MySQL 5.X

SQL Server 2008 & 2011

AS400

SAS 9.X, SAS/BASE, SAS/SQL

MS Excel,

TOAD, HeidiSQL,

Sharepoint,

SQL/PLSQL and ETL

Core Java, HTML, Java Script

SDLC, Agile Methodology,

Waterfall,

Iterative and Integrated.

INDUSTRY / DOMAIN

APPLICATION:

Health Care,

Retail and Sales,

Insurance,

Telecom,

Reporting,

Benefit Management

EXPERIENCE SUMMARY

8 years of IT as BI Data Analyst with Tableau, QlikView, QlikSense, SAS, SSIS, SSRS Design and Development: Strong Knowledge in all phases of Software Development Life Cycle (SDLC) including requirements analysis, scoping and estimate, design, developing, configuration testing, migrating, maintenance, security management and production supporting in various projects. Experience in Design and Delivering the complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade and support of dash boards with experience in industries such as Healthcare, Retail, Insurance and Telecom.

Experience analyzing Large Data Sets, Complex Data Warehouse and Raw System Data to mine the data to implement the reports and visualizations.

Document the data contents and data references for data validations, cleansing, mapping and blending the data for the reports and present insights to business users.

Experience implementing applicable Charts Bar, Bubble, Tree Map, Heat Map, Line, Pie, Scatter Plots, Dual Combination etc and advanced charts like Donut, Venn Diagram, Butterfly, Funnel Chart, Water Fall Chart etc. with relevant Metrics/Measures, Attributes/Dimensions, Filters (action, user), Advanced Navigation Techniques and Level of Detail (LOD) expressions with QlikView, QlikSense and/or Tableau, where applicable.

Experience implementing advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), and Reports/Dashboards.

Expertize in Data Visualization including effective communication, relevant chart types using best practices and optimizing Tableau for Performance.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, Custom Hierarchy, and dashboard actions.

Strong knowledge of Data Warehousing, Big Data, NoSQL and Dimensional Modelling concepts, with experience of Database design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation and upgrade.

Experience identifying areas to increase efficiency and automation of processes to develop the reports.

Extensively worked in end-user requirements, business data requirements, analysis and study and efficient in testing SQL queries using MySQL.

Experience in writing SQL Queries, Stored Procedures, PL/SQL queries, and Triggers in databases viz. Apache Hive, Oracle 8i/9i/10g, SQL Server 2000, MySQL 5.6, DB2 and SYBASE.

Work with different teams and business users to identify data sources and provide requirements for reporting to support dashboard development.

Excellent communication and coordination skills, Documentation Skills, Team problem solving ability, analytical and programming skills in high speed, quality conscious, Multitasked environment.

Flexible adapting to new environment, work as team and independently

Position:

Sr. Data Analyst

July 18 – Current

Client:

Transamerica, Cedar Rapids, Iowa

Project :

Insurance

Role and Responsibilities:

Working as a part of Transamerica IT Transformation services project.

Used Visual studio 2015 for reading SSRS and SSIS Reports for reverse engineering.

Created all the reverse engineered reports in Qliksense Cloud using Apache Hive database.

Maintained tableau reports on Tableau 10.4, 10.5 and 2018.3 Versions.

Worked with SME's in creating BRD's for proper understanding of reports.

Worked as a bridge between offshore team and SME's for further clarification on reports.

Worked with BaNCS team and DWH team for proper understanding of Report mapping.

Worked on insertion of data into hive through putty.

Maintained SLA and SLS Summary reports.

Created reports for Annuity, claims, life and health reports.

Created operations and management report, transaction report and Control reports.

Created reports for new policies with premium and without premium.

Created reports for Policies and rider based reports.

Created WFG (World Financial Group), LTC Rider (Long term), DAC Reports (Dollar Averaging cost), Foreign scan reports.

Created on UTC, UTR, Design Documents on the reports worked on.

Calculated Annuity Claims, TEB Claims and Life & Health Claims numbers for every month.

Environment: QlikView, QlikSense, Tableau 10.4, MS-Excel, Apache Hive, MySQL, SQL Server, SharePoint, Microsoft office, SQL-PLUS, Toad, Service Now

Position:

BI Data Analyst (Tableau)

Aug’17 – March 2018

Client:

Direct TV, El Segundo, CA

Project :

Telecommunications/Customer support

Role and Responsibilities:

Developed Package and Premium Migration by Daily, Monthly and Quarterly reports.

Developed Free View Customer Usage Report, a Funnel Report with Details of active and inactive streamers.

Reports on Channels viewed Prime Time, Weekly, Monthly and Quarterly. View stats on the seasonal sport channels.

Worked on multiple DataSources including Tableau Server, MySQL, SQLServer (ETL Tables), Excel to get the data needed for the dashboards.

Handled the Data Transformation using SQL for the reporting purposes.

Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

Built dashboards for measures with forecast, trend line and reference lines.

Involved in Design/Lead/Develop Prototypes for business solutions (dimensional models, model builds) so that business users may visually understand and explore a new feature or functionality before implementation to expose design assumptions and drive ideation. Ensured prototypes meet the organization standards to allow transfer to production.

Developed compelling, Interactive Dashboards using different features like Filters, Parameter, Actions, Calculations (using logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)

Trained and supporting Business Users on Tableau’s self-service model for creating their own dashboards and Publishing/Accessing them from Tableau online.

Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

Responsible for Understanding Business Requirement and providing solutions by analyzing different data sets within the organization.

Generate KPI for customer satisfaction survey results and disease management. Maintained Test log and Wrote test Evaluation, Summary Reports.

Generated context filters and data source filters while handling huge volume of data.

Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.

Generated Test Cases for each specification in Requirement Specification Document corresponding to dashboard visualization.

Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the Dash Board.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Environment: Tableau 10.4, MS-Excel, MySQL, SQL Server, SharePoint, Microsoft office, SQL-PLUS, Toad, Service Now

Position:

Sr. Tableau Developer

MAR’15 – April’17

Client:

Kaiser Permanente, MD

Project :

Telecommunications/Customer support

Role and Responsibilities:

Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition. Also resolved end user reporting problems through collaboration with IT and Operations.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build different visualizations of non-geographic data.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.

Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Generated context filters and data source filters while handling huge volume of data to build dashboards for measures with forecast, trend line and reference lines.

Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.

Interacted with Strategic development Team, Business analyst and Managers to analyse business needs and developed technical specifications.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboard visualizations and worksheets using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Environment : Windows, Tableau, SQL Developer, Oracle, google Analytics, google Mapping, MS-Access, MS Excel and SQL, Java, JavaScript, SQL,VB

Position:

Tableau Developer

MAR’13 – FEB’15

Client:

FedEx Services, WI

Project :

IMPB & Revenue Recovery (EDW)

Role and Responsibilities:

Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Working with team of developers designed, developed and implement a BI solution for Revenue, Product and Customer KPIs.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Interacted with Strategic Development Team, Business analyst and Managers to analyze business needs and developed technical specifications.

Fine-tuned SQL Queries for maximum efficiency and performance. And generated dash boards with Quick filters, Parameters and sets to handle views more efficiently.

Generated context filters and data source filters while handling huge volume of data.

Built dashboards for measures with forecast, trend line and reference lines.

Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security. Published Workbooks by creating user filters so that only appropriate teams can view it.

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.

Interacted with the existing database developers and DBA to understand the existing schema.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Environment: Tableau 7X/8X, SQL Server 2008, Excel, Oracle 11g, Toad

Position:

SAS Consultant/ Reporting Specialist

JAN’11 – FEB’12

& NOV’12 – FEB’13

Company:

Parkland Hospital, Texas

Project :

Parkland Hospital COPC Dash Boards

Responsibilities:

Generated HTML, Listing, Excel and RTF reports for presenting the findings of various statistical procedures using Proc Report, Proc Print along with SAS ODS.

Reports generated on processed data using Proc Report, Proc Tabulate and also convert the report formats per Clients requirements.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Worked along with ETL team to fulfill the entire Parkland dashboard requirement needs and to find out the KPI’S of the project and proposed those best solutions for their Dash boarding on the top of the existing reports as users requested.

Extensively worked with Clarity data source system to build having experience in Product deployment and product based reporting.

Extensively involved in complete life cycle of Parkland project, starting with requirements gathering from the Parkland users and preparing the Technical Specs and prototypes to present in front of users. Also involved in the Submission/Getting approval on the proposed system and prototypes.

Involved in deployment of Xcelsius dashboards in to the Microsoft SharePoint Portal site. And knowledge in Microsoft Dynamics with Share point.

Closely work with Business users and client engagement team in finding requirements and individually worked in finding solutions and developing the solutions, extensively worked with end user training.

Extensively worked with Excel Pivots and tableau proto types for different KPI’s of the park land hospitals.

Environment: SAS 9.X, Excel, Excel pivot, Oracle 10g, Toad, BO Xcelsius, Tableau, SDE

Position:

SAS Consultant – Clinical Trials

AUG’07 – NOV’10

Company:

Navya Pharmaceuticals, Hyderabad

Project :

Rofecoxib Trails

Responsibilities:

Extracted Clinical Trials raw data and created SAS data sets to track, measure and report the status of project milestones for assigned sites.

Cleaning of data using data step and SAS base procedures, validating, sorting and merging.

Used PROC SORT, PROC FORMAT, PROC CONTENTS, PROC TRANSPOSE DATA STEP Programming.

Reports generated on processed data using Proc Report, Proc Tabulate and also convert the report formats per Clients requirements

Effectively performed Data Sampling, Data Coding, Verification, Cleaning and conversion from other database to SAS for further processing and analysis.

Generated HTML, Listing, Excel and RTF reports for presenting the findings of various statistical procedures using Proc Report, Proc Print along with SAS ODS.

Environment: SAS 9.X, SAS BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS, SAS/STAT, Excel, Excel pivot, Oracle 10g, Toad

Address:

88 Bordentown Crosswicks Rd, Crosswicks, NJ 08515

Education:

Masters Degree, RGUHS, 2007, Bangalore, Karnataka.

Contact this candidate