SUMMARY

• Over 9 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including
• Technical support, troubleshooting, report design and monitoring of system usage.
• 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.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Managed cross-functional teams through Software Development Life Cycle.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, DataStage, UNIX, DB2, Oracle technologies.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• 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.
• Conducting enterprise-wide trainings for 500+ users, ranging from developers to EVPs, on using
• Good Domain knowledge of Banking, Insurance and Health Care applications.
• Experience of working at Client Location and interacting with business partners in requirements gathering and processing requirements.
• Responsible for Gathering requirements and Coordinating with Offshore team, creating Framework Manager Model, Creating different types of reports, performance tuning and trouble shooting of reports, Scheduling the reports, and Creating project supporting documents.
• Extensive experience in analysis to design the BO Universes and Business Objects Reports to support the user requirements. Used aggregate awareness in Universes and created reports employing functionality like Slice and Dice, Drill down, Functions, Filters & Formulae.
• Implicated in Preparation of Metadata in Framework Manager by importing tables views and stored procedures from Database and Preparation of Presentation layer in Framework manager.
• Experience in working with Control-M application to trigger events of remote application servers.
• Experience in creation of test plans and test cases and testing of Business Intelligence BI tool based Reports.
• Experience in creating/reviewing Requirement Specification (SRS) & Design HLD) documents.
• Experience in directly working with business partners from Offshore.
• Good experience in Change Management Request of reports.
• Good Knowledge on Info Web, SDLC and IT Service Catalog applications.
• Effective communication & presentation skills.

TECHNICAL SKILLS

Reporting Tools: Tableau, SSRS 2012/2008, Crystal Reports, Cognos, QlikView

ETL Tools: Microsoft SQL Server Integrated Services, Informatica, Data Stage

Databases: MS-SQL Server, Teradata, Oracle 118i/9i, DB2 UDB, Sybase

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

Defect Management tool: HP Quality Center

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Languages: C, C++, C#,.NET, SQL, PL/SQL and Java

Operating System: Windows NT/2000, UNIX (HP UX, Solaris 2.7/8, AIX), AS/400, OS/390.

Scheduling Tools: Control M, AutoSys, ESP Scheduler, SQL Agent

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: SQL Server 2012/2008, Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, DataStage, Tableau, Autosys, UNIX, SQL Server, ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Eden Prairie, MN

Tableau Developer

Responsibilities:

• Working with Business analyst in converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards.
• Involved in installation of Tableau desktop, Tableau server Application software
• 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.
• Created Business requirement documents and plans for creating dashboards.
• Involved in creating ad hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps,
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• 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 Analyzing, developing, testing and debugging the code by using various SAS techniques like SAS SQL, SAS MACRO and system options like SYMBOLGEN, MLOGIC according to the requirements that are dynamic for meeting the need of modeling team that supports the CCAR Submission.
• Developing new code and modifying the existing complex code to extract the data from various data sources like DB2, ORACLE.
• Creating the SAS Datasets form raw data by using Proc SQL and various Joins to be available for production.
• Creating SAS datasets by sub setting the production datasets according to the requirement from the modeling team.
• Extensively used Informats, formats and indexes in creating the Snapshot datasets for portfolios like Home equity.
• Providing data-analytical support on strategies for CCAR Stress testing

Environment: Tableau Desktop 8.3/8.2/8.1/8.0 , Tableau server / Administrator, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java1.5 platform, Teradata, Microsoft Office 2007, Microsoft Excel, PowerPoint, UNIX, DB2

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Worked with Lead Business Analysts, project managers to create specifications for system that generates reports and insurance related sales material.
• Involved in the complete Life cycle of the Project and in the data analysis process
• Gather the various requirement matrices from the business analysts.
• Worked with Master Data Management.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Designs for the various reporting requirements.
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Designed ER Diagrams, star schema and snow flake schema.
• Importing source definitions. Creating and importing target definitions. Creating the table targets.
• Created and modified of Attributes, Facts, Metrics, Filters and other report objects.
• Conducted data validation testing to ensure data quality.
• Active Participation in checking the data at database level and at SSRS level in case of displaying wrong data.
• Tested all the business application rules with test & live data and automated.
• Involved in testing and fixing bugs on test and On-line data.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Informatica, Cognos, Power Designer, PL/SQL, Oracle9i, TOAD, UML, Microsoft Office Suite (Word, Excel, Power Point, Visio)

Confidential

Data Warehouse Tester

Responsibilities:

• Worked on the project that involved testing and implementation of a data warehouse.
• Responsible for testing process of extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Analysed and tested the mappings, using Informatica 7.1
• Interacted with management to gather sources and their requirements
• Involved in the some part of performance tuning.
• Tested simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.

Environment: Informatica PowerCenter 6.x/7.1, BO 6.5, Microsoft Visio, Oracle 9i.