Professional Profile
Over 8 years of experience in analysis, design and development of applications
using Visual Basic, VB.NET, ASP. Net, MS SQL Server, Oracle, Access and Microsoft
Office
Experienced in managing IT applications in the domain of Healthcare,
Automotive and Financial application systems.
Full system life cycle experience: design, coding, testing, bug fixing,
deployment, documentation and maintenance.
Experienced in developing customized Client Server/ Web applications.
Experienced in relational data modeling and database design.
Experienced in Windows GUI design, back-end SQL programming and development of
Reports
Expertise in writing and testing Queries, Views and Stored Procedures in
Oracle and SQL Server.
Over 2 1/2 Years of experience in coordination with offshore teams in Europe
and Mexico
Good understanding of Relational Database and Object Oriented concepts.
Ability to handle multiple projects simultaneously with a limited timeframe.
Technical Skills
OPERATING SYSTEMS
Windows 9x/NT/Me/2000/XP and Vista, Unix, MS DOS
DATABASES MS-Access 97/2000/2002, Oracle 7.X, 8X, 9i, 10g
MS SQL-Server 7.0/2000/2005, TeraData, DB2
DEVELOPMENT TOOLS / LANGUAGES VB.NET, VISUAL STUDIO 2003/2005, ADO.NET ASP.NET,
Visual Basic 5.0/6.0, PL/SQL, C, C++, Java, J2EE, VB Script, Java Script,
HTML/DHTML, XML, UNIX Shell Scripts, Crystal Reports, Rational Test Manager,
Rational Robot, Rational Rose, Erwin, Toad, Developer 2000, Visio
VERSION CONTROL TOOLS PVCS and MS Visual Source Safe
Global Securitization System February/2006-November/2008
Ford Motor Credit, Dearborn, MI Programmer/Analyst
Environments: Windows NT/XP, SQL Server/VB 6.0/VB.NET /Crystal Reports/MS
Access/TeraData
TF/IRA - Transaction Forecasting (TF) and Investor Reporting and Accounting
(IRA) are application modules within the Global Securitization (GS) System that
summarize data from the Collateral Servicing (CS) module to produce monthly
funding transaction reports published to investors. IRA also sends accounting
entries to the People Soft general ledger and sends cash wire entries to the
Global Cash Management system. The Transaction Forecasting module provides
Treasury Funding with functionality to analyze and forecast performance aspects
of existing funding transactions.
Responsibilities:
Analyzed the requirements and prepared the design documents basing on
the Analysis.
Responsible for Application design, coding, testing and implementation
of the system.
Coordinated the conversion of the TFIRA application from VB 6.0 to
VB.NET. Developed code as required.
Prepared DATABASE requests for New Tables. Wrote Stored Procedures in
SQL Server. Prepared AdhocSQL 's. Involved in the development of the data model.
Used ADO.NET to interact with SQL Server Database Operations.
Designed, developed and tested New Development Projects (Germany ESS
and Mexico)
Coordinated the DATA Propagations.
Involved in Test plan and Test case Preparation and documentation.
Coordinated the QA and PROD Builds.
Involved in maintaining the source code in PVCS.
Involved in Unit Testing and Integration Testing.
Helped the users while testing through Net meetings and Phone calls.
Resolved Production issues.
World Class Improvement Project August/2003- April/2005
British Petroleum, Oregon, OH Programmer/Analyst
Environment: Windows XP, SQL Server 2000/VB.Net/ASP.Ne and Crystal Reports
Contractors Timekeeping System (CTS): is an add-on sub system to the complete
integrated Module of the HP business system that supports the need of various
refinery groups. The main functionalities of the CTS are as follows:
Record contractor labor against work orders
Send the entered information for electronic approvals
Run the batch job that changes the labor to the work orders
Creates the general ledger entry for the changes
Optionally creates an invoice for the vendors
Export data to the Maximo work order system [summary record by contractor by
date by work order by type (labor, equipment or material)]
Responsibilities:
Responsible for Application design, coding, testing and implementation
of the system
Developed stored procedures and functions in SQL Server
Design, develop and maintained web applications using VS .Net 2003
Used JavaScript for performing client side validations.
Used ADO.NET to interact with SQL Server Database Operations.
Developed various ASP.NET user controls, Custom Controls for the
ASP.NET forms
Involved in testing activities - creating test cases, Unit Testing,
System Test
Involved in maintaining the source code in PVCS
Worked with packaging, scripting and deployment team.
Created reports using Crystal Reports.
Troubleshoot and manage resolution of user issues
Prescription Handler for Hospital Feb/2000 May/2003
Corporate Data Systems (Visakhapatnam) Programmer/Analyst
Environment: Windows 98/Oracle8.i/ Visual Basic6.0/ MS Access reports
This application was developed to help doctors and other hospital staffs at
Seven Hills Hospital maintain their patient prescriptions. The application holds
information about a wide range of medicines along with their composition; helps
select medicines according to chemical combinations and provisions. The menus,
tool bars and screen layout are designed based on application security levels
(Physician level access, Nurse level access, Clerk level access)
Responsibilities:
Coordination with Medical staff to determine business requirements for
requests
Responsible for System Analysis, Design, Coding, Development Testing
and Implementation of the application
Documented each program/screen to create the user manual
Developed VB forms for Patient prescription entry, edit, maintenance &
dynamic input box flow
Automated prescription reports by using MS Access reports.
Module-II (Hospital Administration)
Environment: Windows 98/Oracle 8.i/Visual Basic 6.0/Crystal Report
Module II of the system handles patient registration, outpatient and in-patient
detail, billing, and length of stay, laboratory, ward management, Appointment
Scheduling and Medical records. It also has a capability of generating various
daily, weekly and monthly reports.
Responsibilities:
Analyzed, Designed, Developed and Maintained the Hospital
Administration Module of the system
Involved in the creation of stored procedures and functions, triggers
and views using Oracles PL/SQL
Played a lead role in Integration testing, User acceptance testing and
Quality assurance
Helped to create User manuals and in training of users
Maintained and enhanced the system and provided support for bug fixing
and customizations
Troubleshoot and manage resolution of user issues.
Loaded vendor packages into local database tables using Oracles SQL
Loader utilities
Finance Accounting System
Corporate Data Systems (Visakhapatnam)
Environment: Windows NT/MS Access/Visual Basic 6.0 /Crystal Reports
This system was developed for a Finance Company using MS Access and Visual Basic
6.0. The application facilitated dynamic queries to generate up to-date financial
status, which is used by the management to take financial decisions.
Responsibilities included development of the Account Type transactions module,
Deposit/Recurring deposit module, Loans/Intermediate Loan and Reports.
Responsibilities:
Responsible for system design, coding, testing and implementation of
the modules
Designed and normalized the application database
Maintained and enhanced the system and provided support for bug fixing
and customization
Customer support, software upgrades, database maintenance, performance
monitoring, performance tuning, and interface support
Developed the data maintenance modules for the system
Developed daily, weekly and monthly reports using Crystal Reports
Education:
Bachelor of Science
Andhra University, Rajahmundry, India
Postgraduate Diploma in Computer Applications
Para Digm, India
Honors Diploma in Internet Applications
SSI Ltd, India
Visa Status : US Citizen |
