SUMMARY

• Over 5+ years of experience in Software Design, Dashboard Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Around 3 years of experience as Tableau Developer and Admin.
• 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 with in Tableau Server and Reports.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked on various domains including Insurance, Finance, Banking, Healthcare and Retail.
• Worked in various Heterogeneous Source Systems like DB2 Mainframes, Oracle, Teradata, MS SQL Server, Flat files and Legacy systems.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Established Best Practices for EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Involved in creating detailed design documents and performing Proof of Concepts (POC).
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Experience with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assitant.
• Used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Extensive working experience in Packages, Procedures, Functions, Cursors, SQL*Loader.
• Expertise in using Version controllers like Clear Quest, Clear Case and PVCS.
• Strong team member with good communication and analytical skills.
• Experienced in tuning long running SQL queries for better performance.
• Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI Tools: Tableau 8.1/8.0/7.0, SAP BO, SSRS

ETL Tools: SQL Server Integration Services (SSIS) 2005.

Databases: Oracle 10g/9i/8i/7i, IBM UD2 DB2, Sybase SQL Server 11.0, MS SQL Server 6.5/7.0/9.0, MS Access 2000, Teradata

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML

BI Tools: Business Objects XI6/5, Micro Stratergy 9, Cognos

Web Technologies: JavaScript 1.2, HTML 4.0

Others: Erwin 4.1.2/3.5.2 , TOAD,, SQL Loader, MS Office, Smart FTP, Ultra Edit, Autosys, Unicenter, Control-M, Quality Center, MS.VisioOperating Systems Sun Solaris, Windows NT 4.0, Windows 95/98/2000/XP,HP Unix, MS DOS 6.22, IBM-PC Compatibles

PROFESSIONAL EXPERIENCE

Confidential, Phoniex AZ

Sr. Tableau Developer / Admin

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Responsible for implementing effective Business dashboards & visualizations for senior management employing Tableau Software.
• Leading of visualization projects and initiatives within multiple divisions.
• Administrate Tableau Server, data content and report distribution.
• Gathering, cleaning and classifying data from multiple subsystems to support correct metrics distribution within the company
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in installing tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Involved in creating ad hoc analysis and reporting requests in a timely manner for Health Dept, Approval's, Declines weekly monthly and yearly
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended
• Deep experience with the design and development of Tableau visualization solutions
• Worked on XML Web Services Control Flow task to read from XML Source.
• Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.

Environment: Tableau 8.1,8.0, Erwin, SQL SERVER 2008, XML,T-SQL, batch Scripts, SSIS 2005, Rational Suite, Business Objects XI R2

Confidential, Bloomington IL

Sr. Report Analyst/Tableau Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.
• 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
• Validated the reports before publish reports to server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Building, publishing interactive reports and dashboards, report scheduling using Tableau Server
• Set up Tableau Desktop, Data Analysis and publishing reports.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: Tableau 7.0, 6.0, SSIS 2005, SQL Server 2008, DB2, Cognos,Aqua Data Studio, Erwin 4.1.2, Toad, Winscp, Autosys, Rational Clear Case, Rational Req.pro, Rational Clear Quest, UNIX

Confidential

Data Warehouse Consultant

Responsibilities:

• Actively participated in a team in the logical and physical design of the data warehouse.
• Closely associated with data architect in resolving the data issues.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Involved in creating stored procedure to support recovery.
• Responsible for Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the production environment.
• Extensively used the Lookup and Update Strategy Transformations for implementing the Slowly Changing Dimensions.
• Used different tasks like Email, Command task.
• Responsible for migrating the mappings, sessions, source/target definitions from the development repository to the production environment.
• Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
• Developed Informatica mappings and shell scripts for loading trading and clearing data
• Involved in the mirroring of the staging environment to production.
• Created and reviewed the Design and Code review Templates.
• As a part of the testing team, Involved in conducting the Unit tests and System tests.
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Optimizing the Autosys batch flow.
• Developing control files, Stored Procedures to manipulate and load the data into Oracle database

Environment: Informatica Power Center 6.1, Windows NT, Sun Solaris, Shell Scripts, Oracle 8i, PL/SQL, SQL Loader, Discoverer 2000, SQL Server, Autosys, DB2, Erwin 3.5.2.