Bishoy Ayoub ******.*****@*****.*** 718-***-****
BNY Mellon, Project Manager/Business Analyst 10/14 – Current, NY
Knowledge and practice of SDLC: Projects including trade dashboards for Workbench/Splunk, Live Chat for Help Desk, Global Markets reporting, Corporate Trust reporting, creation of new centralized entitlements platform, migration efforts.
Completed firm wide migration effort transitioning/converting 100,000+ accounts across several different platforms
Planned, developed, and coordinated change management plans and strategies; identified integration points with other change management efforts. Developed procedures and documentation for PMO
Worked with Production team to manage user expectations and user experience. Initiated change requests and managed production issues and platform fixes
Oversee SCRUM meetings and coordinate sprint planning sessions with developers
Collaborate with external vendors to exchange information on framework requirements
Worked with developmental teams throughout system implementation and delivery
Identified and mitigated issues before they resulted in major conflicts
Managed the entire project lifecycle from planning through handover to support for various projects
Developed project plans, identified resource needs, defined team roles, lead team meetings, and assured healthy team dynamics
Creation of process flow diagrams, use-case diagrams to enhance business requirements documents
Created and executed detailed UAT plans to ensure product delivery remained consistent with requirements
Implemented tactical data and reporting solutions to promote organization initiatives
Excellent business requirements writing and planning for various projects; Gathered, modified and maintained accurate project data and project status information
Coordinated project discovery and product evaluation efforts, specifically to develop time, resource and cost estimates to be used in project prioritization decision making
Engaged effectively with all levels in the organization – such as managing decision making processes with executives. Communicated with team members and provided direction and guidance in meetings
Supported existing processes, recommended enhancements to research and data gathering procedures
Designed and established new processes for requirements pertaining to existing projects
Provided support for the business and all system users, identifying issues and bugs through testing and questionnaires/feedback. Used data retrieved to solve system issues and create solutions.
Acted as a liaison between departments and systems personnel to develop or enhance systems
Acted as firm-wide subject matter expert and point of contact for questions. Supported multiple lines of business.
Actively partnered with management on operational projects including development of business cases as necessary
Maintained relationships with senior management both on a Domestic and International basis
MIS(Management Information Systems) Team – Executed reporting deliverables across all lines of business and for full array of products licensed by BNY Mellon
Use of VBA to streamline workflows and processes for various teams
Participated in the development of financial presentations for executive management, both on a regularly scheduled and ad-hoc basis
Provided financial and operational reporting for expenses (e.g., variance analysis including identifying key business drivers, monthly/quarterly financial reviews, reconciliations, and progress reports, etc.)
Created SQL queries for various functions and processes; Distributed SQL queries to technology to run against proprietary database structures
Developed presentations and detailed financial analyses presented to senior management including Internal and External analysis
Analyzed trends in the business each month and produced detailed reports for senior management highlighting key changes via ServiceNow
Compiled, monitored and analyzed key business metrics
Designed queries for team databases for use of data validation and extraction; ETL experience
Maintained complex databases. Ran complex reports and/or programs; developed new applications as needed.
Operated on a global team to produce deliverables on schedule; Ad hoc financial reporting for various financial managers and teams
Jefferies, Business Analyst 02/13 - 07/14, NY
Developed detailed descriptions and analysis of current and future state processes and workflows
Facilitated Joint Application Design (JAD) sessions to elicit business and functional requirements. Collaborated with Lead Developers to produce recommendations to business partners for improvements to existing business processes and systems; Mentored junior members on JAD Facilitation techniques
Created specifications that included detailed descriptions of records, files, and documents used in processing, and data flow charts; documented descriptions of relationships of the business rules to be considered by application development. Collaborated with developers to conceive and recommend solutions to business stakeholders
Collaborated with program managers to maintain project budgets
Worked with the Development Lead, Product Manager, and Program Manager to develop and implement software implementation plans
Maintained positive, supportive working relationships with business users and technology staff on assigned projects
Maintained proactive dialogue with business community on changing business strategies and needs
Defined business needs by analyzing and documenting business objectives; including research, planning, writing user cases and project overviews, plus any supporting documentation
Provided guidance in formulating new requirements and aimed to improve business processes by coming up with creative and alternative approaches to solving business problems
Managed scope and user expectations by ensuring requirements can be met within existing project budgets and timeframe
Communicated effectively with external business partners and internal teams to oversee the delivery of project requirements
Worked collaboratively across the organization to support successful institutionalization
Made recommendations on profitability improvement and cost containment
Worked with complex data models
Recorded inefficiencies of query logic and suggested solutions for improvement
Detailed analyses regarding deviations and aberrations in data returned
Analyzed and quoted data quality to ensure integrity standards were met
Citizens Financial Group, Junior Analyst 11/10 - 09/12, NY
Sought out new, value-added, and/or unusual sources of information
Followed and recorded credit market activity, and relayed to senior analyst when traveling
Upon breaking earnings and other news, very quickly composed notes which concisely summarized the news and provided value-added insight
Interacted regularly with clients
Worked closely with internal partners including high yield sales, trading and syndicate groups
Demonstrated business judgment, strong industry knowledge
Worked with senior analysts to develop key trading ideas
Wrote company and industry reports
Worked with and developed databases integral to our research products
Understanding of economics and macroeconomic factors
Assisted in research reports, market forecasts, articles and related products within one or more areas of personal expertise
Supported other analysts where required and provided application, market and product expertise to other groups within the organization
Assessed gaps between business process needs and system solutions and assisted the client with executing acquisition strategies
Monitored reporting environment to ensure report delivery and data integrity were intact
Identified opportunities to create new reports which bring value to end users
Created and maintained report schedules according to client requirements
Prepared new business presentations
Performed detailed sector and company research
Undertone, Cost Analyst 03/10 - 09/10, NY
Prepared revenue schedules in accordance with Undertone revenue policy and GAAP
Reconciled revenue and deferred revenue balance sheet accounts as well as any other accounts that were assigned
Assisted with month-end close, prepare and book journal entries
Assisted with the preparation of monthly and quarterly reporting packages as well as variance analyses
Various ad hoc projects and analyses
Provided assurances that expenditures were properly tracked, documented, and recorded in appropriate cost centers
Evaluated various financial and budgetary implications for sites in order to formulate viable options and recommendations
Collaborated closely with senior leadership on presenting alternative budget scenarios for strategic decision making
Developed year-end budget report for division, communicating findings to programs and senior leadership
Performed short and long-term financial forecasting and financial modeling
Worked closely with operations manager to ensure efficient and appropriate spending
Prepared and submitted invoices as needed
Skills
•Expertise in Microsoft Excel including features such as VLOOKUP, data queries, pivot tables
•Knowledge of VBA for Excel
•Experience with Confluence
•Experience with Microsoft Access as a lightweight back-end database
•Accomplished with Microsoft Power Point
•Knowledge of SQL
•Experience with MATLAB
•Knowledge of GAAP
•Experience with Microsoft Visio for creating flow charts, layers, various diagrams
•Knowledge of Agile
•Experience with UML
•Understanding of technical analysis, fundamental analysis, and statistical analysis
•Knowledge of PeopleSoft(Oracle)
•Use of Tableau for data analysis
•Strong background with ServiceNow
•Skilled with SharePoint
•Knowledge of Jira
•Experience with Capital Markets
•Accomplished with MS Project
Education
Baruch College, BBA in Finance and Investments. Minor in Anthropology/Psychology 2011