Divya Komirishetty

Fremont, CA *****

C: 408-***-**** ac01k5@r.postjobfree.com

PROFESSIONAL OVERVIEW

* ***** ** ********** ** Data warehousing and Business Intelligence technologies along with 3 years of data visualization using Tableau.

Experience in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Good experience in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.

In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.

Developed attractive visuals/dashboards to convey the story inside the data.

Excellent understanding of Relational Database Systems, De-Normalization, Data Analysis, and Data Warehousing.

Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle.

Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects.

Excellent SQL and PL/SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE, UTL_HTTP.

Good Understanding of Data warehouse concepts such as like Kimball model, Inman model. Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.

Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built-in Functions. Performance Tuning of Informatica Mapping and workflow.

Data Modeling experience in Star/Snowflake, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.

Hands on experience on Tableau Desktop, Oracle Data Integrator (ODI), UNIX scripting, Python etc.

Loaded Data into Oracle Tables using SQL Loader.

Experience in creating database objects like functions, procedures, triggers and indexes.

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Involved in trouble shooting of performance issues which were associated with Tableau reports.

Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.

Experience in Error handling and debugging coding issues and troubleshoot production problems.

Technical Skills:

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers, Indexes), DB2.

Tools & Technologies: ODI, SQL*Loader, Tableau, Informatica (Power Center 8.6.1/9.1.0), Business Objects, SQL, PL/SQL, UNIX scripting, Python, Java, XML etc.

Operating Systems: UNIX(Sun Solaris, LINUX), Windows NT/98/95/2000 & Windows XP.

Education Qualifications:

Bachelor’s in Electronics and Communication.

PROFESSIONAL EXPERIENCE:

Confidential Jan’ 15 – Present

Sr. Data Analyst Sunnyvale, CA

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Worked on contracts data and extracted data from various sources such as flat files, Oracle DB.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart and Data Warehouse.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations using Tableau.

Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

Developed various kinds of charts like donut charts for analyzing sales planning data, Trend line chart for performance overtime etc.

Expertise in working with data building Groups, Hierarchies and sets.

Developed effective and interactive Dashboards using Parameters and Actions

Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Published and shared views on Tableau server.

Worked closely with Business users. Interacted with other ETL developers, Reporting Developers, Project Managers, and members of the QA teams.

Ability to work effectively in team environment and interact with all levels of management

Ask.com June’ 14 – Jan’ 15

Data Analyst Oakland, CA

Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business requirements. Involved in optimizing the complex queries to improve the performance.

Involved in writing shell scripts based on business user requirements.

Designed and developed Oracle forms & reports using Developer Suite 10g.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.

Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.

Created dashboards for analyzing financial data using Tableau 8.0.

Designed and developed financial reporting studio reports for balance sheet and income statements.

Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.

Extensively worked on different types of filters.

Created custom Function's Date range, Time functions, Logical functions in the reports.

Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.

Provided user trainings on the key dashboards

Tata Consultancy Services Oct’ 08 – Jun’14

Below listed are the clients/projects worked for:

GE Aviation Systems

Programmer Analyst Pinellas Park, FL

Xerox Corporation

Programmer Analyst Webster, NY

Motorola

PL/SQL Developer Schaumburg, IL

New Mangalore Port Trust

PL/SQL Developer Mangalore, India

HCL

Assistant System Engineer Kolkata, India

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects based on user inputs.

Developed and modified a number of Forms & reports and for various modules using Developer Suite 10g.

Wrote Shell Scripts for Data loading and DDL Scripts.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Performed Database Administration of all database objects including tables, views, indexes, views, sequences packages and procedures.

Used SQL*Loader as an ETL tool to load data into the staging tables.

Good experience in Oracle Data Integrator to map the data between the systems, interfaces,scheduling and workflows.

Provided user training and production support.

Improved the performance of the application by rewriting the SQL queries.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.

Contact this candidate