ENUMULA MAHESH

Software operations and data engineering professional with over 8 years of experience in data engineering, business intelligence, and data warehousing. Expertise in SQL Server, SSIS, SSRS, Azure Data Factory, Snowflake, Python, and DBT for building and optimizing scalable data pipelines. Proficient in designing ETL workflows, integrating diverse data sources, and ensuring data quality through rigorous validation and testing. Familiar with Azure tools, including Data Lake, Synapse, Databricks, and experienced in collaborative environments using Jira, Bitbucket, and Sourcetree.

Project:

Convey Health Solutions (CHS)
Client
Convey Health Solutions (CHS)
Environment
Snowflake, MS SQL Server, Dbt , BitBucket , SourceTree

RESPONSIBILITIES:

• Data Modeling & SQL Development (SQL Server & Snowflake): Designed and implemented logical and physical data models for analytics and reporting. Developed optimized SQL queries, views, and stored procedures to support large-scale data processing across SQL Server and Snowflake environments.
• Advanced SQL & Data Transformation: Built complex queries using joins, subqueries, CTEs, and window functions in both SQL Server and Snowflake to enable efficient data extraction, transformation, and analytical reporting.
• Performance Optimization: Enhanced database and query performance through indexing strategies, query tuning, and execution plan analysis in SQL Server, along with optimization techniques in Snowflake for large-scale data workloads.
• ETL & Data Pipeline Development (dbt): Developed and maintained scalable, modular data transformation pipelines using dbt, enabling efficient data ingestion, transformation, testing, and deployment in cloud-based environments.
• Cloud Data Warehousing (Snowflake): Designed and implemented scalable data warehouse solutions in Snowflake, including data loading, transformation, and optimization to support analytics and reporting use cases.
• Data Quality & Validation: Implemented data validation, testing, and quality checks within dbt and SQL workflows to ensure data accuracy, consistency, and reliability across pipelines.
• Reporting & Analytics Support: Enabled downstream reporting by preparing clean, structured datasets for BI tools, supporting business intelligence and analytical requirements.
• Version Control & Collaboration (Bitbucket & SourceTree): Managed code repositories using Bitbucket and SourceTree, following branching strategies, pull requests, and code reviews to support collaborative and version-controlled development.
• SDLC & Agile Practices: Actively participated in all phases of the SDLC, including requirement analysis, development, testing, deployment, and production support, ensuring alignment with business and regulatory requirements.

Project:

SharkNinja
Client
SharkNinja
Environment
Snowflake, MS SQL Server, Dbt , SSIS 

RESPONSIBILITIES:

• Data Modeling & Requirement Analysis (SQL Server & Snowflake): Translated business requirements into scalable logical and physical data models to support analytics and reporting across SQL Server and Snowflake environments.
• End-to-End SDLC Execution: Actively involved in complete SDLC, including requirement gathering, development, testing, deployment, validation, and production support for data engineering solutions.
• Database Development & Optimization: Designed and optimized database objects and queries in SQL Server and Snowflake, ensuring high performance, reliability, and efficient data processing.
• Advanced SQL & T-SQL Development: Built complex queries using joins, subqueries, CTEs, and window functions for data extraction, validation, transformation, and troubleshooting.
• ETL & Data Pipeline Development (SSIS & dbt): Designed, developed, and deployed ETL pipelines using SSIS and dbt for data ingestion, transformation, validation, and automation across on-prem and cloud environments.
• Python-Based Data Processing: Developed Python workflows for data cleansing, reconciliation, validation, and quality assurance to enhance data pipeline efficiency.
• Data Migration & Transformation: Executed large-scale data migration, cleansing, and transformation using advanced ETL techniques and scripting in SSIS and dbt.
• Cloud Data Warehousing (Snowflake): Implemented scalable and secure data warehousing solutions in Snowflake, supporting high-performance analytics and reporting workloads.
• dbt Transformation Framework: Built modular, reusable, and version-controlled transformation pipelines using dbt to improve data quality, maintainability, and deployment efficiency.
• Reporting & Visualization Support: Delivered structured and analytics-ready datasets for reporting tools such as Power BI, SSRS, and Tableau.
• Production Support & Monitoring: Monitored data pipelines, resolved defects, and ensured SLA compliance through proactive issue resolution and performance tracking.
• Documentation & Data Governance: Maintained process documentation, data schemas, and business rules to support cross-functional collaboration and data governance.
• Cross-Functional Collaboration: Worked closely with engineering, operations, and business teams for QA/QC, UAT, and defect resolution.
• Delivery & Work Management: Managed multiple deliverables and client requirements using structured tracking and reporting approaches.
• Data Warehousing Concepts: Applied strong knowledge of data warehousing principles, including ER modeling and normalization techniques to ensure data integrity and consistency.
• Domain Expertise (Supply Chain & E-commerce): Leveraged domain knowledge to align data solutions with business objectives and improve decision-making.
• Analytical & Communication Skills: Demonstrated strong analytical thinking, problem-solving ability, and effective communication in collaborative environments.

Project:

Commonwealth Care Alliance (CCA)

RESPONSIBILITIES:

· Working as a SQL server Developer for gathering requirements and implemented logical Design into Physical Design from customer.

· Involved in the all the stages of Software Development Life Cycle (SDLC).

· Installed SQL Server on development and production servers setting up databases, users, roles and permissions.

· Created and Modified tables, Views, Indexes, User Defined Functions, Stored Procedures in SQL Server.

· Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.

· Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor

· Used sever Transformations in the SSIS packages for the data transformation from the OLTP to OLAP.

· Explicitly used Execute SQL Task, Script task, Derived Columns, Condition split, aggregate, lookup, Merge join etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.

· Involved in the release documentation.

Project

Monsanto India Pvt. ltd

Responsibilities

· Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.

· Involved in the all the stages of Software Development Life Cycle (SDLC).

· Installed SQL Server on development and production servers setting up databases, users, roles and permissions.

· Created and Modified tables, Views, Indexes, User Defined Functions, Stored Procedures in SQL Server.

· Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.

· Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor

· Used sever Transformations in the SSIS packages for the data transformation from the OLTP to OLAP.

· Explicitly used Execute SQL Task, Script task, Derived Columns, Condition split, aggregate, lookup, Merge join etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.

· Created efficient SSIS packages for processing fact and dimension tables with complex transformations.

· Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.

· Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.

· Designed and crated distributed reports in multiple formats such as Excel, PDF, XML and CSV using SQL Server Reporting Services (SSRS).

· Developed drilldown and drill through reports from multi-dimensional objects like star schema and snowflake schema using SSRS and performance point server.

Designed and Implemented Comprehensive Backup plans and disaster recovery strategies

Project

Mylan Laboratories Ltd

Responsibilities:

· Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.

· Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.

· Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.

· Experience in SSIS package design, development and deployment.

· Expertise in using different transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, merge, union all, slowly changing dimension and many more to transform the data before loading into the destination.

· Configure SSIS Package for run time Parameters and Configuration file.

· Developed some scripts and used in ETL Process that works as transformation

· Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.

· Created packages in SSIS with error handling.

· Scheduled tasks to run every day to update changes in the base tables

· Writing complex stored procedures to meet the business requirements.

· Created new database objects like Stored Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment on SQL Server.

· Created matrix and tabular reports with drilldown, drill through and dropdown menu option using SSRS.

· Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS)

· Designed and developed various types of reports using SSRS

· Created parameterized reports, Drill down and Drill through reports using SSRS

· Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications

· Generated reports using Global Variables, Expressions and Functions using SSRS.

· Worked on Data modelling, creating star and snowflake schemas in SSAS.

· Experience in working with data warehouses and Microsoft OLAP Analytics Services.

· Scheduled Cube Processing from Staging Database Tables using SQL Server Agent

· Scheduled .dtsx packages execution to load data into Fact Tables using SQL Server Agent

· Created complex Stored Procedures, cursors, tables, and viewsand other SQL joins and statements for applications by using T-SQL.