SUMMARY

• Extensive noledge and experience of 5+ years on Ivalua
• Managed workflows for Contract authoring, Sourcing event auctions, Supplier Performance Metrics.
• Created a new module in Ivalua for ‘Opening tickets’ in Ivalua for Internal users and Suppliers users in Ivalua.
• Updating prices by suppliers via UI and scheduled jobs to import the updated pricing via ETL in XML format and XLSX format including driving the necessary notifications.
• Maintained users, their accesses, and user - supplier relationships in controlling the application.
• Worked as a point of contact for FTP upgrade and transfer of files from and to between Ivalua and McDonald’s.
• Involved in Migrating data from different Databases like Oracle, IBM DB2, Flat files, Webpages
• Over 5+ years of experience inTableauDesktop,TableauServer, andTableauReader in various versions ofTableau 10.3,10.2, 9.x, 8.x versions. Involved in beta testing on Tableau 10.4 and 1+ years of experience in Power BI.
• Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task
• Implemented Security by creating roles & web groups, checks wif External tables & LDAP.
• Experience inconfiguring reports from different data sources using datablending esp. on Vertica, Teradata alongside wif WebAPIs
• Experience in using pandas in Python to read data from large data sets and importin the data.
• Generated simple trends and patterns in Invoice data and login statistics using pandas
• Experience in generating automation scripts using Selenium to reduce manual effort.
• Extensive noledge of Business Intelligence platforms and processes across Insurance and Supply chain industries.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Knowledge wif MDX queries to design the cube efficiently and per the requirements.
• Experience in designing stunning visualizations utilizingobjects 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 business/client requirement.
• Has been working wif various data sources such as Oracle, SQL Server, ODBC and flat file sources.
• Experience intableauserver commands likesynchronization, Tabcmd andTableauserver backup activity and Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau Server and Reports.
• Knowledge of creating large enterprise reports, using charts, report parameters, dropdowns and images usingSSRS 2008.
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables.
• Experience in creating different visualizations usingBars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Strong noledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked wif high volume databases wif partitioned data.
• Experience in Database query performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time.
• Very good experience in Leadership, SDLC process and agile - SCRUM, waterfall methodologies.
• Excellent debugging, problem solving and testing skills.
• FirsTEMPthand experience in Data warehousing development using ETL tools such as Informatica Power Center and developed Informatica Mappings and Workflows wif Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.

TECHNICAL SKILLS

Tools: Tableau Desktop 10.x,9.x,8.x/7/6, Tableau Server 9.3,8.3/7/6, Power BI, SSIS, and SSRS, JIRA

RDBMS: SQL Server, IBM DB2, Teradata 12.0, Google Big Query, Oracle 12C/ 11G/9.x, MS Access, Vertica

SDLC Tools: Perforce, Team Foundation Server (TFS)

Languages: SQL, HTML, C, JavaScript

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

PROFESSIONAL EXPERIENCE

Confidential, Downers Grove, IL

Sr Ivalua Developer / Sr Supply Chain Systems Lead / Procurement Analyst

Responsibilities:

• Configure and enhance Ivalua procurement software to provide a custom solution for McDondal’s, CSCS, and Denny’s clients.
• Expertise in the Ivalua data model and responsible for creation of the queries and Stored Procs necessary towards the generation of reports and dashboards.
• Maintain Item, Supplier, DC, Contracts master data and create designs to connect them wif Inventory and Invoice data
• Worked wif spend volumes of > $30,000,000,000 for McDonald’s and > $30,000,000 for Ihop and Applebees and > $30,000,000 for Denny’s restaurant groups.
• Interact wif business stakeholders, gathering requirements and managing the delivery.
• Escalate issues wif DCs, Suppliers, and customer as appropriate
• Knowledge and experience on working wif Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS
• Manage overall system health including automated jobs, system performance monitoring and troubleshooting.
• Create and enhance complex end user reports and audits
• Generate Ad-Hoc reports/dashboards to communicate the requirements wif the customer and convert user stories into designs
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Groups, hierarchies, sets to create detail level summary reports and dashboard using KPI's.
• Generated data models wif Power BI and created visualizations based on live and extract data from more TEMPthan 10 data sources in a dashboard.
• Created Private and Shared workspaces, assigning user privileges to dashboards, reports, workbooks, workspaces wif Power BI
• Administered user, user groups, and scheduled instances for reports in Power BI, Tableau and Ivalua application.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop Expert in generating complex, dashboard reports, ad-hoc business views along wif user acceptance test and data accuracy test.
• Involved in creating dashboards and reports in Tableau 9.3 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Coordinated database middleware issues wif DBA's, system performance wif System Architects.
• Created organized, Defined best practices for Tableau report development.
• Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Create training workshops and provided user manuals for the users to interact wif the Dashboards.

Environment: Ivalua, Tableau Desktop 10.2/9.3/8.0 , Tableau server/Administrator, SQL developer, SSIS, Power BI, Oracle 10g, Microsoft Excel 2007, Python 3.x, pandas, Google BigQuery, MS Access, JIRA

Confidential, Jacksonville, FL

Tableau Developer

Responsibilities:

• Responsible for the creation of Tableau Dashboards to meet the requirements of the stakeholders
• Responsible to coordinate wif the other teams to acquire the data accordingly and coordinate wif all the Tableau developers for the smooth process of development, troubleshooting and enhancement of the data
• Worked extensively on preparing the data and embed the dashboards using JavaScript and .Net.
• Generated dashboards that is consumed by multitude of users including Medical Directors, Business Analysts, Doctors, Health Care Providers…
• Managed claims data to generate the dashboards for the end user to see the lowest level of granularity on the dashboard.
• Current data is over 800 million rows + Data blending to consume 3-Zip codes for maps. Generated the required custom models to accommodate all the data into the dashboard.
• Expertise in performance tuning of the dashboards, and the backend database.
• Passed URL Filters through .net to filter the data on the embedded dashboards.
• Generated logical models for ETL team to load the data that was supplied by the stakeholders.
• Conducted user trainings and created user manuals for the stakeholders (Business Analysts, and Medical Directors) for using Tableau
• Responsible for testing and moving the dashboards between environments.
• Responsible for maintaining the specs mentioned in the Technical Design template for all the dashboards generated and was involved in the upgradation of the same document.

Environment: IBM DB2, Tableau Desktop 9.3/9.2, Tableau Server, Microsoft Visual Studio, Microsoft Visual Basic, Netezza, Tortoise version control, RedShift, IBM DataStage, ERWIN.