Sandeep Boddu Email & Phone Number

Houston, Texas, United States

• Collect deal capture data from Champion, NAP, and Calpine Energy Solutions using the Allegro system. Gather forecasting data from Intelometry and ISOs, then present this information to retail traders to support current.
• Grasp the intricate business logic of deal capture, understand the flow and significance of upstream and downstream processes, and maintain constant coordination with the business team.
• Monitor existing jobs continuously, coordinate promptly with teams to resolve any issues, and take full responsibility for ensuring timely data delivery to complete data integration for both intraday and overnight.
• Understand and implement new business requirements, rewrite existing complex SP’s and Packages, and conduct regression testing to ensure system integrity and functionality.
• Deploying packages to the SSIS catalogue, create and manage environment variables within SSIS to facilitate dynamic configuration of packages across different environments.
• Create comprehensive documentation for future reference, save it in Confluence, and use simplified flow diagrams of ETL structure instead of lengthy text.

United States

• Developing semantic layers for various healthcare data modules like enrolments, claims, flu, clinical engagement, Hospital metrics etc to facilitate the creation of more accessible and robust datasets.
• Rewriting complex legacy member enrolment related stored procedures by thoroughly understanding business requirements, optimizing scripts, and applying the latest fixes.
• Designing efficient ETL SSIS packages using Visual Studio 2017 SSDT to build streamlined ETL processes based on legacy stored procedures and other scripts.
• Integrating data from various servers and source, transforming it into a unified structure to generate views for analytical and reporting purposes.
• Deploying packages and scripts through Bitbucket to higher environments to ensure version control and streamlined deployment processes, documenting entire process in Confluence.
• Scheduling SSIS packages and stored procedures through SQL Agent, with ongoing monitoring and prompt troubleshooting in case of job failures.

• Exhibited extensive proficiency in SQL Server programming constructs, encompassing control flow statements, loops, conditional logic, and robust error handling. Writing SQL statements for data insertion, updating, and.
• Demonstrated expertise in developing complex joins, subqueries, and correlated queries to retrieve data from multiple tables, enabling the generation of valuable insights for business operations.
• Employed advanced optimization techniques to enhance T-SQL code performance, including in-depth analysis of query execution plans, identification of bottlenecks, and implementation of appropriate indexing, query.
• Developed a comprehensive and customizable migration tool from the ground up using SSIS, showcasing strong leadership capabilities in guiding and mentoring a team of junior members throughout the project.
• Demonstrated expertise in Azure Data Bricks by creating advanced notebooks for incremental data loading from Azure SQL database / Parquet/Delta files in a data lake to MongoDB by utilizing Spark SQL, Python, and.
• Leveraged Azure tools like ADF, Synapse, Logic Apps, Key Vaults, and more to establish and maintain a highly efficient ETL process, successfully migrating data to MongoDB using Azure Databricks Notebooks.

Hyderabad Area, India

London, United Kingdom

• Developed complex stored procedures to encapsulate business logic in SQL Server. Utilizing parameters and variables in sp's for dynamic querying. Ensuring error handling and exception management within procedures.
• Extracting and transforming data using T-SQL queries for reporting and analysis. Writing SQL statements for data insertion, updating, and deletion. Handling data validation and ensuring data integrity.
• Successfully orchestrated the seamless integration of millions of Quote and Policy data into robust data warehouses, leveraging the power of SSIS to extract and consolidate data from diverse sources efficiently.
• Demonstrated expertise in developing and implementing multiple SSIS packages for the incremental loading of Datamarts, ensuring batch-wise data updates while maintaining data integrity and accuracy.
• Actively collaborated with business analysts and project managers to refine reporting and analytics requirements, ensuring that the delivered solutions met the precise needs of stakeholders.
• Played a pivotal role as a key member of a large agile project team, actively engaging in daily stand-ups, sprint planning sessions, bi-weekly sprints, task grooming, bug tracking, and retrospectives, contributing to.

London, United Kingdom

• Supported the management and development of multiple data feeds across the EMEA competitive and digital marketplaces, integrating data from a variety of source systems.
• Worked mainly on SQL Server Management Studio (SSMS) for client-driven data management and development (e.g. SQL scripting of tables, views, stored procedures, functions, dynamic SQL etc.).
• Used the Microsoft Business Intelligence (BI) stack for designing and building Extract, Transform & Load (ETL) processes and data integration solutions. This included using Visual Studio 2012 to support and maintain.
• Worked closely with the A&I Evaluation Team to support the provision of reporting datasets for client dashboards (e.g. Tableau/Omniscope) and visualization tools (e.g. Excel Cubes or Microsoft PowerPivot) using SQL.
• Maintained Python processes to support the automation of data delivery and API requests.

Hyderabad Area, India

 Support existing DW platform/applications to ensure system availability and scalability. Developed the packages for handling the huge amount of data from files to load into the database and also maintain the file status for tracking at any cost. Performed code reviews, analyze execution plans, and re-factor inefficient code Involved in all phases of.

Hyderabad Area, India

 Designed, tested and automated SQL Server Integration Services packages for periodical runs to load data into SQL Server databases from legacy systems and Implemented Customized Logging.  Designing the ETL Specifications, data testing and writing SDD, Process documents and Used Team Foundation Server (TFS) as source control. Utilized several.

Master’S Degree, Computer Science

Bachelor’S Degree, Computer Science