SUMMARY:

• Over 8+ years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0, SAS, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies.
• Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1, 8.2 and 9.0 as a developer
• Extensive knowledge in creating wide number of Dashboards and worksheets in large BI environments using Tableau 9.0/8.1/8.0/7.0.
• Good hands on experience in handling Master tickets and resolving issues of users.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Good experience on Security measures that the cloud service provider (AWS) implements and operates.
• Experience in developing and implementing tableau changes such as upgrades and migration.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Reports development using various reporting tools like Tableau, SAS and SSRS.
• Experience with CISCO’s Composite Data Virtualization Platform.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations 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.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 9.0
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi- tier environment.
• Proficient in handling parameterized reports in SSRS.
• Good knowledge on scripting languages like python, bash and ruby.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Good ability to Provide 7/24 Production Support for Tableau
• Good ability to work independently and well in a team
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Created visualization for logistics calculation and department spend analysis.
• Developed Ad-hoc ETL, reports requirement runs.
• Expertise in gathering the requirements from the business users, coordinating the deliverables end to end with the technical team.

TECHNICAL SKILLS:

BI/ETL Tools: Tableau, SSIS (SQL server integration services), DTS & Data stage

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010, MS Share point & Team Forge

Operating Systems: Windows 8/7/XP/2003 & Unix

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services

Defect Management tool: HP ALM & Bugzilla

Languages : T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Office Tools: Microsoft Office 2003 / 2007 / 2010 / 2013

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Tableau Developer/Admin

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked directly with business customers to build reports, dashboards and ad-hoc reports.
• Good hands on experience on terra data DBA and modern data ware housing.
• Good experience on security measures that the cloud service provider (AWS) implements and operates.
• Good knowledge on security measures that the customer implements and operates, related to the security of customer content and applications that make use of AWS services.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Experience with CISCO’s Composite Data Virtualization Platform.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server.
• Good knowledge on scripting languages like python, bash and ruby.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Executed and tested required queries and reports before publishing dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Good ability to Provide 7/24 Production Support for Tableau
• Good ability to work independently and well in a team.

Environment: Tableau Desktop 8.2, Tableau Server, MS Office Suite, SOAP UI, Teradata, MS Excel.

Confidential, New Orleans, LA

Tableu Developer

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 in Tableau.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports thus making them user friendly.
• Developed innovative user interface solutions using Backbone.js, JavaScript, HTML5, and CSS3 for cloud-based healthcare platforms.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Collaborated with front-end and backbend developers using agile best practices and GIT to develop efficiently as an organization.
• Develop a scalable architecture for staging and loading data using Teradata database.
• Write Bteq and Molad scripts to load data from Oracle to Teradata.
• Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Extracted data from SAP source system using DB connect and flat files interface.
• Extracted data from SAP (FI & PCA extractions) and legacy systems (using DB connect). Involved in Generic Extraction of PCA data.
• Worked extensively to debug the existing SAP program and modify the code using modification assistant to customize the program as per requirements.
• Responsible for gathering the business requirements for the Initial PoCs to load the enterprise data warehouse data to Greenplum databases.
• Proficient in data integration between different sources to the EMC Greenplum and Netezza environment and reporting the same on Tableau environment.
• Involved in the creation of Greenplum functions and views for the customer use, both on the Hub level and the Spoke level.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on the requirements.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to the Tableau server.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Migrated Workbooks and Dashboards from Tableau 6 to Tableau 7.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users

Environment: Tableau 7.0/6.0, Tableau server, Oracle 11i, SAP BW/BI, Reporting Services (SSRS), Informatica 8.x, Teradata, SQL, TOAD, Windows 2003/XP, UNIX.

Confidential, Austin, TX

SQL Server Developer/SQL Server DBA

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.
• Involved in unit and integration testing. Creation of test plans and logging defects in HP Quality Center.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL (extract transform, load).
• Developed complex SQL queries, stored procedures, and DTS packages.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2005.

Environment: MS SQL Server 2000, Enterprise Manager, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote Ad-Hoc T-SQL queries for analysis purposes.
• Wrote database triggers in T-SQL to check the referential integrity of the database
• Created the MS-DTS packages for executing the required ETL tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spreadsheet-using DTS
• DTS Packages are created to export and import data from CSV files, text files and Excel files.
• Involved in creating maintenance plans in SQL Agent to back up the database.
• Worked with development teams in the design of physical databases and in modification.
• Generated Tabular reports, Cross Tabs, drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Managed Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated Sub-Reports, Drill Down-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager &Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time

Environment: SQL Server 2000/7.0, Windows 2000 Server, SQL Profiler, DTS, T-SQL, BCP, System monitor/Performance Monitor, Query Analyzer.

Confidential

ETL Developer/SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Designed and developed forms using Visual Basic with ODBC
• Designed and developed reports using Crystal Reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Involved in dimensional modeling to design data warehouse
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Used the calculated members in the fact tables to improve efficiency.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Created roles, assigned permissions and users/groups to roles to limit the access for the users.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Prepared functional specifications for user requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Involved in creation of schema objects, roles and privileges, users.
• Prepared User manual, Technical documents for the end user.
• Prepared executables for system deployment and led the release of applications following
• Experience in UNIX Environment in file transfers, job scheduling and error handling
• Maintenance and support for the system. Involved in end user training.

Environment: Oracle 9i, Windows 2000, PL/SQL, TOAD. Informatica Power Center 8.1, SQL Server 2000, Erwin 7.3, XML