SUMMARY

• 9 Years Implementing both (IT and Non - IT Projects) - In Business Intelligence, MDM, PMO, Governance, RPA, Revenue Management, Supply Chain, Procurement Vendor Management, Operations and HR
• 5 Years of Successful experience Managing (Big Data Warehouse Analytics) in RPA WinAutomation & Kapow/Kofax, Automation Anywhere MS Power BI Desktop; Tableau v.8.3/9.0, SAP BO Webi; Oracle SQL DB
• Managed Agile Programs / Scrum Projects from ($50 k - $150 million +), Small, Medium, & Large, teams - (5 - 170)
• Expert Life Cycle knowledge: BI, Agile, Waterfall, Kan Ban, Lean Six Sigma, Iterative, and other hybrid PMO methodologies
• Industry Experiences: Investment Banking, Pharmaceutical/Healthcare, Insurance, Social Media and Beverages

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Tableau Developer

Responsibilities:

• Extracting data from different sources for developing and designing Dashboards.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau Development life cycle.
• Creating customized and interactive dashboards using multiple data sources, data extraction and custom objects.
• Designing, developing, maintaining and supporting multiple Tableau dashboards and apps using Tableau 8x, 9x and understanding of new features of Tableau 10
• Designed Summary and Detailed reports using Data Blending and cascading feature in Tableau to provide dependency on objects through filters.
• Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
• Developing and publishing story telling dashboards in Tableau Desktop Tableau Server respectively which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Involved in creating side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps to assist business users in solving complex problems.
• Created Data extracts for better performance and accessing data offline.
• Find proficient ways to make tables and graphs visually exciting and at the same time maintaining the accuracy of the core information content that is being communicated.
• Used SQL tools like Toad to run SQL queries and validate the data in the warehouse and marts.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Provide step-by-step training for the end client users on Tableau Desktop from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.
• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles
• Scheduled frequency and time to refresh data when the sources are published or extracted to server.
• Performing various functions such as processing data, creating reports, analyzing metrics, implementing verification procedures, and fulfilling client requests for information by the use of MS Excel, Word, Access, and Power Point.

Environment: Tableau (Desktop, Server) 10/9.3/9.1, Oracle 11g, TOAD, SQL Server 2012 and Microsoft (Word, Access, Excel, Outlook).

Goldman Sachs, New York, NY

Sr. Tableau Developer

Responsibilities:

• Worked closely with project Business Analyst, Data Architect and ETL Developer to ensure that the end to end designs meet the business data requirements.
• Involved in performing extensive GAP as there were numerous 'As-Is' and 'To-Be' conditions in the project.
• Published customized interactive reports and dashboards to Tableau server.
• Extracted data from various sources like SQL Server, data files, Oracle by the use of data blending and joins.
• Translating business requirements into Business Object Reports and Dashboard design -Communicated with stakeholders, business groups as well as participated in meetings and user group discussions.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating New Schedule's and checking the task's daily on the server
• Defined best practices for Tableau report development.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Modifying and creating Interactive Dashboards Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Deep understanding of relational database structures, theories, principles, and practices.
• Responsible in generating dashboards with quick filters, parameter and sets to handle views more efficiently.
• Managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Creating navigation pages such as Table of Contents (TOC) which had all the links to various reports.
• Assisting users with questions and issues using Tableau
• Checking the task’s on the server daily and creating New Schedule's.
• Maintaining the data efficiently by defining it with T-SQL database objects such as tables, joins, views, triggers, procedures, functions.
• Provided 24/7 production support for Tableau users.
• Deep experience with the design and development ofTableauvisualization solutions.
• Coordinated with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
• Extensive experience with the design and development of Tableau visualization solutions.

Environment: Tableau Desktop 9.0/8.3, Oracle10g/9i, Crystal Reports, SQL Server 2008/2012, MS Visio, MS Excel.

Confidential, Bristol, CT

Tableau Developer

Responsibilities:

• Preparing project reports and assisting the project manager in the development of weekly and monthly status reports, policies and procedures.
• Administering and deploying complex Tableau server environments involving multiple server setups in controlled and secure environments.
• Creating users, groups, projects, workbooks and setting the appropriate permission sets for Tableau server logons and security checks.
• Designing business intelligence dashboard using Tableau Desktop and publish in Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Implemented incremental data extracts, updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management.
• Mastered in writing Parameterized Queries for generating Tabular reports.
• Extensively experience with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau desktop/Server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Assisting in project management activities such as planning, development, task allocation, project execution.
• Worked with ETL team for performance improvement using custom SQLs.
• Implementing verification procedures and fulfilling client requests for information using MS Excel, Word, Access, and Power Point.
• Preparing monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Tableau (Desktop, Server)8.0/ 7.0, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, MS VISIO, Microsoft Office Suite.

Confidential, New York, NY

Tableau Developer/Analyst

Responsibilities:

• Actively participated in interactions with Business users in understanding their requirements.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Involved in installation and configuration of Tableau Server.
• Mastered the art of understanding existing business model and customer's new requirements.
• Experience with the design and development ofTableauvisualization solutions.
• Provision a new Tableau Server site by exporting an existing site and importing it into the new one.
• Experience in Utilizing advance features of Tableau software for linking data from various connections together on to one dashboard and to filter data in multiple views at once.
• Created Custom Hierarchies to meet the Business requirements in Tableau
• Experience in building Visualizations and Storyboards by combining and cleansing datasets.
• Worked on creating filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Implemented data refreshes on Tableau Server for biweekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created different analytical reports from various information sources by data blending in Tableau Desktop.
• Worked extensively in creating Calculations, Parameters, Maps, Trend Lines, Statistics, Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Documenting and creating the Test Cases in HPALM.
• Gathered functional business requirements by attending meetings consistently with the Clients subject matter experts in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Involved in executing and testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Collaborated with BI team, business users including business analysts, data warehouse developers, and managers, to design and develop as per requirement.

Environment: Tableau (Desktop, Server) 7.0, Teradata, SQL Server 2012, PL/SQL, TOAD, HPALM, Agile-Scrum, MS Project.

Confidential, NJ

SQL Server Developer/BI Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Extensively used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of the views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema.

Environment: SQL Server 2005 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, DTS, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.