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 and future electricity requirements.• 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 processes.• 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.• Store all scripts and packages in Azure DevOps and deploy them using Visual Studio 2019.• Integrating data from various servers and source, transforming it into a unified structure to generate views for analytical and reporting purposes.• Create SSAS cubes, write MDX queries to extract data from these cubes and load it into various tables, and generate Excel-based pivot tables using the SSAS source.

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.• Adhering to stringent data protection rules and standards, especially concerning sensitive UAT and Prod data, to ensure compliance and safeguard sensitive information.

• 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 deletion. Handling data validation and ensuring data integrity.• 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 tuning, and performance improvement strategies.• 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 PySpark, effectively in achieving successful data transformations.• 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.• Utilized GitHub as a robust source control system while seamlessly coordinating code releases across environments through Azure DevOps (VSTS) and Octopus, effectively streamlining the development and deployment processes.• Generated insightful Power BI reports based on meticulously processed data, delivering actionable insights to stakeholders and driving informed decision-making.

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 the project's overall success.

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 Analysis Services (Cubes) and SSIS packages.• 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 Server “Output” tables and Tableau Data Extract (TDE) files, providing technical assistance if required.• 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 the project (Documentation, Designing, Unit testing and Defect fixing). Written many SQL Queries, Stored Procedures, Views, Functions as for business logic requirements. Created jobs for SP’s, packages using SQL Server Agent. Responsible to process the Cubes and their partitions according to QHourly, Hourly, Daily, Monthly and Yearly data. Browse the cube with filters and Hierarchies. In case of issues, raising the tickets to concern teams. Work directly with functional analysts and business users (R F Engineers) in understanding the information needs of the business and involving in developing new data warehouse/BI functionalities or tools to meet these requirements.

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 Transformations and several tasks for implementing the Transformation Logic in the Packages.  Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments. Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions.

Master’S Degree, Computer Science

Bachelor’S Degree, Computer Science