Summary
Overview
Work History
Education
Skills
Personal Information
Certification
Timeline
Generic

Surendra Babu

McKinney,TX

Summary

Extensive 20 years of IT experience with an emphasis Data Engineering, Designing, Development of Data Warehouse, Data Lake, Data Modeling, Business/Data Analysis, and Big Data Analytics. Implementation of several large-scale projects and design for the integrated business intelligence framework including Data Warehousing, Data Lake, and Analytics. Led multiple roles – Solution Architect, Data Architect, Primary Technical Lead, IT Engineer, and Operations Lead. Data warehouse Technical Lead / Data Architect with more than 15 years of experience with in-depth knowledge in Sales, Finance, Supply Chain, Subscription, service & Marketing functional domains. Successfully Migrated the legacy Datawarehouse systems to new platforms by enforcing Data modeling guidelines and Standards. Involved End to End Project Implementation which include read data from on premise, Azure DB, or Web API into Azure Blob, Azure Data Lake, and then Prepossessing it using Azure Data bricks and storing the data into Azure Data Warehouse for further processing. Experienced in gathering requirements and translate them to logic data model and physical data model with complete data profiling activities. Experience working with Data bricks notebooks & integration of the notebooks with Azure Data Factory. Working experience on python libraries, data validation. Specialties: Data modeling, Dimensional Modeling (Kimball Star, Snowflake, and Inmon ER Model) OLAP&OLTP Architecture, Data profiling, Dataflow Design, Architecture Governance and implementing cyber security standards. Enterprise Data Warehouse (EDW), Data Mart, Data Lake, and Data Engineering and Azure Cloud technologies. Work experience in all the respective database technologies like Teradata, Vertica, MSSQL, Oracle, Azure Synapse and Bigdata platforms (Hive, Presto, Scala and Spark). Processing structured, semi-structured and unstructured data. Building data pipelines with Various ETL tools and Azure SQL DW. Developed Snowflake scripts, Stored Procedures and Tasks to load data from stage (ADLS Gen2) to Snowflake raw layer. Created dedicated Snowflake Virtual warehouses for high data volumes meet critical business slas. Deigned Data sharing objects with different business partners for both snowflake and non-snowflake users. Developed Snowflake external tables for Business to explore the data. Developed snowflake UDTFs to reuse common logic across multiple queries. Assisted the data scientists with building features and deploy them into production using snowflake ML and governed the models using snowflake registry. Generated GENAI and large language models (LLM) apps using snowflake Cortex. Designed and developed snowflake data masking polices for sensitive data. Have experience in creating pipeline jobs, schedule triggers using Azure data factory (ADF). Excellent verbal, written communication skills; ability to interact professionally with diverse groups including executives, managers, and subject matter experts and adapts to modern technologies, circumstances, and environments. Background includes data mining, warehousing and analytics. Proficient in machine and deep learning. Quality-driven and hardworking with excellent communication and project management skills. Respected [Data Architect] with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Data Architect

HP Inc
04.2015 - Current
  • Serving as Solution Architect responsible for enterprise BI and Analytics architecture, product definition, Data Modeling, design, and delivery phases
  • Responsible for Data architecture design and decision
  • Design and implement data schemas and both logical and physical models for a data warehouse
  • Designed logical and physical data models for Sales and services functions and designed data flow starting from data ingestion, Transformation, and consumption layers
  • Designed the Base and Derived products to decouple risk source data latency issues and upstream system changes
  • Generated the reports for supply chain team and senior leadership on KPIs and performance metrics and deliver presentations on findings
  • Delivered BI solutions to get a comprehensive glance at the company’s various business functions performance (Financial, Customer, Innovation/Strategic, Operational and People) to support executive QBR meetings thereby enabling business agility
  • Led and architected BI applications working with geographically dispersed teams (Malaysia, Mexico, India, France, and USA)
  • Participated in implementing and adopting industry best practices on data management like defining data policies, standards, guidelines, architecture, and coached team members to follow the defined standards
  • Designed and developed data ingestion pipelines from on premise to different layers into the ADLS using Azure Data Factory (ADF V2)
  • Established Data Lake and Azure Cloud Data governance and conducted knowledge sharing sessions across multiple groups
  • Supported the HP split into two companies (HP Inc
  • And HP Enterprise) to clone the applications for supporting business continuity
  • Designed conceptual and technical architecture to build snowflake Datawarehouse for sales function
  • Transformed the data from snowflake to create QBR reports for Product and salesforce cast reports
  • Designed and developed ingestion patterns for Batch (Task) and NRT (snow pipe)
  • Designed and developed consumption layer from raw layer using Stored procedures and tasks
  • Used Snowflake transient tables in lower environments for cost optimization.

Tech Lead/Data Architect

Consulting (Cisco systems Inc San Jose)
04.2009 - 04.2015
  • Served as Data architect/E lead and led BI track in creation of Cisco’s Cloud XaaS (X as a Service) strategy to align with key market shifts along with customer and partner demand for greater flexibility and lower costs, are providing Cisco with opportunities to transform Collaboration, Video, Services, and Mobility offerings through cloud-based delivery and flexible consumption models (FCM)
  • Planned and managed BI strategy of operational reporting and sales performance metric requirements for XaaS Cloud offers, Software as a service and FSM Models
  • Worked with Enterprise architects to lay out the foundational architecture for XaaS model in Enterprise data warehouse
  • Performed the data analysis and validations for end-to-end order flow and bookings and revenue recognition
  • Designed Data flow approach to allow the XaaS bookings and Sales order data to Enterprise Bookings SSOT
  • Worked closely with QA and Support teams to migrate the code to Production
  • Developed the ETLs using Informatica and Teradata scripts to load the data from ERP systems to EDW
  • Involved in SQL Query tuning and provided tuning recommendations
  • Integrated WebEx data-warehouse with Cisco’s Enterprise warehouse providing a unified view for reporting processes and providing cost savings to by cutting down the manual processes
  • This program saved $ 200K per quarter on support and infrastructure costs
  • Performed systems study and prepared integration strategy for data and reporting applications
  • Provided resource and cost estimates to prepare data integration road maps and project plans
  • Designed ETL approach working with enterprise architecture team and data modelers
  • Built dimensional models and designed reporting solutions, taking inputs from WebEx team
  • Developed the ETLs using informatica, PL/SQL and Teradata utilities and collaborated closely with offshore team.
  • Enhanced data quality by designing and implementing efficient data models, schemas, and storage techniques.
  • Streamlined data flow by integrating various data sources into a unified system for seamless access and analysis.
  • Improved database performance by optimizing queries, indexing strategies, and overall architecture design.

Sr. IT Engineer

Consulting (Stratapps Sunnyvale)
06.2008 - 03.2009
  • Implemented BI solutions to collect and report near real revenue and streaming statistics for Zillion TV, which is content streaming provider
  • Developed the PL/SQL procedures to collect the customer streaming statics when customer watches the content
  • Exposure on informatica server administration and worked as ETL architect

IT Engineer

Cisco Systems
10.2005 - 06.2008
  • Involved in data migration from Oracle DW to Teradata for better end user reporting query performance
  • Designed Error handling and Audit strategy processes
  • Performed the data analysis on source systems and Existing Oracle DW for history migration and incremental data flow to new Teradata DW
  • Design and developed the ETLs and fine-tuned Informatica mappings and PL/SQL procedures to improve ETL load time
  • Managed the offshore ETL Development team and provided Subject matter expertise on functional areas
  • Design and Developed Business Object universe and developed ad hoc reports based on user reporting needs
  • Provided the operational support for Production data issues.

Developer

Satyam Computers
04.2004 - 08.2005

Education

Bachelor of Science - Computer Science

Acharya Nagarjuna University
Guntur
03.2001

Skills

  • Data Analysis and Problem solving
  • Big Data and MPP technologies
  • Enterprise Architecture and Data Integration
  • Data Warehousing/Business Intelligence/Analytics
  • Virtualization and Cloud solutions
  • Data security policy design
  • Data Modeling
  • Business Requirement Gathering
  • Azure Cloud ADLS Gen, DW, ADF, Azure Data Bricks, Azure Synapse and Power BI
  • Snowflake, Snow sight, snowflake cortex, snow pipe snow park ML and snowregistery

Personal Information

Title: Data Architect

Certification

Azure Data Engineer

Timeline

Data Architect

HP Inc
04.2015 - Current

Tech Lead/Data Architect

Consulting (Cisco systems Inc San Jose)
04.2009 - 04.2015

Sr. IT Engineer

Consulting (Stratapps Sunnyvale)
06.2008 - 03.2009

IT Engineer

Cisco Systems
10.2005 - 06.2008

Developer

Satyam Computers
04.2004 - 08.2005

Bachelor of Science - Computer Science

Acharya Nagarjuna University
Surendra Babu