Sai G Email and Phone Number

• Collaborated with clients to understand their data infrastructure needs and requirements, providing consultation and guidance on data engineering solutions.• Designed, developed, and implemented scalable data pipelines, ensuring efficient extraction, transformation, and loading (ETL) processes for large volumes of data from various sources.• Conducted data analysis to identify trends, patterns, and anomalies, and developed strategies to optimize data storage, retrieval, and processing.• Built and maintained data warehouses and data lakes, applying industry best practices to ensure data integrity, security, and availability.• Worked closely with cross-functional teams, including Data Scientists and Business Analysts, to define data requirements, validate data models, and ensure alignment with business objectives.• Implemented data governance and data quality frameworks, establishing data standards, policies, and procedures to maintain data accuracy and consistency.• Developed and maintained data documentation, including data dictionaries, data lineage, and metadata, to facilitate data discovery and knowledge sharing across the organization.• Collaborated with IT teams to deploy and manage data infrastructure, including cloud-based platforms and on-premises databases, ensuring high availability and performance.• Conducted performance tuning and optimization of data pipelines and queries to improve overall system efficiency and reduce latency.• Stayed up-to-date with the latest trends and technologies in the data engineering field, and proactively recommended and implemented innovative solutions to enhance data engineering processes.• Provided technical guidance and mentoring to junior team members, fostering their professional growth and development

• Identifying issues and risks associated with the project.• Prepared all functional, and technical specification documents and High-Level Document preparation.• Designed and generated reports as per the specifications.• Worked closely with cross-functional teams to identify and evaluate data requirements.• Developed List, Crosstab, and Chart reports and advanced dashboards.• Used Conditional Styles to provide styles based on conditions using Report Studio.• Used Render Variable and switch the pages based on prompt selections in Report Studio.• Used Conditional Block to hide and show the objects within the same page based on conditions in Report Studio. • Utilized the Crosstab spaces in Report Studio. Created prompts like Text box prompt, Value prompt, and Select and Search prompt in Report Studio.• Generated reports based on SQL queries.• Ingesting data from a variety of corporate data sources and performing required transformations in the Power BI query editor• Very strong SQL skills for querying and creating of views/tables, functions, and stored procedures• Experience in designing ETL processes including knowledge of data warehousing strategies and theories• Supported User Acceptance Testing (UAT) and confirmation of the business sign-off, Pre-Production, and Production Reports.• Database experience using Azure SQL. Data Visualization and experience using Microsoft Power BI Dashboard• Strong experience in database performance optimization• Strong ability to define stored procedures, triggers, Jobs, and other database objects.• Experience in creating reports using SSRS in SQL Server and Power BI• Worked in Agile methodology environments and was involved in scrum meetings.• Develop data processing scripts using SQL and be able to optimize complex sequences of SQL Queries• Design, build and deploy effective SSIS packages to validate, synthesize, and transform customer data for integrated business planning and analytics

• Identifying issues and risks associated with the project.• Requirements and Analysis: Understanding the requirements of the stakeholders• Transforming the functional requirement into a technical requirement• Discussing business rules and documenting them along with the data dictionary• Impact analysis of the number of ETL components to be modified/developed• Creating high- & low-level design documents and presenting them in review meetings• Making the code changes, spot checking, and Test Case preparation for Unit testing• Working with various source systems like Flat files, DB tables, SAP, Salesforce, API• Unit test the newly developed, modified, and impacted components• Review of code components changed by peers• Data Integration using ETL such as Pentaho, SSIS• Develop and maintain SSIS packages, and the ability to do Data Migration from different sources to SQL Servers. • Good understanding of SQL Server database design concepts and ability to understand the underlying data model, to develop optimized code.• Experience in SSRS reports development.• Experience in processing huge volumes of data.• Understand the performance measures that impact the application; create solutions to remove bottlenecks across any layer.• Good understanding of BI data warehousing concepts• Strong knowledge of software implementation best practices• Built effective and visually pleasing dashboards/reports using Enterprise Data Warehouse (EDW) to answer business questions in meaningful ways.• Provided BI system support to ensure a high level of system availability• Expert Experience in developing, building, and implementing RDL reports in SQL Server Reporting Services (SSRS)• Expert Experience in Extraction, Transformation, and Loading (ETL) using SQL Server Integration Services (SSIS).• Good Experience in Performance Tuning and Query Optimization.

• Interacted with business users and team leads for a better understanding of business specifications and requirements, identifying data sources and Development strategies.• Evaluating Source systems, standardizing received data formats, and understanding business/data transformation rules, business structure, and hierarchy relationships.• Designed and developed MS SQL server stored procedures using T-SQL statements from scratch. Developed triggers on views to populate tables. Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.• Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.• Created SSIS packages for data loading utilizing various tasks and transformations (such as execute SQL task, script task, execute package task, data flow task, fuzzy lookup, lookup, OLEDB command, derived column, etc.).• Extracted and load data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging area.• Normalized the tables and maintained Integrity by using Primary and Foreign Keys.• Designed and developed various SSIS packages (ETL) to extract and transform data and was involved in Scheduling• SSIS Packages also designed SSRS and Power BI reports to deliver Daily, Weekly, and Quarterly KPIs to clients.• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the data warehouse.• Created, maintained, and updated ETL packages loading both OLTP and OLAP database tables. Repaired SSIS packages with checkpoints, breakpoints, and data viewers.• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load. Created packages in SSIS with error handling and worked with different methods of logging in SSIS.