SUMMARY:

• Over 7 years of experience in software design, development, integration, implementation and maintenance of business intelligence and database platforms.
• Involved in Full Life Cycle Development of reporting projects, includes requirements gathering/ analysis, design, development, testing and production rollover.
• Involved in trouble shooting, performance tuning of reports and resolving issues within Tableau Server and reports.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in Tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML.
• Improved Reports performance in Tableau using extracts and context filters.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Tableau, Business Objects, SSRS, Microstrategy.

ETL Tools: Informatica, Data stage, Microsoft SQL Server Integrated Services.

Databases: SQL Server 2008/2005, Oracle 8i/9i/10g/11g, MS-Access, DB2, Teradata.

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

Scripting Languages: C, C++, HTML, SQL, PL/SQL and XML.

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

PROFESSIONAL EXPERIENCE:

Confidential, KS

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Worked on tableau server 8.3 Version as “site admin” in maintaining Users, Groups.
• Worked on scheduling task for workbook with Tableau Extracts.
• Worked on tableau server in checking and recording the performance history on tableau server.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Have created operational dashboards, established governance model and SOP's for different lines of business including key business clients.
• Support the Business' ad hoc analytical needs.
• Developed canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Environment: Tableau Desktop 8.3, Tableau Server 8.3, Microsoft Office 2007, SQL Server 2008, PL/SQL, T-SQL.

Confidential, Kansas City, MO

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Tableau, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata SQL Assistant, Teradata Administrator, Business Objects, SQL, PL/SQL, MS Project.

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Environment: Tableau 7.0, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential, Atlanta, GA

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 Micro Strategy 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 Micro Strategy 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, Micro Strategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Confidential

Oracle Developer

Responsibilities:

• Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.
• Extensively worked with DDL and DML commands and was also responsible for creating tables, enforcing Constraints.
• Inserted and updated log tables for each transaction on any table using triggers.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Interacted with business analysts to develop modelling techniques and re-structuring strategies.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in debugging and Tuning the PL/SQL code, tuning queries and optimization of the Oracle database.
• Created external tables to transfer .csv files to tables and from tables to .csv using the standard package utl file.
• Modelling of back end database using Erwin data modeller.
• Performed subsequent alterations using SQL, PLSQL to make any changes on adhoc requirements.
• Performed Data Extraction, Data Transformation and Data Loading (ETL).

Environment: Oracle, DB2, Toad, SQL, PL/SQL Stored procedures, UNIX, Business Objects XI, sun Solaris.

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server 2000 Servers, multi instances.
• Database Programming in Visual Basic 6.0, MS SQL Server 2000.
• Planned and Scheduled the Online/Offline Backups, Maintained Backups and Restore.
• User Management creating groups and policies in Active /directory, Maintained User data and File System.
• Created and maintained mail and database accounts with client user support.
• Configured and maintained servers with Active Directory integration.
• Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
• Performed log-shipping process between servers.
• Performed extensive database activities such as data modeling, database design, data analysis, validation and consistency check.
• Used triggers and constraints to maintain the consistency of the databases.
• Used DTS packages to perform Data Transformation tasks like bulk copy and bulk transfer of data and used BCP utility to perform these tasks.
• Implemented Business logic using stored procedures.
• Designed and developed tools for business requirements using stored procedures.

Environment: MS SQL Server 2005, MS Access, Import & Export Data, Windows 2000.