Worked on power commodity ETRM and credit risk management

Summary

Accomplished IT professional with ** years of experience spanning multiple domains including web technologies, business analysis, data analysis, and manual testing. Expert in bridging business needs with technology solutions, with direct expertise in the Energy Trading and Risk Management (ETRM) space, including 3 years of onsite experience working directly with clients.

Proven ability to analyze business requirements, design data models, and optimize workflows to drive business performance. Skilled at supporting cross-functional teams, ensuring quality in all phases of the SDLC, and providing actionable insights through data analysis. Enthusiastic about delivering innovative solutions that meet both business objectives and technical specifications.

Key Responsibilities

Risk Management & Credit Exposure Analysis:

oCollaborated with risk management teams to develop and implement comprehensive credit risk assessment frameworks.

oAnalyzed trading data to identify potential credit exposures and recommended effective risk mitigation strategies.

Stakeholder Collaboration & Requirements Gathering:

oLed workshops with stakeholders to gather detailed business requirements, ensuring alignment with organizational objectives.

oTranslated business requirements into functional specifications, ensuring clear communication between business and technical teams for seamless implementation.

Testing & Quality Assurance:

oDeveloped, reviewed, and executed high-quality test scenarios, input test data, and expected results for all phases of testing.

oPlayed a key role in preparing test plans, writing test cases, defect tracking, and suggesting improvements to enhance application quality.

oIdentified potential issues and created targeted tests to expose bugs, effectively communicating issues to relevant departments and application teams.

oPerformed back-end testing, data validation, and database testing using SQL queries; involved in validating functional, integration, and regression test suites.

oTested Web APIs using tools like Fiddler and Postman, ensuring robustness and functionality.

Software Development & API Design:

oDesigned and developed customized software solutions using web, windows, and service-based platforms with a focus on Microsoft technologies.

oDeveloped and maintained RESTful APIs using the .NET framework, ensuring API security and scalability.

Database Design & Management:

oOver 10 years of experience designing databases, writing stored procedures, functions, triggers, views, and complex SQL queries in SQL Server.

Business Intelligence & Reporting:

oExperience with Business Intelligence solutions such as SSRS and Power BI, delivering insightful and accurate reports to drive business decisions.

Cloud Migration & DevOps:

oContributed to application migration to AWS Cloud, working extensively with EC2, S3, EBS, CloudFormation Templates, Load Balancer, and Code Deploy services.

oGained direct experience with the AWS Cloud Environment to optimize applications for scalability, security, and performance.

Domain Knowledge

Project Management System (PMS):

Experience working on Project Management Systems that encompass project planning, resource allocation, task management, and progress tracking. Proficient in using version control systems, project management software, issue tracking tools, and communication platforms to ensure successful project delivery within time and budget constraints.

E-Learning:

Deep understanding of E-Learning systems promoting flexible, accessible education, allowing learners to study at their own pace. Familiar with Learning Management Systems (LMS), interactive content, multimedia resources, and assessment tools, as well as mobile integration to support on-the-go learning. Focused on enhancing learner engagement and improving learning outcomes through technology.

Energy Trading and Risk Management (ETRM):

Expertise in ETRM systems that support the buying, selling, and hedging of energy commodities such as electricity, gas, and renewable energy credits. Key components of domain knowledge include:

oTrading Management: Real-time support for trading operations to ensure efficient transaction execution in volatile markets.

oRisk Management: Assessing and mitigating financial risks related to market volatility, credit exposure, and operational risks.

oRegulatory Compliance: Ensuring adherence to industry regulations and reporting requirements for financial and operational transparency.

oMarket Analytics: Utilizing data analysis, forecasting, and scenario modeling to inform strategic trading decisions.

oSupply Chain Optimization: Managing logistics, scheduling, and inventory to streamline operations and ensure effective supply chain management.

Technical Skills

Programming Languages & Frameworks:

oDot Net, C#, ASP.NET MVC, WEB API, Entity Framework

Database Management:

oSQL Server, RDS SQL Server, Azure Databricks SQL, SQL Query Optimization

Reporting & Analytics Tools:

oSSRS, Power BI, Data Visualization

Cloud & DevOps

oAWS Cloud, Azure (including Azure Databricks and data services)

Software Development & Methodologies:

oFull Software Development Life Cycle (SDLC), Agile, Scrum, Manual Testing

Academic Qualification

Bachelor of Engineering (B.E.) in Computer Science

PES Engineering College, Mandya, Karnataka, India — 2004

Employment Details

Infosys, Mysuru

Technology Lead

Period: August 2018 – Present

Excel Soft Technologies, Mysuru

Senior Tech Lead

Period: November 2010 – August 2018

Larsen & Toubro Limited, Mysuru

Software Engineer

Period: July 2007 – November 2010

Project: Price Stress Test (PST) – INFOSYS – BP - Onsite

Duration: March 2024 – Present

Objective:

The PST tool assesses how counterparties and portfolios perform under different market conditions by simulating various price scenarios. It helps in evaluating potential exposure in stressed environments.

Key Components:

1.End of Day (EOD) Scenarios:

oOvernight simulations of four pre-determined price stress tests:

Severe up: +100% price increase

Moderate up: +50% price increase

Severe down: -50% price decrease

Moderate down: -25% price decrease

2.Ad-hoc Scenarios: Bespoke scenarios that can be set up by users.

3.What-If Test: Evaluates new deals against credit limits based on potential market changes.

Roles and Responsibilities:

Analyze current systems and propose improvements.

Design workflows, diagrams, and write specifications based on system capabilities.

Prepare technical reports by gathering, analyzing, and summarizing trends and information.

Contribute to team efforts by meeting targets and delivering results.

Validate resource requirements and provide demonstrations to clients for signoffs.

Project: Financial Regulatory Reports – INFOSYS – BP - Onsite

Duration: March 2024 – Present

Objective:

The project involves automating regulatory reports within an ETRM (Energy Trading and Risk Management) system to ensure compliance with regulations such as Dodd-Frank. The reports track trading activities, counterparty credit risks, and exposures, and they help energy trading companies meet regulatory requirements in a structured and accurate manner.

Key Focus Area:

Counterparty Credit Risk Reports: These reports assess the creditworthiness of trading partners.

Benefits:

Reduced Compliance Risk: Automated reporting minimizes errors and delays in submitting regulatory data.

Improved Efficiency: Streamlined processes for data collection and reporting.

Enhanced Transparency: Accurate and easily accessible data that improves insights into market positions and risk management.

Roles and Responsibilities:

1.Requirement Gathering & Documentation: Collect and document detailed specifications for the project requirements.

2.Demonstration to Development Team: Present the requirements to the development team for clarity and understanding.

3.Follow-up on Development & Testing: Ensure the development process is on track and that the system is rigorously evaluated.

4.Functional Validation: Contribute to team efforts by validating functional aspects of the system as needed.

5.Client Demonstration & Sign-off: Provide demonstrations to the client to ensure the system meets requirements, then get their sign-off.

6.Postproduction Validation: After the system goes live, perform validation to ensure all requirements are met and the system works as expected.

Project Title: Commodity Power Enhancements – INFOSYS – BP – Onsite

Duration: November 2022 to December 2023

Project Description:

Project involves enhancement of an ETRM system tailored to the power commodity markets. The primary objective was to enhance trade capture, risk analysis, scheduling and reporting for both physical and financial power trading across multiple regions and markets.

Scope of work:

Integration with ISO/RTO market operators (e.g. PJM, ERCOT, CAISO, NYISO).

Trade life cycle management: deal capture, confirmation, and settlement.

Real-time position reporting & PNL calculation.

Risk Management: VaR, Credit Exposure, and stress testing.

Regulatory Reporting and Compliance (e.g. FERC, NERC REMIT).

Interface development for market data feeds and downstream ERP systems (e. g SAP, Oracle).

Business Benefits:

Streamlined power trading operations and reduced manual processes.

Improved accuracy of PnL and risk metrics.

Enhanced compliance with market and regulatory requirements.

Better decision- making through real time data visibility.

Role and Responsibilities:

Test Case Development & Execution:

oDeveloped detailed test cases and executed them to ensure comprehensive coverage of application functionality.

oPerformed test results analysis, documented findings, and provided clear reporting to stakeholders.

Collaboration with Stakeholders:

oWorked closely with Business Analysts to clarify requirements and ensure proper understanding for test case development.

oPartnered with IT development teams and business analysts to integrate testing activities throughout the software development lifecycle.

Test Planning & Execution:

oReviewed test scenarios with the business analyst and development teams for feedback and sign-off before test planning and execution.

oIncorporated feedback and adjusted test plans accordingly to ensure alignment with project goals.

Functional & Non-Functional Testing:

oConducted various testing types, including accessibility testing, component/integration testing, and cross-browser testing.

oPerformed smoke testing to validate that the test environment was stable and functional before detailed testing.

oExecuted sanity testing after each build deployment to ensure the basic functionalities were working as expected.

oConducted negative testing to identify and report unusual or unexpected behaviors.

Defect Tracking & Reporting:

oLogged and tracked defects identified during test execution and reported them to the development team for timely resolution.

oFollowed up with the development team to ensure prompt defect fixes and retested fixes in the appropriate test environments.

oUtilized test management tools like Microsoft TFS and HP ALM to document and manage defect status and closure.

Regression Testing:

oPerformed regression testing to confirm that latest changes did not introduce defects in existing functionality.

Traceability & Test Coverage:

oDeveloped a traceability matrix to ensure 100% test coverage against business and functional requirements.

Team Communication & Reporting:

oFacilitated regular meetings with the project team to share testing progress, identify risks, and discuss testing status.

oCommunicated clearly with all stakeholders regarding testing outcomes, defects, and necessary actions.

Project Title: Capacity Management Information System – INFOSYS

Duration: October 2019 to November 2021

Project Description:

The Capacity Management Information System (CMIS) is a monitoring and reporting platform developed to track the performance of on-premises servers within the BP infrastructure. The application captures and analyzes key performance metrics such as CPU utilization, memory usage, disk space, network throughput (Net In/Out), swap space, queue length, and page requests. The goal of the system is to provide actionable insights into server health, utilization patterns, and infrastructure optimization.

The platform enables initiative-taking, decision-making regarding server resource allocation—whether a server is underutilized, overutilized, needs to be upgraded, downsized, or decommissioned based on predefined utilization benchmarks.

Key Features:

Server Health Monitoring: Assesses CPU and memory utilization to determine if servers are performing within optimal thresholds or need scaling adjustments.

Heat Map Analysis: Offers a graphical representation of Key Performance Indicator (KPI) metrics. This feature enables quick visual assessments of server utilization using color-coded benchmarks to facilitate fast and accurate decision-making.

File System Metrics: Monitors disk space trends across servers, estimating how long (in months) before capacity is reached. It helps in planning for disk upgrades or identifying over-provisioned systems.

This system provided BP with a comprehensive overview of server utilization, allowing for efficient capacity planning and IT infrastructure cost optimization.

Role and Responsibilities

Solution Design & Architecture: Contributed to the design and architecture of web applications, ensuring scalability, performance, and security.

Security Enhancement: Identified and addressed web application security vulnerabilities, recommending, and implementing fixes to improve overall security posture.

Documentation: Created detailed low-level design documents, including class and sequence diagrams, as well as high-level functional specifications.

Code & Design Reviews: Actively participated in code and design reviews, using Check style for maintaining code quality and ensuring adherence to coding standards.

Vendor Coordination: Collaborated with geographically distributed teams and multiple vendors, ensuring smooth development, testing, and deployment of the project.

AWS Deployment: Contributed to the deployment and management of applications within the AWS Cloud, optimizing resources for cost and performance efficiency.

Corporate E-Learning Product – Excel Soft Technologies

Duration: 3+ years

Role: Tech Lead

Environment: MVC, ASP.Net 4.0, C#, MS-SQL 2012, SSRS Reports, AngularJS

Project Description:

Led the development of an e-learning platform designed to provide online courses, classroom training, and assessments for employee development. The product serves clients across various sectors, including banking, insurance, and corporate firms, enabling them to train their employees and ensure skill proficiency.

Key Contributions:

Platform Architecture: Oversaw the design and architecture of the e-learning solution, ensuring seamless integration of content delivery and training tools.

Course & Assessment Development: Collaborated closely with stakeholders to design and implement training modules and assessments to evaluate employee progress.

Technology Leadership: Led a team of developers, guiding them in the use of MVC, ASP.Net, C#, and AngularJS to deliver a robust and user-friendly platform.

Reporting: Integrated SSRS reports for data analysis and progress tracking, allowing businesses to monitor training effectiveness.

Client Interaction: Functioned as the primary point of contact for key clients, tailoring solutions to meet specific organizational goals and ensuring user satisfaction.

This platform empowers employees to adapt and enhance their skills through continuous learning, contributing to higher productivity and goal achievement.

Responsibilities:

Collaborated with the Business Analyst to gather and understand functional and technical requirements.

Analyzed requirements and performed story breakdown to define development tasks and timelines.

Prepared design documents and assisted the team in creating technical designs, including workflow diagrams and architecture outlines.

Implemented user stories with thorough unit testing to ensure functionality and code quality.

Developed SQL Server stored procedures and optimized report-based queries to support reporting needs.

Designed and implemented SSRS reports related to online courses, classroom training, and assessment analytics.

Created HTML5-based reports for course usage, grade books, and e-learning statistical analysis.

Conducted peer code reviews, provided constructive feedback, and ensured adherence to coding standards.

Resolved technical impediments and supported the team in overcoming development challenges.

Documented user story acceptance criteria for better traceability and testing.

Provided production support for deployed user stories, ensuring system stability and issue resolution.

Video-Based Learning – Data Sync from Authoring to Delivery System

Duration: 3 months

Role: Tech Lead

Environment: MS-SQL 2008, SSIS Packages

Project Description:

Led the development of a data synchronization mechanism for a Video-Based Learning application, enabling seamless transition of authored content from the Authoring System to the Delivery System. The application allows administrators to author learning content, which goes through an approval process. Once approved, the content can be synced on-demand to the delivery platform for learner access.

Responsibilities:

Designed and implemented SSIS packages to facilitate data synchronization between systems.

Utilized SFTP for secure file transfers between the Authoring and Delivery environments.

Ensured seamless on-demand data sync via the web application interface, providing real-time content availability.

Collaborated with stakeholders to define sync requirements and ensure data integrity during transfer.

Performed testing and validation of data consistency across systems post-sync.

Provided technical leadership to ensure reliable and secure data exchange processes.

Prerequisite Set up tool and Pre Health-Check (Automatic required software deployment)

Duration: 6 months

Role: Tech Lead

Environment: .Net 4.0, C#.Net

Project Description:

The toolset helps ensure smooth software deployment by performing the following:

1.Pre-Health Check Tool:

oSystem Health Monitoring: Checks the system’s health before deployment to confirm it meets the required specifications.

oSystem Information: Gathers details like:

Available and free disk space

Operating system version (e.g., Windows 7, 8, 10, 12)

Installed browsers.

oCompatibility Check: Ensures that the system meets the minimum requirements to install the software, such as checking whether necessary frameworks or services are already installed.

2.Prerequisite Setup Tool:

oSilent Installation: Automates the installation of prerequisites (e.g., .NET Framework, SQL Server, and any other dependencies) without requiring user interaction.

oASP.NET + SQL Server Setup: Installs the necessary software to run an ASP.NET application with SQL Server as the backend.

oCross-OS Compatibility: Supports a variety of operating systems, including Windows 7, 8, 8.1, 10, and 12, on both 32-bit and 64-bit machines.

3.Deployment Technology:

oDeveloped using .NET Framework 4.0 and C# for logic.

oUtilizes Click Once Deployment for distributing and installing applications with minimal user involvement.

Challenges and Considerations:

Cross-Version Compatibility: Ensuring that the tool worked across various versions of Windows (7 to 12) could have presented challenges in detecting system configurations, managing different permissions, and ensuring compatibility with various hardware configurations.

Silent Installation Process: While silent installations are user-friendly, they often require careful handling of errors or failures during installation (e.g., handling permission issues or missing prerequisites).

Error Logging and Handling: Providing robust logging during the health check and installation process would be crucial for troubleshooting any deployment issues, especially when dealing with different environments.

Saras Reporting Tool

Duration: 4 months

Role: Tech Lead

Environment: .Net 4.0, C# .net, jQuery, SQL SERVER 2008 R2

Project Description:

The Ad Hoc Reporting Tool empowers end users to generate customized reports on demand, using a flexible dataset designed for self-service analytics. Users can create and visualize data through a variety of formats including tabular reports, matrix layouts, and analytical charts such as pie charts, bar graphs, and stacked bar charts.

Key features include:

Self-Service Report Creation: Users can build and modify reports without technical assistance.

Multiple Visualization Options: Supports pie, bar, and stacked bar graphs for clear data insights.

Flexible Report Formats: Includes tabular and matrix reports to meet diverse reporting needs.

Export Capability: Reports can be exported directly to PDF for sharing or offline access.

Real-Time Analysis: Enables users to draw reports on the fly for immediate decision-making.

This tool is ideal for organizations seeking dynamic reporting capabilities with intuitive data visualization and export features.

Responsibilities:

Requirement gathering

Implementation of the tool by designing the tables, stored procedures.

Implementation of report generation by drag and dropping the columns required to generate the reports by selecting the stored procedure columns.

Unit testing.

Demo to internal stake holders

Documentation of the tool functionality.

Production support.

Pegasus – E-Learning System

Duration: 2.2 years

Role: Tech Lead

Environment: .Net 4.0, C# .net, jQuery, SQL SERVER 2008 R2

Project Description:

Pegasus is a comprehensive e-learning platform designed to enhance digital education through content delivery, assessments, and performance tracking. The system supports students in learning course materials, taking assessments, and receiving grades based on their performance.

Core Features:

Content Delivery: Enables students to read and learn educational material.

Assessments: Facilitates the creation and management of tests and quizzes.

Grading System: Automatically evaluates and grades student performance.

Key Contributions:

1. Admin Module:

Developed features for book publication workflow, allowing content to be published and utilized within the platform.

Implemented organization management, including creation of institutions and administrative roles.

Built functionalities for user management, allowing creation of teachers, students, aides, and organization admins.

Enabled course management, including course creation and user enrollment to control access.

Supported product creation, publishing, and licensing to organizations, ensuring proper distribution and access control.

2. Calendar Module:

Designed and implemented features to allow teachers to assign course content to students for specific class periods.

Supported content scheduling, enabling flexible delivery of materials based on calendar availability.

Developed calendar UI views for students and teachers to track assignments and schedules by day, week, and month.

Responsibilities:

Worked as Tech lead.

Requirement gathering through FTR (Feature Team Review) and Analysis

Technical Architecture Design preparation for the user story.

Resource planning and schedule preparation.

Code reviews, test case reviews, use case reviews.

SPLICE-M -Software Project Life Cycle Management

Duration: 10 months

Role: Senior Software Engineer

Environment: .Net 2.0, C# .net, SQL SERVER 2005

Description:

SPLICE-M is a comprehensive web-based project management tool designed to serve as an end-to-end solution for managing the software development life cycle. It provides a unified platform for enterprises to operate, manage, and monitor their projects under a single login system.

The tool plays a key role in deploying and institutionalizing the Quality Management System (QMS) across projects, ensuring standardized processes and compliance.

Key Features:

End-to-End Project Lifecycle Management: Supports planning, execution, monitoring, and closure of software projects.

Enterprise Single Sign-On: Enables users across the organization to access project resources securely with a single login.

QMS Integration: Embeds quality management principles into every phase of the software development lifecycle.

Tool Integration: Seamlessly integrates with:

oMicrosoft Office (for documentation and reporting)

oMicrosoft Project (for project planning and scheduling)

oMicrosoft Visual SourceSafe (for version control and code management)

Responsibilities:

I worked as a Senior Software developer.

Requirement gathering and design documentation for the work-flow process.

Implementation done for the review process workflow in the SPLICE-M

unit test case preparation and Unit testing

Help desk Utility – IT Service Portal

Duration: 3 months

Role: Senior Software Engineer

Environment: .Net 2.0, C# .net, SQL SERVER 2005, SSRS reports

Description:

The Help Desk Utility is a web-based application developed as an internal IT services portal for organizational users. It serves as a centralized platform for managing and tracking IT service requests efficiently.

Key Features:

Service Request Submission: Users can submit requests for various IT services directly through the portal.

Call Tracking: Users can track the status of their service requests (calls) in real time, improving transparency and communication.

Template and Software Downloads: The portal provides access to commonly used templates and approved software for download, reducing dependency on IT staff for routine resources.

Call Closure Reports: IT Service Administrators can generate and manage detailed call closure reports for auditing, review, and service quality analysis.

Responsibilities:

Worked as Senior Software Engineer

Requirement gathering and design preparation.

Implementation of the ticket display after sending close mail to a respective recipient.

unit test case preparation and Testing

TLS-450 Test Management Suite

Duration: 10 months

Role: Software Engineer

Environment: Squish, python, SQL SERVER 2005, SSRS reports

Description:

TLS 450 is a device used to monitor gas station operations and generate reports on various activities and performance metrics. To ensure the reliability and accuracy of the TLS 450 application, the TLS 450 Test Management Suite was developed to automate and manage GUI and functional testing.

Test Management Suite Overview:

The Test Manager is a web-based application designed to manage and execute the test processes for the TLS 450 application. It provides a centralized platform for initiating and tracking test activities.

Key Features:

Automated Testing Management: Allows initiation of automated GUI and functional tests through the Test Manager interface.

Build Selection: Supports the selection of specific build versions for targeted testing.

Modular Test Suite Structure: Organized using a tree structure, enabling modular breakdown of test cases into GUI, Functional, and Module-specific tests.

Result Logging: Captures and stores test execution results in a MySQL database for tracking and analysis.

Reporting: Generates detailed SSRS (SQL Server Reporting Services) reports for comprehensive result review and documentation.

Email Notifications: Automatically sends test results and reports via email to designated recipients.

Responsibilities

Worked as a software Engineer.

Understanding the test case, manual testing.

Estimation and planning

Test scripts writing.

Code review and integration of the test scripts.

Regression testing.

Development of the test manager and report application.

Sales Tracker – Sales Order Management System

Duration: 1.2 years

Role: Software Engineer

Environment: .NET 2.0, JavaScript, SQL SERVER 2005

Description:

Sales Tracker is a web-based application designed to manage and streamline the process of sales order tracking and reporting. It provides a centralized system for handling various sales-related and administrative activities, ensuring accurate data management and operational efficiency.

Key Features:

Sales Order Tracking: Enables real-time tracking of sales orders throughout their lifecycle.

Reporting: Provides comprehensive reporting capabilities for sales performance, order history, and other key metrics.

Administrative Functions: Supports essential admin activities related to sales tracking, Including user management and data configuration.

Data Consistency: Ensures accurate and consistent data handling across all modules to support decision-making and reduce errors.

Responsibilities:

Worked as a Software Engineer

Requirement gathering and design preparation.

Implementation of the sales order tracking workflow and display of the sales order details along with status in the report, export functionality.

unit test case preparation and Testing

In Sync – Corporate HR Portal

Duration: 4 Months

Role: Software Engineer

Environment: Dot Net2.0, SQL SERVER 2005, JavaScript

Project Description:

In Sync is a web-based application developed on SharePoint Server 2007, designed as a centralized Corporate HR Portal for employees within an organization. It serves as a comprehensive platform to streamline HR communication, resource access, and employee engagement.

Key Features and Capabilities:

Centralized Information Sharing: Facilitates efficient dissemination of HR-related content and updates across the organization.

Contact this candidate