Mike Holman Email & Phone Number

Garner, Nc, Us

Gb

• Imported Client Relationship Executives Contract information for all Regions into the Lotus Notes Database. Downloaded all open cases for Credit Approval Case Report for the New York Regions. Exported firm Directory from Lotus Notes for review. Performed Review of Google Groups and assigned members for updates as needed. Ran queries on Partners worldwide from the Lotus Notes Database as well as the SQL Callidus Database.• Deleted and/or Inactivated Client Assignments for Cases as needed from the SQL Database. Combined numerous MS Excel Reports into on master file. Ran queries on the SQL and MS Access Database for missing WBS codes. Created MS Excel Macros for various Database reports.• Performed preparation of PCS Statements for Quarterly Review.• Redesigned numerous Global Finance System (GFS) Reports from the old format to the new format online, identifying and reporting differences in new format with WBS Codes summaries versus individual Line Of Service counts• Used SAP BEx Business Objects Explorer built into MSExcel to create reports and eliminate Line Of Services differences. Business Explorer allowed for number task to be done efficiently all with MS Excel exclusively• Monitored Message Transmissions of the On Demand Integrator (ODI) of data data which uses Oracle, Informatica, FTP and SSH from Callidus to the Global Finance System (GFS)• Maintained the Marketing & Sales Ops Data & Reporting Table of Contents on Google Drive with Links to documents• Completed tasks on the Global Portal project and decreased time by converting two very large MS Excel files, which combined exceeded the application limits, into one MS Access Database performing MS Access queries as needed

Washington, Dc, Us

• Analyzed Data on various Campaigns by building an MS Access Database to run Queries via SQL/VBA and Reports for data counts and complete information on Registered and Non Registered Health Care Workers along with full contact information for each worker. Maintained a database for each Agency who employed these workers with their contact information. Imported NPI Data info into created MySQL Database at http://www.npi-db.info/db for further review of all NY Data versus data already within the MS Access Database. Used NPG VAN to setup users, import bulk report and run analysis on Agency and Worker data

New York, New York, Us

Administered Consumer Relationship Management for the Global Consumer Response System (Global CRS) which captures Consumer feedback via Social Media (Facebook, Twitter, LinkedIn, etc.), Web Contact Us Page, Phone, Chat and Email within Global Consumer Affairs provided by the Vendor Of choice, Wilke Global, along with related Security and Master Data Management processes to ensure optimization for the Global users. Personally processed over nine hundred and seventy five Metadata Change Request (MCR) updates to Global CRS to correct data related to the Global Users in Latin America and other Regions. Helped ensure validation fitness of Global CRS worldwide while assisting with the expansion of technical capabilities. Assisted the Technology Analyst with delivering process and workflow improvements. Helped fulfill ad-hoc and validated reporting requirements such as the Monthly Sales Module Reporting with comparison of Database existing Products to the same Products produced by the SAP program. Obtained membership within the Society of Consumer Affairs Professionals (SOCAP) to keep abreast of the latest trends within the Consumer Affairs Community.

New York, Ny, Us

Within the Accounting Group assisted with Financial Planning and Analysis ( FP&A ) Data Analysis projects. . Performed analysis on Real Estate Vendor Waivers for various Projects and billing amounts to verify payments made. Performed Telecom Performed Analysis relative to Resources firm wide, Employee Type, Related Entity Names and Levels within the organization to maintain consistency with Human Resource database. Performed Analysis related to Telecom Carriers (Verizon and AT&T) statements to analyze billing usage firm wide to maintain accuracy with Vendor Billing and Internal Consolidated Billing.. Performed Travel and Expense Analysis related to Credit Card Vendor (American Express) and Internal Billing System (Tenrox) for Domestic and Global to ensure accuracy with currency rates received from Vendor vs average market Currency Foreign Exchange Rates. Performed Inventory Analysis on Products orders from suppliers (OfficeMax, etc.) to compare how often ordered and how many ordered firm wide and noted any inconsistencies. Studied System training module inclusive of testing for JD Edwards EnterpriseOne system (JDE)..

New York, New York, Us

Within Regulatory Reporting within the Derivatives space created from the ground up a SharePoint Site for utilization by the Risk and Finance Teams for review of Notional Analysis surrounding various Product Processor systems as Oasys, S2, RRAI, Treasury, etc using Business Intelligence tools such as QlikView, Business Objects and MicroStrategy. Provided strategic and tactical support to the organization by analyzing and interpreting the data to provide creative solutions. Performed data analysis with regard to client requests and developed rules and methodologies for effective data management. Assured the integrity of project data, including data extraction, storage, manipulation, processing and analysis. Collected and collated appropriate data for usage in databases and conducted related research. Discussed business intelligence needs or information with external clients and internal staff. Participated in ongoing decisions concerning data collections, study design, methodology, and data analysis. Contributed to firms Collaborate Intranet Website with Blog Posts.

As, Technology Systems

Pre-Law Studies

Certification, Professional Business Analyst

Bs, Professional Technology Studies/Internet E-Commerce

New York State Security Officer, Security