Thimmaiah Chetranda

Experience

• 

  EClerx Service Ltd

  Jan 2007 - Apr 2007

  Analyst

  Analysis of product data involving prices and information from Dell.com database using MS Excel. Querying of data using SQL querying language for maintaining reports

• 

  Credit Solutions America

  Feb 2009 - Aug 2009

  Business Analyst

  Software Project requirements gathering from internal Clients such as Debt Consultants, Settlement Advisors and Client Services representatives for the enhancement of internal Databases, the Client Portal and user interface of the official company website. Responsible for the addition of enhancements to the newer version of the Customer Relationship Management System for dealing with external Clients.

• 

  Black & Veatch

  Sept 2010 - Feb 2019

  Senior Analyst

  • Command Center Head End System Upgrade Project– Responsibilities included regression, system and integration testing of the Command Center Head End System Upgrade from versions 6.3 to 7.1. Integration testing of Head End system functionality with downstream systems such as MDMS(Meter Data Management System), CSS(Customer Service Suite Billing System), MAM (Meter Asset Management), Middleware, SDOM (Smart Data Outage Management), DMS (Distribution Management System) and OMS(Outage Management Systems).Testing of functionalities included Remote Connects/Disconnects(RCDs), CMOs(Change Meter Orders), Outage and Temperature threshold Event functionalities.• MDMS Outage Management Project - Testing of new functionality for the introduction of Outage flags for missing Interval data on the Oracle Meter Data Management System (MDMS), consumption of this data by the Customer One CSS Billing system. Utilized MS SQL Server, Oracle SQL Developer and DB2 databases to extract and simulate the data required for testing. Batch jobs executed using the UNIX platform to develop automation of batch execution processes• Programming modules for creation of new programs for reporting Temperature Threshold Alerts and generation of Service Orders in the CSS CRM system• Batch scripts for automation of PLSQL report execution were developed using the UNIX platformProduction Support Analyst, Exelon Energy, Sep 2010 – Oct 2012• Managed the Production Control System (PCS) to adhere to the Software Development Life Cycle (SDLC)• Provided Database Maintenance database (using TOAD / SQL Developer) and Management Support of Oracle Lodestar Pricing/Billing Systems to the Business team in creating new Electricity contracts by using Historical and Forecast Usage data• Developed and managed Windows batch programs for daily batch process jobs related to Billing/Invoicing• Performed requested tasks using HPQC (Quality Center) as per business priority Show less

• 

  Smart Grid Ventures

  Feb 2019 - now

  Senior Consultant

  • Worked on Integration, System testing and quality assurance of the existing Meter Data Management System with the Head End Source data system while upgrades to new versions were being performed• Functional requirements, use case and test case development for enhancements of monitoring tools for the daily meter operations. Meter operations include monitoring of alarms and alerts generated by faulty meters or meter events, remote connect/disconnect monitoring, revenue protection monitoring and meter data exception monitoring• Developed new solutions on the Middleware LINUX server systems using Unix for execution of PLSQL and batch scripts for automation of daily process jobs related to network device (Routers and Collectors) monitoring for field operations• Development of SQL queries and PLSQL code for quality assurance testing of enhancements using Oracle SQL developer and MS SQL Server from databases for new functionality developed on the Meter Data Management, Source data and Asset Management systems Show less