HARSHA AVINASH PANASA

**** **************** **. ***# ****, Tallahassee, FL - 32312

adhde1@r.postjobfree.com 404-***-****

PROFESSIONAL SUMMARY

• Over 8+ years of IT industry experience in Microsoft Business Intelligence and Tableau with strong background in Databases and Data warehousing

• Extensive experience in BI Solutions using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications

• Expert at developing ETL interfaces using SSIS, data cubes using SSAS and enterprise reports using SSRS

• Excellent in High-Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS

• Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages

• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling

• Experience in developing and extending SSAS Cubes, dimensions and data source views SSAS-Data Mining Models and deploying and processing SSAS objects

• Experience in report writing using SQL Server Reporting Services (SSRS)

• Have work experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems and in creating database objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.

• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.

• Experience in Performance Tuning and Query Optimization

• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP

• Experience in installation, configuration and administration of Tableau Server in a multi-server and multi-tier environment

• Developed Tableau visualizations and dashboards using Tableau Desktop.

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

• Worked on Tableau server updates for new versions.

• Administered user, user groups, and scheduled instances for reports in Tableau.

• Converted reports from SQL Server Reporting Services to Tableau and worked closely with business during this conversion

• Created incremental refreshes for data sources on Tableau server.

• Experience in training business users through online and in-class sessions.

• Have strong analytical, logical, communication and problem-solving skills, ability to adapt to new technologies by self- learning

• Experience in dealing under pressure and leading a small team with sound knowledge in Homeowners Insurance domain SKILLS

• Database: SQL Server, MySQL, Oracle

• Languages: SQL, PL/SQL, MDX, DAX

• Data Modeling Tools: Star Schema, Snowflake

Schema, OLAP, OLTP

• Operating Systems: Windows NT, UNIX/ LINUX

• Tools and Software: Microsoft SQL Server

Management Studio 2017/2012/2008, Visual Studio

2017/2015, SQL Server Data tools, SQL SERVER BID

Studio 2008, SSIS, SSAS, SSRS, SharePoint, Tableau Desktop, Tableau Server, Tableau Prep, PowerBI

CERTIFICATIONS

• Tableau Desktop Specialist November 2018

• ORACLE Database SQL Certified Expert June 2011

EDUCATION

Master of Computer Science May 2013

• Florida State University (FSU) - Tallahassee, Florida Bachelor of Technology (B.Tech.) in Computer Science May 2011

• Jawaharlal Nehru Technological University (JNTU) - Hyderabad, INDIA. TECHNICAL EXPERIENCE

Business Intelligence, SQL and Tableau Developer, Southern Fidelity Insurance Tallahassee June 2013 – Present SQL/ BI Developer:

• Created databases and schema objects including tables, indexes, stored procedures and functions

• Created and modified SQL Stored Procedures

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes

• Designed and implemented facts, dimensions and OLAP cubes using dimensional modelling standards in SQL Server 2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests

• Designed Policy, Claims, Actuary & Accounting Data Cubes (OLAP) with Star/Snowflake Schema using SQL Server Analysis Services (SSAS)

• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes

• Designed and developed an in-house policy rater for the actuary department that rates all the policies in a particular book of business based on the underwriting rules and populates the rating sheet accordingly using SQL Server. This rater has greatly helped the Actuary department for rate changes and comparing the current rates with market rates

• Awarded with Best Employee/ Performer for developing the in-house rater

• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries

• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder

• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture.

(Table, chart and matrix report)

• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS)

• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Daily support of system-wide replication tasks including monitoring, alerting, and problem resolution

• Responsible for documentation of system related activities

• Performed enhancements and updates to existing Customer facing reports

• Trained the business users to create Ad hoc reports of their own Tableau Developer:

• Interacted with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery

• Created complex and innovative dashboards using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions

• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

• Developed various tableau dashboards prototype for the future uses and conversion of current excel and SSRS reports into tableau.

• Mainly dealt with Executive, Actuary, Claims and Marketing departments to analyze their requirements and design dashboards to meet their requirements

• Participated in regular Technical Reviews, Defect review and walkthrough meetings throughout the project life cycle

• Developed various Salesforce centric dashboards for a non-Salesforce group of users for their goals of understanding data

• Developed an interface using Tableau for displaying the calculated rates and the corresponding rating sheets generated in the in- house rater developed in the SQL Server

• Developed various Hurricane specific dashboards and Mobile dashboards that track the path of the hurricanes and all the claims we are getting along the path on a map in real time and send them a summary of what’s happening daily using a subscription. This helps the Claims and Executive departments to be aware of what’s happening during a hurricane period

• Designed and developed innovative geographic map dashboards for the Executive and Claim departments that displays all the in- force policies and claims on a map that gives them a real-time view of all the current business and claims helping them efficiently track and manage various business decisions

• Developed dashboards for the marketing department that allows them to track the standings for all the agencies, marketing zone production information and loss ratio scenarios.

• Implemented Best practices to enhance the response time of tableau dashboards and speed for the embedded dashboards

• Ensured user security for the views using User filters and shared with business users

• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created a tableau functional design document

Teaching Assistant, Florida State University (FSU) Tallahassee Jan 2013 – May 2013

• Worked under professors as an administrative TA for Computer Fluency courses

• Been a primary contact for the assigned students for all the administrative situations such as grading questions and extension requests

Online Help Desk Support, Florida State University (FSU) Tallahassee Jan 2013 – May 2013

• Part of the team that is responsible for providing online support for students to answer all their course related questions and ensuring to maintain all the course flow procedures Campus Representative, ASUS Aug 2012 – May 2013

• Worked as a Student Campus Representative for ASUS at Florida State University

• Created awareness about ASUS on campus and online

• Drove traffic to campuslife.asus.com and our social media sites

• Worked as a team to increase performance

• Acted as social media support for other teams

• Promoted ASUS Student Deals & Giveaways

Programming SQL Developer Intern, Southern Fidelity Insurance Tallahassee June 2012 – May 2013

• Wrote and ran different type of SQL queries using DDL, DML, DCL commands.

• Created and modified SQL Stored Procedures.

• Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS.

• Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server

• Involved in analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.

• Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.

• Monitored and provided front-line support of daily processes.

• Actively involved in production support by Performing Tests, Trouble Shooting and Bug Fixing.

• Documented and maintained database system specifications, diagrams, and connectivity charts. Library Systems Technical Group Assistant, Strozier Library, Florida State University (FSU) Tallahassee Sep 2011 – May 2013

• Assisted the Systems Department in maintaining library technology and computers, including:

- Public and staff computers

- Access to library databases and electronic reserves

- Library automation system online catalog

- Staff modules

- Reports

- Configuration

- Troubleshooting

- Library statistics

- Equipment inventory

- Software license maintenance

ACADEMIC PROJECT EXPERIENCE

Forms, Relationships and Help Modules for a Java Applet-Based Database Management Interface May 2013

• Worked on developing the Forms, Relationships and Help modules in a DB interface. Through these modules in the interface a user can create relationships between two tables, generate editable forms based on these related tables and access the required information that can be used in getting familiar with how this interface can be used. Implementing a Business Intelligence solution using OLAP techniques Jan 2011-Mar 2011

• Implemented a Business Intelligence solution using open source OLAP tool MONDRIAN which is used in the development of the product Seed Flow developed for the seed production and marketing industry by ATS Trans Logic Systems. Suspicious E-mail Detection June 2010

• Developed an application that suspects e-mails consisting of offensive, anti-social elements and blocks them which help in identifying the suspicious user.

EXTRA-CURRICULAR ACHIEVEMENTS

• National Championships Adult 18 and Over 3.5 Level 4th Place, United States Tennis Association (USTA) League October 2015

• Adult 18 and Over FL Sectional Champions, United States Tennis Association (USTA) League August 2015

• Professional Tennis Registry (PTR) Certified Instructor and member 2009-2010

• Member of college Table Tennis team at ICTHALON-09, an all India Inter College Annual Sports March 2009

Contact this candidate