Azure Functions, Power BI, Python, Azure Data Factory, Power Shell
Resume:
Professional Summary
Sundaramurthy Jagadeesan has 20+ years of total of IT experience & gained valuable knowledge
in Health Safety and Environment (CHEVRON) and Financial Services industries. He has specifically worked on projects related to Microsoft Azure, .NET Projects, Data Warehousing, Data Migration and Reporting. Good Exposure and extensive experience in Azure Functions, CI/CD Pipeline, Azure DevOps, Azure Key Vault, Azure Data Factory, Azure SQL Server, Power BI, SSIS, SSRS, Angular 9, Node JS, JavaScript, SQL Server, Oracle, SSRS, SSIS, Telerik controls, HTML5, Type Script and Angular 2 and programing languages like VB .Net, C# .Net and Python.
Technically strong in C#.NET, ASP.NET MVC, WCF, Web API, LINQ, SOAP, XML, XSL, XSLT, Node JS, Bootstrap, Open API (Swagger), Entity Framework, Git, RESTful Web Services, Web Services, Dot.NET Win Forms, Windows Service, RabbitMQ, MSMQ ASP and IIS.
Work extensively in Dot.NET Technologies (ADO.NET, C# .NET, ASP.NET, MVC, WCF and Web Forms) and Angular 15.
Experienced in building/managing Web Applications using Classical ASP, ASP.NET Web Forms, MVC (Razor/ASPX engine), ASP.NET Web Forms, ASP.NET State Management & ASP.NET Caching.
Good working knowledge in Agile, leading SCRUM meetings and handling Story Boards / Sprint Boards.
Deploy the Various Solution like for Azure SQL Server, Azure Key Vault, Azure Functions and Azure Data Factory to various Environments using Azure CI/CD pipelines
He has prominent experience in database design, creation of data objects – table, packages, stored procedures, functions, views using SQL Server and Oracle.
Proficient in OOP (Object Oriented Design and Programming.)
Good knowledge in handling SaaS Enterprise applications called Sphera systems like (Sphera Essential, Sphera IMPACT) and Cority systems like IIR (Incident Investigation Reporting)
Worked on to enable single sign-on (SSO) for SaaS applications, allowing users to access multiple cloud-based applications with just one set of credentials by authenticating through Azure Active Directory (Azure AD) using the SAML authentication.
Working in Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, SQL server, Azure Key Vault, resource groups.
He also gained knowledge in Power BI, Power Apps and has got vast exposure in Agile SCRUM Azure DevOps expertise to execute the project.
Delivered Power BI Reporting on Azure environment. Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
Expertise in utilization of DAX expressions like Filters, Aggregate, Calculate, Use Relationship, and Time Intelligence functions to create new calculated columns and measures.
Worked on MSBI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).
Created Pipelines in Azure Data Factory and Azure Synapse to Extract data from different sources (Excel, ADLS, azure SQL etc.) and ingested into CDM (Common data model) & data lake layers.
Create and Schedule Azure Data Factory (ADF) pipelines
Experience D
Skills
Languages
C#.Net, Vb.Net, Python
Cloud Technologies
Microsoft Azure, Azure Data Lake, SAML Authentication & Application Gateway, Azure functions, Azure Devops, CI/CD Pipeline, Logic Apps, Azure Data Factory, Azure Key Vault, Azure Blob Storage, Azure Data Lake
Web Technologies
ASP.Net 1.1,2.0,3.5, ADO.Net, WCF, WPF, Silverlight, Entity Framework 4.0, MVC 3.0, Blazor, Angular 9, Node JS, Web API, .NET Core and LINQ
RDBMS
SQL Server 2005,2008,2014,2016,2019,2022 and Oracle
Microsoft ETL Tools
DTS and SSIS (SQL Server Integration Services), Azure Data Factory, Databricks, Python, PySpark
Reporting Tools
Crystal Reports, SSRS (SQL Server Reporting Services)
Robotic Automation Tools
UiPath Robotics Process Automation
Analytical & Visualization tools
Power BI and VISIO
Source Control
Visual Source Safe (VSS), Team Foundation Service (TFS) and Git
Bug Tracking Tool
Test Tracking Pro, BMC Remedy and Service Now
Web Server
Internet Information Services (IIS)
Primary Domain
Oil & Gas
Work Experience
Environment: Azure Functions, .NET Core, Rest API, Azure Data Factory, Azure Key Vault, Azure Data Lake, Ansible CI/CD Pipeline, Azure Devops and Azure SQL Server.
Work Experience
Project: Incident Investigation Reporting (IIR) April 2022 to Till Date
Client: Chevron Corporation Limited, US
The purpose of the Incident Investigation and Reporting (II&R) process is to report, classify, and investigate incidents and near misses, including injury, operational, occupational illness, environmental, reliability, business disruption, and community concerns. The lessons learned from investigations can then be leveraged to reduce or eliminate root causes and prevent future incidents.
Cost savings by moving to a single SaaS solution (Cority IIR) and eliminating the support of outdated architecture and maintenance. No more upgrades, server costs, etc. Simplified maintenance.
Developed interfaces to send Chevron Organization, Position, Personnel Identity data to Cority and vice versa using Azure functions, Azure Data Factory and SQL Server.
Responsibilities
Provides broad understanding of platforms and applications across all technologies.
Consumed APIs to post data into Third party vendor tool called Cority IIR through Azure Functions.
Reviewing of deliverables and deploying the application in the test and production environment through CI/CD pipeline.
Worked on to enable single sign-on (SSO) for SaaS applications, allowing users to access multiple cloud-based applications with just one set of credentials by authenticating through Azure Active Directory (Azure AD) using the SAML authentication.
Created Pipelines in Azure Data Factory to Extract People data from Azure Data Lake and processing through stored procedures and sending over to Cority SaaS application through Azure Functions
Delivered Power BI Reporting on Azure environment. Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards
Develop uses cases, test scripts, and initiate the process of User Acceptance Testing (UAT) and tested the Web API through Postman tool.
Consumed Cority Site Security data through API and store it in the SQL Server table to assign the role based on organization.
Environment: Databricks, Spark, Python, Pyspark, Azure Data Factory, Azure Key Vault, Azure Data Lake, Ansible CI/CD Pipeline, Azure Devops and Azure SQL Server.
Project: Data Migration (IIR) Mar 2021 to Apr 2022
Client: Chevron Corporation Limited, US
The purpose of the Incident Investigation and Reporting (II&R) process is to report, classify, and investigate incidents and near misses, including injury, operational, occupational illness, environmental, reliability, business disruption, and community concerns. The lessons learned from investigations can then be leveraged to reduce or eliminate root causes and prevent future incidents.
Migrated IIR data into Common data model (Azure Data Lake)
Responsibilities
Provides broad understanding of platforms and applications across all technologies.
Created Pipelines in ADF and Azure Synapse to Extract data from third party SaaS sources (IIR Cority.) and ingested into CDM (Common data model) data lake layers.
Transforming data in Azure Synapse Analytics using Apache Spark and interactive python notebooks to
create efficient and scalable data processing and transformation pipelines.
Synapse data warehouse design and DB objects Development.
Scheduling Synapse pipelines and monitoring.
Spark Performance tuning for faster data retrieval and transformation.
Handling Build and deployment through ADO.
Involved in peer review.
Environment: ASP.NET 4.0, C#.NET, Azure Devops, Ansible CI/CD Pipeline, Web API, .NET Core and Azure SQL SERVER.
Project: Integrated Waste Management (IWS) April 2020 to March 2021
Client: Chevron Corporation Limited, US
The Integrated Waste System application is easy-to-use digital solutions that allow Chevron to effectively and efficiently manage and track waste management activities so that the company can assure the exposure to waste related liabilities and risks associated to noncompliance are minimized.
This application allows the following:
Waste Requests being submitted in the field, using a mobile device .
Waste Requests being submitted in the office, using a web application.
Waste Requests being reviewed by Waste Specialists prior to creating shipment requests.
Shipment Requests being submitted for reviewed Waste Requests
Shipment Requests manifests being printed.
Allowing status /commenting and tracking of all the various attributes of Waste Requests / Shipment Requests
Involved in design and programming for both front-end using Blazor and SQL Server.
Initially targeting Chevron Richmond Refinery, MCBU and SJV for first release of MVP Used across the Business Units with no limit on number of users.
Available to Chevron Internal and External users
Integrate waste request into Sphera Essential application, because Sphera Essential is our source of record for reporting and other purpose.
Responsibilities
Analyze, Design, develop and implement systems software using Angular 15, C#.NET, ADO.NET, ASP.NET, MVC, WCF, JQ Grid, SQL Server Technology and Open API (Swagger).
Involving in the full Life Cycle of the project including Analysis Design, Development, Debugging, Testing and Deployment.
Responsible for designing user Interface using HTML5, CSS, Typescript (3.3 & above), jQuery, AJAX, JSON, and Dot.Net Server controls.
Retrieve data from using LINQ Query and Lambda Expressions.
Design and develop Applications using MVC design patterns.
Using Microsoft SQL Server 2022 (T-SQL) to achieve database operations.
Creating technical document, use cases and unit test case scenarios for different functionalities.
Design a SSIS package to extract the master data from Sphera Essential suite to IWS application. The waste requests created or modified in the IWA are also changed and modified in Sphera Essential as Sphera is the application by which waste requests are centrally located and maintained. New waste requests created in Waste application also appear in Sphera Essential.
Created new Web APIs to consume in Angular & Xamarin platforms.
Reviewing of deliverables and deploying the application in the test environment, develop uses cases, test scripts, and initiate the process of User Acceptance Testing (UAT)
Prepare estimates and finalize timelines to implement technical solutions.
Coordination with Vendor, Product owners & other departments for developing business cases.
Designing flowcharts to facilitate programmers to use them while building the system
Prepare the detailed design document.
Train staff and users to work with computer systems and programs
Environment: ASP.NET 4.0, VB.NET, ADO.NET, SSIS, SSRS, UI PATH and SQL Server.
Work Experience
Project: Sphera Essential March 2017 to March 2020
Client: Chevron Corporation Limited, US
The Sphera Essential application (from Environmental Support Solutions, Inc.) was selected by Chevron as the enterprise platform. The application is a data management tool that enables Chevron to capture, manage, and use the information required to support the Compliance Assurance and Environmental Stewardship processes, and relevant Environmental Performance Standards, for all Chevron entities. The Essential Suite tool provides
the added benefit of integrating the management of compliance assurance controls and verification activity with the data and management functions.
Sphera Essential is split into five major Modules
Air
Water
Waste
Audit
Compliance
Sphera Essential is an enterprise-wide application software
Used across the Business Units with no limit on number of users
Available to Chevron and External users
Assure Compliance with internal and external requirements
Enterprise tool for capturing and reporting compliance assurance (CA) and environmental stewardship (ES) data
Responsibilities
Provides broad understanding of platforms and applications across all technologies
Analyzing, Designing, Development, Data modelling, Testing and Deployment for all the application in scope across multiple tools/languages (e.g., Sphera Essential, .NET Framework, C#, Asp.net, Vb.net, SQL Server, SSAS, SSRS, SSIS, UI PATH etc.)
Involved in design and programming for both front-end using Angular and SQL Server.
Perform technology upgrades to Windows 2016 servers with SAML authentication
Technical feasibility and risk analysis of proposed solutions and provide automation solutions to improve the efficiency and effectiveness by reducing manual work
Design a SSIS package to extract data from Sphera Essential suite to CGRES application.
Develop and modify SSRS Reports (SQL Server Reporting Services) to display graphical/visual representation of metrics and data in the application user interface.
Reviewing of deliverables and deploying the application in the test environment, develop uses cases, test scripts, and initiate the process of User Acceptance Testing (UAT)
Prepare estimates and finalize timelines to implement technical solutions.
Coordination with Vendor, Product owners & other departments for developing business cases.
Designing flowcharts to facilitate programmers to use them while building the system
Monitoring the project progress in terms of deadlines cost and standards
Discuss business solutions with Chevron desktop systems operations Business Analysts resolve existing problems and improve the application stability
Prepare the detailed design document.
Developing/modifying new/existing request according to the requirements.
Reviewing of work products.
Monitoring existing systems performance and providing ways to improve the efficiency
Train staff and users to work with computer systems and programs
Environment: ASP.NET 4.0, VB.NET, SSIS, SSRS, Crystal Reports, Ui Path, ADO.NET and SQL SERVER.
Work Experience
Project: Enterprise CHESM Tool April 2014 to March 2017
Client: Chevron Corporation Limited, US
The purpose of the Contractor Health, Environment and Safety Management (CHESM) process is to establish clear accountabilities, ensure active engagement of contractors, and provide a consistent CHESM program to help eliminate health, environment, and safety (HES) incidents and injuries involving contractors. A Contractor Health, Environment and Safety Management (CHESM) process is in place that clearly establishes accountabilities to include:
Identification of company contract “owners” (or management sponsors) accountable for each contract.
Active engagement of contractors in implementing and improving the CHESM program.
A contractor qualification and selection process which addresses HES performance.
Pre-job and work-in-progress activities to verify scope of work, reinforce expectations and monitor compliance to requirements.
A mitigation plan for contractors and subcontractors with poor HES processes and performance.
Identification, effective management, and control of short
Service employees.
Periodic evaluation of contractor HES performance and assessment of the CHESM program.
Responsibilities
Provides broad understanding of platforms and applications across all technologies
Document current state technical design of the ISNetworld data feed to the CHESM DB by individual CHESM DB partition/data feed
Gather Technical Requirements for ISNetworld integration to new CHESM IT Tool
Document Technical Requirements ISNetworld integration to new CHESM IT Tool
Design a SSIS package to extract a data from ISNetworld.
Gather Technical Requirements for CHESM IT Tool SSRS reports
Document Technical Requirements for CHESM IT Tool SSRS reports
Design SSRS reports for CHESM IT Tool based on provided requirements
Environment: ASP.NET 4.0, VB.NET, ADO.NET, SSIS, SSRS and ORACLE.
Work Experience
Project: BBS July 2013 to April 2014
Client: Chevron Corporation Limited, US
BBS Behavior Based Safety (BBS) is a web-enabled application that is widely used in Chevron to support the OE process for BBS. This tool aims to help you enter and review your Behavior Based Safety (BBS) observations as
easily as possible. Recent month and year-to-date status are displayed to give you a summary of the observations you entered.
The application was built in-house and offers a range of customization features to enable tailoring the application to the needs of the business unit.
BBS interact with Spotfire provides an interactive and graphical way to analyze BBS data. This helps to detect trends and see patterns in the data. The standard template provided with the BBS service shows the best practices for understanding what is happening in a large amount of BBS data.
Responsibilities
Involved in gathering requirements for Change Request directly from the customer’s and analysis of the same.
Created complex reports using HTML
Involved in Coding associate phase.
Creation of stored procedures.
Root Cause Analysis for defects and fixing the same.
Deploying the application in Staging and Production Servers.
Environment: ASP.NET 4.0, VB.NET, ADO.NET and SQL SERVER.
Certifications
Work Experience
Project: CHESM Dec 2010 to Till Date
Client: Chevron Corporation Limited, US
The Contractor Health, Environment and Safety Management (CHESM) Database is a web-based tool designed to capture and evaluate Health, Environment and Safety (HES) information about Chevron contractors.
The CHESM application was developed with customization in mind. Almost all parts of the application are customizable in some way regarding which data points are used to calculate the HES rating, the percentages of those data points that make up the HES Rating, the questions, and responses on all the forms used and the scoring of those forms.
Responsibilities
Involved in gathering requirements for Change Request directly from the customer’s and analysis of the same.
Created user controls and reused in multiple places
Created complex reports using HTML
Involved in Coding associate phase.
Creation of stored procedures.
Root Cause Analysis for defects and fixing the same.
Knowledge Transfer to New Joiners and training the Application Support Team.
Deploying the application in Staging and Production Servers.
Environment: ASP.NET 4.0, VB.NET, ADO.NET, SSIS, Aspose PDF and SQL SERVER.
Project: RIMS May 2009 to Nov 2010
Client: Chevron Corporation Limited, US
Tool for capturing and managing project risks. It is also a hub for contractors to communicate with each other through designated Chevron authorities.
Risks and interfaces can be created related to various projects which can be individually maintained. There are specific workflows available to process a particular risk or interface in this application.
Responsibilities
Involved in Coding associate phase.
Creation of stored procedures, triggers
Root Cause Analysis for defects and fixing the same.
Involved in code optimization in front end and backend
Knowledge Transfer to New Joiners and training the Application Support Team.
Deploying the application in Staging and Production Servers.
Environment: ASP.NET 2.0, VB.NET, ADO.NET, SQL Reporting Services, and SQL SERVER.
Project: TIMES June 2008 to April 2009
Client: Chevron Corporation Limited, US
Use the Indexing module to create boxes and folders by entering information into the database. The Box number and folder numbers are system generated unique identifiers. The storage system identifies them using these numbers. Apart from creation of box and folder, indexing module provides facility to edit the box information, to edit folder details, to delete a folder from box and generate a box report. All the functionalities are controlled according to the logged in users privilege level.
Responsibilities
Involved in Coding.
Created complex reports using HTML
Root Cause Analysis for defects and fixing the same.
Deploying the application in Staging and Production Servers.
Environment: ASP.NET, VB.NET, ADO.NET, and ORACELE 8i.
Project: IGSFORUM June 2008 to Dec 2008
Client: Chevron Corporation Limited, US
IGS Forum is a Web based administration. Unlimited number of categories, forums and messages which includes private messaging and private messaging notification features. It has unlimited user groups, with option to automatically promote users based on number of posts. In this application administrators can mass email to all users or specific group. Here user can watch forums or topics for new posts and setup moderators with the ability to moderate topics, posts and user’s signatures.
Responsibilities
Done Code Integration Activities.
Responsible for quality deliverables to onsite.
Participated in the Integration testing.
Environment: ASP.NET, C#, ADO.NET, and SQLSERVER.
Project: EBS Data Conversion July 2007 to Jan 2008
Client: Weyerhaeuser, US
Customer Enrichment tool:
The customer enrichment tool consists of ETL jobs and .Net web pages. This tool allows the extract of customer data from legacy system or manually created data file across multiple legacy systems. These customer records are standardized and compared against each other to form groups of customers that are or could be the same. These groups are displayed to a user through the web GUI to allow them to be validated as the same and or split apart. The GUI then allows the user to determine what the best data is and should be loaded into target SAP client. This should be done without losing any of the user modified changes that were made through the web GUI.
Object ID Management tool
The purpose of the Object ID Management tool is to provide a central entry point for the BW functional spec IDs, development, and conversion IDs. Need to create web pages and database tables that will allow data to be entered, viewed, and updated.
Need ability to email to interested parties when an object ID is created. This should be a separate/modifiable table. There should be a table to enter interested party email addresses and the tool should automatically generate when this option is used.
Need the ability to download the object IDs to a spreadsheet
A group should be created to give permissions to team members who need admin access to the tool. Everyone should have access to the web page (no restrictions).
Everyone will have access to the tool, but only certain people will have permissions to enter Object IDs.
Responsibilities
Involved in design and programming for both front-end and SQL Server.
Developed the Admin, Request Object ID, and View Request Modules independently.
Done Code Integration Activities.
Done test case review and code review.
Responsible for quality deliverables to onsite.
Developed reusable objects and functions.
Participated in the Unit testing.
Project: Athena June 2006 to May 2007
Client: Johnson Diversey, UK
The main objective of ATHENA is to avoid redundancy and to make the decentralized Sku’s (opcos) as centralized Sku’s. ATHENA extracts data from various applications namely PIPE, MRDR, CONDOR, TPS, RMF, SAP. MRDR: It collects data from various databases and generates reports. CONDOR: Deals with sales details. TPS: Transfer Pricing System deals with costing. RMF: Deals with Raw materials and Formulations and Price Forecasting System. PIPE: Deals with the life cycle of product. ATHENA mainly deals with Report Generation, Sourcing Allocation and Migration Planning.
Responsibilities
Involved in design and programming for both front-end and SQL Server.
Developed the User Management, Sourcing Allocation and Migration Planning module independently.
Done Code Integration Activities.
Done test case review and code review.
Done code optimization and SQL tuning
Implemented the application at Client site.
Participated in the Integration testing.
Environment: ASP.NET, C#.NET, ADO.NET, SQL Server and Data Transformation Server.
Project: Contact Management Oct 2005 to May 2006
Client: Reynolds and Reynolds, USA
Contact Management is an Internet lead management and customer relationship application for the automotive industry. The main purpose of Contact Management is to convert Internet Leads into customers, enhance the salesperson’s contact tasks and provide full integration with Dealers DMS.
The web application has following major functions to the dealership:
Client Management
Campaigns
Sales and Vehicle Management
Business Management
System Administration and Tools
Custom Reports
Custom reports deal with converting Activex reports to SQL Reporting Service for clear visibility and easy maintenance. The work also involves creation of new reports from scratch based on customer requirements.
Responsibilities
Involved in design and programming for both front-end and SQL Server.
Developed the Custom Reports Module.
Prepared unit and System test cases.
Done test case review and code review.
Responsible for quality deliverables to onsite.
Environment: ASP.NET, C#.NET, VB.NET SQL Server and SQL Reporting Services.
Project: Human Resource Management System Apr 2004 to Oct 2006
Client: Leading Software Technologies
This Project is to create an Employment Database of the Candidates seeking jobs and Employers offering Vacancies. The Main Components of this project were Data entry of candidate’s Profile, Employers & Vacancy details and Master tables Editing, Displaying and Deleting of Master tables, candidates Profile, Employer’s and Vacancies details, Interview scheduling process and finally making selection list. Filtered Query and Reporting as per employer and candidate’s requirements. Message & matching of the Candidates & vacancies.
This project also deals with Payroll and Leave Management modules which are considered as Post Requirement process.
Responsibilities
Involved in design and programming for both front-end and SQL Server.
Developed the Admin Process Module.
Participated in Integration Testing.
Prepared unit and System test cases.
Education
Degree
Specialization
University
Year of passing
Graduation
B.E in Computer Science
Madras
2004
Passport & Visa Details
Passport No.
X7617978
Valid Upto: 04 Oct 2033
Visa Type
Country
Valid Upto
H1B
USA
11/14/2025
Personal Details
Particular
Details
Name
SUNDARAMURTHY JAGADEESAN
Email ID
**********@*******.***
Client email id
SUNDARAMURTHY_JAGADEESAN
Contact Number – Mobile
Contact this candidate