Business Analyst

Skills

Employment History:

CONFIDENTAIL

Special Operations Division

The Government of the District of CONFIDENTAILa, Office of Contracting and Procurement OCP , on behalf of the DMV is providing a web-based ticket processing system call TASS Ticket and Adjudication Management Services for the adjudication of violations, accepting payments of tickets, maintenance of records of tickets issued in the District of Columbia for all vehicles. Making sure all the systems involved in issuance of tickets entails a smooth integration and coordination of data with various vendors and systems.

Responsibilities:

• Key player in the department's biggest expansion and launch of New Photo Enforcement Technology called DC Street Safe which doubled the program's capacity.
• Analyzed and managed large amounts of data through its life cycle thus making sure that the flow of data from one system to another Camera-Vendor-Processing was accurate, consistent and reliable that helped management in making critical decision and meeting deliverables.
• Making sure the ticket processing systems CITEWEB and CITENET is as efficient, user friendly and will support in generating a variety of reports and analytic tools in order to see results in enforcements, patterns of traffic, identifying new locations for camera's, and flow of data from one system to another system and monitor productivity of processors.
• Liaised with software developers on a regular basis to provide feedback on the usage of CITEWEB and CITENET thus encouraging creation of new functions that would the productivity of enterprise programs.
• Used UML notations and RUP methodology to analyze and translate the business requirements into system requirements.
• As business Analyst of this large municipal organization, I was responsible for all budgeting, yearly expense and procurement for those operations as well as the enforcement issues.
• Evaluated and tested new or modified software programs to verify that programs function according to user requirements and conform to established guidelines.
• Wrote, revised, and verified quality standards and test procedures for program design and user functionality. Reviewed, on a regular basis, operational procedures to ensure that they are being performed in the most economical and efficient manner.
• Created reports and developed analytic tools to improve the ticket processing system and electronic traffic enforcement tools including: tracking location data, ensuring integration between vendor programs, investigating system errors and evaluating and providing solutions for improving user productivity
• Created a variety of training manuals LPR's, ALARMS, CIC Training for using CAPTIVATE 4.
• Worked with financial teams for activities such as planning, budgeting, forecasting, reporting analysis capabilities in isolation.
• Participated in UAT for LPR's License Plate Readers . Made sure that all requirements for the HH HandHelds were tested using various scenarios and conditions, and ready to hit the streets.
• Had Knowledge in municipal organizations business and their MOU processes.
• Thorough knowledge of the current Ticket Processing System and a clear understanding of the life cycle of a ticket from its inception to its final NOI Notice of Infraction to the registered owner of the vehicle.
• Enhanced my knowledge on the need for safer roads for pedestrians and drivers and making sure the endeavor to have 'Zero' fatalities will someday be accomplished.

CONFIDENTAIL

Business Analyst

CONFIDENTAIL

• CONFIDENTAIL has various divisions and five main lines of banking namely Branch Banking, Fifth Third Processing, Commercial Banking, Consumer Lending and Investment Advisors.
• Scope of the project was to adding features and enhancements to existing credit management products such as online applications, online account access, online bill payment, wire transfers, and viewing and downloading monthly statements. One of the main objects of this project was to enhance the application process for loans in order to meet business and regulatory requirements.

Responsibilities:

• Worked with financial teams for activities such as planning, budgeting, forecasting, reporting analysis capabilities in isolation.
• Worked with SME's in Finance, Investment, Commercial and Personal banking to document existing business processes, and performed Business Process Re-engineering.
• Performed Fit-Gap Analysis and gathered both functional and non-functional requirements based on interactions with process owners stakeholders.
• Followed the adaptive RUP framework for the Project life cycle PLC .
• Updated and maintained Use Cases, Activity Diagrams and Workflow Diagrams using UML and MS Visio.
• Ensured Wires processed are in compliance with the Bank's Overdraft Policies and are properly approved.
• Released customer ACH files to the Data Center to insure financial entries to client accounts are properly Charged / Credited.
• Experience in dealing with Business managers to indicate long-term business plans, and adapt them into the long-term financial plans.
• Documented business processes as well as business rules and worked with users to define the project and system requirements.
• Developed Test scenarios and implemented Test Plans for UAT. Assisted in quality testing of the application using functional and regression testing on various browsers such as Internet Explorer and Safari and reporting bugs to the development team.
• Had experience in Implementing back office and web based systems and procedures to parallel overall municipal organization Business strategies.
• Strong analytical skills including a thorough understanding of how to interpret customer business needs and translate them into clear business requirements and functional requirements
• Maintained Project notes and files to ensure Deliverables were met and tracked on a regular basis.
• Trained end-user groups, and documented functional instructions and user guidelines.
• Gained valuable Project Management experience working with software development teams, tracked schedules, timelines and budgets, and monitored daily tasks using MS Project and MS Excel.
• Facilitated Joint Requirements Planning JRP sessions between technical, business and regulatory teams to ensure that requirements are met, and issues during the development phase are resolved.

CONFIDENTAIL

Business Analyst and Quality Control Analyst

CONFIDENTAIL has established negotiated TOB's Terms of Business to purchase loans from the Seller. These contracts are created as per the Sellers' Master Agreements MA , Master Commitments MC or amendment to the existing contract, and the loans are processed using either of the two systems: the Selling System PE Sourcing and the Legacy System MIDAS LOP . Once the Sellers define and accept the terms of the contract, the Seller delivers loans against the contract. Based on the terms of the contract, product and credit terms are setup in the Selling and/or Legacy systems. The primary objective of this project involved implementing new financial products by creating and modifying mortgage products using mainframe MIDAS Mortgage Information Direct Access System . This involved analysis of Business Requirements for completeness and accuracy. Worked closely with internal business partners to manage and maintain project release timeline. Followed all QC procedures to ensure SOX compliance.

Responsibilities:

• Analyzed contracting documents in Deals on a daily basis and set up business rules in Terms, Products, and Agreement TPA system Web Application for a variety of Terms of Business TOB using Freddie Mac database repository DOORS, DPM Deal Pipeline Manager .
• Generate daily and weekly reports for Single Rule Exception SRE , Special Characteristic Code SCC SRE, and Negotiated Values/Products work status. Generate weekly and monthly check-in report from Remedy v7 system.
• Expertise in managing requirements and traceability using Requisite Pro and DOORS.
• Analyzed LEGACY requirements and set up products and programs in MIDANET and CSWEB. SME Subject Matter Expert on Setup and Quality Control activities. Trained and mentored new recruits within a group on Setup and Quality Control.
• Used DOORS to write the detailed requirements for application control and functional specifications.
• Strong analytical skills including a thorough understanding of how to interpret customer business needs and translate them into clear business requirements and functional requirements
• Analyzed functional requirement specifications and wrote detailed Test plans, Test cases and executed Test scenarios.
• Met all deliverable times and participated in 7 scheduled releases within a year and that was the highest number of releases held in one year.
• Had experience in Implementing back office and web based systems and procedures to parallel overall municipal organization Business strategies.
• Strong knowledge in dealing with Business managers to indicate long-term business plans, and adapt them into the long-term financial plans.
• Provided source documents for one of Freddie Mac's Key Control's TEC 19 which when tested passed the PWC Price Waterhouse Coopers and KPMG internal and external audit.
• Generate the reports on Ad-Hoc request in Excel for Deals or Data in TPA per management's request.
• Scheduled Project Team meetings prior to releases to ensure timelines and guidelines were being met. Participated in weekly Legacy meetings and responsible for the meeting minutes and distribution of minutes to concerned parties.
• Contributed towards the Knowledge Transfer and Transition document in place by creating and updating Process and Procedures for business flow Using Visio Word and also composed instructions or manuals for new system or process flow Using PowerPoint
• Managed monitored business rules request from community mailbox and open remedy tickets if it's needed.
• Adhered to department practices, standards, policies, procedures and methodologies.

CONFIDENTAIL

Business Analyst/Data Analyst

The goal of the Project was aimed at maintaining Data Quality Standards set by CONFIDENTAIL . This involved updating and maintaining the metadata repository known as the CDM for various systems used by the Company in order to develop an Enterprise Level Repository that incorporated both the Single-family as well as Multifamily data. Provided Data Quality Analysis around issues related to Multi-Family HCD Data, which included creating 'as-Is' and 'To-Be' lineage diagrams, providing proposed system changes and lastly closing out Data quality issues. Data quality reports were created on a daily, weekly and monthly basis for various teams to assure the quality of data.

Responsibilities:

• Led the efforts on the conversion project of the in-house Metadata Repository CDM to the Enterprise Level Metadata Repository EMR . Responsibilities included verifying and mapping the attributes in various systems, meeting with business leads and data modelers to validate definitions, physical names, business names, data types, codes values, data source etc. to conform to the HCD Housing and Community Development Standards.
• Used DOORS for capturing, analyzing and managing changes to requirements.
• Worked along with members of the Enterprise team to implement standards and procedures for changes to the new Enterprise Level Metadata Repository.
• Created RTM using Doors, that traced Application Use Cases to Business Requirement Document, Test Cases to Application Use Cases, Test Cases to Report Requirements and Test Cases to Supplementary/GUI specifications
• Worked with financial teams for activities such as planning, budgeting, forecasting, reporting analysis capabilities in isolation.
• Communicated to the IAWC Information Architecture Working Committee for approvals towards project level compliance and DST process review.
• Worked with various teams to create 'as-is' and 'to-be' flows for identified critical data elements using MSVisio and PowerPoint. Was able to provide system changes and data quality checks that needed to be added to the systems to insure quality of data.
• Generated data corrections reports together with proposed resolutions, documentations, and system impact analysis for the Data Governance Board meeting.
• Implemented the data corrections in Production through various implementation procedures.
• Through data analysis, I was able to close out data quality issues that existed between the various systems.

CONFIDENTAIL

Business Analyst

The project aimed at developing a system that creates financial reports in turn replacing the existing manual process to obtain data Primary job responsibility was to gather requirements for creation of these financial reports. The scope of the project was to automate the manual processes for obtaining data, Store data on the CDW, Generate financial reports for internal and external reporting e.g. Annual Reports . Generate analytical reports for internal use e.g., Multifamily Loan Details Report . The automation will make these reporting processes more practical and agile, thereby helping to meet the corporate mandate to close the books within 18-days. By replacing manual processes with automated systems, controls will be monitored, thereby adhering to Sarbanes-Oxley compliances.

Responsibilities:

• Gathered requirements in order to ensure that the Multifamily Housing Finance and Development's long-term vision to build a MHFD Multifamily Housing Finance and Development Data Mart for historical data, against which reports can be run for a variety of purposes, is fulfilled.
• Managed all requirement documents using Doors.
• Collected requirements for the MHFD Multifamily Housing Finance and Development automated reconciliation's in a technology independent context.
• The new application's requirements were gathered in order for it to achieve the following functionalities: Store data in data tables, Perform calculations necessary for financial reporting, Provide auditable history of monthly activity and reporting, Provide about 30 reports for analysis, Comply with existing FASB Pronouncements and Accounting Policies at the time of build.
• Worked with financial teams for activities such as planning, budgeting, forecasting, reporting analysis capabilities in isolation.
• Entered requirements in and change requests in Requisite Pro.
• Effectively automated financial reporting for Accounts Receivables and Payables and tighten data security that benefited in better analysis, reporting and communication at the management level.
• Experience in dealing with Business managers to indicate long-term business plans, and adapt them into the long-term financial plans.
• Involved in Change Management Configuration using Rational Clear-Quest.
• Worked closely with the UAT team to resolve issues or concerns from the SIT Systems Integration Team . Created a maintained the UAT suite Test Plan, Test Cases, Test Scripts . Analyzed UAT results.
• Interacted with the Business Users through interviews and Joint Application Development JAD sessions.
• Participated in preparing flow diagrams for the using Ms Visio.
• RUP process model was used for the different phases of the application development of the Software Development Life Cycle.
• Examined user requirements, attended Change Request meetings, documented changes and implemented change control procedures using the Rational Clear Quest.
• Networked with developers to report software bugs and re-tested the fixed issues.
• Gave constructive input in terms of Modification Requests and Enhancement Requests.
• Maintained Risk Register and Issues Log.
• Responsible for weekly status.