
Mark Kidane
- Project Manager Assistant / Sr. Business Analyst
- New York City, NY
- Member Since Jun 09, 2023
Mark Kidane
Summary:
· Sr. Business Analyst with a track record of 7+ years’ experience in identifying user requirements, analyzing, designing, developing, testing user, and production support.
· Skilled in performing Gap analysis in financial services industry and specialize in front office analysis, information systems management and analytical reporting using various business objects and Reporting in Actimize and AML reporting.
· Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirements document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) across the deliverables of a project.
· Demonstrative experience in requirement gathering, change management, defining the data requirement preparing data flow diagrams, data analysis, data dictionaries and data mapping.
· Extensive knowledge in software development life cycle (SDLC), project life cycle (plc) and software development methodologies such as RUP (Rational Unified Process) , Waterfall and Agile Techniques for front office etc. Well-versed with Microsoft Visio, rational requisite Pro, Rational clear quest, test director. Experience in JAD Sessions, Live Meetings and Interviews.
· Extensively experience with MS Visio and UML preparing Use Cases, Class Diagrams, Activity Diagram, Sequence Diagram , entity relationship diagrams, collaboration Diagrams. ..etc.
· Experience in writing SQL complex queries/scripts for fixed income data warehouse including triggers procedures.
· Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.
· Extensively experience on preparing a Project charter/definition.
· Intensively worked on US Fixed Income - Callable Bond, Corporate Bonds, Government Securities (T-Bond, T-Note, and T-Bills), Money Market Security, Mortgage Backed Securities and various risk measures such as duration, convexity.
· Hands on in developing and implemented QA/UAT test plans and user training for bloomberg. Gained recognition in planning and executing the smoke testing, system testing, functional testing, integration testing, performance testing and regression testing for Teradata.
· Hands on experience in conducting user training sessions, preparing user-training manuals and conducted post audit meetings for issue resolutions during production.
· Ability to track record of designing and developing high quality, scalable and efficient solutions and products on schedule.
· Excellent understanding of option Greeks like delta, gamma, theta, Vega.etc
Technical Skills:
Programming Languages: C, C++,Java ,Python, HTML, XML, PHP, SQL, PL/SQL
Project Methodologies: UML, RUP, SDLC, RAD, Agile, Waterfall
Requirement analysis Tools: Rational RequisitePro, Rational Rose, Toad, Jira, QTP
Quality Assurance: Load Runner, Software Application Testing Life Cycle
MS Office: MS Access, Excel, PowerPoint, Outlook, Visio, MS Project
Databases: Oracle 10g, MySQL, Sybase, PLSQL
Market Data Sources Reuters, Bloomberg, Barclays, IDC, Markit
Work Experience:
Citi group. NYC, NY. Nov 2014-Present
PM Assistant/Sr. Business Analyst
Worked on multiple projects with principal responsibility in creating DataMart for fixed income reporting. OTC Derivatives Analyzed the source data, written Business Rules and Constraints and prepared data mapping & Data dictionary files. The DataMart was integrated with the reporting platform within the company’s framework.
Responsibilities:
· Develop business architecture using project requirement by preparing project plan/charter as well as project schedules.
· Gathered business requirements and processes through document analysis and interviewing the users.
· Analyzed compliance requirements and identified functional and non-functional requirements. Prioritized the requirements, developed effective and unambiguous business requirement document and translated them into functional specifications.
· Conducted (JAD) joint Application Development sessions with cross-function team members for discussing various shared issues to ensure that the business objectives are met with and requirements are understood clearly at all levels.
· Responsible for data mappings, data dictionaries and data validations.
· Prepared data flow diagrams to show how the data will be mapped and flow in different systems.
· Communicated with the internal stakeholders while gathering validating requirements.
· Managing requirements and communicating with user groups and team members. Role involved extracting, analyzing, merging, and summarizing data from the existing Financial systems.
· Involved in developing projects plans and project charter along with the schedules.
· Implemented business rules to measure, analyze, improve and control business workflow of fixed income reporting process for futures data. Used SQL queries/scripts for Fixed income data warehouse and security master.
· Developed the test plan, test conditions and test cases for compliance UAT and conducted UAT testing in batches.
· Managed the change requests and requirement throughout the project life cycle (PLC) - Initiation, Planning , Execution, Control and Closure.
Pioneer Investments. Boston, MA. Oct 2013-Nov 2014
PM Assistant/Sr. Business Analyst
Involved in creation of daily/monthly Actimize report and generating algorithms for alert. Worked with Suspicious behavior Analysis models include AML-EFT,AML-ECT,AML-STR and AML-TSD.
Responsibilities:
· Responsible writing functional requirements and specifications for new AML Rules and procedures.
· Involved in gathering requirements for alerts for various Actimize models.
· Involved in Actimize for trade surveillance (Parking).
· Successfully integrated Alert Detection Model into the firms System.
· Created Data Mapping and Data Dictionary files and analyzed large data sets.
· Performed User Acceptance Testing and System Integration testing to make sure Firms Compliance system is properly integrated with the Actimize models.
· Effectively identified data from various data sources and written business rules and constraints so that the data is mapped correctly to the Actimize model.
· Prepare use cases, test cases and test data.
· Conducted daily SCRUM meetings to establish daily deliverables and mitigated obstructions to development schedule. Create Daily, Weekly and Monthly progress reports on projects and issues in SharePoint.
· Wrote business specifications documents and functional specification documents.
· Involved in creating data documents for upstream and outside vendors defining data requirements clear and concise.
Western Asset Management Company. California, CA. Apr 2011-Oct 2013
PM Assistant/Sr. Business Analyst
Worked as a Business Analyst and implemented the processes and methods to test various applications developed to accomplish risk management tasks. This application has the ability to perform risk return analysis in the back office. Assisted risk manager to implement Basel II Requirements in his risk reporting modules.
Responsibilities:
· Gathered Basel II Reporting Requirements for fixed income instruments from the traders and risk managers.
· Involved in preparing test plans and test cases.
· System design, Document preparation, Gap Analysis, requirement gathering.
· Designed and developed Use-Case Diagrams, Class Diagrams, Object Diagrams using UML Rational Rose.
· Involved in System Analysis and worked as a Technical Business Analyst.
· Analyzed existing systems, conducted gap analysis and recommended solutions to augment current functionality.
· Designed Class, Use Case, State Chart, Activity and Component diagrams.
· Used Visio to create flow charts to show cause and effect, process, or work flow diagrams.
· Requirements gathering, Validation of requirements, Process flow design, and Use Case diagrams. Handling dynamic change of business rules.
· Extensively involved in UI testing and Black box testing.
Blue Shield of California. San Francisco, CA. Jan 2010-Apr 2011
PM Assistant/Sr. Business Analyst
Worked on Marketing Department requirements for a precise, actionable reporting system to track sales in Online and Offline systems. Identified effective lead generation tactics that would result in higher sale conversion. System was put through SDLC with pretesting done on various solutions with recommendations using ROI were provided.
Responsibilities:
· Conducted JAD sessions and created BRD for creating Performance Metrics to assess and track Marketing Effectiveness. Partnering with key participants to design and implement Performance Management Metrics.
· Created Marketing Effectiveness Dashboards financial and sales data, to measure direct sales efforts.
· Created and managed weekly reports with KPI for measuring marketing effectiveness.
· Analyzed Marketing Campaign, results in measurable improvement in market
· Assisted technical team in creating ER Diagrams for Database Design and performed SQL Queries for Data Analysis
· Worked with Data Architect in analyzing existing applications & completed Data Modeling for the corporate database
· Reviewed and validated the Data Model to make sure that business rules are met; Assisted database designers by continuous involvement in transition from business requirements to database design
· Created Test Plans, test requirements, test hierarchy, test cases and Test Scripts in conjunction with QA team and was involved with test execution; participated in System Testing and UAT process before rolling out to production.
· Worked on documenting User Manual, Reference Guide, and Administrative Guide.
Eaton Vance. Boston, MA. Feb 2009 – Dec 2009
Sr. Business Analyst
Working on Basel III, actimize Reporting framework for OTC Derivatives and Fixed Income Instruments. Successfully integrated the current reporting platform to the Basel III requirement to calculate and report Market and Credit Risk. The Report Aggregation Application supported new analytics requirement for OTC Derivatives and produced customized exposure & analytics reports for different portfolios in order to support Market Risk, Credit Risk and Liquidity Risk requirements of Basel III.
Responsibilities:
· Analyzed the complex analytics requirements for OTC Options and Bonds and prepared Data Mapping and Data Dictionary Files.
· Gathered business requirements through sessions and analysis by interviewing users and subject matter experts (SME) for, Parking, equity cross, AML (SAM) reports
· Identified the gap analysis in financial services industry and specialize in Front office analysis, information systems management and analytical reporting using various business objects and Reporting in Actimize and AML reporting.
· Coordinated with upstream providers of analytics and security reference data for equity, fixed income and derivatives to oversee data integrity
· Assisted project manager with identifying project scopes, deciding project participants and preparing project timelines. Successfully identified data from various data sources and written business rules and constraints so that the data is mapped correctly to the Actimize model
· Created Data Mapping and Data Dictionary files and analyzed large data sets via sql related to the implementation of SAM model (Suspicious Activity Monitoring)
· Actively involved in the ETL of data so that it can be implemented and integrated in Actmize
· Created mockups and wireframes for analytics and report Aggregation Engine.
· Led scrum meetings as a scrum master to share opinions and track sprint tasks by analyzing Burndown charts
· Conducted Joint Application Development (JAD) sessions with project manager users, developers, quality analyst, legal & compliance representative, and data architect for discussing and identifying issues so that the requirements are clear, concise and unambiguous.
· Broke down the requirements into functional and non-functional requirements to ensure the requirements are buildable, testable and traceable
· Worked with user group in understanding the requirements and various complex financial calculations.
· Assisted in developing QA test strategies and Test Plans /test cases and continuously keep the track of defects identified and prepare the defect trends.
· Managed the change requests and requirements throughout the project life cycle (PLC) - Initiation, Planning, Execution, Control and Closure.
· Developed and Implemented Requirements Traceability Matrices, Project Status reports, Issue/defect management, UAT test plans and User Training documents.
· Organized and executed UAT testing.
· Successfully completed the User training sessions, deployment, production testing and closures.
· Responsible for Issue resolution & developing the issue escalating procedures.
Education:
· Masters from Massachusetts University. Boston, MA.