We provide IT Staff Augmentation Services!

Database Design Resume

Princeton, NJ

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

Hire Now