Shyam Nelapatla

Results driven professional with wide ranging 15+ years of experience in enterprise applications and in building analytics and data warehouse solutions from the ground up, with global development and engineering teams. Successfully built transformational analytics big data solutions across multiple paradigms (OLAP/OLTP, ODS based, Hadoop based solutions, Cloud adoptions) from product and enterprise analytics. Wide experience in the areas of Enterprise Data Management, Business Intelligence, Analytics, Data Architecture, Data Governance, and Compliance. Proficient in data driven decision making built with an iterative approach and strong collaboration with business partners, IT, vendors, and management.

• Stanford University, Redwood City, CA, Business Intelligence Manager, 09/2019, Current, Manage all Enterprise BI, Financial Reporting, and Data Management Projects Infrastructure, with a team of BI Leads/Architects and Developer and consultants, Strong experience in scoping, estimations, resource planning, budgeting, and project management., Hands-on with BI tools, end-to-end delivery process, enterprise BI frameworks, Data warehouse (Enterprise Data Warehouse (EDW), Operation Data Store (ODS), Data Lake, Snowflake, etc.), data management, data governance, and building frameworks for enterprise operation excellence., Managed & migrated legacy on-premises servers to Amazon Web Services (AWS) → Improved Disaster Recovery, improved data reliability and availability, Implemented POC migrating legacy data marts to cloud using Snowflake as part of cloud initiative.
• Arlo Technologies, San Jose, CA, Analytics Manager (Joined through Netgear spin-off), 06/2018, 09/2019, Successfully led BI Systems separation from Netgear spin-off for Day1 readiness., Managed Corporate Analytics for Demand Planning, Sales, Operations, Finance (FP&A, Revenue, and Accounting), and Audit business teams., Managed 3 tracks for E-commerce project (Reporting, Audit, Security) for launching Arlo E-comm store., Leading Solution Architecture, Design and Development for data lake and reporting through Informatica, OBIEE, Tableau and Snowflake applications, Lead Google Analytics 360 for tracking Sales and Marketing effectiveness to measure conversions., As a track owner for Security for E-comm project, partnered with Vendors to perform Threat Model to identify assets, threat agents, trust zones, potential threats and existing controls. Also performed Penetration Testing to assess applications ability to resist common attack patterns and identifying vulnerable areas in the internal and external interfaces that may be exploited by malicious user., Responsible for security risk analysis of the product and ensure third party product compliance., Process owner for GDPR account close requests across Engineering and Corporate, CRM systems.
• Netgear, San Jose, CA, BI & Hyperion EPM Manager, 06/2016, 06/2018, Managed BI and EPM projects and been SME for Informatica, OBIEE and Tableau Applications, Prioritized Monthly release and forecasting cycles with Finance FP&A and Revenue teams, Supported cross functional business and IT teams for sustain and projects, Led Hyperion EPM and OBIEE upgrade projects for on time completion., Lead as Project Manager and Solution Architect, autonomously, a team of both onsite and offshore consultants and to provide the reports, measurement of the metrics, dashboards and business intelligence to the product group, Played both PM and Technical manager role for Netgear/Arlo Systems separation for EDW, Informatica, Tableau systems. Upgraded to OBIEE 12c for Arlo spun-off., Led GDPR project partnering with vendors to document data flow maps of Netgears’s business process flows, capture related data elements into an Article 30 Data processing Inventory. Captured identified risks and issues within a consolidated Risk Inventory.
• JDS Uniphase, Milpitas, CA, OBIEE/Informatica Solution Architect/Project Lead, 04/2012, 05/2016, Led and Performed OBIEE upgrade from 10g to 11.1.1.6.6 including Informatica upgrade from 8.5 to 9.0.1, Responsible for Enterprise wide support for the EDW and OBIEE and Informatica applications in the areas of Finance, HR, Supply Chain, Order Management, Agile., Implement Data Level and Object Level Security, by creating Session/ Dynamic Repository Variables and Initialization Blocks in OBIEE repository., Manage application build, prepared reports, test planning and execution Plans and also prepared user guides for the use of OBIEE Analytics., Managed group of contractors and vendors to see end to end delivery, Demonstrated BI capabilities to C-Level Execs through iPad app for Booking, Billing, Backlog & HR data
• Symantec Inc., Mountain View, CA, Technology Solutions Manager/Project Lead, 08/2010, 03/2012, Project Lead: Manage the Data Warehouse (EDW) and Operational Data Source (ODS) and CRM (Siebel Analytics), EDW/ODS/Siebel Analytics SME: Responsible for Enterprise wide support for the EDW and ODS, Siebel Analytics environments. This includes: content management, enhancements, system integrations, and key relationships with upstream source SME(s)., Responsible for assessing customer requirements from a business and technical perspective, and designing solutions to meet these requirements, Developing road maps describing the integration of all legacy VeriSign enterprise solution portfolios from current state to future state, Identified and retired some legacy VeriSign applications saving ~500K, Manage technical assessment and design activities for enterprise technology projects, Assist with governance activities associated with ensuring solution architecture, Ensure alignment of technical solutions with established IT standards and business objectives., Identify root cause for technical issues in a conclusive manner by applying analytical thinking and quantitative tools/methods.
• VeriSign Inc, Mountain View, CA, Technical Lead DW/BI OBIEE, 03/2007, 08/2010, Responsible for technical design of interfaces from Source Engineering (Transactional) system to Staging to Siebel OLTP as part of CRM Automation project, Create solution and technical design for reporting in OBIEE Siebel Analytics., Identify Business Model and Security (Determined Facts & Dimensions, Date & Time relationships, Granularity, Data Consistency across Dimensions and Identified Business Users & Group Security), Coordinate project work with offshore counterpart team for executing the technical details of the project, Design and implement custom business intelligence solutions .rpd, and configured metadata objects, web catalog using OBIEE Siebel Analytics., Designed and Developed solutions for Data cleansing using BO DQ XI for Data Quality., Develop OBIEE Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model, Implement security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security., Involve in the phase of Data Model Design and Documentation (Facts and Dimensions), Work on ETL process using Informatica for various transactions and loading data from Relational Database and Flat Files., Provided full life-cycle support to the Informatica, OBIEE environment.

• Hands on experience in design, development in Data Integration tools i.e. Informatica, Snowflake), visualization i.e. Oracle Business Intelligence, Tableau and defining/driving enterprise strategy and migration and adoption of cloud technologies, including evaluations and POCs. (AWS)
• Proficient and experienced in presenting and driving discussions at the executive level (CIO/SVP/VP) with end-to-end responsibilities from concept-to-reality. Strong business collaboration (KPI, data governance and delivery, process optimizations reduction)
• Built data models for business/end user consumption with enterprise (structured) and unstructured, web logs, web analytics combined models, scalable, secure, cloud based and highly available.
• Excellent communicator and team builder with a track record of problem solving and employee development. Practice Management based on core values: strong empathy, fear less problem solving, deep expertise, client focused, nurtured creativity, cultivate ownership, and accountability with in team