Data Developer
Resume:
VindhyaKothakonda
Tableau Developer/ Database Developer
408-***-**** – ************@*****.***
Professional Summary
Over 8+ years of experience in Software Design, Development, Implementation, Maintenance and production Support of Business Intelligence and Database Solutions and platforms.
4years of extensive Tableau Experience in Enterprise Environment, in Tableau 10.2/9.x/6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst
In-depth knowledge on Tableau Desktop, Tableau Server and Tableau Viewer.
Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau. Preparing Dashboards using calculations, parameters in Tableau.
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
End to end experience in designing and deploying data visualizations using Tableau.
End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.
Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to requirements specifications.
Extensive experience in troubleshooting, performance tuning and supporting Business reporting platforms.
Extensive experience in Database Design using SQL and PL/SQL Programming using Stored Procedures, Functions, Packages and Triggers.
Strong in using tools such as PL/SQL developer, TOAD and SQL*Plus.
Experience in writing complex SQL Queries.
Strong Knowledge on Oracle Architecture and Database Design.
Extensive experience in Oracle 10g/9i/8i RDBMS.
Tuning the SQL Queries using TKPROF and EXPLAIN PLAN facilities.
Expertise in loading data from legacy systems using SQL*Loader.
Involved in Unit level testing, Module level testing and System testing.
Technical Skills:
BI Tools Tableau Desktop 10.x/9.x/ 8.3/7, Tableau Server 8.2, OBIEE 11g/10.1.3.4
ETL Tools Informatica 7.x/8.x (Power Center)
RDBMS Oracle 9i/10g/11g, MS SQL Server 2008, Teradata, PL SQL,
Languages HTML, XML
Operating Systems Mac OSX, Windows 95/98/NT/2000/XP/7
FTP Tools WinSCP 5.X, Filezilla 3.5.x, Putty
Professional Experience
Tableau developer, Apple Inc – Sunnyvale, CA Mar 2017- Present
Apple Authorized Campus Reseller and Revenue Dashboard
This dashboardprovides the QTD, YTD, QoQ and YoY Detailsregarding the Sell Through, Sell In and Inventory details for the LOB Products Mac, iPad, Watch, Beats, iPod, Apple TV for each Campus Store/Reseller Stores designated to Territory which is owned by AD (Area Director), RM(Regional Manager) and AE(Area Executive). The Dashboards not only provides booking and billing details but also includes the details drilled down to a micro level of each individual device and version, product trending and YoY Sell Thru Trending.
Roles and Responsibilities:
Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
Hands-on experience in analyzing the data and writing Custom SQL queries for better performance, joining the tables and selecting the required data to run the reports.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server.
Developed Tableau workbooks from multiple data sources using data blending.
Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
Responsible for creating dashboards using bars, stacked bars, pie charts, scattered plots, line charts, Gantt charts, and maps.
Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
Worked with BO reports, analyzed the KPI’s and implemented the same reports in Tableau.
Involved in Data validation compared to the BO report against Tableau reports.
Scheduling the Dashboards refresh, publishing and maintaining the data sources and reports in the tableau Server.
Environment: Tableau /10.2/10.0.2/10.0.7, Tableau Server 10.0/10.2 and Teradata, BO
Tableau Developer, CISCO San Jose, CA Feb 2015 – Feb201e7
eStore Project
Infra Provisioning Metrics associated to eStore Application, eStore is the place to find all of the IT services, software and applications that you need to stay connected and work productively at Cisco. The Client Order
the services through eStore creating Bundles and Ordering services.
Roles and Responsibilities:
Analyzed and understood the process flow to provide solution for the proposed requirement change.
Identified the area of the code where the fix needs to be done.
Provided fix for a dataflow which was successfully implemented and accepted by the business.
Creating various views and Materialized views which are necessary for the Data Metrics.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules and checking the tasks daily on the server.
Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making.
Experience with design and development of Tableau visualization solutions.
Scheduling Cron Jobs using Putty
Writing, Editing and Trouble Shooting Various Refresh Cron Jobs using PUTTY
Writing various queries to pull the data required to verify the Metrics calculations form backend.
Successfully extracted data and completed data conversion for legacy systems
Performed rigorous unit testing for the code change in development and stage environments.
Successful deployment of the code changes in production.
Experience on working with portal 11g.
Prepared necessary technical development documents.
Created PL/SQL Procedures, Functions and Packages.
Developed SQL scripts to create database objects like Tables, Views and Sequences.
Environment: Tableau 9.2,Oracle 11g Ex, Toad 12.1, PUTTY,Windows 7
Tableau/Database Developer, Chuwa America Corp, San Jose, CA Feb 2014 – Jan 2015
Roles and Responsibilities:
Gathering the requirements from the client, 3rd party vendors and translated the business details into Technical Design documents.
Created PL/SQL Procedures, Functions and Packages.
Created different views in workbook to visually analyze data.
Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
Used different Mark types and Mark properties in views to provide better insights into large data sets.
Created External filter, internal filter and Context filter to improve performance.
Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
Created parameters and quick filters. Created sets to display top products based on their sale.
Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
Created Dashboards with interactive views, trends and drill downs.
Published Workbooks and Dashboards to the Tableau server.
Combined visualizations into Interactive Dashboards and publish them to the web.
Created groups and users in Tableau server.
Developed SQL scripts to create database objects like Tables, Views and Sequences.
Generating reports using PL/SQL Procedures.
Environment: Oracle 10g, Toad 9.6.1, Putty 0.62, Windows 7, ETL Tools,SQL*Plus, SQL*Loader
Tableau/Database Developer, CIG Monterey, CA Aug 2011 – June 2014
CIG is an indirect automobile finance company helping car dealers provide financing for their customers. CIG currently approved and lending in 12 states. The project scope involves development and enhancements of Warehouse and Finance applications.
Roles and Responsibilities:
Gathering the requirements from the client, 3rd party vendors and translated the business details into Technical Design documents.
Created PL/SQL Procedures, Functions and Packages.
Created different views in workbook to visually analyze data.
Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
Used different Mark types and Mark properties in views to provide better insights into large data sets.
Created External filter, internal filter and Context filter to improve performance.
Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
Created parameters and quick filters. Created sets to display top products based on their sale.
Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
Created Dashboards with interactive views, trends and drill downs.
Published Workbooks and Dashboards to the Tableau server.
Combined visualizations into Interactive Dashboards and publish them to the web.
Created groups and users in Tableau server.
Developed SQL scripts to create database objects like Tables, Views and Sequences.
Generating reports using PL/SQL Procedures.
Environment: Oracle 10g, Toad 9.6.1, Putty 0.62, Windows 7, ETL Tools,SQL*Plus, SQL*Loader
Sr. PL/SQL Developer, HP, Wayne, NJ Dec 2010 – Jul 2011
HP is one of the world’s largest information technology companies and operates in nearly every country. HP specializes in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. The project scope involves development and enhancements of Retail, Finance and Distribution applications used within HP.
Roles and Responsibilities:
Gathering the requirements from the client, 3rd party vendors and translated the business details into Technical Design documents.
Using PL/SQL, developed scripts to extract the data from multiple applications to multiple applications.
Performance tuning and testing of Oracle PL/SQL database entities.
Coordinating with offshore teams on the development processes.
Developed control scripts for SQL*Loader to load the data from flat files to Oracle Databases.
Extensively Used Oracle supplied Packages during the course of development.
Working closely with DBA’s for performance problems, fix the problem and make recommendations to technical staff to improve performance.
Reviewing the deliverables and ensuring the delivery is as per the quality standards.
Managing issues with client and providing resolutions by coordinating with on-site, offshore teams.
Environment: Oracle 10g, Toad 9.6.1, Putty 0.62, Windows 7, SQL*Plus, SQL*Loader
Oracle Developer Nov2008- Nov 2010
Yankee Candle, Deerfield, MA
Yankee Candle has become the #1 most-recognized name in the candle business and the country's best-selling candle brand. It’s the largest U.S. manufacturer of scented candles. Objective of the project is to replace the current Warehouse Management System (PKMS) with Manhattan Associates suite of products.
Responsibilities:
Wrote several stored procedures in PL/SQL. Wrote ad-hoc queries using SQL.
For better performance used EXPLAIN PLAN, HINTS to tune queries.
Created Tables, Views, Indexes and constraints.
Developed control scripts for SQL*Loader to load the data from flat files to Oracle Databases.
Involved in SDLC - Analyzed the existing partially developed tool. Provided input to the requirements analysis team and supported ongoing release activities.
Prepared the technical design documents (TDD) for most of the core modules of Project.
Developing, Testing and debugging the code according to business requirements
Environment: Oracle 9i, Oracle Pl/SQL Developer, PVCS, SQL*PLUS, Windows XP.
DB2DBA Sep 2005-Sep2008
I-flex business solutions, India
I-flex is of one of the world's largest business solutions providing its customers day to day database support.
Responsibilities:
Involved in Creating Databases, Table spaces and tables using CREATE command
Catalog and Uncatalog Databases.
Granted Privileges to the users for accessing user tables and system tables and buffer pools
Granted privileges for Binding a Plan and Package
Running Back up and Recovery Utilities like COPY, MERGCOPY, RECOVER
Responsible for providing database security by creating database Roles
Responsible for Constant monitoring of log and spool
Responsible for Running DB2 utilities like EXPORT, IMPORT, LOAD, REORG, REORGCHK, DB2MOVE and RUNSTATS
Responsible for Performing FTP of datasets from one LPAR to another LPAR
Providing support to application programmers in case of any issues
Moving System dumps from Fault Analyzer to test and production history log files
Responsible for DB2 Performance tuning and trouble-shooting skills
Involved in Monitoring the performance of the system using the TMON tool
Involved in Installing new product using SMP/E as per requirement
Responsible for providing on call support in 24X7 bases
Environment: IBM DB2 v9, AIX10.0
Contact this candidate