SUMMARY

• Around 8+ years of IT experience, which includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2014/2012/2008/2005 ) in production environments.
• Experience in developing Tableau visualizations and dashboards using Tableau Desktop.
• In - depth knowledge on Data Analytics and experience in creating Tableau Data Extracts and scheduling the Extracts for daily refresh.
• Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, geo maps and stories using Tableau.
• Experience in developing and implementing Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Reporting Services (SSRS).
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad-hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Tableau
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.
• Worked on the Data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a Data warehousing application.
• Experience in Logical modeling, Data Marts, Data warehousing, Operational Data Store (ODS) and OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, FACT and Dimensions Tables using MS Analysis Services.
• In-depth knowledge of Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.
• Knowledge in creating cubes, dimensions, measures, measure groups and key performance indicators (KPIs) using Analysis Services (SSAS)
• Experience in coding SQL scripts to analyze data, modify data, import / export scripts, and execute stored procedures.
• Excellent experience in creating complex queries Stored Procedures, View, Triggers, Union and Join Functions.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Designed, developed and supported BI solutions, Involved in Debugging, monitoring and troubleshooting issues.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Ability to work on multiple technologies.

TECHNICAL SKILLS

Programming Languages: C, C++, PL/SQL, C#

Databases: SQL Server 2000/2005/2008 , Oracle 9i, MySql

Microsoft Technologies: SSIS, SSRS, SSAS, DTS, SQL Management Studio

Reporting Tools: Tableau, SSRS, Excel, Power View

Operating Systems: Windows XP/Vista/2000/NT 4.0/98/95, Linux, UNIX, Mac OS.

SAP Technologies: Business Objects Data Services (BODS)

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Sr. Tableau/SQL BI Developer

Responsibilities:

• Worked on gathering and analyzing business requirements for new project requests. Developed ad-hoc queries and reports for clients and provide analytical support and recommendation as necessary.
• Built several business dashboards using Tableau to conduct trend analysis on retail metrics, especially relating to driving sales revenue.
• Used Business Intelligence Reporting Tools like Tableau, SSRS and Power Pivots to create KPIs and Scorecards for clients like Whirlpool, Hisense, Bose, HP, Tracfone and others.
• Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
• Built ETL Packages to import data from SalesForce and custom sources to SQL Server to support analytical reports.
• Built Marketing Dashboard using Tableau for Corporate program to analyze the Confidential website Traffic flow.
• Developed Transition Reports for Whirlpool Client using Tableau which shows how the SKU’s are transitioned at each retailer.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Extensively involved in writing complex SQL queries to create custom data Extracts in Tableau.
• Scheduled Tableau reports on auto refresh on Tableau online and also monitored the refresh schedules.
• Built several Views, Stored Procedures, and SQL Scripts for all the adhoc requests.
• Validated the data from the reports against the database by developing SQL queries.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Assisted in redesigning and tuning existing stored procedures, triggers, UDF, views that ultimately improved the performance of the queries.

Environment: SQL Server 2014, Tableau 10.0, SSRS 2014, SSIS 2014, SSAS 2014,Teradata, Management Studio, SharePoint, JIRA.

Confidential, Atlanta, GA

Reporting Analyst/Tableau Developer

Responsibilities:

• Built leadership dashboards using Tableau to help drive multiple focus initiatives such as First Call Resolution, and agent schedule adherence.
• Deep dive analysis on reporting data sources to track suspected issues and differences between data sources.
• Built trending analysis reporting to ensure that customers with equipment changes were handled effectively without having to contact support for further assistance.
• Designed a detailed reporting solution to help reduce unnecessary tech visits to the home to improve customer support and satisfaction.
• Experience in creating Rich Dashboards using Tableau for Customer Care division.
• Created Dashboards and Data visualization for business to take key decisions.
• Involved in migrating data from multiple sources using Integration tools.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau Dashboards from multiple data sources using Data Blending.
• Involved in Developing Tableau Data Extracts from SQL Server and Teradata sources and also used live connection based on the volume of data.
• Extensively involved in writing complex SQL queries to create custom data Extracts in Tableau.
• Experience in using Tableau Dashboard Actions to navigate between the Dashboards, Workbooks and also to pass the filters.
• Used Tableau best practices for creating dashboards by matching requirements to the charts to be chosen, color to be used and configuring tool tips.
• Created several trend reports to measure KPI’s, increased business focus on the key Issues.
• Developed Ad-hoc reports using SSRS, Excel.
• Responsible for gathering business requirements for different phases of the projects. And also involved in report documentation.
• Documented all the reports in Wiki tool.

Environment: SQL Server 2012, Tableau 9.0, SSRS 2012, SSIS 2012, TFS 2012,Teradata, Management Studio, Redmine, SharePoint

Confidential, Louisville, KY

Sr.BI Developer

Responsibilities:

• Created OLAP cube for ABC (Activity Based Costing) where user can analyze different metrics resolved around various dimensions to estimate the total costs incurred and profits made.
• Created Data Mart with Fact and Dimensions tables on SQL Server 2008 database.
• Designed the OLAP cube using Star Flake schema.
• Involved in creating Views and writing complex SQL queries to build the OLAP cube.
• Created several SSIS packages to load data from different sources into the Data Warehouse.
• Created Linked Servers for connecting several servers to pull the data for ABC Data Warehouse.
• Automated the SSIS packages to do an Incremental load to the Data Warehouse.
• Scheduled the SSIS packages for daily loads.
• Created SSRS reports to show custom analysis of Activity Based Costing.
• Created Drill Down and Drill through SSRS reports for showing different grouping of billings and also for navigating through several parent child reports.
• Created a Report Server link to access the SSRS reports on the IIS.
• Uploaded ABC Reports on to the Reporting Server where user can directly access the reports using a website link.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in taking daily backups of the Databases to avoid any loss of the data.
• Knowledge on version controlling with Team Foundation Server.

Environment: SQL Server 2008, Query Analyzer, SSIS 2008, T-SQL, Excel, Microsoft SQL Reporting Services 2008 (SSRS),MS SQL Analysis Services(SSAS), SQL Server Management Studio

Confidential, Edina, MN

Sr.BI Developer/Report Analyst

Responsibilities:

• Created SQL server Reports using SSRS 2008 for the management to take strategic decisions.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Designer.
• Created a dash board implementation using various key indicators in charts, graph, gauge, list and pie charts.
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Modified existing reports according to requirements of the end users.
• Rendered reports in different formats like PDF, HTML, Word, and delivered reports via push and pull delivery methods.
• Deployed all the reports to Report server and managed through Report manager.
• Involved in performing database Backup and Recovery.
• Responded timely to daily ad hoc reporting requests from various organizational teams.

Environment: MS SQL Server BIDS 2008, Microsoft Visual Studio, SQL Server Management Studio, SSRS, SSIS

Confidential, Minnesota, MN

BI Developer

Responsibilities:

• Actively involved in design and development of Centralized Data Warehouse using Microsoft SQL Server 2008.
• Involved in Source Data Analysis, designing Mappings for data extraction, and designing and developing SSIS Packages to load the data from various databases and files.
• Migrated data from Heterogeneous Data Sources and legacy system (Flat file, Access, Oracle, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Participated in upgrade/migration of MS SQL Server 2005 to MS SQL Server 2008 without service interruption using side-by-side migration.
• Used various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Fuzzy Grouping, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations in the SSIS Packages.
• Worked on de-bugging package execution using break points in control flow and data viewer in data flow.
• Used Deployment Utility to deploy the SSIS Packages from Development to Production Environment.
• Scheduled SQL Jobs using SQL Agent to automate all the SSIS packages.
• Involved in design and development of Reports representing information in textual and graphical formats using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server BIDS 2008, Microsoft Visual Studio, SQL Server Management Studio, SSIS, SSRS

Confidential, Mundelein, IL

ETL Developer

Responsibilities:

• Worked on extracting, transforming and loading data using BODS.
• Extensively worked on all activities related to the development, implementation and support of ETL (Extract, Transform and Load) processes for large-scale data warehouses using SQL Server SSIS and BODS.
• Scheduled SQL Job using SQL Agent to automate all the SSIS packages.
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load (OLTP databases like SQL Server, Oracle, MS Access flat file, excel etc.) data to data warehouse databases and involved in Data cleansing in the data transfer.
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Generated Tabular, Sub reports and Parameterized reports for the Business users to analyze the migration of data.
• Formatted the reports using the Global variables and expressions using report designer.
• Developed a dashboard reports as per the end user requirement for an easy understanding of business.
• Involved in Performance Tuning to improve response time of Stored Procedures.

Environment: MS SQL Server 2008, SSIS, SSRS, BODS, Microsoft Visual Studio 2008

Confidential, Fitchburg, MA

Freelance Analyst/Developer

Responsibilities:

• Created ad-hoc reports, and complex Enterprise reports (drill down, and drill through reports, Parameterized reports, cascading report) using SQL Server Reporting Services and report manager. Created linked reports using report builder.
• Wrote SQL queries to provide day to day ad-hoc reports to the admissions team.
• Involved in deploying reports to reporting server.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.
• Completed documentation about the database. Analyzed long running, slow queries and tuned the same to optimize application and system performance.
• Documented and trained users to use Reporting Services.

Environment: MS SQL Server 2008, SQL server Reporting Services 2008, SQL, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.