SUMMARY

• Over 7 years of database development experience with Microsoft SQL Server 2008/2012/2014/2016. Worked with SSIS, SSRS, SSAS, Excel, Power BI, and Tableau as well as ETL and Data Extraction.
• Experience working with the full development cycle of a data warehouse including requirements gathering, design, implementation, and maintenance. A team player and looking for a challenging opportunity that will leverage technical background to add value on a project.

TECHNICAL SKILLS

Languages: T - SQL, Java, C#, C/C++, CSS, HTML, PHP, MatLab

Data Warehouse Tools: SSIS, SSRS, SSAS, Business Intelligence Development Studio, DTS, SQL Profiler, Weka.

Database: MS SQL 2016/2014/2012/2008 , MySQL, Teradata, Visual Studio 2010,2012 and 2013, MS SharePoint 2013, TFS 2013, Power BI, Azure DB.

Reporting Tools: Excel, Power BI, Tableau, SQL Server Reporting Services 2014, 2012, 2008, 2005.

Web Technologies: HTML5, CSS3, JavaScript, ASP.NET, PHP, MVC, Hibernate Framework, Spring MVC, JSP, Servlets, Hibernate, XML, SOAP, REST, JSON, AJAX, JQuery, Prototype, WCF, Bootstrap.

Other Tools: MS Office, JIRA, Confluence, Visio, MS Excel, MS-Project, Star UML, Eclipse, Load Runner, NetBeans, Adobe Photoshop CS, Corel paint shop pro, Microsoft Photo edition 2006, Illustrator.

PROFESSIONAL EXPERIENCE

Sr. BI / ETL, SQL Developer

Confidential

Responsibilities:

• Responsible for Tableau reporting on Amazon’s Business group
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Tasked with moving data from Data lake/SQL server to AWS Redshift
• Managing entire ETL process for the team using Datanet and EDX
• Responsible for leads generation using RPA
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Sr.BI / ETL, SQL Developer

Confidential

Responsibilities:

• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Used Teradata utilities fastload, multiload, tpump to load data.
• Involved in Design and development of new data warehouse (Analytical Data Warehouse) for better reporting and analysis.
• Mange and administer two servers (Production and User Acceptance) used by worldwide Team.
• Create SSIS package to pull all incident and programs data from database server and SharePoint lists.
• Create a staging database and apply the business logic using T-SQL scripts.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Performance Tuning the Stored Procedures used in SSIS Packages
• Wrote Stored Procedures in designing various SSIS packages
• Involved in Performance tuning of ETL transformations, data validations and stored procedure
• Partnered with IT and business leadership to develop applications for internal use.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created Sets, Groups and Data Bins as per user requirements.
• Created and Published Tableau Dashboards into Tableau Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Created Development and Production support documents
• Worked with BI team members to define development specifications and created data loads and reports that were high quality while ensuring their ability to automatically refresh the report more easily.
• Created the necessary SQL objects/models to support a range of ad-hoc and standard reports/dashboard in Power BI, Tableau and Excel.
• Develop Tableau reports that provide clear visualizations of various KPIs.
• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Performance Tuning the Stored Procedures used in SSIS Packages
• Wrote Stored Procedures in designing various SSIS packages
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Sr.BI /Data Architect (Tableau Report)

Confidential

Responsibilities:

• Partnered with IT and business leadership to develop applications for internal use.
• Extracted data from different sources like MVS data sets, Flat files (“pipe” delimited or fixed length), excel spreadsheets and Databases.
• Used Teradata utilities FAST LOAD, MULTI LOAD, TPUMP to load data.
• Wrote, tested and implemented Teradata Fast load, Multiload and BTEQ scripts, DML and DDL.
• Worked with BI team members to define development specifications and created data loads and reports that were high quality while ensuring their ability to automatically refresh the report more easily.
• Created the necessary SQL objects/models to support a range of ad-hoc and standard reports/dashboard in Power BI, Tableau and Excel.
• Develop Tableau reports that provide clear visualizations of various KPIs.
• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Performance Tuning the Stored Procedures used in SSIS Packages
• Wrote Stored Procedures in designing various SSIS packages
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Sr.BI Developer (ETL, SQL, Power BI / Tableau Report)

Confidential

Responsibilities:

• Extract data directly from various data sources (Splash Core, SAP, Data warehouse) using SSIS
• Create a (user friendly) central database which combines the various data
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks create multiple kind of Power BI Reports and Dashboards.
• Build/create a UI through which we can generate sales reports, forecasting tools, etc.
• Train existing ops/tech on how to use Power BI
• Migrate Business Objects reports to Power BI
• Migrate SSRS reports to Power BI
• Designed and created different ETL packages using SSIS from various source to SQL Server as destination
• Performance Tuning the Stored Procedures used in SSIS Packages
• Wrote Stored Procedures in designing various SSIS packages
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Develop Tableau reports that provide clear visualizations of various KPIs.