PROFESSIONAL SUMMARY:

• 8+ years plus experience as Business Analyst/ Data Analyst in Finance sector with an understanding and ability to work independently and in cross functional teams.
• Maintain a strong understanding of the requirements, by closely collaborating with Providers frequently.
• Extensive knowledge of Software Development Life Cycle (SDLC) and quality control methodologies such as Waterfall Traditional Methodology, Agile, SCRUM and RUP (Rational Unified Process)
• Experienced in requirements gathering through various means of conducting group meetings, interviews and JAD Sessions to identify customer needs, gather requirements and create Business Requirement Documents (BRD), Functional Requirement Documents (FRD), User Acceptance Test (UAT) Documents and Use Narrative & Use Case Diagram.
• Exhibited competence in processing Test Plans, executed test cases, validated and tested complex scenarios for quality purposes including UAT.
• Proficient in using Unified Modeling Language (UML) diagrams for Business Process Modeling, Use Cases, Activity Diagrams, Data Flow Diagrams, Class Diagrams and document them using MS Visio.
• Ability to prepare RTM (Requirements Traceability Matrix) & perform requirement analysis.
• Comprehensive understanding and experience of Cash Flow Analysis, Financial Statement Development, Ratio Analysis, Data Modeling and Survey.
• Excellent knowledge of GAAP, IFRC and excellent knowledge of making them work in user specific environment.
• Experienced in analyzing and creating SQL and PL/SQL scripts to generate customized monthly, quarterly, annually user reports.
• Extensive experience on manual and automation testing tools such as HP ALM /Quality Center, Rational Team Concert, Rational Quality Manager, QTP/UFT, Selenium, Spring too, Eclipse, CI, Cucumber, Soap UI.
• Regularly interacting with the development team and higher management in order to meet the project objectives, deadlines and solving any outstanding problems.

TECHNICAL SKILLS:

Project Methodology: Waterfall, Agile and SCRUM

UML Tools: Microsoft Visio, Visual Paradigm

Operating Systems: MS windows (XP, Vista, Window 7, Windows 8, Windows 10)

Databases: SQL Server, DB2, MS access, Excel

Office Tools: MS Word, MS power point, MS outlook, MS Excel

Requirement Management: DOORS, Requisite pro, HP Quality center and Share point

Data Modeling: SAS, SPSS, STATA and MATLAB

KEY COMPETENCIES AND SKILLS:

• Budgeting and planning
• Business Analysis
• Financial services
• Supporting Strategy Rollout
• Change management
• Pro - Forma Financial Statement
• Client relations
• Business modeling
• Data Migration Mapping
• UAT & Testing
• CRM & Workflow
• Test planning
• Enterprise Architect
• Financial Programming
• Ruby/Java/Selenium, QTP,UFT, ALM,QC, GitHub, Version One, SVN, Maven, Hudson, Jenkins-CI/CD, Cucumber, testing frameworks, Hive, Pig, Saucelabs, Appium, Apple Tools, Mac, Angular JS, Mobile development, MS Project, Visio, SPSS, SAS, Finance, Accounting, Process modeling, MATLAB, STATA

PROFESSIONAL EXPERIENCE:

Confidential, Tucson, AZ

BUSINESS DATA ANALYST

Responsibilities:

• Responsible to work in on the enhancement and functional development of Navigator portal. Responsible to pursue the follow up the user tests and in corporate any changes to the requirements arising from the tests. Acting as a feeding source to the Change Management process from initial request through estimation, approval, requirement documentation, and implementation.
• Served as a product lead Business Data Analyst on the Navigator portal project for the Investment Banking, Commercial Banking and Corporate Banking groups. Navigator is used for on boarding clients and entering deals, revenue, call reports, and client plans.
• Elaborating requirements (i.e., Data, System, User, Security, etc.) for the OBO Design Standards Database Project.
• Elicited, wrote and managed full functional requirement process for on - going enhancements made to the Navigator portal.
• Responsible for creation and updating of all system requirements documentation. (User' Guides, User Stories, Acceptance Criteria, Test Case, Test Steps)
• Responsible for Information Technology (IT) Division System Development Methodology (SDM)
• Reviewed and approved the QA team’s test scripts. Participated in the QA team’s defect meetings to review defects as entered in Quality Center. Validated defects, added comments and assigned proper status to defects as required.
• Gathered and documented business requirements for the conversion of legacy Merrill Lynch applications to the Navigator portal. Served as a subject matter expert on legacy Merrill Lynch applications.
• Developed and maintained Oracle PL/SQL Packages, Stored Procedures, Functions, Views, Materialized Views, Triggers, Sequences, etc. Analyzed existing Production Stored Procedure code in Data Warehouse and wrote business requirements where none existed.
• Provided data analysis in Production, Staging and UAT environments with SQL, Excel, Access and other tools to the users and other stakeholders.
• Wrote stored procedures and queries consisting of T-SQL and DML to create tables and views, load/update/read data as needed from SQL server, data warehouse.
• Created new Cognos reports to aggregate and display data. Tracked project progress and posted updates and reports to SharePoint portal for dynamically delivered/cached presentation.
• Analyzed data discrepancies for data conversion projects. Documented and managed data dictionaries of systems.
• Supported logical and physical mapping efforts. Helped review the accuracy of the logical data models and data mapping transformation rules...

Confidential, Parsippany, NJ

BUSINESS DATA ANALYST

Responsibilities:

• Responsible to contact the PoC at the Apple Federal Credit Union to conduct meetings and gather requirements for the Online Mortgage Loan origination. Responsible for analyzing the needs of the business and its customers and incorporating them into the FRD. Involved in the management of multiple small projects, using MS Excel and DOORS to enhance the existing functionality and web page development for the customer. Acting as a feeding source to the Change Management process from initial request through estimation, approval, requirement documentation, and implementation.
• Participated in mortgage loan processing evaluation and documented the needs and requirements for the systems and reviewed the requirements for the existing system to find out areas where additional enhancements are needed.
• Used DOORS to develop Business Requirement Documents (BRD) and Functional Requirement Document (FRD) for the Online Mortgage Loan origination system.
• Performed additional analysis of FRD to make it robust and consistent with the AFCU needs and developers' understanding.
• Arranged multiple in person meetings and JAD sessions with the developers and AFCU to discuss the requirements and in corporate changes.
• Projected and tested different scenarios to predict the functionality and performance level of the Loan Origination System, using the IRAS tool.
• Used Visio and UML Diagrams to visualize the system process and to present, elaborate and explain the details of the requirements to all stakeholders.
• Communicated with the relevant parties and, in times, solved the defects and bug issues arising from either Alpha or Beta Tests conducted during development or after deployment.
• Performed Gap analysis during the whole process of SDLC to find out whether or not the project is meeting the predicted goals and objectives.
• Actively involved and assisted the PM in the Agile process formation and SDLC development determined and presented the Level of Effort (LoE) to the PM.
• Wrote Business Requirement Specifications documents to further elaborate the requirements and successfully delivered necessary change in a manageable way, during the process of Change Management.
• Helped the team in the process of Implementing new designs within the Business Operating Model and continuously communicated with the customer and developer.
• Used SQL and MS Excel to Map and extract Data based on the customer needs and requirements and prepared Data Mapping Documents for specific requirements of the customer.
• Prepared Data Specification Document for the loan repayment data migration between data bases and data warehouses.
• Developed and wrote ETL (Extract, Transfer, Load) Logics, in line with the customer needs.

Confidential, Washington, DC

BUSINESS ANALYST

Responsibilities:

• Working with the Point of Contact at Confidential to determine the exact needs for the system changes in the IPMS. Responsible to document securitization process system upgrading. Responsible for analyzing the needs of the business and its customers and incorporating them in to the FRD. Involved in the management of multiple small projects, using MS Excel and DOORS to enhance the existing functionality and web page development for the customer. Acting as a feeding source to the Change Management process from initial request through estimation, approval, requirement documentation, and implementation.
• Documented the upgrading and enhancement of four new applications for issuers as part of enhancing the Integrated Pool Management System (IPMS).
• Reviewed the requirements for the existing security issuance platform, so that the new applications don't contradict with the basic structure of IPMS.
• Participated in mortgage based securitization process evaluation and documented the needs and requirements for the systems and reviewed the requirements for the existing system to find out areas where additional enhancements are needed.
• Used DOORS to develop Business Requirement Documents (BRD) and Functional Requirement Document (FRD) for the Online Mortgage Loan origination system.
• Performed additional analysis of FRD to make it robust and consistent with the IPMS needs and developers' understanding.
• Arranged multiple in person meetings and JAD sessions with the developers and IPMS PoC to discuss the requirements and in corporate any changes in to the FRD and/or BRD.
• Projected and tested different scenarios to predict the functionality and performance level of the IPMS platform, using the IRAS tool.
• Used Visio and UML Diagrams to visualize the system process and to present, elaborate and explain the details of the requirements to all stakeholders.
• Communicated with the relevant parties and, in times, solved the defects and bug issues arising from either Alpha or Beta Tests conducted during development or after deployment.
• Performed Gap analysis during the whole process of SDLC to find out whether or not the project is meeting the predicted goals and objectives.
• Actively involved and assisted the PM in the Agile process formation and SDLC development determined and presented the Level of Effort (LoE) to the PM.
• Wrote Business Requirement Specifications documents to further elaborate the requirements and successfully delivered necessary change in a manageable way, during the process of Change Management.
• Helped the team in the process of Implementing new designs within the Business Operating Model and continuously communicated with the customer and developer.
• Used SQL and MS Excel to Map and extract Data based on the customer needs and requirements and prepared Data Mapping Documents for specific requirements of the customer.
• Prepared Data Specification Document for different data set migration between data bases and data warehouses.
• Developed and wrote ETL (Extract, Transfer, Load) Logics, in line with the customer needs.
• Prepared Data Specification Document for the periodic Confidential interest payments for different types of Confidential holder groups.

Confidential, RESTON, VA

BUSINESS ANALYST

Responsibilities:

• Working with the Point of Contact at Confidential to determine the exact needs for the Lender's Office system changes. Involved in the management of multiple small projects, using MS Excel and DOORS to enhance the existing functionality and web page development for the customer. Acting as a feeding source to the Change Management process from initial request through estimation, approval, requirement documentation, and implementation.
• Documented the upgrading requirements for the Lender's Office in compliance with new requirements of Uniform Loan Delivery Dataset (ULDD).
• Worked with the PoC to make sure the requirements are according to the expectations of Confidential new set of rules and regulations.
• Reviewed the requirements for the existing ULDD platform, so that the new applications don't contradict with the basic structure of ULDD.
• Used DOORS to develop Business Requirement Documents (BRD) and Functional Requirement Document (FRD) for the Online Mortgage Loan origination system.
• Performed additional analysis of FRD to make it robust and consistent with the customer needs and developers' understanding.
• Arranged multiple in person meetings and JAD sessions with the developers and ULDD project PoC to discuss the requirements and in corporate any changes in to the FRD and/or BRD. Documented the requirements and validated the contents during the meetings and JAD sessions with all stakeholders.
• Projected and tested different scenarios to predict the functionality and performance level of the ULDD platform, using the IRAS tool.
• Used Visio and UML Diagrams to visualize the system process and to present, elaborate and explain the details of the requirements to all stakeholders.
• Communicated with the relevant parties and, in times, solved the defects and bug issues arising from either Alpha or Beta Tests conducted during development or after deployment.
• Performed Gap analysis during the whole process of SDLC to find out whether or not the project is meeting the predicted goals and objectives.
• Actively involved and assisted the PM in the Agile process formation and SDLC development determined and presented the Level of Effort (LoE) to the PM.
• Wrote Business Requirement Specifications documents to further elaborate the requirements and successfully delivered necessary change in a manageable way, during the process of Change Management.
• Helped the team in the process of Implementing new designs within the Business Operating Model and continuously communicated with the customer and developer.
• Used SQL and MS Excel to Map and extract Data based on the customer needs and requirements and prepared Data Mapping Documents for specific requirements of the customer.
• Prepared Data Specification Document for different data set migration between data bases and data warehouses.
• Developed and wrote ETL (Extract, Transfer, Load) Logics, in line with the customer needs.
• Helped the team in the Implementation process of new designs within the Business Operating Model and continuously communicated with the customer and developers.

Confidential, Washington, DC

BUSINESS ANALYST

Responsibilities:

• Working with the Middle East and Central Asian Department (MCD) to assist in the process of developing new economic programs for the member countries. Responsible to collect, compile and report economic and financial data to the desk economists. Help the desk economists in the process of economic data modeling and data verification with source.
• Used MS Excel to compile economic data.
• Compiled economic indicator data like Gross Domestic Product (GDP), Balance of Payments (BoP), Monetary Aggregates (M1, M2) for member countries
• Used STATA, SAS and Matlab to model economic trends and feed the results to the economics programs.
• Used SQL to map data for economic indicators from the International Financial Statistics (IFS) data warehouse.
• Used MS Excel to produce macros and run them to get special trend analysis.
• Used Visio to visualize the outputs in the presentations.
• Experience in Keyword Driven Testing, Data Driven Testing, cross browser testing and parallel test execution using Selenium suite, Cucumber, and Eclipse.
• Implemented automation using Selenium Web Driver, JAVA, Cucumber, Maven and Jenkins
• Involved in projects to review financial & budgetary systems and redesigning of the systems for IFS.
• Knowledge and Expertise in System design and development required for business process.
• Used MS Office extensively (Word, Excel, MS Access Visio, Visual Basic, Power Point, Outlook Project) for calculations, developing graphs, presentation and documentation throughout the projects.
• Knowledge of Data Modeling, Data Mapping, Data Mining and Data Warehousing.
• Having a thorough understanding of how IT interfaces with multiple functional groups within an organization.
• Ability to construct process models including data dictionaries and quantitative estimates.
• Ability to design and produce pro forma financial statements.
• Able to test business applications from a business perspective to ensure that all client requirements are incorporated into the design.
• Understanding service objectives and capturing business requirements through active listening & questioning techniques.
• Able to prepare written proposals, requirements and solution specifications.
• Able to Identify business & systems process improvements from Big Picture to detail level (Macro to Micro and Micro to Macro).
• Excellent communication skills to manage and liaise with business and technical consultants to explore business process improvement opportunities.

Confidential, New York, NY

BUSINESS ANALYST

Responsibilities:

• Served as a liaison between the internal/external business community and the IT organization in order to help facilitate the development of project business, user and functional/non-functional requirements, Worked on Inventory Systems
• Involved with the Project Manager (PM) for the initial development of project plan, milestones and management of deliverables, Detailed Schedule, Resource Allocation and Budget Plan throughout the entire life cycle of the project
• Studied the insurance market thoroughly and Kept a record of the changing trends of the insurance market.
• Worked closely with Business users, IT, SMEs and stakeholders to ensure business needs and views are properly represented throughout the lifecycle of the project.
• Responsible for drafting and facilitating reviews and approvals of key project documentation with Goals, Objective and Scope Statements, High-level and Detailed Business Requirements, Success Metrics, Business Cases, Process Models, Use Cases, Test Cases/Scenarios etc.
• Served as a liaison between the internal/external business community and the IT organization in order to help facilitate the development of project business, user and functional/non-functional requirements, Worked on Inventory Systems.
• Facilitated meetings and interview sessions with Business PMOs and Enterprise Program Managers EPMs and SMEs for review, edit and updated the documentation and for cross functional approvals.
• Touched basis of different work streams and participated in End to End E2E testing cycles
• Communicated and interacted with both IT team and QA team to clarify and provide information on validating and testing the requirements specifications
• Collect information related to ongoing application upgrade and their impact on implementation and to discuss the next steps for implementation
• Developed Process flow diagrams and use cases and test cases using Visio and Power point and worked with Solution Architects to understand the workflow of the system
• Performed GAP analysis and Impact analysis to see application impact on other applications
• Conducted GAP analysis on the "Current" system and worked on the documentation of the requirements of the future "Target" system
• Contributed in Defect Tracking and Logging for quality assurance and future maintenance purposes
• Formulated the Requirements Traceability Matrix for tracking and reviewing requirements
• Performs other reasonable duties as required