SUMMARY

• Over 7 + years of total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, Client/Server and Web applications on Windows and Unix platforms in various verticals such as Financial, Retail and Health Care.
• Experince including Analysis, modelling, design and development of Tableau reports and Dashboards for analytics for reporting applications.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7.x/8.x./9.1
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters,prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Expert in working on Oracle, SQL server, Teradata, DB2
• Developed complex reports using Cognos and Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Sub reports and Grouping.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles,Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Excellent analytical and problem solving using Tableau and SQL debugging skills.
• Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Involved in full life cycle implementation of datawarehouse projects.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources..
• Very good experience in Oracle database application development using Oracle 12c/11g/10g/9i/8i/x, SQL, PL/SQL,SQL*Loader. Strong experience in writing SQL, PL/SQL - Stored Procedures, Functions and Triggers..
• In-depth knowledge in building/maintaining Repository, Universes and creating AdHoc reports.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Highly motivated with the ability to work effectively in teams as well as independently
• Excellent interpersonal, analytical and presentation

TECHNICAL SKILLS

BI TOOLS: Tableau Desktop 9.1, Tableau Server, Cognos, Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI, and Qlikview

ETL Tools: Ab Initio GDE, EME, BRE, Informatica 8.1, Datastage7.5.

Database: Teradata V13/V12/V2R6, Oracle (9i/10g/11g/12c), SQL Server 2005/2008/2012 , DB2

Programming: SAS, SQL, PL/SQL, TOAD, C#, HTML/XML, Shell Scripting, Java/J2EE

Others: AutoSys

Operating Systems: MS-DOS, IBM AIX, HP UNIX, Solaris,Windows 98/2000/NT and Sun OS

PROFESSIONAL EXPERIENCE

Confidential, Monroe,MI

Sr. Tableau Developer/Admin

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Experience in migrating client’s reports from excel (static) based solution to an interactive service.
• 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 and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from Tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test..
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Cognos Reports into Tableau Dashboards.
• Having experience in SME (Subject Matter Expert) in all BI tools.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.0/9.1, Tableau server / Administrator, tabcmd,Tableau drive, Cognos, SQL developer, SQL 2012,Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, Hadoop, MS Access, Windows 2007 server,Microsoft office 2007

Confidential, McLean, VA

Sr.Tableau Developer

Responsibilities:

• Gathered Data from FWIR, RTQ and Epay application analysts and used SQL server analytic and integration services to organize the data, integrate the data and clean the data.
• Provide Line of Efforts (LOE) for the requirements using the tool.
• Developed interactive Dashboards and created reports like The areas in which fraud can occur, To find data patterns amongst data elements, stratification of numbers, Validating the entry dates, Identifying the missing values in sequential data where it should not be none etc. to minimize the fraud occurrence.
• Communicate requests to development teams to support appropriate staging and configuration of data to make dashboard more per-formant.
• Created different visualizations e.g. side by side bars, Scatter plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps and predictive models according to deliverable specifications.
• Developed and Maintained Universes by defining joins, cardinalities between tables, applying contexts and alias tables to remove cyclic dependencies using TOAD .
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
• Worked with Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Produced accurate analyses of fraud data as defined by the required specifications.
• Manage the application’s users, groups, licenses and integration with Active Directory.
• Perform production readiness audit of tableau applications developed by the development team or users.
• Maintain professional links with project clients as directed by the manager, particularly with regard to the collection and analyses of their data, including responding to ad-hoc queries or requests and to gain an understanding of their needs.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Involved in design and implement tableau security, and worked with other team members to establish right physical architecture /layout.
• Performed administrative and support activities across a multi environment tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Provided 24/7 production support for Tableau users.

Environment: Tableau Server 8.0, Tableau Desktop 8.0, Oracle, TOAD 7.0, MS Excel 2010, Windows, UNIX

Confidential, Chicago,IL

Tableau Developer

Responsibilities:

• Worked on Reports from requirement gathering to Universe & Report Development to migrating it to production.
• Analyze PCRF production data like Total Number of requests, Errors, Transaction Per Second (TPS), Latency of different components etc and provide feedback to Business, Product Management and Architect teams to improve business, capacity.
• Developed database objects like tables, views, procedures, triggers, functions using TOAD /T-SQL to provide definition, structure and to maintain data efficiently.
• Followed AgileScrumprocess to streamline development process with iterative and incremental development.
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs and PreparedDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application
• Generate dashboards to provide trending of data using statistics and KPI’s.
• Integrated Cognos and crystal reports to tableau.
• Act as system administrator and is responsible for security, administration, release management, troubleshooting, performance tuning and general system maintenance.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.
• Manage the application’s users, groups, licenses and integration with Active Directory
• Perform production readiness audit of tableau applications developed by the users.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Proof-read all documents and maintain accuracy of information and preparingSOP
• Provide Weekly, Monthly metrics and presentations to management on production issues.

Environment: Tableau Server 7.0/8.0, Tableau Desktop 7.0/8.0, SQL Developer, Oracle 11g, SQL plus, IBM Cognos, SAP Crystal Reports, IBM DB2.

Confidential

Tableau Developer

Responsibilities:

• Involved in creating dashboards and reports in Tableau 6.1.
• Created report schedules on Tableau server.
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Provided 24/7 production support for Tableau users.

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Created Database objects including Tables, Indexes, Clusters, sequences, roles, and privileges.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created separate table spaces for Users, Indexes, Rollback Segments and Temporary Segments. Renamed and resized redo log files, user data files, rollback files, index files and temporary files.
• Created and maintained Triggers, Packages, Functions and Procedures.
• Created and maintained roles and profiles for security and limited access of data.
• Designed and implemented Backup & Recovery strategies.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Debugged, performed system/application tuning by identifying long running reports.
• Created users and established application security by creating roles.
• Wrote procedures to meet adhoc requirements to replicate data from one table to another.

Environment: Oracle 9i, PL/SQL, Windows NT