Deepthi Singidi Email & Phone Number

Mckinney, Tx, Us

Addison,Tx

Irving, Tx

Involved in knowledge transition of TXU.COM project and TXU business domain orientation.Development of technical specifications using Microsoft Visio and Word.Involved in defect fixing in the modules MyAccount, Plans & Offers, and Energy Savings Plans.Involved in bug fixing in SiteCore. Created Sitecore Templates, Sublayouts and Items.Involved in making UI changes using Javascript, JQuery, CSS and Bootstrap.Involded in making UI changes for mobile web and iphone app. Implemented WCF service changes and also upgraded the RFC changes from .Net Connector to ERP Connector. Tested the SAP Function Modules using SAP client as it was the Back End.Upgraded the code to MVP for few modules.

Dallas, Tx

Developed database driven usercontrol to show documentation links for NY and NJ markets. Developed generic and complex customer profile screen for new providers “Central Hudson” and “Orange & Rockland” in New Jersey market. Involved in fixing UI issues.Developed T-SQL script to add document file paths in media server database.Developed stored procedures using T-SQL. Changed resource files for setting up new rate plans in Ambit Energy public site.Publishing and deploying ASP.NET web applications in IIS 7.0.

Irving, Tx

Created tables based on database migration specifications.Developed several complex T-SQL scripts to migrate the data from old database to new database with new schema.Developed SSIS package with sql tasks for data migration.Developed views, stored procedures and stored functions using T-SQL.Developed extended stored procedures and stored functions using .NET and C#. Improved the performance of data migration tasks using temp tables rather than table variables. Identified and implemented non-clustered indexes to improve the performance of sql queries.Implemented changes in data access layer of company directory ASP.NET application to migrate from inlined sql queries to calling stored procs and also to point to next generation framework database.Implemented InvoiceView web application using ASP.NET and C#. Implemented web admin screens using ASP.NET, AJAX, C# and LINQ. These admin screens are used to manage User Profiles, Campaigns, Associations, Products, and lookup tables.Publishing and deploying ASP.NET web applications in IIS 7.0.

Dallas, Tx

Developed consumer reports using SSRS 2008. Developed statistical dashboard reports using SSRS 2008 and Dundas chart controls.Developed stored procedures and stored functions using T-SQL to pull data from SQL Server 2008.Developer and consumed the WCF service to populate the data in the reports.Integrated SSRS reports into web application NBSClientWebSite.Improved the performance of statistical reports loading web page by 70%.Improved the performance of dashboard reports loading web page by 50%.Consumed Microsoft Enterprise Logging application block for logging exceptions and unexpected errors. Attended daily scrum meetings as part of Agile Methodology.

Albuquerque, New Mexico Area

Developed generic data access assembly “NMDWS.Data.SqlClient” based on ADO.NET to access SQL Server. Developed front-end code for Qwest IVR Usage reports web application. I have used ASP.NET 3.5, AJAX 3.5, C# and LINQ in this application.Developed WCF proxy object (WCF client object) to communicate with WCF service “IVRSelfServiceReports” hosted in windows service. This proxy object was required for Qwest IVR Usage reports web application to pull reporting data from SQL Server through WCF Service.Developed different types of IVR call usage reports using SSRS 2008 client reporting model i.e. generating PDF and excel reports from RDLC files.Developed Stored Procedures(sprocs) and Stored Functions using T-SQL to pull appeals, issues, unemployed claimants, and employers data from SQL Server 2008.Developed WCF and Windows services and WCF proxy object to provide secured data access interface for front end code in Appeal Hearings web application. WCF Service makes calls to stored procs to pull/update appeals and hearings related data. Developed front-end code for Appeal Hearings web application. I have used ASP.NET 3.5, AJAX 3.5 and C# in this application.Developed language based document generation process for Appeal Hearing notices, Case Transmittal sheet and Hearing Master schedule. I have used SSRS 2008 client reporting model to generate documents as PDF files.Used FogBugzReport assembly to report exceptions occurred in the code.

Irving, Tx

Developed data access based on ADO.NET, business and front-end code completely from scratch for Customer Web application. I have used ASP.NET 3.5, AJAX 3.5 and C# in this application.Developed SSRS reports based on Client Reporting model for Customer Web application.Using T-SQL, I have developed all stored procedures and stored functions required for customer web application. I have extensively developed XML based T-SQL code. Developed Equipment Pool and Mass Release screens in Equipment module in Admin web application. The screens were developed using ASP.NET 3.5, AJAX 3.5 and C#.Developed Booking, Rail and Dispatch modules in Admin web application. The screens were developed using ASP.NET 3.5, AJAX 3.5 and C#.I have developed XML driven UI in some of the screens. Developed SQL script for performing database health check in production environment on regular basis. Also developed Windows tool using WinForms to perform health check on production database.Developed .NET ASMX web services. These services were consumed by JavaScript methods.Fixed bugs in Booking, Rail and Dispatch modules in Admin application.Agile and XP software development methodologies were followed.

Houston, Texas Area

Developed Reports using SSRS 2005 which would give a detailed analysis of the inventory, Users, Cost spend and Transaction level information. Used SSIS 2005 in sending email alerts to the clients whenever they are out of threshold limits and moving data between different databases.Features such as storing the favorites as their bookmarks and filtering based on the user requirements were implemented. Implemented trending which would give a detailed analysis of the Data they are looking at as graphs using the Dundas chart controls.Implemented many stored procedures which would give a detailed analysis of the Transactions based on the requirements.Changed business object to include discrepancy of the item and cost spent on it. This would give a detailed analysis of discrepant quantity and amount spent at all levels.