Data Analyst @ • Leading the business requirement activities necessary to define reporting needs, design and developing dashboards and reports using GoodData cloud BI and MAQL.
• Solving ad hoc data questions faced by our clients and client support team using complex SQL queries against MySQL.
• Supporting Marketing team in identifying opportunities for product improvements including developing affiliate marketing initiative test case scenarios.
• Interpret research and app analytics data and explain their implications for business, sales and finance strategies.
• Analyzing impressions, visits, clicks and other metrics for new marketing strategies rolled out on our partnered loyalty websites. From February 2015 to Present (11 months) San Francisco Bay AreaBusiness Data Analyst @ • Interpreted and evaluated market survey data for all Ultra High touch customers of Cisco Systems and developed integrated business analyses and projections for strategic decision-making.
• Customer excellence dashboard is developed for all Ultra High touch customers. Metrics including On-Time-Shipment, Lead Time Attainment, Lead Time As scheduled, Aging Backlog, End-to-End Order cycle and Perfect order were provided on QoQ and YoY.
• Evaluated market surveys by pulling data from multiple survey sources like ForeSee, Verint and Walker using complex SQL queries.
• Worked hands-on with the team to develop a risk model to identify customer sentiment analysis.
• Developed periodic performance reports and distributed them to stakeholders.
• Developed customer excellence ad-hoc reports in Tableau environment and shared it across with stakeholders.
• Assisted business users in month end and quarter end audits for supply chain business unit. From June 2014 to February 2015 (9 months) San Francisco Bay AreaBusiness Intelligence Business Analyst @ • Translated Enterprise bookings and discounts business requirements into functional design solutions, support development, testing and release activities.
• Adhered to the IT SDLC and ensured the Bookings business follows required processes and standards.
• Worked with Partner Operations stakeholders as IT SME/ETL Lead for building VMware
Partner Data Automation Project.
• Supported and maintained VMware compliance, HR inventory and Intellectual Property reports.
• Developed and supported existing Bookings OBIEE Dashboard into Tableau Environment using
Tableau Desktop and Analytics with wide expertise in Visualization techniques.
• Analyzed metrics for better understanding and formulated, presented relevant actionable
recommendations to business during months and quarter ends and Management buy-outs (MBOs). From May 2013 to December 2013 (8 months) San Francisco Bay AreaBusiness Intelligence Data Analyst @ • Analyzed NetApp expense procure-to-pay requirements in the areas of Oracle GL, AP, PO, PR, vendor invoices and Oracle Financials AR, revenue subject area; Supported the team building the reports using OBIEE.
• Actively participated in data modelling in the capacity of an IT Data analyst.
• Reconciled and tested Finance Business Intelligence (FBI) reports and assessed readiness and deviation of product/project performance based upon results and design specifications.
• Handled the various aspects of the end to end lifecycle related to complex data warehousing and
business intelligence projects.
• Extensively involved and supported developing reports with inputs from the assigned Business Analysts.
• Worked in a cross functional environment engaging with Business, Development, QA and Operations team; well versed with the onsite-offshore development model. From January 2011 to December 2012 (2 years) San Francisco Bay AreaBI Developer @ Informatica ETL developer, developed ETL source to target mappings, designed ETL logic and implemented mappings for slowing changing dimension target tables and change data capture methodologies for data warehouse. Actively participated in Data modeling (LDM/PDM) for business deliveries across different subject areas.
Created dashboards using OBIEE and worked in a cross functional environment engaging with business, development, QA and operation teams. Assisted business users in month end and quarter end audits. From August 2008 to December 2010 (2 years 5 months) San Francisco Bay Area
Bachelor of Engineering (B.E.), Electrical and Electronics Engineering @ Osmania University From 2004 to 2008 Sandeep Shayini is skilled in: Data Warehousing, Business Intelligence, Oracle, Data Analysis, OBIEE, Business Requirements, Data Quality, Informatica, SQL, Data Modeling, Procure-to-Pay, Financial Reporting, Salesforce.com, ETL, SDLC