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

Projects: Monthly Reporting System, Global Reporting Database, CTI ICG/Consumer Database.
MS Access VBA, MS Excel VBA

Confidential Rutherford Data Center encompasses six components: NA Planning and Analysis, NA Site Operations, Hardware Planning, Strategic Planning and Risk and Control and the NA Business Office, NA Control Office and NA Security Information.

Applications were created to support the CTI NA Senior Management team working with the "factory organizations," Client facing groups and managing budget performance for the whole group and worldwide. The team consists of Critical Systems Engineering, NA Assets and IT Transformation Management, as well as the NA Business Office.

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

Projects: Admin Database, Launcher Database, Floating Rate, Reconciliation Db, WMS Upload App, Access/Excel migration from MS Office 2003 to MS Office 2007, Citrix

State Street is the world\'s leading provider of financial services to institutional investors. It is an essential component in their client\'s business strategies. They provide service solutions that help make their clients fundamentally stronger — and more successful in serving their own customers. Including many other, the main three core business of State Street Corporation are Investment Servicing, Investment Management and Investment Research and Trading. Anup is involved in creating, maintaining and providing production support to MS Access Databases and Excel workbooks using VBA extensively.

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

Projects: Compensation Database, Inception Database, Equities, Municipal and Taxable Database

MS Access VBA, MS Excel VBA and SQL Server 2000

Merrill Lynch is a leading global financial management and advisory company. It serves the needs of both individual and institutional clients with a diverse range of financial services. Anup was involved in creating, managing and migrating couple of MS Access databases and SQL Server Databases. VBA for MS Access and MS Excel Visual Basic 6.0 has been extensively used in creating MS Access and MS Excel Applications/Utilities.
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

Projects: IGA Loader Database, 
MS Access and SQL Server 2000 Databases 
Thomson Financial is a leading global provider of integrated information solutions to business and professional customers. Thomson provides must-have information, with technology and applications that help its customers make better decisions, faster. Thomson server more than 20 million information users in the fields of law, tax, accounting, higher education, reference information, corporate training and assessment, financial services, scientific research and healthcare. Anup was involved in creating, maintaining and migrating MS Access and SQL Server databases using Visual Basic 6.0 and Access, Excel VBA.
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

Projects: Assessment Database, Next Steps Database, Equipment, 
Information System, Continuous Innovation Database, Scenario Capacity Generator

Bristol-Myers Squibb is one among the largest pharmaceuticals companies in United States with mission to extend and enhance human life by providing the highest-quality pharmaceuticals and health care products. The company is making a difference in the lives of millions of customers across the globe providing them with life saving drugs and other health care products from more then over a century. Anup was involved in development and maintenance of multiple IT projects going on in the company. The databases and applications were developed using Oracle 8I, Visual Basic 6.0, VBA, MS Access/97/XP, MS Excel/97/XP and Crystal Reports.
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

Ernst and Young is a large company known for high professional standards and the ability to deliver quality services. E & Y helps companies in businesses across all industries—from emerging growth companies to global powerhouses—to identify and capitalize on business opportunities. They deal in more than 130 countries worldwide can implement a broad array of solutions in audit, tax, corporate finance, transactions, online security, enterprise risk management, the valuation of intangibles, and other critical business-performance issues.
Anup was involved in the development of a major project of E & Y called GFIS (Global Financial Information System. The system is developed using Oracle, VB, and VBA (Excel/Access 2000).

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
Project: Project Information System
Projects: Contract Inventory, Teamster Services Database, Empire Time (Billing Information System)

Prudential Financial is a large company dealing in Insurance, Loans/Banking, Investments and Real Estate. Contract Inventory System is the system which prepares complex reports for all the contracts undertaken by Prudential. Sybase 10.0 is used as backend and Access 2000 and Crystal Reports are used for preparing various dynamic reports. Teamster Services Database is another big system developed using SQL Server 6.5 as backend and Access 2000 as front end. The complete system is recreated using SQL Server 6.5 as Backend and Visual Basic 6.0 as front end.

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
Project: Project Information System

Global Crossings is a Large Telephone Communication Company. The application involved keeping a record of the different information pertaining to the personnel, status and progress of the various projects undertaken by Global Crossings. The application was used by a number of users in various departments.
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
Project: Business Partnership Database

Description:
Board of Education NY is a Government Organization which has business relationships with other big companies like IBM, J P Morgan etc. These companies come up with variety of services for all schools in New York for development of schools. 
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

Confidential, Iselin NJ Aug 2000 to Oct 2000
Project: Site Information System

NCR Corporation is the company which takes contracts for preparing the databases for other companies using MS Access 97/2000 and Oracle 8.0. The information includes details like number of employees on site, contact person on site, No. of telephone connections, Information regarding HUB, PBX key system installations and there manufacturers and also keeps track on financial expenses done on the site including budgets, loans etc assigned for a particular site and processes the financial data.
Responsibilities:

• Import/Export of data between Excel to Access
• Developed complex Access Reports using Queries and Dynamic SQL
• Data Modeling and Database Designing.
• Created variety of Reports using VBA and SQL.
• Used ADO/DAO to connect SQL Server as Backend Database.
• Manage User Accounts and Access rights.
• Used Windows API and Active X Controls for Enhanced Data Entry Screens.
• Created a Runtime Version of the system using MS Access Developers Tool Kit 2000.
• Created Formulas and Macros for Excel Spreadsheets.

Environment: MS Access 2000, Windows 98, VBA, MS Excel 2000, VB6.0, SQL Server

Confidential, Manhattan NY Jan 2000 to Jul 2000
Project: Customer Information System

Customer Information system is a system which takes care of all the customer related information including all the order details. The system also includes the Domain name registration information and keeps the complete information for each type of domain extension. The system was developed in Access 97 and VBA is extensively used to generate variety of reports.
Responsibilities:

• Created Tables and Entity Relationship Diagrams (Database Design).
• Import/Export of data between Excel, Flat Files and Access
• Created a User Friendly Query Tool using Dynamic SQL.
• Used Active X Controls for enhanced screens.
• Developed complex Access Reports using VBA and SQL.
• Created Connection Objects using ADO to connect backend SQL Server Database
• Created Formulas and Macros for Excel Spreadsheets.
• Designed and Developed Excel Templates to extract and manipulate data from the Access Database using VBA.

Environment: MS-Access 97, VBA, VB 6.0, MS-Excel 97, SQL Server 7, Windows NT 4.0

Confidential, India Apr 1995 to Jan 2000

A software development company specializing in developing a variety of business software applications for clients all over the world .All the projects listed below are the turnkey assignments which Anup was involved in.

Project: EIS-Employee Information System Jul 1999-Jan 2000
EIS is a software which takes care of all the Employee related information right from his resume to his retirement. VBA has been extensively used to incorporate this functionality. 
Responsibilities:

• Develop Data Entry Screens and Processor Forms.
• Importing and Exporting of Data between Spreadsheets and Access Database.
• Develop complex Access Reports using SQL.
• Created Automated Excel Spreadsheets using Macros and VBA.
• Write VBA code for automated transferring of data between spreadsheets and other workbooks.

Environment: MS Access 97, Oracle 8i, Windows NT 4.0, VBA (MS Excel 97 and MS Word 97)

Project: Security Management System Oct 1998-Jun 1999
The system was developed using MS-Access 97 as Front End and Back End.
Responsibilities:

• Develop Reports using Access 97
• Data Modeling
• Write code using MAPI which exchanges data through emails
• Export/Import data between to and from Excel 97 and Word 97 using VBA code.
• Use FTP utility to transfer files over the internet.

Environment: MS-Access 97, Windows 95, VBA (MS-Excel 97 and MS-Word 97)

Project: Timesheet and Billing Management System Jun 1997-Sep1998
The system generates Access Reports as well as Excel spreadsheets using VBA.
Responsibilities:

• Develop Data Entry Screens
• Develop Reports using Access 97 and Generated Excel spreadsheets
• Data Modeling and Database Design.
• Co-ordination between the QA department and Development Team.

Environment: MS Access 97, Windows 95, VBA (MS Excel 97 and MS Word 97)

Project: Menu Management System Sept 1996 - May 1997
The system was developed using Access as Front-End and Back-End.
Responsibilities:

• Data Modeling and Database Design
• Creation and Modification of Tables and Relationships between them.
• Co-ordination between the QA department and Development Team.
• Handling all the QA documentation formalities.

Environment: MS-Access 2.0/97, Windows 95

Project: Financial Accounting System Sept 1995 – Sep 1996
The System takes care of the Financial Accounting requirements for small scale businesses. 
Responsibilities:

• Data Modeling
• Manage user Accounts and Access rights
• Creation and Modification of Tables and Relationships between them.
• Created Automated Excel Spreadsheets using Macros and Excel VBA

Environment: MS-Access 2.0, MS Excel, Foxpro 2.5, Windows 3.1

EDUCATION

• Polytechnic Diploma in Computer Science Confidential
• Diploma in Computer Applications Confidential