SUMMARY

• Proven experience in IT industry wif 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.
• 10 years of working experience in MSBI (SSIS, SSRS and SSAS) and 4 years of working experience in Tableau Desktop and Server components and around 1 year of experience in Power BI.
• Involved in Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings, Create teh Task Board and Sprint Burn down Chart at teh start of every Sprint, attend all Scrum meetings and continually work wif teh Team and business to find and implement improvements.
• Involved in Data Modeling, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Involved teh Source - Target Mapping for teh Dimensions and Fact Tables.
• Worked wif Dimensional modeling, Data migration, Data cleansing, ETL Processes for teh data warehouse.
• Technical and analytical skill wif 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 teh data from various sources such as SQL Server, Mainframes, Text files, Excel files, .tab files, .dat files, Oracle, SharePoint, Access Database, DB2, AS400, Teradata, ODBC and flat file sources.
• Worked on Various SSIS components like Control Flow, Data Flow Transformations, Error Logging and Event Handlers.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Extensive noledge of Creating User defined Project Variables, Package Variables and using System Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Creating Package Configuration to change teh package properties dynamically in SSIS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive noledge of Creating User defined Project Variables, Package Variables and using System Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Creating Jobs, Alerts, and Scheduling SSIS packages by using SQL agent and Created Mailing concept using SMTP server.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies wif SSAS.
• Expertise in creating Cell Level Security, Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in creating various database objects in C#, Visual Studio and ASP.net and deploying them to teh SQL Server.
• Experience in creating Database objects like Tables, Views and creating constraints like Primary key, Foreign key, Check, default and Unique constraints.
• Writing complex queries using CTE (Common Table Expression) and recursive CTE.
• Excellent experience in creating Indexes, Indexed views, Column Store Index 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 using SQL Profiler, Index Tuning Wizard, Windows Performance monitor and optimizing teh queries.
• Reorganizing Index for fixing internal fragmentation and Rebuilding teh Index for fixing internal and external fragmentation, which will improve teh query performance.
• 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.
• Experience creating, populating and maintaining data marts. Thorough noledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Good experience in Users/User Groups, Security Filters, Security Roles and Project management in SQL SERVER/SSIS.
• Performed operations like Data reconciliation, Data Integrity, Data validation after extracting data into files, SQL Server and DWH.
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• 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.
• Develop canned / Ad-Hoc reports and complex dashboards in Tableau as needed.
• Ability to use custom SQL for complex data pulls.
• Experienced in working on Tableau (Desktop, Server), creating Dashboards and Reports using different functionalities.
• Expertise in Creating Schema Objects (attributes, facts, Hierarchies, Transformations), Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Drill Maps, Templates), designing & creating Report Service Documents.
• Create a wide variety of analysis including comparisons, Forecasting, trending and wat-if analysis. Proficient wif Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, etc.
• Experienced in creating Calculations (Table Calculations), Creating/Using Parameters and Passing values at runtime by using dynamic parameters and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding).
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and Creating Local and Global dynamic filters by using parameters and Creating Action filters according to teh end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in teh organization.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage and Backup and Cleaning.
• Experience in BI solutions using ASP.net, Performance Point and Dashboard concepts as required.
• Good experience in creating Data extracts and scheduling extracts refresh and publishing dash boards to Tableau server.

TECHNICAL SKILLS

BI Tools: MSBI (SSIS, SSRS, and SSAS) and Tableau Desktop 7.x, 8.x9. X, 10.x, Tableau Server, Power BI.

Databases: SQL Server, Access Database.

Query Tools: SQL Management Studio, SQL Data Tool, AccessTeradata 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, ASP.net, VB.Net, C AND C++.

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

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

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. BI Engineer & Tableau Developer & Admin

Responsibilities:

• Gather and analyzethe business requirements and thentranslate themto technical specifications.
• Involved in Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings, Create teh Task Board and Sprint Burn down Chart at teh start of every Sprint, attend all Scrum meetings and continually work wif teh Team and business to find and implement improvements.
• Designed and developed SSIS Packages to import and export data from Prod platform based on different source systems.
• Developed DPE (Data Process Engine) Packages for executing teh packages depending on Business day.
• Created dependency between Import to Aggregation and Aggregation to Extract packages.
• Developed scripts for validating teh 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 business logics using Derived column, Data conversion, Aggregation, Lookup, Script task transformations.
• Created Aggregation packages using execute SQL task to execute complex stored procedures and functions.
• Loaded data in to aggregation data base by using Aggregation process.
• Performed weekly batch loads (Full & Incremental) by building, deploying and executing of teh DBTable Details, Customer Air travel, Card transactions info and hotel transactions info packages in both teh Dev and Prod, troubleshooting process for issues and errors occurred using SSIS.
• Configured teh loading of OLTP data into Staging and ODS areas both checksum SCD method and CDC method to load teh (regular transactions of customers) into DW history tables.
• Performed unit testing, integration, user acceptance testing on teh loaded data into DR Platform and provided production support for teh Accounts and Cards packages deployed.
• Responsible in enhancing teh existing Reports and pdf’s, creating reports using Tableau desktop.
• Identified new metrics and enhanced teh 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.
• Worked on teh development of Dashboard reports for Key Performance Indicators (KPI) for teh top management.
• Created KPI’s for Domestic and International Air Spends.
• Created action filters, parameters and calculated fields, sets for preparing dashboards and worksheets in Tableau that allowed end users to understand teh data on teh fly wif teh usage of quick filters 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 using show me functionality.
• Rebuild existing Reports into Tableau Visualizations wif user and action filters.
• Reviewed teams work on Data modeling (Dimensional & Relational) wif Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle). 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 teh reports wif teh 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.
• Interact wif customers on a regular basis to resolve issues.
• Handled Performance Tuning and Optimization on SSIS packages.
• Improved Reports performance wif strong analytical and troubleshooting skills for quick issue resolving in large-scale production environments located globally.

Environment: MSBI 2014, SQL server, SSDT, SSIS, SSRS, SSAS, Import/Export tools, SQL Server Agent Tableau Desktop and server 10.x/9.x/8.x, MS Access, Visual studio, VB.net, C#, ASP.net, Report Builder, Power BI, Rest API

Confidential, New York

Sr. BI Engineer & Tableau Developer

Responsibilities:

• Created around 700 SSIS packages for Import, Aggregation and Extract process
• Developed DPE (Data Process Engine) Packages for executing teh packages depending on Business day.
• Created dependency between Import to Aggregation and Aggregation to Extract packages.
• Developed scripts for validating teh 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 teh 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.
• Lead multiple teams for new initiatives, enhancements and support of BI in Corporate Office of Technology.
• Interacted wif business stakeholders to understand their requirements, analyzing teh available data to build Tableau Dashboards.
• 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 teh 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 on AWS.
• Configuring me-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, troubleshooting issues related to reports, schedules and subscriptions.
• Automated teh process of taking server backup on daily basis.
• Implemented failover and High availability mechanism on Tableau server.

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:

• Attending Scrum meeting to provide teh status, gathering requirements from customers.
• Understanding teh functional and technical specification
• Created Tableau dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts, Heat maps using show me functionality.
• 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.
• Creating users, groups, projects, Data connections, settings as a tableau site administrator.

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

Confidential

Business Analyst - Tableau Developer

Responsibilities:

• Worked as Tableau developer/SME in standardizing Tableau for shared service deployment.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively worked on Dashboards and have utilized teh new features to convert teh dashboards into Flash mode.
• Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues

Environment: Tableau 7.0/8.0, MS SQL Server, Windows.

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 teh Mappings using Data Flow Transformations such as teh 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 teh ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating teh 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 wif 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 teh data from SQL Server and applied Business Logic then load into teh target tables.
• Avoid Blank pages when we export teh report to PDF format by changing teh properties of can grow to avoid report control to grow more TEMPthan teh define report layout, etc.

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