SUMMARY

• Overall 7 years of experience in Business Intelligence and Data Warehouse technologies. This includes 3 years of experience in data visualization using Tableau (version 8 and version 9) and 4 years of solid experience in performing ETL tasks (using SSIS) and Reporting (using SSRS).
• Strong background in writing SQL queries.
• Experience in software, healthcare, finance and biotech domain.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Proficient in design and development of various dashboards, reports utilizingTableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizationetc. making use of actions and filters according to the end user requirement.
• Experience in designing stunning visualizations usingtableausoftware and publishing and presenting dashboards on web and mobile platforms that are self intuitive with highly interactive graphic user interface that enable users to visualize data easily.
• Have been working with various data sources such asOracle, SQL Server and Flat File sources.
• Created incremental refreshes to pull the records from data sources to Tableau Extracts.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableauServer.
• Experience inInstallation, Configuration and AdministrationofTableauServer in amulti-serverandmulti-tierenvironment.
• Expertise in writing SQL Queries, dynamic-queries, sub-queries and complex Joins for generating complex Stored Procedures, Triggers and User-defined Functions. Developed queryfor generating drill down reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and parameterized and linked reports.
• Develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS 2005 & 2008). Used SSRS to generate all daily, weekly, monthly and quarterly reports.
• Designed SSIS packages to extract data from different sources like flat Files, Excel Files, SQL Server; transform them and then load into Dimension and Fact tables in the Data Warehouse using SSIS.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Strong analytical, logical, communication and problem solving skills and abilityto quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence,Data Collection.BI Tools Tableau(version 8 & 9), SSRS, SSIS, SQL Server Management Studio.

Relational Database: MS SQL Server, Oracle.

Languages: T-SQL, PL/SQL, Python.

Operating Systems: Windows 2000/2003/2008 Server, Windows 95/98/2000/XP/7.

PROFESSIONAL EXPERIENCE

Confidential, San Rafael, CA

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/ MS SQL Server for design, development, testing and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current services by color that was broken into regions allowing business user to understand in more efficient way.
• Projected and forecastedfuture growth by developing Area Maps to show details at the county level.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary keyfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to business users, program managers, and end users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased 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.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop version 9,TableauServer,MS Office Suite, MS Excel, SQL Server

Confidential, Thousand Oaks, CA

Tableau Developer

Responsibilities:

• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are showing most profit.
• Created Bar Charts which were complied with data sets and added trend lines and forecasting on future.
• Created crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states with most vs. least profit values.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly basis, scheduled refresh of data based on business or system changes to ensure that the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop version 8, Tableau Server, Oracle SQL Server, MS Excel, CSV.

Confidential, Schaumburg, IL

Tableau Developer / Sr. Data Analyst

Responsibilities:

• Identification and gathering of the user requirements and business requirements from different groups, end users for developing reports.
• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements.
• Participated in the business and specifications requirements gathering sessions and convert it into design specifications.
• Performed analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Conducted quality control checks for accuracy of reports generated
• Analyzed the future trends and provide business ideas to manage wealth, investments.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, funnel charts etc., to assist business users in solving complex problems.
• Extensively used of filters and parameters using URL to navigate to website.
• Performed yearly analysis and business risks using different line charts.
• Generated interactive Tableau dashboards for sales with forecast and reference lines.
• Extensively used SQL queries for loading data and creating data extracts
• Designed Ad-Hoc reports across various verticals as per the Business Users requirements.
• Analyzed the customer retention details based on regions and market segments using bar charts and tree maps.
• Handled Tableau admin activities granting access, managing extracts and installations.
• Extensively performed data blending, Custom SQL, deployed features such as Interactivity, Navigation, Images and Parameters in this process.
• Performed Data Mapping between the data sources.
• Used Custom SQL, Aggregate and Analytical functions to extract the required data for reports and dashboard development.
• Integrated tableau reports with web application and viewing reports online.
• Created ad-hoc SQL queries for end user reports, executive management reports.

Environment: Tableau Desktop, Tableau Server, Oracle, SQL Server, SQL, PL/SQL, Microsoft Office Suite (Word, Excel, Power Point).

Confidential, Greenwood Village, CO

Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Demonstrated knowledge in dealing with various functionalities like global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Prepared dashboards using calculations, parameters in Tableau, prepared Ad-Hoc reports.
• Interacted professionally with a diverse group, including executives, managers, and LOB.
• Worked on generating various dashboards in Tableau Server using various sources such as Teradata, Extract files.
• Developed, organized, managed and maintained document templates that will allow for efficient creation of reports.
• Proofread all documents and maintained accuracy of information and preparing SOP.
• Performed unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.

Environment: Tableau Desktop 7.0, Tableauserver / Administrator, SQL Server, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007

Confidential, NYC, NY

MS SQL/ETLDeveloper/SSIS/SSRS

Responsibilities:

• Designed SSIS packages to extract data from different sources like flat Files, Excel Files, SQL Server; transform them and then load into Dimension and Fact tables in the Data Warehouse using SSIS.
• Developed SSIS packages to process all Excel files within folder, File System Task to move file into Archive after processing.
• Execute SQL task to insert the transaction log data into the SQL table.
• Gathered report requirements and determined the best solution to provide the results in a Reporting Services.
• Produced operational reports in SSRS i.e. drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS from the relational database.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Generated monthly and quarterly reports for the management by making use of different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Responded to Ad-Hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Environment: Microsoft SQL Server 2008 Enterprise Edition, Windows 2003 Server, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL.

Confidential, Rockville, MD

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Designed ETL packages dealing with different data sources such as SQL server, CSV and Flat Files.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Followed and maintained standards and best practices in database development.
• Defined and designed the data sourcing and data flows.
• Identified the data source and defined them to build the data source views.
• Wrote complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Developed Stored Procedures to transform the data from Enterprise Data Warehouse (EDW) to SQL Server and load data to Fact Tables.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS and then created reports using this data using SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server, SSRS, SSIS, MS Access 2000, T-SQL, MS-Excel, MS-Access, SQL Server Management Studio.