Project Manager

Jamal Haider

Professional Summary

Over * years of extensive experience as a Business systems Analyst in gathering and analyzing business and functional requirements, data analysis, data mapping, business process re-engineering, object-oriented designing, unified modeling language (UML), SDLC methodology (RUP, Agile, SCRUM, XP) and project management in cable communication, finance and investment banking domains

Extensive knowledge in conducting joint application development (JAD) and Rapid application development (RAD) sessions.

Extensive knowledge in Data Modeling, Data Analysis, GAP Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, and Dimensional Modeling.

Proficient in the use of Excel functions, VLookup, and Pivot tables for data extraction, analysis, and presentation.

Well-rounded knowledge of Financial Planning, Cost benefit analysis, ROI analysis, Forecasting, Budgeting and utilization of variance analysis to manage project completion timely and within budget.

Capable of writing MS access and SQL queries for: data entry, storage, extraction, and generation of reports for facilitating project management and decision making processes.

Extensive knowledge in UAT (User Acceptance Testing), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.

Excellent capabilities in implementing various negotiating strategies to gather resources for project development.

Extensive understanding of Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.

A Self-motivated individual with the ability to adapt to new environments and situations quickly with the ability to form and maintain positive and productive working relationships.

Possess excellent verbal and written communication skills as well as interpersonal and conflict resolution skills with strong analytical skills.

Comcast Cable Alexandria VA

Business/Systems Analyst July 2012 – Present

Primarily responsible for managing activities related to the conversion of Comcast’s Central Region’s current DDP billing system to CES 7.5 billing platform, offered by AMDOCS, a renowned SaaS company.

Responsibilities

Working with Comcast and AMDOCs SMEs in implementing the conversion of the current DDP billing system to AMDOCS CES 7.5 software especially focusing on key areas like: Rating Logic Configuration, Enterprise Product Cataloging, Rating, and Invoicing.

Regularly using DDP and CES 7.5 billing system software for monitoring the effects of billing system conversion on key customer metrics such as: correct cable service coding, taxation, invoicing, payments, and rating.

Carrying out data analysis using tools like: Excel VLookup, SQL Server, Pivot Table, MS Access to extract and report data related to equipment and accounts converted to CES 7.5.

Eliciting business and functional requirements from Comcast SMEs and developing requirement documents for the offshore programming team.

Developing test plans to monitor the quality of system conversion by stress testing the system with various functional scenarios.

Regularly leading system conversion meetings to ensure smooth transfer of knowledge and working concerns among business and development teams.

Facilitating smooth communication, information exchange, and documentation of all conversion related activities by developing PowerPoint presentations, meeting minutes/agendas, and other related reports.

Leading a team of 4 billings analysts responsible for Comcast subscriber bill auditing by working hands on with the DDP billing system software; and training the team in its operations.

Extensively traveling to Comcast Central Region Division offices for monitoring data transfer from the DDP system to CES 7.5; and carrying out quality assurance by reviewing key metrics of the new bills produced with the regional teams.

Environment: MS Visio, MS Office Suite, MS Project, UML, AMDOCS-DDP & DDPF, Remedy, SQL Server 2008, MS Project.

First Mortgage Corporate, Phoenix, AZ

Sr. Business Analyst June 2011 – June 2012

Worked on LOS (Loan Origination System) that provided First Mortgage associates and staff with a unified and integrated web based application for Loan Origination and Processing. I was involved in integrating the system for customer application. The application is used from the initial contact with customer through the final closing documents. Due to business expansion, the business operation needed to reduce manual review of loans and supporting files throughout the loan origination process. This was built to maximize loan efficiency, maintain current staffing levels, and double production volume within the project duration.

Responsibilities

Utilized Rational Unified Process (RUP) and Agile methodologies to configure and develop process, standards, and procedures.

Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.

Analyzed business requirements and segregated them into high level and low level Use Cases, Activity diagrams / State Chart Diagrams and Sequence Diagrams using Rational Rose/ MS Visio according to UML methodology thus defining the Data Process Models.

Developed standard documentation package (Requirements, Specification, Design, Operations, and Quality Testing Plans).

Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.

Performed requirement gathering & analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application.

Assisted in developing test plan, test cases and test scenarios to be used in testing based on business requirements, technical specifications, and product knowledge.

Identified use cases from the functional requirements and wrote use case specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams) in VISIO

Conducted functional and user requirement specification reviews and walkthroughs with the designers, developers and stakeholders.

Involved in performing User acceptance testing (UAT).

Worked with Quality Assurance team to review the test scripts against the functional specification and helped them in creating scenarios that would test the system end to end.

Worked closely with the data model team to review the data model and validate them.

Environment: Rational Requisite Pro, Rational Rose, Clear Quest, ClearCase, Rational Robot, Java, MS-Project, MS-Visio, MS-Office, UML

Capital One Plano, TX

Sr. Business Analyst June 2008 – August 2009

Capital one is a bank holding company specializing in retail & investment banking, credit cards, home loans, auto loans, and savings products. At Capital One, I worked on the updating of their signature Portfolio Builder tool that allowed investors to search and trade ETFs; and assisted in researching and analyzing new investment products. The project involved updating the system to provide a one shop-stop to carry out all these important investment functions.

Responsibilities:

Consulted various project stakeholders including Subject matter experts (SME's) and product owner to elicit business and functional requirements.

Worked with project managers, tech leads, external teams and vendors to set the estimates for all the functional areas getting impacted.

Conducted JAD sessions to gather business requirements from stakeholders, business and external users.

Followed Software Development Life Cycle using Agile Methodology for the project.

Prepared user stories for all the impacted functional areas and walkthroughs with the developers and stakeholders.

Prepared high level scope document including the impact analysis.

Participated in weekly status meetings with project manager, delivery manager and tech, leads to discuss and review the status of the projects.

Prepared source to target mapping document and reviewing it internally.

Conducted bi-weekly meetings with external teams to discuss impacts, finalize time lines, and share development and test results.

Assisted the SME with data extraction using SQL queries for reporting and interpreting data, and also voluntarily participated in portfolio analysis through carrying out Return on Investment calculations.

As needed, acted as a project manager to conduct standup meeting, retrospective meeting and updated that in sprint backlog.

Assisted the project manager with cost benefit analysis to ensure viability at all stages of project implementation.

Participated in the daily off shore team meetings to have transition presentation to explain every functional area.

Worked closely with QA lead to solve testing issues while conducting system and regression testing.

Prepared UAT test scripts and plans for efficient user acceptance testing.

Worked closely with QA lead and data stewards to conduct UAT testing.

Environment: MS Visio, MS Office Suite, MS Project, UML, ETL(abnitio), HP (Quality Center 9.2, QuickTest Professional 8.2/9.2), SQL Server 2008, Oracle 9i/10g, Version1.

Barclaycard Wilmington, DE

Business Analyst/ Accounting – Finance March 2006- May 2008

Barclaycard produces and designs a wide range of visa and master cards to meet the individual business and personal requirements of customers. Some of these cards include business rewards cards, Barclaycard ring, travel and entertainment, retail, special interest and business cards with the option of getting any of these cards issued as visa or master card. The project was based on the credit card billing application. The goal was to develop a tool that maximizes automation in the banks centralized billing system, and improve the functions of marketing, credit bureau reporting, payments, and transaction summary.

Responsibilities:

Performed project management functions including project planning, budgeting, business requirements, technical design, system specifications, and project deliverables

Processed feedback from project employees and determined project completion date

Documented and validated acceptance, integration, performance, and regression test plans

Provided technical support for technical project staff and customers

Continuously performed problem solving, problem analysis, and creativity functions using knowledge and logic intensively

Acted as the communication bridge between technical and non-technical project staff

Extensively worked with access and SQL databases while gathering the business requirements for the inbound data feeds and outbound data feeds for the finance department

Worked with Data Warehouse for data mining, making consolidated reports and finding relationships & correlations

Continuously documented business processes, operational processes and fulfilled test case and testing plans throughout the project

Developed featured lists for the analysis of the players in the market, financial data and divided them into release plans

Used product burn down charts to monitor the progress of the project

Concluded product backlogs and divided them into different sprints

Monitored and reported event activity and/or trends that occurred as a result of data load to the client counterpart

Implemented reference data management and provided the required info for the main System

Developed, managed and documented client data feed specifications, set the production schedule, and work with others to ensure the feeds were brought into production. Also had to monitor the process to ensure successful stabilization

Processed and/or reviewed daily/weekly inbound data load files to include research and data resolution of load file errors

Collected data on liquidity risks, analyzed regulatory reports and applied risk measurements

Carried out researched and resolved assigned specific issues and general inquiries reported through issue tracking

Analyzed trending activity related error reports including numbers, whether or not received, error type, percentage of total records, etc.

Developed ad hoc reports requested by the client and/or internal staff

Carried out testing of all phases of open enrollment/special projects including system functionality, forms, WEB and online screen functionality

Created various reports and report formats from the General Ledger (GL), cash flow and P/L statements

Used Excel Graphics, Pivot table reports and dynamic charts that had been created to develop automatic reports

Used normalization to retrieve the data into different forms using ERWIN and generated tables in the access database.

Extensively used Excel/Access and VBA for the ad hoc analysis of the data

Environment:

Microsoft Visio 2007/2010, Microsoft Access 2007/2010, XML File, SQL Server, Rational Requisite Pro, Windows ME, UML, MS Office 2003/2007/2010, and Rational Clear Quest 2002.

GMAC Mortgage Corporation Plymouth, MI

Business Analyst June 2004 – March 2006

GMAC Mortgage Group is a part of GMAC Financial Services, and consists of GMAC Residential Holding Corp. and GMAC Commercial Holding Corp. The project was a web-based application that aimed to enhance the automated Mortgage loan origination process beginning from origination/opening a mortgage application through funding/closing. The system performs all the Business functions of the loan process such as set-up Account information, New Loan set-up, Escrow Analysis, the Appraisal, credit, and income.

Responsibilities:

Established a RUP (Rational Unified Process) centric business analysis methodology.

Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.

Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC

Provided key initiatives in working with users in defining project and system requirements.

Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML

Performed requirement analysis, went through all the use cases and issue logs.

Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.

Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.

Involved in data migration design so that the data can be exchanged from other systems in standard ACORD XMLife standards.

Worked on data modeling and produced data mapping and data definition documentation

Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.

Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.

Played a key role in the planning, testing, and implementation of system enhancements and conversions

Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.

Guided development team in the Oracle 9i based database. Assisted in presenting reports and analysis to help guide the management.

Organized cross training of team members and users to become more responsive.

Assisted in development of training materials for new technology and process improvements

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, IBM Mainframes, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Education

Columbia University – School of International and Public Affairs New York, NY Master of International Affairs Specialization: Financial Management

College of Wooster Wooster, OH Bachelors of Arts Majors: Economics and Mathematics

Contact this candidate