SUMMARY

• Over 8+ years of experience in Data Warehousing and Business Intelligence solutions with expertise in Tableau BI Products. 4 years of experience on Tableau 10, 9.x/8.x product suite (Desktop, Server, Public, Reader, and Mobile) in Retail, Banking, and Health care sectors.
• Technically hands - on experience mainly with creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Actions, Dashboard color coding, formatting, Tableau designs, proto types and Tableau mock up reports, wireframes, frame works, design documents and reporting.
• Used Tableau Desktop for the Data Analysis, Visualizations and for the explorations.
• Used Tableau server for publishing the dashboards to the server, user management, user security administration and Content Restriction as a Tableau Server Administrator.
• Experience working as a Tableau analyst, Tableau Developer and Tableau Administrator and experienced as in using the Tableau BI Products, Tableau Desktop and Tableau Server.
• Experience in creating schedules and extracts in Tableau and .tde, .tdx, .twb.
• Good experience on Tableau server administration, monitoring server activities, identifying performance issues and updating software.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, SQL Server, Tableau, Informatica, SSIS, MicroStrategy, Business Objects, SSRS technologies.
• Experience in creating Aggregates, Hierarchies, Charts, Histograms, Filters, Quick filters, Table Calculations, Trend lines and calculates measures and more.
• Experience in creating Ad-hoc dashboards using joins, merges, sets and hierarchies.
• Experience in creating calculations fields to create complex dashboards using Live/ Extract.
• Experience in using Alteryx, Green Plum for the better usage of data.
• Expertise inPerformance Tuningof overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.
• Hands on Experience Dealing with the issues related to Performance problems, Database outage, server crashes, and Database recovery, integration and Optimization.
• Had Experience in Unit, Regression Testing and supported during UAT.
• Administered user, user groups, and scheduled instances for reports in TableauServer.
• Strong knowledge of SDLC Requirement gathering, analysis, Deployment, Test.
• Hands-on skills with use of action, user filters, advanced navigation techniques.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Proven myself as the self-motivated, energetic and well- balanced Business analyst as I am very much interested in what I am performing.
• Had good communication and presentation skills, can easily mingle with the people.

TECHNICAL SKILLS

Tools: Tableau (Desktop, Server, Reader, Online), CognosSSIS, SSRS, SAP BW/HANA, green plum, Hadoop, HIVE, TOAD, MicroStrategy.

Environment: Creating Reports and Dashboards with multiple sources, blending, groups, sets, coloring, different types of charts, storing data into EXCEL sheets, R, Python, Alteryx.

ETL Tools: Informatica, Talend

Language: C, C++, Java, HTML, XML, PL/SQL, TSQL, Visual Basic and UML

Web/Application servers: Tomcat, Apache

Databases: Oracle, SQL server 2000/2005/2008 , Teradata, MySQL, DB2

Scripting Languages: VB script

Operating Systems: Windows XP/VISTA/7/10, Linux and Unix.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Indiana

Sr. Tableau Developer

Responsibilities:

• Developed various data connections from data source to Tableau Server for report and dashboard development.
• Analyzing the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developing predictive statistical models using statistical analysis and other predictive Data Modeling techniques.
• As a Tableau Developer, using Tableaufor Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.
• Used Alteryx, Oracle, Netezza for the advanced data extraction.
• Had knowledge and experience in Regression, Performance and unit Testing and in UAT.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Work Sheet Actions, Functions, Connectors (Live and Extract), dashboard color coding, formatting and report operations.
• Experience in SAP HANA to accelerate business processes. Good understanding of SAP HANA architecture, user management and security.
• Experience in working with .tde, .tdx, .twb. and translating requirements to efficient reporting.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Extracted data from SQL and transformed them using Talend and other ETL tools.
• Extracted data from SAP and legacy systems (using DB connect). Involved in Generic Extraction of PCA data.
• Worked extensively to debug the existing SAP program and modify the code using modification assistant to customize the program as per requirements.
• Experience in gathering requirement from clients and used in deployment and SDLC.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed several database structures, Tables, SQL queries, stored procedures, views, triggers and user-defined functions to support business needs and reporting requirements.
• Created SSIS Packages using Execute SQL Task, Data Flow Task etc., to import data into the data warehouse.
• 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, 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.

Environment: Tableau Desktop 10, Tableau server, SQL server, Oracle, Alteryx, Python, MS EXCEL, Talend.

Confidential, Jersey City, New Jersey

Tableau Developer/ Admin

Responsibilities:

• Expertise in dealing with Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Worked extensively on multiple data connections using Data Blending and Data Joining, Integrating and optimizing. Worked on Data Extracts and managing queries.
• Experience in using .tdx, .tde, .twb for the storing and saving the data for further uses.
• Experience working with Agile - Sprint project Methodology.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, Dashboard reports etc.
• Strong knowledge in various reporting objects like Attributes, Hierarchies, Transformations, Filters, Prompts, Calculations, Sets, Groups, Parameters, Formulas etc.
• Experience in working with different data sources like Teradata, SQL, Netezza and Oracle using ETL tools like Tableau, Talend, Informatica.
• Expertise on tools like Toad, Autosys, and SQL Server Management Studio and involved in Unit testing, Functional testing and User Acceptance testing on UNIX and Windows Environment.
• Responsible for gathering the business requirements for the Initial PoCs to load the enterprise data warehouse data to Greenplum databases.
• Proficient in data integration between different sources to the EMC Greenplum and Netezza environment and reporting the same on Tableau environment.
• Experience in SAP BW to transform information virtually
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in TableauDesktop.Created and Published Tableau Dashboards into Tableau Server using Live/ Extract connections.
• Used Alteryx for tableau for the great usage of data.
• 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, Users and gathered requirement for deployment.
• Connected Tableau Desktop with Teradata to extract data from stored procedures and custom SQL to plan refresh timings and publish to Tableau server.
• Proactively communicate Tableau server issues and maintenance schedules.

Environment: Tableau Desktop 8 & 9, Tableau server, SQL Server, Oracle, Alteryx, R, Windows 8.

Confidential, Des Moines, Iowa

ETL Developer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Incoming data was loaded to the landing area and from there to staging area.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Participated in Transition management assist users and educate them on tableauad-hoc reports.Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins.
• Used Cognos for
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Performed data validation by Unit testing, integration testing and System Testing
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Involved in resolving reporting issues and design issues throughout the reporting life cycle.
• Worked with client and team members to understand and clarify visualization requirements.
• Worked on Data blending as well as newly introduced Cross data base joins.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Environment: Informatica PowerCenter8.6, Oracle 10g, PL/SQL, MS Access, Windows 2003 Server, UNIX, Cognos.

Confidential

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008. Created star schema in SSAS and developed SSRS reports based on the cube.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in the team with appropriate documentation and domain knowledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Interaction and coordination with end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Visio 2005, SQL Query Analyzer, SQL Developer.

Confidential

SQL Server developer

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries. Use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, Enterprise Manager, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.