.Net Sql Server Project Oracle Engineer Data Experience
Resume:
SATYA SRAVANTHI
Ph No: ***- ***-****, *********.*@*****.***
SUMMARY
. Over 6 years of experience in design and development of web and
windows applications using .NET technologies.
. Strong Technical expertise in ASP.NET, VB.NET, C#, ADO.NET, Winforms
and Visual Studio.Net.
. Extensively involved in the Design, Development, and Unit testing of
web based N-tier applications using .NET Framework in various
environments like Process Industry, Logistics and Financial sectors.
. Solid understanding and experience in Object Oriented Programming
(OOP) and methodologies
. Experience in converting the Business and Functional Requirements into
Technical Specifications.
. Strong knowledge in Relational Database Management Systems and
experience in writing SQL scripts, Stored Procedures, User Defined
Functions and Triggers for SQL Server 2000/2005 and Oracle 9i/10g.
. Highly skilled in web building technologies like HTML, DHTML,
JavaScript, CSS, XML, XSL, XSLT, DTD/Schemas and AJAX.
. Experience in developing MS Excel applications using VSTO.
. Good experience with Crystal reports and SQL Reporting Services.
. Excellent debugging skills in resolving the problem logs and bugs
logged by testers and business users.
. Strong and effective problem-solving, analytical and interpersonal
skills, besides being a valuable team player.
EXPERIENCE SUMMARY:
. ABB Pte Ltd, Singapore Mar '06
- May '10
Projects: cpm Plus Smart Client and Cost Center Planning
Technologies: ASP.NET, VB.NET, C#, ADO.NET, Microsoft
Visual Studio.NET 2005/ 2008, XML, SQL Server 2005, Oracle, .NET
Framework 2.0/ 3.5, AJAX Control Toolkit, Infragistics.
. Intellitrans LLC, Philadelphia, PA, USA
May '05 - Nov '05
Projects: Combined Services Offering and Multi Modal Tracking System
Technologies: ASP.NET, C#, ADO.NET, Visual Studio.NET 2003, CSS,
JavaScript, HTML, XML, SQL Server 2000, Visual Source Safe, Crystal
Reports 8.0 .NET Framework.
. Merrill Lynch, Hopewell, NJ, USA
Sep '04 - Apr '05
Projects: Advice Access
Technologies: ASP.NET, C#, ADO.NET, Microsoft Visual Studio.NET 2003,
T- SQL, Web Services, XML, XSL, HTML, SQL Server 2000, .NET Framework
1.1, Visual Source Safe.
. University of Louisiana at Lafayette (ULL), LA, USA
Aug '03 - May'04
Graduate Research Assistant, ULL
Technologies: C#, VB.NET, ASP.NET, JavaScript, XSD, XML, XSL, SQL
Server 2000, Oracle.
EDUCATION:
Masters of Science in Computer Science
Aug '02 - May '04
University of Louisiana at Lafayette (ULL), Louisiana, USA.
Bachelor of Technology in Computer Science
May '98 - May '02
Andhra University (AU), Andhra Pradesh, India.
TECHNICAL SKILLS
. NET Technologies ASP.NET1.1/2.0/3.5, C#, VB.NET, ADO.NET, WinForms
Web Development ASP, XML, HTML, DHTML, AJAX, CSS, XSLT, VB Script,
JavaScript, Perl 5, Cold Fusion, IIS.
Development Tools Visual Studio. Net 2002/2005/2008, Install Shield, UML,
Visio.
Languages C#, VB.NET, T SQL, PL/SQL, C/C++
Databases SQL Server 2000/2005, MS Access, Oracle 9i/10g
Version Control Tools Visual Source Safe, PVCS
Operating Systems MS-DOS, Windows NT 4.0/2000 Server, Professional/ XP, UNIX
PROJECTS
ABB Industry Pte Ltd, Singapore, Singapore
Role: Software Engineer
Project: Cost Center Planning
Description: Cost Center Planning is a tool to help business units (BU)
monitor, forecast and report their costs. This system leverages the
existing electronic infrastructure as it gets automated data feeds from
SAP. The system is developed at the corporate level, but the data is
stored in different database schemas for different BU, so that each BU has
exclusive access to only its data. Security is implemented using Single
Sign on, so that users can only work with their unit's data.
Responsibilities:
. Extensively involved in gathering user requirements and created design
documents for the database and the web application.
. Created Ajax Enabled Website to have partial page post back of web
pages.
. Infragistics controls for web were used for displaying and editing
hierarchical data.
. Used Master Pages and CSS for consistent look and feel
. Designed SQL Server 2005 database such that data for each unit was
stored in its individual Schema for ease of use, maintenance and to
facilitate each unit's custom reports that are to be generated from
the database.
. Created all database objects (Stored Procedures, Triggers, Functions
and Schemas) for storing, querying and manipulating data from SQL
Server 2005 database.
. Different database users were dynamically impersonated from the web
application based on the access of the logged in user.
. Wrote database scripts that are executed every month for loading data
from staging databases to the application's database.
. Worked with SAP developers to load data from institutional
repositories to the staging SQL databases.
. Worked with QA team to write the Test Cases, Test documents.
Environment: ASP.NET, C#, ADO.NET, Visual Studio.NET 2008, T- SQL, XML,
SQL Server 2005, .NET Framework 3.5, AJAX Control Toolkit, Infragistics.
ABB Industry Pte Ltd, Singapore, Singapore
Role: Software Engineer
Project: cpm Plus Smart Client
Description: The cpm Plus Smart Client is the ABB Process Information
Management System for different industries like pulp and paper, Power and
Oil and Gas. cpm Plus Smart Client is an application that lets you create,
monitor and manage dynamic runtime controls that represent the industrial
plants. In this application, you can graphically represent a physical
entity (valves, motor, gauge etc) and monitor their functioning.
Responsibilities:
. Responsible for developing and maintaining the click-once Smart client
application in C#/ VB.NET/ Visual Studio.Net 2005.
. Understand the functional specs and develop the user controls using C#,
Visual Studio.Net 2005.
. Profile the smart client application and find the performance hindrance
areas.
. Write Test Specifications for the User Controls developed.
. Developed the client application using Windows forms technology.
. Used Visual Source Safe for version controlling.
. Responsible for the framework of cpm Plus Smart Client application
which is the base for the communication of the data providers, various
user controls. Used Reflection to load controls dynamically.
. Responsible for developing the Production Report user control which is
used to configure various kinds of Unit, daily, weekly, monthly reports
in C#.
. Developed cpm Plus Excel interface using VSTO. Users can drag and drop
properties from 800xA browser and create real time reports.
. Used InstallShield to create the cpm Plus Smart Client installer.
. Communicate with the testing team and solve the bug cases for most of
the modules in the application.
. Created XML data schemas for various xml files the application uses.
. Used Document X tool to maintain documentation for the controls
Environment/Tools: Visual Studio.NET 2005, VB.NET, C#, Oracle 10g, XML,
XPath, Windows Forms, C++.
Intellitrans, Ardmore, PA, USA
Role: Programmer Analyst
Project: Combined Services Offering
Description: The Combined Service Offering, or CSO, offers a comprehensive
suite of products and services aimed at driving efficiencies throughout the
logistics functions of a bulk commodity shipper. The CSO integrates the
products and services from Trinity and Intellitrans - the asset management
solutions from Trinity, and the in-transit inventory solutions from
Intellitrans. CSO 1.0 combines the features of MMTS and MyRailcar and is
aimed at customers who require complete in-transit visibility of their rail
shipments along with access to mechanical data and the shop status of their
equipment.
Responsibilities:
. Responsible for the Admin module, which allows the Administrator to
assign the visibility of modules and menus to a particular user through
roles. I was responsible for designing and developing the UI, designing
the data model required for this purpose.
. Responsible for BOL Generator module, which allows users to search,
generate new Bill of Lading.
. Created the user interface of Reports module, the business logic to
queue the reports and present them to the user in PDF or excel formats.
Used Crystal Reports to create the reports.
. Created ASP.NET pages with in-built user validation where required.
. Extensively used VB.NET Collection classes.
. Extensively used ADO.NET objects for data retrieval and database
updates.
. All the modules created are User controls, with attributes, which can
be made available by the administrator.
. Involved in converting the existing ASP/VB modules into ASP.NET/VB.NET.
. Extensively created stored procedures, functions in T-SQL.
. Responsible for creating the Cascading Style Sheet for the CSO1.0
Project.
. Used Visual Source Safe for version controlling and code baseline.
Environment/Tools: Visual Studio.NET, VB.NET, Crystal Reports, ASP.NET,
ADO.NET, JavaScript, HTML, XML, XSL, XSLT, and SQL SERVER 2000.
Intellitrans, Ardmore, PA, USA
Role: Programmer Analyst
Project: Multi Modal Tracking System
Description: MMTS will assist users to track shipments within North America
and also give them an opportunity to manage their fleet and analyze
performance on various lanes through reports.
Responsibilities:
. Responsible for the design and development of the whole Detention
module, which enables the users to view Current, Marketing, Historical,
Detention reports and also perform End-Of-Month (Billing the current
report) functionality. Users can also send the Detention report feed to
the Client using this module.
. Responsible for the Fleet module, which allows users to manage the
Fleet (like adding new fleet, search and view reports of the fleet).
. Extensively used ASP.NET validators and JavaScript functions to perform
client side validation. Used Datagrid extensively.
. Extensively used SQL Helper Classes to interact with the database.
. Extensively used ADO.NET objects for data retrieval and database
updates.
. I was responsible to design the Data Definitions (DTD) for the Inbound
and Outbound Interface feeds.
. Designed and implemented components, which dynamically display the
search, results according to the customer specifications. This is
accomplished using XSLT, XSL and XML.
. Created DTS package to transfer data to & fro from SQL Server to
different formats like txt, xls.
. Responsible for the back end functionality of the Inbound and Outbound
Feeds between Intellitrans and the Customers. In this process, created
many stored procedures, functions and Views to interface the feeds.
. Used Crystal Reports to create various Rail fleet shipment reports.
. Responsible for writing the user test cases for the modules I
developed.
Environment/Tools: Visual Studio.NET, VB.NET, Crystal Reports, ASP.NET,
ADO.NET, JavaScript, COM, HTML, DHTML, XML, XSL, XSLT, and SQL SERVER 2000.
Merrill Lynch, Hopewell, NJ, USA
Role: Developer
Project: Advice Access
Description: Merrill Lynch Advice Access is a multi-channel investment
advisory program that provides participants with investment recommendations
and asset allocations based on information provided by the plan sponsor and
participants, including their demographic background, financial status, and
investment goals.
Based on the current annual income, age and retirement income goal of the
participant, Ibbotson, a recommendation tool used by Advice Access
calculates and displays the current and the target retirement savings rate
and savings plan for the participant. Record keeping is maintained using
Mainframes. Advice Access database is maintained using Oracle database.
Advice Access uses web service interface to access Ibbotson and to access
mainframe records.
Responsibilities:
. Created ASP.NET pages with web server controls for the presentation
layer.
. Implemented validation using validation controls and JavaScript client
side validations.
. Data Formatting was done using HTML, CSS and client side scripting
using Java Script.
. Involved in the development of business logic in C#. NET.
. Created web custom controls and web user controls where necessary.
. Database transactions were achieved through Datasets, Data Reader and
SQLData Adapter.
. Created and consumed XML Web Services, which were used to interact with
the 3rd party tool, Ibbotson and also the Benefits Online Application.
. Created XSLT style sheets and parsed the XML documents to populate the
data on the front-end and extensively using .net parsers.
. Configured Global.asax and web.config for setting the Application and
Session variables.
. Responsible for sanity checking of our application and production
support.
. Involved in writing SQL commands, SQL procedures to interact with the
Oracle 9i database.
. Involved in the Prometheus Project, which is devised to redesign the
entire site.
. Involved in the integration of Advice Access with other Applications
under the Retirement Group.
. Responsible for resolving the problem logs and bugs in the application.
. Involved in writing test cases for the whole application for unit
testing.
. Used PVCS for version controlling.
Environment/Tools: C#. NET, ASP.NET, ADO.NET, MS Visual Studio. NET, Web
Services, XML, XSLT, UML, JavaScript, Oracle 9i.
University of Louisiana at Lafayette, LA, USA
Project: Implementation of RBAC using XML for Web based Applications
Implemented Role Based Access Control, wherein access decisions for the
particular information are based on the roles than an individual have on
the part of the organization. Users take on assigned roles (such as Doctor,
Nurse, Teller, manager) and the operations that a user is permitted to
perform are based on the user's role. In this project, I developed an XML
Schema for representing the schema of the RBAC model and a conforming XML
document containing the actual RBAC based access control data for an online
organ procurement and donation system. Based on the XSD (XML Schema
Definition) file and the XML file, methods for parsing an XML file in .Net
are used for implementation of the RBAC model.
Environment/Tools: ASP.NET, C#, XSD, XML.
University of Louisiana at Lafayette, LA, USA
Project: Virtual Mall.
This is an e-commerce website, where different merchants can register and
sell their products. When the users place orders, the respective merchants
are notified and credit card transactions between the merchant, credit card
banks and customers are carried out in a secured manner. This application
uses server side programming (JSP, ASP.NET) extensively and Oracle for
database, Triggers and stored procedures for manipulating (inserting,
deleting, updating the data) the database. JavaScript is used for client
side validations.
Environment /Tools: JSP, JavaScript, C#, ASP.NET, Oracle.
Naval Science Technological Laboratories
Project: Automation of Technical Information Systems
The Technical Information Systems division manually did the process of
placing orders, which was tedious and not prompt. The automation consists
of implementation of message boards, search facility and administrative
pages to place orders, monthly magazine issues and manage message board.
Responsibilities:
. Gathered the functional requirements from the users and designed the
system.
. Designed and created the database tables and the SQL Scripts.
. Entire design and development of front-end interface with the
implementation of the Message boards and the search facility for the
monthly magazine issues and the orders using JSP and JavaScript.
Environment/Tools: JavaScript, JSP, MS Access, Windows 2000.
REFERENCES: Available upon Request.
Contact this candidate