SUMMARY:

• An experienced and highly motivated IT professional, with 8+ years of experience in analysis, architecture, design, development, testing and support of Business Intelligence products and services in Tableau Desktop and Server Components and Power BI, Database and ETL processes using MSBI (SQL SERVER, SSIS, SSRS and SSAS).
• Hands on experience in development, administration, managing, designing, Dimension modeling, and testing of enterprise wide reporting systems.
• Proven experience in IT industry with business analysis, development and implementation of Data warehousing and Database, focusing on Requirement Analysis, Development, Testing, Administration and Implementation of BI Solutions in various verticals such as Banking, Insurance, Retail, Manufacturing and Healthcare.
• Involved in Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings, Create the Task Board and Sprint Burn down Chart at the start of every Sprint, attend all Scrum meetings and continually work with the Team and business to find and implement improvements.
• Interacted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Proficient with Cross tab, Scatter Plots, Heat Map, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart, etc.
• Experienced in advanced Tableau features including calculated fields, parameters, table calculations, row - level security, joins, data blending, and dashboard actions.
• Create a wide variety of analysis including comparisons, Forecasting, trending and what-if analysis.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created dashboards for measures with forecast, trend line and reference lines.
• Generated context filters and data source filters while handling huge volume of data.
• Experienced in working on Tableau Products like Desktop, Server, Reader. Creating Dashboards and Reports using different functionalities.
• Created parameters for dynamically changing the View, filters and Sorting the data as per user selection and added local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Expertise in generating standard and ad hoc reporting capabilities from new and existing data sources.
• Expertise in Creating Schema Objects (attributes, facts, Hierarchies, Transformations), Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Drill Maps, Templates).
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Experienced in developing rich Interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.
• Created data extracts and scheduled extract refresh when publishing to Tableau Server.
• Optimizing tableau dashboard performance.
• Published Workbooks and Dashboards by creating user filters and Groups, so that only appropriate teams can view it.
• Finding new views and ways to present data on dashboard.
• Guide the best practices of visual design and building end-to-end effective and secure Tableau analytical solutions for performance.
• Involved in Data Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Involved the Source-Target Mapping for the Dimensions and Fact Tables.
• Worked with Dimensional modeling, Data migration, Data cleansing, ETL Processes for the data warehouse.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Technical and analytical skill with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using ETL tools (SSIS, Bulk Insert, and BCP).
• Experience in pulling the data from various sources such as SQL Server, Mainframes, Text files, Excel files, .tab files, .dat files, Oracle, SharePoint, Access Database, ODBC and flat file sources.
• Worked on Various SSIS components like Control Flow, Data Flow Transformations, Error Logging and Event Handlers.
• Creating Package Configuration to change the package properties dynamically in SSIS.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge of Creating User defined Project Variables, Package Variables and using System Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Good experience in Users/User Groups, Security Filters, Security Roles and Project management in SQL SERVER/SSIS.
• Creating Jobs, Alerts, and Scheduling SSIS packages by using SQL agent and Created Mailing concept using SMTP server.
• Performed operations like Data reconciliation, Data Integrity, Data validation and error handling after extracting data into files and SQL Server.
• Monitoring of database size and disk space in production and Planning and Implementing Backup and Recovery Strategy. Good Knowledge in Full Backup, Differential Backup and Log Backup.
• Excellent experience in creating Indexes, Indexed views and creating effective Functions, Procedures and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience in optimizing performance of various long running queries and stored procedures usingSQLProfiler, Index Tuning Wizard, Windows Performance monitor and optimizing the queries.
• Reorganizing Index for fixing internal fragmentation and Rebuilding the Index for fixing internal and external fragmentation, which will improve the query performance.
• Good Experience in Service Desk Management (SDM),Creating Incidents and Requests for source data issue.
• Handling SDM’s for Production Issues and Providing L1 and L2 support for production Environment.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 7.x, 8.x, 9.x, 10.x, Tableau Server, Power BI and MSBI(SSIS, SSRS, and SSAS) 2005-14.

BI Mobile: Tableau Mobile.

Databases: SQL Server 2005-14, Access Database.

Query Tools: SQL Management Studio, SQL Data Tool, Access, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer.

Modeling Tools: MS VISIO.

ETL Tools: SQL Server Integration Services (SSIS).

Reporting Tools: SSRS.

Visualization Tools: Tableau and Power BI

Programming: T-SQL, VB. Net, C AND C++.

Scripting: HTML, Java Script, VB Script, C#.

Operating Systems: Windows XP, 2003, 2007 and 2010.

Other Tools: MS SQL Profiler, SQL Query Analyzer, MS Visio, SQL Server Agent, Control-M.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. BI Engineer & Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Involved in various JAD sessions to fully understand customer specifications and convert them into Detailed functional documentation.
• Used Tableau to create key dashboards to help translate raw data into visualizations for stakeholders and clients.
• Identified new metrics and enhanced the existing KPI's. And used Custom SQL for complex data pulls, and replicated thoseCustom SQL query joins onto Tableau to connect to various data sources.
• Designed, developed and implemented BI solution for Air Travel, Credit Card, Hotel and Customer KPIs (Key Performance Indicators)for the top management.
• Created action filters, parameters and calculated fields, sets for preparing dashboards and worksheets in Tableau that allowed end users to understand the data.
• Created User control with the usage of quick filters and dynamic parameter controls for on demand needed information.
• Developed Tableau data visualization for Air travel, Hotel and Credit Card performance using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Rebuild existing Reports into Tableau Visualizations with user and action filters.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip for gap analysis and utilized Tableau QA server to publish and share the reports with the QA team.
• Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Responsible in enhancing the existing Reports and pdf’s, creating reports using Tableau desktop.
• Validating the logic and underlying data in views.
• Used Tableau to create key dashboards to help translate raw data into visualizations for stakeholders and clients.
• Interact with customers on a regular basis to resolve issues.
• Participated in daily stand-ups with clients on daily design and development effort
• Improved Reports performance with strong analytical and troubleshooting skills for quick issue resolving in large-scale production environments located globally.
• Performed weekly batch loads (Full & Incremental) by building, deploying and executing of the DB Table Details, Customer Air travel, Card transactions info and hotel transactions info packages in both the Dev and Prod, troubleshooting process for issues and errors occurred using SSIS.
• Performed unit testing, integration, user acceptance testing on the loaded data into DR Platform and provided production support for the Accounts and Cards Reports deployed.

Environment: Tableau Desktop and server 10.x/9.x/8.x,SQL server 2012, SSDT, SSIS, SSRS, Import/Export tools, SQL Server Agent, MS Access, Visual studio, Report Builder

Confidential, New York

BI Engineer & Sr. Tableau Developer

Responsibilities:

• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Lead multiple teams for new initiatives, enhancements and support of BI in Corporate Office of Technology.
• Interacted with business stakeholders to understand their requirements, analyzing the available data to build Tableau Dashboards.
• Design and develop end-to-end Dashboard solution supporting the reporting process.
• Reverse engineered and optimized reports and dashboards.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created Auditing reports for various purposes like User activity, Package performance.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the Customers status, Income, Tax and region wise dash boards.
• Debugged several data issues using Derived column and data conversion transformation.
• Used Tableau Data Extracts for improving Performance and giving flexibility for different Customers in using worksheets.
• Administered user, user groups, and scheduled instances for reports in BI/Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Defined best practices for Tableau report development and dashboards development.
• Installation and Configuration of SQL SERVER and Tableau tool suite.
• Configuring I-Server, Project and Web Preferences Settings, Database connectivity, Migrating Metadata, Project Duplication Activity.
• Creation users, groups, projects and sites in Tableau server environment.
• Setting up security and permissions at different levels.
• Creating and managing, trouble shooting issues related to reports, schedules and subscriptions.
• Automated the process of taking server backup on weekly basis.
• Created SSIS packages for Import, Aggregation and Extract process
• Developed DPE (Data Process Engine) Packages for executing the packages depending on Business day.
• Created dependency between Import to Aggregation and Aggregation to extract packages.
• Developed scripts for validating the source file availability for all Import packages.
• Created file transfer process for coping source files in to Input folder and sending extract files to end users.
• Created Error log-in mechanism to log the Exception logs, Error logs, Package execution status logs and Process completion logs.
• Have created Data integrity package for extracting last 6 months’ data trend, which is used for trend analysis by BAU team.

Environment: Tableau 8.x/9.x, SQL SERVER 2012, SSIS 2012, Power BI, MAIN FRAMES,AWS, IBM DB2 9.7, Windows.

Confidential, New York

Sr. Software Engineer - Tableau Developer

Responsibilities:

• Reviewed the functional requirement specifications and supporting documents for business systems, created database design process and data modeling process for the EMR by extracting data patient medical reports, Patient-info database and resident survey flat files.
• Created Resident-Info, Nurse-Info, HR, the CAN charting module and office module Packages in SSIS 2012 to automate the process of capturing the changes made on application by using SCD and CDC tasks with Fuzzy Lookup and Data Conversion using for-loop, Sequence Containers.
• Reviewed & Tested packages, fixed bugs using SQL Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and DW of the EMR system.
• Responsible in enhancing the existing dashboards, creating reports using Tableau desktop and published that reports on to Tableau server.
• Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Identified new metrics and enhanced the existing KPI's. And used Custom SQL for complex data pulls, and replicated those Custom SQL query joins onto Tableau to connect to various data sources.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Combined views and reports into interactive dashboards in Tableau which are presented to End User.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau to find the various resident and pedestrian incident gap in EMR DW.
• Developed Tableau data visualization for resident performance using Cross tabs, Heat maps, Box and Discharge Summary using Whisker charts, Scatter Plots, Geographic Map, Pie, Bar and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip for gap analysis and utilized Tableau server to publish and share the reports with the business users.
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the incident reports.
• Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters.
• Handled Performance Tuning and Optimization on SSIS, MDX and Reports with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Environment: Tableau Desktop 8.x/9.x, Microsoft SQL Server, SSIS, SSRS, SSAS, and Import/Export tools, SQL Server Agent, MS Access.

Confidential, New York

Software Engineer - Tableau Developer

Responsibilities:

• Interacted with Strategic Development Team, Business analyst, Product Managers to analyze business needs and developed technical specifications.
• Attending Scrum meeting to provide the status, gathering requirements from customers.
• Understanding the functional and technical specification.
• Used Tableau to create key dashboards to help translate raw data into visualizations for stakeholders and clients.
• Created Tableau dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts, Heat maps using show me functionality.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Linking SQL SERVER database to Tableau server.
• Creating aggregation tables based on business requirement.
• Converted business requirements into dashboard views and designs.
• Designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
• Created actions, filters, parameters and calculations for preparing dashboards and worksheets in Tableau.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Designed Filters, quick filters, table calculations, calculated measures and parameters.

Environment: Tableau Desktop 7.0/8.x, Microsoft SQL Server.

Confidential

Business Analyst - Risk

Responsibilities:

• Transformed data from various data sources using Flat file, Excel, ADO .net and OLE DB connection by creating various SSIS Packages.
• Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Creating the Mappings using Data Flow Transformations such as the Sort, Derived Column, Conditional Split, SCD, Pivot and Lookup etc.
• Using Control Flow elements like Containers, Execute SQL Task, Execute Package Task, File System Task and Send Mail Task etc.
• Scheduling and Monitoring the ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating the Data flows and Control Flows
• To Develop Exception Handling process for each SSIS Package.
• Implemented Performance Tuning at various levels.
• Design and development of database scripts and procedures.
• Implemented check point configuration, package configuration in packages for better reusability.
• Created manual test cases for SSIS testing.
• Involved in UNIT testing.
• Compared RIS output data with FERMAT output data and compared dollar value columns, Number of columns, Compared data format of each column.
• Development of different types of SSRS reports like Drill down, sub report, link report, pivots, charts, tabular. Extract the data from SQL Server and applied Business Logic then load into the target tables.
• Avoid Blank pages when we export the report to PDF format by changing the properties of can grow to avoid report control to grow more than the define report layout, etc.

Environment: SQL SERVER 2008 R2, SSIS 2008 R2, SSRS 2008 R2, Main Frames, Access Database, PL/SQL Developer, Windows.

Confidential

Sr. Consultant - MIS

Responsibilities:

• Worked with business analysts to baseline the requirements.
• Understanding the process and data flow of existing DTS packages.
• Worked on creating the packages using various BIDS Control flow tasks and Containers.
• Worked on designing SSIS packages using various BIDS Data flow sources, Transformations and Destinations.
• Created dependency between Import and Aggregation process.
• Worked on creation of variables and Event handling.
• Created manual test cases and involved in execution of test cases for various testing phases like SIT and UAT for SSIS testing.
• Compared SSIS output data with DTS output data and compared dollar value columns, Number of columns, Compared data format of each column.
• Deployed packages and SQL objects like tables, stored procedures, Synonyms, Functions and Package related scripts in to Production environment.
• Created drill maps for end users to drill down and recover data.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Development of different types of SSRS reports like Drill down, sub report, link report, pivots, charts, tabular. Extract the data from SQL Server and applied Business Logic then load into the target tables.

Environment: SQL SERVER 2008 R2, SSIS 2008 R2,SSRS 2008 R2, Main Frames, MS-Access, Vb.net, C#.net, Excel VBA Macros, Windows.