SUMMARY

• Over 14 years of experience in the IT industry, with wide variety of experience in Business Applications including Finance, Banking and Pharmaceutical.
• Specializes in Visual Basic 6.0/5.0/4.0, programming MS ACCESS (97/2000/XP/2003/2007) VBA front-end and back-end, MS Excel 97/2000/XP/2003/2007 VBA and is also proficient in the MS OFFICE Suite of software, particularly MS-WORD, FrontPage and Power Point including the interfacing/exchange of data between these softwares.
• Adept in CRYSTAL REPORTS and has experience in VBA (Visual Basic for Applications), and uses ADO/DAO to manipulate Microsoft JET Engine (ACCESS Kernel) and ODBC Data Sources.
• Relevant work experience in a wide variety of application software development with significant knowledge in design and development.
• Specializes in MAPI, WIN API, COM/DCOM, SMTP, FTP and HTML and lot of Third Party Controls.
• Experienced with all the phases of Project Development Life Cycle with more focus on Data Modeling, Database Designing, Coding, Optimization Issues, Testing and Implementation
• Presentable, hardworking, has leadership qualities and a valuable addition to any team.

TECHNICAL SKILLS

Languages

Visual Basic 6.0/5.0/4.0, VBA
MS Access VBA (Forms/Reports/Macros/Modules)
MS Excel VBA (Forms/ Macros/ Modules/Charts/Pivot tables)
MS Front Page, HTML
MS Word VBA
PowerPoint VBA SQL
Crystal Reports

Databases

MS-Access 2.0/97/2000/XP/2002/2003/2007, Oracle 8i, SQL Server 7.0 , SQL Server 2000, Sybase 11

Operating Systems

WINDOWS NT 4.0, WINDOWS 98/95, WINDOWS XP, MS DOS

Tools

MS-Office, MS-Project, Microsoft Visual SourceSafe, Lotus-123 4.0

Technologies

Client Server, Web Server, OOPS, SMTP, POP3, COM/DCOM, FTP

PROFESSIONAL EXPERIENCE

Confidential, NJ May 2011 - Present

Responsibilities:

• Application design and Database normalization.
• Creating Data entry Forms using VBA
• Created reports in Access and Excel 2003 and 2007
• Designed specifications/layouts for Data entry screens and reports.
• Securing the Database and providing user rights and logins.
• Maintenance and Production support of existing systems on day to day basis.
• Data migration and Data validation/Testing through VBA modules between MS Access and MS Excel 2003 and 2007 workbooks.
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.

Environment: MS Access 2003 and 2007 (VBA), MS Excel 2003 and 2007 (VBA), Windows XP

Confidential, Princeton, NJ October 2005 – May 2011

Responsibilities:

• Database Design and Normalization
• Requirement Analysis and Design
• Creating Data entry Forms using VBA
• Created reports in Access and Excel XP, 2003 and 2007
• Designed specifications/layouts for Data entry screens and reports.
• Securing the Database and providing user rights and logins.
• Maintenance and Production support of existing systems on day to day basis.
• Data migration and Data validation/Testing through VBA modules between MS Access and MS Excel XP,2003 and 2007 workbooks.
• Extensively used embedded SQL in VBA front end.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.
• Created Generic Query Tool to provide enhanced reporting interface using VBA.
• Wrote scripts to make the VBA Applications compatible with other OS\'s and MS Office Versions.
• Modified/Created MS Access and Excel applications to run on and off Citrix environment.
• Migrated MS Excel and MS Access applications from MS office 2003 version to MS Office 2007 Version.
• Resolved Production Support tickets for MS Access and MS Excel applications on daily basis.
• Setup MS Access/Excel applications to run on Citrix during regular server downtime as part of application side Risk Management.
• Coded various business rules in Excel reports to raise flags and send emails to Risk Management teams when Portfolio values exceeds tolerance levels.
• Documented the Application Operating procedures and Technical documentation.
• Automated importing and cleaning of data from text files and Excel into Access to upload in other applications.
• Used Sybase and SQL Server as backend database for MS Access and MS Excel applications.

Environment: MS Access XP (VBA), MS Excel XP & 2002,2003 and 2007 (VBA), Windows 2000,XP, Citrix, Sybase and SQL Server.

Confidential, Princeton, NJ March 2005 – October 2005

Responsibilities:

• Creating and Designing New Databases.
• Repair and enhancement of existing MS Access and MS Excel applications.
• Creating Data entry Forms using VBA and VB.
• Creating Complex Reports using Access and Excel as reporting tools.
• Designed specifications/layouts for Data entry screens and reports.
• Testing through VBA modules between MS Access 2000 and SQL Server.
• Designed and Normalized databases from scratch for new applications.
• Automated Importing of data to Access and SQL Server from flat files and Excel spread sheets.
• Integration between different Databases and Applications.
• Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA.
• Importing/Exporting data from pre-existing text files and excel spreadsheets in batch mode.
• Maintaining the MS Access application in production.
• Created Queries, Reports and Forms in MS Access using VBA.
• Database Security and Data Cleaning.
• Tested, Integrated and Implemented Access and SQL Server applications.

Environment: MS Access 2000 (VBA), MS Excel 2000 (VBA), SQL Server 2000, Visual Basic 6.0, Windows NT

Confidential, New York City, NYDecember 2004 – March 2005

Responsibilities:

• Analysis and Designing the MS Access applications in SQL Server 2000.
• Database Designing.
• Creating Data entry Forms using Visual Basic 6.0 and VBA
• Created Stored procedures, Views and Packages(DTS) in SQL Server 2000
• Designed specifications/layouts for Data entry screens and reports.
• Migrated MS Access databases to SQL Server 2000 and created Visual Basic front end.
• Created and Managed Registry Settings for the applications using VB6.0 and VBA.
• Maintenance of existing systems in production.
• Data migration and Data validation/Testing through VBA modules between MS Access 97 and SQL Server.
• Designed and Normalized databases from scratch for new applications.
• Automated Importing of data to Access and SQL Server from flat files and Excel spread sheets.
• Integrated small databases with corporate centralized database using Visual Basic and VBA.
• Updating data through VB front end in various SQL Server and Sybase Databases.
• Used Functions and Procedures to get data from Excel spreadsheets.
• Importing/Exporting data from pre-existing text files and excel spreadsheets in batch mode.
• Maintaining the MS Access application in production.
• Running Weekly and Monthly data updating batch process in SQL Server and Sybase.
• Created Queries, Reports and Forms in MS Access using VBA.
• Tested, Integrated and Implemented Access and SQL Server applications.

Environment: SQL Server 2000, Visual Basic 6.0, MS Access 2000 (VBA), MS Excel 2000 (VBA), Windows NT

Confidential, New Brunswick, NJ May 2003 – Dec 2004

Responsibilities:

• Requirement Analysis and Design
• Data Modeling
• Creating Data entry Forms using Visual Basic 6.0 and VBA
• Developed Query tools to extract data from Oracle and Access databases for reporting purposes for ad-hoc reports.
• Designed specifications/layouts for Data entry screens and reports.
• Converted MS Access 97application to MS Access XP version, maintaining table attributes and application functionality.
• Created and Managed Registry Settings for the applications using VB6.0 and VBA.
• Maintenance of existing systems in production.
• Data migration and Data validation/Testing through VBA modules between MS Access 97 and MS Access XP databases.
• Designed and Normalized databases from scratch for new applications.
• Extensively used embeded SQL in VB6.0 and VBA front end.
• Created parameter driven reports using Crystal Reports running thru Access VBA front-end.
• Created Generic Query Tool to provide enhanced reporting interface using VBA.
• Created Stored Procedures, Views and Triggers for all the existing queries in the Access database and additional business rules.
• Exporting the data from Excel 97 to Excel XP.
• Modified Excel 97 VBA code to make Excel XP compatible.
• Imported Data from Excel 97 to Excel XP workbooks.
• Providing Security to the System with respect to user access.
• Created Automated Spreadsheets in Excel XP using VBA.
• Integrated small databases with corporate centralized database using Visual Basic and VBA.
• Created User Forms and modified existing forms for the Excel XP version.
• Used Oracle and MS Access as Backend Databases.
• Consolidating the Spreadsheet Data.
• Created Graphs for Spread Sheets and MS Access Reports.
• Used Functions and Procedures to get data in Excel spreadsheets.
• Created Pivot Tables to view summarized Spread Sheet Data.
• Importing/Exporting data from pre-existing text files and excel spreadsheets
• System Documentation and wrote application help files.
• User Interaction
• Performed Unit and Integration Testing.

Environment: Oracle 8I, Visual Basic 6.0, MS Access/97/XP, MS Excel/97/XP, VBA, Crystal Reports, Windows NT/XP

Confidential, Lyndhurst, NJ Oct 2002- May 2003
Project: Global Financial Information System

Responsibilities:

• Database Design and Data modeling (MS Access 2000).
• Created Complex Queries and manipulated them thru VBA in Querydef Collections (Jet DB Engine).
• Designed and Developed Report layouts.
• Extensively used and created Queries at design time as well embedding SQL in VBA modules.
• Created VBA controlled Data entry Screens/Forms in MS Access 2000.
• Data retrieval from Backend database and populating in reports.
• Database conversion from MS Access 97 to MS Access 2000.
• Automated creation of Pivot Tables through reading INI (Text Files) files using VBA.
• Wrote Generic VBA code to create multiple reports at runtime.
• Manipulating the Pivot collections through VBA for Pivot table dependent reports.
• Automated formatting of rows and columns using VBA.
• Wrote macros and extensively used formulas and mega formulas.
• Imported Data from MS Excel 97 version to MS Excel version 2000 maintaining the functionality of workbooks.
• Controlling, Creating and performed Calculations in multiple worksheets/workbooks through VBA modules.
• Used various Excel built in Functions and used them in VBA code to implement possible automation.
• Created Excel Templates and .Xla files for Add Inns and report creation.
• Used Excel reports in VB as objects to use them at runtime.
• Created User Forms for data entry and data retrieval.
• Used VBA Functions to replace conventional formulas.
• Created VBA dependent Pivot Charts and Pivot Tables.
• Created Bar Graphs, Pie Charts etc to view summarized data.
• Manipulating large recordsets using VBA. (Used ADO/DAO for Backend Connection)
• Used SQL/Dynamic SQL extensively.
• Cleaning the existing Data and Designing the new Databases in MS Access 2000.
• Used VBA to create MS Access Dynamic Reports.
• User Interaction and involved in QA testing process.
• Integrating the Excel/Access reports to the existing VB Applications.

Environment: MS Excel 97/2000, VBA, Oracle 8i, Visual Basic 6.0, MS Access 97/2000, VBA, Windows 2000

Confidential, Scranton, PA Jan 2002-Sep 2002

Responsibilities:

• System Analysis and Design
• Database Designing and Data Modeling
• Creating Data Entry screens using MS Access and VBA, Queries, Dynamic SQL
• Created a user friendly Generic Query Tool .
• Crated Stored Procedures and Pass thru Queries.
• Database converiosn from Access 97 to Access 2000
• Used MAPI to create an email program for sending automated reply to the user requests.
• Recreating existing systems and optimizing them for better performance.
• Creating Databases from scratch in SQL Server and MS Access 2000.
• Preparing adhoc Reports.
• Creating all reports and retrieving data, dynamically changing the SQL statements for the query from the forms.
• Migrating Access Databases to SQL Server keeping the front end in Access 2000.
• Used ADO/DAO to connect backend databases.
• Extensively used Transact SQL.
• Data migration from Excel 97 to Excel 2000 and code modification.
• Converting the tables and queries into HTML format to publish on the Web.
• Providing security to the system with respect to user access.
• Created Automated Spreadsheets in Excel 2000 using VBA .
• Write VBA code for automated transferring of data between spreadsheets and work books.
• Created User Forms for the spreadsheets.
• Used Oracle as Backend Database.
• Used Functions and Procedures in Spread Sheets spreadsheets.
• Created Pivot Tables to view summarized Spread Sheet Data.
• Importing data from pre-existing text files and excel spreadsheets

Environment: MS Access 97/2000, VBA, SQL Server 7.0, Sybase 10.0,Visual Basic 6.0, Excel 97/2000, Windows NT

Confidential, Morristown NJ Feb 2001-Dec 2001

Responsibilities:

• Creating Data entry screens using MS Access VBA, Queries and Dynamic SQL.
• Created a user friendly Generic Query Tool.
• Designed specifications for Business Objects on the middle tier
• Used MAPI to create an email program for sending automated reply to the user requests.
• Created and Managed Registry Settings for the application.
• Used a number of WIN API calls for OS related settings.
• Creating all reports and retrieving data, dynamically changing the SQL statements for the query from the forms.
• Created reports using Crystal reports and Integrated them Report screens.
• Exporting the data to Excel Spreadsheets to publish them on the Web.
• Converting the tables and queries into HTML format to publish on the Web.
• Providing Security to the System with respect to user access.
• Created Automated Spreadsheets in Excel 2000 using VBA.
• Created Macros in Lotus-123.
• Created Pie Charts, Bar Graphs for Lotus Sheets.
• Write VBA code for automated transferring of data between spreadsheets and work books.
• Used Oracle as Backend Database.

Environment: MS Access/2000, VBA, VB 6.0, Excel VBA, Crystal Reports, Windows NT

Confidential, Brooklyn NY Nov 2000 to Jan 2001

Responsibilities:

• Analysis and Design
• Database Designing and Data Modeling
• Designed and Developed Tables and Data Entry Screens
• Created a customizable user friendly Query Tool using Dynamic SQL.
• Developed complex Access Reports using VBA and SQL.
• Handled Optimization Issues related to linked objects from ODBC data sources.
• Migrating MS Access database to a robust Oracle 8i database and converting Forms, Reports, Procedures in Visual Basic 6.0
• Created Formulas and Macros for Excel spreadsheets and editing them making more proficient.
• Used ADO/DAO to connect Backend Database.
• Consolidating Data of Spread Sheets.
• Created Charts and Pivot Tables for Excel Spread Sheets.
• Created User Forms in Spreadsheets.
• Created Macros in Lotus-123.
• Created Pie Charts, Bar Graphs for Lotus Sheets.
• Write Functions/Procedures and executed them through VBA code and Cells.

Environment: MS-Access 2000, VB 6.0, Excel VBA, Windows NT 4.0, VBA

EDUCATION : Confidential