SUMMARY

• Seasoned IT professional with 8+ years of Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Marketing, Technology, Manufacturing and Banking domains.
• Certified TableauDesktop 9 Qualified Associate possessing in - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Over 4 years of experience in end-to-enddesigning and deploying data visualizations using Tableau (9.x/8.x/7.x).
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Expertise in understanding and supporting the client with project planning, project definition, requirements definition, analysis, design, testing, system documentation and user training.
• Extensive experience in client interaction to gather, understand and document business requirements and convert user requirements into functional, technical requirements.
• Proficient in blending data from different sources and developing reports from the same onTableau environment.
• Designed and published visually rich and intuitively interactiveTableaureports and dashboards for executive decision-making.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations likePareto Charts, Waterfall Charts, Line Diagrams,Bar Graphs, Scatter Plots, Pie-Charts, Geographic Visualizationand other making use of actions,Level of Detail (LOD) Expressions and other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, SQL Server, OBIEE, Informatica, MicroStrategy and other Client-Server technologies.
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• High level proficiency and experience in Business Intelligence Life cycle management - Vision workshops, analysis, Data Architecture, Data Integration and cleansing, data modeling, deployment and change management, maintenance, testing, Quality Control.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Posses strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Strong background in MS-Excel, charting, pivot charts, formula, writing macros and PowerPoint.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post - Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven
• Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS

BI Tools: Tableau(Desktop/Server/Reader), MicroStrategy, SSRS,OBIEE

ETL Tools: Informatica, DataStage, SSIS

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Google BigQuery, Teradata, Oracle, SQL Server, DB2, Sybase, Access etc

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

Programming Languages: C, C++, HTML, SQL, PL/SQL, XML, Python, C#

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential NY

Sr.Tableau Developer/Sr. Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs, which were visually easy to understand, and at the same time maintaining the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
• Used LOD Expressions to perform Cohort Analysis of different market segments.
• Validated the results in Tableau by running SQL queries in Oracle SQL developer and Google Big-Query.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Created tableau functional design document.
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the retrospective meetings and next sprint planning meetings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 9.x/8.x (Desktop/Server), OBIEE, Oracle, Google Big Query, Informatica Power Center, Sales force, SharePoint.

Confidential, Torrance,CA

Sr.Tableau Developer/Sr. Data Analyst

Responsibilities

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Used Autosys as Third Party Scheduling tool.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view, which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references.
• Migrated all the reports, dashboards, and scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• 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.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment:Tableau 8.x/7.x, Teradata, Teradata SQL Assistant, SQL, SharePoint, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Phoenix, AZ

TableauDeveloper/ Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using Tableau.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Standardize Tableau for shared service deployment and data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Mentored power users in creating reports by providing Tableau server and Tableau desktop training.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement and involved in the deployment process.

Environment:Tableau 7.0, MicroStrategy, Oracle, MS Access, Teradata, Informatica,TOAD, PL/SQL Developer,AutoSys, Windows 2003/XP, ERwin, and MS Office Suite (Word, Excel, PowerPoint).

Confidential, Austin, TX

BI Developer/ Data 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), MS-VISIO, MS-Project.

Confidential

SQL Developer

Responsibilities

• Worked on the project that involved development and implementation of a data warehouse.
• Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes.
• Created and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using job-scheduling tool.

Environment:MS SQL Server 2000/2005, MySQL, Lotus Notes, MS-Access, MS-Office Suite(Word, PowerPoint, Excel).