SUMMARY

• Over Four years of strong experience in design, development, testing and deploying of various business applications using Oracle10g/9i, PL/SQL, SQL, SQL*Loader, VB, VB.NET, ASP.NET, Teradata, Business Objects
• Expertise in Oracle 10g/9i/8i/8.0, PL/SQL, SQL, SQL Loader
• Expertise in Maintaining, Debugging, Database and Technical Support to deployed applications.
• Expertise in design and developing ETL process
• Set up Shell script Jobs in UNIX environment for FTP and loading daily/monthly files
• Excellent programming and analytical skills
• Experience in developing and publishing reports using Business Objects (Web Intelligence)
• Highly motivated and adaptive with the ability to grasp things quickly and possess excellent interpersonal technical and communication skills.
• Working knowledge of Version Control tools like PVCS and Visual SourceSafe
• Experienced in interacting with the client during design, development and product implementation phases.
• Commitment to achieving corporate goals, able to establish priorities and adapt quickly to changing needs
• Very rapid learner, voracious reader, good listener, effective writer and speaker, extremely organized and disciplined, good people skills.
• Teradata Certified SQL Specialist

TECHNICAL SKILLS

Development Tools/Languages: VB, VB.NET, ASP.NET
RDBMS : Oracle 10g/9i, Teradata
Database Connectivity : ActiveX data Objects (ADO), ADO.NET
Report Tools : Oracle Reports
Languages : SQL, PL/SQL, Visual Basic
Markup Languages : HTML, XML
Scripting Languages : Unix Shell Script, Java Script, VB Script
IDE : Visual Studio.Net, Visual Studio 2005
Operating Systems : Unix,Windows Family
Web Servers : IIS
Source control Tools : PVCS

EDUCATION

• MS Computer Applications,

PROFESSIONAL EXPERIENCE

Confidential,Richmond, VA
July’2008 –September’ 2009(Developer)

The overall objective of the project was to provide Fifth Third and First Tennessee banks with a data warehouse that will assist banks in developing a totally data driven approach to risk, marketing and customer relationship management.

Fifth Third and First Tennessee send daily and monthly Consumer and Business credit transactions, daily maintenance, Authorizations, credit bureau information to SSS. Several ETL processes were designed and developed to download the files from FTP server and load them into SSS data warehouse system.
.
Key Contributions:

• Involved in various client meetings for analyzing/gathering User Requirements.
• Involved in creating Source-Target mapping document
• Designed and developed several ETL processes for Credit bureau, Daily Balance, Transaction history, Collateral, Loan Applications etc.
• Created Staging tables, Fact tables, views, synonyms, SQL Loader control files
• Developed ETL processes using PL/SQL
• Developed Unix shell scripts and scheduled through cron
• Developed packages, functions procedures, triggers using PL/SQL
• Involved in testing, implementation and troubleshooting and loading daily/monthly files
• Developed and published exception reports from daily/monthly batch loads using Business object (Web Intelligence)

Environment: Oracle 10g/9i, PL/SQL, SQL Loader, SQL, UNIX, Shell Script, SQL Developer, TOAD, Business objects

Confidential,Ann Arbor, MI
Apr’2005 -Oct\'2007 (Developer)

Title List System
This system allows users to generate title lists along with coverage information for ProQuest Information and Learning products based on the search criteria. Also system generates open URL, which directly links to ProQuest Publications where user can select/view list of issues and articles. User can download in various formats such as HTML, EXCEL, TEXT, MARC and PQ defined etc
.
Key Contributions:

• Involved in analysis, design and development of the application functionalities using Oracle 9i, PL/SQL, SQL
• Created tables, views, materialized views
• Involved in various client meetings for analyzing/gathering User Requirements.
• Developed packages, functions procedures, triggers using PL/SQL
• Involved in testing, implementation and troubleshooting

Environment: Oracle 9i, PL/SQL, Linux, TOAD

Library Holding Upload System
This system uploads librarian\'s holding information which includes title, Issn#, Custom defined URLs to PQ database and later on Librarian can search their holding via PQ Local Administrator interface and update PQ defined, E-journal and custom defined links to their titles.

Key Contributions:

• Involved in various client meetings for analyzing/gathering User Requirements.
• Developed packages, procedures, functions and triggers using Oracle 9i, PL/SQL
• Involved in testing, implementation and troubleshooting
• Involved in performance tuning

Environment: Oracle 9i, PL/SQL, Linux, TOAD

ProQuest MARC Record Delivery System
This is an automatic process, which downloads MARC (Machine Readable Cataloging, A standard format for storing bibliographic information in electronic format) records from Library of Congress in a periodic basis and feeds PQ Database after applying some business rules. Finally, this system generates the PQ MARC Records along with ProQuest links to its publications and delivers to the customers based on the customers preference.

Key Contributions:

• Involved in various client meetings for analyzing/gathering User Requirements.
• Writing packages, procedure, functions and triggers for whole application using PL/SQL
• Created web interface forms and display outputs using VB.Net/ASP.Net
• Designed and developed windows controls for Data binding to client applications via DataSet.
• Used DataGrid, DataSet and DataReader to retrieve, display and manipulate data.
• Used Data Views for filtering the data.
• Used grid view to retrieve data from dataset and bind it to the control and display.
• Involved in testing, implementation and troubleshooting
• Involved in performance tuning
• Was solely responsible for the creation of the web site including: concept; organization; esthetics, usability and functionality

Environment: Oracle 8i, PL/SQL, VB.NET, ASP.NET,VB, Windows 2000

Confidential, New Delhi. Feb’2003-March’2004

Bank Reconciliation System
This system calculates interest, commission from FDR system, prepares receipts and then enters into financial accounting book. Lastly matches the bank transactions as per bank advice versus financial accounting books for the month.

Key Contributions:

• Designed and developed application using VB 5.0, Oracle 8i
• Wrote Database Procedures, Functions, Triggers using PL/SQL
• Involved in testing, implementation and production support

Environment: Oracle 8i, PL/SQL, VB 5.0, Windows NT