SUMMARY

• Around 6 (Six) Years of experience in IT System development which includes Tableau, Data Analysis, SAP BASIS and Business Intelligence Technologies
• Expertise in developing data visualization using Tableau Desktop versions 8.1/9.x/10, Tableau Reader, Tableau Public, and Tableau Server
• Technical hands - on experience with full range of BI Skills using Tableau 9X,10X Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS
• Expertise in Tableau BI reporting tools, Tableau Dashboards Developments & Server Administration
• Mastered in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Experience in configuring reports from different data sources using data blending
• Expertise in Tableau advanced analysis features like Actions, Calculations, forecasting, Parameters and Trend lines
• Proficient Star Schema dimensional modeling understanding business processes, modeling dimensions, hierarchies and facts.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections
• Experience in working/migration of data with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications.
• Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases namely Oracle, MS access and flat files
• Experience in writing complex SQL queries involving multiple table’s inner and outer joins, stored procedures
• Experience in using variables, expressions, functions and defining Query for generating drill down reports in SSRS
• Experience in all aspects of SAP Basis Administration including, upgrading by applying Enhancement Packs, Support Packs, Kernel Upgrades, performing Client Copy/ Export/ Import, System Copy/ Refresh, Spool Administration, Background jobs, Workload Analysis, Add-On installations, System Monitoring
• Efficiently worked on SAP Security Administration which included creating roles, profiles, users, authorizations, assigning authorization objects to roles, assigning roles and profiles to users
• Worked in a landscape involving around 500+ SAP instances, Oracle & SQL Server databases, Windows Server & AIX Operating Systems
• Responded to End-User requests according to Service Level Agreements (SLAs) and enforced Security practices and procedures consistently
• Experience in Analysis, Debugging & solving of SAP issues using - ABAP dumps, Backup issues, System log etc.
• SAP Solution Manager - Installations, Support Packs, Managed system Configurations, Early Watch Configuration, Proactive System Monitoring using Solution Manger alerts, Configuring Root Cause Analysis, Technical Monitoring, Maintenance Optimizer, and ITSM- Configuration & Setup
• Exposed to database utilities such as SAPDBA, BRTOOLS, BRSPACE, also have knowledge of database backups, restore and recovery

TECHNICAL SKILLS

Analytical Tools: Power BI, SAP Bex, MS Excel (VBA), SSAS, Power Query, SAP HANA

Reporting Tools: Tableau, MS SSRS, Crystal Reports, SAP Lumira, Qlikview

RDBMS: MS SQL Server 2005/2008 R2/2012/2016, MS-Access, Oracle 10G, IBM DB2

ETL Tools: SSIS 2008R2/2012, SAP BW, Informatica

SAP Domains: SAP BASIS, SAP Security & Auth, SAP ERP - MM, SD, HCM, SAP CRM

Programming Languages: SQL, R, HTML, Python, Java, DAX

Statistical Analysis Methods: Regression Analysis, Hypothesis Testing, ANOVA, Random Forest

Operating Systems: Windows server 2008R2/2012, IBM AIX

Software and Tools: MS Visio, MS Office, SAP (GUI, Web Portals), R Studio, SAP HANA Studio

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, Dallas, TX

Responsibilities:

• Gathered Techno- Functional requirements to oversee the end to end development and deployment of the solution
• Performed Extract, Transform, Load (ETL) from Different Data Sources including MS SQL Server and SAP BW
• Extracted data from multiple data sources namely MS Access, R, SAP BW and MS Excel performing Data Blending for further analysis
• Generated Workflows, Macros using MS Excel and MS Access in order to automate data extraction tasks from different sources for further complex reporting and dashboarding
• Augmented dashboards and reports by the use of calculated fields, hierarchies, mappings and drilldowns
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Verified and tested Dashboards to ensure data matching as per the business requirements
• 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

Tableau Developer

Confidential, Oklahoma City, OK

Responsibilities:

• Designed, developed, tested and maintained Tableau functional reports based on user requirements
• Developed Tableau reports using Combo charts, Heat Maps, Box and Whisker charts, Scatter plots, Geographic maps and Histograms
• Developed donut charts for analyzing sales planning data and different KPI's using Table calculations and calculated key figures, manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Line, data building Groups, Hierarchies and sets
• Designed and developed ETL (Extract, Transform and Load) to populate data from various sources using SSIS
• Performed Dimensional Data Modeling and Cube partitioning in SSAS
• Generated multi-parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports making them user friendly
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent
• Delivered SSRS reports using drill-down capabilities and graphical representation using charts and dashboards

Tableau Developer/ Data Analyst

Confidential, Dallas, TX

Responsibilities:

• Developed SSIS ETL packages in an extremely efficient way using package execution trees
• Delivered enterprise, web enabled reporting to create reports drawing content from disparate data sources
• Experimented using various advanced Tableau features namely Global, local, context filters, parameters and Groups enhancing reporting and dashboarding quality
• Developed complex reports using multiple measures like Individual Axes, Dual Axes and Blended Axes to demonstrate Sales KPIs, metrics namely Sales Funnel Leakage, Marketing Collateral Usage
• Created custom reports highlighting sales KPIs using complex stored procedures and Crystal reports
• Built and published customized interactive sales cycle metrics, revenue reports and dashboards on Tableau server
• Established the use of ETL capabilities on the Query Editor in Power BI to convert raw spreadsheet data to fine analytics-capable processed data further to generate reports
• Formulated complex calculated measures using Data Analysis Expression (DAX) enhancing the Quality of Sales Dashboards
• Developed complex SQL queries using common table expressions(CTEs) to support Power BI reports

SAP BASIS System Analyst/ Tableau Developer

Confidential

Responsibilities:

• Managed a team of 5 consultants acting as a liaison between the senior management and multiple technical teams
• Implemented Kernel Upgrades, Patch Upgrades, SAP Notes, Oracle DB Backup Scheduling, Early Watch alert scheduling and SAP Jobs scheduling
• Administered operational and technical issues on all the SAP systems, Databases leading to a reduction in the incidents by 30%
• Executed Oracle Database Refresh on multiple SAP ECC 6.0 systems successfully delivering them to the client 100% of the time
• Performed Client Copy, User Master Copy, Safeguard Transports and configured the SAP Transport Management System
• Administered the Oracle databases guarding the online /offline backups at the Unix/AIX level, monitoring and increasing tablespace using BRTOOLS and reviewing filesystem space issues
• Developed Trend Lines, Statistics, Log Axes, Groups, hierarchies, sets to create detail level summary report highlighting statistics related to SAP systems Incident, Change and Problem information
• Connected to Oracle databases directly creating the dimensions, hierarchies and levels on Tableau desktop
• Automated Oracle backup extraction data from URLs using Macros on MS Excel

SAP BASIS Consultant/Data Analyst

Confidential

Responsibilities:

• Prepared the business process and technical documents of implementing the SAP Business Suite earning accolades from the client
• Governed users, profiles and roles across SD and MM modules on SAP ECC 6.0 in co-ordination with functional consultants
• Acted as a shadow SAP BASIS Consultant during the SAP Business Suite Implementation including ERP 6.0, CRM 7.0, BI 7.40, SCM 7.0 and SOLMAN 7.1 for a distribution company
• Documented the entire technical and functional process of the SAP Business Suite Implementation earning accolades from the client
• Acquired Distribution metrics data from multiple data sources including MS SQL Server, Oracle onto Tableau for further complex reporting
• Created quick filter in Tableau to identify revenues generated in individual states, cities highlighting the distribution centers in each of them
• Employed different statistical analysis methods including Regression Analysis, Random Forest onto Excel to identify the factors affecting the distribution metrics namely Order Shipment Cycle Time, Customer Backorder Rate
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Created Database objects like tables, views, procedures, triggers, functions using T-SQL providing definition, structure and maintaining data efficiently

SQL Server Developer

Confidential

Responsibilities:

• Created and modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008
• Executed Database Administration activities including Index maintenance, Database consistency check, Updating Database Statistics and DR strategy
• Rebuilt indexes at regular intervals enhancing database performance
• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permission
• Configured and deployed SSIS packages from test to production environments
• Developed SSIS packages transferring data from different sources into the data warehouse further exploiting features like event handler, package configurations, checkpoints to manage the packages
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008 Reporting Services (SSRS)