SQL Server Developer/ETL SSIS Developer/Tableau Developer

Professional Summary:

●Over * years of IT experience as Tableau Developer/MS SQL Server Developer 2014/2012/2008 R2/2008/2005/2000 in various Industry verticals like Insurance, Airlines, Healthcare, Telecommunication, Pharmaceutical and Bank.

●Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

●Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

●Proficient in Design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement

●Expert in evaluating data models to design Tableau solutions.

●Responsible for developing interactive data visualizations.

●Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.

●Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.

●Highly proficient in the use of T SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.

●Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.

●Expert in Data Conversion, Normalization and Data Modeling, Multidimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

●Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

●Proficient in creating On demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).

●Maintained positive communications and working relationships at all business levels.

Education & Certification:

Masters in Banking and Finance

Microsoft SQL Server certification

Skillset

MS SQL Server 2012/2008 R2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft, Tableau Desktop 10/9.2/8/7/6/5, Tableau Server 10/9.2/8/7/6/5, Tableau Online, Tableau Public, Tableau Reader, Tabcmd, Citrix Server, WINSCP, SAS Enterprise Guide 7.0, SAS Visual Analytics, Access 2000/8.0, TFS, SQL Source Control, SQL Prompt, TSQLT, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Toad, JIRA, Power Designer 16.0, 16.5, Vb.net, Erwin Data Modeler 7.2/4.2/4.1, Excel VBA, Crystal Reports 8.5, T SQL, MS Visio 2005, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Client: District of Columbia Healthcare Finance

Duration: June 2016 - Current

Role: Sr.SQL/SSIS/SSRS/ETL Developer

DC Medicaid is a healthcare program that pays for medical services for qualified people. It helps pay for medical services for low-income and disabled people. For those eligible for full Medicaid services, Medicaid pays healthcare providers. Providers are doctors, hospitals, and pharmacies who are enrolled with DC Medicaid.

Responsibilities:

●Understand the Requirements and Functionality of the application from specifications.

●Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

●Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and

Parameters using Tableau

●Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau

●Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008

●Developed various operational Drill-through and Drill-down reports using SSRS

●Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

●Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

●Developed Reports for business end users using Report Builder with updating Statistics.

●Load Millions of records from MMIS to Sql server and SAS to Sql server through SSIS.

●Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

●Created different KPI using calculated key figures and Cascading parameters

●Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

●Utilized Tableau server to publish and share the reports with the business users

●Also involved in administration tasks such as setting permissions, managing ownership and providing access to the users

and adding then to the specific group.

●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion

●Linked SAS and Tableau Reports through Hyperlink on ID Parameter.

●Move Binary files from SFTP server using WINSCP to Share folder through Execute process task and schedule package in SSIS

●Work with the Data Warehousing team to build data pipelines to support visualization requirements.

●Consulted on Tableau server performance enhancements; upgrades from version 9.3 to 10 and server reconfiguration

based on workbook complexity and data extraction

●Customized the Tableau landing page with site listing as icons and description

●Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

●Created dynamic filters and action filters between tableau multiple dashboards, blended multiple data extract files for

dashboards.

●Writing complex SQL and SAS Quarries to pull data from a backend system with a goal of presenting and visualizing them

in Tableau and Use ODBC Connection to pull SAS Data to Tableau

Tools & Technologies:

Sql Server 2014 and 2016, SSIS, Tableau Desktop 10/9.3, Tableau server 10/9.3, Cognos, Citrix server, SAS Visual Analytics, SAS Enterprise Guide 7.1, SharePoint, ODBC 64Bit Connection, WINSCP, TFS

Client: Transportation Department of Idaho Boise, ID

Duration: September 2015 –June 2016

Role: Sr.SQL/SSIS/SSRS/ETL Developer

Collaborative Online Archival Library providing a consolidation master data model (MDM) data repository for all DMV data for purpose of analysis and reporting.

Responsibilities:

●Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.

●Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations.

●Applied conditional formatting in SSRS to highlight key areas in the report data.

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

●Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

●Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.

●Worked a great extent with the design and development of Tableau visualizations, which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.

●Installed and upgraded Tableau server and server performance tuning for optimization.

●Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

●Implementation of MS SQL Server 2012 Management studio to create Complex Stored procedures, Triggers, User defined Functions, views to evaluate results for the reports.

●Prepared Complete Data mapping and report definitions for the project.

●Created Complex ETL Package using SSIS to extract data from staging tables to partition table with incremental load.

●Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification

●Involved in Tableau installation and configuration with Single Server System and Three Node Server System.

●Configuring Users based on Active Directory and logged in through Run as User account.

●Created numerous dashboards in Tableau Desktop based on the data collected from Customer Data Tracking System by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.

●Created Synonyms Provides a layer of abstraction that protects a client application from changes made to the name or location of the base object.

●Created a procedure using Error Handling, try/catch and transaction, Symmetric key based structures.

●Created TSQLT stored procedure to test existing stored procedures.

●Implemented CDC (Change Data Capture) to monitoring Insert, Update and Delete records on Tables.

●Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Customer Vehicle and License records

●Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.

●Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Customer Vehicle and License records usage with Quick Filters for on demand needed information with just a click of a button.

Tools & Technologies:

MS SQL Server 2012, T SQL, SSIS, Tableau Desktop 9/8, Tableau Server 9/8, Tabcmd, TFS, TSQLT, SQL Source Control, SQL Prompt, Microsoft Excel

Client: Federal Home Loan Bank, Des Moines, IA

Duration: February 2015 – Aug 2015

Role: SQL Server Developer/ETL SSIS Developer/Tableau Developer

This project is to provide Seattle member seamless integration into the Des Moines bank. Providing both Seattle and Des Moines member’s benefits such as new Advance products and various types of Collateral. This project will also work to greatly reduce the operating expenses of both banks thereby improving the financials for all members.

Responsibilities:

●Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

●Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.

●Held responsibility for integration points and the order in which these must be executed.

●Built compelling, interactive dashboards in Tableau that answer key business questions.

●Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.

●Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.

●Generated insights out of voluminous and complex datasets and built story lines.

●Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.

●Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.

●Involved in reviewing business requirements and analyzing data sources from MS SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.

●Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.

●Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.

●Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

●Experience in SQL joins, sub queries, Function, tracing and performance tuning for better running of queries.

●Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

●Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

●Created metadata in Excel and pulled that metadata through SSIS Control Packages to generate Comparison report for Source to Source, Source to Application and Application to Data Warehouse Report in Excel.

Tools & Technologies:

Tableau Desktop 8, Tableau Server 8, Tabcmd, MS SQL Server 2012/2008 R2, T SQL, SSIS, SSRS, Microsoft Excel, TortoisSVN, JIRA

Client: Iron Mountain, Irvine, CA

Duration: September 2014 – February 2015

Role: SQL Server Developer/SSIS/Tableau Developer

Job Description:

Iron Mountain’s Accutrac software provides a total records management solution to manage your active and inactive records wherever they reside, all from a single interface. The Accutrac® application is a comprehensive and flexible system for managing enterprise records. It is a highly configurable system

Enabling a user to customize the program to best fit a company’s business processes.

Responsibilities:

●Responsible for gathering and defining the initial requirements, Reports Development, Testing, Implementation, and Support

●Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

●Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

●Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.

●Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

●Used SQL Queries at the custom SQL level to pull the data in tableau desktop.

●Validated the results in Tableau by running SQL queries in MS SQL developer.

●Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.

●Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.

●Performed performance tuning of the dashboard in Tableau desktop.

●Created SSIS packages to clean and load data to data warehouse.

●Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

●Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

●Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters

●Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition

Split, Script Task, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, File System Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Created stored Procedures, triggers, Views, tables and generated T SQL Script for application

●Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database

Tools & Technologies:

MS SQL Server 2012/2008 R2, Tableau Desktop 7/6, Tableau Server 7, T SQL, SSIS, Microsoft Excel, TortoisSVN, JIRA

Client: Wells Fargo, Concord, CA

Duration: October 2013 – August 2014

Role: Sr. Business Intelligence Developer/Tableau Developer

Job Description:

The purpose of this project is for Wells Fargo system applications to integrate data from different data sources to destination databases and generate different kinds of reports using Tableau for inter user’s.

Responsibilities:

●Planned, defined and designed data based on business requirement and provided documentation.

●Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

●Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.

●Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop

●Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate) and also used Custom components such as Audit on Pre Execute, Audit on Post Execute, Custom Email Task and Statistics Logging Component.

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.

●Provided support for Tableau developed objects and understand tool administration.

●Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

●Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.

●Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups and String manipulations.

●Used commands in Tabcmd and Tabadmin utility tool for Tableau Server maintains and configurations.

●Published Workbooks and Dashboards to the Tableau server.

●Monitoring performance and optimizing SQL queries for maximum efficiency

●Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

●Combined visualizations into Interactive Dashboards and publish them to the web.

●Created groups and users in Tableau server

●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● modified the existing SSIS packages to meet the changes specified by the users.

Tools & Technologies:

MS SQL Server 2012/2008 R2, T SQL, SSIS, Tableau Desktop 8/9, Business Object 3.1, Oracle 11g, ODBC, Microsoft

Excel

Client: Hawaiian Airlines, Honolulu, Hawaii

Duration: January 2013 September 2013

Role: Sql Developer/Tableau Developer/Data Modeler

Flight Data Mart this application provides fast, efficient, secure and state of the art data analysis capabilities in reference to the Flight data. It provides benefits of modern IT infrastructure with powerful reporting capabilities via Tableau. Power User will leverage from analytics capabilities offered by tool in excel 2007, 2010 generate metrics/KPIs for strategic and corporate management whereas other business users will use canned reports for their operational analysis.

Responsibilities:

●Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.

●Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.

●Created guided navigation links for Interactive dashboards in Tableau.

●Developed actions filters, combine field, Group, Calculated field, Filters and sets for preparing dashboards and worksheets using Tableau Desktop

●Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

●Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.

●Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

●Involved in reviewing business requirements and analyzing data sources (Oracle and SQL Server) for design, development of reporting and analysis projects within Tableau Desktop.

●Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

●Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.

●Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table

●Involved in creating a dual-axis bar chart with multiple measures.

●Configured and Installed Tableau Server using three tier architectures.

Tools& Technologies:

MS SQL Server 2012/2008 R2, Tableau Desktop 7/8, Tableau Server 7/8, TabCMD, T SQL, SSIS, SSAS, Erwin 7.2, Microsoft Access, Oracle 10g

Client: AIG Insurance, Jersey City, New Jersey

Duration: July 2012 – December 2012

Role: Senior MS SQL Server/SSIS/Tableau Developer/ Data Modeler

Job Description:

Detailed analysis, reviews and recommendation of designs of data structures required for storing detailed underwriting, financial and accounting data efficiently for use in the Economic Capital Model implemented in Tower Watson Igloo risk modeling environment.

Responsibilities:

●Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non functional specifications for BI reports and applications.

●Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.

●Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information

●Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.

●As in development team, worked with DBA teams for database update and system restarts.

Tools & Technologies:

MS SQL Server 2012/2008 R2, T SQL, SSIS, Tableau 8.2, Tableau server, Win 2003 Advanced Server, Erwin v7.2,

Client: Care First Insurance, Baltimore, Maryland

Duration: October 2010 – July 2012

Role: MS SQL Server Developer/SSIS/Tableau Developer

The mission of care First Blue Cross Blue Shield is to provide health benefit services of value Customer

Across the region comprised of Maryland and the National Capital Area. To fulfill this Mission, CareFirst

Blue Shield Commits to collaborate with community to advance health care Effectiveness and quality,

Offer a broad array of quality, innovative insurance plans and Administrative services that is affordable

and accessible.

Responsibilities:

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.

●Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.

●Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

●Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.

●Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

●Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

●Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis

●Modified the existing SSIS packages to meet the changes specified by the users.

●Trained on building Conceptual, Logical and Physical data model.

Tools & Technologies:

MS SQL Server 2008, Tableau Desktop 7/8, Tableau Server 7/8, T-SQL, SSIS, Win 2003

Advanced Server, Erwin v7.2.

Client: A.D.C Bank, Ahmedabad, INDIA

Duration January 2007– February 2008

Role: MS SQL Server Developer

Ahmedabad District Co. Operative is INDIA largest private sector bank. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. The project was more on the upgrading of the server from a MS SQL Server version 7.0 to the MS SQL 2000 version. Implementation of user login and security was developed.

Responsibilities:

●Installed and configured SQL server 2000, created logins, users and maintenance plans managing use of disk memory and connections to the database.

●Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, T-SQL, Stored Procedures and Views).

●Used ER-win, Normalization, Dimension Modeling and Enterprise Manager for Logical and physical database development.

●Imposed Referential Integrity of data by creating different constraints.

●Migration of the data from text files to SQL Server database using BCP and DTS packages for the processing of different policies.

●Managed and Monitored System Utilization.

●Created triggers, stored procedures and functions using T-SQL to implement the business logic.

●Designed and Implemented the Stored Procedures and Triggers for automating tasks.

Tools & Technologies:

MS SQL Server 2000/4.0, Windows Server, Windows NT, .NET, Erwin.

Contact this candidate