We provide IT Staff Augmentation Services!

Vba Developer (excel/vba/vb) Resume

4.00/5 (Submit Your Rating)

VA

SUMMARY

  • 9+ years professional Microsoft Technologies in Designing, Developing and Implementing Intranet, Internet, client/server applications, web development, Object Oriented Programming in Software Development Life Cycle (SDLC) using Microsoft.NET Framework 4.0/3.5/2.0/1.1 , ASP.NET, VBA, C#, VB.NET, ADO.NET, AJAX, JAVASCRIPT, IIS 5.0/6.0/7.0, Web services, HTML, XML, Database Queries, Stored Procedures, Views, Functions, SQL Server tuning and Triggers Using SQL 2012/2005 and Oracle.
  • Having extensive experience in all phases of Software Development Life Cycle (SDLC) including Architecture, Requirement analysis, Design, Development, Implementation, Debugging, Testing, Documentation and Maintenance of Client/Server and web based applications.
  • Ability to conceptualize, document, and communicate project ideas and plans.
  • Have extensively worked on OOPS CONCEPTS Abstraction, Encapsulation, Inheritance, and Polymorphism.
  • Experience in updating, accessing and version controlling the source code using Visual Source Safe (VSS), Tortoise SVN and Team Foundation Server (TFS).
  • Experience in creating Single Page applications using Angular JS Created code for Angular JS based application for a new functionality to communicate to a Web API.
  • Excellent knowledge and experience of VBA and business finance
  • Good Experience in developing with Visual Basic programming
  • Comprehensive knowledge of MS Excel in a business environment
  • Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI), Inversion of Control (IOC), Singleton, MVVM and MVC.
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
  • Experience in Database Analysis/Normalization processes using SQL Server, MS Access, Oracle.
  • Strong analytical and problem - solving skills coupled with excellent written, verbal and interpersonal communication skills.
  • Experienced in creating test cases in Unit Testing
  • Strong Skills in developing 3-Tier and N-Tier Architecture systems deployed on windows Platform.
  • Very good experience with agile/SCRUM development.
  • A good team player with strong ability to learn and adapt new skills and makes efforts to do the work at hand and manage time effectively.

TECHNICAL SKILLS

Platforms : Windows 7/NT/2000/XP, Windows server 2003

Programming languages: C#.NET, VB.NET, ASP.NET, PL/SQL, Excel/VBA, VB, ASP, PL/SQL

Scripting languages: JavaScript, Angular JS, JQuery

Development Tools: VisualStudio.NET 2003/2005/2008/2010/2012/2013.

Databases: MS SQL Server 2012/2008/2005/2000 , Oracle, MS-Access

Web Technologies: HTML/XHTML, DHTML, HTML5, XML, XSL, CSS, ASP.NET WEB SERVICES, SOAP, WCF, RESTful, VSS, AJAX, Angular JS.

Web Server: IIS 7.0/6.0/5.0.

Version Control: VSS, TFS and Tortoise SVN

Others: Toad, SSRS, Entity Framework

PROFESSIONAL EXPERIENCE

Confidential

VBA Developer (EXCEL/VBA/VB)

Responsibilities:

  • Developed macros to protect the workbook based on committee stages
  • Implemented Authentication and Authorization to the Model.
  • Consuming restful services to get the existing data, parameter data and mapping data.
  • Created JSON object to save the data into database.
  • Implemented JSON parsing to get the values from JSON Object.
  • Implemented various validations like ping, out of sync and Active Participant
  • Involved in creating the Add-In to implement all models.
  • Ensured maximum performance of processes in coordination with internal IT teams.
  • Developed .exe using C#.Net to distribute the DLL into Business Analysts Systems.
  • Developed DLLS using EXCL - DNA using C#.Net.
  • Version control access
  • Worked in AGILE environment and participated in daily SCRUMS
  • Migrated office 2010 to 2016.

Environment: MSOffice 2010/2016, VBA (Macros), .NET Framework 3.5, Visual Studio .NET 2015, MS SQL Server 2012, Documentum, JAVA

Confidential, VA

.Net Developer

Responsibilities:

  • Responsible for designing the ASP.NET application authentication using .NET Framework, C#.NET, Model View Controller (MVC).
  • Created dynamic front-end webpages using AngularJS.
  • Setting up AngularJS framework for UI development. Developed html views with HTML, Bootstrap, JQuery, JSON, and Java Script.
  • Designed Frontend with in object oriented JavaScript Framework like Angular.js
  • Created and tested scripts using JQuery on various browsers Chrome, Firefox, Opera, IE, etc
  • Helped implement the DAL layer of Web API using Entity Framework.
  • Involved with the design of client interface, defined needed data validations and wrote client side validation scripts using JavaScript.
  • Followed Scrum and Test Driven Development Methods in Agile Scrum Methodology to produce high Quality software.
  • Developed application as n-tier application with UI in the presentation layer using ASP.NET 4.0, business logic in the middle layer using C#.NET and data service activities in the backend using MS SQL Server 2012.
  • Created ASP.Net pages and Class Libraries containing code for business and data access logic using C# .Net.
  • Built front-end SPA using CSHTML, AngularJS, and bootstrap and back-end using ASP.NET MVC and Web API.
  • Developed the validation process on both client side and server side using ASP.NET validation controls.
  • Worked with WEB API's to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server.
  • Retrieved and update data using SQL server as database and wrote Stored Procedures and SQL queries for business rules.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Generated several drill down and drill through reports using SSRS.

Environment: .NET Framework 4.0, C#.Net, AngularJS, Microsoft MVC, HTML, CSS, Web API, Microsoft Visio 2010, MS SQL Server 2012, JQuery, SSRS, TFS, IIS7.0.

Confidential, Jacksonville, FL

.Net Developer

Responsibilities:

  • Implemented Forms-based Authentication in ASP.NET to authenticate the users.
  • Designed and Implemented the Data Access Assembly using ADO.NET, C#. NET, SQL-Server.
  • Implemented AngularJS Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory.
  • Designed, developed, maintained Application using VB.Net, C#, ASP.NET 4.0, MVC, Javascript, JQuery, Angular JS, HTML, CSS.
  • Creating custom, general use modules and components which extend the elements and modules of core AngularJS
  • Implemented AngularJS Controllers to maintain each view data. Implemented Angular Service calls using Angular Factory
  • Utilized various JQUERY plugins to build Rich Internet Application RIA to make it look more intuitive.
  • Helped implement the DAL layer of Web API using Entity Framework.
  • Extensively involved in Developing Components for Business Layer, Data Layer.
  • Created stored procedure, trigger on the database to provide/insert specific data from multiple tables for Web API services.
  • Gained experience in REST architectural style, worked on CRUD actions. (Get, Post, Put and Delete).
  • Configured Web.Config file for the configuration of the entire Web Application.
  • Extensively used Dataset, Data Reader and Data Adapter objects to retrieve and manipulate data and display it onto an ASP.NET page.
  • Extensively used .NET Web Services implemented in C#, to fetch data from various sources and analyze it.
  • Used Entity Framework Code First approach for the Data Access Layer for the ASP.NET MVC application using HTML5 and Razor view.
  • Used web services to interact with data layer to access data from the database.
  • Worked in AGILE environment and participated in daily SCRUMS

Environment: Net Framework 4.0, C#.Net, MVC, Visual Studio 2012, ASP.NET 4.0, JavaScript, AJAX, JQuery, Angular JS, Web API, Entity Framework 5.0, HTML 5, IIS, XML, SQL Server 2012, TFS

Confidential, Charlotte, NC

.Net Developer

Responsibilities:

  • Designed the application as a three-tier application with UI in the presentation layer, Business logic in the middle layer and Database activity in the third layer.
  • Designed and developed user interfaces in ASP.Net / C#.
  • Developed and used ADO.Net objects for handling database activities.
  • Used LINQ to build set of operations, parameters and expression during execution a set of data from SQL Server.
  • Created Integration Services SSIS package to import raw data from MS Excel to the SQL Server.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Performed client and server validations using Validation Controls.
  • Developed many T-SQL queries to fetch data as per the business requirements with proper tuning techniques.
  • Responsible for writing stored procedures and triggers.

Environment: .NET Framework 3.5, C#.Net, Ajax, Microsoft MVC, HTML,CSS, Web Services, Webforms, Visual Studio .NET 2010,WCF,Visio, MS SQL Server 2008, SSIS, TFS.

Confidential

.Net Developer

Responsibilities:

  • Worked with clients in gathering various business requirements and translated them into technical specifications. Developed requirements, design, test plans and deployment artifacts.
  • I have trained new staff members on project specific technologies and ensured their utilization efficiently.
  • I performed technical lead duties and worked with staff members in successfully implementing various maintenance and enhancements releases in a highly demanding environment; worked closely with staff in reviewing their changes, refining them as needed and training them as needed. This ensured in successfully utilizing the team and working on delivering various releases on time and within budget.
  • Create one prototype application for presentation purpose to get the approval from client.
  • Involve in design and developing (coding) part of application
  • Before deliver the application test the whole functionality
  • Maintenance of application
  • Handle if any changes required by clients after deliver the application
  • Provide the services in SEO(Search Engine Optimization) by implementing the different strategies such as on-page optimization(keyword research) and Off-Page Optimization (Social Media Marketing, Link-Building)

Environment: .NET Framework 3.5, C#.Net, Ajax, Microsoft MVC, HTML,CSS, Winforms, Webforms, Web Services, Visual Studio .NET 2008, Microsoft Visio 2010, MS SQL Server 2008, TFS, SourceTree (GitHub).

Confidential

.Net Developer

Responsibilities:

  • Interacted with business users to gather business specs and prepared design docs (use cases, sequence diagrams).
  • Object-oriented concepts such as abstraction, polymorphism, interfaces, delegates, classes, constructors, methods
  • Develop controls such as user-controls, listviews, editing and validation, modal popups and Ajax extenders, dropdown lists, file uploaders, query strings, SQL Datasource
  • Created ASP.Net pages and Class Libraries containing code for business and data access logic using C# .Net.
  • Update with ASP.Net AJAX to allow for instant updating of client-side HTML fields without doing a post back.
  • Developed the validation process on both client side and server side using ASP.NET validation controls.
  • Involved with the design of client interface, defined needed data validations and wrote client side validation scripts using JavaScript.
  • Involved in the design of the business flow along with the development of the application.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Extensively used bulk collection in PL/SQL objects for improving the performing.
  • Involved in Logical & Physical Database Layout Design.
  • Worked on . NET WinForms, state management, user controls, and secured .NET windows application by using .NET security model (Membership, Authentication, Authorization, Roles, Profiles and Cryptography).
  • Implemented layer architecture with emphasis on programming Business Logic and Data Access Logic Layers.
  • Developed reusable .NET components to perform business processes and interact with the database using ADO.NET.
  • Change settings in web.config file according to application needs
  • Deployed the application on web servers and application servers in development environment.
  • Utilized Form based authentication to get customer’s identity. Used Cookies and Session objects to store customer's preferences.
  • Set-up and Design of Backup and Recovery Strategy for various databases.
  • Provided user training and production support.

Environment: ASP.NET Framework 2.0, C#.Net, Ajax, ADO.Net, JavaScript, UML, HTML,CSS, Winforms, Web Services, Visual Studio .NET 2005,TOAD, SQL, Pl/SQL, Webforms, Microsoft Visio 2003, Oracle, VSS.

We'd love your feedback!