PROFESSIONAL SUMMARY:

• Senior Tableau/BI developer with 7 years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Reporting using Tableau v9.x/8.x/7.x, Oracle and SQL Servers.
• 4+ years of experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and dashboards using Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Strong hands - on knowledge onTableauDesktopandTableauServer.
• Extensive experience in Installation, configuration, upgrade and administration ofTableauDesktop/Server.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
• Experience in developing multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, Dual-axes charts, Geo-Maps, Bubble, Histograms and Heat Maps.
• Highly skilled inTableauDesktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• ImplementedTableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert intableauserver commands like synchronization, Tabcmd andTableauserver backup activity.
• Experience inTABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and drivers setup activities.
• Hands-on experience in Trouble Shooting, Performance tuning of reports and resolving issueswith in TableauServer and Reports.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements usingXSL, HTML, andDHTML.
• Strong experience in using Java Script API withinTableau.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in creating Jobs, Alerts and setting up SQL server mail agent for SSIS packages.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Extensive experience in working with Relational databases such as MS SQL Server 2012/2008R2/2008, Oracle 11g/10g/9i, DB2 and MS Access.
• Experience in performance tuning SQL queries in TOAD.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

TECHNICAL SKILLS:

Data Modeling Tools: CA ERwin, Oracle SQL Developer Data Modeler, TOAD, DBSchema

Data Warehousing ETL Tools: Informatica Power Center 8.x, 7.x, SAP Data Services

Databases: Oracle 11g/10g/9i, SQL Server 2012/2010/2008/2005

Database Tools: TOAD, SQL Developer, SQL Plus

Reporting Tools: Tableau 9x/8x/7x, SAS, OBIEE 10.1.3x/11g, Active Reports 5, 6, 7, SAP BOE 3.5/4.0, Crystal reports

Languages: PL/SQL, Delphi, Java, HTML 5, Java Script, ASP.Net, VB.Net

Web Tools: HTML, DHTML, XML

Operating Systems: UNIX, Linux, Microsoft 10/8/7/Vista/XP/2000/98

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Tableau Developer

Responsibilities:

• Involved in creating dashboards and Workbooks inTableau. The dashboards display key metrics such as Flights on Time per region, Average Load by month, Fleet Utilization, and Costs by month.
• Created Executive dashboard dat show Top 10 and Worst 10 Air routes along with Flight, Customer and Financial Figures.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Extensively usedTableauActions-Filters and URL to navigate from Summary to Detail Workbooks and passed the selected parameters and Quick filters values in the URLs.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support forTableaudeveloped objects and understand tool administration.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement inTableau.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Environment: TableauDesktop 8/9,TableauServer 8/9,Tableau Public, Oracle 11g,Microsoft SQL Server 2012, Microsoft Visio, Windows 7/8/10.

Confidential, Jersey City, NJ

Tableau Developer

Responsibilities:

• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing toTableauserver.
• Extensively used TABADMIN and TABCMD commands in creating backups and restoring backups of Tableau repository.
• Conducting performance tuning, applying user and data source level securities upon need.
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableauas needed.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8.3 desktop/Server.
• Created schedules, Tasks, Groups, Users, Permissions and Subscriptions onTableau server.
• Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in creating various views inTableauby different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.

Environments:TableauDesktop 8x,TableauServer 8x,Tableau Public, Oracle11g/10g, SQL Server 2008R2, MS Excel.

Confidential, Mount Laurel, NJ

Tableau Developer

Responsibilities:

• Developed dashboard design and layout as it pertains to business flow, performance, and functionality
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Scheduled data refresh on Tableau Server on daily, weekly and monthly basis to ensure dat the views and dashboards were showing up updated data.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Administered user, user groups, and scheduled instances for reports inTableau. Installed patches on server and documented upgrade plan formTableau8.0 toTableau8.1.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports inTableau.
• Using advanced date calculations, aggregate calculations, user-calculations, table-calculations, logical-calculations, string-calculations, type-conversion and number calculations.
• Using the date month, logic statements and using several Calculation Types like Type Conversions and Date Calculations, Quick Table Calculations.

Environment: SQL Server 2012, Oracle 11g, Tableau Desktop 8, Tableau Server 8, Tableau Public, Windows 7/8.

Confidential

SQL/Tableau Developer

Responsibilities:

• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Involved with SSIS for sending and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Created database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Migration of DTS to SQL Server Integration Service (SSIS) and Designing/ Implementing Backup policies for databases.
• Created various DDL/DML triggers in SQL Server 2005/2008.
• Creating, maintaining the users, roles and granting privileges and Rebuilding indexes on various tables.
• Wrote SQL stored procedures to implement business logic and Optimized the performance of queries with modifications in SQL queries.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance. dis report gives a detail report to the management on the Performance of the server.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Performed Database testing, maintaining the data and writing the procedures.
• Fine tuning the Database Settings as well as the Server Settings.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Cross Tab reports.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: SQL Server 2005/2008, SSAS, SSIS, SSRS, InfoPath, Access, IIS 6.0, XML, MS Visual Studio 2008, ASP.Net, VB.Net.

Confidential, Milwaukee, WI

SQL/BI Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.
• Involved in Partitioning tables dat have bulk inserts, deletes and updates to improve the performance.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy dat protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008, CA Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.

Confidential

Sr. SQL Developer

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers. Installed and configuredSQLServer 2005 on the server and client machines, provide connections and manage databases.
• Created and maintained various databases for Production, Development Servers using MSSQL Server 2005
• Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
• Createdpackages, procedures, functions, triggers and alerts, scripts for automation and DTS packages for ETL.
• Monitoring of alert log files, control files, archive log destinations, blocking, deadlock issues and long running complex queries/stored process.
• Designed new job process, new database maintenance plans, DTS packages.
• Developed sample Reports for the users.
• Modified raw data and added links between tables and also created derived tables using SAP Data Services 3.5.
• Created Dashboards and also created parameters for those dashboards for large data using SAP BOE 3.5.
• Created test cases for both Oracle and SQL servers. And also conducted Quality Analysis for those test cases.
• Conducted Performance testing on millions of records to support the customer’s requirement.
• Installed Server and Client at the User end and also made modifications to the database and Server according to their requirements.
• Awarded Team Star Award for our work for completion of near impossible project in the specified dead line.

Environment: Excel, Access, Microsoft SQLServer 2005, Oracle 10g/9i, SAP BOE 3.5, SAP Business Objects Data Services 3.5, Crystal Reports.

Confidential

SQL Developer

Responsibilities:

• Created some new modules in Inpursuit application.
• Created reports on specific modules on Active reports 5.0.
• Developed report parameter sheets with parameters and linked those report parameter sheets to the reports.
• Fixed bugs on some modules, report parameter sheets and also on reports.
• Done research work on Spell checker tool and coordinated with Spell checker team to integrate it with Inpursuit.
• Explored the tools and listed all the tools with their features in an excel sheet. Helped the team to purchase DBSchema tool for Entity Relationship Diagram (ER-Diagram) to present the tables and links to the customers for their understanding.
• Installed the old versions of Inpursuit on VM’s for maintenance on old versions.
• Designed Login page for the users with all company standards using ASP.net and VB.net.
• Developed Test Scripts and conducted Quality Analysis testing along Testing Team.
• Awarded Pat-on-back award for my work on a critical report before the Inpursuit release.

Environment: Crystal reports, Active Reports 5, ASP.net, VB.net, Delphi 2005/2006, Borland 7/8 and Oracle 9i, CA Erwin.