SUMMARY

• 13+ years of IT experience in the Analysis, Design, Development, Testing, Implementation, and documentation of application software in Tableau, Oracle SQL, PL/SQL, SQL Server, Pentaho data integration and UNIX Shell scripting and worked on different domains like Banking and Financial, Manufacturing and Telecom domains
• 8 years of Tableau experience and creating high performance dashboards and user management. Involved in high volume data loads.
• Connected Amazon redshift, Teradata, snowflake, Netezza, web data connector databases through Tableau dashboard development
• Built and published interactive dashboards usingTableauDesktop andTableauServer and Worked on user management and increased the dashboard performance by extracting data
• Expertise in designing and development of various dashboards, reports utilizing various tableau viz like Dual axis, bar Graphs, scatter plots, Pie charts, heat maps, bubble charts, Tree Maps, Box plots, Waterfall charts.
• Involved in Tableau report validation by comparing the numbers/data against data source using queries
• Using Hive to query bigdata source for tableau reporting
• Good exposure in data warehousing models like Star/snowflake schema.
• Good exposure in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Pentaho (PDI) and Informatica
• Expertise in writing simple and complex SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors
• Enforced data integrity using integrity constraint and database triggers
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Expertise in loading data in tables from flat files using SQL*Loader
• Strong exposure in UNIX shell scripting
• Documentation of projects for Functional Requirement Spec, Use case Spec, Test Plan, and Test Script & Test Cases
• Worked in AGILE environment & attended daily scrum meeting
• Assisted QA Teams for bug fixing, User Acceptance Testing (UAT) & System Integration Testing
• Significant experience working with clients, technical teams for executing concurrent multi - technology projects
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction

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, RedShift

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:

• Designed and developed Tableau reports, dashboards at varying levels of complexity
• Organizing and transforming large data sets
• Developing parameter and dimension-based reports, drill-down reports, matrix reports, charts, Forecasting and Tabular reports and dashboards usingTableauDesktop
• Blended data from many databases into single report by selecting Primary keys from each database for data validation.
• 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.
• Creating and publishing interactive dashboards and stories
• Using Hive queries to get bigdata for tableau reporting
• Planning, Estimation, Assigning, Tracking tasks, Status Reporting for Onsite and Offshore tasks.
• Responsible for advanced PL/SQL programming like Using Records and Collections, Bulk Bind, Ref.
• Cursors, Nested tables and Dynamic SQL and Regular expressions.
• Working extensively on UNIX commands and shell scripting to create jobs
• Responsible for Change Requests Implementation and bug fixing for defects.
• Day to day operations support, user queries, issue resolution.
• User queries and issues resolution.
• Involving in Tableau dashboard creation and publishing
• Incident Management and Root cause analysis.
• Performed code/document review and always put forward the suggestions for the effective code/document.
• Developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL
• Involving in tuning queries

Confidential, Fishers, IN

Sr. Tableau Developer & DB Developer

Responsibilities:

• Involved in Requirement gathering and Analysis, created Functional Requirement Documentations, technical specification document.
• 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
• Blended data from many databases into single report by selecting Primary keys from each database for data validation.
• 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.
• 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 advanced PL/SQL programming like Using Records and Collections, Bulk
• Bind, Ref. Cursors, Nested tables and Dynamic SQL and Regular expressions.
• Working extensively on SQL Loader utility daily basis to load data from different files to database tables.
• Working extensively on UNIX commands and shell scripting to create jobs
• 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.
• Participated in all stages of development life cycle.
• User queries and issues resolution.
• Performed code/document review and always put forward the suggestions for the effective code/document.
• Developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL
• Involving in tuning queries.

Confidential, New York, NY

Sr. PL/SQL Developer

Responsibilities:

• Requirement Gathering and Analysis, Functional Requirements Documentation
• 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.
• Participated in all stages of development life cycle.
• Participated in SPE Scrum method of agile development.
• User queries and issues resolution.
• Worked on UNIX shell scripting
• Incident Management and Root cause analysis.
• Performed code/document review and always put forward the suggestions for the effective code/document.
• 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.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• 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.

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