Kalesh GADIPARTHI

Project : Catalyst Insights and Analytics -Internal

Role : Lead Data Engineer

Summary : The Catalyst Insights and Analytics team plays a pivotal role in providing critical KPIs such as revenue, gross margin, demand, and supply to facilitate informed decision-making for the leadership team. As part of this project, we will ingest data from various sources in our system, transform it according to business requirements, and build an Enterprise Data Warehouse (EDW). Subsequently, we will utilize the EDW as a source to develop Tableau reports, effectively depicting KPIs through visualizations. This ensures data accuracy and accessibility, empowering executives with actionable insights for driving business performance.

Responsibilities:

• Extracted and transformed multi-source data( Salesforce , Workday, Intacct, Sage, iCIMS ) , incorporating assets into unified databases while monitoring integration and replication performance.
• Design and develop complex SQL queries, stored procedures, triggers, and functions to support various business requirements.
• Created and maintained ETL processes to integrate data from multiple sources into centralized databases.
• Assisted in database migration and upgrade projects, ensuring minimal downtime and data loss.
• Implemented data validation and cleansing procedures to ensure data accuracy and consistency.
• Collaborate with cross-functional teams to gather and analyze business requirements and translate them into database solutions.
• Lead database design and architecture initiatives, ensuring scalability, reliability, and data integrity.
• Devised high-quality database solutions ranging in size and complexity, increasing productivity, and improving data sharing.
• Designed and developed customized extract, transform and load (ETL) applications per client specifications.
• Gathering requirements through client interaction and analyzing the same through BRD, to understand requests/needs and thereby provide best solution possible.
• Produced high-standard database solutions to meet stability, reliability, and performance metrics.
• Establishing rules and guidelines for data architecture, data model design, data warehousing, data integration and data security.
• Analysed data warehousing framework proposals, advising on feasibility, scale, and other metrics.
• Providing high level conceptual & technical expertise and understanding of data warehousing & business intelligence best practice.
• Developing, implementing & maintaining all key BI & data management policies & procedures, including those for BI/EDW architecture.
• Extract ,Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL . Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
• Ensuring the data quality and created database objects and procedure to load the data for reporting purpose.
• Performance tuning of Procedures, ETL processes and improved execution time.
• Implemented PGP encryption and decryption as part of flat file integrations with different systems .

Client : SumTotal Systems

Role : Senior Data Engineer

Summary: SumTotal, a company specializing in e-learning products, offers modules for Learning Management, Talent Management, and Workforce Management (WFM). In this project, the focus was on the WFM module, entailing the maintenance of customer data elements and worker records. The project involved enabling data ingestion from transactional databases and implementing replication mechanisms. Additionally, rules were established for setting up a Data Warehouse (DWH) to support dedicated reports for WFM functionalities. This initiative demanded meticulous attention to detail and expertise in data management to ensure accurate and efficient data processing for WFM operations.

• Drove data analysis, resolving complex business issues and proposing long-term system solutions.
• Wrote and optimized SQL statements to assist business intelligence practices.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse.
• Developed custom database objects, stored procedures and delivered application support
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Designed and implemented data models and database schemas based on business requirements.
• Developed and maintained database systems for various clients, ensuring optimal performance and data integrity.

Client: Florida Power & Light Company

Role : Senior BI Developer

Summary : Florida Power & Light Company (FPL) is a major Florida-based power utility, engaged in the generation, transmission, distribution, and sale of electric energy. The project encompasses data engineering efforts to integrate diverse data elements, such as wind energy production, into Oracle databases using an Extract, Transform, Load (ETL) process. This enhances FPL's data management and analytics capabilities, facilitating optimized operations and decision-making. Additionally, the project involves migrating reports from Cognos to Microsoft BI, ensuring comprehensive reporting and analysis capabilities aligned with FPL's business objectives. Efficient ETL processing enables seamless data flow and accurate reporting for FPL's operations.

Responsibilities:

• Developed and optimized PL/SQL procedures, functions, and packages for data manipulation and transformation.
• Successfully migrated legacy Cognos reports to SSRS while maintaining their original functionality by querying against Oracle databases.
• Designed and implemented ETL processes to extract, transform, and load data from various source systems into Oracle databases.
• Implemented data warehousing best practices, including dimensional modeling, to ensure efficient storage and retrieval of data.
• Collaborated with cross-functional teams to gather requirements, design data solutions, and deliver actionable insights through reports and dashboards.
• conducted performance tuning and optimization of SQL queries, ETL workflows, and database objects to enhance system performance.
• Developed pivot tables and pivot charts from SSAS cubes to visualize data effectively.
• Involved in configuring and deploying reports in the report server and report manager for accessibility.
• Demonstrated proficiency in various chart types such as Pareto Chart, Line Chart, and Bar Chart for comprehensive data visualization.
• Experienced in implementing slicers to enhance user interaction and data filtering capabilities.
• Involved in deploying packages to the integration service catalog, cubes to the analysis server, and SSRS reports to the report manager for seamless integration and functionality.
• Led a team of 5 members for the wind model module, overseeing their tasks, providing guidance, and ensuring project milestones were met within deadlines.

Client: Aon

Role : BI Developer

Summary: Aon is a leading global provider of insurance services and consulting. Their Aon wrap offering provides all-encompassing liability insurance for contractors and subcontractors on large projects. Aon wrap includes a reporting module for diverse business needs and external partners. A proposed reporting solution aims to modernize architecture using Microsoft best practices. This involves end-to-end development for improved data warehousing and analytics.

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical reporting on SQL Server using SSIS and SSRS.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Developing process-automation tools, maintaining program modules including operational support, problem resolution, production support, preventative & corrective maintenance & enhancements