SUMMARY

• Over 9 years of experience in Application design, analysis, testing and product support.
• Developed 2 - tier/3-tierdesktop & distributed applications
• Developed user friendly screens in MS Access and Visual Basic
• Developed macros for automizing MS Access & other MS Office Applications.
• Worked with Ms Office 2010, 2007, 2003 and prior versions.
• Designed and coded a Visual Basic ActiveX COM and implemented in Access.
• Developed SQL Server / MS Access database for storage and retrieval of real-time data.
• Developed MS Access reports, Crystal reports, and Data reports.
• Developed complex PL/SQL packages, procedures, functions, triggers, and other database objects.
• Worked with large databases SQL Server, Oracle, Sybase, TeraData, and MySQL.
• Extensively worked on extraction, transformation and loading (ETL).
• Strong financial & accounting experience.
• Translated detailed designs into application.
• Completed projects under aggressive financial and time constraints.
• Exceptional communication, analytical, and project management skills.
• Created technical flow diagrams, screen flow diagrams, and class structures.
• Prepared program-level and user-level documentation.

TECHNICAL SKILLS

VBA / Macros: MS Access, MS Excel, MS Word and MS Outlook

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

Operating System: Windows 2000/2003/2008 server, Red Hat Linux, Solaris.

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

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

E R P: SAP(Finance & Control)

PROFESSIONAL EXPERIENCE

Confidential, NJ

MS Access Developer

Responsibilities:

• Designed Dashboard in MS Access.
• Developed macros for updating customer orders in MS Access Application.
• Created tables, Link tables, Views, Forms and Reports in Access from scratch.
• Developed user friendly screens for capturing customer information and order details in MS Access.
• Developed macros to upload, export data automatically & periodically in MS Access.
• Developed macros to fetch data from different data sources.
• Implemented pivot tables and charts in Access for summarizing data.
• Migrated prior versions of MS Office applications to 2010.
• Created relationship between tables and queries in MS Access.
• Get prescriber details in XML format from Oracle database through COM (DLL reference).
• Update member and payment information on SQL Server using ADO.
• Translated Excel formulas into VBA code (including “VLOOKUP”)
• Worked with Name range and data validations in MS Excel.
• Created report templates in MS Access.
• Created technical flow diagrams, screen flow diagrams, and class structures.

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

Confidential, PA

MS Access Developer

Responsibilities:

• Developed macros to loop into several servers & sub folders to pickup source files.
• Developed Macro to pickup source file from multiple FTP servers & Windows servers.
• Parse XML data and feed to FTP tool as configuration data through VB.Net component.
• Translated upload & transfer rules & logic into VBA code.
• Created macros to upload & download files on FTP Server.
• Created macros to copy and move files from windows server to FTP Server.
• Pickup approx 3000 files from multiple servers and then upload/transfer on multiple servers.
• Created macros to generate log files.
• Used shell command for uploading files on FTP server.
• Created macro to send report through outlook as email attachment to users.
• Prepared program-level and user-level documentation.
• 24/7 Product Support.

ENVIRONMENT: Windows, VB, Excel, Access, VBA, XML.

Confidential, NJ

MS Access Developer

Responsibilities:

• Designed Dashboard in Access & excel and linked macros to command buttons.
• Created tables, Link tables, Views, Forms and Reports in Access from scratch.
• Developed macros to upload, export data automatically & periodically.
• Implemented several complex SQL queries for reporting purposes.
• Translated business rules & logic into VBA.
• Developed macros to read data from internal Web pages.
• Developed user friendly screens for capturing data.
• Implemented Pivot tables and charts for summarizing data.
• Migrated prior versions of Access and Excel files to 2010.
• Developed Com to convert old value to new value from LOV
• Developed macros for accounting and financial calculations purpose
• Created relationship between tables and queries in MS Access.
• Developed macros to fetch data from different data sources.
• Developed and performed test/debug functions.
• Implemented conditional formatting in access reports.
• Created templates in Excel and Access for frequently created tables and tabs.
• Prepared program-level and user-level documentation.

ENVIRONMENT: Windows, Access, Excel, VBA, Share Point, SQL Server, C# and VB.

Confidential, MI

MS Access Developer / Analyst

Responsibilities:

• Designed Dashboard in excel and linked macros for step by step processing.
• Designed an optimal one-to-many relationship layout in MS Access.
• Developed macros for updating MS Office files on Share Point
• Developed macros for cost accounting and financial purpose in Excel
• Developed data base queries to fetch data from Access and other databases.
• Developed user friendly screens for capturing data in MS Access.
• Converted Excel formulas into VBA code (including “VLOOKUP”)
• Implemented conditional formatting in Excel.
• Developed macro for ETL and reporting purpose.
• Created tables, Views, Forms and Reports in Access.
• Used several types of data sources for connecting to different databases and files.

ENVIRONMENT: Windows, Access, Excel, VBA, SQL Server, Oracle, SAP BW and Share Point.

Confidential, NJ

MS Access Analyst & Developer

Responsibilities:

• Developed VB application to export data from SQL Server to Access.
• Developed front end forms for data automation in Access.
• Moved MDF and LDF files from production server to Data Center through macros.
• Created stored procedure for ETL and reporting purpose.
• Migrated Ms Access database to SQL Server database.
• Migrated prior versions of Access DB to 2010.
• Uploaded excel data sheets to MS Access and SQL Server.
• Designed and coded a Visual Basic ActiveX DLL.
• Enhanced an existing applications consisting of several VB programs and Access.
• Connected databases through ODBC for Micro strategy reports.
• Developed VB program to get pricing data from an external vendor and integrate into existing database.
• Developed ASP.net web pages for manipulating SQL server data using VB.net.
• Developed multiple input/output worksheets throughout the model.
• Developed a structure of input sheets and validate the data by user inputs.
• Developed applications using PL/SQL packages and Stored Procedures

ENVIRONMENT: Windows, Access, Excel, VBA, VB.net, ASP.net, SQL Server and Sybase.

Confidential, NY

Access Developer

Responsibilities:

• Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Access/VBA.
• Designed screens for maintaining details (General Info, Payment, Process Info).
• Developed macros to pull data from QuickBooks and format into Application requirements.
• Developed Com components using VB.Net
• Developed custom data extracts and formatted results into a readable format.
• Developed Excel VBA applications that load data from the SQL Server databases.
• Developed macros to upload, export data automatically & periodically.
• Migrated prior versions of MS Office applications
• Migrated Ms Access database to SQL Server database.
• Built Excel VBA application that communicates with DB using ADO objects.
• Extracted data from different databases and loaded into Application database using ADO.

ENVIRONMENT: Windows, Excel/Access/VBA, SQL Server, MySQL, PHP, HTML, QuickBooks and VB.Net.

Confidential

Access 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.
• Designed and developed user interfaces according to client requirements.
• Worked closely with administration department to determine the requirements and specifications.
• Designed and developed user interfaces according to client requirements.
• Developed Com components for accounting and financial calculation purpose.
• Developed several stored procedures in SQL server.
• Designed and coded a Visual Basic ActiveX DLL and EXE.
• Designed and developed user interfaces according to client requirements.
• Developed Access forms and reports for administration purpose.
• 24/7 Product Support for critical applications.
• Worked closely with administration department to determine the requirements and specifications.
• Enhanced an existing applications consisting of several VB programs and Access.
• Developed macros to pull data from QuickBooks and format into Application requirements.

ENVIRONMENT: Windows, Access, Excel, SQL SERVER, ASP, HTML, XML, Win Trade.