SUMMARY

• Over 7 years of diverse experience in Business System Analysis of application software’s across Finance and Banking industries. Advanced knowledge of the applied principles of Project Management, and methodologies of SDLC, Proven proficiency in creating use case, activity, logical, component and deployment views, to develop various project deliverables.
• Expertise in conducting Joint Application Development (JAD) sessions with exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines.
• Strong time management, communications, decision - making, leadership and planning skills, with the ability to deliver quickly and multi-task in a fast paced environment.
• Extensive experience in data research & tracking solution functionality and performance to ensure that it meets market needs through analysis and validation of functional requirements, visual design, test plans and test code development
• Insightful understanding of Iterative Software Lifecycle Development process and Unified Modeling Language for modeling views and creating activity, data flow, using MS Visio.
• Excellent oral communication skills - Interacting with external stakeholders (such as clients and customers) and internal stakeholders (such as Subject Matter Experts, Management, Developers, Quality Assurance team, and Architecture Designer) to elicit, analyze and validate requirements; Conducting JAD sessions, walkthroughs, and conference meetings to elicit requirements, to discuss issues and suggestions, and to ensure that the requirements are understood and implemented correctly.
• Exceptional written communication skills - Producing Business Requirement Documents (BRD) and Functional Requirement Documents (FRD), Request for Proposal (RFP) Documents, Use Cases Specifications Documents, Data Dictionary Documents, and weekly status reports using Rational Requisite Pro and MS Word.
• Experience in usage of SharePoint to maintain updates in implementation of a new system
• Skilled at creating Use Case Model and detailed use cases in conjunction with the project team, to define the workflows and features of the application for the aid of the development team.
• Experience in querying and verifying Databases on Oracle, DB2
• Working closely with the Quality Assurance (QA) teams in developing Test Requirements documents, creating Test Cases and executing Test Plans, in performing positive testing, negative testing, regression testing, functional testing and User Acceptance Testing (UAT) and in analyzing test results.
• Experience with database development, datawarehouse development, ETL data extraction/transformation/loading, data mappings, financial and mortgage industries.

TECHNICAL SKILLS

Applications: MS-Office

Design Skills: MS Visio

Programming Languages: Oracle SQL

Data warehouse & BI Tools: Data stage

Project Management Tools: MS Project, Easyprojects.Net, SharePoint

Testing Tools: Quality Centre

Version Control: Rational Clear Case

CRM Solutions: Salesforce

Databases: Oracle, MS Access

Operating Systems: Microsoft Windows

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Business Analyst / Data Analyst

Responsibilities:

• High level design & Project plan that are best suitable for ongoing CCAR phase II process.
• Identify multiple source systems from which CCAR gets the data.
• Create detailed mapping documents for each source system. Mapping documents include details about all the CCAR business fields from a particular source system, join conditions and its impact on the CCAR monthly file which is delivered to the FED.
• Perform Data Profiling of the fields and present it to business to get sign off on each field for its population and DBR documentation
• Data Profiling - Performed data profiling on multiple source systems. Data profiling exercise includes multiple steps which are
• Traceability of atomic level data elements
• Identify and document the DQ rules for each atomic element
• Run a standard metrics report using DM studio
• Query each Data quality rule to identify the DQ anomalies
• Document the DQ anomalies in a separate work sheet
• Responsible for getting revision signoff from stakeholders and few business partners after completing the data profiling exercise for a source system.
• Fixed many DQ issues after reviewing the Data Profiling results with business partners and other stake holders.
• Created and adhered to project plan timelines for CCAR module wise development and delivery.

Confidential, Chicago, IL

Business Analyst / Data Analyst

Responsibilities:

• Understand and profile the business and loan systems at Confidential .
• Responsible to define business processes for gap analysis. Work with the Business and Business Systems to Design future state processes.
• High level design preparation for tactical and strategic technical solutions that are best suitable for ongoing process
• Perform Data Profiling of the fields and present it to business to get sign off on each field for its population and DBR documentation
• Data Profiling - Performed Data analysis / Profiling for over 50 CCAR fields which includes both retail and wholesale areas, mostly using Hard code SQL, PL SQL and Microsoft Excel.
• Performed Design and Architecture of CCAR Data Vault by creating Data models and high level business flow charts.
• Responsible for getting revision signoff from stakeholders and few business partners after completing design and development for few modules and sub modules.
• Created ETL Mapping documents and Data flow documentation (Data Vault)
• Involved in designing the frame work for CCAR loan population module and Retail and Wholesale sub-modules.
• Worked closely with ETL developers in guiding them through the business flow and regularly monitored progress of Data stage job development.
• Created detailed flow charts for CCAR loan modules and schedule preparation.
• Ran test scripts and use cases to validate data consistency between CCAR data and final FED schedules.
• Involved in creating and maintaining Metadata tables required for CCAR schedule processing.
• Monitored data model changes on a weekly basis and maintained metadata tables and related documents in sync.
• Created and maintained CCAR Reference code domains table.
• Worked closely with Testing Team to help out them to understand business and process flows. Involved in Test Case Design and Performance testing.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Gathered Business Requirements by interacting with the Business users, and Key stake holders for better understanding of the Business Processes.
• Served as a direct point of communication with business partners, Mortgage experts, QAs and with in-house developer staff to provide technical assistance during the development, testing and deployment processes
• Conducted Functional requirement specification and User requirement specification reviews and walkthroughs with the designers, developers and stakeholders.
• Analyzed business requirements and segregated them into high level and low level Use Cases (using MS Visio); Activity/State Chart Diagrams according to UML methodology to define Data Process Models.
• Analyzed operating procedures and policies on an ongoing basis and recommend and implement improvement plans where appropriate.
• Collaborated with Business Leaders to share and gather Cognos Planning requirements.
• Developed and prepared new and enhance existing Cognos applications.
• Supported and assisted existing production Cognos Planning applications.
• Developed and created procedures to administer Cognos Planning applications.
• Supervised internal quality assurance testing activities.
• Developed and prepared process to move Cognos Planning data to Data Warehouse.
• Worked with the Data Modelers team in modeling the conceptual, logical and physical data models in a Teradata DW Environment.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Tracked defects, assigned severity ratings, and managed change requests to target the most important bugs and enhancements in the product using Quality Centre.
• Wrote various SQL queries using joins and sub queries in Oracle database to develop Views for reports.
• Performed User Acceptance Testing (UAT) of Oracle Database with help of SQL Queries for data verification and data validation.
• Created different Traceability views to maintain the Trace ability of the requirements. Frequently updated the requirement and defect status as per current status of the project using Quality Center.

Confidential, Rockville, MD

Business Analyst

Responsibilities:

• Gathered Business Requirements by interacting with the users, designers, developers, project manager and SME's to get a better understanding of the Business Processes.
• Understood and articulated business requirements from user interviews
• Conducted Functional requirement specification and User requirement specification reviews and walkthroughs with the designers, developers and stakeholders.
• Analyzed business requirements and segregated them into high level and low level Use Cases (using MS Visio); Activity/State Chart Diagrams according to UML methodology to define Data Process Models.
• Analyzed operating procedures and policies on an ongoing basis and recommend and implement improvement plans where appropriate.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Tracked defects, assigned severity ratings, and managed change requests to target the most important bugs and enhancements in the product using Remedy’s Action Request System.
• Set up definitions and process for test phases including product test, integration test, and system test. Worked to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.
• Developed data quality SQL queries to address missing required data and incorrect data types.
• Created different Traceability views to maintain the Traceability of the requirements. And ensuring that appropriate documentation was stored in SharePoint repository.

Confidential

Business Analyst

Responsibilities:

• Assisted Project Leads in all phases of the Project to review project deliverables for completeness, quality and compliance.
• Comprehensive knowledge of the Loan Servicing System helped in creating targeted Questionnaires for SMEs to gather requirements and understand the business process goal from them.
• Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness. Planned and monitored projects to meet deadline, quality and budget requirements.
• Conducted JAD sessions with Subject Matter Experts to obtain domain level information and developed a vision plan that defined the primary goals and objectives of the project.
• Identify gaps, which require operational change in order to optimize system solutions by GAP analysis.
• Draw Use Case Diagrams, Activity Diagrams, and Process Flow Diagrams using MS Visio
• Created Requirement Specification Documents after conducting Interviews with End Users for the purpose of creating and defining the business and functional requirement documents.
• Prepared comprehensive Use Case Specifications document by identifying the use cases from the collected business-gathering document.
• Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
• Used TOAD with the MS SQL Server RDBMS to view tables, indexes, stored procedures, Joins etc.