• Developed Microsoft Access Application to retrieve data from Oracle Identity Analytics database and produce Macro enhanced Excel Files used for Periodic Application Access Reviews• Performed data accuracy and quality assurance testing on VBA Applications built.• Used Microsoft Excel, Access, and 3rd party data software programs such as Rapid SQL and Toad Data Point to analyze data related to Identity and Access Management.• Analyzed data integrity and performance metrics of Applications Access Management, Access Request, and Incident Management Systems.• Built automated Microsoft Office based dashboards to display performance metrics surrounding access management and access related incidents• Wrote SQL Queries to mine and analyze data retrieved from SQL Server database and Oracle databases• Developed thorough understanding of Role based Access Management, as well as the systems used to manage and review access.

• Converting MS Access Application to a Windows Forms Application and transitioning the database to MS SQL Server, using MS Visual Studio 2015 and MS SQL Server 2008 R2.• Built an E-Commerce Database with Microsoft Access and VBA to extract data from multiple sources and producuce upload files for multiple E-Commerce Channels• Prepared MS Access Database for conversion to VB Application to run on SQL Server• Programmed VB Script to upload flat file data to SQL Server and produce record level import error reports• Created Customer Marketing list using specified criteria• Designed reports on E-Commerce website for sales, and product information using SQL on Magnaverse Platform• Developed Excel based VB Project to extract Website Data and produce parameter based reporting• Wrote SQL Queries in MySQL, Oracle, and Teradata for as needed reporting an analyses• Developed and produced weekly executive sales reports

• Developed a MS Access database to replace an existing cost accounting system during system transition• Gathered business requirements and developed project plan and application workflow• Worked with business and software stakeholders to design import and export specifications to allow for timed import/export processes• Wrote VBA functions to calculate and store moving average prices on an daily bases for variance validation and audit tracking• Built interface for adjustments as well as spreadsheet templates bulk cost adjustments• Integrated MS Access with Outlook for e-mailed attachment uploads, reporting and notifications• Wrote SQL queries and VBA functions to report cost of goods sold and provided accounting with reporting extracts to book cost adjustments to their general ledger.• Worked with accounting department to test outputs and cost accounting calculations

• Designed and programmed MS Access Applications using proprietary coding standards and specifications provided by management• Programmed an Application Inventory System to centralize the documentation of applications and their components• Designed an automatic audit of code changes and created a notation system for application reviews and issue reporting• Obtained specifications for designing forms and writing VBA procedures and functions to automate workflow into a centralized database

MIS Analyst I (Feb 2012 to Dec 2013)• Utilized SQL, SAS, and MS Office to query data and provide analytic support for executive management• Utilized correlation and regression analysis’, in addition to pattern recognition to develop and present staffing forecasts in MS Excel• Designed MS Access based application through every stage of the development lifecycle to facilitate production tracking and increase efficiency with automated data imports and on demand MS Excel reporting• Transformed large data extractions to a presentable tables and meaningful reports using MS Excel’s lookup, sumif, countif and other functions• Lead on medium to large scale projects involving analytics, business systems, and productionBusiness Consulting Analyst / Information System Operations Officer (Mar 2009 to Jan 2012)• Built Central Operations Database in MS Access to facilitate reporting and track tasks and projects for Credit Department • Created data connections between multiple Databases and MS Excel to enhance efficiency in reporting bring forth a self-service reporting tool for management• Performed user testing for the for Rapid Application Development, documenting and translating user requirements to technical requirements • Created shrinkage reports from exported csv files and used MS Excel to lookup, filter and quantify the data• Liaison between Scheduling Department and Credit Department for proper staffing and optimal performanceCredit Underwriter (Apr 2007 to Feb 2009)• Review consumer credit card applications, credit bureau profiles, and account histories to determine credit worthiness and establish credit limits within granted credit extension authority level• Service customers/merchants regarding the underwriting of new accounts, line increases, reinstatements, and authorization requests, while providing an exceptional customer experience