SUMMARY:

• Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 5 years of extensive Tableau Experience in Tableau 6.x/7.x/8.x /9.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst.
• Extensive experience inTableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and SQL, PL SQL and UNIX shell scripting.
• Worked a great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Experience in configuring reports from different data sources using data blending
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), SQL Server MS Access and client/server applications.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages
• Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations.(Automate the SSIS Packages and Import, Export).
• Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Developed scripts in PLSQL and Python to ingest API data from internal web servers. implementation expert, BI Project Concept Scoping, BI Semantic layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop v6.x/v7.x/v8.x/v9.x, Tableau Server v6.x/v7.x/v8.x, Tableau Online v9.x, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence,SSRS

Databases: Teradata, MySQL, MS SQL Server, ORACLE, IBM DB2, MS Access, Amazon Redshift

ETL Tools: Informatica, SSIS,SSAS

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, JIRA

Programming Languages: SQL, PL/SQL, HTML, ASP.net,C

Document Management: Documentum, Share point, Ultra Edit

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling: Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Productivity Tools: Ms Word, MS Excel, MS PowerPoint, MS Visio, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

Data Analyst/Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• PerformTableauServer admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Effectively used data blending feature in Tableau.
• Prepared and published customized reports/dashboards.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.,
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Perform system administrative tasks, managing and checking the state of the Greenplum databases and its distribution of data.
• Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Tableau Desktop 9.1, Tableau Server 9.1,SQL, PL-SQL, TSQL, SQL Server 2012, MS Office Suite.

Confidential, Seattle, WA

Data Analayst/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.
• 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 particular date.
• Working on Data modelling tools like SSMS and Navicat data modeler.
• Expert in upgradingData ware housing.
• Was the lead in Data Ware Housing Foot-Print reduction
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Hands on experience in UAT Test management, Execution, Scripts
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• 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 (Desktop/Server), Teradata, MS SQL Server, SQL, Teradata SQL Assistant, Java API, Putty, UNIX, Microsoft (Word, Access, Excel, Outlook),sql server, SSIS,SSRS,SSAS

Confidential, Atlanta, GA

Sr. Tableau developer / Data Analyst

Responsibilities:

• Understand the business requirements for report development on exceptions and financial reports
• Developed and deployed merchant friendly UI to generate assortment exception reports
• Created modules and pass through queries to access the DB2 environment source data
• Use the Share embed codetheSharebutton at the top of each view provides embed code that you can copy and paste into your webpage.
• Developed financial reports in tableau for understanding the assortment based on performance
• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Enhance the embed code that Tableau provides, and build own code. Either way you can use parameters that control the toolbar, tabs, and more.
• Resolved the data blending issues based on data from multiple sources
• Developed various tableau BI charts on assortment planning and reporting
• Created parameters, calculated fields, various filters and groups to facilitate different views on dashboards.
• Developed sales reports from Teradata on store wise performance and filtering them on top sales
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• UsedSOQL & SOSLwith consideration toGovernor Limitsfor data manipulation needs of the application using platform database objects.
• Responsible for all the activities related to configuringData Loader, uploading data inCSV filesinto salesforce.com, checking for the correctness of the data.
• Worked with Salesforce.com team to make application certified.
• Packaged and Deployed customizations fromSandboxto other environments using Force.com IDES.
• Help users withChatterteams/Groups and follow application as well.

Environment: Tableau (Desktop, Server), MS Access 2010,VBA, Teradata, SQL, Teradata SQL Assistant, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Hanover, MD

Tableau/ Data Analyst

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 datamarts 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/ datamarts.
• 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 ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, Lookups and Quick Table calculations.
• 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.
• 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 totableauusers.

Environment: Tableau(Desktop/Server)6.1,.2/6.0.1,Oracle,Teradata,MSSQL Server, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, CA Service Desk, Microsoft (Word, Access, Excel, Outlook),Adobe Marketing Cloud

Confidential, Mount Laurel, NJ

BI Analyst/ Data Analyst

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 (Desktop/Server), Oracle, Teradata, Informatica, SQL,, TOAD, Teradata SQL Assistant, Autosys, UNIX, MS SQL Server, ERWin, MS VISIO, Microsoft (Word, Access, Excel, Outlook).

Confidential, Schaumburg, IL

Data Analyst / Business System Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements
• Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the central repository.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created the AS-IS and TO-BE process flow diagrams.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Defined functional business requirements, analyzed client requirements, and generated workflow processes
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Assisted in project management activities like planning, development, task allocation, project execution
• Provided full project life cycle flowcharting, analysis and documentation.
• Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
• Designed, developed, and tested the jobs, using Data Stage
• Involved in the some part of performance tuning.
• Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.
• Created Data Definitions and help maintain Metadata repository.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Experience in using MicroStrategy in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Defined project milestones, schedules, monitoring progress and updating plans using MS Project.
• Prepared 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: Oracle, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Developer

Responsibilities:

• Worked as developer of a team, responsible for the design and development of an ORACLE application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with the project manager to understand the scope of each phase & module and further understand & implement the Object Model & Database design specifications, Domain Model.
• Framing the business logic plus code for accessing data stores.
• Develop validation routines for complex business rules and data handling.
• Created numerous forms and reports using Forms and Oracle Reports.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Used SQL*Loader to load data into Oracle database.
• Troubleshoot performance issues and bugs within packages.

Environment: Oracle, SQL*Plus SQL, SQL* Loader, PL/SQL