We provide IT Staff Augmentation Services!

Ms Access /quickbase Developer /report Developer (system Engineer) Resume

Dallas, TX

SUMMARY

  • Over 14 years of IT experience as Senior Access Developer in MS Access (All Versions including 2013) and Project Lead, Team Lead, DB Admin.
  • 9 years of sound experience in managing and leading large development teams of 4 - 10 members
  • Strong experience in software development, design, project transitioning wif focus on Business Application Software using MS Access (All Versions) wif VBA and back-end like Oracle, SQL and SharePoint Server.
  • Designed and developed automated form wif Command Button for Data Extraction from using MS Access Front End wif SQL and Oracle Database back end database.
  • Extraction of Data from different data source like Excel, Text file and all other RDBMS. Experience in Software Development Life Cycle (SDLC) wif both waterfall and iterative models.
  • Data Migration involving MS Access Versions 97, 2000,2002,2003,2007,2010,2013,2016
  • Complex Query and Report Generation and send email automatically to specific users wif the report.
  • Extensive experience exporting data to flat files for submission to SQL/Oracle database.
  • Extensive experience of Importing Data from Excel and Text File wif delimited wif space and comma (CSV).
  • Created MS Word Mail Merge automation for letter /Email/Labels etc. using MS Access Database.
  • Created Pivot Table in MS Excel, used Vlookup, IF, Product functions.
  • Additionally have experience in the following domains: HealthCare, Banking and Finance, Mortgage Industry, Retirement Plan Provisions and regulations
  • Excellent written, verbal, interpersonal, team and leadership skills.
  • Used MS Visio for DFD and others flowchart.
  • RAD Experience in designing applications using Visual Basic Application.
  • Strong experience in Database Design, Store Procedure, User Interaction Form and various kind of Report generation.
  • Understanding large-scale project architecture, project execution strategies, and requirements gathering and translating it to software solutions.
  • Used MS Access VBA for Data Extraction Transformation and Load

TECHNICAL SKILLS

Languages: VBA(Visual Basic Application), Visual Basic, VB Scripts, SQL/PLSQL, TSQL,COBOL, C,C#, Visual FoxPro, Foxbase, dBaseIV (UNIX), Microsoft .Net 4.0

Databases: MS-Access 97/2000/2003/2007/2010/2013/2016 , SharePoint, SQL 2000, 2005/2008, ORACLE6.x/7.x/8.me, 10g. MySQL

GUI: Oracle Forms 6i, Oracle Reports 6i, MS Access Form

Web Related Tools: HTML4.0/XML, MS Visual Studio 2008

Packages: MS Office2000/MS Office XP, MS Visio, Adobe Photoshop 7.0

Reporting Tools: Business Objects 6.5/XI, Tableau 8.1/8.2, Crystal Report

Case Management: Serena ChangeMan VM Web Client. Microsoft Team Foundation

Hardware: Mini Computer (HP/HCL Meteor), 486 and Pentium PC, HP900 Series, IBM Xeon, PC’s

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

MS Access /QuickBase Developer /Report Developer (System Engineer)

Responsibilities:

  • Working of enhancement all MS Access tool
  • Migrating MS Access DB to QuickBase (Clouding computing)
  • Designed and Developed Attendance and Leave Tool in Quickbase (Cloud base computing) system for FMLA department.
  • Dash board using programming language, as well as ADO and DAO (data access technology),Data Validation Procedure for comparison from both versions of Data Bases.
  • Data Migration from MS Access 2007 to MS Access 2013, 2016
  • Data integration wif QuickBase and MS Access 2013, 2016 technologies.
  • Refined Data Exported to different Format like Excel for graphical presentation wif different kind of chart.
  • User Power programming is used for Internal Process automation
  • Developed User Interface Form and Database Relation
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Created User interface form using Data manipulation and processing data from different source.
  • Separate Report module for large volume different kind of data
  • Accrual Suspension Report. Daily Leave Attendance Report.
  • Created Oracle and Sql Database to migrate all MS Access Table backend Database.
  • Created frontend form (user interface), report, dashboard all kind of day to day basis schedule.
  • Used tableau reporting for different kind of matrix and dashboard.

Confidential - Miramar, FL

MS Access VBA /ETL Developer /Report Developer

Responsibilities:

  • Designed and Developed Brand Portfolio Management National Pricing Tool (MS Access 2010/2013 ACCDB)
  • Developed complete automation module for end user (EUC applications.) Created Custom Menu and Dash board using VBA programming language, as well as ADO and DAO (data access technology),Data Validation Procedure for comparison from both versions of Data Bases.
  • Created dynamic MS Access Pass-through queries to pull data form Oracle table using sql triggers.
  • Data integration wif MS Access2010/2013, SQL, used DAO and ADO data access technologies.
  • Refined Data Exported to different Format like Excel for graphical presentation wif different kind of chart.
  • User Power programming is used for Internal Process automation
  • Developed User Interface Form and Database Relation
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Created User interface form using MS Access Form for retrieving and processing data from SQL Database.
  • Importing and Exporting Data from various data base (warehouse)
  • Data Migration from MS Access 2010 to MS Access 2013
  • Developed Different kind of reports for MS Access 2013 and Reports connecting live Data wif MS Access, SQL 2008/2012, Oracle
  • Separate Report module for large volume different kind of reports
  • Used TFS for Project Management

Confidential - Washington, DC

MS Access Developer

Responsibilities:

  • Designed and Developed Re-class Statement Database Tool for re class accounts (MS Access 2007/2010 ACCDB) Version and Cost Analysis.
  • GLDM Process Tool (EUC applications.) and Reporting using MS Access and VBA
  • EMR MS Access/Excel Full automation system using VBA.
  • Timesheet process tool developed complete automation module for end user.
  • Financial Planning and Analysis.
  • Month end close GL and AP detail report.
  • VBA programming language, as well as ADO and DAO (data access technology), Data Validation Procedure for comparison from both versions of Data Bases.
  • Developed User interface Form and Sub form for Data Conversion procedure.
  • User Permission and Site administration on SharePoint.
  • Data integration wif MS Access2007/210, SharePoint and Oracle SQL, used DAO and ADO data access technologies.
  • Developed automation system for EMR tool using Excel and VBA
  • User Power programming is used for Internal Process automation
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Created User interface form using MS Access Form for retrieving and processing data from multi-platform database.
  • Importing and Exporting Data from various data base source.
  • Data migration from Access and 2010.
  • Developed Different kind of reports MS Access 2007/2010 and Tableau 8.0 connecting live Data wif MS Access, MS SQL 2008/2012,Oracle, SharePoint, MS Excel, Essbase. TSQL, MySQL
  • Developed complex metrics report for Prototype tooling using Tubule 8.2
  • Use ASP Microsoft .Net 4.0 for developing web based interface.
  • Used TFS for Project Management

Confidential - Warren, MI

Senior MS Access Developer

Responsibilities:

  • Designed and Developed Process Database Tool for Prototype Tooling Planning (MS Access 2010/2013 ACCDB) Version and Cost Analysis
  • Performed migration of Access 2007 to Access 2010 and Access 2013
  • Developed complete automation module for end user (EUC applications.) Created Custom Ribbon bar using VBA programming language, as well as ADO and DAO (data access technology),Data Validation Procedure for comparison from both versions of Data Bases.
  • Created dynamic MS Access Pass-through queries to pull data form Oracle table using sql triggers.
  • Data integration wif MS Access2010/2013, SharePoint and SQL, used DAO and ADO data access technologies.
  • Refined Data Exported to different Format like Excel for graphical presentation wif different kind of chart.
  • User Power programming is used for Internal Process automation
  • Developed User Interface Form and Database Relation
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Created User interface form using MS Access Form for retrieving and processing data from SQL Database.
  • Importing and Exporting Data from various data base (warehouse)
  • Developed Different kind of reports MS Access 2010 and Tableau 8.1 connecting live Data wif MS Access, SQL 2008/2012, Oracle, SharePoint.
  • Developed complex metrics report for Prototype tooling budget using Tubule 8.1
  • User Permission and Site administration on SharePoint. Use ASP Microsoft .Net 4.0 for developing web based interface

Confidential - Franklin Lakes, NJ

Sr. MS Access Developer

Responsibilities:

  • Designed and Developed Process Database Tool for Program Effort Plan and Capacity Planning (MS Access 2010 ACCDB) Version.
  • Developed complete automation module for end user.
  • VBA programming language, as well as ADO and DAO (data access technology), Data Validation Procedure for comparison from both versions of Databases.
  • Access 2003 to Access 2010 and Access 2013
  • Developed User interface Form and Sub form for Data Conversion procedure.
  • Used VBA code for automation for connecting SQL /SharePoint.
  • Used tables, views, queries
  • Data integration wif MS Access2010, SharePoint and SQL, used DAO and ADO data access technologies.
  • Refined Data Exported to different Format like Excel for graphical presentation wif different kind of chart.
  • User Power programming is used for Internal Process automation
  • Developed User Interface Form and Database Relation
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Created User interface form using MS Access Form for retrieving and processing data from SQL Database.
  • Importing and Exporting Data from various data base (warehouse)
  • Creating Different kind of chart for analysis for Business wif report
  • Developed Time Reporting MS Access 2010 Database Engine connecting live Data wif SharePoint and SQL.
  • Modified all old versions MS Access Database to MS Access 2010 Version.
  • Used TFS for Project Management

Confidential - Washington, DC

PROGRAMMER/DEVELOPER

Responsibilities:

  • Designed and Developed Process Database for conversion of MS Access 97 Database to MS Access 2010 (ACCDB) Version.
  • Developed complete automation module using MS Access VBA for convert 4500 MS Access 97 version MDB to MS Access 2010 ACCDB
  • Programmed VBA programming language, as well as ADO and DAO (data access technology), in MS Access 2010.
  • Data Validation Procedure written for comparison of both version of Data Bases.
  • Developed Pension/Retirement Plan Provisions and regulations package using MS Access, and for automation used VBA wif Backend Oracle Database Connection.
  • Developed User interface Form and Sub form for Data Conversion procedure.
  • Used VBA code for automation for Oracle 10g connectivity.
  • Data manipulation using tables, views, SQL Server.
  • Data integration wif Oracle
  • Used DAO and ADO data access technologies
  • Refined Data Export to different Format like Excel and Text format for user’s analysis.
  • Developed User Interface Form for Many To Many relation tables in MS Access Database
  • Creation of tables, data relationships, and advanced queries/reports, as well as modifying existing tables, data relationships.
  • Linking wif SQL Server and Oracle Database, user interface using VBA and Form
  • Created User Interface Form for retrieving and processing data from Oracle Database Server.

Confidential - Southfield, MI

PROGRAMMER/DATABASE DEVELOPER

Responsibilities:

  • Designed and Developed Clinical Data Model in MS Access (2003/2007)/SQL.
  • Created Junction Table and Version Control Data Model in MS Access.
  • Many to Many Data Base Relation model.
  • Form and Sub form for Customer Data Entry and Data Validation.
  • Multiple Nested Report generation for the users.
  • Refined Data Export to different Format like Excel and Text format for user’s analysis.
  • Used VBA code for automation.
  • Data integration wif SQL and Data Analyzer.
  • Data Validation Process Cycle.
  • Created - Pivot Tables and used function like (vlookup, sumif, sumproduct), Macros.
  • MS Visio for DFD.
  • Designed and Developed CPT codes Database
  • Electronic Medical Record Database Systems

Confidential - New Castle, DE

PROGRAMMER ANALYST/Developer

Responsibilities:

  • RAD Based Stock-Based Compensation Accounting Unit from scratch.
  • Designed and Developed Daily Sales Data Base Systems.
  • Automated Module Generation for Import data from different data source.
  • Data Entry Form.
  • Various Reports for Daily sales.
  • Report for GL Reconciliation.
  • Designed and Developed Foreign and Domestic Reconciliation Data Base Systems
  • Pulling Data from Different Source and Design RAD Systems.
  • GARS report Database for analysis.
  • All data are imported through automation process from Database and generated report for analysis.
  • Roll-forward Report
  • Inter-Company Database Information Systems
  • Global CAP Summary Process Stage 1 and Stage 2
  • DSA /RSA Summary Report
  • SAAS Data Form.
  • Created Complex Query/Macro/Module/ for the seamless automation process.
  • Incorporated wif Email process wif Outlook.
  • Used MS Access and VBA / VB Script along wif backend database (SQL /Oracle).
  • Data integration wif SQL
  • Used BOXI for reports.
  • MS Access Database Administration, Users Support, Trouble Shooting.
  • MS Visio for Data Flow Diagram.
  • Convert MS Access 2003 Database to MS Access 2007.

Hire Now