SUMMARY:

• Quality focused, detail - oriented analyst, Oracle Certified with strong knowledge of business analytics tools such as Tableau, Business Objects and possess technical experience in IT Industry. Skilled trouble-shooter with ability to translate business intelligence requirements into manageable data visualizations.
• Possess knowledge and practical skills of Business Reporting tools such as Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience with SQL, PL/SQL, SQL and PL/SQL Tuning, Database Administration Tasks.
• Expertise in writing SQL Queries, Analytical functions, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Deep understanding of Business Functions/Process and have e xperience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Strong Customer Centric Approach, with Process Orientation ; Motivated by internal standards of performance to deliver quality results.
• Working knowledge of Agile Methodology of Project Management and Delivery functions.
• Successfully executed and managed many projects in America , India and APAC . Experienced in providing support in different geographies and time zones all over the globe.
• Exposed to entire SDLC process including Requirement Analysis, Effort Estimation, Design, Solution Development, Review, Testing, Implementation and Documentation .
• Experience with UNIX shell scripting and Windows environment.
• Extensive working knowledge in the following areas:
• Advanced Tableau Techniques - Joins, Data Blending, Unions, Calculations and Parameters, Table Calculations, Top N, Dashboards and Stories, etc.
• Creating interactive dashboard using actions like filter , highlight and URL , drill through reports, dual axis charts.
• Writing and tuning complex SQL statements, complex joins, M-views and sub-queries
• Aspects of Oracle Database , including creating tables & indexes , using data dictionary , writing SQL Loader Scripts and Oracle Export/Import Utilities .
• Writing Batch Jobs, Stored Procedures, Packages, Functions & Database Triggers using PL/SQL
• Creating logical and physical data models , process models , and detail design specifications .
• Experience in Extraction, Transformation and loading using SQL Loader and Other tools.
• Strong in Database Design, Creation, Migration, Performance Tuning , Logical and Physical Design, Disk Space Management, Database Tuning, Backup and Recovery Activities, Installation and Upgrade of Database.
• Worked on Operating Systems : UNIX / Linux, Windows9x, NT & 2000 .
• Complete Software Development Life Cycle (SDLC) including Global delivery model projects (Onshore-offshore development and delivery):
• Roadmap, Requirements Gathering and Analysis
• Design and Architecture
• Customizing and configuring the product/tool to meet the customers need
• Testing, Implementation and Product Support
• Agile Methodology for Delivery Projects:
• Requirement Gathering and Prototype Development
• Regular Demonstrations with the clients and end users to provide the appropriate solution to their needs followed by Unit Testing, SIT and UAT

PROFESSIONAL EXPERIENCE:

Confidential

Tools: Tableau Desktop, Toad, SQL Developer, Python, OBIEE, BO

Senior Tableau Developer/Database Analyst, San Jose, CA

Responsibilities:

• Understand the usage data for Confidential and process flow between ordering, provisioning and billing systems.
• Analyse client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Involved in creating dashboards by extracting data from different sources.
• Maintained the tableau server site for Confidential group and performed activities like creating users, groups, projects, providing licenses, setting the proper permissions and schedules.
• Developed various reports, views, drill down and bar chart dashboards using Tableau to in corporate the growing business needs and data representation at various levels and for different stakeholders.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, parameters, mapping and hierarchies .
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce Multiple chart types in a single view.
• Involved in generation of reports and dashboards using OBIEE and BO as well.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Oracle, SQL Server
• Used Tableau type conversion functions and date functions extensively when connected to relational data sources.
• Developed python scripts to automate the refreshing/publishing extracts to tableau server.

Confidential

Tools: Tableau Desktop, SQL Developer, Python, Toad

Tableau Developer/Database Analyst, San Jose, CA

Responsibilities:

• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Engage client to gather software requirements/business rules, and ensure alignment with development teams.
• Understand the complete Bookings process and implement the logic using complex plsql objects.
• Created complex dashboards to show bookings data, sales data, year over year comparisons in Tableau.
• Developed python scripts to automate the data loading process and refreshing/publishing extracts to tableau server.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Oracle, Hana.
• Used complex table calculations, parameters, filters, context filters and custom sql in Tableau to meet the business requirements.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered user, user groups, permissions and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked in writing ad hoc SQL Queries, Pl/ SQL Procedures and functions to fetch data for analysis.
• Loaded data into oracle tables using SQL*Loader and Python.

Confidential

Tools: Toad, SQL Developer, Tableau Desktop

Tableau and Database Developer/Analyst, San Jose, CA

Responsibilities:

• Translate stakeholder requirements into different deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Generation of graphs and charts for a complete metrics data representation using Tableau using various data sources like Oracle, Excel, etc.
• Hands on experience with Advanced Tableau Techniques - Joins, Calculations and Parameters, Table Calculations, Top N, Dashboards, Actions etc.
• Involved in creating data blending in case of merging different sources.
• Generating the Inventory Metrics through custom procedures and scripts and regulated their execution through data base jobs.
• Responsible for refresh of Load Test environment with production.
• Extensive use of Materialized Views to enhance the performance trends for heavily populated tables.
• Worked on Performance tuning of Queries that took longer time to execute in application.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Developing and Enhancing the existing Workflows, Request Types, Portlets, Reports and Dashboards using PL/SQL procedures and functions.
• Developed real time, Account, Project Manager and Team Member dashboards using SQL and PL/SQL for resource utilization, project cost details, project tracking, audit details, defect tracking, project monitoring and planning for SDLC/Maintenance/QA/Production Support projects.
• Migration of Resource bundle from one instance to other using Change Management module. Defining Security Model for users.
• Used shell scripting, basic Unix commands for scheduling jobs, running scripts, etc.
• Was responsible for tuning the SQL statements using Explain Plan, SQL Trace, TKPROF and Optimizer Hints.
• Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met
• Testing and identifying Bugs in the existing version Inventory Reports.
• Facilitate meetings with clients to document requirements and explore potential solutions.

Confidential

Tools: SQL Developer, Emptoris CLM (IBM)

Senior Oracle DB Consultant, Cupertino, CA

Responsibilities:

• Created new procedures and Scripts for Migration and Real Time Data updates in CLM Databases.
• New Custom Schema setup for integration.
• Setting up interfaces between GMACC and CLM - for publishing and subscribing data.
• Creating Data Flow Diagrams.
• Managing migration risk and ensuring Data Integrity.
• Involved in creation and updates of several SQL Index, Views , Complex Stored Procedures and appropriate User defined functions.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins and statements for applications.
• Creating Complex queries for reporting.
• Data validation scripts for verifying data post migration.
• Supporting UAT.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
• Used TKPROF (SQL Trace) tool to analyse and fix multiple time consuming SQL statements that were available in stored packages.
• Used SQL hints and indexes to improve SQL performance and analysed the schema tables for to get the better performance.
• DBA Activities including backups, managing CLM integration, tablespace monitoring, query optimization.
• Loaded data into oracle tables using SQL*Loader.

Confidential

Tools: SQL Developer, Toad, Business Objects

Oracle Developer/Consultant

Responsibilities:

• Created new procedures and tables for Archiving databases.
• Extensively used DBMS Scheduler for scheduling the nightly batch jobs.
• Tuned SQL Query for optimization in Oracle stored packages using Explain plan and Auto trace.
• Used TKPROF (SQL Trace) tool to analyse and fix multiple time consuming SQL statements that were available in stored packages.
• Involved majorly in Data Refresh, Cloning activities, Deployment of Service Packs and import export of database schemas.
• Deployed Operational Reporting Solution (Integration of PPM 9.12 with Business Objects) for the OOTB Operational Reporting.
• Prepare, Execute and review test plans and test cycles ;
• Delivered unit and integration testing and documentation.
• Involved in Defect fixing and code deployment into test environments.

Confidential

Tools: SQL Developer, Toad

Oracle Developer/Reporting Analyst

Responsibilities:

• Involved in writing queries and fetching the data from the database using PL/SQL on various modules like Demand, Time, Project and Finance.
• Developed complex custom JSP Reports for the Health Analysis (Schedule, Cost, Issue, Resource and Risk) of Projects and Programs.
• Gathered various Business Requirements from the client and translated the Service requests (SR) into technical design and specification.
• Involved in importing the production data to work environment through Datapump Utility.
• Responsible for the data refresh activities from Prod to Stage and Dev.
• Heavily involved in Oracle SQL and PL/SQL Coding.
• Involved in Creation of Tables, join conditions, Correlated sub queries, Nested queries and Views for various HP PPM applications.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Planning for Production Deployments.
• Customization of several OOTB JSP pages and XML files to meet the client requirement.
• Responsible for System Integration testing and migrations after UAT.

Confidential

Tools: Toad; SQL Developer

Oracle Developer/Consultant

Responsibilities:

• Extensively used SQL Loader to load the data from Flat Files into the staging tables and verified the Log Files for rejected rows.
• Used various Exception handling cases for proper flow of data into database tables.
• Created various M-Views to improve performance of queries fetching large amounts of data for reporting.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Analysed existing logical data model and made appropriate changes to make it compatible with business requirements.
• Worked on Shell Scripting, fair knowledge of UNIX.
• Handling Change Request's (Enhancing procedure logics to support functionality and enhancements in queries to add new columns to Reports) in the form of releases (Using Agile Methodology).
• Performed systems analysis, gathered requirements and created design documents.
• During Upgrade Process, performed System testing and was involved in bug fixes for all invalid database objects.
• Creating Estimation of release and Creating plans for releases.
• Managed activities such as: Gathering requirement from customer and providing them efficient solution.
• Direct interaction with customers to clarify the requirements
• End-to-end responsibility for releases including coordination with various teams within organization.
• Developed complex queries for Portlets and dashboards for trend analysis of reports on weekly basis.
• Communicated with Subject Experts for implementing any modifications affecting production data.

Confidential

Tools: Toad

Database Developer and Administrator

Responsibilities:

• Performed DBA Activities including backups and recovery through RMAN and EXP/IMP utilities.
• Involved in writing several PL/SQL procedures and functions as per the requirement.
• Used SQL queries and analytic functions.
• Performed Database creations, Tablespace monitoring.
• Performed Query Optimization and Database Tuning.
• Used Explain Plan and SQL Trace to fix multiple time consuming SQL statements that were available in stored packages and procedures.
• Developed SQL scripts and Procedures to load data (ETL) into data marts and database tables.
• Written complex procedures for validation and error reporting on the data.
• Part of the team that was involved in project planning and timeline estimation.
• Creating many reusable components for migrating Excel data to Oracle database.