SUMMARY:

• Over 10 years of experience as Excel/Access VBA Developer and Business Analyst, with IT and Financial.
• Involved in gathering business requirements and created user and technical documentation.
• Helped in JAD sessions with end users, designers, developers, QA and project management to gather requirements and identify critical high - risk areas.
• Excellent experience in the areas of Design, Analysis and Development of Software Applications using Access and Excel VBA.
• Tremendous experience in tuning the MS Excel, Access queries and the database.
• Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies
• Facilitated new releases into production and provide production support services for the Blue Prism RPA Application.
• High visibility as liaison between the business line, users and the development teams throughout the project cycle.
• Worked intimately with business domain to gain full knowledge of the flow of the flow of business.
• Scheduled JAD sessions with impacted team members.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
• Familiarity with Salesforce in an administrative capacity
• Knowledge, or ability to learn, writing basic scripts using SQL.
• Expert in handling errors and validating user data using VBA.
• Gather, organize and analyze data for loan approval including property economics, borrower/sponsors, location, current market rents/vacancy and leasing. This includes keeping checklists for the loan approval due diligence items up to date.
• Responsible for providing support and creation of support tickets to large Mortgage applications such as REO, Bankruptcy, Foreclosure, Home Retention, and Tax Support, as well as Claims and Customer Correspondence Relations Systems.
• Responsible for design authority for new task automations being implemented.
• Extensive experience in Data Mapping, Data Analysis, Data Cleansing.
• Solid background in table/query design, report design, and automation utilizing VBA modules.
• Extensive experience in developing, maintaining and testing, class modules using MS Access.
• Excellent team player with extraordinary analytical, strategic planning, interpersonal and communication skills. Highly motivated, enthusiastic and self-starter with exceptional ability to perform individually.
• Pull various data elements of the mortgage from the Servicing System and identify any gaps in the hand-offs between Loss Mitigation, Bankruptcy, Collections and Foreclosure which would delay the final disposition of the property and increase risk of loss and turn any gaps into projects.
• Strong leadership skills working with executive management, technical architects and business end-users working through change management and new technology deployments.

TECHNICAL SKILLS:

• MS-Excel- 2016/2013/2010 /2007
• MS-Access- 2016/2013/2010 /2007
• Blue Prism Robotic Process Automation Software
• Foxtrot
• CenBase Reporting Tool
• Black Knight Financial Services
• Loan Sphere Invoicing
• SharePoint Ticketing System
• Tableau 8.0.1 Desktop
• Teradata 13.10.0.05
• E-Views and Yield book
• SQL Server 2008/2005
• Crystal Reports 8.5/11
• SAP Business Objects BI Platform 14.1.7.1933
• Oracle 10g
• Oracle 11i Financing
• Tally 7.2/8.1
• MS SharePoint
• Salesforce Edition- Enterprise.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Business Analyst/RPA Controller

Responsibilities:

• Collaborated with department managers to determine functionality requirements, resolve data quality issues and improve the quality of source data.
• Received system information from Business Analyst II’s to improve efficiency and accuracy of processes.
• Used work policies and procedures to correct system errors.
• Assisted team members with training on new work process.
• Analyzed and defined data requirements, specifications procedures, planned for and anticipated changes in data capacity requirements and evaluated new technologies and architectures.
• Monitor and manage Bots and automated processes.
• Provide RPA support or technical support services typically in a defined moderately complex project.
• Maintain/update documentation of RPA processes and Platform management.
• Coordinated support releases and testing of automated RPA Processes. Maintain Controller Schedule.
• Involved in complete software development lifecycle experience (SDLS) from business analysis to development, testing, deployment and documentation.
• Assisted in designing, planning and managing the data migration process.
• Created test data, analyzed test data, and help upload the true data for a new user-friendly Tax database with the goal of reducing the managers time to review productivity of associates on a Daily/Weekly/Monthly basis.
• Assisted in creating various dashboard per requirement of the user and business need using Salesforce interface.
• Conducted requirement gathering session with users, facilitate the requirement validation sessions, work-group meeting session, reach out to users through emails and schedule meetings to gather requirements.
• Performed data migration audit, reconciliation and exception reporting.
• Responsible for testing 300+ forms and correspondence which includes triggering each from various business process in the LOB application, validating the content based on the design documents, and working with a team to track and resolve defects.
• Worked across multiple functional projects to understand data usage and implications for data migration.
• 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 Excel/Access/VBA.
• Participated in the technical production support rotation.
• Prepared data migration plans including migration risk, milestones, quality and business sign-off details.
• Worked on solving Service Now tickets related to MS Access, MS Excel VBA issues.
• Created Knowledge Based articles for the issues resolved for future reference for team members.
• Performed migration and testing of static data and transaction data from one core system to another.

Environment: MS-EXCEL- 2016/2013/2010, Excel/VBA, Business Objects, Blue Prism Software (Version 6.1.0 and 6.3), Foxtrot (Version 11.0.6), Visual Basic MS-ACCESS- 2016/2013/2010, Access/VBA, SharePoint Ticketing, Service Now, Tableau 8.0.1 Desktop, Teradata SQL Assistant, IBM Notes 9, PeopleSoft, Notepad ++, Microsoft Visio Standard, Snagit 11 Editor.

Confidential, Ewing, NJ

Data Analyst

Responsibilities:

• Execute ad-hoc reports for management to support critical business decision-making processes to improve departmental efficiencies.
• Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data.
• Optimization of existing macros and creating new standalone macro-books to improve report run-times.
• Conducted GAP analysis by identifying the strategic objectives.
• Assisted QC team to ensure requirements are translated into executable Test Plans and strategies.
• Created Access databases designed to import data from CenBase Portal (Internal System) and automated report run times based on individual report schedules and client demands. Also consolidated data in Access database with the help of forms, Visual Basic and database relationships.
• Remediated slow Excel Macro tools by converting them into Object Oriented Programs and removing slow loop code and replacing it with arrays to range allocations. Influenced other programmers to use similar methods to write faster Macros.
• Completed Access Database, restructured and performed troubleshooting of the VBA code.
• Extensive experience in designing templates, user forms, user defined functions and creating and using add-ins.
• Used advanced MS Excel to create pivot tables, used VLOOKUP and other advanced excel functions.
• Strong record for delivering on IT and Non-IT projects for Home Lending / Mortgage Banking, including process improvement, strategic projects, audit / risk projects, modification solicitation programs, and reporting requirements with agile methodology.
• Competent in loading data from multiple data sources into Excel Reports using Excel VBA.
• Managed change requests received from the business and to ensure the releases of new functionality.
• Responsible to perform migration of old reporting system to the new standards specified by the company with the help of Excel VBA Macros.
• Utilized SQL queries to access data stored in the database for analysis and data cleansing
• Perform Data Analysis, Data Profiling, Data Validation and Data Quality using SQL queries
• Created requirement details documentation, implementation documentation, user acceptance testing documentation, support documentation, user manuals and technical documentation throughout the application development.
• Supported data governance, integrity, quality and audit functions.
• Creation and Maintenance of the SharePoint Ticketing System.

Environment: MS-EXCEL- 2016/2013/2010 /2007, Excel/VBA, Business Objects, Visual Basic MS-ACCESS- 2016/2013/2010 /2007, Access/VBA, SharePoint Ticketing, Cenbase Reporting Tool, Black Knight Financial Services, Loan Sphere Invoicing, SharePoint Ticketing System, Tableau 8.0.1 Desktop.

Confidential, Bedminster, NJ

Business Analyst

Responsibilities:

• Gathered business requirements from key executives and senior management level decision makers to create customized data analytics tools and report generation.
• Prepared a detailed roadmap and analyzed impact of the new processes on Confidential & Confidential ’s business verticals.
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Analyzed the logic and syntax of existing code. Ensure timely delivery of projects and within budget.
• Utilized agile methodology to configure and develop process standards and procedures.
• Developed user-defined functions, menu bars, forms, add-ins, etc. used for daily tasks.
• Implemented security features in Access application by creating security modules using VBA.
• Created Stored Procedures in SQL Server to import data using VBA from SQL Server to Access and Excel.
• Designed and Created Report templates, bar graphs and pie charts based on the financial data using Tableau.
• Assisted in creating various reports (summary reports, matrix reports, pie charts and dashboards) and report folders to assist managers to better utilize Salesforce.
• Generate comprehensive reports annually for review by the executive team.
• Created an automated process within MS-Access to generate weekly, monthly and quarterly reports.
• Leading various projects involving Data Cleansing, Data Mining and Data Analysis skills, and creating meaningful reports out of the same to support the decision-making process.

Environment: MS-Excel 2010 & 2013, Excel/VBA, MS-Access 2010 & 2013, Access/VBA, SQL Server 2008, Visual Studio 2008, SharePoint, Crystal Reports, SAP Business Objects 14.0, Teradata SQL Assistant, Salesforce Edition- Enterprise.

Confidential, NY, NY

Data Analyst

Responsibilities:

• Gathered requirements regarding the metrics, calculations and style of the templates.
• Provided in depth analysis of potential investments, acquisitions or divestures as they relate to corporate financial objectives.
• Conducted profitability analysis/reporting through complex calculations in Excel and VBA.
• Created templates for the financial statement analysis and pivot tables/charts for sales analysis using Excel and VBA.
• Extensive experience in designing templates, working with pivot tables, graphs, user forms, user defined functions and creating and using add-ins.
• Ensured data integrity by validating information obtained from fund/product administration systems using a variety of available resources.
• The interconnection between finance and software systems in the preparation and completion of the annual budget, quarterly forecasts and monthly actual performance.
• Acted as both a user and developer of applications created in Excel and/or Access to prepare timely and accurate sales performance, analytical and reporting on both a periodic and an ad hoc basis.
• Performed statistical analysis on data to evaluate and isolate the critical factors influencing trends and relationships of variables to drive improved results.
• Implemented standard operating process (SOPs) after process automation.

Environment: MS-Excel 2007, Excel/VBA, MS-Access 2007, Access/VBA, SQL Server 2008, Visual Studio 2008, SharePoint, Crystal Reports, Oracle 10g, Oracle 11i Financing.

Confidential

Excel/Access/VBA Developer

Responsibilities:

• Developed Access databases, working with excel that reconciled Accounts, provided analytical support including development of a reconciliation database allowing users to perform automatic and manual reconciliation.
• Supported departmental goals of minimizing revenue leakage from daily operations and report findings to departmental managers through the development of new databases and the enhancement of existing ones.
• Implemented security features in Access application by creating security modules using VBA.
• Strong track record meeting the customer’s information system needs by providing on time, on budget, and on the mark information system solutions in team and independent environments.
• Extensively involved in VBA code modification / module testing for incompatible code in new VBA object model.
• Administered departmental MS Access databases including establishing workgroup security.
• Enhanced the customer service to track payments to suppliers by modifying the existing Access database so that users could quickly reconcile invoice payments.
• Provided users the ability to lookup claims, properly disposition them, and have the updated data immediately available to Customer Services.
• Supported company’s Customer Services departmental goals of tracking and resolving supplier claims by redesigning existing price variance and supplier databases by converting all macros into VBA code and adding error trapping.

Environment: MS-Access-2003/2000, Access/VBA, MS-Excel-2003/2000, Excel/VBA, SQL Server 2000, MS-Office Suite, Tally 7.2/8.1