Suyog Shah: in Fullerton, CA

Technology stack: SAP Business One, Advanced Excel, SQL server. • Generated high-quality database solutions and implemented optimized stored procedure and functions. • Explored required data and built appropriate and useful deliverables. • Examined existing SQL queries and suggested new queries for performance improvement. • Coded and tested SQL queries based on persistent table via inline views, Dynamic SQL and Merge statements. • Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non-clustered indexes. • Translated business requirements into BI application designs and solutions. • Installing and configuring business applications based on SAP. • Developing and designing process to integrate Business One with third-party applications. • Planning project schedules. • Supervising and maintaining MS SQL backups and SQL servers. • Recommending and responding to issues and questions regarding software implementation. • Creating reports by using queries, user-defined fields, formatted searches and user-defined tables. • Conducting training for users on SAP functionality. • Assisting users regarding screen and menu development to streamline their process flow. • Produced attractive visuals/dashboards to convey the story inside the data. • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. • Involved in trouble shooting of performance issues which were associated with Tableau reports and administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server. • Supported Data team for effectively loading Master Data Warehouse • Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies. Triage data related issues • Assist in troubleshooting and impact analysis of any changes made to the database Objects • Optimize SQL performance, integrity and security of the project's databases/schemas. Contribute to the optimization of data management and performance tuning • Work as data steward in maintaining data integrity of transactional and referential data. Define & maintain business and technical rules for cleansing and maintaining data. Enforce data quality standards • Develop triggers and stored procedures to manipulate data • Clean, transform and model data to ensure and improve accuracy of metrics calculations • Create, modify and troubleshoot SQL queries, stored procedures and jobs. • Collaborate with product managers, software engineers, application architects, and DBAs, to assess technical requirements and make recommendations where appropriate. • Performed tuning and trouble-shooting of applications, modules and reports to improve performance and minimize system resource constraints. • Lead deep dives into complex business logic and exiting SQL to do root cause analysis • Design, analyze and modify SQL and TQL views, stored procedures, and functions

Technology stack: Tableau, Advanced Excel, Python, SQL server. • Analyzed Nissin's delivery network by plotting a route map in Tableau to identify potential routes to save freight costs by 15% • Constructed OTIF (On Time In Full) dashboard for Nissin's supply chain centers in North America using Tableau and SQL • Involved in performing Profit & Loss analysis by Customer by Product for the company, gathering the data from General Ledger entries using SQL queries. • Created Quadrant Analysis dashboard in Tableau for Nissin's Customer*Product base representing Marginal Income and Year over year growth. • Developed Bracket compliance dashboard in Tableau that helped Company save Freight costs and identify the unnecessary subsidy given to customers. • Developed several auto update-able dashboards in Tableau like Case Fill Rate, Demand & Planning Accuracy, Trade and Actuals etc. • Generated the Daily Sales Progress report of the Company in Tableau with drill down and filter capabilities that is used by Field to perform better Forecasting. • Created business specific SSRS reports and Data Dumps using SQL queries.

Technology stack: SAP Business Objects, Tableau., Advanced Excel, IBM Cognos, SQL server. • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options. • Supported reporting capability for 200+ users across Sales and Operations teams. • Developed and maintained more than 20 Business Objects reporting constructs. • Identify and gather detailed business requirements, create technical documentation, clarify, interpret and translate specifications as required to develop an appropriate information solution. • Reduced client's manual task (5 days a month) by 90% by implementing SAP Business Intelligence and automated regression. • Liaised with Business Objects end-users to design and develop Universes to suit their standard and ad-hoc reporting requirements. • Built Tableau Dashboards with interactive views, trends and drill downs along with user level security. • Assigned users access to their reports, dashboards, storyboards and query and analysis documents through BI Launch Pad thereby resulting in increased security and efficiency.

Technology stack: SAP Business Objects, Advanced Excel, IBM Cognos, SQL server. • Migrating Business Objects reports from XI R2 to XI 3.1 Version. • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. • Configured servers, created user access levels and scheduled reports based on recurrence. • Generate and validate design specifications for new reports or reporting solutions, configuring servers, creating user access levels and scheduled reports based on recurrence. • Trained end users in understanding the canned report and how to develop adhoc reports for data analysis. • Designed aggregation tables and look up tables to improve report performance. • Generated statistical reports, financial reports and other analytic reports; analysed data from different levels of detail and from different viewpoints. • Documented reporting methodology and analysis reports created ER diagrams in MS Visio. • Writing and editing of SAP BEx queries using Query Designer. • Creation and maintenance of OLAP universes sourced from BEx queries.

Technology stack: SQL, SSMS, Python, Tableau, Advanced Excel, Microsoft Office • Used regression analysis and forecasting to improve efficiency by 13%. • Converted and enhanced Cognos into Web Intelligence, Crystal, and Xcelsius reports with SAP data. • Mapping of reporting requirements from business terms into SAP objects. • Writing of test scripts for accuracy, formatting, and performance • Performed data integrity checks, data cleaning, exploratory analysis using Python and Tableau. • Collaborated in writing test plans and analysis for A/B, multivariate testing of marketing campaigns. • Performed cost benefit analysis on sales and expenses data to publish daily, weekly reports using Tableau. • Developed data models for cost and profit optimization using Advanced Excel (Pivot table, VLOOKUP, Macros) • Involved in creating admin roles, Installations and built Xcelsius reports for top level management. • Created Single sign on between SAP enterprise portal and BI and BO systems and dash boards for the top level management using BW data. • Designed universes based on SAP BW info cubes, creating backup and recovery plan for BOE servers. • Designed Xcelsius reports for SAP sales and distribution info cube, daily dash boards for region wise sales and setting up live office files to pick up data from SAP on a daily basis. Daily sales, revenue, booking dashboards. • Proficient in managing SQL database tables and optimized SQL query performance by using Indexes, joins, subqueries resulting in an improved efficiency by 30% in production environment.