SUMMARY

• Dynamic and skilled VBA developer with experience in Project Management / Business Systems Analysis /IT SOX Auditing and data capture in support of forensic and ligation activities with expertise in all aspects of systems development life cycle SDLC . Exceptional technical, communication and business skills with experience in application development, analysis and customer interface. Deliver mission-critical automated solutions by leading project teams and ensuring that development and QA teams implement system on time.
• Project Manager: Managed projects from 50k to 6MM with teams from 1 to 45 using MS Project.
• Business Requirements: Document existing business issues and processes. Liaise with customer to create clear understanding of business needs to be automated and enhanced.
• Data Modeling: Create conceptual and logical models that illustrate the data flows needed to support the business. The models serve as the foundation for development of operational databases.
• Problem Analysis: Identify core issues and identify opportunities for improvement in workflow processes and data quality.
• Customer Focus: Facilitate meetings and interface regularly with customer to ensure that all issues are understood and business needs are achieved.
• User Training and Technical Writing: Deliver post-implementation training and high-quality documentation of system.
• End User Tool Development: Develop automated solutions to address client needs. Created P L 'What If' application comparing LOB/ROB -in Access/VBA using 10 external feeds apportioning the expense and profit lines at product level for three business units.

PROFESSIONAL EXPERIENCE

Confidential

Sr. IT Auditor/Project Manager

• Data Analysis of Accounts Payable AP and Accounts Receivable AR , for duplicate payments, Purchasing to payments, open or dues for deficiencies, etc. HR compensation analysis and reporting.
• Duplicate detection for payments, invoices, transactions and vendor returns for credit.
• MetLife, Integrate:
• Project initiation complete that included the assessment of the experience achieved from the prototype lessons learned .
• New requirements from the user community corporate and 5 remote locations leveraged by the lessons learned document.
• SDLC components created Charter, Business Case to include Total Cost of Ownership, Scope, Team, Project Plan, and Business Requirements.
• Solicited and selected a vendor to supply a hosted web base real time solution.
• Current tasks are data cleansing and quality assurance, development of UAT approach and finalize deployment tasks and responsibilities.
• Hands on data analysis to determine beneficiary payment extensive use of MS Access and Excel to complete complex analysis scenarios.
• Experis Parsippany, NJ, Wyndham, Knight Capital, Revlon and Situs:
• Project plans in support of timely task completion, weekly status reports, solicit requirements from user community, problem/issues resolution.
• IT Internal Audit SDLC, PCI
• SOX 404 Compliance and Testing
• Control Design and Operation Assessment

Confidential

Developer/Analyst

• Global application development with over 25 users in Europe, Asia, Africa, North America.
• Developed Product Sales Forecasting by SKU application for SOD/Sterile product lines MS Access
• Developed an Excel Template to perform Profit Analysis with automated interfaces.
• Extensive use of VBA MS Access/Excel in Access to Excel integration and interface and DB tools Toad.
• MS Access front-end to Oracle 10g back-end to facilitate Global viewing and reporting requirements SQL and Stored Procedures..

Confidential

Analyst/Auditor August

• Assessment of Control Design and Assessment of Control Operation for ITGC, SOX 404 testing.
• Assessment of Application Control and Assessment of Control Operation. Some business processes tested: HRIS Data, AP Permit to Pay, Procurement Duplicate Invoice , Accounts Receivable Market Development Funds, Cash Reconciliations , GL, Interfaces Oracle Financials, SAP, Hyperion , Inventory Reconciliation, Global Enterprise Manufacturing Management System GEMMS, OPM - Oracle Process Manufacturing , Warehouse Management Control System SAP customer order to inventory shipments reconciliation, Returns interface Reconciliation Genco-SAP interface, SAP to PKMS interface, Price Override Reconciliation.

ConfidentialAuditor/Analyst

• Assessment of Control Design and Assessment of Operation
• SAP R3, MS SQL, Active directory, SOP, GxP, Policies/Procedures.
• Identified and resolved SAP password issues via an automated reconciliation procedure.
• Analysis and audit process of SAP transactions SCC4, SE01, SE03, SE09 and SE10 authorization and usage.
• Extensive use of MS Access and Excel in data mining SAP HRIS Data and SOD analysis and reporting.

Confidential

Auditor/Analyst

• Performed and supervised SOX 404 and Remediation testing for Key controls identified in the following domains: IT Operations, IT Change Management, Application Security PeopleSoft, All Other Applications , Operating System Security UNIX, Windows, Open VMS, AS 400, Novell, HP 3000 , Database Security Oracle, All Other Databases , Data Center Physical and Environmental Security, Network Security, Changes to global policies and procedures and Planning and Organization. Audit of the LIMS application to sure unique good laboratory practice or GLP. Performed PeopleSoft HRIS Data Analysis.
• Testing of IT controls to analyze and remediate terminated users with active access to financial applications CODA Financials/Cognos Business Intelligence / IWR / Power Play, PeopleSoft 7.5, 8.9 and 9.0 , PeopleSoft FSA, Timberline, JDEdwards, FAS, and Active Directory using Excel vlookup, Match, Hlookup, offset, list and combo box, index and named cells macros and VBA, Pivot tables, Pivot Charts and MS Access/VBA.

Confidential

IT Consultant Global Infrastructure Support

• Developed a MS Access/Excel VBA application to support the migration to Windows XP, parsed the imported registry data to capture the software and versions installed on over 750 personal computers.
• Managed the Global Deployment of hardware and XP software for the GTS division. Utilized and managed resources in a highly matrixed organization to include on-shore and off-shore technical and business components. The major objective was to maintain a high level of quality with a very limited budget.

Confidential

IT Consultant Technical PMO Function

• Managed multiple projects to ensure compliance with the Sarbanes-Oxley 404 legislative requirements to include strong password compliance and app to app communication. Developed an Access/Excel VBA - ODBC based application to manage weekly status reporting using on-shore and off-shore resources.
• Implemented Microsoft SOX Accelerator built on Microsoft Windows SharePoint Services and Microsoft Office InfoPath 2003 as the administrator used the following functionality web parts, document check-in check-out, events list, announcements list, tasks list, discussion boards and the following processes: Automation and Workflow, Collaboration and Communication, Monitoring and Reporting.
• Utilizing internal and off-shore resources to modify Web based Java, PL SQL, ASP, C , VB, XML, J2EE , Client Server SQL Server, Oracle, Access, Excel , Mainframe CICS, DB2, MVS for eBusiness, HR, Accounting, Payroll, Truecomp, Hyperion, COTS, AR, Marketing and Sales, and Payroll applications.

Confidential

IT Consultant

• Coordinated, managed the definition and developed a Clinical Quality Control MS Database application for the audit department to ensure the fulfillment of Good Clinical Practice GCP methods and policies for the over 265 domestic and international CRO test sites. Facilitated Root Cause Analysis CAPA from audit results. Complex VBA code to report via MS Access of both text and embedded documents.
• Used MS Access/VBA to send system generated e-mails, verify passwords using Spellchecker, manage and report embedded Word and Excel documents.

Confidential

IT Consultant /Service Delivery

• Designed, developed and implemented a multi-step MS Access/VBA error tracking/root cause application for a business critical application across two platforms Mainframe and Server writing automation code VBA for the personal computer based Reflections application. Ensured that invoicing errors were identified and addressed promptly. Automated application to execute a job to extract and transfer data to the workstation from the mainframe executing two MS Access applications to purify data and report critical errors.
• Lead a cross-functional team of fourteen on both technical and functional tasks completing an eighteen-month Customer Service business critical unification project using an SDLC development approach. My team 30 of the resources implemented over 60 of the deliverables.
• Designed EDI Suspense function, purchase order and invoice processing EDI 810, 850, 855, etc .
• Designed and implemented a Vendor Managed Inventory function into the Customer Service department using customer product forecasts. Communicating order delivery and payment to the customer via electronic data interchange. Developed a monitoring MS Access VBA application that resulted in the correction of the configuration of the IBM supplied customer forecasts. Processed daily order volume in excess of 5MM.
• Developed a P L 'What If' application-in Access/VBA using 10 external feeds apportioning the expense and profit lines at product level for three business units. Required the definition and application of rules governing the distribution of the expense and profit lines. P L reporting at either a summary level, by line of business or down to the individual product level within each business.

Confidential

Project Manager/Service Delivery

Initiated a data review process in Access/VBA to mine and analyze multiple state sales tax process. Extracted, analyzed and reported data that returned 1.2MM in overpaid taxes to the client.

Employment:

Confidential

IT Consultant

• Converted 12 MS Access applications form MS Access 2000, 2002 to MS Access 2007 to include an Investment Database. Analyzed and changed existing code to allow for a front-end / back-end split so that the application could more efficiently perform in a multi-user environment. Modified and installed VBA code where applicable.
• Designed and implemented an IT Infrastructure for a Non-profit consisting of configuring 150 work stations. The final infrastructure supported five servers three domains primary and two remote sites using Windows Server 2003 and Active Directory, Microsoft Exchange 2007 and emails, SQL Server 2005, SharePoint 2007 and MS Access 2007. Extensive development in MS Access 2007 in support of the business needs of operations, finance and IT.
• Created three SharePoint site groups to manage proprietary financial data requiring a secured access environment, unique permissions. Used MS Access 2007/VBA/ODBC to SQL Server to verify and populate financial data views from multiple sources, created and housed in MS Access or SAS.
• Developed a generic MS Access/VBA front-end application to automate the IT COBIT ITGI General and Application Controls and application specific controls supporting Internal IT Audits and IT SOX Audits. Included the embedding of evidence as objects. Single front-end used for all clients variation contained as data in each client back-end using a re-link function to migrate between client specific data. Developed an Access/Excel/VBA based application to populate Open Pages application. Imported and normalized data from excel spread sheets.
• Audited, changed and created policies for Internet usage, Electronic Communications, Password policy, Remote Access, Data Backup, Computer Acceptable Use, Wan Network Security, Wireless Network Security, Virtual Private Network VPN , Application Security, Data Classification, Vendor Management, Logical and Physical Access, SDLC, Change Management, Service Level Agreements, End User computing, Incident Management.
• KNBT Bank Audit of SEC SEC Rule 17a-3 and Rule 17a-4 and NASD rules 3010 and 3110 covering data/document security and financial correspondence to the public. WORM technology for e-discovery.
• Completed technology audit to ensure that customer identity technology conformed to acceptable industry and federal standards. Tested the technology security access at each airport and at central facilities using the Federal Information Systems - Standards and Guidelines SP 800-53 issued by the NIST National Institute of Standards and Technology to ensure viability and compliance for on-going operation.

Confidential

Responsible for daily operations of this apparel division using an interactive IVR ordering system, bar code scanning for product selection, integrated UPS label/shipment system to track orders from shipment to delivery. Also developed a MS Access Sales Force reporting and tracking that was used to print IRS 1099 forms.

Confidential

• Responsible for the enhancements and rollout of an enterprise wide apparel Retail Management System.
• Developed, documented and implemented a formal SDLC.
• Initiated and implemented business process improvement for the Mail Order division exceeding sales projections.

TECHNICAL SKILLS

• Server Software: ERP JDE, Stellent, SAP, CSI, PLUS, custom , Salesforce.com, Point of Sale STS, ISD, custom , Peoplesoft, Order Processing, Inventory Control, EDI, Vertex, Visanet, CRM Mozart, custom , Planning DMS , Physical inventories Hart, Contract, Datascan , Accounts Payable, Receivables, Assets.
• Auditing: ACL, OS Security Scripts, GAIT, ITGI, Top Down Risk Based Auditing Standard No. 5 - AS5 Technology Layers Auditing. Open Pages, BWise, MS SOX Accelerator and MARCS.
• Client Software: Lync IM, MS Office Word, Excel, PowerPoint, Access 2.0, 95, 97, 2003, 2007 , MS Project, Lotus123, Lotus Notes, Visio, WordPerfect, Reflections
• Languages: XML, SharePoint, VBA, SQL, VB, Ideal, Cobol, CICS, HTML, File-Aid, Awk, BASIC, SAS, and Scripts
• Operating Systems: Windows Server 2003, Windows 2000/XP, NT, MVS/JCL, TSO, SMS, MQ SERIES, TSO, UNIX, UNIDATA, PICK, IVR, OS/400
• Databases: MS ACCESS, SQL Server 2005, ORACLE, DATACOM, DB2
• Hardware: Windows Servers, IBM Mainframe, AS400, RS/6000, IBM PCs and Compatibles, HP9000
• Network Protocols: VOIP, DSL, TCP/IP, FTP, ISDN, SDS, VPN, FRAME RELAY, and X.25