Data Project
Resume:
Samatha
*********@*****.***
Permanent Resident
(Preferred Location is NYC, NJ)
PROFESSIONAL SUMMARY:
* ***** ** ******** ********** as a Business Systems Analysis/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
Diverse experience in Banking, Financial Services, Mortgage and Insurance.
Deep understanding of enterprise data warehouses.
Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
Experience with IBM WebSphere Business Modeler to understand and transform business through superior business modeling.
In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Agile, Object Oriented Analysis and Design (OOA/D)
Experience working with COTS applications and CMS (Content management systems).
Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, navigational flows, story boards, UI specifications and Sequence Diagrams.
Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
Knowledge with investment banking regulatory reporting regulations like Basel II Accord
Experience with SOX, Regulatory Compliance and Controls.
Extensive experience in configuring data mapping between different Databases.
Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/data mart and Business Intelligence (BI) tools like Cognos Modules (Reporter, Supervisor, Designer, and Web Intelligence).
Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
TECHNICAL SKILLS:
Methodologies:
RUP, Agile, Waterfall SDLC.
Testing Tools:
Rational Enterprise Suite, Test Director, HP Quality center
Change Management Tools:
Rational Clear Quest.
Business Modeling Tools:
Rational Rose, Requisite Pro, Microsoft Visio.
Operating Systems:
Windows9X, Windows2000, Windows ME, Windows XP, Windows Vista, Linux, Unix, MS DOS.
Office Package:
Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook Express.
Project Management:
Microsoft Project, Microsoft Office.
Databases:
MS-Access, SQL Server, Oracle.
Reporting tools:
SAS, COGNOS, Crystal reports, Erwin
PROFESSIONAL EXPERIENCE:
Client: Capital One, McLean/Richmond, VA Feb 2014 - Present
Role: Sr. Business Analyst
The project was to design and develop an Investment Risk Evaluation System for Capital One’s Financials Portfolio Management Business. The system provided a complete set of rules, computations, business definitions and underlying data structures to help Bank’s Financials Investment achieve Compliance to the Internal Rating Based Approach of the Basel Accords and RWA calculations.
Responsibilities:
Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
Collects requirements from department managers and users for enhancements. Acts as liaison between clients (Business Team) and (IT Team) development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
Followed Agile/Scrum methodology for the life cycle of the project.
Developed user stories and attended stand up meetings on a daily basis.
Prepared for GAP Analysis; identified and documented improved areas to meet capital requirements.
Interacted with Legal & Compliance team to include regulatory aspects.
Collaborated with Basel II team on credit risk analysis and issue resolution.
Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
Excellent knowledge in Component-based Development (CBD) and Commercial Off-the-shelf (COTS).
Worked in the implementation of COTS within Procurement business processes.
Performed Impact analysis of COTS on the interface between systems engineering and software engineering.
Followed Agile/Scrum methodology for the life cycle of the project.
Knowledge with investment banking regulatory reporting regulations like Basel II Accord
Ensure business requirements / application functionality is consistent with regulatory mandates from Dodd-Frank Act.
Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
Gathered and converted new regulatory rules and requirements into functional requirements for the system in ongoing update process.
Participated in establishing inventory of all operational and regulatory reports required for cutover. Provided reporting specs for numerous billing and network related tracking reports.
Was responsible for indexing of the tables in that data warehouse.
Develop 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
Tested Performance & Accuracy related queries under SQL Server
Designed and implemented basic SQL queries for testing and report/data validation
Manage Scope and change throughout the SDLC process of the product.
Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
Managed backlogs within the agile projects.
Used Data warehousing for Data Profiling to examine the data available in an existing database.
Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, EVPN, COTS, IBM Websphere Business Process Modeller, VBScript, Adobe Photoshop, MIS-IP, ACORD, C#. NET, ASP.NET, XML, MicroStrategy, Agile, TestDirector, LoadRunner, Niku Project WorkBench, AVPN.
Client: Bank of America, Charlotte, NC Jan 2011 – Jan 2014
Role: Sr. Business Analyst
This project focuses the regulatory expectations of BofA to comply with the Basel Accords adopted by the BCBS (Basel Committee on the Banking Supervision), which aims to strengthen the risk management in the financial systems across the banking sector.
Responsibilities:
Initiated Requirement gathering, analyzing, validating, and authoring use cases using UML
Prepared Use Case documents for all requirements and followed the RUP process.
Interacted with Legal & Compliance team to include regulatory aspects
Interface with the Wholesale Commercial Loan and Mortgage user group to address issues
Strong knowledge and understanding of the various steps in the Mortgage Loan Lifecycle
Held JAD sessions, finalized business requirements & prepared functional specifications
Involved in Inception Phase and prepared logical data models that contain set of diagrams and BRD (Business Requirement Documents) supporting documents containing essential business elements, definitions and descriptions of the relationships between the actors to analyze and document business data requirements.
Arranged meetings & Managed meeting minutes & created processes/ narrative flows
Involved in re-design of Mortgage Asset Management System.
Tailored business requirement documentation process with project scope and SDLC methodology used.
Designed Sequence diagrams, OOD using UML.
Collected information about business processes and requirement by conducting interviews with key business users.
Worked closely with employees in the Entire Mortgage Life, including Loan Application, New Loan Origination, Payment Application and Remittance, Collateral Inspection and Monitoring.
Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
Conducted brain storming sessions and collected information from committee of SMEs from various business areas such as Mortgage servicing, loan monitoring and asset management.
Designed and implemented basic SQL queries for QA testing and report / data validation.
Developed Proprietary business analysis methodology based on RUP (Rational unified Process) and supported in the design of Use cases and project plans.
Wrote SQL commands and procedures, to check for newly provisioned subscriber data for consistency and update invalid fields with proper value.
Documented various phases of product life cycle, and details of each iteration execution.
Used MS Project for project scheduling
Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
Effectively implemented the Change Management and Configuration Management process.
Performed change configuration management and defect management
Analyzed business requirements and constructed business logical models.
Prepared user guide & support documentations
Expanded existing filing resources, trained team on it
ABN AMRO, Chicago, IL Sep 2009 – Dec 2010
Business Analyst
Phase I
The primary function of the project was to automate the Mortgage Loan Origination Process beginning with the customer initiation to title transfer. 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, income and Title functionalities. My primary responsibility was to develop functional specification documents for the appraisal and credit departments by gathering, analyzing and documenting requirements from various Business users associated to the system, analyze external factors and the third party data sources such as regulatory agencies and credit bureaus and document the constraints
Phase II
My project was to build an Enterprise Reporting System to support the portfolio management and performance analysis of the credit card business with various reward offerings. The whole application processes were comprised of ETL process for transactional data, Filter process to identify valid transactions, calculation process for transaction and reward fee calculation, data integration into the Data Warehousing System. The end user interface was a web based OLAP reporting system implemented in Business Objects to provide business intelligence capability to asset manager
Responsibilities:
Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
Working with clients to better understand their needs and present solutions using structured SDLC approach.
Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
Analyzed data and created class diagrams and ER diagrams for designing databases.
Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
Extensively involved in the modeling and development of Reporting Data Warehousing System.
Analyzed the various kinds of risks that had to be accounted such as the Asset Class Risk for e.g. Credit Card Risk, Personal Loan Risk, Mortgage Loan risk, etc.
Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
Created Mock-up forms in MS word for better visualization and understanding of the software solution.
Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
Resolved issues related to requirements during system testing and UAT plan preparation.
Responsible for creating Use Cases, Business Process Modeling and Work Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
Tracked change requests and monitored workload and schedule.
Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
Identified various frequently used modules with in the application as well as the peak user volume for load testing purposes.
Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
Helped in creating end user manuals and procedure manuals.
Environment: Java, J2EE technology, Windows 2000 Advanced Server, UNIX / Oracle Platform, MS Visio, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot
PNC Bank, Pittsburgh, PA Mar 2008 – Aug 2009
Business Analyst
The project at was to design, alter, and update their banking platform. Commercial Market Loan Origination System (CMOS), CMOS is designed to book loans in commercial banking. It allows inputting all the information about businesses and individuals in the main application form that is tied up with number of other forms in a precise workflow. Loans are approved and then booked if all the requirements are fulfilled.
Responsibilities:
Requirements Gathering, its analysis & design using Rational Rose.
Conducted JAD & JAR sessions
Created Process Work Flows using ER diagrams, Functional Specifications, and Project Initiation documents.
Analyze Software Requirement Specifications (SRS); prepare Functional Specification Document (FSD), Design Document.
Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
Extensively performed data modeling
Analyzed, documented project requirements and changes to requirements for the new functional specifications to be included in the current system within the current development lifecycle.
Interacted with various cross functional teams on building business use cases, understanding the process flow and sequence activity
Performed complex sql queries to validate back end transactions and ETL process.
Created full life-cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
Involved in the drafting of reporting methodology and multiple statements and combined statements
Design Sequence diagrams for all the identified use cases.
Design Class diagrams for the various identified packages.
Over-looking test plans such as system integration plan
Involved in the Preparation and execution of Test Plans, Test cases, Test scripts using Test Director
Reported bugs to developers using Test Director
Involved in the processes of both Automated and Manual Testing.
Design & development of user interface.
Environment: Rational Rose suites, SharePoint 07, MS Visio, MS-Project, Test Director
EDUCATION:
Bachelors of Technology from JNTU, India
Contact this candidate