PROFESSIONAL SUMMARY:

• 12+ years of IT experience in the Analysis, Design, Development, Testing, Implementation and documentation of application software in Oracle SQL,PL/SQL and UNIX Shell scripting and worked on different domains like Banking and Financial, Manufacturing and Telecom domains
• 7 years of experience in Tableau Desktop& Tableau Server
• Extensive experience in loading high volume data, requirements gathering, analysis, design, development, test and implementation.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server and Worked on data blending and increased the dashboard performance by extracting data from databases like Oracle, Netezza, SQL server, SAP HANA etc.
• Designed and developed the most suitable User Interface such as multiple charts types, Dashboards, customer requests for Excel Export and objects for Management Dashboard reporting using Power Pivot
• Worked on LOD calculations, filters, parameters, groups, sets etc.
• Involved in data validation of the results in Tableau by validating the numbers against the data by querying the Database
• Have good exposure on Tableau administration activities like performance monitoring, capacity planning, and tuning for multiple members and manage the applications users, groups and permissions
• Good exposure in data warehousing models like Start/snowflake schema with Erwin Data Modeler.
• Worked on ETL process using PL/SQL scripts and have good knowledge on 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
• Extensive experience with all phases of the Software Development Life Cycle including analysis, code development, testing, implementing and maintenance
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, Test Plan, and Test Script & Test Cases
• Worked in AGILE environment & attended daily scrum meeting
• Assisted QA Teams for bug testing, 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:

BI Tools: Tableau 9x, 10x (Desktop, Server, Reader)

Programming Languages: XML, UNIX, Oracle, PL/SQL

Data Bases: Oracle 11g/12c, SQL server, Netezza, SAP HANA, Excel, Flat files.

Data Warehousing: Informatica PowerCenter 9.x/8.x, Star and Snowflake Schema, SQL Loader and Informatica versioning tool

SDLC tools: Control-M, TOAD, SQL Developer, Team foundation Server (TFS), HP Quality center, JIRA, Drupal

EXPERIENCE SUMMARY:

Confidential, Philadelphia, PA

Sr Tableau & SQL developer

TECHNOLOGIES Oracle, Netezza, SQL Server, SAP HANA, Tableau Desktop 10.x, 2018.x, Tableau Server, Toad, MS Excel

Responsibilities:

• Furnishing Leadership Team with insights, analytics, reports and recommendations enabling effective strategic planning. Analyzed and processed complex data sets using advanced queries and Identified, measured and recommended improvement
• Developing parameter and dimension based reports, drill-down reports, matrix reports, charts, Forecasting and Tabular reports and dashboards using Tableau Desktop
• 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 Oracle, SQL Server, Netezza, SAP HANA, and Hadoop etc.
• 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 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.
• 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 & SQL developer

TECHNOLOGIES Oracle 11g, Informatica, Tableau Desktop 10.x, Tableau Server, Toad, MS Excel, SCM Workbench, Windows and UNIX.

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

Sr PL/SQL developer

TECHNOLOGIES: Oracle SQL, PL/SQL, Oracle 11g, TOAD, Java 1.6, J2EE, Oracle Web Logic Application Server 11g (WLS), CVS, Eclipse 3.7.2, Windows and UNIX.

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

TECHNOLOGIES: Oracle 10g, Tableau 7, TOAD, Control-M, VSS, Windows, UNIX and Excel

Responsibilities:

• Generating reports using scripts/procedures
• 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.
• 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

TECHNOLOGIES: Oracle SQL, PL/SQL, UNIX, Clear case, Remedy & Clear Quest

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

Confidential

PL/SQL developer

TECHNOLOGIES: Oracle, UNIX, Remedy, Excel

Responsibilities:

• Involved in requirement analysis.
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages, Database triggers, Collections and Dynamic SQL, Refcursors
• 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.

Confidential

PL/SQL developer

TECHNOLOGIES: Oracle SQL, PL/SQL

Responsibilities:

• Involved in understanding the requirements of the system.
• Involved in developing procedures, functions, packages and triggers.
• Involved in writing SQL and PL/SQL script.
• Involved in data conversion by using SQL*loader