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

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.
• Wrote complex custom SQL’s for tableau and also 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.

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.

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

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.