SUMMARY

• Over 7+ years of IT experience in the field of Business/Data analysis, ETL Development and Data Modeling.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Experience in SSIS, SSRS
• 4 years of extensive experience inTableau Desktop, Tableau Server, Tableau Admin, Tableau Online, Tableau reader in various versions of Tableau (8.x/9.x/10.x) and SQL.
• TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Experience in development of mappings using needed transformations using Pentaho Kettle tool.
• Worked on great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using T-SQL
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages
• Expertise in analysis, design and implementation of data warehousing applications using Teradata
• Excellent in High Level Design of ETL, SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Derived Columns, Audit, Lookup, Data Conversion, Character Map, Merge, and union all.
• End-to-end experience in designing and deploying data visualizations using Tableau
• Good Experience withTeradata and Semantic Views.
• Manage the online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turn around time. Complete large database cleanup projects to insure data integrity.
• Strong background in support documentation.
• Worked on SSRS (SQL Server Reporting Services) reports creation on ad-hoc requirements
• Proficient in data migration from sources like MS Access, SQL server, Text files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services(SSIS); and Data collation, data cleansing, Entity Relationship Design.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Hands on experience in creating SSIS packages with error handling, logging, package configurations and by implementing Break points and Check points as well.
• Analyzes company performance versus competitors and industry benchmarks
• Worked on CRM database to prepare firms legal directory submissions for relevant representative works

TECHNICAL SKILLS

DBW Tools: - Tableau Desktop 8.x/9.x/10,Tableau Server, Tableau Admin,Teradata, Report designer,Business Objects 4.0, 4.1, Crystal/Business Objects Reports, DataAnalysis, EnterpriseDataWarehouse, Database Design and Modeling,DataIntegration and Migration, Design,DataWarehouse, OLTP, OLAP Erwin 9.x, Rational Rose, ER/Studio, MS Visio, SAP Power designer, My SQL Server

ETL Tools: - Data Transformation Services (DTS), SQL Server Integration, Services (SSIS),Import Export Data, Bulk Insert

Other Reporting Tools: - SAP Business Explorer BEx Analyzer, BEx Query Designer, SAP LUMIRA

Environment: - Windows 2008,Windows 7, windows 2003, XP.

Database: - MS SQL Server, ORACLE, T-SQL, Teradata, MS Access

Language: - VB.NET, C .NET, HTML, SQL

PROFESSIONAL EXPERIENCE

Data Analyst/Tableau Developer

Confidential, Chicago IL

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Experience in standardizingTableaufor shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities inTableau.
• DeployedTableauServer in clustered environment by mapping server nodes to primary machine.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.
• Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA's withTableausupport.
• Defined and created procedures to installTableaudesktop in silent mode.
• Defined best practices forTableaureport development.
• Provided 24/7 production support forTableauusers.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Migrated Workbooks and Dashboards fromTableau7 toTableau8.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end user.

Environment: Predictive analysis, Tableau 10.1, Workday, Alteryx, SPSS, MS Excel, PowerPoint, and MS Outlook

Confidential - Novi MI

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies inTableau.
• Created and updated server architecture for scheduling tasks.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Building, publishing customized interactive report sand dashboards, report scheduling usingTableau server.
• Creating users, groups, projects, Data connections, settings astableauadministrator.
• Developed Dashboards using OLAP cubes.
• Ad-hoc ETL, Reports requirement runs.
• Use of Java script for creating the client side validations in the webpages with dashboards.
• Use of Java script for embedding the dashboards on the webpages.
• Involve creating dashboard sand reports in Tableau9.3andMaintainingserveractivities, user activity, and customized views on Server Analysis.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards usingTableauDashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.

Environment: Tableau 9.0,SSIS 2012, Windows XP, Microsoft Project 2000,HTML, Teradata, Oracle MS Excel, PowerPoint, MS Visio and MS Outlook

Confidential -Topeka, KS

Data Analyst

Responsibilities:

• Gathered requirements, analyzed, and wrote the design documents.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Implemented discretization and binning, data wrangling: cleaning, transforming, merging and reshaping data frames
• Determined optimal business logic implementations, applying best design patterns
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Created and updated server architecture for scheduling tasks.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Utilized data blending activities for Tableau functionalities.
• Responsible for creating datasets using T-SQL and stored procedures
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Responsible for making the report available for scheduling or viewing on demand.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Effectively used data blending feature in Tableau.

Environment: Tableau 9.0, Tableauserver/Administrator,MS SQL Server 2012,SSIS 2012, SSRS 2012, Windows XP, Microsoft Project 2000,HTML,, Python, MS Excel, PowerPoint, MS Visio and MS Outlook, windows 7

Confidential, Seattle, WA

Syste Analyst

Responsibilities:

• Migrated the server from a VM to Physical server to improve the performance.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• 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 reports and dashboard using KPI's.
• Enabled SSO to SAP HANA data source fromTableauenvironments.
• Experienced in writing scripts to remove inactive users on the server.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies inTableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Connected toTableauPostgre SQL database to create customized interface forTableauworkbooks to provide native intranet style.
• Created scripts to send automated alerts when ever restore or backup fails.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
• Coordinated database middleware issues with DBA's, query performance with System Architects
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level. Defined best practices forTableaureport development.
• Extensively used Tabadminand Tab cmd commands in creating backups and restoring backups ofTableaurepository.
• Provided 24/7 production support forTableauusers.

Environment: Tableau 9.x,10.x,SQL Server 2008R2, T-SQL, Visual, Studio 2010, Python, MS Office 2007, Talend Microsoft Share point server, Cloud.

Confidential, Atlanta, GA

Tableau/Data Analyst

Responsibilities:

• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Wrote regression test cases, did smoke testing with users.
• Good Experience in creating cubes by using Pentaho Schema Workbench.Installation and setup complete BI suite as per the clients requirements.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Debugging the failure issues by capturing the array and register dumps usingPythonscripts, traces and performing several experiments by interacting with the design team
• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Enhance the embed code that Tableau provides, and build own code. Either way you can use parameters that control the toolbar, tabs, and more.
• Resolved the data blending issues based on data from multiple sources
• Developed various tableau BI charts on assortment planning and reporting
• Created parameters, calculated fields, various filters and groups to facilitate different views on dashboards.
• Developed sales reports from Teradata on store wise performance and filtering them on top sales
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.
• Help users withChatterteams/Groups and follow application as well.

Environment: Tableau (Desktop/Server), windows 7,SSIS, SSRS,MS SQL SERVER, MS Access 2010,Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential- Hanover, MD

Data\Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ datamarts.
• Refreshed the Tableau Extract in production server using scheduler.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, Lookups and Quick Table calculations.
• Created Actions in Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
• Involved in administrating Tableau server and creating tabadmin scripts for automating backup procedures through windows scheduler.
• Worked in user management, group management and permission management for accessing dashboards based on security requirement.
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Provided 24/7 customer support totableauusers.Understand the business requirements for report development on exceptions and financial reports
• Developed and deployed merchant friendly UI to generate assortment exception reports
• Created modules and pass through queries to access the DB2 environment source data
• Optimized the performance of the queries by passing the parameters based on the merchants selection from the UI
• Developed financial reports in tableau for understanding the assortment based on performance
• Used Tableau Desktop for blending databases and create interactive views and dashboards

Environment: Tableau(Desktop/Server) 8.1.2/8.0.1 , Oracle,Teradata,MSSQL Server, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, CA Service Desk, Microsoft (Word, Access, Excel, Outlook), Adobe Marketing Cloud

Confidential, Mount Laurel NJ

BI Analyst\Data Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure and to maintain data efficiently.
• Worked with source system teams to understand source data and complete source data profiling.
• Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same.
• Designed database tables to feed Promotions, Campaigns, Customer, Sales data for effective targeting and direct marketing campaigns.
• Extensively worked on Pre-Campaign and Post-Campaign data analysis.
• Involved in testing, fixing the bugs and troubleshooting the technical problems.
• Created the templates for test plan, test cases, process flow diagrams etc.
• Involved in Performance Tuning of Parallel Jobs by analyzing the performance of the jobs and project and enhance the performance using the standard techniques.
• Experience in co-coordinating offshore team with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.

Environment: Tableau (Desktop/Server),SAS, Oracle, Teradata, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, UNIX, MS SQL Server, ERWin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Schaumburg, IL

Data Analyst / Business System Analyst

Responsibilities:

• Design and build ETL, Data Marts and Reporting systems.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Troubleshoot system issues, performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for performance purpose.
• Maintain the upgrade of the ETL system for marketing and sales lead scoring system that allows for easy and consistent data transfers and integration.
• Expert in Bash scripting.
• Expert in designing and deploying data visualizations using Tableau
• Contribute to the upgrade of Oracle 9 and older SQL Server systems to SQL Server 2012
• Created Packages and jobs to import the data on daily basis from Flat file to SQL server.
• Actively involved in Normalization of database and assisted clients with physical database modeling, data archiving strategies and disaster recovery planning.
• Worked on MVC reporting and javascripts
• Reacting and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively participated in gathering Business Requirements and System Specification from users.
• Created complex stored procedures and functions to support efficient data storage, purging and manipulation.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Importing and Exporting of the data using DTS routines that extract, transform, and load data from heterogeneous sources.
• Worked in My SQL

Environment: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Developer

Responsibilities:

• Worked as developer of a team, responsible for the design and development of an ORACLE application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with the project manager to understand the scope of each phase & module and further understand & implement the Object Model & Database design specifications, Domain Model.
• Framing the business logic plus code for accessing data stores.
• Develop validation routines for complex business rules and data handling.
• Created numerous forms and reports using Forms and Oracle Reports.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Used SQL*Loader to load data into Oracle database.
• Troubleshoot performance issues and bugs within packages.

Environment: Oracle, SQL*Plus SQL, SQL* Loader, PL/SQL