SUMMARY

• Over 7+ years of Data warehousing experience with Business Intelligence Tableau 9.0/8.2/8.1/8.0/ 7.0 , OBIEE, SAS, OLTP and OLAP Microsoft SQL Server, Microsoft Excel as a Developer in various companies.
• Reports development using various reporting tools like Tableau.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Provided 24/7 customer support to tableau users.
• Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring backups of Tableau repository.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
• Created incremental refreshes for data sources on Tableau server.
• Creating users, groups, projects, Data connections, settings as a Tableau administrator.
• Extensively worked on Tableau Administrator and Tableau Server.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Involved in creating various SAS Reports that includes Charts, Filters, Scorecards, Drilldown and Drill - Through, Cascade, Parameterized reports that involved conditional formatting.
• Quick learner and good performer both in team and independent job environments.
• The ability to analyze truly big data at interactive speeds using Teradata.
• Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation, Data Warehouse (Design, Implementation & Support).
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server.
• ExtensiveDimensional Modellingexperience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Extensivelyworked on databases likeOracle, SQL Server, DB2.
• Strong programming and debugging skills inPL/SQL, SQL and Unix shell scripting.
• Experienced in developing complexpackages, procedures, functions, triggers, views.
• Extensive experience in entireSDLC.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts.
• Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Pivot table, Chart, Column Sector, Narrative view) with local and global filters using OBIWeb.

TECHNICAL SKILLS

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Data Warehousing ETL Tools: Informatica Power Center 8 .X,7.X, Data Cleaner 2.2

Databases: Oracle 11g/10g/9i, MySQL, SQL Server, Teradata

Database Tools: TOAD, SQL Developer, SQL Plus

Reporting Tools: Tableau 8.2,8.1/8.0/7.0,SAS,OBIEE 10.1.3x/11g (Oracle BI Interactive Dashboards, Oracle BI Administration Tool, Oracle BI Answers, Siebel Analytics, Oracle BI Delivers)

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks, CA

Tableau Data Analyst/Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet.
• Involved in installation of Tableau desktop 10.0, Tableau server Application software.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 10/9.x. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Involved in creating ad hoc analysis and reporting requests in a timely manner for BML Risk related to fraud Approval's, Declines daily, monthly and yearly.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Deep experience with the design and development of Tableau visualization solutions.
• Provided 24/7 production support for Tableau users.

Environment: Tableau Desktop 10.1/9.x/8.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008.

Confidential, Colorado Springs, CO

Sr. Tableau Developer

Responsibilities:

• Involved in all phases(SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears and Kmart Complex reports and Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Environment: Tableau9/8/7.0, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential, St Louis, MO

Tableau Developer/BI Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current services by color that was broken into regions allowing business user to understand..
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, Teradata and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target and Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Involved in importing Source Tables from the different databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop v8.x/7.x, Reader, SQL Server 2005, Windows 2000 Server, MS Excel, MS Access.

Confidential, CA

Oracle/Tableau Developer

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with Business.
• Participated in all phases including requirement analysis, Client Interaction, designing and testing
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, and Dimensional tables.
• Enhanced the Previous ETL process with new features by exploring areas of improvements like data quality, data masking, slowly changingdimensions andperformance enhancements. Implemented best practices for development in all the environments.
• Developed number of complex Informatica mappings and custom transformations to implement the business logic and to load the data incrementally.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Worked on Migration of User Developed Applications/reports from Mainframe SAS to SAS EG in order to optimize the execution time, resources and to reduce the cost of process
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL
• Usage of SQL loader to load data from external files that is exported from Server
• Wrote UNIX shell scripts to spawn the Loader job for daily load of data.
• Developed static and dynamic parameter files for reusability and database connection management among development/testing/production environments.
• Development of shell scripts to access informatica workflows for scheduling
• Design and development of business objects universe for adhoc reporting and web-intelligence reports.
• Developed reports with features like drill down, slice and dice, master/detail for analysis of business.
• Created different reports containing charts showing end of day trade details and statistics.
• Utilized SAS to Create complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plans.

Environment: Oracle, Informatica Power Centre 7.1, Tableau, SAS, PL/SQL, SQL Developer.

Confidential

Informatica Developer

Responsibilities:

• Create informatica mappings to build business rules to load data.
• Used Informatica power center to extract, transform and load data from multiple input sources like Oracle and flat files to target data base Oracle 8i.
• Used mapping designer and mapplets to generate different mappings for different loads.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Used various transformations like source qualifier, expression, filter, lookup, update strategy transformations etc.
• Designing, Scheduling & Monitoring of workflows.
• Development of reports using OLAP tool Business objects 5.1.
• Optimizing/Tuning mappings for better performance and efficiency.
• Involved in Unit Testing.

Environment: Informatica 8.1, Oracle 8i, Windows

Confidential

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Visio
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in SQL server agent for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2005
• Written SQL queries and stored procedures to generate data for reports.
• Involved in testing the triggers and procedures to be used in the production for optimization and improving the performance.

Environment: SQL Server 2005, Management Studio, Windows XP, Oracle 10g, Excel, PL/SQL Developer 1.1.3, TOAD, Unix