Project Customer Service

Mythily Sundararajan, PMP

Active CLEARANCE: Public trust

US Citizen

Cell: 571-***-****. Email: *******.******@*****.***

Senior Business/Systems Analyst/Project lead

Accomplished Business/Systems Analyst/Project Lead, offering expert analytical skills, extensive project management experience, and a history of delivering significant business process and bottom line improvements within the Banking, Wealth Management, Mortgage and Insurance domains. Hands on experience leading all stages of system development effort, including planning, requirement definition, gathering, design, architecture, testing and support. Outstanding team leader capable of successfully managing and coordinating the team during all phases of the project to support the business objective.

Areas of Expertise:

● SDLC (Agile, RUP, Waterfall)

● Data Analysis/ Validation/ Mapping/Dictionary

● Business/Requirements Analysis

● Requirements Management/Traceability

● JAD Sessions/User Stories/Epics

● Business Requirements Document

● System Requirement Specifications

● Use Case/Activity/ Flow Diagrams

● Reverse Engineering

● User Acceptance Testing (UAT)

● Communication and Interpersonal skills

● Team and Project Leadership

● Project Management

● Organization skills/Detail Oriented

Education

M.A. Public Administration, University of Madras, India

B.A. English Literature, University of Madras, India

Certifications

PMP. Project Management Institute

Technical Skills

Methodologies and languages: Waterfall, RUP, Agile, UML, SQL, HTML

Tools: DOORS, IBM ClearQuest, IBM Requisite Pro, Visio, Mercury Quality Center, Rational Jazz, TFS, JIRA

Data Base: Oracle, MS-Access, MSSQL Server

Productivity Applications: MS Project, Word, Excel, Power Point, Outlook.

Others: SharePoint, Lotus Notes, Microsoft CRM, BMC Remedy

COTS: TeamSite, Eloqua, Informatica

BI/BA/Visualization tools: Business Objects

Professional Experience

Primescape Solutions

Client: Office of the Comptroller of the Currency (OCC) April 2015 – Current

Dept. of Treasury, Washington D.C.

Lead Systems/Business Analyst

OCC is an agency of Treasury that ensures the safety and soundness of the national system of banks and savings associations, foster competition by allowing banks to offer new products and services, improve the efficiency and effectiveness of OCC supervision, including reducing regulatory burden and ensure fair and equal access to financial services for all Americans

Project:

Supervision Modernization is one of the components of the OCC Enterprise Information and Analytics initiative. As part of this initiative, the goal is to migrate institution structure data received from the FRB NIC & CATS/NATS systems and supervision data from SIS (Supervisory Information System) to meet the agency’s analytical and operational reporting needs. The data mart will support these analytical functions through a design, which will provide for ease of use and increased query response time.

•Served as the Lead/Senior Systems Analyst.

•Collaborated with the Project Managers, Business owners to establish scope and monitor scope.

•Created Project plan and maintained it in MS Project.; Created PowerPoint presentations for project review meetings, conducted daily status meetings to provide status updates to management about the project status, risks and impediments.

•Provided back up support for the project manager in tracking project goals, setting scope, interacting with the customers for status updates and other project related work.

•Conducted extensive JAD sessions with various stakeholders to gather business and data requirements.

•Worked extensively with MCBS (Midsize Community Bank) and LBS (Large Bank) personnel in analyzing financial and supervisory data to create reporting and analytical requirements.

•Created operational reporting requirements & analytical reporting requirements.

•Provided examples of existing analytical/operational reports used by examiners.

•Created “as-is” and “to-be” data workflow.

•Performed gap analysis to sort out the source to destination mapping issues and resolved issues with the development team and the customers.

•Defined business rules that governed the data load into the Integrated Data Store, Data warehouse and the Data mart.

•Created data view requirements for use by end user for analytical and reporting needs.

•Maintained requirements in Rational Jazz and SharePoint.

•Created RTM (Requirement Traceability Matrix) using Rational Jazz.

•Created business object universes; ran reports on Business objects to test and analyze user needs and requirements.

•Working knowledge of relational data modeling, ETL process.

•Executed SQL statements to retrieve and analyze supervisory data for writing requirements and resolving issues; Working knowledge of RDBMS, database design.

•Created UAT test plan, test cases and scripts and participated in User Acceptance Testing to validate the requirements.

•Provided ongoing support during the development and testing phases.

Freddie Mac, McLean, VA Dec 2014 – April 2015

Lead/Senior Systems Analyst

Freddie Mac, one of America's biggest buyers of home mortgages, is a stockholder-owned corporation chartered by Congress, to keep money flowing to mortgage lenders in support of homeownership and rental housing.

Served as the Lead/Senior Systems Analyst supporting multiple projects

Collaborated with the Project Managers, Business owners, junior analysts, to establish timeframes, provide cost-benefit comparisons on new projects, monitor performances of junior analysts in respect to deadlines and artifacts.

Provided extensive support to the Project Managers in terms of cost benefit analysis, budget issues, and weekly updates.

Project: Informatica Data Masking Project

Freddie Mac has a large number of applications, systems and tools that contain Protected Personal Information (collectively, “PPI Applications.”) associated with over 60 million borrowers as well as for Freddie Mac employees, contingent workers and other individuals. To address this security challenge, the PPI Applications – Data Protection Strategy project team will implement both technical and non-technical solutions to protect high-risk PPI data from unauthorized user access.

Created Project Plan & contributed to Kick-off planning.

Defined Project Scope and wrote scope document, project charter.

Created RACI matrix to identify all stakeholders

Developed PowerPoints and conducted presentations introducing Informatica DDM Tool to BIO Teams across 26 applications and 42 databases

Conducted extensive JAD sessions with various stakeholders to gather business and data requirements.

Developed and managed BRD and SRS in Sharepoint.

Used DOORS as the requirements management tool and created RTM (requirement traceability matrix) to track the business goal to the product.

Collected data for various Inscope applications / databases containing Personal Protected Information (PPI)

Collected Masking Policy identified for each user and contributed to Scoping Document

Managed Testing Effort, Knowledge Management Effort and Implementation Plan

Analyzed high risk data elements containing personal protected information

Gathered and defined business rules for masking data

Extensive analysis with excel using Pivot tables, Vlookup, Conditional Formatting etc.

Documented System Requirements and Business Requirements Document

Monitored progress of junior analyst tasks

Project: Team Site Software Upgrade

Online Strategy & Management (OSM) utilizes HomeFront (the corporation's intranet), freddiemac.com (the corporation's internet site) as well as other Freddie Mac owned domains as primary communications channels to communicate corporate and business related messages to external and internal audiences. TeamSite is a Commercial Off-The-Shelf (COTS) product used by OSM to manage HomeFront, Freddiemac.com and associated domain’s content. It is used to collect, manage, and publish content. It also provides for content version control.

Provided cost benefit comparison of Team Site Software Upgrade versus moving Team Site to the Cloud

Conducted extensive research on their cost and features vs their benefits.

Prepared and presented to the Business customers the convinced them to an in-house upgrade vs moving to HP Cloud.

Project: Knowledge Article for Help Desk in handling FHFA users

The purpose of this document is to help guide FHFA users, when issues are encountered accessing Freddie Mac (FRE) IT assets, resetting passwords, and requesting support for the GRC application related issues.

Worked on creating this knowledge article and work flow by talking to several internal teams including Help Desk, Internal Audit, GRC operations team, and Service Desk

Created a Work flow process to aid the Help Desk Personnel in assisting FHFA users, who are considered “VIPs” and are required to be treated as special customers.

Pragmatics, Inc

Client: Office of the Comptroller of the Currency (OCC) Nov 2011 – Dec 2014

Dept. of Treasury, Washington D.C.

Lead Systems/Business Analyst

OCC is an agency of Treasury that ensures the safety and soundness of the national system of banks and savings associations, foster competition by allowing banks to offer new products and services, improve the efficiency and effectiveness of OCC supervision, including reducing regulatory burden and ensure fair and equal access to financial services for all Americans.

Project: Supervisory Information Systems (SIS) – Reporting

SIS-Reports is a Web-based application that enables OCC users to query current and historical supervision data, then use that data to generate reports built in SSRS. Users additionally can export report data to Microsoft Excel and save reports as PDFs. SIS-Reports is an OCC internal-use-only system accessible from the OCC intranet.

Project: Supervisory Information Systems (SIS) - Admin

SIS-Admin is a Web-based application built in .Net platform that provides numerous administration screens used to maintain user data, as well as other reference data. This “back-office support” program has specialized modules for a variety of users, including Help Desk personnel, Customer service representatives, Large bank system administrators, Examiners, and Technical staff members. SIS-Admin is an OCC internal-use-only system accessible from the OCC Intranet.

Served as the Supervisory Information Systems (SIS) team Business Analysis Team lead for developing reports used for bank supervision by Midsize Community Bank Supervision (MCBS) and Large Bank Supervision (LBS) groups.

Worked extensively with MCBS and LBS personnel automating business processes and analyzing financial and supervisory data.

Created, owned, and maintained Business requirements document in Rational Jazz and Sharepoint

Created RTM (Requirement Traceability Matrix) to trace the business goal to end product

Conducted highly interactive JAD sessions to gather functional and non-functional requirements.

Built very strong business relationship with both internal and external customers, which in turn has, lead the team to provide successful Agile delivery of software solutions to the business needs.

Expert skills in writing epics, user stories and acceptance criteria for the agile framework; managed spring backlogs.

Managed multiple projects/tasks from Project initiation, through requirements, design and development, testing, implementation, maintenance, using OCC Agile development.

Managed the team through the full life cycle of report development from planning scope, gathering requirements, developing reports

Served as a member of Change Control Board (CCB) for major enhancements and followed detailed CCB process to implement changes

Supported the developers and testers during coding and system testing

Supported business customers and participated user acceptance testing

Helped the Project Manager with overseeing production implementation, and providing post-implementation support.

Assisted the development and quality assurance teams with the deployment process from development environment to testing and staging environment in TFS.

Client: Freddie Mac, McLean, VA April 2011- Aug 2011

Sr. Systems Analyst

Freddie Mac, one of America's biggest buyers of home mortgages, is a stockholder-owned corporation chartered by Congress, to keep money flowing to mortgage lenders in support of homeownership and rental housing.

I worked on the Data Services Integration (DSI) project under the Multi-family division of Freddie Mac. It was an Enterprise wide initiative to create a centralized hub for data sharing and exchange of data between several Producer and Consumer Systems. It involved publishing real time business data from the Producer Systems to the DSI hub and consumption of real time data by the Consumer Systems from the hub. Data was published to the DSI hub via business events and consumed by the Consumer systems in a specific order. I was in charge of the study, analysis and creation of various software documents for the Consumer system named MISYS Loan IQ, a COTS product.

Responsibilities:

Reviewed business team artifacts, understood business need, and elicited functional and non-functional requirements.

Collaborated with architects in the refinement of event and logical data models for the Consumer systems.

Collaborated with architects to perform mapping of business data requirements to Source of Record.

Analyzed existing documentation and elicited future needs, created to-be process flow diagram and documentation.

Conducted interactive JAD sessions to elicit business requirements.

Assessed translation and transformation needs to convert CDM format to Consumer format.

Thoroughly studied the inherent systems to have a clear understanding of the business processes and associated system workflow, created AS-IS and TO-BE workflows to identify gaps.

Conducted multiple interviews to clarify requirements in order to identify functional and nonfunctional requirements

Created Software requirement specification based on the meetings with users and analyzed Business Requirement Document.

Involved in walkthroughs and meetings with development team.

Conducted walkthrough sessions of the requirement documents with development and testing team.

Provided extensive support during development and system testing phases.

Created User Acceptance Test Plan, Test cases and Test Scripts

Client: Bank of America Merrill Lynch, NY July 2010 – Mar 2011

Sr. Business Systems Analyst

Bank of America Merrill Lynch's Real Estate Structured Finance Servicing Unit is the sixth largest commercial mortgage loan servicer in the country. The portfolio totaling approximately $134 billion is serviced primarily for third parties, including CMBS investors. The platform is rated annually by S&P and Fitch as a Primary, Master and Special Servicer.

I worked on multiple projects under the Multifamily Data Warehouse (MFDW) initiative. The initiative was aimed at setting up a Data Integration Infrastructure for Commercial mortgage. This would help Merrill Lynch in reducing replication of data, retiring ETL EUC’s and legacy systems, adding abstraction to eliminate dependence on upstream systems design and creating a single source of attested data. The MFDW would also improve efficiencies for future systems / enhancements and simplify corporate reporting. This initiative implemented rules driven Service Oriented Architecture (SOA).

Responsibilities

Worked with the PM to create Project Charter, which covered high-level objectives of the work to be done, strategic fit, key success factors and scope of the project.

Conducted a walkthrough session of the scope document to ensure that the project sponsors and stake holders understand the project scope and any associated constraints, risks and issues as early as possible.

Used a blend of waterfall and iterative as the System Development Life Cycle (SDLC).

Developed project plan along with cost and resources, track the progress and generate reports using MS Project.

Analyzed procedure documents of manual and already automated reports and reconciliation to get a better understanding of the system.

Created as is process work flow with proper understanding of system by applying accounting concepts and to be process work flow and conducted GAP analysis.

Conducted interviews with key business users to collect requirement and business process information by forming questioners with proper understanding company’s business model about secondary market.

Effectively conducted JAD sessions to gather cross function information and different opinions.

Recommended alternate solutions and presented them to the management, end users and developers.

Identified all the business needs and stakeholders and modeled it by creating a Use Case Model.

Conducted brainstorming sessions to enhance the use case model by identifying missed stakeholders and system uses.

Modeled the business process and documented it by creating process flow diagrams and business requirements.

Created the Activity Diagrams, Use Case Specification and Functional Requirement Specifications in co-ordination with the Business area and development team.

Carried out data analysis and data validation for existing database using SQL queries to verify accuracy and completeness of organization’s data and verify new Database schema with existing data structure and data types.

Prioritized and distributed tasks to the team for effective execution and conducted weekly team meetings to streamlining the team development activities.

Maintained business requirements, use cases, Functional Requirement Specifications and business rules in Requisite Pro.

Exported functional requirements to Quality Center and linked them to UAT test cases.

Created Requirement Traceability Matrix (RTM) using Quality Center.

Created UAT Test Plan based on UAT strategy and conducted detailed walkthrough sessions with all stakeholders to communicate their responsibilities and effort requirements for UAT.

Lead the UAT execution and managed defects.

Created (Clear Quest) CQ tickets for all defects and coordinated with development team and business to get the defects resolved.

Involved in regular reports, feedback and communication with the management, coordinating the team members and maintaining the project log Presentation, delivery and documentation of project.

CIG Corp., MI July 2009 –May 2010

Business Analyst

CIG Corp. is primarily a Wealth Management Company selling Insurance, Equities, Bonds, REITs and Investment Banking. They needed a Control System to meet the compliance regulations, using the most effective technique for balancing extreme efficient customer quotation, maintenance and providing customer service for online system. This project was the introduction of Online Inquiry to the new and existing Policies in effect.

Responsibilities:

Performed Gap Analysis for new functionality requirements for Control System projects, as well as prioritized them based on actual business needs to align them with the product release roadmap.

Involved in JAD sessions for efficiently defining user requirements and eliminate project errors.

Managed and traced requirements using DOORS.

Design and develop the Functional Overview Document (FOD) and the Business Requirement Document.

Worked on Insurance, Equities and Bonds Trading Transactions projects with multiple users.

Worked on multi user’s authentication, authorization of users in accounting system.

Responsible for writing Functional Use Cases.

Involved in Re defining business process, documenting enhancements.

Responsible for Business Analysis, business interaction, and production of functional requirements and interfacing with Technology build team.

Responsible for coordinating business meetings and generating monthly status reports.

Used Management Tools like MS Project'98, for Project Planning, Project Tracking, Resource Allocation, Time Allocation, and Performance tracking.

Involved in modeling of the business and application using Rational Unified Processing (RUP) and UML.

Actively engaged senior business team members and power users to gather requirements. Led sessions between various development teams to elicit use cases.

Communicating QA standards and procedures to the project management, Business analysts and the development teams.

Prepared Change Management Plans and prepared project charters.

Experienced in defining Change Management (CM) best practices.

Managed successfully CCB and ECR process through Rational Clear Case and Clear Quest.

Cambridge Consulting Group, MI March 2005 – Jan 2009

Business Analyst

Worked on various projects with a leading Insurance & Investment Brokerage Company in Michigan. They provide Equity/Bond Investments, Life Insurance, Disability and Health Insurance, Property & Casualty Insurance. It incorporated a wide range of features for Policyholders and new customers.

Project: The project involved developing applications for the company’s e-business that took care of online account services which allowed customers to get online Life Insurance, P&C quotes, check their bill history, manage accounts, order auto insurance ID cards, make changes to Policy, Claims and Billing.

Project: Worked on automating the Claims processing system for Auto Insurance, Health, Life & Homeowners Insurance, which helped Online Claim intimation, submission of claims & processing.

Project: Estate planning application for providing high net-worth clients with appropriate wealth management solutions.

Responsibilities:

Conducted highly interactive JAD sessions with project stakeholders, subject matter experts (SME), end-users, developers and project management team for identifying business needs, defining software requirements and resolving issues.

Thoroughly studied the inherent systems to have a clear understanding of the business processes and associated system workflow.

Conducted multiple interviews to clarify requirements in order to identify use cases and document UC Specifications.

Created Business Requirement documents based on the scope document and meetings with users and analyzed User Requirement Document, Technical Requirement Specification and Functional Requirement Specification (FRS).

Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML 2.0.

Worked with the team to create the User Interface screenshots to be presented to the Business.

Performed Gap analysis for the modules in production.

Used Rational ClearCase, a Configuration Management tool, to maintain different project documents with descriptions.

Involved in walkthroughs and meetings with development team to discuss related issues.

Conducted walkthrough sessions of the requirement documents with the all stakeholders for their review.

Initiated and managed the documents approval processes as indicated by adopted SDLC.

Participated in User Acceptance Testing (UAT) for results analysis and defects triaging.

Participated in User Trainings.

State Farm Insurance, IL Sep 2004 – Feb 2005 Business Analyst

I worked with a leading Insurance company in the USA, to help them introduce multi line discount to their policyholders. I worked with various stakeholders to elicit, analyze, document, and test functional requirements for this feature.

Contact this candidate