PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Business Intelligence, System Analysis, Data Integration & Migration, Designing and developing client server applications for various Data Warehousing projects.
• Over 4 years of development experience in creating highly interactive data visualization reports and dashboards using Tableau Desktop/Server.
• Expert in developing Business Intelligence reports/dashboards using different BI tools like Tableau & SAP Business Objects.
• Very good experience in installing, configuring, upgrading and managing Tableau server in cluster environment.
• Good experience in all aspects of project documentation, including functional, technical specifications, testing templates, ETL mappings etc.
• Very good experience in SQL tuning and dashboard performance improvement.
• Extensive experience in ETL analysis, designing, developing, testing and implementing ETL processes including performance tuning and query optimizing of databases.
• Strong understanding of OLAP, Data warehousing concepts, Dimensional data models, Star & Snowflake Schemas.
• Capable of working as a team member or individually with minimum supervision. Flexible to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Good communication and interpersonal skills with the ability to interact with end - users and managers.

TECHNICAL SKILLS:

BI Reporting Tools: Tableau Desktop/Server 9.x/10.x, SAP Business Objects 4.x/3.x, WEBI reports

ETL Tools: SAP BODS 4.1/4.0 (Data Integrator), IBM DataStage 8.x/7.x

Databases: SQL Server 2012/08/05, Oracle 11g/10g/9i, SAP HANA 2.0

Languages: SQL, C, C++, LINUX

Cloud Technologies: Amazon AWS

Other Tools: BI Launchpad, IDT (Information Design tool), Universe Designer, Oracle SQL Developer, Toad, MS Visio & Erwin data modeling tools.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Tableau Developer/Admin

Responsibilities:

• Installation and configuration of Tableau server in cluster environment.
• Performing administration tasks such as creating and managing users, sites, groups, setting permissions, providing access to the users using user filters and adding them to the specific group.
• Gathering and analyzing user requirements and designing software solutions for the proposed POC.
• Writing SQL queries in HIVE to extract source data from different data feeds to create reports and dashboards using Tableau Desktop as per the business requirements.
• Creating multiple workbooks and dashboards using Calculated fields, Quick table calculations, Custom hierarchies, Sets & Parameters to meet the business needs.
• Creating different charts such as Scatter plots, Dual charts, Bar charts, Line charts, Pie charts & text tables, highlight tables etc.,
• Building, publishing & scheduling customized interactive reports and dashboards using Tableau Server.
• Upgrading Tableau Server across all environments, migration and scheduling the extracts.
• Providing all the necessary documentation, updating tasks in Rally and training the business users.
• Performance tuning of the SQL’s while extracting source data.

Environment: Tableau Desktop/Server 10.2, HIVE (Drill Explorer), Amazon AWS, MapR Hadoop Hive, Rally, Windows Server 2012.

Confidential, San Francisco, CA

Tableau BI Consultant

Responsibilities:

• Gathering and analyzing user requirements and designing software solutions based on the requirements.
• Writing complex sql queries in Teradata to extract source data for creating dashboards using Tableau Desktop as per the business needs.
• Creating multiple workbooks and dashboards using Calculated fields, Quick table calculations, Custom hierarchies, Sets & Parameters to meet the business needs.
• Creating different charts such as Heat maps, Donut charts, Bar charts, Line charts etc.,
• Building, publishing & scheduling customized interactive reports and dashboards using Tableau Server.
• Creating actions, action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
• Providing all the necessary documentation and training to the end users.
• Implementing row level security as well as group/user level security for Tableau dashboards.
• Performing administration tasks such as creating and managing Users, Sites, setting permissions, managing ownerships, providing access to the users using user filters and adding them to the specific group.

Environment: Tableau Desktop/Server 9.1, Teradata 14, Windows Server 2012

Confidential, San Jose, CA

Tableau BI Consultant

Responsibilities:

• Gathering requirements from business users to build reports & dashboards in Sales and Operations, Planning, PO and Inventory modules.
• Write complex sql queries to prepare the data for dashboards as per the requirements.
• Developed visually compelling and actionable interactive dashboards for corporate users which show some of the KPI’s like Sales per Division, to track Shipments, Purchase Orders, Booking information etc.
• Developed forecasting and various trend reports by extensively using Advance analytics like Reference Lines, Trend Lines and Bands.
• Implemented row level security as well as group/user level security for Tableau dashboards.
• Developed different Tableau data visualizations using Line charts, Cohort charts, Box and Whisker charts, Scatter Plots, Geographic Maps, Cross tabs etc.,
• Converting existing BO 4.x reports & dashboards into tableau dashboards as per the business needs.
• Communicating with the server using TABCMD and TABADMIN command utility tool.
• Performed administration tasks such as creating, managing users, sites, setting permissions, managing ownerships, providing access to users using user filters.

Environment: Tableau Desktop/Server 9.x, SAP Business Objects 4.x, SAP Business Objects DataServices 4.1, Information Design tool, WEBI, SAP HANA 2.0, MS SQL Server 2012, Windows Server.

Confidential, Fremont, CA

BI Developer

Responsibilities:

• Gathered business requirements by interacting with the Users, Project Managers and other SME’s to get a better understanding of the business processes.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations to build dashboards.
• Created different KPI’s using Table calculations; LOD’s and calculated key figures (manipulating strings, arithmetic calculations, aggregation options and logical functions).
• Developed extremely complex dashboards using Tableau table calculations, quick filters, context filters, hierarchies, parameters and action filters.
• Set appropriate permissions Confidential the project level, work book level, data view level and data source level for Tableau server logons and security checks.
• Creating attribute views, analytic views, calculation views in SAP HANA.
• Worked extensively with advanced analysis Actions, Table calculations, Parameters, Maps, Trend Lines, Background images, Groups, Hierarchies & Sets to create detail level summary reports and Dashboards.

Environment: Tableau Desktop 9.x/8.x, SAP Business Objects 4.x, SAP Business Objects DataServices 4.1, MS SQL Server 2012, SAP HANA 2.0, Windows Server 2012.

Confidential, TX

BI Consultant

Responsibilities:

• Created ETL mapping documents to define data flow from different source systems to stage and then to the enterprise data warehouse as per the requirements.
• Consolidating 4 different rapid marts (GL, AP, AR, Sales) into a single rapid mart job using Business Objects Data Services 4.0 ETL tool.
• Developed an ETL process design using Business Objects Data Services 4.0 for extracting data from source database SAP and loading it into the target Datawarehouse.
• Expertise in working with various transforms such as SQL, Table comparison, History Preservation, Row Generation, Query, Map Operation, Merge, Look Ups, Pivot, Case etc.
• Created Universes and created WEBI reports on ad-hoc basis as per the business needs.
• Deploying and scheduling the consolidated rapid mart job and other Data Services jobs.
• Generate test data and tested the database to meet the functionalities/deliverables in the project documentation and specifications.
• Actively participating in the code reviews, meetings and solving any technical issues.

Environment: SAP Business Objects DataServices 4.0, Rapid Marts, Universe Designer, Web Intelligence, MS SQL Server 2008, Windows XP.

Confidential, Troy, Michigan

ETL DataStage Developer

Responsibilities:

• Worked with the end business users to comprehend their requirements in order to design and develop interactive jobs and reports that meet business expectations.
• Based on the discussion with the end users and the Interface Design documents provided, developed the Functional Requirement documents and Technical Specification documents.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Created Test Plans and Test Scripts for unit testing and Integration Testing and created implementation plans and implemented projects.
• Co-ordinate with Database Administrator to create appropriate indexes for faster execution of jobs and performed Performance Tuning.
• Created job sequences and job schedules to automate the ETL processes.
• Supported the offshore team in designing and developing the jobs.

Environment: IBM Infosphere DataStage 8.5, Oracle, PeopleSoft, UNIX, HP Quality Center, SQL Developer.

Confidential, Oakland, CA

ETL DataStage Developer

Responsibilities:

• Extensively used DataStage Designer to develop various Parallel jobs in integrating and loading data into target Enterprise Data Warehouse.
• Extracted data from different source systems such as DB2 database, Flat files, Datasets etc. transformed and loaded into the target tables of the Datawarehouse.
• Used the DataStage Director to run the Parallel jobs, scheduling, testing and debugging its components, and monitoring the resulting executable versions.
• Co-ordinate with Database Administrator to create appropriate indexes for faster execution of jobs and performed Performance Tuning.
• Created job sequences and job schedules to automate the ETL processes and implemented restart ability using various checkpoints.
• Performed unit testing on all jobs manually and monitored the data to see whether the data is consistent throughout the project life cycle.

Environment: IBM Infosphere DataStage 8.0.1, DB2, Oracle, UNIX, Microsoft Visio, Tortoise CVS.

Confidential, Columbus, OH

ETL DataStage Developer

Responsibilities:

• Worked with BA team on requirement analysis and issue escalation.
• Involved in mapping multiple data sources to a single target database by analyzing the business requirements that are specified in the functional documents.
• Created Technical Specification Documents (TSD) to map source and target attributes applying business rules and mapping logics.
• Building SQL queries to fetch the data from the Database as per the business requirements and use the SQL queries in the DataStage for further processing.
• Created reusable DataStage Shared Containers for all the common modules (e.g. using different code table values) to allow reusability of code.
• Performed unit testing on all jobs manually and monitored the data to see whether the data and the record count is matched.
• Designed and developed common modules for error checking (e.g. to check if the reject record output file is empty and to check if there are duplicate natural keys in a given table).

Environment: IBM Infosphere DataStage 8.01, Oracle 10g, UNIX, CLEAR CASE, HP Quality Center, SQL developer.