SUMMARY:

• Over 12+ years of experience in implementing Business Intelligence solutions for various clients across diverse business segments.
• Extensive experience in the full life cycle implementation of BI projects that includes: gathering Business Requirements, performing GAP Analysis, Designing, Developing, Testing and Documentation of business processes.
• 4 years of experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9/10/2018/2019
• Experience in Financial, Insurance and Consumer Domain.
• Extensive working knowledge of all phases of SDLC and Agile/Scrum methodologies.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactiveTableau workbooks and dashboards for executive decision making.
• Strong experience in trouble shooting, Performance tuning of reports, performing Root Cause analysis, Impact analysis, resolving issues within Databases,Tableau dashboards.
• Proficient in design and development of various dashboards, reports utilizing Tableau
• Hands on experience on various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Well versed with Tableau & Reporting development best practices and performace tuning.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters,Actions, Calculated Fields, Sets, Groups, and Parameters.
• Good Knowledge on Tableau adminstrative activities in creating Projects,Users,Groups and Schedules
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Experience in writing complex SQL queries to perform End - to-End ETL validations and support Ad-hoc business requests.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.­­­

TECHNICAL SKILLS:

BI Tools/Analytics: Tableau Desktop 9/10/2018/2019 , Tableau Server,Tableau Reader, Tableau Online,ThoughtSpot, SAP Business Objects WebI, Business Objects XI 4.2, 3.1

RDBMS : SQL, PL/SQL, My SQL, MS-Access, SQL Server 2008/2012, Oracle 9.2/10.2, Teradata, Netezza

ETL Tools : Ab Initio Co>Operating system 2.15, 3.2.3.8, GDE 1.15,2.14,3.1.5

Other Tools : Oracle SQL Developer, Microsoft SQL Server Management Studio, TOAD, MS Office Suite.Power Pivoit,Power View,Alteryx

Service Management : Service Now, HP Quality Center

Version Controls : EME, ControlM

Web/Scripting Languages : HTML, Unix Shell Scripts

Operating Systems : Windows,UNIX and Linux

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential

Responsibilities:

• Interacted with underwriting team & gathered requirements, created business/technical documents and owned DVS process pipeline.
• Developed DVS reports that focus on the life cycle of Day 1 Ceraintiy.
• Consolidated data from multiple Business areas using Alteryx & automated the proces to eliminate the manual process.
• Created and Implemented Customer Experience Design standards to be used across all the reports with in the project. This helped to achive uniform/standard look and feel for end users.
• Implemented ThoughtSpot as self-service platform to enable business users to create their own reports on ad hoc basis.
• Consolidated data points for various subject areas and loaded data into ThoughtSpot tables.
• Created worksheets on top of ThoughtSpot tables which are used as source by business users to create reports.
• Trained users on ThoughtSpot feaures to educate how to use the tool
• Gathered & consolidated & zeroed down on the list of reports to be migrated by consulations with various stakeholders.
• Analyzed data & report metrics to consolidate & merge reports with similar business need & KPIs.
• Achived a self-service orientated report delivery using Tableau Server instead of previous manual and email delivery.
• Reduced the overall report count drastically by using Tableau featuers like parameters,filters,scheduling (weekly,monthly etc)
• Developed dashboards for exteranl and internal users by implementing row leverl securities for FM connecdt portal.

Environment: Tableau Desktop 9/10/2018/2019 , Tableau Server, Alteryx Designer 2018, ThoughtSpot 5.1.2,MS Office Suite,SAP BW,Oracle 11g,Netezza,Windows,UNIX

Tableau Developer

Confidential, NJ

Responsibilities:

• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Involved in reviewing business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc
• 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.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.

Environment: Tableau Desktop 8.0/9.1,Tableau Server,Microsoft Power BI, MS Office Suite, Oracle 10g, MS SQL Server 2008,Windows 7,Toad,SAP Busssiness Objects.

Confidential

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle 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.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Developed interactove Dashboards using dashboard actions. Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• 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.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Involved in fixing the issues when tested in multiple environments.
• Published customized interactive reports /dashboards into Tableau Server.

Environment: Tableau Desktop 7/8,Tableau Server,MS Office Suite,Oracle 11g, Netezza, MS SQL Server 2012/2008,Windows 2007 server

Confidential

Database / ETL Developer

Responsibilities:

• Understanding the Business requirements, co-ordination with designers and Business Analysts directly.
• Involved in all the stages of SDLC during the project. Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Designed and Developed the generic graphs using the GDE, with components sort, reformat, replicate, assign key, join, merge, gather, components.
• Used Various inbuilt functions like lookup, lookup match, lookup local, string filter out were effectively used in various transform functions
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Created the ACE configurations for the entire process like dimension processing, Fact processing.
• Created and checked in the input and output data sets for the BRE process and incorporated the BRE xfr’s in the graph transformations.
• Created the Conduct>it plans for the end to end process for the end to end testing.
• Created the project level and incremental tags to promote the code to different environments SIT, UAT, Prep prod environments.
• Closely worked with testing team to complete the testing smoothly.
• Worked on defects raised by testing team, thoroughly analyzed and fixed the incidents and deployed for retest.
• Worked on Automate test harness graphs and tested the end to end code before deploying to different environments.

Environment: Ab Initio 2.15, CO>OS, Teradata, UNIX, BRE, SQL Plus, HP Quality Center, Windows NT.

Confidential

Database/ETL Developer

Responsibilities:

• Developed and Implemented extraction, transformation and loading the data using Ab Initio Metadata mapping from source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing the business logic transformation.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Extensively Used Transform Components Join, Normalize, Reformat, Rollup and Scan Components.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Involved in writing wrapper scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading.
• Used Parallelism techniques to partition and process large data simultaneously.
• Used UNIX environment variables in All the Ab Initio Graphs, which comprises of specified locations of the files to be used as source and target.
• Followed the Deployment process to promote code from DEV to SIT and UAT environment to test & validate data.

Environment: Ab Initio 1.13, Co>Operating System 2.14, UNIX, HP Quality Center, WinSCP Oracle9i, TOAD, Windows NT

Confidential

ETL Developer

Responsibilities:

• Understanding the Business requirements, co-ordination with designers and Business Analysts directly.
• Worked in the Data Management Team on Data Extraction, Data Cleansing and Data Validation.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Merge etc.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Developed UNIX shell scripts for Archiving, Data Loading procedures and Validation.
• Tested and tuned the Ab Initio graphs and Oracle SQL’s for better performance.
• Supported the testing team (SIT, UAT environment) implementation as part of change/enhancements for the application by developing, modifying the existing code.
• Worked and resolved the defects raised by testing team and deployed the code by following the deploying process.

Environment: Ab Initio 1.13, Co>Operating System 2.14, UNIX, HP Quality Center, WinSCP Oracle9i, TOAD, Windows NT