SUMMARY:

• 5 years of professional experience as MS SQL Server/ETL/BI developer in designing and developing T - SQL queries, ETL package, and business reports using SSMS, SSIS and SSRS
• Highly qualified in Tableau Desktop and Tableau Server with 4 years of professional experience in various versions of Tableau(8.x/9.x/10.x).
• Worked with multiple System Development Life Cycle (SDLC) methodologies including Waterfall, Agile -Scrum Framework and have extensive experience working with Development, Production and QA environment.
• Robust understanding of logical and physical Database design and development, data conversion and Normalization concept.
• Proficient at data Extraction, Transformation and Loading(ETL) between Homogenous and Heterogeneous Systems.
• Experienced in SSIS for creating, documenting and deploying ETL packages under Package Deployment Model and Project Deployment Model to load data from source to destination.
• Proficient using SSIS for implementing initial data load using Bulk Insert Task, Bulk Copy Program and Fast Load. Also, expert at implementing incremental data load using Slowly Changing Dimension(SCDs), Change Tracking and Change Data Capture(CDC).
• Skilled at Error Logging, Exception handling and Custom Logging for SSIS package and Performance tuning in SSIS package.
• Profound understanding of Enterprise Data Warehouse(EDW) concepts including OLTP/OLAP, Dimension/Fact table, Top-down/Bottom-Models, Star/Snowflake schemas.
• Proficient in T-SQL, Query optimization, creation of Views, Triggers, User-defined functions, Store Procedures, Dynamic-queries and using CTE, Temp table, Table Variable, View as well as Subquery and join.
• Broadly Intricated in Requirement gathering, Requirement documentation, Writing test plans, Testing and Quality reviews.
• Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SQL SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including the status.
• Hands-on experience with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Donut Charts, Circle Views, Line Charts, Bullet Graphs and Histograms in Tableau Desktop versions (8x/9.x/10.x).
• Proficient at Developing Dashboards and user stories using Tableau to deliver insights and advanced visualization. using Data blending, Replace s and customized queries in Tableau.
• Proficient at using Alteryx for Customer Churn Analytics, Data Blending, Data Cataloging, Data Profiling, In- Database Processing.
• Passion for exploring modern technology, strong social responsibility, outstanding interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS:

RDBMS/OLTP: SQL 2008/2008R 2/2012/2014/2016 , Oracle 9i/10g/11g, MS Access

Data Warehouse/OLAP: SQL Server Analysis Services(SSAS), IBM Cognos, Tableau Server

Reporting Tools: SQL Server Reporting Service(SSRS), Tableau (8x/9.x/10.x)., IBM Cognos, PowerBI, Qlikview (1.x/2.x/3.x), Domo

ETL: SQL Server Integration Service (SSIS), Data Transformation Services, SQL Server Data Tools(SSDT), Alteryx

Project Management Tools: JIRA, SharePoint, Github, MS Project Planner, TFS

Platform: Visual Studio 2005/2008/2010/2012

Programming Language: SQL, T-SQL, PL/SQL, R-Programming, Python(2.x/3.x)

PROFESSIONAL EXPERIENCE:

Confidential, Rutherford, NJ

Sr. BI Developer/Tableau Developer (SQL/SSMS/SSIS/SSRS/Tableau)

Responsibilities:

• Responsible for the Deliverables, Scheduling, Resource allocation and requirement gathering for the project.
• Provide technical expertise to the management and development teams.
• Identifying and creating Facts, Dimensions, and Hierarchies of the business model.
• Involved in requirement gathering, creation of requirement specification documents for new SSRS reports.
• Interact with business users to refine the requirement and to explain end to end change.
• Monitoring the team and their work responsible for task completions and other project management related activities.
• Associated in requirement gathering, impact analysis and design document creation for the existing SSAS cubes and SSRS reports.
• Worked as a liaison between Business Intelligence and Business User groups to relay change requests.
• Coordinated with clients for feasibility study of the project in Tableau and established timelines for designing the database as per project requirement.
• Refresh data on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards display updated data.
• Performed data blending operations using Alteryx to create a de-normalized dataset for report creation.
• Aided in developing runtime-driven tools using the Alteryx API to embed processes into other internal applications and expose these tools to other business analysts across enterprise.
• Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints.
• Ensure on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.

Environment: Tableau 9.x/8.x (Desktop/ Server), SQL Server 2014, SQL Server Management Studio, Alteryx, SQL BI Suite (SSIS, SSRS), Jira(5.x/6.x)

Confidential, Chicago, IL

Business Intelligence Analyst / Tableau Developer

Responsibilities:

• Implemented Tableau BI Dashboard reporting solution for different groups in the organization and published Dashboards onto Tableau Server for users to view in different mediums (laptop, pc, I Pad)
• Participated in technical walk-through meetings to develop the functional design for the implementation of dashboards
• Performed detailed requirement analysis and created data mapping documents.
• Provide data analysis support for the company's initiatives and projects and oversee the performance of these project designs are as per the requirement.
• Created extensive joins for data blending from several different data sources.
• Developed Tableau scorecards, dashboards using stack bars, dual axis charts, geographical maps and Gantt charts. Built complex formulas in Tableau for various business calculations.
• 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 Tableau Desktop.
• Created organized, customized analysis and visualized projects and dashboards for presenting to Senior Level Executives.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Performed Tableau Server administration activities like Site and Project creations and adding users and providing permissions to workbooks.
• Conducted JAD sessions, design discussions and SOS meetings to develop the appropriate data mart.
• Conducted sessions for users on Tableau to use it as a Self-service BI tool for ad-hoc reporting.

Environment: Tableau (Desktop/Server) 8.x/9.x, SSIS, Alteryx, Teradata, Oracle, Toad, SQL Developer, UNIX, MS Visio, MS Office

Confidential, Dallas, TX

Business Intelligence Analyst

Responsibilities:

• Build and maintain inventory of financial reports and dashboards to support management’s decision-making process using SSRS and Create Trailing Twelve Months for all these reports.
• Extracted data from the company’s core financial systems; transform and load data into SQL databases and developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL task, Sequence Container, Breakpoint, and Checkpoint.
• Deployed& configured ETL packages and coordinated with DBAs to schedule the package in SQL server Agent to run the packages every weekend and run reconciliation queries to cross-check the data.
• Updated reports and financial databases to reflect changes in business strategy, new accounts, and new business units.
• Analyzed financial data to explain variances in the budget and determine profitability of the product, line of business, and customer level.
• Provided demonstrations to senior management of various Tableau functionalities and efficient data visualizations approaches using Tableau
• Generated Excel based financial models for forecasting and analyzing financial results using Vlookups, Power pivot, Macros.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. Built complex formulas in Tableau for various business calculations.
• Developed advanced reports for the annual budget process in direct coordination with company management.
• Performed non-repetitive, ad hoc reporting and analysis.
• Supported the financial reporting needs of executives and line of business managers.
• Participated in the preparation of monthly, quarterly, and annual financial reports for internal and external uses.

Environment: SQL Server 2012, Amazon Redshift, SQL Server Integration Services (SSIS), SQL Server Report Service (SSRS), SQL Server Data Tool (SSDT), Tableau 9.x/8.x (Desktop/ Server), MS Access, MS Excel, MS Word, MS Outlook, TFS.

Confidential, Wilmington, DE

MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Involved in gathering user requirements from business users and IT managers and created documentation for the project.
• Worked with writing complex SQL queries that involved reoccurring sub queries with the use of multiple joins and unions.
• Designed and created Data Warehouse solutions using SSIS packages with the use of lookup, merge, union-all.
• Created SSIS packages that involved dealing with different source formats (Text files, XML, Database Tables).
• Implemented Agile Project Management method throughout the project.
• Performed performance tuning with existing SQL queries with the use of SQL Server Profiler/Database Engine Tuning Advisor.
• Developed dashboards in Tabular Modes to help management identify critical KPIs and facilitate strategic planning in the organization.
• Using SSRS designed dashboards having Geo Maps, Heat Maps, Drill through, Drill down reports functionality.
• Deployed the reporting solutions on production servers and maintained the data quality accuracy before data refreshes on dashboards.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns and setup the visibility of dashboards to employees based on their responsibilities.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed & designed various reports (pivots, charts, tabular, drill down, pivot, narrative reports) using global and local filters.
• Created calculated member for complex calculation in reports using Business Intelligence.
• Involved in the development, testing and deployment phase.

Environment: SQL Server 2012, SQL Server Management Studio, SQL BI Suite (SSIS, SSRS), XML, MS Project, MS Access & Windows Server 2008 R2.

Confidential, Little Rock, AR

Business Intelligence Analyst (SQL/SSMS/SSIS/SSRS)

Responsibilities:

• Gathering user requirements from IT, Human Resource, Vendors and provide the functional and non-functional analysis to the enterprise IT architecture, and business architecture.
• Created Store Procedures, User-Defined Functions, Indexed Views, and DML Triggers to facilitate ETL processes using T-SQL.
• Performed T-SQL queries and dynamic queries in SQL server management Studio(SSMS) to create databases for quarterly HR Workforce Scorecard regarding parameters and time frame.
• Aided in design and data modeling efforts of Data Marts and Enterprise Data Warehouse.
• Involved in creating SQL Server integration Services(SSIS) ETL packages and other back-end processes to support system integration and ETL processes to facilitate the creation and population of Enterprise Data Warehouse(EDW).
• Created SSIS packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data Warehouse and Data Marts.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Deployed SSRS monthly reports and applied business rules to maintain the data security and integrity prior to the disclosure of the workforce information.
• Designed data visualizations and other KPI reports according to HR scorecard and executive’s proposal.
• Created Snapshot report, parameterized reports, Drill-down reports and Drill-through reports using SQL Server Service(SSRS).
• Reviewed documentation with developers, clarified any questions or issues.

Environment: MS SQL Server 2008 R2, Service(SSIS), SQL Server Management Studio, SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT), SQL Server Analytical Tool(SSAS), SQL Profiler, Visual studio 2008