Mahesh D Email and Phone Number
• Over years of professional IT expertise, including work with Big Data technologies and a variety of Legacy Database systems.• Working knowledge of data modeling programs like Erwin and ER/Studio.• vast expertise in designing and deploying large-scale data processing systems employing HDFS, MapReduce, YARN, and Hive, as well as other components of the Hadoop ecosystem.• Skilled in creating intricate joins, subqueries, stored procedures, triggers, and views.• Expertise in creating ODS architecture, Snowflake schema, and Star schema for Data Warehouses. • Strong knowledge of data architecture, ETL procedures, and data warehousing, as well as proficiency in Spark Scala and Cloudera on-premises.• Working knowledge of EC2, S3, Redshift, Glue, Lambda functions, Step functions, CloudWatch, SNS, DynamoDB, and SQS as well as other AWS services• Involved in conceptual, logical, and physical data modeling and used star schema in designing the data Warehouse.• Expertise in Data Modelling, Data Mapping, SQL Server Management Studio SSMS, SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS.• Creating and scheduling SQL jobs.• Expertise in visualization tools like Grafana.• Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like Flat File, Excel, MS SQL and Automate the ETL.• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages also in backup and disaster recovery procedures.• Knowledge of the setup and upkeep of AWS stacks that automatically scale.• Possess competence in building complex mappings, performance optimization, and gradually modifying dimension and fact tables. • Used a terminal to deploy the Spark Cluster and other AWS services.• I've used Docker consoles to manage the application life cycle and have good expertise with Docker to deploy applications quickly, setup CICD pipelines, and monitor on Git.
-
Servicenow Adminstrator And DeveloperJohnson & JohnsonUnited States -
Data EngineerJohnson & Johnson Jul 2023 - PresentNew Brunswick, Nj, Us• Design and implement data pipelines and workflows using Databricks ensuring scalability, reliability, and performance.• Designed and deployed secure, scalable, and resilient integration workflows using Azure Integration Services to facilitate seamless data exchange across multiple systems.• Enhanced integration workflows through the strategic utilization of Azure Integration Services, leading to a 30% decrease in operational expenses and enhanced data precision.• Implemented intricate workflows utilizing Azure Logic Apps to automate business procedures and enhance operational efficiency.• Develop and maintain Python Notebooks within Databricks for data analysis and processing, optimizing data workflows for efficiency and accuracy.• Identified and resolved challenges within Azure Logic Apps to maintain high availability and reliability in automated workflows.• Utilized Azure Functions for executing backend processes, including data processing and API orchestration, resulting in a 40% acceleration in processing speed.• Regular monitoring and performance tuning of APIs through Azure API Management, improving response times by 25%.• Optimized data storage solutions leveraging Azure SQL Database, Azure Data Lake Storage, Azure Cosmos DB, and Azure Blob Storage.• implemented data models using Azure services like Azure Analysis Services and Azure HDInsight, enabling stakeholders to derive actionable insights from large datasets.• Have built Qlik dashboards using all the charts that are available within the product including bar chart, pie chart, scatter plot, combo chart, histogram, line chart etc.• Extensive experience with Qlik sheet objects, scripting, and optimizing applications and building QVD’s and QVW’s.
-
Data Engineer/Data ModelerCigna Healthcare Jul 2019 - Dec 2021Bloomfield, Ct, Us• Increased data pipeline efficiency by 40% by designing and implementing end-to-end pipelines using Azure Data Factory, resulting in faster data processing, and reduced operational costs.• Designed and maintained CI/CD pipelines GitHub Actions, resulting in a 40% reduction in deployment times and ensuring smooth integration and continuous delivery.• Optimized data processing scripts in Python and SQL, enhancing data pipeline efficiency by 30%.• Optimized data warehouse model by leveraging Snowflake, leading to a 30% reduction in query execution time and enhancing overall data processing efficiency for the organization.• Utilized Spark to streamline data transformations, leading to a 30% increase in data accessibility for analysts and improving overall data-driven decision-making.• Monitoring and logging solutions with CloudWatch improving system reliability and quickly identifying issues.• Coordinated cross-functional efforts with platform engineering, operations, data science & Microsoft technical support, resulting in a 15% reduction in system downtime. This improved system stability positively impacted user experience and overall business performance.• Developed ETL process for the Workday data using Python and loaded the data into HIVE and SQL for the analysts.• Implemented Apache Airflow for authoring, scheduling, and monitoring data pipelines, designing multiple DAGs to automate ETL pipelines.• Possess strong experience in ETL concepts, building ETL solutions, and data modelling -
Etl DeveloperAptivacorp Jul 2018 - Jun 2019Somerset, New Jersey, Us• Coordinated with Business Analysts and end-users to gather and understand business and functional requirements, translating them into detailed ETL design documents, increasing design accuracy by 50%.• Extensively developed ETL processes using Informatica PowerCenter/IICS, including complex mappings and Power Exchange Change Data Capture (CDC) mappings, improving ETL process efficiency by 50%.• Performed initial data profiling to assess data quality, removing duplicate records to maintain data integrity, resulting in a 30% improvement in data quality.• Conducted performance tuning at source, target, mappings, sessions, and system levels to optimize ETL processes and improve efficiency, achieving a 40% increase in system performance.• Enhanced existing data sources to meet evolving customer requirements, ensuring timely and accurate data delivery, and improving data availability by 50%.• identified and resolved performance bottlenecks in Informatica mappings by implementing effective transformation logic, enhancing processing speed by 30%.• Collaborated closely with business users and technical teams in a customer-facing role, consolidating requirements into cohesive ETL design solutions, increasing user satisfaction by 30%.• Provided comprehensive data support to the reporting team for generating daily, weekly, and monthly reports, facilitating accurate business insights and increasing report accuracy by 50%.
Frequently Asked Questions about Mahesh D
What company does Mahesh D work for?
Mahesh D works for Johnson & Johnson
What is Mahesh D's role at the current company?
Mahesh D's current role is ServiceNow Adminstrator and Developer.
Who are Mahesh D's colleagues?
Mahesh D's colleagues are Sandrine Pivert, Jeff Esslinger, Dave Turner, Susan Konopack, Monika Sulidis, Khat Ismail, Thomas Alkiviadis Kotsis.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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