SUMMARY

• Highly accomplished and motivated professional with over 14 years of contribution in individual and leadership roles involving Enterprise solutions following industry standards and creating corporate strategies.
• Catering to many industry verticals, including business intelligence/data warehousing, data integration, master data management for various fields like merchandise, healthcare, utilities, and public safety.
• Extensive Tableau Experience in Enterprise Environment in Tableau 6.0, 7.0, 8.0, 8.1, 10.2and 10.4, 2018.1, 2018.3 as Tableau Developer and Analyst
• In - depth knowledge on Tableau Desktop, Tableau Server.
• Strong communication skills and excellent team player who believes in building teams for success and creating an environment for growth and excitement.
• Well- versed in complete system development life cycle for data management applications including business process discovery, data analysis, data modeling (entity-relationship and multi-dimensional), source code development and optimization, system and user-acceptance testing, continuous deployment, and system integration.
• Extensive experience in Database Design using SQL and PL/SQL Programming using Stored Procedures, Functions, Packages and Triggers.
• Hands on and knowledge working on Power BI Tool.
• Strong in using tools such as PL/SQL developer, TOAD and SQL*Plus.
• Experience in writing complex SQL Queries.
• Strong Knowledge on Oracle Architecture and Database Design.
• Extensive experience in Oracle 10g/9i/8i RDBMS.
• Tuning the SQL QueriesusingTKPROFand EXPLAIN PLANfacilities.
• Expertise in loading data from legacy systems using SQL*Loader.
• Involved in Unit level testing, Module level testing and System testing
• Accustomed to utilizing and integrating proprietary and/or open-source development software within various technology stacks.
• Worked with high performance teams developing and implementing state of the art Business Intelligence applications following agile methodology as Technical Lead.
• Customer focused and driven to deliver results with the ability to understand business needs in terms of business value.
• Excellent communication skills (verbal and written), interpersonal and organizational skills.
• Self-starter capable of multi-tasking and delivering quality results.

TECHNICAL SKILLS

Reporting and Analytical Tools: Tableau (Desktop, Server, Reader), Alteryx, Excel

ETL: Pentaho, Informatica PowerCenter 9.x

Data Modelling Tool: Erwin

Source Control Tool: Visual source safe, GitHub, SVN, Rational ClearCase

Database: Oracle, SQL Server, Netezza, MS Excel

Application Server: WebLogic 6.0, 6.1, WebSphere

Project Management: MS Office Suite, MS Project, MS Visio

Domain Expertise: SQL, PL/SQL, XML, UNIX

Collaboration: JIRA, Confluence, ServiceDesk

PROFESSIONAL EXPERIENCE

Confidential - Philadelphia, PA

Lead Tableau Developer

Responsibilities:

• Developing and implementing custom BI applications for reporting and data analysis efforts; engineering and deploying data integration (DI) and reporting services supported by ETL routines (Pentaho DI); creating static reports and interactive web dashboards (Tableau).
• Facilitating knowledge-based transfer sessions, mentorship, and production system support for internal DB-BI team.
• Performing database (DB) design/modeling, development, and administration for an operational data store (ODS), creating and optimizing compiled DB routines (PL/SQL) for transactional and analytics application processing.
• Created Ad-Hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports.
• Used KPIs, Excel, flat files and CSV files to create Tableau Ad-Hoc reports.
• User queries and issues resolution.
• Incident Management and Root cause analysis.
• Creation of complex views in snowflake in respective to the dashboard
• Study the reports from salesforce (SFDC) and try to in corporate the reports as tableau dashboards.
• Creation of extracts, publish data sources to tableau server, set up refresh schedule for extracts in Tableau serve and monitoring the failure extracts and trouble shooting.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Worked with UI designing perspective by providing visuals for the crosstab sheets in the report.
• Provide Data Validation for the dashboards created and worked with Business in resolving the queries.
• Gathering the requirements for new dashboards.
• Understanding the data and building the trends for the future, which helped in revenue.
• Extensive user support, user management on Tableau Server.
• Migration of data from SQL server to snowflake, validation and recreation of dashboards pointing to new data source.

Environment: Tableau Desktop, Tableau Server, MySQL, ETL, SSRS, SharePoint, SQL Server, and Windows, Tableau 10.4, 10.5, 2018.1,2018.3 and Microsoft SQL Server.

Confidential - Fishers, IN

Sr. Tableau Developer & DB Developer

Responsibilities:

• Architected and implemented Tableau environment and workflow across the organization and led the design and implementation of reporting database on top of the existing application database.
• Designed dashboards on the theory of Dynamic Availability where in a variety of worksheets / views were connected by Actions and provided an interactive reporting environment.
• Created Ad-Hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used KPIs, Excel, flat files and CSV files to create Tableau Ad-Hoc reports.
• Applied different graph formats like Tree map, Line chart, Bar chart, Pie chart etc., on visual query for better representation of dashboards.
• Worked on Automating the Tableau Reports to End users by scheduling the role specific Pdf reports.
• Creating various views and Materialized views which are necessary for the Data Metrics.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules, and checking the tasks daily on the server.
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making.
• Experience with design and development of Tableau visualization solutions.
• Scheduling Cron Jobs using Putty
• Writing, Editing and Trouble Shooting Various Refresh Cron Jobs using PUTTY
• Created PL/SQL Procedures, Functions and Packages.
• Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Wrote complex custom SQLs for tableau and writing SQLs to get data and compare data between source systems like Hadoop, Amazon Redshift and Tableau dashboards and crosstabs.
• Planning, Estimation, Assigning, Tracking tasks, Status Reporting for Onsite and Offshore tasks.
• Responsible for Change Requests Implementation and bug fixing for defects.
• Incident Management and Root cause analysis.

Environment: Tableau Desktop, Tableau Reader, Tableau server, Oracle, SQL, Flat files, SQL server, MS-Excel, Statistical files, Microsoft access and Extracts, Oracle 10g, Toad 9.6.1, Putty 0.62.

Confidential - New York, NY

Sr. PL/SQL Developer

Responsibilities:

• Requirement Gathering and Analysis, Functional Requirements Documentation, and prepared technical specification document.
• Planning, Estimation, Assigning, Tracking, Status Reporting for Onsite and Offshore tasks.
• Responsible for implementing SQL and PL/SQL to Store and retrieve rating results.
• Responsible for Unit testing, Quality Assurance and Production deployment of applications.
• Responsible for Change Requests Implementation and bug fixing for defects.
• Day to Day operations support, user queries, issue resolution.
• Worked on UNIX shell scripting
• Developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Generating reports using scripts/procedures
• Developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL
• Involving in tuning queries in Oracle SQL and PL/SQL.
• UNIX CRONTAB schedules
• Responsible for scheduling and monitoring jobs through CONTROL-M
• Understanding business requirements thoroughly to have proper knowledge of reports.
• Responsible for the analysis of data for the reports assigned
• Creating stored procedures depending on the requirement for reports.
• Preparing technical specification document for entire process.
• Responsible for implementing the CR’s after adequate analysis and clarification to meet the business requirements.
• Performed code/document review and always put forward the suggestions for the effective code/document.
• Responsible for bug fixing during generating reports.

Environment: Oracle 10g, Toad 9.6.1, Putty 0.62, Windows 7, SQL*Plus, SQL*Loader

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Involved in requirement analysis.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in UNIX Shell Scripting.
• Involved in LLD, Unit testing and prepared test cases
• Involved data migration to newly added tables and columns
• Review of code changes, test procedure, test plans and other deliverables using Clear case.
• Involved in requirement analysis.
• Involved in supporting the application and handling the remedy tickets and deployment activity.
• Involved in tuning queries in Oracle SQL and PL/SQL.
• Involved in creating documents for issues raised by users and analysis to future reference
• Involved in LLD, Unit testing and prepared test cases
• Review of code changes, test procedure, test plans and other deliverables using Clear case.
• Involved in UNIX CRONTAB schedules

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server, Oracle, UNIX Shell Scripting, Oracle SQL and PL/SQL.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Involved in requirement analysis.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL, ref-cursors
• Involved in LLD, Unit testing and prepared test cases
• Involved in testing procedures, test plans and other deliverables using VSS.
• Involved in Developing Code standards by using Code Expert tool of Toad.
• Involved in supporting the application and handling the remedy tickets and deployment activity.

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server, Oracle, UNIX Shell Scripting, Oracle SQL and PL/SQL.