SUMMARY

• Having 10+ years of experience in IT industry, and 5+ years of experience in Tableau and 2+ years in SAP HANA.
• Involved in development and implementation of SAP BI. Worked extensively on various functionalities of BI.
• Strong and experienced team player, with excellent communication and interpersonal skills. Proven ability to work independently.
• Able to learn new technologies, concepts and Business processes quickly, evaluate their applications, and apply them to business need when appropriate.
• Worked on Data Modeling, Data Provisioning, Reporting.
• Experience working on HANA Enterprise - Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.
• Excellent knowledge and experience on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA.
• Experience in Data-Provisioning techniques using SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Calculated Fields, Sets, Groups, Parameters etc., in Tableau.
• 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, Donut Charts, Lollipop Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Knowledge on Tableau extract API and converting CSV files to .TDE files. Good Knowledge on embedding dashboard into a webpage.
• 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
• Experienced in writing complex TSQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex-SQL Stored Procedures and constructingTables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
• Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.
• Expertise in various phases ofproject life cycles (Design, Analyzing, Implementation and testing).

TECHNICAL SKILLS

SAP In-Memory (HANA): Data Provisioning (Flat Files, SLT for SAP & Non-SAP, DXC)Information Models (Attribute view, Analytic View, Calculation View, CE functions)

SAP BI/Reporting: BEx (BEx Query Designer, Web Application Designer, BEx Analyzer), Lumira.

SAP EDW: SAP NW BI 7.x, SAP BW 3.x.

ETL: SSIS, Informatica 9.x

ERP: SAP R/3 4.7, ECC 6.0.

Tableau: Tableau Server, Tableau Reader, Tableau Desktop 8.x/9

Database: MS SQL server, DB2, Oracle, HANA

Operating System: Win 8.1/8/7/Vista/XP/2000/NT/ME/9x, MS DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE

CONFIDENTIAL

Tableau Consultant and SAP HANA Modeler

Responsibilities:

• Tested all the BI existing functionalities are working fine in HANA similar to ORACLE database. This will ensure business continuity with planned DB migration.
• Involved in creating Packages, Schemas, Tables and Information views like Attribute views, Analytic views, and Calculation views(SQL Script based and graphical based).
• Tested BI reporting performance and data loading performance by reconciling the results in Oracle and HANA databases.
• Good exposure on various components of SAP HANA.
• Developed use cases in HANA side car and tested by replicating the data using SLT.
• Designed and DevelopedSAPHANAartifacts such as Attribute Views, Analytic Views and Calculation Views.
• Created Composite Calculation views that includes variables, input parameters and calculated columns.
• Applied knowledge of Normalization and De-Normalization techniques. Writing queries to createstored procedures, User Defined Functions, Views, TriggersandCTEs (Common Table Expressions).
• Using all kinds of SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Performance tuningof Stored Procedures and T-SQL Queries.
• Created logins, users and configuring permissions and assigning roles to users.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts fortuningandscheduling. Performeddata conversionfrom flat file into a normalized database structure. Created newSSISpackage to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio(BIDS)and Visual studio 2008.
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• 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.
• Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Confidential, Baltimore, MD

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Installed and managed MS SQL Server 2005.
• Extracted data from xml and flat files using SSIS
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Confidential, Jacksonville, FL

Tableau Consultant

Responsibilities:

• Scope of the project was to enhance the Insurance App's systematic processes. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability to get better understanding of future enhancements.
• Designing and developing the SSIS Packages.
• Involved in creating writing the scripts for creating tables, functions and views.
• Involved in client interaction and reviews and actively participated in solving the issues.
• Created and managed schema objects such as tables, views, procedures, and functions.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications.
• Implemented BCP/ETL Scripts for data transformation.
• Development of data extract, transform and load (ETL) programs using Microsoft SQL Server, including T-SQL, DTS and SSIS.
• Resolve SQL Job failures.
• Involved in end to end implementation and enhancements on insurance agent's App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App's by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Insurance App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.