Vba Excel Access Developer

Sujan Manandhar

Professional Summary:

●Certified Excel/Access VBA developer with more than 9 years’ experience in Finance and Retail verticals

●Master of Business Administration in Accounting/Finance

●Excellent understanding of real-world financial markets and technology systems

●Experience in working with executive management, technical architects and business end-users working through change management and new technology deployments.

●Experience in integrating Excel/Access application with External Databases, outlook, import and export data files using import, export features. Expert in retrieving data from various databases using Active X Data Object.

●Expert in Data Modeling Tools like Erwin and Navicat Data modeler.

●Extensively used MS Visio for number of diagramming needs like UML Diagrams.

●Solid background in table/query design, report design, and automation of financial tools utilizing VBA modules and Macros.

●Deep Understanding of various SDLC methodologies having worked in project based scenarios and platform like Share point Server.

●Comfortable with using project management tools like MS Project Server for Project tracking.

●Extensively worked in .net framework environment for creating class libraries and calling them through VBA

●Proficient in understanding financial analysis and managerial requirements and creating Modules and Macros with Excel VBA in different business environments.

●Proficient in handling errors, debugging, troubleshooting and validation of user data.

●Experienced in data migration, automation of report generation also in designing templates, working with pivot tables, graphs, user forms, user defined functions and creating and using add-ins.

●Expertise includes extracting data from different file formats like EGT/ESS (compression and normalization of existing database), XML, MDB, ACCDB, ORA, ODBC, ADO etc.

●Excellent experience in the areas of Design, Analysis and Development of Software Applications using Access and Excel VBA.

●Efficient and experienced in converting requirements to technical specifications, developing solutions, documentation, providing application support and train users.

●Extensive experience in developing, maintaining and testing, class modules using MS Access

●Efficient and experienced in converting requirements to technical specifications, developing solutions, documentation, providing application support and train users.

●Details oriented and excellent team player with extraordinary analytical, strategic planning, interpersonal and communication skills. Highly motivated, enthusiastic and self-starter with exceptional ability to perform individually.

Certificates:

Certification in Web Development

Certification in Oracle Database Administration

Education:

Masters of Business Administration

Major - Accounting/Finance

Minor - Management Information System

Proficient Business/Technical Skills:

MS Excel 2000/2003/2007/2010/2013, VBA, MS Access 2000/2003/20072010,2013 VB6/7/8/9/10/11/12, C# .Net,VB.net, Microsoft Visio, Microsoft Project, Erwin, Transact SQL, PL SQL, Rest, Dot Net framework, SQL Server2005/2008/2012, Oracle 9i/10g/11g, Crystal Reports 8.5/ 11.

Intermediate Business/Technical Skills:

Java, Python, PHP, JavaScript, jQuery, Ajax,HTML5, CSS, MVC 3.5/4, VB.Net, C#, Bootstrap, Angular, ASP.Net, SOAP, SharePoint Server, SharePoint designer

Dress Barn Inc. – Mahwah, NJ July 2016 – Present

Senior Excel/Access VBA Developer

Dressbarn is part of the Ascena Retail Group, Inc. family and remains customer centric, extremely sensitive to and focused on the needs and desires of women in the 21st century. The project involves maintaining, enhancing and developing their Line Planning Application which is excel based vba application whose data feed connected to Oracle RMS and Microsoft Microstrategy and MS Access 2016.

Responsibilities:

●Participation in issue identification and resolution sessions

●Modified and create front end screens which are linked to custom vba modulae functions that handle automated tasks

●Created back end logic to drive business logics and front end display algorithms using vba codes within modules

●Maintained system tables/data and update where business planning rules are changed

●Programmed code changes and have the test version ready for UAT and deployment after it passes business review

●Maintained separate application environments for timely version updates

●Managed service requests and act accordingly to resolve in timely manner

●Started initial planning and recommendation on future enhancements

●Participated in user level training on application and also help new trainees

Tools & Technologies:

Microsoft Office 2010/2013, MS-Excel 2010/2013, MS-Access 2010, VBA Project, Oracle 10g, Oracle RMS, SQL Server 2012, PL/SQL, T-SQL, Visual Studio 2013, ASP. Net 4/4.5/5,Custom UI, JavaScript, MKS Integrity Client, Front Range

Chico's FAS – Fort Myers, FL March 2014 – May 2016

Sr. Excel/Access/VBA/.Net Developer

Chico's FAS through its brands - Chico's, White House Black Market and Soma, is a leading women's Omni-channel specialty retailer of private branded, sophisticated, casual-to-dressy clothing, intimates, complementary accessories, and other non-clothing items. This project involved enhancing existing vba/access based inventory management application and also creating a new c# .net intranet application for managing stores.

Responsibilities:

●Performed enhancements and maintenance tasks on application named Business On Order Management (BOOM).

●Consolidated all product and location attributes across brands aligning attributes, names and values increasing clarity for business partners and reporting.

●Troubleshoot emerging or ongoing issues and make functional changes or improvements as laid out in requirement documents which are prepared with ongoing consultation with business.

●The back end for BOOM is linked to SQL Server 2012 database but ultimately all data eventually flows in and out to SAP master database. Export is carried out with PO Upload Tool which is Microsoft Excel based application created to simplify data transfers and generate report for the users.

●Performed enhancements as per user requests to the Store Placeholder Application which is a .NET 4/4.5 based web application written in C# with back end oracle database. The enhancements involved making UI changes and also functionality enhancements involving the user’s ability to edit placeholders.

●Created web application written in C#/VB which would extract product values from Master Data (SAP) and store in oracle database where users would edit attributes and eventually update the Master Data.

●Created web application for business to maintain and edit location eligibility information. The front end was written in HTML5, CSS and JavaScript. Backend logic written in ASP.Net and ADO.Net for connecting to oracle database.

●Wrote test cases for the UAT as a base to carry out tests.

●Created user documents for the business on any new changes carried to the applications.

●Performed maintenance and troubleshoot on any issues reported by the business.

Tools & Technologies:

Microsoft Office 2007 & 2010, MS-Excel 2007/2010, MS-Access 2007/2010, VBA, SQL Server 2008/2012, T-SQL, Visual Studio 2012, ASP. Net 4/4.5, Custom UI, XML, JavaScript, Quality Center 11.0, Citrix, Tortoise SVN, Google Docs, Google Sheets

The Hershey’s Company - Hershey, PA March 2013 – Feb 2014

Senior VBA/Excel/Access Developer

The Hershey Company is the leading North American manufacturer of quality chocolate and non-chocolate confectionery and chocolate-related grocery products. The project focused on developing and also enhancing existing Product Screening Tool Systems and ensuring compatibility with the Company’s goal of upgrading all its systems to Windows 7 and Office 2013.

Responsibilities:

●Remediated PST so that it is compatible with Office 2003, 2007 and 2013.

●Eliminated DTS and upgrade the existing ETL with DTSX packages to upload data from SAP Unix Server to SQL Server.

●Created a separate application to monitor errors and address these issues.

●Incorporated Application enhancements based on user requirements related to business process change or User Interface.

●Generated stored procedures to handle CRUD operations and also generate custom reports.

●Created rest service using WCF that could be consumed by PowerBuilder based PCM Tools and EPM Tools in SharePoint.

●Created code snippets to parse data in XML and JSON formats.

●Created various office add-ins and supporting installation programs that targets windows APIs and DLLs so that the environment could be maintained for the application to performed as required.

●Created flexible forms, reports and pivot tables to present data to the user.

●Incorporated .Net libraries and classes with VBA to enhance the application functionalities and compatibilities with other organization applications.

●Improved the ETL process for the monthly and yearly data update process.

●Created test scripts and cases to for unit testing and conducted those test documenting the test results in quality center 11.0.

●Monitored SAP CRM for tickets as a second resolver.

●Created detailed documentation and training materials for a smooth transition and knowledge transfer.

Tools & Technologies:

Office 2003, 2007 & 2013, MS-Excel 2003/20072013, MS-Access 2003/2007/2013, VBA, SQL Server 2008, MS-SQL Server 2005, T-SQL, Visual Studio 2010, Custom UI, XML, JSON, Quality Center 11.0, Citrix, FileZilla, SAP CRM

Express Scripts - Lincoln Park, NJ Feb 2012 – Feb 2013

Excel/Access/VBA Developer

Express Scripts manages pharmacy benefit programs for employers, unions and government health plans. The project involved automating and managing large sets of data for further analysis and/or further consumption by other application.

Responsibilities:

●Performed data sanity checks and consolidate data from other pharmacy information systems for further consumption

●Worked with triggers, stored procedures and views while handling large data

●Created codes for searching records based on various criteria and also for producing reports based on multiple parameters, and exporting that data to MS Excel.

●Designed and develop user interface for viewing/printing of the reports and also performing regular automated tasks.

●Developed VBA Macros to read table definitions from Excel and automatically create those tables in Access.

●Identified entities and attributes and created Conceptual, Logical and Physical data models.

●Created User Login Form and developed several scripts to control the different access level for users.

●Enhanced & developed several Excel Reports & templates which connected to numerous tables in an Oracle database using ADO.

●Created flexible forms and reports using SQL and VBA to read, update and append records to the Oracle tables.

●Performed database creation, database tuning, Indexing, performance planning and backup planning.

●Created a personal Access application to keep track of progress on all individual projects for reporting, status and scheduling purposes.

●Created requirement details documentation, implementation documentation, user acceptance testing documentation, support documentation, user manuals and technical documentation for all applications.

Tools & Technologies:

MS-Access 2007, MS-Excel 2007, VBA, T-SQL, MS-SQL Server 2005, ERWin 7.2, MS Visio, SharePoint, MS Project Server

EQuality - Loretta, MN Jun 2010 - Jan 2012

Excel/Access/VBA Developer

EQuality - Pathways to Potential, a community based program assists adults with developmental disabilities with finding and maintaining competitive and contracted employment. They help each individual find meaningful work, grow and develop personally, and participate in their community. The project involved creating an access application used specifically for tracking programs and coordinating their life cycles.

Responsibilities:

●Designed and create tables from scratch as per agreed application design

●Created communication reports and training materials that could be circulated to users

●Wrote excel and access macros in vba code for automation of donor and projects reports.

●Designed Front end screens with user validations in Visual Basic, Excel.

●Worked on Pivot tables for the summarized reports of Excel and Access data.

●Performed data checks and also necessary application changes as per user requests

●Managed data feeds from multiple individual excel and text files

●Created MS Access and Excel Front end to load local data into XML using MS Excel macros.

●Worked on Transportation of large amount of data from Excel flat files into SQL Server.

Tools & Technologies:

MS-Access 2007, MS-Excel 2007, VBA, T-SQL, MS-SQL Server 2005, ERWin 7.2, MS Project

US Bancorp - Minneapolis, MN Sep 2009 – May 2010

Excel/Access Developer

US Bancorp is one the nation’s largest foremost financial and banking institution. The project involved providing level 2 application support for Production Services, triage and issue resolution along with creating, managing and ensuring adherence to application governance requirements

Responsibilities:

●Created Front end screens with user validations for new version of excel using the ribbon formats where add-ins had to be modified to use the ribbon for smooth operation

●Performed upgrade tasks like compatibility checks and error analysis and write fixes if required in VBA module codes

●Wrote macros for excel and/or access as needed through user meetings for various reports or data applications

●Worked with Pivot tables for the summarized reports for Excel and Access data.

●Performed data cleanup and write code for transfer jobs for archive and storage. This required writing stored procedures, and creating or working with views.

●Automated graphical financial reports using Excel Graphics and VBA which could be accessed via buttons and/or ribbon tabs

●Worked with large data sets in excel and sql server

●Provided support and maintenance and also perform regular backups

●Performed version release when required

●Worked with UAT users to see that functions are working as designed when migrating to newer version

Tools & Technologies:

MS Excel 2007, VBA, TSQL, MS Access 2007, SQL Server 2005

Destination Hotels & Resorts – Olympic Valley, CA Dec 2005 – Jun 2007

Excel Developer

Destination Hotels & Resorts is the fifth largest hospitality management company in the country. It is an exceptional collection of resorts and hotels the spans the nations. The project involved maintaining as well as creating custom functions including advanced formulas, vba module code, screen design, pivot tables and reports for business users.

Responsibilities:

●Created Front end screens with user validations in VBA, Excel.

●Managed data transfer feed from multiple source file and integrate them into a single reporting entity

●Checked data integrity and perform necessary service to manage processing times

●Designed and create database tables and forms in MS Access for multiple users

●Developed modules to export the data from access and central database to excel for creating charts and graphs

●Generated audit reports to track jobs and errors

●Generated forecasts for sales, cost component breakdowns in lieu with decision makers

●Managed regular archival and backup processes for both data and applications

●Wrote queries and macros for reporting needs

●Worked on Pivot tables for the summarized reports of Excel and Access data

●Provided any necessary support when issues arise or even teach users on usage

Tools & Technologies:

MS Excel 2003, VBA (Visual Basic for Applications), PLSQL, MS Access 2003

Contact this candidate