Usha Kiran
***.******@*****.***
Professional Summary:
9+ years of professional experience in development, migration, testing, support and maintenance projects.
Extensive experience working in ASP, ASP.Net, MVC, C#.Net, MS SQL Server 2000, 2005 and 2008.
Working experience in GUI Design, OLEDB, ODBC, JavaScript, AngularJS, knockout, XML and IIS.
Experience working with HTML, XAML, CSS, Web API, Crystal Reports, BO, SSIS and SSRS.
Strong knowledge of integration technologies and web service methods using SOAP UI.
Experience in developing, setting up of Development, Disaster Recovery and deploying in a distributed environment, verification and validation of new environments.
Extensive experience in providing L2/L3 support for critical production applications also including creating and tracking work requests, incidents and problem tickets within SLA.
Experience working with various database system, SQL servers, and frameworks.
Professional experience on projects including web layout enhancements, desktop applications, web-based applications, and database-backed websites.
Has good knowledge in entire Software Development Life Cycle.
Has got good experience in gathering requirements which includes analysis, planning and understanding of requirements, documenting the requirements and providing the required interface control document (ICD) and Technical Design Document (TDD).
Coordinated with the teams in implementing any new process or changes to existing project and follow up on the project completing the relevant requirements and documenting all the deliverables which have been properly reviewed by stakeholders.
Researched, created, reviewed, and revised process documents and project management approaches, tools and phases of the project lifecycle.
Development of project scope, collection and documentation of business requirements, preparation of related process documentation, preparation of change document and coordination of user acceptance testing.
Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into functional/technical requirements.
Experience in managing process project delivery, leading team in requirement analysis/design, schedule and execute all stages of enterprise software, hardware and system implementations.
Worked closely with various project stakeholders, Subject Matter Experts (SME’s) and staff to understand and document business requirements, functional requirements, and design specifications for new applications along with enhancements to the existing applications.
Has got domain expertise in Energy and Utilities, Health Care and Pharmacy, Client/Server and Web applications using Microsoft and Java technologies.
Technical Skills:
Operating systems
Windows XP, Windows 7, Windows 10
Microsoft Technologies
ASP, ASP.Net, C#.Net, MVC, MS SQL, Oracle, SSIS Packages
Data Bases
MS SQL Server 2000, 2005 and 2008
Scripting Languages
HTML, XML, CSS, AngularJS, Knockout and JavaScript
Other software
Crystal Reports, Business Objects6, MS Office, VSS, SQL ETL Tool,Visual Studio .Net 2003, 2005, 2008,Remedy V7.5 IT Service Management Tool, MS Visio
Project Profile:
Client: Wells Fargo, San Francisco, CA
Project: Enterprise Business services Technology (EBST) Jul’17 to Till-date
Project Description:
The Enterprise Business services Technology (EBST) program objective is to establish Wells Fargo as the global choice for their commercial banking customers.
Product, technology and operations work streams will define a new Global Branch Core platform architecture leveraging common software solutions for all GBE markets creating a consistent implementation pattern and customer experience architected in advance of any market deployment.
The objective of this integration project is to build enterprise integration and workflow orchestration between the newly defined Global Branch Core applications and existing Wells Fargo enterprise applications.
Responsibilities:
As a Lead Engineer, was responsible
Stakeholder management and business interaction on business requirements
Analysis of requirements for new enhancements and prepare detail requirement specs
Analyze business application use cases
Involving in coding and unit testing
Involving in defect triages, analyze and defect fix
Support various process such as review, release in project life cycle
Prepare unit test scenarios and maintain traceability matrix
Review system and integration test cases
Prepare user acceptance test cases and own the complete UAT process
Perform reconciliation of result sets
Client: CVS Caremark, Buffalo Grove, IL
Project: Enterprise Digital Production Support Mar’15 to July’17
Project Description:
Caremark Mobile Applications are the systems to track/ Order caremark PBM & Specialty prescriptions through Mobile device. A Prescription Benefit Manager( PBM) is an Organisation that manages prescription drug benefits for clients and plan participants( members).PBM services include administering and processing claims, developing network and contracting with pharmacies, providing mail order service, ensuring appropriate drug usage by working with physicians, pharmacists, plan participants, consulting with clients to provide optimum plan performance and negotiate with manufacturers for rebates and program funding. Mobile Applications are used by registered patients using their mobile device. The front end of the applications are developed using AngualrJS and for all its functionalities it calls the domain services.The Project involves providing production support for the Enterprise Digital Mobile Applications. It involves resolving issues, providing enhancements to existing functionalities, monitoring and fixing batch job issues at the customer location.This is for end to end production support for CVS IT portfolio based applications based on Microsoft and Java technologies.
Responsibilities:
As a Lead Engineer, was responsible
Validate and monitor the availability of the ICET, Mobile Apps and work out resolutions of incidents reported by application users.
Interaction with business Users for requirement clarification and resolution of problems being reported.
Participate in Metrics collation and review & Manage issues, Risk Identification and Mitigation plans.
Attend Project Turnover meetings and shakeout meetings for all the planned and emergency deployments.
Ensure that Process adherence, quality standards of the deliverables are met.
Participate in internal review with leads and managers.
Manage, Monitoring and Design for minor enhancements.
Interact and coordinate with global teams for getting the work done on time.
Client: Laboratory Corporation of America Holdings (LabCorp), Burlington, NC
Project: Workflow App Dev and Support Sep’14 to Dec’14
Project Description:
LabCorp Workflow AppDev department develop / support of three applications namely DocFinity, mPower, Artiva software for MS SQL Server upgrade, SSIS packages, SQL Data Base tuning, stored procedure development and other related tasks used for 3rd Party Billing, Client and Patient Billing departments.
Responsibilities:
As a Lead Engineer, was responsible for
SSIS Package Development.
SQL Server Maintenance and Query Development
Requirements Analysis for new enhancements
Application Development and Unit Testing
UI Design and coordination
Integration and System Testing
UAT Support and Deployment
Production Support
Status reporting to LabCorp Management.
Core platform: SQL Server DB-, MS SQL Server 2000, 2005,2008 and SSIS ETL tool.
Client: BP US Supply, Warrenville, IL
Project: BP US FVC Supply Feb’12 to May’14
Project Description:
There are 3 applications that are currently being handled
Aspen Retail, CU website (Development and Support), Load Tracker, Tas User Access Website
Responsibilities:
As a Programmer Analyst, was responsible for
Enhancement of the Aspen Retail and CU Website by fully integrating the software system for logistics scheduling and optimization using ASP.net, Oracle 11g.
Coding for new requirements and fixing the issues.
Maintenance of the Aspen Retail and CU Website applications.
Project release coordination for major releases and providing constant updates to the user.
Involved in supporting of new requirement gathering and analysis of Load Tracker and TAS-C applications.
Providing support to the users of the Aspen Retail and CU Website applications.
Development of Load Tracker using BO and Crystal Reports which is a primary reporting tool.
Migrated TAS User access application to latest version Visual Studio 2008.
Cloned BP version of Load Tracker and Aspen CU as part of Project COOPER to New TESERO environment for TESERO client which supports Southwest Terminals.
As part of TAS Upgrade Project identified all users mapped to the terminals using SQL and migrated the data files to the scheduled terminals, servers involved in migration are TopHat (UNIX System) to TopTech (UNIX System).
Used Remedy to track the service and incident tickets for production support
Core platform: ASP, ASP.NET, MS SQL Server 2000, 2005
Client: BP US Pipelines and Logistics, Warrenville, IL
Project: Win2k Remediation Sep’ 11 to Feb’ 12
Project Description:
Win2K Remediation Project is aimed at creating Dev and DR setup, executing failover\failback testing for eight applications below under USPL embedded apps umbrella.
Responsibilities:
As a Senior Project Engineer, was responsible for
Migration project to superior servers i.e. app servers from win2003 to win 2008 and database servers from sql server 2000 to sql server 2008 and support after migration
New DEV and DR Environment on win 2008 servers and migrated existing TEST and PROD application which were on Win2003 Server to Win2008 and their Databases which were on the SQL Server 2000 to SQL Server 2005. Following application have been impacted as part of migration.
USPL Intranet
Travel Approval Tool
Job Skill Testing (JST)
Financial Reporting System (FRS)
PLTCC Timesheets
Reward & Recognition (Carving out of DSST)
TAS User Access Website
Contractor Selection Tool (CST)
Core platform: ASP, ASP.NET, MS SQL Server 2000, 2005
Client: BP US Supply, Warrenville, IL
Project: Prism Jul’ 10 to Feb’ 11
Project Description:
British Petroleum US Supply Project works for BP Client in US for Petroleum business in Retail and Marketing Area. I worked in Logistics Area under support and maintenance which deals With loading and unloading fuel through Trucks. I have handled TAS UID, JST, RR, Travel Tool, Prism applications for development and support
Responsibilities:
As a Senior Project Engineer, was responsible for
TAS UID: This application is a web based tool used by the TAS-C users to register for a user id and password for Terminal Automation System. Involved in enhancement of providing consolidated Interface provision and other functionalities like applying SOX compliance on TAS.
PRISM: Support of Project PRISM (Project portfolio and Information Systems Management) is a tool to plan forecast and manage spending for projects within US Pipelines and Logistics Business Unit.
RR-Travel Tool: The US Pipelines & Logistics Reward & Recognition (R&R) web application provides a centralized, web based GUI front to assist with the USPL R&R nomination process and to record and optionally display previous award recipients. The application makes use of a Microsoft SQL Server database to store the R&R nominations and their associated approval information.
JST: JST is a web based tool which allows the application user to map an employee to an exam which he has to complete and sends the schedule across to prometric centers.
Core platform: ASP, ASP.NET,JavaScript, MS SQL Server 2000, 2005
Client: Thames Water, London, UK
Project: TW-SAP-IS-PROC-INT-1855 Aug’ 09 to Jun’ 10
Project Description:
Implementation of SAP HR module gave an opportunity to re-look at the current Starters, Movers, Leavers and Name Change HR / IT processes and to enhance them to fit into the new SAP framework. People Directory decommissioned and developed the interface between SAP and Directory v2. Online forms made pre populated from Directory v2 database.
Responsibilities:
As a Project Engineer, was responsible for
Participated actively in all the phases of SDLC for the DirectoryV2.
Worked for Business Requirements Specifications and Functional Specifications.
Coded for directory V2 for Advanced search.aspx, Employee Search, Search Results.aspx, Search Results User Control, Quarterly Audit report pages with the backend Stored procedures.
Did Analysis and coding for CR on Quarterly Audit Report for category B and C.
Fixed all UAT bugs raised on DirectoryV2 and handled some of the issues raised on Click IT and online Forms as part of contingency plan. Did Schedulers testing.
Worked on Test scripts scripting and execution for Directory V2, Online Forms and Click IT Applications.
Worked on Reviews, Test review comments during CUT Phase and Testing Phase.
Core platform: C#, ASP.NET 3.0, MS SQL Server 2005.
Client: Thames Water, London, UK
Project: Permits Invoice System TMA-P-4 R-2 Warranty May’ 09 to Jul’ 09
Project Description:
The purpose of the TMA Phase IV Project is to introduce people, process and technology changes to ensure we operate within the policy framework for the last of the four Regulations
Responsibilities:
As a Project Engineer, was responsible
For Development and Maintenance of Registers, Notices, Directions and Designations
Fixed Penalty Notices
Charges for Unreasonably Prolonged Occupation of the Highway
Permits Change details: CR11 Avoidable Flag, Avoidable Amount and Avoidable
Adding of Reason fields to to PIS application.
Amendment of Link Permit Business logic
CR12: Permit Application - Addin Works Description field Permit Schemes with exemptions in them where no permit fee applies.
For the highway authority to identify and exempt the works description that must contain details of the exemption. Equally, anyone processing an invoice needs to be able to identify this special case. To aid the identification of these exempt permits, and to avoid the invoice admin having to spend time opening other systems.
Changes to the permit application to include the works description with the permit details imported from Insight and addin up a new field to display the works description.
Involved in Analysis of the CRs, P5 and P4 ought to do and the CI items impact on the production application.
Involved in documenting the FS of the Change request CR12.
Involved in coding of (CR12) among (CR11, CR12), 6 (P5) independently and 3 (P4) in .net level1.1.
Involved in Data Access Layer design using ADO.NET.
Involved in scripting of Test cases.
Involved in Unit testing, integration testing, System testing of the application.
Involved in Deployment and warranty support. Involved in manual creation of Invoices in FPN and PIS for SAP Testing.
Core platform: ASP, ASP.NET, SQL Server 2005
Client: Thames Water, London, UK
Project: TWUL-PERMITS-PIA-REL-2 Oct’ 08 to Apr’ 09
Project Description:
After the commencement of permit regulation act by the DFT, Thames Water would need to issue permits instead of notices to Highway councils. Highway councils will have a choice to work on either Notice or Permit scheme. Thames Water would issue permits to permit enable Highway council electronically using Work-Management system and Notice-Management systems. A new application, permit application, would be developed to record pay permits invoices. The permit application would be developed by using existing FPN application infrastructure and a new interface with PeopleSoft would be developed to pay permit invoices. The Permit fees would be paid via PeopleSoft. Permits could be recorded automatically and manually. The automatically recorded Permits come from Insight on a daily batch process.
Responsibilities:
As a Project Engineer, was responsible for
Involved in Requirements gathering and Analysis Phase, Design.
Documentation of Functional Specifications (FS) for the HLD and LLD.
Involved in coding of 3 modules namely Admin, Permit and Reports in .Net 3.5.
Involved in Migration FPN Application source code from .Net 1.1 level to .Net level 2.0. Involved in coding of 2 CRs in FPN Application on .net 2.0 and then migrated to .Net 3.5 level.
Involved in Data Access Layer design using ADO.NET.
Involved in Unit testing of the application. Involved in Debugging and Bug fixing of the application.
Involved in Scripting of test cases, Testing (UTC, ST and SIT) and UAT support for the application. Involved in Deployment on April 4th, 2009.
Core platform: ASP.NET 3.5, C#, Java Script, MS SQL Server 2005.
Client: Thames Water, London, UK
Project: Fixed Penalty Notices TMA P-4 R-1 Jul' 08 to Oct' 08
Project Description:
The invoices would be sent from Highway Authority (HA) to Fixed Penalty Noticing (FPN Team) team by Mail or Fax. FPN team would record the invoice details manually onto the FPN application. The FPN team will then check for validity of error reported by HA council manually by logging onto Vistec/JMS/HW1 applications and either agree or rebut. If FPN team approves the Invoice, emails would be triggered to respective Budget Unit (BU) to notify. All approved/authorized Invoices will be transferred to PeopleSoft via FTP for payment to Highway Councils (HC). An acknowledgement of the payment would be received back as a text file from PeopleSoft.
Responsibilities:
As a Project Engineer, was responsible for
Involved in Requirements gathering and Analysis Phase.
Involved in Design, Documentation of Functional Specifications (FS) for the high level as well as low level design.
Involved in coding of two design references (TMA416, TMA418) and involved partly in 417 in .Net 1.1. Design Reference Description: TMA 416: 2 Two new FPN offence types to be added to the FPN Application for permit offences and to be added to all areas of the application including search and reports screens. 1) Works without a permit 2) Breach of permit conditions TMA 417: New cost value for offence of type works without a permit to be added to the FPN Application and mapped accordingly.
Involved in coding of Change requests in Fixed Penalty Notices (Application) on .net 1.1
Involved in Data Access Layer design using ADO.NET.
Involved in Unit testing of the application.
Involved in Debugging and Bug fixing of the application.
Involved in Scripting of test cases, Testing (UTC, ST and SIT) and UAT support for the application.
Core platform: ASP.NET1.1,2.0, 3.5, MS SQL Server 2005
Client: Thames Water, London, UK
Project: TMA P-3 Warranty Jun’ 08 to Jul’ 08
Project Description:
The New Roads and Street works Act has been reinforced by the introduction of the Traffic Management Act. This Act gives Highway Authorities additional powers and reinforces others. Amongst the provisions is the facility to issue Fixed Penalty Notices for failure to serve the prescribed notices within the prescribed periods. These Fixed Penalty Notices will carry a fine of £120 with a discount of £40 if paid within 29 days. So, the proposed system is a payment authorization application where in the invoice processing is automated for validation, authorization and payments.
Responsibilities:
As a Project Engineer, was responsible for
Involved in coding for warranty issues in FPN Application of version .net level1.1.
Involved in Data Access Layer design using ADO.NET.
Involved in Unit testing of the application.
Involved in Debugging and Bug fixing of the application.
Involved in Scripting of test cases, Testing (UTC, ST and SIT) and UAT support for the application.
Involved in Deployment and warranty support.
Core platform: ASP.NET1.1,2.0, 3.5, MS SQL Server 2005
Employer:
Wipro Technologies, May 2008 to till-date.
Education:
Bachelor in Engineering from JNTU Hyderabad, India in 2007.