SUMMARY:

• Over 7+years of BI experience concentrating mainly on Tableau (10.1/10.0/9.0/8.0/7.0 ) and successfully addressing client’s requirements.
• Experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD
• Relational database (RDBMS) background in SQL Server 2000 / 2005 / 2008 / 2012, Oracle with extensive knowledge and proficiency of T - SQL, PLSQL to design business applications
• Extensively worked on databases like Oracle, SQL Server, DB2
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Involved in installation of Tableau desktop 9.0, Tableau server Application software.
• Creating users, groups, projects, Data connections, settings as a Tableau administrator
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• 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.
• In-depth knowledge in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
• Experience with designing Data Models, develop ETL (Extractions, Transformations and Load) packages using Microsoft SQL Server Integration Services (SSIS), and customize Analytics Reports with Microsoft SQL Server Reporting Services (SSRS).
• 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) of the project ranging from client requirement, design, development and maintenance.
• A good listener and persuasive speaker excellent written and verbal skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau 8.0/7.0, OBIEE 10.1.3x/11g, Business Objects 5.x/4.1, Crystal Reports, Cognos, Micro Strategy, SAS

Data Warehousing ETL Tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2, IBM Info sphere Data Stage, Microsoft SQL Server Integrated Services

Databases: Oracle 11g/10g/9i, MySQL, SQL Server, Teradata

Database Tools: TOAD, SQL Developer, SQL Plus

Data Modeling: Star schema modeling, Snow-flake schema modeling

Languages: PL/SQL, SQL, Java, C

Web Tools: HTML, DHTML, XML, JavaScript

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, Chelsea, MA

Tableau Data Analyst/Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet.
• Involved in installation of Tableau desktop 9.0.4, Tableau server Application software.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on 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 BML Risk related to fraud Approval's, Declines daily, monthly and yearly.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• 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

Environment: Tableau Desktop 9.0.4/10.4, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008.

Confidential, Newyork, NY

Tableau Developer

Responsibilities:

• Developed business process and technical design documentation for each reporting service developed in this project.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Working with Business Teams to gather requirements and assist them in UAT process.
• Experience writing Custom SQL queries for Complex Tableau Reporting.
• Created Data Connections, published on Tableau Server for usage with operational/Monitoring Dashboards.
• Worked on Teradata Store procedures and functions to conform the data and load it on the table.
• Performance tuning, bug fixing and error handling. Used SQL Assistant to querying Teradata tables.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Good knowledge of Tableau Admin activities like Security, Debug user level access, Scheduling, Subscriptions, and User Security.
• Built Complex Data Functions in Tableau Calculated Fields using Parameters and Sets.
• Created various complex SQL Queries, Stored Procedures, and User Defined Functions to implement the business logic.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps per deliverable specifications.
• Created extensive custom joins for blending data from several different data sources like SQL, Excel, Text, and Access.

Environment: Tableau 8.0.5-8.0.21, Tableau server 8, Teradata 12, 15, SQL Server 10.50/ 2008R2 Enterprise Edition, SSIS/SSRS, VSS and SQL Management

Confidential, Denver, CO

Oracle/Tableau Developer

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with Business.
• Participated in all phases including requirement analysis, Client Interaction, designing and testing
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, and Dimensional tables.
• Enhanced the Previous ETL process with new features by exploring areas of improvements like data quality, data masking, slowly changing dimensions and performance enhancements. Implemented best practices for development in all the environments.
• Developed number of complex Informatica mappings and custom transformations to implement the business logic and to load the data incrementally.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Worked on Migration of User Developed Applications/reports from Mainframe SAS to SAS EG in order to optimize the execution time, resources and to reduce the cost of process
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL
• Usage of SQL loader to load data from external files that is exported from Server
• Wrote UNIX shell scripts to spawn the Loader job for daily load of data.
• Developed static and dynamic parameter files for reusability and database connection management among development/testing/production environments.
• Development of shell scripts to access informatica workflows for scheduling
• Design and development of business objects universe for adhoc reporting and web-intelligence reports.
• Developed reports with features like drill down,slice and dice,master/detail for analysis of business.
• Created different reports containing charts showing end of day trade details and statistics.
• Utilized SAS to Create complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plans.

Environment: Oracle, Informatica Power Centre 7.0.5,Tableau, SAS, PL/SQL, SQL Developer.

Confidential, Malvern, PA

Mainframe Analyst

Responsibilities:

• Daily interaction with the Onsite counter parts regarding the support activities.
• Co-ordination with the onsite team and the Client regarding the development.
• Involved in development and implementation of work requests.
• Coding.
• Prepared Unit Test Plan, Unit test Cases, System test Plan.
• Unit Testing, Regression, Shakedown Testing, System & Integration Testing.
• Appropriate Documentation.
• Communicating with the Business Partners and solving the issues raised by them.
• Involved in Preparation of Installation Plan and Back out Procedure

Environment: Windows XP, Z/OS, Cobol, JCL, DB2, CICS, MQ Series, IMS-DB, SMILE, Advantage-Gen and MS Office Suite.