Post Job Free

Resume

Sign in

Pl Sql .Net Developer

Location:
San Jose, CA
Posted:
March 11, 2024

Contact this candidate

Resume:

Professional Summary

Overall, ** years of experience in IT industry with good experience in dealing with business to gather/understand the requirements and provide effective solutions. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery.

Certified in Oracle-OCA and Microsoft -MCTS.

Experience as a .NET developer in developing Windows based and web-based applications using .NET technologies such as C#, VB.NET, ASP.NET, ADO.NET, win forms, Server controls, web services, .NET Framework, HTML/XHTML, DHTML, CSS and IIS.

Efficiently used Data Readers and Datasets in ADO.NET to retrieve, display edit and update the database.

Worked extensively in Oracle PL/SQL. Expertise in Client-Server application development using Oracle 10g/9i PL/SQL and TOAD.

Experience in database in creating complex Stored Procedure, Views, Packages using PL/SQL, T-SQL in SQL Server 2008, and Oracle.

Experience with Unit testing, Integration Testing and Functional Testing.

Excellent Communication skills, team player, quick learner, organized, and has ability to quickly master new concepts and capable of working in-group as well as independently. Good experience in dealing with business to gather/understand the requirements and provide effective solutions.

Experience Details

Organization

Designation

Duration

TechMahindra

Senior Software Engineer

June 2007—July 2015

Skills

Front End

Microsoft Technologies - .NET 3.5, C#, ASP.NET, ADO.NET, JavaScript

Back End

Oracle 10g, 9i, SQL\PLSQL and SQL Server 2005, 2008

Certifications

(70-528) TS: Microsoft .NET Framework 2.0 - Web-based Client Development

(70-536) TS: Microsoft .NET Framework 2.0 - Application Development Foundation

(1Z0-007) Introduction to Oracle9i:SQL

(1Z0-147) Oracle9i: Program with PL/SQL

Work Experience

Project Profile 1:

Project Name

RSCM: (Remarketing Supply Chain Management)

Client

Cisco Systems Inc.

Duration

November 2013—July 2015

Environment (with skill versions)

Languages:

C#, JavaScript, PL/SQL

Software:

Microsoft .Net 3.5

Database:

Oracle

Tools:

Toad 9.0

O/s:

Windows

Project Description:

Remarketing manufacturing operations application providing visibility of remarketing product inventory, build plan functionality, workflow functionality for product requests, Master file repository and report/KPI/dashboard generation.

Contribution:

Providing New Reports to the Business for Inventory Management and Backlog Forecasting.

Customizing and Enhancing the Existing Reports.

Improving data integration.

Establishing a single version of truth

To provide accurate data for an improved decision support system.

Documentation on Requirement and Functional Specifications.

User Training and Support

Project Profile 2:

Project Name

Conditional Accessibility (CA) Auto Test

Client

Cisco Systems Inc.

Duration

January 2013—October 2013

Environment (with skill versions)

Languages:

C#, JavaScript

Software:

Microsoft .Net 3.5

Database:

Oracle

Tools:

Toad 9.0

O/s:

Windows

Project Description:

Conditional Accessibility (CA) Auto Test is a robust Web based application built on MS.NET platform with Oracle as Backend. Basically, this application is downstream for SAP users, which deals with the Inventory items. This application enables SAP users to

automate the process.

Contribution:

Was responsible for gathering the Business Requirements

from the Client over Tel-Conferences and involved in Analysis,

Design, and Development & Implementation of Client Requirements.

Developed GUI using ASP.Net Web Forms.

Designing and developing databases in Oracle.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Developed Packages, Procedures and Functions in Oracle database.

Worked with ADO.NET and Oracle Client for accessing the Oracle database.

Documentation on Requirement and Functional Specifications.

User Training and Support.

Project Profile 3:

Project Name

Project Metrics Automation

Client

Cisco Systems Inc.

Duration

January 2012—December 2012

Environment (with skill versions)

Languages:

C#, JavaScript

Software:

Microsoft .Net 3.5

Database:

Oracle 10g

Tools:

Toad 9.0

O/s:

Windows

Project Description:

Project Metrics Automation Tool is a web application which captures metric information for each project under Finance Group. This tool helps the managers to enter information about each project and its status. It also enables the managers to update and track the Project details at all stages. Admin Module helps the administrators to perform admin activities i.e., Adding and Deleting Users, changing their Role, Assigning and Deleting Projects and Modifying the Project Names and Categories.

Contribution:

As an Individual Contributor was responsible for gathering the Business

Requirements from Client and was involved in Analysis,

Design, Development & Implementation of Client Requirements.

Developed GUI using ASP.Net Web Forms.

Designing and developing databases in Oracle.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Developed Packages, Procedures and Functions in Oracle database.

Worked with ADO.NET and Oracle Client for accessing the Oracle database.

Documentation on Requirement and Functional Specifications.

Database Objects Migration.

Deployment of code in dev and prod server.

User Training and Support.

Project Profile #4:

Project Name

Cisco_CSCORE Dashboard Metrics Automation

Client

Cisco Systems Inc.

Duration

November 2010—December 2011

Environment (with skill versions)

Languages:

C#, JavaScript

Software:

Microsoft .Net 3.5

Database:

Oracle 10g

Tools:

Toad 9.0

O/s:

Windows

Project Description:

Cisco Systems Inc.is the worldwide leader in networking for the Internet. We are building a Web Application for GCCO which atomizes the application metric data from manual/csv. Our task is to reduce data inconsistency and enhance security. Lot of validations are done through wed application so the data which reaches the reports is factual, correct, and valid for Decision Support System. Only metric owners can manipulate the data. Listed below are the responsibilities.

Contribution:

As an Individual Contributor was responsible for gathering the Business

Requirements from Client and was involved in Analysis,

Design, Development & Implementation of Client Requirements.

Developed GUI using ASP.Net Web Forms.

Designing and developing databases in Oracle.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Developed Packages, Procedures and Functions in Oracle database.

Worked with ADO.NET and Oracle Client for accessing the Oracle database.

Documentation on Requirement and Functional Specifications.

Database Objects Migration.

Deployment of code in dev and prod server.

User Training and Support.

Project Profile 5:

Project Name

Product Activation Support

Client

Microsoft Corporation

Duration

January 2010—September 2010

Environment (with skill versions)

Languages:

C#, JavaScript

Software:

Microsoft .Net 2.0

Database:

Microsoft SQL Server 2005

Project Description:

Product Activation Support is organized along a multi-tier service model that has been designed to enhance customer relationships, assist with resolving problems promptly and to ensure that the proper resources are engaged as quickly as possible. The model defines clear expectations and timeframes for issues that require action from associated support teams, including increasing technical complexity, multiple areas of infrastructure ownership. It is important to note that this tiered structure is a model and may not be implemented purely across all applications.

Contribution:

As a team member was responsible for First point of contact for end-users of an application for functional and technical questions and issues.

Send out notifications prior to scheduled maintenance or at the first instance possible for unscheduled downtime. Resolve functional issues and provide Application specific information.

Maintain high availability of the PA Backend Applications and Services as well as day-to-day running and maintenance. Log and track all application related issues that are placed through Program Support.

Escalation of requests/issues as appropriate Facilitate communications between all support tiers and relevant parties on Program issues.

Monitor and report performance of the application components in the production environment.

Ad Hoc reporting requests Product Key related issues/requests.

Project Profile 6:

Project Name

BP Supply Support

Client

British Petroleum (BP)

Duration

September 2007—November 2009

Environment (with skill versions)

Languages:

C#, JavaScript

Software:

Microsoft .Net 2.0

Database:

Microsoft SQL Server 2005

Tools:

Microsoft Visual Studio Web Developer 2005.

O/s:

Windows XP

Project Description:

The downstream of oil marketing company is all about the supply chain management of the finished products. Out of business requirement oil companies, amongst themselves exchange the product and use each other’s infrastructure. This Project is suit of 21 applications which is caters to the BP supply applications, which involves varieties of technology from .net 2.0, SQL server, BO, Cobol, Mainframes and Sybase, as a Team member playing an active role in supporting Supply Crude Oil Reconciliation Engine (Score) and OA IST EDMS (Oil Americas IST Electronic Document Management System).

Contribution:

As a team member was responsible for providing support for the two applications.

Onsite - Offshore coordination for gathering the requirements.

Analysis of the specifications provided by the client.

Monitoring LOA activities.

Coding using ASP.net and C#.Net.

Documentation for Enhancements.

Testing and Implementation.

Education

Degree

Specialization

University

Year of passing

Post-Graduation

MCA Computers

Osmania University

2007

Degree

Specialization

University

Year of passing

Graduation

B.C.A Computer Applications

Osmania University

2003

Passport & Visa Details

Personal Details

Name

Sravanthi Palla

Email ID

ad3899@r.postjobfree.com

Contact Number – Mobile

408-***-****

Location

San Jose, California



Contact this candidate