• Senior Software Engineer with 10 years of experience with significant expertise in Data warehousing, ETL process using, Informatica PowerCenter, DataStage, SSIS, SQL Server, Oracle/PLSQL, Snowflake, Teradata, Kafka in various segments of Software Development Life Cycle (SDLC).• Strong experience as Azure Cloud Data Engineer in Microsoft Azure Cloud technologies including Azure Data Bricks, Azure Data Factory (ADF), Azure Data Lake Storage (ADLS), Azure Synapse Analytics (SQL Data warehouse), Azure SQL Database, Azure Analytical services, Azure Cosmos NoSQL DB, Azure Key vaults, Azure DevOps, Azure HDInsight Big Data Technologies like Hadoop, and Apache Spark.• Strong experience in Amazon simple storage service (Amazon S3), AWS Redshift, Lambda and Amazon EC2, Amazon EMR, AWS Glue, Apache Airflow, and Apache Spark (PySpark).• Expertise in designing and developing Data marts and Data Warehouses using multi-dimensional Models such as Snowflake and Star schema while implementing decision support systems.• Excellent Experience in Designing, Developing, Testing and Documenting of ETL jobs and mappings using Informatica PowerCenter and Datastage• Extensively worked on creating pipelines in Azure Cloud ADFv2 using different activities like Move &Transform, Copy, filter, for each, Data bricks etc.• implementation of Databricks transformations (SQL/Python) of data stored in Azure Data Developed Pipelines and Notebooks within Azure synapse. Choosing correct data storage solution to meet the technical and business requirements.• Implemented ETL workflows using AWS Glue ETL and EMR, ensuring efficient data extraction, transformation, and loading. Utilized AWS cloud services including EMR, Redshift, Glue, and S3 for data processing and storage.• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems into snowflake table.• Extensively worked on performance tuning of the ETL process and SQL optimization on a large database. Automated the jobs in production environment.• Experience in migrating the data from on-prem to Azure Cloud. Experience in CICD model of deployment using GitHub and Jenkins.• Experience in writing the Solution Design Documents, gathering requirements and provide estimates for new development and change request.• Effective communication skills, work ethics and the ability to work in a team efficiently with good leadership skills.• Ardent desire to learn new technologies with positive attitude.• Ability to work independently and as a part of team.
-
ConsultantMckessonNovi, Mi, Us
-
Senior Software EngineerMckesson Apr 2023 - PresentIrving, Texas, UsInformation Management Data Warehouse (IMD) incorporates Equipment & Medical Supplies Inventory information. This project aims to build a data warehouse (DWH) to maintain the data from all the required data sources and enable the required reporting from the DWH. -
Senior Software EngineerHsbc May 2019 - Mar 2023London, GbThe system is mainly based on the retail banking activities. The purpose of this build is to extract the next best actions (NBA) data from SFE and report in insights. The data will then be used by team managers to coach their team members in the use of NBAs and used by the business to monitor the relevance of NBAs to the customer base. These NBAs could be regarding security, fraud, products, or services, etc. -
Senior AssociateSchneider Electric Hub Sep 2017 - Oct 2018Novi Sad, Srbija, RsThe system is based on sales and inventory information originating from various branches of the company. This information is used for trend identification, forecasting and competitive analysis and target market research. -
Senior Software EngineerJohnson & Johnson Jul 2016 - Aug 2017New Brunswick, Nj, UsJ&J has the NA Data Lake project for the multiple sources feeding data to the data lake for the marketing analytics data push to MSA (third party). There are around 21source systems/files like Google, YouTube, face book and Bing etc., Which need to be ingested into Data Lake, cleansed, validated, and segregated based on the output file requirement from MSA. -
Application EngineerWells Fargo Sep 2015 - Jul 2016San Francisco, California, UsWells Fargo Is a leading global financial services firm with Serving millions of consumers, small businesses, and worlds most prominent corporate, institutional and government clients worldwide. Liquidity is the management of assets and liabilities. Asset Liability Management (ALM) plays a critical role in weaving together the different business lines in a financial institution. Managing liquidity and the balance sheet are crucial to the existence of a financial institution and sustenance of its operations. -
Software EngineerIntuit Sep 2014 - Sep 2015Mountain View, California, UsIntuit Is a leading global tax services firm with Serving millions of consumers in more than 60 countries worldwide. Intuit provides a full range of tax services, including advising on corporate strategy and structure.
Prasanna S Education Details
-
Andhra UniversityElectrical And Electronics Engineering -
Jawaharlal Nehru Technological University, AnantapurElectrical And Electronics Engineering
Frequently Asked Questions about Prasanna S
What company does Prasanna S work for?
Prasanna S works for Mckesson
What is Prasanna S's role at the current company?
Prasanna S's current role is Consultant.
What schools did Prasanna S attend?
Prasanna S attended Andhra University, Jawaharlal Nehru Technological University, Anantapur.
Who are Prasanna S's colleagues?
Prasanna S's colleagues are Taylor Jaros, Janet Hekkanen, Pmp, Farhad Sayeed, Jim Hines, Abbey Coppenger, Caridad Yeny2000, Johnny Taylor.
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial