Mike Holman - Certified Securities Operations Professional

 

,

Mike Holman


Download SHORT Mike Holman Resume


Download LONG Mike Holman Resume


View Mike Holman's profile on LinkedIn

 

Cover Letter

 

Named by The Root Magazine as one of The Seventeen Black Internet Pioneers http://theroot.com),  my name is Mike Holman http://mikeholman.com/

I am more than happy to share my experience in the Custody space within Financial Services handling products such as Trade Settlement, Cash, Corporate Actions, income & more for years. 

I have uncovered inconsistencies within the TBA (whose underlying securities are Mortgages) Reporting market. FINRA/SEC has passed a ruling allowing for greater transparency (the heart of Dodd Frank). More info is at my sites http://mikeholman.info/ , http://tbasecurity.info/ and http://mbssecurity.info/

I continue my work with further involvement in the Regulatory space using BI Tools such as Business Objects WEBI used by Social Solutions in their Efforts To Outcome ( ETO ) Application, MicroStrategy and QlikView. I am a Global Knowledge Certified Professional Business Analyst, Institute of Certified Bankers Certified Securities Operations Professional, New York State Teachers Assistant and trained New York State Security Officer. Of special note is that in the way of Information Security Governance, Risk and Compliance, I have used RSA Archer eGRC with Administration Access.

 I have been on the phone with clients in Asia Pacific, Europe, South Africa, Western Hemisphere and Latin America at all hours to ensure timely settlement of trades in a Middle Office role as a Liaison between the Client and the Support Areas globally. Continuing my passion for Technology, I have worked within the Network space with VLAN and VOIP to further enhance the customer experience having a degree in Technology Systems from Pace University.

Having a foundation in running my own Communities (SharePoint, Bulletin Board Systems, Commercial Online Services from the then CompuServe and Microsoft Network to the now Facebook, Google Blogger, Twitter, Drupal and WordPress), helped me build and contribute to these Communities within the Enterprise.

 

Sincerely,

 

Michael Holman

 

 Resume

 

WALL STREET AND TECHNOLOGY PROFESSION

 

EDUCATION

 

Bachelor of Science degree, Professional Technology Studies - Internet E-Commerce                                         

 

PACE UNIVERSITY, Seidenberg School of Computer Science and Information Systems                            New York, NY

 

Associate of Science degree - Technology Systems                                                                                                 

 

PACE UNIVERSITY, Seidenberg School of Computer Science and Information Systems                            New York, NY

 

Global Knowledge Training: Project Management Fundamentals, Business Analysis Essentials, Business Process Analysis, Requirements Development, Documentation, and Management for IIBA CBAP and PMP via BABOK PMBOK

 

PROFESSIONAL EXPERIENCE

Marketing and Sales - Operations Analyst                                                                                                                          CCA Consultant at PricewaterhouseCoopers, New York, NY                                       September 2016 to Present

 

·       Downloaded Master Work Breakdown Structure (WBS) data from SQL Callidus online Database and imported data into MS Access Database. Ran queries for Table updates. Imported new XLos WBS Code data into MS Access Database. Exported results to MS Excel formatting data and importing new data into SQL Database.

·       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

 

 

Data Analyst (Contract)                                                                                                    October 2015 to September 2016

1199SEIU, New York, NY

·       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.

Global System Administrator (Contract)                                                                            February 2015 to October 2015

Colgate Palmolive, New York, NY

·       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.

Analyst (Contract)                                                                                                            September 2014 to January 2015

Related Companies, New York, NY

·       Within the Accounting Group assisted with Financial Planning and Analysis ( FP&A ) Data Analysis projects using MS Excel Pivot Tables and VLookups to create Consolidated Reports for  Travel and Expense (T&E), Telecom, Inventory and Human Resource Management. Studied System training module inclusive of testing for JD Edwards EnterpriseOne system (JDE) which serves as the firm’s Global Customer Relationship Management System (CRM) for contacts, Journal Entries, HR, Accounts Receivable and Accounts Payable. Performed analysis on Real Estate Vendor Waivers for various Projects and Billing amounts to verify payments made.  Performed Analysis relative to Related Entity Names and Levels within the organization to maintain consistency with Human Resource database. Performed Analysis related to Telecom Carriers 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  and Internal Billing System (Tenrox) for Domestic and Global to ensure accuracy with Currency Foreign Exchange Rates received from Vendor  vs average market currency rates.

Senior Data Analyst (Contract)                                                                                              January 2014 to August 2014

Citigroup, New York, NY

·       Within Regulatory Reporting within the Derivatives space, as The Project Lead, 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. Used MS Excel to create Derivative Sub Instrument Reports via Pivot Tables and VLookups. . 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. 

 

 

Desktop Support and Facilities Administration, (Contract)                                               August 2013 to January 2014

Emerge212, New York, NY

·       Created MS Excel BandWidth Usage Reports using Pivot Tables to determine appropriate usage by Tenants. Efficiently handled logistics and coordination for the Emerge212 Centers, as it relates to all aspects of technical and network (Virtual Local Area Network / VLAN / Routed IP / Public IP (Router On A Stick) /  Voice Over Internet Protocal / VOIP, Voice Portal / Self Provisioning / Voicemail / Hunt Groups / Voicemail via Email )  functionality/ support via the use of the fully Automated and Advanced Systems of the key Vendor WUN Systems. Simultaneously supported  the Emerge212 infrastructure as well as ensure that all systems for both tenants of Emerge212 are running smoothly.

 

 

Business Analyst, (Contract)                                                                                                         July 2013 to July 2013

SONY, 550 Madison Avenue New York, NY

·       As an RSA Archer eGRC Admin, setup new users. Using MS Excel VLookups and Pivot Tables, created as well as Uploaded Processes, Sub Processes, Controls and Questionnaires. Worked on Migration from Legacy Socrates System to the New RSA Archer eGRC Platform, comparing data in the Legacy System to the New Systems for Accuracy, reporting back to Manager.

 

Student                                                                                       :                                            March 2012 to June 2013 

Global Knowledge Training, New York, NY                                                                            

·       Coursework in: Business Analysis Essentials, Business Process Analysis, Requirements Development, Documentation, and Management and Project Management Fundamentals

 

Business Data Analyst (Contract) (Work moved to Mumbai, India),                                     April 2011 to February 2012

JP Morgan – Treasury & Securities Services (TSS), New York, NY

·       As The Project Lead, Built MS SharePoint sites and sub sites for Global Collaboration (Files, Calendars, Messaging, etc.) of Work with User Administration responsibilities.

·       Creation of various SharePoint Sites, Data Population and User Access Management

·       Daily using Business Objects Enterprise Data warehouse, MS Excel, Pivots Tables, etc. across Trade, Cash, Corporate Actions, Income and Securities Lending product lines, personally identified gaps in Security Identification of TBA Securities causing incorrect data to be reported for years to numerous large client across various sectors. The correction will result in more accurate reporting by teams in Mumbai and New York.

Finance and Accounting Analyst, (Contract)                                                                          June 2010 to April 2011

JP Morgan – Investment Bank, New York, NY

·       Assisted Business Management for the Investment Bank's Finance and Business Management Group in reporting on Prime Brokerage/Equity Finance, Broker Dealer Services, Global Futures & Options and OTC Clearing lines of business as it related to Business Cases, Headcount Productivity, Booking of Project Time/Expense, Open/Closed Requisitions and Yearly Plan Reporting bringing report such as the Missing Time Report from 50% to 100% efficiency to accurately account of time and expense using Business Objects Enterprise Data warehouse Reports.

Student                                                                                                                                     January 2010 to May 2010 

Global Knowledge Training, New York, NY                                                                    

·       Coursework in: Business Analysis Essentials, Business Process Analysis, Requirements Development, Documentation, and Management and Project Management Fundamentals

 

Business Data Analyst, (3 Month Contract)                                                                    October 2009 to December 2009

Morgan Stanley New York, New York, NY

·       As part of the Enterprise Services Business Unit, reviewed the exported Vendor Invoice Data Files created using Business Objects XI R3 Enterprise Data warehouse and further created MS Excel Pivot Tables and VLookups to validate Vendor invoices against the firms Web based Vendor Management System confirming accuracy of category expenses to mitigate firmwide Risk. Assisted in decreasing Risk Levels by Fifty Percent

·       Liaised with Sourcing Reps to confirm Business Unit Owners, to determine appropriate risk level to firm as part of the Preliminary Risk Assessment. Successfully categorized over One Thousand Items.

 

Student                                                                                       :                                          May 2009 to September 2009 

Global Knowledge Training, New York, NY                                                                    

·       Coursework in: Business Analysis Essentials, Business Process Analysis, Requirements Development, Documentation, and Management and Project Management Fundamentals

                                                                                         

Operations Risk Technical Analyst, (3 Month Contract)                                                        February 2009 to April 2009

The Federal Home Loan Bank of New York, New York, NY

·        Participated in FHLBNY process reviews relative to security identifier systems issues with Money Market, Derivatives, Repos, Fixed Income, Equity, Municipal Bond and Securities Lending

·        Completed the Business Objects Data Insight Training offered by SAP for the Operations Risk Team to ensure various department data was accurate when compared against business rules and was included in the overall Data Quality Methodology. This assisted in Risk Assessment relative to integrity of customer data.

·        Improved efficiency by decreasing Ops Risk Team processing time by Fifty Percent using MS Excel defined names along with pivot tables of Business Objects XI R2 Enterprise Data warehouse User Activity Reports from weeks to hours

 

Strategy Support Specialist and Senior Coverage Officer (Full Time)                                 June 2006 to January 2009

JP Morgan, New York, NY

·       Built Lotus Notes QuickPlace (succeeded by MS SharePoint) sites for Global Collaboration (Files, Calendars, Messaging, etc.) of Work with User Administration responsibilities.

·       Liaison between the internal business groups and technology product teams to meet requirements.

·       Responsible for overseeing timely GL, Trade Finance Settlement, Cash Settlement, Income, Corporate Actions events of Fixed Income, Equity, Money Market Deposits, Derivatives, Repos, Municipal Bonds products and Securities Lending

·       Reduced processing time for the Finance and Market Products Securities Lending using MS Excel Pivot Tables, VLookups and MS PowerPoint reports by Seventy Five Percent going from days to minutes by implementing Business Objects XI R2 Enterprise in UAT/PROD

Custody Officer (Full Time)                                                                                                              April 2002 to June 2006

The Bank of New York, New York, NY

·        Responsible for overseeing timely Trade Settlement, Cash Settlement, Income, Corporate Actions events of Fixed Income, Equity, Money Market, Derivatives, Repos, Municipal Bonds products and Securities Lending leveraging MS Excel Pivot Tables and VLookups.

·        Enhanced the Client Service Team processing time from weeks to minutes using Crystal Reports GUI for Analysis of STP Client Report Card, allowing for prompt delivery to the client and identification of potential problematic markets

·        Daily monitored Client exposure working with the Compliance Officer to mitigate risk relative domestic and international currency balances and obtaining necessary Credit Officer Approvals as needed.

 

Training Specialist (Full Time)                                                                                     March 2001 to March 2002

Depository Trust and Clearing, New York, NY

 

Delivered Training to the Financial Community, promoting awareness of DTC and NSCC core products. Maintained proficiency in DTC/NSCC core products such as Problem Resolution, Reconciliation, Deposits, Withdrawals, Reorganization (Corporate Actions), Settlement, Dividends, Continuous Net Settlement (CNS) and Automated Customer Account Transfer System (ACATS). Management (CRM) Peregrine Incident Tracking System.

Selected accomplishments:

·       Received company Rewards and Recognition certificate for excellence in handling the project management function of the roll out of the Financial Community Focus Workshop working with project managers. 

·       Received a company Reward and Recognition certificate for participation in a special Task Force that identified and resolved problems in dealing with online (PINS) and Call Center inquiries (logged on Peregine Systems) from the financial community.

 

Training Specialist (Full Time)                                                                                  December 1998 to March 2001

The Bank of New York, New York, NY

Assistant Treasurer and Training Specialist of internal and external customers in the U.S. and Europe on Banks Domestic Operations/Systems (ASP, TAS, FRB, MBS, Money Market, Fixed Income and Government versus Security Master CUSIP information) and Global Operations/Systems (GSP, IMMS and EuroClear versus Security Master ISIN information).

Selected accomplishments:

·       Personally trained the newly acquired Royal Bank Of Scotland/BNYE Group.

·       Designed training program on effectively implementing company’s On Demand Report system designed to improve delivery of historical data information to customers.

·       Designed Microsoft Access 2000 Database to track all participants in the Training Programs and Designed Query Reports for Monthly statistics and Trend Analysis.

 

Assistant Treasurer (Full Time)                                                                                 May 1988 to December 1998

The Bank of New York, New York, NY

Investment Manager Services Dept.

 

·       Served as Global Account Officer. Placed inquiry on Failing Global Currency and Security trades to offices in London and Belgium.  Requested Foreign Exchange transactions as needed. Sent Global Customer daily Reports on Failing Global Trades and Nostro Exceptions. Reported Customer Over limit Exceptions on Global Currency Credit Lines. Corresponded with Customers and Global Operations in New York, London, Brussels and Asia via phone and online Lotus Notes Server and Workstations.

·       Served as an Domestic Account Officer in Investment Manager Services. Investment Liaison between Customers Investment Managers and Bank Administration Run daily Online DTC Reports to confirm broker instructions to customer confirmations. Inform Securities Lending Administrator of customer requests to sell Securities that are on loan, so Administrator can call back the loan. Notify Investment Manager of various Corporate Actions (Called Bonds, Tender Offers, elections, etc.) and receive Investment Manager decision on Participation if needed.  

 

Foreign Exchange Support Dept.

 

·       Supervised Multi-Agreement Processing Unit (MAP) staff. Saved Foreign Exchange Department over $20,000 monthly through Process FX Automation, saving time by eliminating the need to use manual tickets as items were processed directly on the system.  Designed Global Trading Flow Charts with work flows for various departments outlining flow of work from Trading Front office system to Back Office main frame operations system. Compared System Specification of SWIFT transmissions to actually system-generated transactions received.  Processed Foreign Exchange Transactions. Handled FX confirmations via phone and Reuters. Checked customer FX Credit Limits. Processed Foreign Exchange Options, Swaps, Spot, forward, and Compensation deals. Processed transactions relating to Offshore Funding and Grand Cayman. Process funds Transfer transactions. Processed all transactions using CICS mainframe as well as Client/Server. Monitored System Status on VAX/MBX Terminal


 

 

Mike Holman - Certified Professional Business Analyst 

 

 

 

CLICK HERE TO SEE ALL MY GLOBAL KNOWLEDGE COMPLETED CERTIFICATES