SUMMARY

• 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms
• Over 3 years of experience inDataModeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and LogicalDataModeling
• Proficient in design and development of various dashboards, reports utilizingTableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) usingTableauDesktop.
• Created Rich dashboards usingTableauDashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experience in configuring reports from different data sources using data blending
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Strong experience in writing SQL Queries, Views, Materialized Views, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions. PL/SQL tables in 11g, 10g, and 9i.
• Experience in Deploying Forms and Reports on the web.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Business andDataAnalysis,DataProfiling,DataMigration,DataIntegration, Datagovernance and Metadata Management, MasterDataManagement and Configuration Management experience.
• Experience in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• End to end experience in designing and deploying data visualizations using Tableau9.3.
• Deployed the reports and Scheduled Reports for the use of end users.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables, UML.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Experience in performing System, Functionality, User Acceptance, Integration testing.
• Excellent Interpersonal communication, Documentation skills and experience coordinating with project managers, business Analyst, Architects, DBAs and Developers.

TECHNICAL SKILLS

Databases Tools: SQLEnterprise Manager, Query Analyzer,SQLServer Management Studio, Business Intelligence Development Studio.

Data Visualization tools: Tableau 9.3, Informatica, and Crystal Reporting.

Reporting Tools: SQLServer Reporting Services, Business Objects.

Database: MSSQLServer, MS Access, Oracle, MySQL

Programming: T-SQL, PL-SQL, C, (Shell Scripting)

Web Technologies: HTML, XML

Operating Systems: Windows, UNIX, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Access), ERWIN, Project

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Tableau Developer

Responsibilities:

• Responsible for conducting needs and impact analysis on business data requests, and defining ways to link data, processes, and systems throughout the organization to achieve optimal efficiency and align information technology with business initiatives.
• Creating and modifying Business Intelligence analytical reports/ dashboards usingTableau Desktop.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards usingTableau9.3 using the drill down, drill across, actions for business steering committee.
• Created Complex dashboards intableauusing the various sources of data from Excel sheets, SQL Server, Oracle databases.
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used advance chart visualizations inTableaulike Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primarykey's from each database for data validation.
• UtilizedTableauvisual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Worked on SQL Tuning and Optimization of the reports.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Created Unit Test Cases and documented the Unit Test Results.

Environment: Tableau 9.3, Qlikview 7, DB2, oracle, MS Excel, Crystal Reporting, Agile methodology.

Confidential, McLean, VA

Tableau Developer

Responsibilities:

• Responsible for conducting needs and impact analysis on business data requests, and defining ways to link data, processes, and systems throughout the organization to achieve optimal efficiency and align information technology with business initiatives.
• Worked with ETL team (DWH) to extract data intoTableauusing custom SQL to filter data source.
• Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies inTableau.
• Designed and deployed interactive reports with Drill Downs, drop down menu option, Parameters and Linked reports usingTableau.
• Built reporting against Single, Multiple Tables, Views, Materialized Views and Complex Custom SQL.
• Build and publishTableaureports utilizing complex calculated fields, table calculations, filters, parameters.
• Scheduled data refresh onTableauServer for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Develop parameter and dimension based reports, drill-down reports, charts, and Tabular reports usingTableauDesktop.
• Worked closely with network team to build dashboards about the outages and network loss in each and every region around the globe.
• Worked as an Administrator to manage user, user groups, and scheduled instances for reports in Tableau.
• Migrated all dashboards fromTableau8.1 to 9.3.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• PerformedTableauAdmin related activities likeTableauServer installation, backup, upgrades and performance tuning.
• Created users, groups, security roles and SSL authentications.
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production.

Environment: Tableau (Desktop), Crystal Reporting, SQL Server Management Studio Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook)

Confidential, Washington DC

Tableau Developer

Responsibilities:

• Worked with Global Operations, Technology and Data Metrics and Analysis teams to analyze, define and publish firm-wide performance and risk metrics to enable managers to make informed decision
• Handled Tableau admin activities like granting access, managing extracts, patches, upgrades and installations.
• Worked extensively in creating dashboards usingTableauthat includes tools likeTableauDesktop TableauServer andTableauReader in various versions ofTableau7 and 8.1. Also involved in the administration ofTableauserver like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementingTableauBI tool in all IT projects.
• Generated reports using SQL queries inTableau7.x/8.x and published them to users in online thru Tableauserver.
• Involved in generating Daily/Weekly Sales & Finance trending reports usingTableauby identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
• Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
• Generated Tableau dashboards with combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields within Tableau reports to facilitate automated data visualizations.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Involved in requirement gathering, reviewing requirements and data sources for design, development, and testing and production rollover of reporting and data visualization projects using Tableau
• Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote the usage of Tableau.

Environment: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, Tableau Reader 7.x/8.x, SQL Server 2005/2008/2012 , Designer, BI, Dashboard/ Crystal Reports 2008/2011, SQL.

Confidential

Tableau Developer

Responsibilities:

• Involved in the full life cycle of this enhancement (Analysis, Development, Implementation and Testing).
• Unit, System, and Integration testing of the procedures.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like flat files, to SQL Server database using SSIS package.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for Data warehousing and also scheduling the SSIS packages and Jobs.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performance tuning and optimization of procedures and queries.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Environment: MS SQL Server 2008, SQL Server Management Studio (SSMS), T-SQL, Microsoft Excel.