PROFESSIONAL SUMMARY:

• Over 19 years of experience in Application design, analysis, testing and production support.
• Designed SQL Server / Access database for storage and retrieval of real - time sensor data.
• Strong finance & accounting knowledge and experience.
• Extensive experience working with large Corporations in Agile and Waterfall environments.
• Extensive experience in Analyzing and migrating large data.
• Extensive experience on extraction, transformation and loading (ETL) data.
• Proficient working on all phases of SDLC.
• Designed and Developed user friendly screens in Access, VB 6.0 and VB.net.
• Published MS Access tables as a list on SharePoint server.
• Translated detailed designs into application.
• Proven background completing projects under aggressive financial and time constraints.
• Exceptional communication, analytical, and project management skills.
• Prepared High level, program-level and user-level documentation.

TECHNICAL SKILLS:

RDBMS / DBMS: MS SQL Server, MS Access, Oracle, MySQL, and FoxPro.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, MMC, I-SQL, T-SQL, PL/SQL, DTS, ODBC, SSRS, ADO, SQL OLEDB, DBCC.

Operating System: Windows, Red Hat Linux, Solaris.

Programming Languages: VB.Net, C#.Net, VB 6.0, VBA, Perl, VBScript, HTML, DHTML, T-SQL, PL/SQL.

Reporting Tools: Access Reports, Crystal Reports, Data Reports, SSRS, FoxPro reports.

PROFESSIONAL EXPERIENCE:

Confidential - Norfolk, VA

VBA Developer

Responsibilities:

• Modified existing VB scripts and VBA code during enhancements.
• Developed macros to automate Prepayment Letters & reports.
• Created smart GUI forms in MS Access using VBA for capturing auditing data.
• Migrated MS Access slow running queries to SQL Server Views.
• Created consolidated reports in MS Access and Excel.
• Create/Modify/Move queries to SQL Server views/Proc.
• Parse address field into Street, City, State and Zip code through macros.
• Fetch user & computer details from windows API.
• Extensively worked with “Pass through queries”.
• Automated daily reports in Excel using VBA & Macros.
• Migrated data while merging CIMS with Metric Stream.
• Worked with large datasets, Implemented OFFSET & FETCH NEXT key words in the select statement for splitting result sets.
• Migrated 40k Metric Stream cases to CIMS.
• Handled 76k attachments during data migration.
• Created VBA tool for migrating data.
• Created LOV’s & Column mapping for data migration.
• Utilized SQL server import/export tool for populating SQL server tables.
• Created hundreds of DSN less Linked tables for Prod & Dev environments.
• Created Tables, Views, and Procs in SQL server for CIMS & CRAV applications.
• Created staging tables, views, triggers and procs in Oracle for pulling Facets claims.
• Created staging tables, views, triggers and procs in Teradata for pulling ‘WellPoint Group System’ (WGS) claims.
• Modified/Enhanced existing Visual basic applications.
• Designed normalize Database for Pre-Payment providers.
• Created Dev environment for CRAV migration and merging CIMS with Metric Stream.
• Import data into SQL Server Dev environment from Prod during Dev environment setup.
• Created Application Current Status, functional and technical documents.

ENVIRONMENT: MS Access 2010, SQL Server 2012, Oracle 10, Teradata, VBA, Excel 2010, PEGA, JIRA.

Confidential - Glenn Mills, PA

VBA/Access/Excel Developer & Analyst

Responsibilities:

• Created smart GUI forms in MS Access using VBA.
• Extensively worked with Linked tables through ODBC.
• Automated data import/Export process using VBA.
• Worked with Excel objects to export data.
• Developed ActiveX COM components with methods and properties to upload bulk data.
• Registered DLL and d in Excel VBA.
• Developed custom data extracts and formatted results into a readable format.
• Built Excel VBA application that communicates with SQL Server DB using ADO objects.
• Extensively used VLOOKUP, data validations, and “Allow users to edit ranges” in Excel.
• Created reports in Excel using VBA.
• Created button groups in custom ribbons using XML for using custom Macros.
• Created Pivot tables and charts for summarizing data.
• Created technical documents, functional documents, Flow Charts and Entity diagrams.

ENVIRONMENT: Windows 7, VB 2012, MS SQL Server 2014, VBA, MS Access 2013, Excel.

Confidential- Philadelphia, PA

VBA Access Excel Developer / Analyst

Responsibilities:

• Translated business rules & logic into VBA.
• Developed user friendly screens for capturing data
• Created physical tables, link tables and temp tables as per the client requirement.
• Automated data update process for daily status report.
• Modified existing scripts to read and write to SQL Server tables.
• Implemented several complex SQL queries for reporting purposes.
• Developed macros to filter, format and send data as CSV attachment.
• Developed Tracking and comparison reports.

ENVIRONMENT: Windows 7, MS Access 2013, Excel 2013, VB 2012, VBA, SQL Server 2014.

Confidential - Grove City, PA

VB/VBA /Data Support & Data Analyst

Responsibilities:

• Migrated three large MS Access backend Databases to SQL Server.
• Normalize database with 133 tables.
• Created a web tool for uploading data from Excel to SQL Server in VB.Net.
• Modified/Enhanced existing Production Tracking Applications in VB.Net
• Modified/Enhanced existing Production control MS Access desktop applications.
• Installed & configured IIS web server for web applications (Environments Dev/Stg/Prod).
• Created smart GUI forms in MS Access using VBA.
• Developed reports for printing barcodes.
• Support & enhanced existing daily reports applications.
• Automated daily backup and compact & replace MS Access databases.
• Filtered and replaced data while migration.

ENVIRONMENT: MS Access 2010, SQL Server 2012, VB.Net 2012, VBA, ASP.Net, Excel.

Confidential - New York, NY

VBA Excel Access Developer /Data Analyst

Responsibilities:

• Developed macros to Automize daily / Weekly / Monthly reports.
• Developed macros to verify, split and compare data.
• Developed macros to filter & format trading and execution data and move to new work book.
• Handled large data sets (66 Million Records), Bulk Copy (BCP) in and out.
• Modified existing scripts to read and write to multiple databases at the same time.
• Automated Broker & user inactivity report.
• Created High level documents and Flow Charts for the existing script.

ENVIRONMENT: Windows 7, Excel, Sybase, SQL Server 2012, Access 2010, VB, VBA, Perl, SharePoint.

Confidential - New York, NY

VBA Excel Access Developer /Analyst

Responsibilities:

• Developed multiple Excel forms for SAP roles.
• Designed and developed GUI dashboard in MS Excel.
• Designed and developed “Role Mapping Tool” in MS Access.
• Published “Role Mapping Tool” on SharePoint server.
• Published existing MS Access tables as a list on SharePoint server and linked it back to the tool.
• Created validations in Excel.
• Developed macros to filter, format and send data as CSV attachment.
• Created Queries and Reports in Ms Access.

ENVIRONMENT: Windows 7, Excel, Access 2010, C# 2012, VBA, SAP, SQL Server 2012.

Confidential - Hoboken, NJ

Data Analyst / VBA Excel Access Developer

Responsibilities:

• Developed multiple input/output validation sheets.
• Designed and developed dashboard in MS Excel.
• Developed macros to fetch data from different data sources.
• Extensively used VLOOKUP & Index function throughout the project.
• Automated daily process to download data from Dell site.
• Imported data into excel from flat files.
• Developed macros to verify and compare data.
• Created queries to find new joiners and leavers.

ENVIRONMENT: Windows 7, Excel, Access 2010, VB 2012, VBA, PeopleSoft Data.

Confidential - Woodbury, NY

VB Developer

Responsibilities:

• Enhanced existing bus tools application.
• Developed application to indicate service status.
• Modified and updated master tables.
• Created VB forms to manipulate data.
• Developed macros to drop tables and recreate tables.
• Developed macros to delete data and refresh tables.
• Implemented pivot tables and charts in Access.

ENVIRONMENT: Windows, VB, Access 2010, Excel, VBA, XML, SQL Server 2008 and Share Point.

Confidential - Conshohocken PA

VB Developer

Responsibilities:

• Parse XML file and read configuration data from XML file.
• Implemented XML configuration settings into VB.
• Loop in several folders and servers for identifying required files.
• Filter & Pickup approx. 3000 files from multiple servers and upload on multiple servers.
• Created log files using System.IO.
• Send report as email attachment to users through SMTP using SQL server mail.

ENVIRONMENT: Windows, VB 2008, XML, VBA, Access 2010, Excel, SharePoint, FTP.

Confidential - Warren, NJ

VBA Developer

Responsibilities:

• Designed Dashboard in Access and excel.
• Designed an optimal one-to-many relationship layout of tables in Access.
• Created tables, Link tables, Views, Forms and Reports in Access from scratch.
• Developed macros to upload, export data automatically & periodically.
• Developed user friendly screens for capturing data.
• Created relationship between tables and queries in MS Access.
• Developed macros to fetch data from different data sources.
• Implemented conditional formatting in access reports.

ENVIRONMENT: Windows, Access 2010, Excel, VBA, Share Point, SQL Server 2008.

Confidential - St Joseph, MI

VBA Developer

Responsibilities:

• Designed Dashboard in excel.
• Designed Master form, Reports in Access.
• Developed data base queries to fetch data from Access.
• Developed user friendly screens for capturing data.
• Developed and performed test/debug functions.
• Implemented conditional formatting in Excel.
• Developed VB application to export data from SQL Server to Access.
• Created tables, Views, Forms and Reports in Access.

ENVIRONMENT: Windows, Access 2007, Excel, VBA, SQL Server 2008, Oracle 10, SAP BW.

Confidential - Freehold, NJ

Data Analyst / VBA

Responsibilities:

• Developed VB application to export data from SQL Server to Access.
• Developed front end forms for data automation in Access.
• Handled 3 TB database in SQL server.
• Created stored procedure for ETL and reporting.
• Developed custom data extracts and formatted results into a readable format.
• Developed Excel VBA applications that load data from the SQL Server databases.
• Designed and coded a Visual Basic ActiveX DLL.
• Enhanced an existing applications consisting of several VB programs and Access.

ENVIRONMENT: Windows, Access 2007, Excel, VBA, VB.net 2008, ASP.net, SQL Server 2008.

Confidential - New York, NY

Data Analyst / VBA Developer

Responsibilities:

• Designed GUI screens for capturing (General Info, Payment Info and product info).
• Built Excel VBA application that communicates with DB using ADO objects.
• Designed and developed user interfaces according to client requirements.
• Developed Access forms and reports for administration purpose.
• Enhanced an existing applications consisting of several VB programs and Access.

ENVIRONMENT: Windows, Access 2007, Excel, VBA.

Confidential

Access / Excel / VBA Developer

Responsibilities:

• Developed VB application program to export data from SQL SERVER to Access and excel.
• Enhanced an existing applications consisting of several VB programs and Access.
• Developed VB application program to import data from excel to SQL Server.
• Developed several stored procedures in SQL server and Oracle.
• Designed and coded a Visual Basic ActiveX DLL and EXE.

ENVIRONMENT: Windows, Access 2000, Excel, SQL SERVER 2000, ASP, Win Trade 4.3.

Confidential

Data Analyst / VBA Developer

Responsibilities:

• Worked with VB Forms, pull-down menus, buttons, and radio dials.
• Developed VB applications that load data from the SQL Server databases.
• Enhanced existing VB application that communicates with DB using ADO objects.
• Designed an optimal one-to-many relationship layout of tables in SQL server.
• Developed stored procedures for bulk data updates.

ENVIRONMENT: Windows, VB 6.0, VBA, Access 97/2000, Excel, SQL Server 2000.