SUMMARY:

• Project Professional in the Financial and IT Domains with over 25 years’ experience in the investment industry and other various industries. Solutions driven
• Business Analyst/ Project Coordinator with experience leading cross functional teams in the development, documentation and delivery of process innovations driving the attainment of business calls.
• Experienced working with multiple trading platforms and database management, accounting and reporting platforms and proprietary programs.
• Excellent interpersonal and organizational skills able to multitask and set priorities to maximize potential. Strong strategic planning and project management competencies with focus on achieving deadlines and highest quality output.
• Effectively coordinated projects across multiple internal and external client organizations resulting in significant process improvement
• Collaborated with technical, product and business teams to implement programs and achieve their goals
• Expert in Business Delivery and Operational Effectiveness able to provide ongoing, timely, and accurate analysis of monthly financial results to support month - end and quarter-end close processes
• Experienced in developing requirements and functional specifications to a high standard, documenting the same and translating business requirements into detailed functional specifications (i.e. design the functionality of a system). Drove numerous small to large, complex projects that require increased skill in business modeling and requirements definition. Possess lending industry domain knowledge.

TECHNICAL SKILLS:

• Active Directories(AD), Advanced Excel (Macros, PowerPivot, VLOOKUP’s)
• Advent, ADP, ADT, AFS, Agile, AS400, Axys, Bank Trade, Beta, Blackline
• Bloomberg, Bottomline, Brokers Ally, CMDB, Crystal Reports
• Document Direct, DTC, EAF, FIS, Fiserve
• Goldmine 5.0, Hyperion, ILX, Intacct iMatch, ISO 27000 Series, ITSM, JetWeb
• Market Axess, Market Manager
• MS Dynamics GP, MicroHedge
• Midas, Moxy, MS Project, Nexonia
• NextGen, Oasys, Omega, Orion, Pac2000, Paxus, Pershing, Peoplesoft
• Planview Enterprise, Portfolio Genius, PN3, Portia, PST, QuickBooks
• Reflection3270, Replicon, Sage MAS 500, SAP Vendor Management
• SAS Financial Management, SAS70 /SSAE16, SAI Global DM360
• Scrum, SharePoint, ServiceNow, SIS, SPSS, SQL2005 Queries
• SWIFT, Thompson Reuters, TLM, TPG Software, Trade NAS

PROFESSIONAL EXPERIENCE:

Confidential - Lake Forest, IL

Information Systems Business Analyst

Responsibilities:

• Actively participated in all phases of the testing lifecycle and performs unit system and integrated testing tasks and activities
• Conducted system build integration of AD & CMBD troubleshooting and configuration updates
• Defined configuration specifications and business analysis requirements
• Owned and developed relationships with partners, working with them to optimize and enhance our integration
• Developed a comprehensive standard operating procedure guide using MS Visio and business process mapping best practices
• Created and maintained regular status reports, provided verbal and written status to project managers and senior leadership

Confidential - Lake Bluff, IL

Information Systems Business Analyst

Responsibilities:

• Business and Technology Services (BTS) is responsible for maintaining the data integrity relating to servers in the Configuration Management Database (CMDB) Validated and recorded an ITSM ticket for CMDB updates
• Tasked with following up with hundreds of “server owners” to validate data within Abbotts CMDB
• Responses recorded in a mass import spreadsheet and attached to an ITSM ticket for CMDB updates
• KPI’s tracked and progress reported to Sr. Leadership

Confidential, Rosemont, IL

Sr. Consultant Treasury Management Migration

Responsibilities:

• Provided Cash Management, product and industry expertise to the organization with a primary focus on supporting Implementation of ACI commercial online business platform
• Accountable for 200 Commercial (Middle Market) online banking clients, researching Treasury Management product portfolios, confirming entitlements and liaising with internal business units to identify unique requirements

Confidential - Waukegan, IL

Financial Analyst - Foundation Processes Contractor - SAP Vendor

Responsibilities:

• Instrumental in the development, identification, and implementation of system modifications to improve productivity regarding vendor set-up, monitoring VMD system performance, and tax form collection and coding
• VMD systems/tax analyst worked closely with Tax, Accounts Payable, IT, and Purchasing to maintain accurate and appropriate tax documentation, and monitor performance/compliance in conjunction with Tax department
• Provided direct support for projects, daily business activities, and supports the VMD team, including providing specialized technical and business knowledge regarding US tax form collection and tax code assignment

Confidential - Chicago, IL

Business Analyst Consultant

Responsibilities:

• Implementation of new accounting and expense software; transition from Replicon and Sage to Intacct and Nexonia
• Implemented modules ranging from A/R, Order Entry, A/P, Purchasing, Project Accounting, Revenue Recognition, Multi-Currency Consolidations, Multi-Entity, Fixed Assets, Time & Expenses
• Utilized API, Platform Services, Customization Services, third-party modules and acted as liaison between client and firm software engineers to develop custom integrations
• Collaborated with CFOs and controllers in designing the structure of the chart of accounts, dimensions, customer list, vendor list, etc.

Confidential - Chicago, IL

Workday Implementation

Responsibilities:

• Accessed current financial business processes requirements and procedures to align the same in Workday
• Customized numerous EIB’s and Workday templates in report builder
• Conducted ongoing system build, integration troubleshooting and configuration updates
• Developed, supported and maintained all required system design and build documentation
• Managed process of daily ACH payments and weekly checks to vendors in Workday Financial
• Managed a team of 7 AP specialists, assigned tasks and produced procedural processes documentation
• Executed data Conversion from PeopleSoft to Workday, ensuring the integrity of the data
• Facilitated team processes; writing and reviewing Unit Testing and UAT test plans and scripts when necessary
• Created customized Excel template for accounts payable month-end analysis and KPI’s
• Reported via deck all Key Performance Indicators for AP department

Confidential - Chicago, IL

Sr. Investment Accountant

Responsibilities:

• Daily and monthly reconciliation and analysis to be included in the report package to the Board of Directors of 3-billion-dollar portfolio to custodian and over 30 internal general ledger accounts using SAP Financial Management
• Calculations for MBS, CMBS, (CMO’s), Bank Obligations, NCUA Guaranteed Notes, Bullets, Balloons, Derivatives, Muni’s, and utilized solid analytical skills to determine and reconcile principle pay downs, accrued interest, and coupon payments
• Preparation of monthly, quarterly and annual financial reports for internal and external auditors and NCUA call report
• Calculated, analyzed and reported performance metrics for each series of capital; comparing to index benchmark’s
• Prepared journal entries reconciling to support month end process by ensuring timely resolution and clearing of open items

Confidential

Business Analyst - Project Coordinator

Responsibilities:

• Analyzed invoice spend and identified opportunities for consolidation and alignment
• Multiple credit bureau strategic initiatives including sub code clean-up project where over 77% of credit bureau subscriber codes were identified as either inactive or duplicate efforts and could effectively be closed, resulting in saving 42% of costs
• Developed and maintained process flow diagrams and activity assessments to design and/or re-engineer Risk Management processes expanding project opportunity and mitigating risk
• Visio for process mapping
• Inventoried all sub codes used to report BMO customer information, ultimately consolidating to a streamlined set of codes, to increase efficiency and ensure compliance with FCRA
• Created procedures and notification process when new Sub Codes are requested by stakeholders

Confidential - St Louis, MO

Consultant Business Analyst / Project Coordinator

Responsibilities:

• Calculated fee analysis on multi-faceted spreadsheet with multiple scenarios to assist products team in fee negotiations
• Incremental fee analysis using complex pivot and V-lookups that compared and calculated pre/post conversion revenue
• Facilitated weekly team meetings and daily conference calls addressing projects statuses, IT issues and all action items

Confidential, Chicago IL

Business Analyst Exceptions Processing System Migration

Responsibilities:

• Resolved settlement discrepancies and out of balance settings through a variety of balancing techniques and research
• Followed through on all out of balance conditions to ensure full and timely resolution.
• Discovered and recommended opportunities to improve reconciliation processes for greater operational efficiency, as well as improvement opportunities for other processing areas to minimize risk of error and research time
• Monitored and reconciled multiple general ledger and wire accounts daily, resolved trade breaks
• Streamlined operations and workflow to close office in NJ and transfer all processes to Chicago and Bangalore
• Prepared and disseminated various daily, weekly, monthly and quarterly control reports
• Executed daily, monthly and audits ensuring the handling and safekeeping of securities and processes
• Supervised daily OFAC and SIS checks on incoming securities, approved and verified processors daily work
• Calculated and processed FED/DTC factor adjustments, CTAS adjustments and Buy/Sell reclaims for all CMO’s
• Analyzed operations and created workflow diagrams to streamline all processes
• Reconciled general ledgers, exception reports and monitor settled/failed trades through Securities Transfer System
• Resolved daily reject issues on FED/DTC related transactions, CV and Registration Code corrections
• Reallocated shares on loan