SUMMARY

• Over 7+ years of IT Experience in design, analysis, development and implementation of Various applications in Client/Server OLAP environment using BI Tools in Manufacturing, Retail and Financial industries
• Extensively worked on Tableau 6.x/7.x/8.x (Desktop, Server, Mobile, and Public), Micro Strategy, Business Objects and SSRS.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Managed cross - functional teams through Software Development Life Cycle.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working 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.
• Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata,, Informatica UNIX, DB2, Oracle and SQL Server technologies.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• 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.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio).

TECHNICAL SKILLS

BI Tools: Tableau Desktop 8,Cognos 10.2/10.1/8. x suite(Framework Manager, Query Studio, Business Insight Advanced, Report Studio, Analysis Studio, Metric Studio and Event Studio)

ETL Tools: Informatica, DataStage

Web server: IIS Web Server, Apache, Tomcat

Databases: Oracle 8i/9i/10g/11g, Teradata, MS SQL Server 2005/2008/2012 and DB2

Tools: MSExcel,MSWord,MSPowerPoint, MS project, MS Front MS Expressions Web, TOAD, Sql Developer, Sql Star Plus.

WEB Technologies: JavaScript, XML, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Tableau Developer

Responsibilities:

• 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL server 2008/2012

Confidential, San Jose, CA

Sr. Tableau Developer

Responsibilities:

• 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.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that build tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.
• Working with User for requirements and part of the team developing the software.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Experienced in developing Dashboards using Xcelsius 2008.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely with Data Modelers in designing various data warehouse schema techniques
• Create complex reports against SAP BEx Queries.
• Created the reports on the web by using Web intelligence .
• Worked on the data provider that forms the basis of the ad-hoc analysis

Environment: Tableau Desktop 8.1/8.0/ 7.0 SQL Server 2008/2012, Info view, Windows 2008 Server

Confidential, Los Angeles

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office

Confidential

SQL Server Developer

Responsibilities:

• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Transferred flat files from different sources to the Staging Area by using SSIS and executed BCP from a package to import all files to pre-staging database.
• Worked on different kinds ofTransformationsinSSISas per the client requirements.
• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Understanding the OLAP processing for changing and maintaining the Data Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on the business requirements to change the behavior of the cube by using MDX scripting.
• Worked with database designing physical and logical database design.
• Coordinated with back-end programmers in optimized stored procedures, implemented referential integrity by using triggers, worked on performance tuning.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Created database objects on the Staging Area to ensure the consistency and integrity of my database.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent. Experience in using Performance Monitor/Profiler to solve Dead Locks.

Environment: SQL Server 2005, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SSAS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in logical modeling and physical modeling of the database.
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity.
• Created audit trails of activities on database using triggers on backend.
• Implemented the business logic and processing of the payment by developing stored procedures and scripts.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Environment: MS SQL Server 2000, T-SQL, Visual Basic 6.0 and windows NT.

Environment: SQL Server 7.0/2000, T-SQL, VB 6.0, Windows NT/2000 server.