Objective
Visual Basic/ Excel VBA Develope


Summary

7 years of experience in Design, Analysis and Development of Software applications in client, server environment using Visual Basic .NET, C#, Crystal Reports, ASP, Oracle, XML, Unix and Excel VBA
Strong Background in Pharmacy, Manufacturing and Finance Industry with Fixed Income Derivatives

Extensive experience in Manual, Automated and Load testing of integrated applications.

Good Experience in Excel Add Ins technology
Strong Expertise in Writing Complex Excel Macros with Excel VBA with Different Business Environments. Analyzing complex Business Requirements and developing technical applications in both Client Server and Object Oriented Environments.
Strong Expertise in writing Complicated PL/SQL procedures and triggers in Oracle for Financial Applications

COMPUTER SKILLS
Languages C, SQL, Java, Unix Shell Scripting, PL/SQL, ERWIN 3.5.2
Web Design Tools HTML, DHTML, ASP, VB Script, JavaScript, XML, XSLT
Operating Systems UNIX, HP_UX, WINDOWS 2000 or NT
RDBMS ORACLE 7.3/8.0 MS SQL Server 7.0 MS-Access2000 SYBASE 11.0 DB2, TOAD
GUI Visual Basic 6.0 or .NET, Developer 2000, VBA with Excel MACROS and Access, MS-Word Macros, Excel XLA or C# .NET
Reporting Tools Crystal Reports 9.0/10.0 Reports 9 Crystal Info, Transformation Tools SQL* Loader, Microsoft Data Transformation Services, Microsoft OLAP Services, ERWIN 3.5

PROFESSIONAL EXPERIENCE :
Senior. Oracle, Visual Basic Programmer in Fannie Mae, VA Jun05 Till Date
Lender Configuration/ Fixed Income and Platform Administrator

Fannie Mae is 1 of the leading Home Loan and Mortgage lending Companies in USA
With more than a billion dollars of annual turnover, Fannie Mae is 1 of the most prestigious secondary market investors, having liaison with Chevy Chase bank, Nationwide, 53rd Bank, Flagstar etc.

ProSpan is a Platform Administrator Application which is both web enabled and client server based system
This application is for Lender certification of companies like Chevy Chase, Fremont Bank, Nationwide etc. This application enables the applicants to apply for a home loan online. Also California center agents, loan officers, mortgage agents etc are included in the system. Fixed Income Calculations were automated

Generated front end GUI for entering Lender details using Visual Basic .NET and Excel XP GUI
Created COM components and ActiveX controls in Visual Basic .NET for Complex mortgage calculations and Fixed Income Derivatives
Created ActiveX DLLS in Visual Basic .NET or Excel Macros for loading data from multiple sources on to the web.
Created weekly ad hoc Loan reports and Pivot tables using Excel Macros and VBA
Loaded excel reports on to web using Excel XLA and Excel Add Ins with ASP, VB.NET
Converted Mortgage Crystal graphical reports into Excel Pivot tables and Excel bar graphs
Converted Flat file data from multiple sources to XML data using XSLT and Excel macros
Loaded Lender configuration data into remote FTP agents and email sources using Excel macros for Fixed Income Derivatives
Loaded Crystal reports of Lenders into web using Crystal Enterprise and Crystal Info
Created Database triggers in Oracle for preventing any loss of financial data
Created Functions and Packages in Oracle to import large Financial data from Excel
Created Unix Shell scripts to load flat file data into Oracle using SQL Loader

Created Database Procedures in Oracle to calculate date wise mortgage interest calculations
Generated Unix Shell Scripts to identify any bad creditors and Yearly loss
Created MS Access Front end to load local data into XML using MS Access macros
Generated Macros in Excel VBA to email Fixed Income data to lenders

Environment : Visual Basic 6.0/. NET, C#. NET, Oracle 9i, VBA with MS-Excel 2000 and XP, VBA with MS-Access 2000 Crystal reports 9 Unix HP_UX Shell Scripting, ASP, XML, Java Script

Senior Excel VBA, Macros Developer in Metropolitan Transportation Authority, CA Aug 04 May05
Logistics Scheduling and Routing Systems

This application deals with the advanced Scheduling and Routing of the Logistics application of Metropolitan Transportation Authority, Los Angeles, California. MTA is responsible for the public transportation for the city of Los Angeles and is governed by California Department of Transportation. MTA spends over a billion dollar for the benefit for the public transportation of the city of Los Angeles
This application involves creation of front end for the routing validations of Logistics application. Multiple reports were built in Excel/ Crystal reports to report the weekly scheduling operations of all the buses in Los Angeles. Oracle packages were created to maintain backend routing transactions Unique Routing Ids were given to each trip and accessed through web with Excel VBA/ Crystal Enterprise.
Automated Weekly Costing reports using Excel Macros and API calls
Converted a lot of corporate reports into Excel graphical charts and reports with Excel VBA
Used Active x controls in VB.NET, Excel XP for automation of excel reports.
Created COM components and User Controls in VB.NET, to link remote Excel data to Oracle database and Unix flat files
Linked Oracle Data to Excel sheets and shown as linked reports using Excel VBA for Fixed income calculations
Worked on Pivot tables for the summarized reports of Excel data
Linked the Excel and Access Reports to the web for the global access of the data.
Generated bar graphs and Pie diagrams in Excel sheets for providing weekly

Shipping status to management. This was done though excel macros
Generated Automatic graphical shipping reports using Excel Graphics and VBA, C#
Linked Excel reports to web using Excel VBA and Excel Add Ins and Unix Shell
Generated Master detail reports using Crystal reports from Excel for transport data
Automated various statistical, graphical and mathematical functions through MS-excel
Used ActiveX Controls for the linking of Excel and Access reports to Visual Basic
Generated Unix shell scripts to FTP data to UNIX
Generated Graphical Bar charts in Excel reports with Excel VBA and Add Ins
Created Database triggers in Oracle to enhance security requirements
Loaded data into Oracle using SQL Loader and Unix and Excel Macros and Excel xla
Generated Procedures in Oracle to calculate complex financial functions
Automated various statistical, graphical and mathematical functions through MS-excel
Generated Unix shell scripts to automate date wise transactions



Employment

2004 -  2004
SQL Developer

Capital 1 Auto Finance is the nations largest online vehicle lender providers in USA It is head quartered in San Diego, CA and Plano TX. Capital 1 is recognized nation wide and it has Strategic Partners like AAA, American Express, Edmunds.COM, Kelley Blue Book, LendingTree.com, NADA.
Various parameters like Moodys credit Derivative rating, S and P rating etc along with KBB calculations is done for the customer evaluation and the Vehicle Grading.
This project involves creation of user interface maintaining of the database and generation of weekly and ad hoc reports using Excel Macros. Front End GUI was developed in Visual Basic
Responsibilities
Written Excel Macros and Unix Shell Scripts and generated Excel reports for Fixed income queries
Generated Front end for Fixed income User Validations using Visual Basic. NET/ Excel Front End
FTP ed large amount of corporate data from Windows to Unix using Excel Macros
Loaded data into Excel Reports from multiple Oracle and Unix data sources using Excel Macros
Linked Excel reports with Web and sent automatic emails to multiple customers with Excel Macros and Unix Shell Scripts
Included the Excel Add Ins features into reports with xla technology, C#
Linked remote OLE objects to the Fixed income Excel reports with Excel VBA and xla technology
Generated GUI open interface in Visual Basic. NET/ C# for user navigation
Generated COM components in Visual Basic/ C# to load excel reports on to web
Generated Procedures and functions in Oracle to automate database costing transactions
Generated Pivot tables with Excel Macros for summarization of region wise financial data
Loaded Huge amount of Excel file data into Oracle using SQL Loader and Unix Shell Scripts
Integrated Excel reports with Crystal reports and involved in report migration
Generated reports and integrated them with Web with Visual Basic .NET and XML
Used File Scripting Objects in accessing files and folders from Unix flat files
Generated Triggers and PL/SQL packages in Oracle for data base security

2003 -  2003
Visual Basic Programmer

GlaxoSmithKline is a multi billion Pharmaceutical Company with branches in many countries All over the world. It is 1 of the top 10 Drug manufacturing companies in the world and is among the Fortune 50 companies. Glaxo manufactures a wide variety of drugs and maintains huge inventory in various stages. The inventory is of 5 types : - Raw materials, Work in Progress Semi Finished products, Finished products and Packaged components
This application involves generation of front end for the Automation of Inventory Accounting of Glaxo. This application would enhance users to enter data, retrieve data and generate reports necessary for the Inventory transactions.
Responsibilities : Created Front end screens with user validations in Visual Basic, C#
Generated Pharmacy related weekly Excel sheets reports to front end using Visual Basic, C#
Generated Excel and Access Macros for the automation of Drug related Reports
Worked on Pivot tables for the summarized reports of Excel data
Normalized the pharmaceutical data into different normalized forms using ERWIN and generated tables, views, synonyms and sequences in Oracle, Generated Automatic graphical pharmacy reports using Excel Graphics and VBA
Linked graphical objects and templates to excel reports using XLA technology connected excel sheets to multiple data sources with XLA technology
Created Oracle PL/SQL Procedures and triggers for automation of backend transactions
Created ActiveX Controls for the linking of excel and Access reports to Visual Basic
Generated Unix shell scripts to load data from flat files to Oracle database
Helped in Transportation of large amount of data from Excel flat files into Oracle database tables using SQL*Loader and Unix Shell Scripts
Generated graphical reports with Excel Reports and loaded text data using Unix Shell scripts
Analyzed the drug related information using Unix Shell Scripts for MIS reports
Linked Excel reports and sent automatic mails to multiple users with Excel macros and Unix Shell Scripts

2002 -  2003
Developer

Procter and Gamble is a multi billion consumer durables manufacturing organization and is 1 the leading companies in the world in the field of consumer products This project involves the automation of the Sales data of the Pharmaceutical division of Procter and Gamble in Cincinnati, OH.
This application involves creation of the database and the front end screens for the weekly sales of a drug called Actonel 35mg. Initial data was collected from the medical prescriptions and the database was developed using normalized tables. Various reports were generated using Excel and Visual Basic. The excel reports were automated using Excel Macros and Excel VBA
Responsibilities : Created Front end screens with user validations in Visual Basic
Used ActiveX Controls for the linking of excel reports to Visual Basic
Generated Excel Macros for the automation of Excel Reports
Worked on Pivot tables for the summarized reports of Excel data
Loaded data into excel using Oracle database with Excel VBA and Unix
Generated MS Access Reports for Actonel drug based on prescriptions, Physicians and patients and linked to Excel with Excel VBA.
Created Normalized tables in Ms-Access and Oracle and FTP ed data with Excel VBA
Linked the Excel Reports to the web for the global access of the data.
Generated sub reports, mail matrix reports and master detail reports in Crystal reports
Linked reports to web using Crystal enterprise and Crystal reports
Created a repository of Excel reports paths with XLA technology and Unix
Included Add In features into the excel sheets with XLA technology
Used certain FTP tools for transport of excel through different Unix sources

Generated Graphical bar charts and other reports in Excel and Access
Loaded data into Excel sheets from multiple remote sources and provided cumulative data
Created Access Macros for automatic updations of linked tables

2001 -  2002
Programmer

Worked as a lead developer and automated - Key Accounting and Online Sales Automation Systems for SC Johnson, Racine, WI. SC Johnson is a leading multi billion Family company which is involved in the manufacture of consumer durable. The job involves automation of sales reports Using Excel macros and VBA. The reports maintain data for the sales details of SC Johnson In K-Mart, Wal Mart, Krogers and Food Lion. Involved in Design, Coding, Development, testing and Documentation.
Responsibilities
Written Excel Macros and generated Excel reports for MIS queries
Used File Scripting Objects in accessing files and folders.
Used Active x controls for automation of excel reports.
Managed Pivot tables in excel macros and reports in summarizing data
Employed App object to access local and remote resources.
used Excel and Access Macros and VBA with Excel Forms and Excel Charts.
Written Triggers for Excel charts for automation of reports
Included Add Ins features into Excel sheets with XLA technology
Included security and password features into excel reports using XLA features
Created linked tables in MS Access and also modules for front end Application
Generated monthly reports through Excel VBA and used Access VBA in initial report data modeling
Developed linkage of various excel reports through sub reports

1998 -  2001
Developer

Karvy Consultants Ltd, an ISO 9002 company is 1 of the leading Registrars in India for handling Mutual Funds both at the national level and global level. This Application shows the best Performing Mutual Funds in the Market. The User is given access to Research information on these Mutual Funds
Responsibilities used various triggers in Visual Basic to support the calculation, navigation and estimation logic in the Application.
Used ADO data objects and RDOs to connect to backend from Oracle 8.0

Education

Miscellaneous

Developed various performance reports for the Mutual Funds and User Profiles using Crystal Reports. Created Dynamic Reports by giving Flexibility to the User to provide input parameters. Created Crystal Reports for Parameter Passing.
Automated end reports using VBA with Excel.
Develop, install and customize Microsoft Office Tools MS Excel and Word as required by various departments and conduct end user training and support.
Generated Ad hoc query reports and spooled data to MS- excel reports and combined with OLE control.

Environment : Visual Basic 6.0 ASP, COM Components, Oracle 8.0 VB Script, MS-Excel, Crystal Reports 7.0 MS Access

Environment : Visual Basic 4.0 Oracle 6.0 Cobol, ProCobol, HP-UX