SUMMARY:

• Eight years experience on Business Intelligence and ETL Applications
• Four Years Experience developing Tableau Views, Dashboards, Scorecards, created data extracts for optimized loads, Tuned Server and Dashboard Performances,
• TwoYears Experience wif SAP Business Objects - Created Business Objects Repositories, Designed Universes, Developed Full Client reports wif multiple Data Providers, free hand SQL,
• Twoyears Experience wif Pentaho DI/ETLLoaded data into STAGE/ARCHDATA/DW/DM by using Transformations/Jobs which consists of 150+ Transformations and 30+ Jobs all together using SMART Master ETL Job.
• Proficient in Data warehousing, Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, DB2 UDB, SQL Server 2000,

TECHNICAL SKILLS:

Software: Tableau 8.3, 9,Business ObjectsXI R3.3,R2

Database: Oracle 11g-9, MS SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential, Roswell, GA

Tableau Developer

Responsibilities:

• Worked on Customer Care and Aftersales (CCA) project.CCA makes sure that teh parts for services and repairs for every GM vehicle sold in North America are available when they are needed. CCA provides these parts through our two well-known brands: Genuine GM Parts and ACDelco.
• Developed Vehicle Profitability and Sales Dashboards,VehicleInventory,Vehicle Parts Supersession Workbooks etc
• Worked closely wif business and data teams to gather key stakeholder requirements and convert them into technical specifications. Conducted Business Acceptance and user Acceptance testing and sign-off meetings
• Used URL actions to navigate from Summary Views to detail views, Used Highlight and filter Actions,Parameters,Quick Filters,Calculations
• Used Summary and Detail Queries for Summary and detail workbooks to implement
• Drill down functionality. Used Filtervalues to pass teh values in teh URLs from Summary to Detail workbooks
• Set up Security table and used calculated fields in Tableau to implement Row Level Security
• Used Table Calulations-Created fields to calculate Year to Date,Month to Date, used
• Tableau lookup functions for 3 week decline in sales calculations
• Extensively used Bar, Bar in Bar, Line Charts, Scatter Charts, Maps
• Used Dual Axes,Implemented Dynamic X axis and Dynamic Y axis using parameters
• Created Reference lines, color coded various metrics based on teh threshold values
• 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
• Created datasources - set up joins, Dimensions, Measures, Calculated fields, Groups, Sets, Parameters and published them to Tableau server for Self Service BI. Business users can create AD Hoc reports based on these datasources
• Installed and Configured Tableau Server, Performed Upgrades to 9.0 from 8.0,
• Set up Projects,Groups, Users and set up Permissions
• Set up schedules,tasks,monitored extracts to see if there are any failures
• Used tabadmin for Tableau data backups and restores
• Used automated scripts and windows scheduler to take backups automatically
• Installed Postgres database, configured PG Admin3 and accessed/ monitored all teh Tableau Server Repository tables for default tableau profiles. Created custom dashboards on these repository tables to analyze different server statistics

Environment:Tableau 9/8.3, Oracle 11g,DBVisualizer

Confidential, Atlanta GA

Tableau Developer and Admin

Responsibilities:

• Designed Dashboard Landing Page where most of teh metrics are grouped into Customer,Operational, Employee and Financial planks.
• Developed Tableau Views/Vizsfor over 30 metrics for Call Handling, Customer Satisfaction and Time to resolvemetrics (Customer plank),Utilization,TEMPEffectiveness,Compliance metrics(Operational plank),Operational Costs,Service Cost metrics(Financial plank),Skillset DevelopmentAnd Employee Satisfaction (Employee Plank)
• Implemented ETL to Extract and Transform data from text files, SQL Server 2005 instances and to load into Staging Database. Teh main purpose to load into staging database was to change all string values to integer and load to Data Warehouse for further Data Analysis by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension.
• Created different user level groups, and assigned appropriate permission level to teh database using Credentials tool. dis made sure that only teh right person wif enough authorizations would be able to see their corresponding Information
• Created Executive Scorecard that provides information about how agents of a Functional group has performed wif 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 teh scorecard
• Installed and Configured Tableau Server, Performed Upgrades to 8.0 from 7.0,
• Set up Projects,Groups, Users and set up Permissions
• Used URL actions to navigate from Summary Views to detail views, Used Highlight and filter Actions,Parameters,Quick Filters,Calculations
• Used 'User Filters' for row level data security
• Used Bubble Charts, Maps, Bar charts, Line Charts,Scatter charts
• Used Full Set up best practices for Tableau Data Extracts, Tableau Dashboards

Environment:Tableau 8/ 7, Windows 2008 server, SQL Server 2008

Confidential, San Jose,CA

Tableau /Pentaho ETL Developer

Responsibilities:

• Interacted wif users and Gathered, addressed 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 teh reports in different Formats.
• Used Pentaho inbuilt Change Data Capture utility (CDC) to get teh data from source system/ Load data into Data Mart(DM)
• Created Database logging for each Transformation/Jobs into ETL PDI TRANS and setup Email notification failure on each Component level.
• Implemented Logic wif Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• 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 teh quality and consistency of teh source data.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions wif programs/interfaces
• Set up best practices for Tableau development and administration
• Prepared TestData and Validatedprograms and teh reports against teh oracle 11i database

Environment:Tableau 7, Pentaho DI,Windows 2008, oracle 11g,Oracle AERS, TOAD

Confidential, MD

Business Objects Architect/ Developer

Responsibilities:

• Interacted wif 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 wif 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 teh reports against teh oracle 9i database
• Created, and optimized Business ObjectsUniverses for Financial, Procurement and Fixed Assets using Designer
• Performed Administrative tasks like Setting up user profiles, assigning rights and privilegesfor 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 teh Integrity of teh Business Objects Universes
• Implemented Security Features of Business Objects like row level, object level and report level to make teh data secure
• Created Indexes and Summary tables for improving teh performance of reports
• Designed and Developed Datamarts using Star Schema and Snow Flake Schemas

Environment: Business Objects(Designer,Desktop Intelligence,Central Management Console, Web Intelligence,Xcelsius, Websphere), Windows 2003, oracle 9i

Confidential

Business Objects Developer

Responsibilities:

• Designed ODS, dimensional data marts, and data warehouses
• Generated, published and scheduled reports in Web Intelligence..
• Worked wif Java Developers to integrate Business Objects wif teh Insurance Application
• Involved in tuning performance of reports by creating aggregate tables
• Setup and maintained user security using Supervisor..
• Provided End-user support and training.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Business Objects 6.5, Oracle 8i,Crystal Reports 9.0