PROFESSIONAL SUMMARY:

• Qualified professional with 8 years of extensive IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications in Healthcare, Finance, Automobile and Wholesale industries.
• 3 yearsof experience as Tableau Developer onTableau 7.x/8.x product suite(Desktop, Server, Public, Reader, Mobile).
• Experience in Operational Data Store (ODS), Business Intelligence, Database Modeling, Data Warehousing concepts, OLAP, ETL tools and reports generation.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators.
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using Scatter plots, Gantt Charts, Bubbles, Geographic Map, Histograms, Bullets, Heat maps and Density Chart.
• Expert in creating Calculations (Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensivelyused Business ObjectsEnterprise Xi3.1/XiR2/Xi/6.5,Informatica Power Center, Business ObjectsData Integrator,and SQL Server, Oracle 11g, Teradata and DB2.
• Highly Proficient inAgile, Test Driven, Iterative, Scrum and WaterfallSoftware Development Life Cycle (SDLC).
• Knowledge on SSIS/SSRS and Built prototype reports from excel spreadsheets during the requirement gathering phase to visualize the reports and clarify requirements.
• Experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise inperformance tuning of loading the OLTP Transactions and integration of the data intoData Warehouse (EDW)and Data Marts.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Strong understanding ofData Warehouseconcepts, Star Schema, Snowflake Schema, Business ProcessAnalysis, Physical andLogical data modeling.
• Proficient in creating Use Cases, Data Flow Diagrams, Sequence Diagrams, Class Diagrams, State Transition Diagrams, ER Diagrams etc.
• Actively participated and conducted JADsessions with business users, technical leads and with development personnel in all aspects of theSDLC.
• Extensively involved inReverse-Engineeringand Business Rules Extraction, Expert inproject planning,strategic planning,systems analysisandtroubleshooting,quality control, forecasting, scheduling, planningand tracking of results.

TECHNICAL SKILLS:

BI Tools: Tableau( Desktop/Server/Mobile/Public), Crystal Reports XI, XCelsius, Business Objects, SSRS

ETL Tools: Informatica, Data Stage, SSIS

Databases: SQL Server, Oracle, MS-Access, DB2, Teradata, Oracle.

Database tools: SQL Enterprise Manager, TOAD, Teradata SQL Assistant

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio

Scripting Languages: C, C++, HTML, SQL, PL/SQL, XML, VB

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Design/Version Control: UML, Rational rose

Operating Systems: Windows Server 2000/2003/2008 , Windows 98/2000/XP/VISTA/7, OS 400

PROFESSIONAL WORK EXPERIENCE:

Confidential, Lexington, MA

Sr. Tableau Developer

• Designed and constructed real time dashboards for sales and marketing teams using Tableau.
• Implemented report development methodology for operational analytics group.
• Provided business intelligence guidance to business operation analyst groups.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies.
• Creating data blending while designing a dashboard reading data from different datasets.
• Extensively worked on Tableau dashboard and SQL query optimizations and response monitoring.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Motion Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Worked extensively with Advance analysis Actions, Drill-Down Analysis, 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 and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, and Production environments.
• Deployment of Tableau reports, creating project folders and assigning user/group permissions.
• Worked creating Aggregations, Calculated fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created actions in worksheets and dashboards for interactivity and to compare data against different views.
• Created and managed tableau server groups and permissions.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.
• Restricted data for particular users using Row level security and User filters.
• Consulting with business partners on reporting requirements and deciding business strategies for slice and dice analysis.
• Conduct demonstration for business users and interacted with end users.

Environment: Tableau Desktop 8.2/8.1/8.0, Tableau server/administrator, SQL developer, SQL 2008, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0

Confidential, El Segundo, CA

Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them technical specifications.
• Building and publishing customized interactive reports and dashboards reports in the Tableau Server.
• Effectively used Data blending, groups, combine fields, Dual Axis, aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created parameters, quick filters, context filters and Sets to display top result set which changes dynamically.
• Experience in creating sets, joins, hierarchies, filters, global filters, table calculations, calculated measures and parameters.
• Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.
• Developed various dashboards, work books and data views depending upon the business requirements and published in the tableau server.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Definedbest practices for Tableau report development.Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Published the developed dashboard reports on theTableauServer so that the end users having access to the server can view the data.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Developed Parameter based reports, Drill-down reports, Matrix reports, Charts and Tabular reports and enabled ad-hoc reporting with report builder.
• Executedand tested requiredqueries and reportsbefore publishing.
• Creating test case for each data view in the Tableau.

Environment: Tableau 8.0/8.1, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Oracle.

Confidential, Issaquah, WA

Sr. Business Intelligence / Tableau Developer

Responsibilities:

• Used Oracle warehouse builder tool to enact some ETL processes required as per data architecture and mappings.
• Modified and updated current universes working on the OLTP data architecture for various business changes using designer.
• Developed complex universes by using advanced features in Business Objects like Aggregate Awareness and prompts.
• Created several Business Objects reports and scheduled them via Info view.
• Created users, users groups and maintained user access rights for Business Objects universes and reports using Central Management Console.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Various kinds of the transformations were used to implement simple and complex business logic to load the tables in staging area using data integrator.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality. Created hierarchies, prompts and aggregate awareness
• Tested reports for query optimization and performance before posting them to the repository.
• Involved in creating data models and building data marts. Used business objects data integrator tool to load tables and run the batch process.
• Analyzed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL.
• Prepared Dashboards using calculations, parameters in Tableau and also created Dual Axis, Data blending for merging data between two data sets, created calculated fields, groups, sets and hierarchies etc.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc. Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logon’s and security checks.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Provided on-going production support for Business Objects End Users in the final stages of the project.
• Trained the users to use reporting interface and to create ad-hoc reports based on their needs.

Environment: Crystal Reports Xi r2, Tableau Desktop 6.02, 7.0, 8.0., Tableau Server / Administrator, SQL Developer, SQL 2008, Oracle 10g, ETL.

Confidential, Racine, WI

Sr. Business Objects Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications
• Involved in gathering the requirements from BusinessManagers for reports development
• Designed and developedUniversesas per report requirements of Businessanalysis
• Identified the Metrics and sub metrics, Key performance indicators(KPI’s) for Dashboard development
• Worked onmultipledata providers to develop the dashboards coming from different sources
• Involved in bug fixing for invalid data flows, Work flows and projects, testing of Stored Procedures and Functions, Testing of Data Integrator jobs, and the Target DataWorked withContexts and Aliasesto resolve theLoops in Universes
• Managed Users, Groups and their access privileges on the documents
• Extensively worked with BODI Transformations like Reverse Pivot, Map Operation, Table Comparison, Effective Date, History Preserving, Row Generation, Key Generation, Query, Case, Merge, and Pivot
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by contexts
• Creating various UDF’s in the database for data retrieval in complex reports
• Monitoring the daily job scripts for loading the data about business transactions from source systems to EDW
• Created Stored Procedures while generating the reports and tested them against Oracle Database
• Tuning SQL query performance, working with data warehouses, managing metadata, and developing Web services using DB2
• Used Data Integrator Administrator for scheduling the jobs and validation of the jobs before executing them

Environment: Business Objects Xi3.1, Xi r2, Crystal XCelsius 2008, QAAWS, Designer, Desktop Intelligence, Web Intelligence, SQL Server 2005, Oracle 9i, Teradata, Windows XP

Confidential

SQL Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program and Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Performed optimization of indexes and queries by using index tuning wizard to enhance the performance.
• Performed extensive database activities such as data modeling, database design, data analysis, validation and Data migration (import & export/BCP) from Text to SQL Server.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinated post-implementation events such as testing and configured replication server.

Environment: SQL Server 2000, SQL Server 2005, Import& Export Data, ER-Win, T-SQL, Excel, Access and Windows NT.