SUMMARY

• Around 7 years of experience in IT Software design, development, implementing, testing, reporting and production support.
• Experience in Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle/SqlServer), MS Access and client/server applications.
• Expertize on Tableau Desktop and Tableau Server.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive experience in Tableau Architecture and Administration, configurations and installations
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations inTableau.
• Extensive experience in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) usingTableauDesktop.
• Experience in publishing Dashboards toTableauServer
• Strong experience inDatawarehouse concepts, ETL.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers
• Good understanding of Oracle data dictionary and normalization techniques.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Extensively worked with database tools like Sql Developer, Toad.
• Familiar with programming language such as C and JAVA.
• Extensively worked with large databases in Production environments, UAT and migrations.
• Prepared technical documents for different components during the implementation work relationships with all levels of personnel

TECHNICAL SKILLS

Reporting Tools: Tableau 8.x/9.0, Excel,SSRS

Databases: ORACLE 10g/11g, MySql, DB2, Sql server.Amazon Redshift

Database Access: TOAD 9.5, SQL Developer, SQL*Plus, ODBC, JDBC..

ETL Tool: Informatica Power center8.6.1

Languages: C, C++, Java, Pl/Sql

Operating Systems: UNIX, Windows 95/98/2000/NT/XP,DOS

PROFESSIONAL EXPERIENCE:

Tableau Admin

Confidential, OR

Responsibitlies:

• Installing the Tableau Server in different environments: Cloud,windows
• Handling 2 on-prem Tableau Servers.
• Clustering Tableau Server with worker nodes.
• Working with different Databases Oracle,Sql Server,Redshift,Hadoop
• Changing the configurations using the Cmd line Utility
• Accessing the Tableau Server Repository and creating the custom administrative views.
• Interacting with business users for gathering the requirement while working on new environments.
• Automated the extracts through batch files
• Troubleshooting the extract failures with N/W & DBA Team.
• Performance tuning the complex workbooks
• Performance tuning of the Extracts, to reduce the extraction time.
• Installed and worked on performance testing on pre-release Tableau 9 beta versions
• Providing access to users,creating the groups,schedules
• Providing Techincal support to the end users.

Tableau Consultant

Confidential, Charlotte NC

Responsibilities:

• Created reports to users in Tableau by connecting various data sources (MS SQL Server, Oracle, MS Excel, Flat files, CSV).
• Generated adhoc Tableau reports on based on user requirements.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Handling Tableau server in distributed enivronment, maintaining log levels
• Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.
• Combined multiple data sources by joining tables using Data Blending.
• Worked on multiple Complex tables through custom SQL.
• Generated several drill down and drill up reports.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• Created and managed schedules for users.
• Worked on groups, sets and different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards for the clients to measure cost saving.
• Generated dashboard with security by using user filters.
• Performed end-to-end Data Analysis and ensure the data quality gaps are identified.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Created visualizations inTableauusing Excel data extract source, wrote Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 7.x/8.x, Sql Server, Oracle, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel).

Data Analyst

Confidential

Responsibilities:

• Monitoring the Load Process and resolution to the issues.
• Developed SQL queries for the manipulation of data
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Issue resolution by digging into the Packages and procedures available and enhanced the same where ever required.
• Created dashboards for the clients to measure performance of their services and financial management.
• Generated reports individually for each business CRE, CS, EFS, HFS.
• Involved in working with Implicit Cursors, Explicit Cursors, REF Cursors.
• Solving the issues in SQL Queries and PL/SQL coding for compatibility like Cursors, stored procedures, functions, views, synonyms, Tables.
• Involving in the discussions to understand the requirements of changes requests.
• Feasibility and Impact analysis of Change Requests.
• Creating users, roles, privileges in the BPM Tool.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data from Database sources like GL Source & flat files.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations
• Extensive support to the end Users during UAT and fixing the issues.
• Handling Trainings for the end users to facilitate smooth UAT.
• Monitored and provided front-line support of daily processes
• Handling Migration Activities required for successful transition of artifacts from UAT to Production liaising with DBA team and Server management team.
• For New Requests Interacting with the users and gathering the requirement, providing the resolution plan to the manager, implementing it and post to UAT sign off migrating to production.
• Handing the calls with the business for providing the updates on the issues raised by them training them on BPM Tool usage.

Environment: BPM Tool (TLM), Oracle9i/10G, Pl/SQL, SQL, SQL Devleoper, Unix(Putty)

Responsibilities:

• Designed competent pl/sql programs using pl/sql Collections, Records, Object types.
• Wrote both Implicit and Explicit Cursors to capture rows within a PL/SQL block, and applied business rules on them.
• Good knowledge on joins and Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE.
• Designed matching Rules, Dashboards as per the CRE biz specifications
• Design a multi stage approval process using BPM Tool workflow tools
• Developing PL/SQL procedures for accessing external tables to produce custom workflows.
• Wrote complex SQL Queries to retrieve data from multiple BPM Tool tables to in testing the tool.
• Performed several DDL, DML and TCL operations.
• Worked on inline and correlated sub queries based on business context.
• Created Database Triggers for Auditing.
• Prepared User manuals with screenshots.
• Extensive support to the end Users during UAT and fixing the issues.
• Handling Migration Activities required for successful transition of artifacts from UAT to Production liaising with DBA team and Server management team.

Environment: BPM Tool, Oracle 9i/10G, PL/SQL, SQL, SQL Developer, Unix(Putty).

Confidential

Responsibilities:

• Requirement gathering, basic designing and coding and optimizing the query.
• Created new packages with Procedures, Functions, PL/SQL Records and Collections.
• Solving the issues in database objects like Cursors, Stored Procedures, Functions, and packages as per the business logic.
• Highly skilled in creating database objects like tables, views, procedures using Oracle tools like PL/SQL,SQL*Plus and Handled Exceptions
• Generate and maintain Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
• Developed complexSQLqueries to perform the back end testing of the Oracle database usingSQL and UNIX shell commands.
• Generating monthly reports.
• Maintenance and production support.

Environment: Oracle 9i, PL/SQL, SQL, SQL Developer.