PROFESSIONAL SUMMARY:

• Around 8 years of experience in Analysis, design, development administration, and Implementation of Business Intelligence solutions and Data visualization .
• Expertise in Extraction and Transformation (ETL) of data sourced from flat files, excel, xml, Oracle DB and SQL Servers.
• Extensive Tableau experience in enterprise environment. Worked with various Tableau versions such as 7.x, 8.x, 9.x, 10.x as a developer both on Tableau Desktop and published on the Server.
• Experience in creating year over year, quarter over quarter , YTD, QTD and MTD dashboards in no time.
• Created Dashboards using Tableau for various stakeholders such as Analysts, Managers and Chief executives depending on the requirement and provided restricted access depending on the role.
• Experience creating customized reports using various chart types like , Text Tables, Bar Charts, Pie Charts, Tree Maps, Heat Maps, Line Charts, Pivot Tables, Combination Charts using Tableau for various BI projects .
• Designed and developed complex Parameters - based Calculations, Aggregate Functions , Filters , Relationships to visualize the KPI’s in the most efficient and appealing way.
• Experience using tools in SQL Server Management Studio such as SSIS and SSRS .
• Developed dashboards that tell a story and solution driven which allowed end users to understand the behaviour of the data.
• Expertise in OLTP/OLAP System Study , Analysis, developing Database Schemas like Star Schema & Snowflake Schema used in Relational, Dimensional and Multidimensional modeling.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Functions, Views, Indexes, Relational data models and and also involved in maintaining Data Integrity in various tables using SQL joins and writing Sub Queries .
• Proficiency in interpreting data from data sources, primary and secondary using Statistical Techniques to generate reports that maintain compliance with industry standards.
• Strong knowledge of statistical methods ( Linear Regression, Time Series Analysis, Hypothesis Testing, Randomized Experiment , Confidence Intervals, 2 Sample Testing).
• Performed Data Integrity checks , Data cleaning , Exploratory analysis and feature engineer using R and Python .
• Expertise in all aspects of Software Development Life Cycle ( SDLC ) from requirement analysis, Design, Development Coding, Testing, Implementation and Maintenance including agile and waterfall models.
• Experience in preparing Test plans, Test Data and executions of Test Cases to ensure applications functionality meet the user requirements.
• Knowledge of Big Data, Hadoop, Spark, Apache, HDFS .
• A quick learner and enthusiast to learn new technologies.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2007/2010/Vista

RDBM/Databases: MS SQL Server 2008/2012/2014/2016 , MS Access 2010, MySQL

T: SQL, Dynamic SQL, DOS Scripting

Data Modeling/Analysis: Tableau, Power BI, R,SAS, Python, MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access

Data Design Tools: MS Visio, Smart Draw

BI Tools: SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), BIDS

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS)

Application Packages: MS Office, Microsoft SharePoint Server

WORK EXPERIENCE:

Confidential, RockLiegh, New Jersey

Sr. Tableau/BI Developer

Responsibilities:

• Responsible for developing, analyzing and reporting Key Risk Indicators and Key Performance Indicator metrics that enable management to make timely and effective decisions related to Threats, Risks and Control requirements .
• Created Tableau Scorecards, Dashboards using Stack Bars, Bar Graphs, Scattered Plots, Geographical Maps, Heat Maps, Bullet Charts, Gantt Charts demonstrating key information for decision making.
• Designing the Reports as per client requirement and created the reports using Excel file, SQL Server and Oracle databases.
• Developed Business Process and Technical Design Documentation for each reporting service developed in the projects I was involved.
• Developed and produced peer quality metric performance validated data and processes to ensure accuracy, completeness, and consistency of data using SAS .
• Involved in extraction, transformation and loading( ETL ) of data directly from different source systems like Flat files, Excel, Oracle and SQL Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes, Groups, Sets, Hierarchies to create detail level summary reports and dashboards for KPI's .
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked on Motion Chart, Bubble Chart, Drill Down Analysis using Tableau desktop .
• Interacted on a day to day basis with several different groups in order to achieve a common deliverable.
• Created complex reports like Detail Level Transaction report's , Monthly Aging , YTD cash goal Reports , Quarterly reports by creating multiple queries.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
• Involved in resolving reporting issues and design issues throughout the reporting life cycle.
• Strong ability in developing SQL queries to extract, manipulate , and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Ensured all project requirements and objectives are properly documented and pursued.
• Created conditional filters to filter the data on dashboard.
• Written complex SQL queries and optimized queries for performance tuning .
• Participated in meetings, Reviews, and user Group Discussions as well as communicating with Stakeholders and business groups.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Microsoft SQL Server 2012, MS Excel, MS Access, Windows 2007 server

Confidential, Nashville, Tennessee

Sr. Tableau Developer

Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable vision.
• Involved with the Business users along with the administration and management to gather the report business requirements, report types and report formats.
• Performed Data wrangling and cleaning using Python Pandas before loading the data into Tableau Desktop.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Contributed to team's growing set of development platforms, tools, and processes especially within the area of Business Intelligence for future projects.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Interacted with Data Modelers on regular basis for creating the Logical Data Model(LDM) and Physical Data Model (PDM)
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Using Micro Strategy Desktop created Application Objects like Template, Filters, Prompts, and Reports according to the Business requirement.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 9.0/8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, Milpitas, CA

BI/Tableau Developer

Responsibilities:

• Created visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Created KPI’s across channel presence, digital media reach and engagement into a single Digital IQ score card. Evaluated the score for each member, zone, and region and nationally to gauge system performance using the Tableau.
• Created series of signboard and dashboard reports, built for a new process being built in Horizon.
• Created & maintained data sources in Cognos connection and used Framework manager's best practices to create models, publish packages, designed several reports using Cognos Report Studio on EDW environment.
• Created complex data Views manually for multiple KPI’s to visualize in Tableau.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Optimized SQL scripts to improve the efficiency on the database and was involved in the performance tuning for tableau Dashboards.
• Define / Develop SQL queries, Stored Procedures, and data mining as necessary in collaboration with the Database developer and BI Team as needed.
• Developed transformation logic and designed various Complex Mappings using the Designer.

Environment: Tableau Desktop 8.X, 7.X, Tableau server / Administrator, SQL, Unix Shell Scripting, Windows/UNIX, Oracle, Cognos.8.X

Confidential, Plainville, CT

BI Developer

Responsibilities:

• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Developed Custom SQL scripts to view required Claim data in developed dashboards.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Extensively used analytical features in Tableau like Statistical Functions and Calculations, Trend Lines, Forecasting etc. in many Tableau reports.
• Utilized SAS , to provide ad-hoc reporting , tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications.
• Used Principal Component Analysis and Factor Analysis in feature engineering to analyze high dimensional data in Python .
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Making a Report as per user requirement using MS Reporting Services 2005/2008 and send the reports directly to the respective E-mails using Subscriptions.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Created execution plan for better tuning of the database using optimized queries.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 8.x, Tableau Desktop 8.x, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008,, Oracle 11g, Toad, MS Office, Team Foundation, SharePoint

Confidential, Atlanta, GA

BI Developer

Responsibilities:

• Worked extensively on Tableau Desktop, Oracle and MSBI Tools (SSRS, SSAS, SSIS) mainly for creating reports and dashboards.
• Pulled data from different databases and integrated into a central source using SSIS to get all the needs of the customers in various fields so we can do a better analysis and tweak our suggestions to different customers.
• Analyzed sales data using SSAS and gave detailed reports of the best products which can suggested to specific set of customers.
• Created many complex dashboards by extracting data from many different sources using data blending and joining multiple tables in case of merging data from different sources using Tableau and SSRS for a different set of teams.
• Involved in creating database objects like Tables, Views, Procedures, Triggers and Functions using T-SQL to provide definition, structure and to maintain data efficiency.
• Interacted with the existing database developers and DBA to understand the existing schema .
• Automated monthly excel reports into Tableau workbooks and dashboards .
• Consolidated multiple Tableau workbooks into a single workbook for the company sales division for a better understanding of data at glance.
• Hands-on development in assisting users creating and modifying worksheets and data visualization dashboards.
• Documented the entire process of working with Tableau desktop and in evaluating business requirements.
• Created and modified data as per their requirements in the Oracle Database and involved in testing these databases using complex scripts.

Environment: Tableau Desktop, MSBI Tools (SSRS, SSAS, SSIS), Microsoft Office, Oracle, SQL, Microsoft SQL server Management studio.

Confidential

MS SQL Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
• Created Tables, Indexes and Constraints and Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Defined stored procedures for module integrity and application.
• Written Procedures/Stored Procedures/Functions/Triggers in T-SQL for various applications which sits on top of the database.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Used SQL Server Profiler to trace the slow running queries.
• Analyzed and debugged jobs and procedures.
• Performed Backup operations.

Environment: MS SQL Server 2008, T-SQL, MS Excel, SQL, T-SQL, SQL Query Analyzer, Profiler.