Srikanth Nehru Koraganti

Project: Chubb-LDTI Cloud Migration

Developed and maintained data pipelines using Azure services resulting in a 40% increase in data processing speed. Designed and implemented a data lake architecture resulting in a 25% reduction in storage costs. Collaborated with data scientists to implement machine learning models resulting in a 15% increase in revenue

• Worked on migration of on-prem data into cloud databases like azure synapse analytics and azure SQL databases.
• Developed several data pipelines jobs, scheduling triggers, data flows using ADF pipelines.
• Involved in Building and maintaining data models, databases, and data warehouses on Azure Synapse Analytics
• Monitoring and optimizing the performance of data warehouses in Azure Synapse Analytics.
• Collaborating with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions.
• Hands-on experience in these areas, like LIFT and SHIFT on-prem data to cloud platforms (MS Azure Cloud).
• Designed and implemented ETL processes using Azure Data Factory, resulting in a 50% reduction in processing time.
• Collaborated with cross-functional teams to design and implement scalable data architectures.
• Implemented data governance policies resulting in a 30% reduction in data quality issues.
• Work with the team to architect and implement enterprise data modeling solutions across multiple subject areas.
• Experience with azure BLOB and data lake storage and loading data into azure synapse analytics (DW).
• Develop reusable frameworks for enterprise data lakes, and drive adoption of the frameworks to enable deployment.

Environment : IICS 10.4.1, Informatica PC 10.4.2,Azure Synapse Analytics,MS Azure ADLS Gen2, ADF, Pyspark SQL, Data bricks, GIT, Nexus,

Project: Kroger Digital Transformation

• Collaborated with product managers to integrate data engineering into the Expedia platform, enhancing data connectivity by 34%
• Streamlined data warehousing using Azure Synapse, leading to a 29% faster data retrieval rate
• Led the migration of on-premises databases to Azure SQL Synapse, resulting in 33% faster query performance
• Worked closely with BSA to understand the function requirements and also be part of mapping document review.
• I was responsible to come up with ETL solution design and dataflow documents and present them during team reviews.
• Attended daily scrum meetings and provide status on the tickets I was working and any impediments.
• Worked with QA teams in designing Test scenarios and plans.
• Utilize JIRA, Remedy to capture, manage and track requirements throughout the application development, testing cycle
• Design Conceptual Data models, Logical Models followed by fully blown Physical models.
• I was part Data Architect team; responsible for end to end technical architecture, sizing and solutions design.
• Written ETL specifications for all the development tasks, to better evolve the ETL design

Environment :MS Azure ADLS Gen2, ADF, Pyspark SQL, Data bricks, Synapse analytics. Informatica Intelligence Cloud Services 10.1, PowerCenter 10.4.1, MS SQL 2014, Teradata Utilities, JIRA, Tableau, Linux,TWS,, Terraform, Informatica Cloud (IICS)

Project : Global Data Registry - Federal Reserve Bank, SFO, CA

• Designed and implemented data storage solutions using Azure services such as Azure Synapse Analytics and Azure Data Lake Storage
• Developed and maintained data pipelines using Azure Data Factory and Azure Databricks
• Performed data modeling and schema design for efficient data storage and retrieval
• Optimize data processing and storage for performance and cost efficiency
• Implemented security and compliance measures for data storage and processing
• Collaborated with data scientists and analysts to provide data insights and support data-driven decision making
• Troubleshoot and resolve data processing and storage issues and reduce shuffling.
• Manage code build and deployments using GIT source code management tool.
• Utilize JIRA, Remedy to capture, manage and track requirements throughout the application development, testing cycle

Environment : MS Azure ADLS, SQL DW, ADF, HDFS, Hive, Data Lake,, Cloudera Navigator, Spark 1.6, Hbase 1.2, Kafka 0.9, hdfs, impala, IICS 10, Informatica PowerCenter 10.2, Power Exchange 10.2, MS SQL 2014, JIRA, Tableau, Linux, Autosys,; Informatica Cloud (IICS)

Project1: EBPP- US Cellular, IL

• Worked with Informatica PC to create Source /Target connections, monitor, and synchronize the data in salesforce.
• On-boarding new applications in the project and ensuring smooth transition to the entire team.
• Identifying the performance bottleneck of the application and sharing it to clients periodically.
• Participate in IA review sessions with business analysts and project management people.
• Create technical design of ETL integrations followed by LLDs.
• Written Complex SQL overrides for source qualifier and Lookups in mappings.
• Written ETL specifications for all the development tasks, to better evolve the ETL design .
• Involved in Data Quality Analysis to determine cleansing requirements.

Project 2: EDW- BCBS, MI

• Monitoring data warehouse performance and ensuring data availability
• Troubleshooting data quality issues Creating and managing database objects like tables, procedures, and function
• Designing and implementing data warehouse ETL pipelines
• Extracting, transforming, and loading data using tools like Informatica
• Identifying, analyzing, and resolving data warehouse related incidents
• Implementing processes for incident and problem management

Environment: Informatica 9.6, ILM 6.2, Web Services SOAP, WSDL,XMLParser,Oracle, PL/SQL, Linux, Tivoli, Cognos

Worked as data warehouse lead engineer

• Design and build data models and ETL jobs for Enterprise Data Warehouse, Data Marts and Operational data stores using Informatica, SQL Server, Oracle, UNIX, SQL/PLSQL

Worked as associate architect and delivered..

• Solutioned and Developed EDW and Data Mart applications using Informatica, Oracle, SQL/PLSQL, UNIX, Microstategy

Worked as ETL developer and responsible for.

• Technical specification documents, develop ETL pipelines and batch for data warehouse and operational data stores jobs using Informatica, UNIX, Oracle, Cron jobs, DQL, PL/SQL