Prasad Kumar Boddu Email & Phone Number

Idaho, United States

Designed and optimized Snowflake data warehousing solutions to improve data storage, retrieval, and analysis.Led an offshore team, fostering a collaborative environment and mentoring team members to enhance technical skills and productivity.Developed Data Vault 2.0 models to ensure data accuracy and consistency, collaborating with cross-functional teams to align with business requirements.Built and maintained ETL pipelines using BODS, AWS Glue, Lambda, and Airflow, streamlining data integration to enhance quality and accessibility.Implemented performance tuning to optimize query efficiency, reducing execution times and organizational costs.Experienced in using DBT to transform raw and staged data into business-driven views.Ensured data governance, security, and compliance by overseeing data access, encryption, tagging, and row-level access policies.Automated processes to improve scalability and reduce manual interventions, enhancing operational efficiency.Communicated effectively with stakeholders, translating business needs into technical solutions aligned with organizational goals.Maintained documentation for data warehousing solutions, including architecture diagrams, data dictionaries, and metadata management.Demonstrated expertise in Snowflake core concepts like recovery methods, cache usage, Streams (CDC), SnowSQL, Snowpipe, data sharing, UDFs, zero-copy clones, time travel, micro-partitioning, stored procedures, data import/export, RBAC, and resource monitoring on AWS/Azure platforms.Worked with SAP Supply Chain, Logistics, and FICO module data.Applied Agile methodologies to ensure project success.Tech Stack: Snowflake, AWS S3, Glue, Lambda, Matillion, DBT Cloud, SAP ECC, SAP BW/HANA, S4/HANA, HANA Studio, BODS 4.2, MS SQL Server, SQL, ER Studio, Python, Snowpark, Power BI, DOMO Reporting Tool.

Pheonix, Arizona

• Design, implementation, and optimization of Snowflake data warehousing solutions, enabling efficient data storage, retrieval, and analysis for the organization.• Directed and managed a diverse offshore team, fostering a collaborative and high-performance work environment. Provided mentorship and guidance to enhance their technical skills and productivity.• Designed and Build data vault 2.0 modeling to ensure data accuracy and consistency for reporting and analytics. Collaborated with cross-functional teams to align data structures with business requirements.• Designed, developed, and maintained ETL pipelines to extract, transform, and load data into Snowflake By using BODS, Matillion and Streamlined data integration processes to enhance data quality and accessibility.• Demonstrated experience in implementing core Snowflake concepts, including recovery methods, Cache usage, Streams (CDC), SnowSQL, snowpipe, data sharing, User-Defined Functions (UDFs), zero copy clones, time travel, micro partitioning, stored procedures, data import/export, RBAC, external tables, Tasks, Tags, Dynamic Masking, Snowpark and External Tables, Resource Monitoring for the AWS platform /Azure Platforms and Created queries to check consumption.• Agile Methodologies

• Involved in architect snowflake implementation and design database, access management policies (RBAC).• Creation of database objects, Streams, Snowpipe etc. and sharing DB's for other accounts• Having Experience in Snowflake performance tuning, capacity planning, handling cloud spend and utilization.• Replication by using Matillion, Perspectium, SnowSQL, Boomi from the Multiple different kind of Sources• Created dedicated Virtual warehouse/ Multi-cluster Warehouse, partitioning, auto scaling, and auto clustering.• Involved in data encryption, Dynamic masking, and hashing where applicable.• Develop operational best practices, monitoring, defining SLAs, and measuring metrics.• Designed and involved in creation of snapshot data by using streams and procedures and scheduled by Tasks to capture changing dimensions• Designed and Build dimensional Modeling and did POC’s with other modeling options like Data vault 2.0 etc.• Having good experience in building complex enriched views based on business metrics by using SQL, Procedures, Functions• Created and Scheduled tasks• Involved in building few predicted metrics by integrating snowflake and Data bricks and Snowpark• Build enriched Views based on required Metrics in People Analytics, Customer support, Product Operation and Value Realization Portfolios by using Snowflake and HANA.• Worked on SAP HANA multi-dimensional Data Modelling using Attribute Views, Analytic Views and Calculation Views.• Agile MethodologiesTech Stack: Snowflake Cloud Warehouse, Matillion, MS Azure ML, Data Bricks, Python, HANA, BODS, Perspectium, SQL, Tableau, Power BI and ServiceNow Platform Products (HI, SURF and LXP etc.)

Hyderabad Area, India

Working for Newboy,Dubai,UAE• Involved in Giving solutions,Project plan,Requirement gathering, Design and Build • Tech spec Preparation• Scheduling• Configured LT replication server between SAP source system ECC and HANA to enable real-time reporting.• Scheduled data replication, replicating only the relevant tables in to HANA by using SLT both initial load and continuous replication.• Worked on SAP HANA multi-dimensional Data Modelling using Attribute Views, Analytic Views and Calculation Views.• Worked on SAP HANA Live VDM’s for SD, MM, SCM, FICO and WM Modules.• Experienced in writing complex SQL Scripts and CE Script• Experience in Text analysis for various product reviews.• Experienced in applying privileges, Input parameters, variables • Experienced in creating Decision tables, Hierarchies, sequences, triggers and synonyms• Experience in creation of Universe by using IDT.• Experience in creation of Story boards (Dash Boards) by using SAP Lumira and Reports on WEBI. Environment: SAP HANA Studio SPS 9.0, SAP BODS 4.2, Information Designer tool (IDT), Web Intelligence and SAP Lumira.

Hyderabad Area, India

AIG (American International Group) June 2014 – May 2015 Burberry (UK, London) June 2013 – May 2014Unilever (UK, Netherlands) March 2012 – May 2013FFIC (Firemen’s Fund Insurance Company) Oct 2010 – Feb 2012SAP HANA• Broad understanding of Analytics & interpretation to industry relevant scenarios• SAP HANA Modelling, managing schemas, data model objects, import/export content and Data provisioning using SLT Replication server (for both initial load and continuous replication)• Expertise in Importing data by using Smart Data access/BODS from Oracle,DB2 and Hadoop• Worked on SAP HANA multi-dimensional Data Modelling using Attribute Views, Analytic Views and Calculation Views.• Strong experience with SQL Script, CE Script, Stored Procedures, Function Calls, Designing tables, data loads• Experienced in applying privileges, Input parameters, variables • Experienced in creating Decision tables, Hierarchies, sequences, triggers and synonyms• Worked on different joins, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Text Join and referential Join when connecting tables• Experienced in establishing connection between HANA and other systems (Excel, BODS and BO Tools) for ETL/Reporting.• Development of predictive analytics capabilities on SAP HANA (PAL)• Development of unstructured text analytic capabilities on SAP HANA• Design and development of geo coding, spatial processing capabilities on SAP HANA• SAP HANA Live RDS for FICO,SD,MM,HCM,SCM,PP,PI and S4HANA Simple Finance • SAP HANA Cloud Platform (HCP) and Integration (HCI – DS)• SAP HANA One (AWS)• Having Good Knowledge on Multi-tenant Database and Dynamic Tiering (SPS 9.0)• Having Knowledge on Smart Data streaming and Smart Data Integration (SPS 9.0)

Hyderabad Area, India

Responsibilities:• Involved in Requirement gathering • Designing• Tech spec Preparation• Scheduling• Worked closely with delivery team responsible for designing, developing, and supporting Data Integration Objects using ETL tool SAP BO Data services.• Involved in planning and coordinate with development team to complete the build and knowledge transfer.• Participated in design reviews.• Responsible for transferring data from the legacy systems to the Target system (SAP and/or non-SAP) efficiently.• Responsible to setup standard guideline to perform data validation, data cleansing, data transformation and calculations, as well as writing, scheduling and monitoring the load jobs.• Responsible to meet project objectives and stay within scope, monitor and track progress to plan and manage personal work assignments.• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms to successfully load data from multiple sources into a desired target.• Involved in writing Data Integrator (Key Generation, Pivot, Reverse Pivot etc) Data Quality (Associate, Match, Cleanse and more) Platform and Data Processing related transformations and other ETL functions within Data services using best practices and coding techniques for the data warehouse design, development and testing.Environment: SAP BODS 3.2 SP1, Universe Designer tool (UDT), Web Intelligence, Oracle 9i/11g, Windows XP.

Hyderabad Area, India

Responsibilities:• Worked closely with delivery team responsible for designing, developing, and supporting Data Integration Objects using ETL tool SAP BO Data services.• Involved in planning and coordinate with development team to complete the build and knowledge transfer.• Participated in design reviews.• Responsible for transferring data from the legacy systems to the Target system (non-SAP) efficiently.• Responsible to setup standard guideline to perform data validation, data cleansing, data transformation and calculations, as well as writing, scheduling and monitoring the load jobs.• Responsible to meet project objectives and stay within scope, monitor and track progress to plan and manage personal work assignments.• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms to successfully load data from multiple sources into a desired target.• Involved in writing Data Integrator (Key Generation, Pivot, Reverse Pivot etc) Data Quality (Associate, Match, Cleanse and more) Platform and Data Processing related transformations and other ETL functions within Data services using best practices and coding techniques for the data warehouse design, development and testing.Environment: SAP BODS 3.2 SP1, Universe Designer tool (UDT), Info space, Explorer, Oracle 9i, DB2, Windows XP.

B Tech, Mechanical Engineering, 75

Bachelor Of Technology (Btech), Mechanical Engineering

Activities and Societies: Swimming