SUMMARY:

• Over 10 years of experience in IT and Client/Server based Application.
• Extensive experience in design, analysis, testing and production support.
• Designed and created a Microsoft Access database for storage and retrieval of sensor data.
• Analyzing functional business applications and design specifications for functional activities.
• Proven background translating cell formulas in Excel into VBA code.
• Designed and Developed user friendly applications in Excel and Access.
• Extensive experience implementing user interface based on client needs.
• Designed block diagrams logic flowcharts and translate detailed designs into application.
• Proven background completing projects under aggressive time constraints.
• Exceptional communication, analytical, and project management skills.
• Extensively worked on Visual Basic 6.0, SQL Server 2005.
• Extensively worked on extraction, transformation and loading .
• Developed and performed test/debug functions.
• Developed reports using Crystal reports, Data reports and MSTR reports.
• Prepared program-level and user-level documentation.

TECHNICAL SKILLS

EXPERIENCE:

Confidential

Web 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.
• Implemented several complex SQL queries for reporting purposes.
• Translated business rules logic into VBA.
• Get data from Web pages.
• Developed user friendly screens for capturing data.
• Implemented Pivot tables and charts for trading data.
• Migrated prior versions of Access and Excel files to 2010.
• 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.
• Analyzed, re-design user interface and program logic.
• Prepared documentation demonstrating the correct implementation of various financial and mathematical formulas in the new application.

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

Confidential

VBA Excel Access Developer / Analyst

Responsibilities:

Project: Program management

• Developed macros to Automize daily / Weekly / Monthly reports.
• Developed macros to verify, split and compare data for Shares, Futures and Options.
• 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.
• Created physical tables, link tables and queries for reporting purpose.
• Created Views, Backup, truncated and drop tables in Sybase and SQL Server.
• Modified existing scripts to read and write to multiple databases at the same time.
• Imported millions of rows using Power Pivot.
• Created and modified existing templates.
• Automated Broker user inactivity report.
• Developed data mapping tool for data migration.
• Analyzed data and created pivot tables.
• Translated VLookUp and other formulas into VBA.
• Created High level documents and Flow Charts for the existing script.

ENVIRONMENT: Windows 7, Excel, Sybase, SQL Server, Access, VBA, Perl, SharePoint, Microstrategy.

Confidential

Web Developer

Responsibilities:

• Developed VBA application to export data from SQL Server to Access.
• Developed front end forms for data automation in Access.
• Extensively used Excel functions in development
• Designed and created a Microsoft Access database for storage and retrieval of sensor data.
• Migrated Ms Access database to SQL Server database.
• Uploaded excel data sheets to MS Access and SQL Server.
• Designed block diagrams flowcharts and translate detailed designs into application.
• Developed VBA application to download data from Oracle to Excel.
• Enhanced an existing applications consisting of several VB programs and Access.
• Connected databases through ODBC for Micro strategy reports.
• Developed several VB programs to get pricing data from an external vendor.
• Designed and implemented a system to provide automation for pricing.
• Developed multiple input/output worksheets throughout the model.
• Analyzed, re-design user interface and program logic.
• Prepared documentation demonstrating the correct implementation of various financial and mathematical formulas in the new application.
• Developed and performed test/debug functions

ENVIRONMENT: Windows, Access, Excel, VB Script, VB.net, ASP.net, SQL Server and Oracle.

Confidential

Web Developer

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
• and reporting.
• Migrated Ms Access database to SQL Server database.
• Migrated prior versions of Access DB.
• 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.

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

Confidential

Web Developer

Responsibilities:

• Designed Dashboard in excel for managing macros.
• Analyzing functional business applications and design specifications for functional activities.
• Created relationship between tables.
• Developed data base queries to fetch data from Access.
• Developed VBA application to import data into Access from Excel files.
• Developed front end forms for data automation in Access.
• Developed Excel formulas in VB script including Sum if for Accounting purpose and conditional calculations.
• Developed Excel formulas in VB script including VLOOKUP for extracting data from external Excel files.
• Developed and performed test/debug functions.
• Developed VBA application to manage and maintain file size.
• Designed block diagrams logic flowcharts and translate detailed designs into application.
• Implemented conditional formatting in Excel.
• Developed VBA application to import data from SQL Server to Access.
• Created tables, Views, Forms and Reports in Access.
• Created templates in Excel and Access for frequently created tables and tabs.
• Used several types of data sources for connecting to different databases and files.
• Prepared program-level and user-level documentation.

ENVIRONMENT: Windows, Access, Excel, VBA, SQL Server, SharePoint.

MS Access/Excel DBA Developer

Responsibilities:

• Developed VB application to export data from SQL Server to Access.
• Developed front end forms for data automation in Access.
• Extensively used Excel functions in development
• Designed and created a Microsoft Access database for storage and retrieval of sensor data.
• Migrated Ms Access database to SQL Server database.
• Uploaded excel data sheets to MS Access and SQL Server.
• Used SSRS to create reports.
• Used DTS /ETL to Imports data from various data sources to SQL Server
• Designed block diagrams logic flowcharts and translate detailed designs into application.
• Enhanced an existing applications consisting of several VB programs and Access.
• Connected databases through ODBC for SSRS reports.
• Designed and implemented a system to provide automation for pricing.
• Developed multiple input/output worksheets throughout the model.
• Analyzed, re-design user interface and program logic.
• Prepared documentation demonstrating the correct implementation of various financial and mathematical formulas in the new application.
• Developed and performed test/debug functions

ENVIRONMENT: Windows, Access, Excel, VB Script, VB.net, ASP.net, SQL Server and Oracle.

Confidential

Web Developer

Responsibilities:

• Developed com components for VB application.
• Analyzing functional business applications and design specifications for functional activities.
• Developed and performed test/debug functions
• Developed Crystal reports and Data reports for various applications.
• Designed and implemented comprehensive Backup plan for Databases.
• Performed testing, distribution, documentation, and training on final application.
• Visual Basic in code was used for massive updating of records
• Developed User Interface using VB Script.
• Developed COM components in VB to implement business rules and data access objects.
• Developed database schema scripts, stored procedures and triggers.
• Involved in Model View Control MVC design pattern.
• Designed forms and reports in Oracle developer 2000.

ENVIRONMENT: Windows, SQL Server, Oracle, Access and VB, Crystal Reports, Data Reports.