PROFESSIONAL SUMMARY:

• 8 Plus 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 Banking
• Experience 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 6.x/7.x/8. x/9. x/10. x.
• 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 creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
• Developed complex reports using Business Objects XIR3/XIR2 Webi Rich Client 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 QlikView, 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.
• Good experience as a developer, designer and analyst in designing and developing of Extract transfer and Load (ETL) processes using the tools like AB INITIO, Infromatica Software.
• Involved in full life cycle implementation of data warehouse 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 10g/9i/8i/x, SQL, PL/SQL, SQL*Loader. Strong experience in writing SQL, PL/SQL - Stored Procedures, Functions and Triggers.
• Worked on large data sets within Hadoop ecosystem performing analysis using Hive.
• In-depth knowledge in building/maintaining Repository, Universes and creating AdHoc reports.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal 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 skills

TECHNICAL SKILLS:

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

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

Database: Teradata V13/V12/V2R6, Oracle (9i/10g/11g), SQL Server 2005, DB2, SAP HANA, Hadoop Hive, AWS, Impala.

Languages: C, C++, Java, Visual Basic, ASP.Net, JCL

Scripting languages: UNIX Shell, JCL, Java Script, VB Script, Perl

Others: Business Objects, AutoSys

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

EXPERIENCE:

Confidential, Richardson, TX

Sr. Tableau Developer

Responsibilities:

• Designing complex tableau report packages and story publishing them on the tableau server.
• Designed report that depicts top performers of the total client list in quadrant graph.
• Designed Status Requestor Dashboard that provides status of specific request from end client which provides them tracking ability of their ad-hoc report requests.
• Training Internal employees with tableau desktop and tableau server knowledge.
• Implementation of Initial Sql and Query banding techniques on Teradata tableau connection window to improve performance and security of the data.
• Efficient usage of Regular expressions and level of detail function in tableau 9 to design dashboards with lowest level of aggregation.
• Designed a report by blending 20 different data sources in a single report and controlling entire report with single selection.
• Developing cohort analysis of claims data to estimate cost avoidance charges by connecting through virtual visit’s programs.
• Developing KPI’s dashboard package to depict success of MD live program for the client.
• Developed account specific reporting packages for client’s customers to track their spending on employee insurance.
• Developed MHA, American Airlines, HEB, MD Live, Walgreens etc. accounts specific reports.
• Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
• Involved in design requirement meeting with clients and internal employees.
• UAT testing of the reports developed along with Dev and SIT testing.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Designing excel based reports on tableau.
• Working with Level of Details expressions and Regular Expressions which are helpful in providing etl functionality for tableau.
• Migrating reports from standard reporting tools like excel and cognos to tableau.
• Migrating all the reports from tableau 9.3 to tableau 10.3 and publishing them on the server.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Teradata Sql Assistant, Teradata 14, My SQL, MS Excel .

Confidential, Fort Worth, TX

Sr. Tableau Developer

Responsibilities:

• Created Tableau dashboards using Gantt Charts, Bar in Bar graphs, Line over Bar Graphs, Scattered plots.
• Created workarounds to export excel with single click option on the dashboards.
• Created reports over SAP HANA live connection by including input parameters and variables from BW and SAP HANA.
• Designing Reports with transactional Data with a live connection with efficient performance.
• Worked on FM, MAM, EAM of Plant Maintenance Module of SAP HANA.
• Created dashboards based on user requirement for EAM structures and tracks.
• Creating preventive analysis dashboards with client data.
• Experience in creating executive dashboards with high performance.
• Experience in creating adhoc reports based on client’s data.
• Installed Server 9.2 in Dev, QA, UAT, Prod Environments.
• Managing users on server 9.1 and 9.2
• Working in designing and development of HANA live report along with HANA implementing partners Bluefin.
• Implementing single sign on in tableau over SAP Hana DBMS.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Creating reports on live data with limited tableau functionalities.
• Designed adhoc reports for business users to understand data.
• Extracting data into tableau through hive server from HDFS.
• Developed tableau visualizations connecting to servers like Hortonworks Hadoop Hive, MapR Hadoop Hive, Cloudera Hadoop Hive

Environment: Tableau Desktop 9.2/9.1, Tableau server 9.2 tabcmd, SAP HANA Live, SAP BW, SAP MM, SAP EAM, SAP FM, DB2, JavaScript. Hadoop, Hive, Redshift S3.

Confidential, Nashville, TN

Sr. Tableau Developer

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 7.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 Crystal Reports and Xcelsius 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/7.0, Tableau server / Administrator, tabcmd, Crystal Reports, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, Hadoop, MS Access, Windows 2007 server, Greenplum, Microsoft office 2007

Confidential, Charlotte, North Carolina

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created Reports for Enterprise Data & Analytics team on Mortgage integrated data environment(MIDE) .
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX, Teradata, Unix, Micro strategy, Hadoop, MS Access.

Confidential, Rockleigh, NJ

Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating calculated fields, groups, sets and hierarchies etc.
• Creating data blending in case of merging two different datasets.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing Ad-Hock Reporting.
• Managed development and maintenance of web portal pages and assisted in training on the use of MS SharePoint.
• Working knowledge on Tableau Server / Administration.

Environment: Tableau Desktop 8.0 Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Toad, Windows 2007 server, java 1.5 platform, MS SharePoint, Microsoft office 2007.

Confidential, Chicago, IL

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, San Francisco CA

ETL Developer/Analyst

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Technical expert in the areas of relational database logical design, physical design, and performance tuning of the RDBMS.
• Extensively used ETL to load data from Oracle database, XML files, Flat files data also used import data from IBM Mainframes.
• Responsible for trouble shooting, identifying and resolving data problems, worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Created Fast Load, Fast Export, Multi Load, BTEQ scripts.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Developed Scripts to load the data from source to staging and staging area to target tables using different load utilities like Bteq, FastLoad and MultiLoad.
• Gather information from different data warehouse systems and loaded into Kaiser System Consolidated model using Fast Load, Fast Export, Multi Load, Bteq and UNIX shell scripts.
• Created Process Data Flow diagrams in Ab Initio GDE for data conditioning, transformation, and loading.
• Generated Configuration files, DML files, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
• Updated and inserted transactional data according to the business changes using continuous flows.
• Involved in creating Flat files using dataset components like Input file, Output file, Intermediate file in Ab Initio graphs.
• Developed graphs using multistage components.
• Extensively Used Transform Components: Reformat, Rollup and Scan Components.
• Implemented the component level, pipeline and Data parallelism in Ab Initio for ETL process for Data warehouse.
• Extensively used Partitioning Components like Broad Cast, partition by key, partition by Range, partition by round robin and Departition components like Concatenate, Gather and Merge in Ab Initio.
• Responsible for the automation of Ab Initio graphs using korn shell scripts.
• Developed Ab Initio scripts for data conditioning, transformation, validation and loading.
• Documented the process procedures and flow for the process.

Environment: Ab Initio (GDE 1.15/3.0, Co>Operating System 2.15/3.0), Oracle 10g, Teradata V12/13 (FastLoad, MultiLoad, FastExport, BTEQ and Queryman SQL Assistant), Shell Scripts

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