SUMMARY:

• Over 8 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• Certified Tableau associate with 5 years of extensive experience in Tableau 9.x/8.x/7.x/6.x (Desktop, Server, Reader, Public) as a Developer and Analyst
• Competent in Software Development Life Cycle methodology (SDLC)and Software Testing Life Cycle (STLC) which includes RUP, Agile and Waterfall Methodology.
• Proficient in conducting Gap Analysis, Business Process Re - engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, MicroStrategy, Unica, Google Analytics, UNIX, Toad, Microsoft Office Suite.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data.
• Experience in configuring reports from different data sources using data blending.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actionsandother local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc.
• Hands on experience in embedding Tableau reports and dashboards on external websites using JavaScript API.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Experienced in roles such as End-to-End BI and data-warehouse Solution implementation expert, BI Project Concept Scoping, BI Semantic layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.
• Designed the data conversion strategy, development of data mappings, source data profiling and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expert in Unit,System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Analytical Tools: Tableau 9.x, 8.x, 7.x,6.x(Desktop/Server/Reader/Public), MicroStrategy (Desktop/Web), UNICA, Google Analytics (Adobe Site Catalyst).

Data Integration (ETL) Tools: Informatica, MS SQL Server Integrated Service (SSIS), SQL Server Reporting Services ( SSRS )

Data Modeling /UML Tools: Power Designer, Erwin, MS Office ( Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio

Service Management: CA Service desk, Lotus Notes

Document Management: Share Point, Documentum

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Defect management tool: Mercury Test Director, HP Quality center

Scripting Languages: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 8/ 7/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential

Senior Tableau Developer/Analyst

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 8.2, Business Object 5x, Amazon Redshift. Tableau 9.x/8.x (Desktop/Server), Teradata, MS SQL Server, SSIS, SSRS, Adobe Marketing Cloud, Informatica, SQL,TOAD, Teradata SQL Assistant, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, PowerPoint, Outlook).

Confidential, Charlotte, NC

Sr. Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Designed data marts to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
• Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ data marts.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS.
• Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
• Refreshed the Tableau Extract in production server using scheduler.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Built complex calculations using advance functions such as LOD, DATE functions, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, CASE WHEN, Table calculations and WINDOWS functions.
• Created Actions in Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
• Created SQL scripts for testing and validating data on various reports, dashboards, and scorecards and handled performance issues effectively in Tableau.
• Good experience in developing reports using SQL Server (SSRS).
• Involved in administrating Tableau server and creating tabadmin scripts for automating backup procedures through windows scheduler.
• Worked in user management, group management and permission management for accessing dashboards based on security requirement.
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Provided 24/7 customer support to tableau users.

Environment: Tableau 9.x/8.x (Desktop/Server), Teradata, MS SQL Server, SSIS, SSRS, Adobe Marketing Cloud, Informatica, SQL,TOAD, Teradata SQL Assistant, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, PowerPoint, Outlook).

Confidential, Minneapolis, MN

Sr. Tableau Developer

Responsibilities:

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Extracted data from internal data warehouse system to SSRS.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Environment: Tableau 8.x (Desktop/Server), Teradata, MS SQL Server, SQL, SSIS, SSRS, Teradata SQL Assistant, Java API, Putty, UNIX, Microsoft (Word, Access, Excel, Outlook).

Confidential, Chicago, IL

Tableau Developer

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Converted SSRS and Micro Strategy reports into Tableau.
• Analyzed existing report requirements with end user and converted them for reporting using Tableau.
• Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
• Worked with Tableau administrator in managing Production, Test and Development environments.
• Used data blending feature in tableau and defined best practices for Tableau report development.
• Prepared and published customized reports/dashboards.
• 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.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Developed Geo Maps to show details on customer distribution across United States.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created reports in Tableau using SSRS SQL Queries and Stored procedures.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 7.x (Desktop/ Server), Micro Strategy (Desktop/Web), SSRS, Oracle, Microsoft SQL Server, Toad, Microsoft Office Suite (Word, Excel, PowerPoint, Visio).

Confidential, Pleasanton, CA

Data Analyst/ Business Intelligence Developer

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure and to maintain data efficiently.
• Worked with source system teams to understand source data and complete source data profiling.
• Created Source to Target mapping documents detailing Source rules, Target rules, Transformations required, Error handling etc., and worked with the team of ETL developers to implement the same.
• Designed database tables to feed Promotions, Campaigns, Customer, Sales data for effective targeting and direct marketing campaigns.
• Extensively worked on Pre-Campaign and Post-Campaign data analysis.
• Designed various analytical reports and dashboards on Sales performance, campaign response data in Tableau.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Involved in testing, fixing the bugs and troubleshooting the technical problems.
• Created the templates for test plan, test cases, process flow diagrams etc.
• Involved in Performance Tuning of Parallel Jobs by analyzing the performance of the jobs and project and enhance the performance using the standard techniques.
• Experience in co-coordinating offshore team with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team has on top of design documents, source to target mappings.

Environment: Tableau 6.x (Desktop/Server), Oracle, Teradata, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, UNIX, MS SQL Server, ERWin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Atlanta, GA

Data Analyst/ Business Systems Analyst

• Analyzed requirements to understand business needs.
• Formal Training in Unicaaffinium campaign tool.
• Coordinate with marketing, channel and operational managers to ensure campaigns are consistent with a customer-centric strategy & channel capabilities.
• Design ETL spec documents for the development team and perform data analysis for gaps.
• Assisting developers to resolve complex issues. Developed jobs for ETL audit trail process.
• Extensively developed and used custom routines and enhance the existing projects for campaign management.
• Extracted customer data to suffice source data requirements for campaigning using complex SQL.
• Responsible for complete data integration with other systems developed for marketing.
• Designed the augmentation of MDM processes to improve the quality of the referential databases.
• Managed and assigned engineering tickets and resolve them in very critical time.
• Define methodologies for performance improvement and device strategies for ETL and database optimization.
• Suggested efficient routes in extraction, load and data archiving strategy.
• Involved in Test Plan Preparation and Effort Estimation.
• Understanding and providing feedback for all allocated features / defects, including the work that may need to be completed by the offshore team.
• Involved test planning, test scenario development, and execution of E2E testing with the help of the offshore team as an onsite resource.
• Understanding and analyzing the release statuses and activities
• Provided review feedback for all aspect of testing (test plan, test case, test execution) to the offshore team.

Environment: Oracle, UNICA, Informatica, SQL, TOAD, UNIX, HP Quality Center, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Charlotte, NC

MS SQL Server Developer/BI Developer

• Extracted and reviewed data from heterogeneous sources like ( Excel, CSV, Oracle, flat file, Text Format Data ) using SQL Server Integration Services (SSIS) from OLTP to OLAP .
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
• Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS

Environment: MS SQL Server 2005, MS Visual Studio 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.