Data Developer

Arpitha

Contact: 571-***-****

Email: ****.*****@*****.***

Summary:

Having 8+ Years of experience on Business Intelligence Applications

* ***** ** ********** **** Tableau -Developed Tableau Workbooks, Views, Dashboards, Scorecards, and in creating data extracts for optimized loads, Tuned Server and Dashboard Performances.

Experience in Installation, Configuration and administration of Tableau Server in a multi-server environment.

Tuned Tableau Server and Dashboard Performance-Reduced Tableau Views load times to 5 seconds,Used Incremental Extracts to reduce extract refresh times

Worked with Different Databases like SQL Server, Oracle,DB2, MS Access.

4 years Experience with SAP Business Objects- Created Business Objects Repositories, Designed Universes, Developed Full Client Deski / WebI reports with multiple Data Providers, free hand SQL, stored procedures, Combined Queries ;Used functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Break ; Implemented security at row level, Object and Report level; Installed,Configured and Optimized BO Servers

Good Understanding of Data Warehousing concepts like Star Schema and Snowflake Schema, Data marts, Kimball Methodology used in relational, dimensional and multidimensional modeling.

Strong analytical and conceptual skills in database design and heavily involved in designing and developing database schemas and database objects like Tables, Views, Functions, Stored Procedures, Triggers, Cursors, Synonyms and other DB objects in SQL Server 2000/2005/2008 and Oracle 8i using Toad and SQL Developer.

Proven ability to work with senior leadership to align business objectives with information technology.

Experience:

General Motors, Detroit Jul 2013 -Present

Tableau Developer/ Admin

Responsibilities:

Worked closely with the Business Analyst to get requirements from the business. Done Whiteboarding

and mockups of charts, got the sign offs by the Business on the Requirements documents

Created Tableau worksheets, designed, developed dashboards and published to server.

Data is pulled from multiple datasources and blending is done on Tableau workbooks.

Used sheets as quick filters to overcome Tableau Quick filter limitations when multiple datasources are used

Used Advanced table Calculations

Used Actions in order to provide additional drill down functionality and used Hyperlinks to navigate to other tableau reports. Passed Values from Summary to Detail workbooks

Used Dynamic X axis and Dynamic Y axis so that business can select Dimensions and Measures dynamically from Parameters

Set Up permissions for Tableau Views and Dashboards.Created Users,groups,projects.

Used TABCMD to develop automatic batch scripts to schedule extract refreshes after ETL refreshes and to refresh dashboards,export to csv and pdf files and email these files to business

Used TABADMIN for Tableau backups and restores

Used 'User Filters' for row level data security

Set up best practices for Tableau development and administration

Used Full Set up best practices for Tableau Data Extracts, Tableau Dashboards

Tuned Tableau Server and Dashboard Performance-Reduced Tableau Views load times to 5 seconds,Used Incremental Extracts to reduce extract refresh times

Installed and Configured Tableau Server, Performed Upgrades to 8.0 from 7.

Created Custom date calculations for Point in Time Analysis

Built Custom Dashboards to monitor Tableau Sever –Top 10 widely used dashboards, Peak times of server usage, Top 10 users etc.

Unit Tested the reports for Interface,Data and Build Defects.

Used queries in Sql Server Management Console

Visualizations used-Bar in Bar,Pareto,Maps,Scatter,Line,Heat Maps. Used Combo Charts

And Dual Axes

Environment: Tableau 8.2/ 8.1.4, Sql Server, SSIS,Windows 2008

Philips Healthcare,Atlanta April 2012 –Jun 2013

Tableau Analyst/ Developer

Responsibilities:

Developed Tableau Views/ Vizs for over 30 metrics for Call Handling, Customer Satisfaction and Time to resolve metrics (Customer plank), Utilization, Effectiveness, Compliance metrics(Operational plank),Operational Costs, Service Cost metrics(Financial plank), Skillset Development And Employee Satisfaction (Employee Plank)

Created Executive Scorecard that provides information about how agents of a Functional group have performed with respect to various metrics for an year and month . Key metrics like Avg Talk Time, Cases Per Head, Training Compliance, First Visit fix rate, OT Percent etc are shown on the scorecard

Installed and Configured Tableau Server in a multi server environment

Developed and tested Tableau Workbooks, Dashboards, Scorecards using Tableau Desktop

Created Projects and Groups, Set up permissions, Server Security

Published Reports, workbooks & data source to server and exported the reports in different Formats.

Different datasources used for Dashboards: Oracle, Excel files, data Extracts, Custom sqls

Scheduled extract refreshes

Visual Analysis using Tableau Desktop- Created Dashboards, Scorecards, Calculations and Filters, Parameters, Maps and Geocoding,

Created Custom date calculations for Point in Time Analysis

Used several types of charts- Bar, Line, Pie, Pareto, Heat, Scattered charts

Performed source data assessment and identified the quality and consistency of the source data.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

Set up best practices for Tableau development and administration

Prepared Test Data and Validated programs and the reports against the oracle 11i database

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle, MS Excel

Dell, Austin Feb 2011 –Apr 2012

Tableau Developer

Responsibilities:

Interacted with users to collect and address business and technical requirements; translated business requirements into technical requirements and specifications.

Installed and Configured Tableau Server.

Developed and tested Tableau Workbooks, Dashboards, Scorecards using Tableau Desktop.

Created Projects and Groups, Set up permissions, Server Security.

Published Reports, workbooks & data source to server and exported the reports in different Formats.

Different data sources used for Dashboards: Oracle, Excel files, data Extracts, Custom sqls

Scheduled extract refreshes

Visual Analysis using Tableau Desktop- Created Dashboards, Scorecards, Calculations and Filters, Parameters, Maps and Geocoding.

Created Custom date calculations for Point in Time Analysis.

Used several types of charts- Bar, Line, Pie, Pareto, Heat, Scattered charts.

Performed source data assessment and identified the quality and consistency of the source data.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Set up best practices for Tableau development and administration.

Prepared TestData and Validated programs and the reports against the oracle 11i database.

Environment: Tableau 7, Windows 2008, oracle 11g, TOAD

Accenture,Austin Oct 2008 - Dec 2010

SAP Business Objects Developer

Responsibilities:

Spearheaded the Business Objects 6.5 to XI 3.0 migration project. Designed and implemented the roadmap for migrating Business Objects the deployment from 6.5 to XI 3.0

Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications

Created scripts for Oracle Tables, Indexes, Users, Roles, views and Stored Procedures and Functions using SQL,PL/SQL

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

Prepared operation instruction manuals to business users

Set up best practices for all Business Objects development and administration

Prepared Test Data and Validated programs and the reports against the oracle 9i database

Created, and optimized Business Objects Universes for Financial, Procurement and Fixed Assets using Designer

Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up Categories using Central Management Console

Created Financial, Procurement and Fixed Assets reports and Xcelsius Dashboards.

Created HR Reports like Grant Certification, Leave Accruals, W2 Audit, Payroll, CIGNA, Retirement Projections, Pension Enrollment etc

Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, prompts

Tuned Universes, created Contexts and Aliases for resolving Loops, Fan Traps, Chasm Traps, and checked the Integrity of the Business Objects Universes

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure

Created Indexes and Summary tables for improving the performance of reports

Designed and Developed Datamarts using Star Schema and Snow Flake Schemas

Environment: Business Objects XI R3(Designer, Desktop Intelligence, Central Management Console, Web Intelligence, Xcelsius, Websphere), Windows 2008, oracle 8i

Goldstone Technologies Feb 2007 – Sep 2008

SAP BO Admin Engineer - SAP Business Objects German Support

Responsibilities:

Support to BMW SAP BO customers worldwide.

The main responsibility is to troubleshoot customer issues; provide technical help in resolving issue and use follow up procedures to ensure customer satisfaction.

Planning, Installation, Sizing and configuration all the BO Servers, BI4.0 Servers & XI 3.1 Servers.

Setup of the Business Object Desktop and Server products.

Worked on User Management tasks.

Implemented and managed the BO Security Model.

Modifying the Sever properties like (sizing, timeout, cache size, session timeout, etc.) from CMC.

Created the New Custom Access levels and Enable the Auditing on BOE 3.1.

Configure Windows AD, LDAP and configuring trusted authentication in BOE 3.1 and SAP BI 4.0 along with single sign on (Including 3rd Party Tools).

Experience in migrating from one environment to another environment using Import wizard, LCM.

Upgraded Management Tool in BI4.0 and troubleshooting the issues that arise in Migration.

Extensively worked on Report Conversion Tool for converting the Desktop Intelligence Reports to Web Intelligence Reports.

Maintain Virtual Servers.

Provided 24/7 Production Support.

Environment: Business Objects 6.5(Designer, Desktop Intelligence, Central Management Console, Web Intelligence, Windows 2003, oracle 8i

Contact this candidate