SUMMARY:

• 5+ years of professional experience as a Business/System/Data Analyst in Finance/Banking Domain.
• Worked with Cross - Functional team, Business Analysts, Product Mangers, Project Managers, Testers, Subject Matter Experts and Developers.
• Excellent knowledge about SDLC methodologies like Waterfall and Agile.
• Expert in MS Office Applications and have excellent Organizational Skills, Leadership Skills, Problem-Solving Skills, Multi-tasking Skills, Critical thinking Skills.
• Collaborated with Stakeholders and gathered the business needs and have extensive experience in writing Business Requirements, Functional Requirements, Non- Functional Requirements, System Requirements, Functional Specifications and Technical Design Documents.
• Assisted relationship mangers and portfolio managers with completing KYC and reaching out to clients regarding their AML docs.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Expertise in translating user requirements into technical specifications and mapping the process design, work flows for SDLC with documenting and managing business requirements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Business Objects and Tableau.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Experience with Data Analysis using Oracle as a backend and TOAD as the querying interface.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Good Knowledge in Structured Query Language (SQL).
• Proficient in Functionality Testing, System Integration Testing, and Regression Testing including Effective defect tracking and reporting using HP Quality Center, JIRA and Application Life Cycle Management (ALM)
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.

TECHNICAL SKILLS:

Requirements Management: Requisite Pro, Microsoft Office (Word & Excel)

Front End Tools: Microsoft Project, Microsoft Office

Databases: SQL Server, Oracle Toad 10, Oracle SQl Developer, Mongo DB, MS Access

Document management: Visual Source Safe 6.0, Share point, Ultra Edit

Defect management tool: HP Quality center 10.0

Methodologies: Agile, waterfall

BI Tools: Business Objects, Microsoft SQL Server Reporting Services, Tableau.

ETL Tool: Informatica, Microsoft SQL Server Integrated Services

Data modeling: Microsoft SQL Server Analysis Services

PROFESSIONAL EXPERIENCE:

Confidential, Norristown, PA

Business System Analyst

Roles and Responsibilities:

• Served as the Technical Business Analyst, led multiple teams on several complex, enterprise-wide Business Intelligence projects, providing business, data, and technical requirements analysis to ensure that reporting solutions met the highest data quality standards.
• Involved in business analysis and project management, coordinating between team members, addressing budget issues and creating test plans according to the business requirements.
• Worked with the project manager for planning and organizing the project activities and communicating with other business center managers and stakeholders’ project.
• Gap Analysis of client requirements.
• Participated in sessions to define the solutions approaches, and identifying assumptions, constraints, risk and issues. Analysis and specification of changes.
• Defined and documented vision and scope of the project.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition stage.
• Worked with the project manager to estimate, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Prepared the Business Workflow using MS-Visio.
• Worked with the clients on the final signing process in the User Acceptance stages.
• Involved in data mapping and data migration process with the help of SQL queries and MS OFFICE tools.
• Educated myself about testing environments
• Used Quality Center to invoke the scripts, initially performed the baseline testing, organized all the scripts systematically and generated reports
• Supported conducting regression testing and PRE/ POST RTM.
• Wrote test cases and test scripts for the User Acceptance testing.
• Involved in requirements analysis, system analysis and design and testing phases of Software Development Life Cycle (SDLC) and in iterative, agile and structured methodologies.
• Work with solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouses.
• Responsible for the quality and accuracy of data in all new large-scale projects for the Mortgage Division.
• Coordinated with the technical team, and developed new reports using Business Objects/Crystal Enterprises on SQL Server and DB2 databases, focusing on data verification and query performance.
• Reviewed, assessed, and signed off on all project artifacts (business, data, and technical requirements documents) for data conversion and data integration projects, providing gap & risk analysis and working with the technical team to address gaps and risks to ensure that all data quality requirements were met.
• Led portion of JAD meetings for large enterprise-wide BI projects and addressed gaps during requirements.
• Performed data profiling to determine how well data matches metadata, supports stated business rules, and relates to other data. This involved working very closely with business SME's and Data Stewards solid understanding of the data source(s) and how the business utilized the data.
• Reviewed and signed off on the process and data flow documents to determine if data integrity was met as data moved from system to system.
• Ensured the operational and compliance policies and procedures of the company during the project.
• Provide support to the business in researching data issues, specifically how to find and use the data they need, and investigate and resolve data quality issues.

Environment: Rational Rose, Rational Requisite Pro, Win Runner, Business Objects, ETL, MS Office and MS Project. Agile(Scrum) SDLC, MS SharePoint, MS Access, and MS Excel, MS Outlook.

Confidential, Chicago, IL

Business Systems Analyst

Roles and Responsibilities:

• Interview business area experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
• Interact with SME's to elicit business goals and define goal-level requirements.
• Collaborate with financial analysts, investment analysts and accountants to collect and understand business requirements.
• Created Report Mockups and wireframes to gather functional requirements and expedite the design & integration activities.
• Involved in gathering the requirements that were critical to the business process flow and using those requirements for the Business Requirements Document (BRD).
• Created Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system.
• Worked with oracle identity management software.
• Worked on Credit Risk Management (Commercial Lending), AML, derivatives.
• Assisted in the administration and review of Client Risk Scoring, Client Identification and KYC documentation oversight/management requirements.
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Created Use Cases, Activity Report, Logical Components to extract Business Process Flows and workflows involved in the project using Rational Rose, UML and Flow Chart Tools such as MS Project and MS Visio.
• Worked on data modeling and produced data mapping and data definition documentation.
• Helped Technical team in data modelling to build up logical data model and created Entity Relationship (ER) diagram in Erwin.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Developed the Enterprise Data Warehouse (EDW) logical data model to support rollout of the Data Warehouse Strategy.
• Interact and negotiate with Vendors to complete the tasks related to data conversion.
• Used Complex SQL join queries to extract and validate data from multiple databases.
• Extensively used SQL to create Scripts, procedures and indexes on database.
• Participated throughout the Extraction, Transformation, and Loading (ETL) process of data mapping, cleansing, standardization and implementations.
• Developed and designed the test cases for different modules of finance referring to the test plan document and analyzing the test rules
• Provide AGILE project management controls, project plans, timeline schedules, facilitate RAD sessions, and review software defects.
• Liaised with Clients, Front Office, Credit, Legal and Client On-Boarding as necessary as part of the KYC process.
• Conducted Functional Testing, Joint Functional Testing and UAT, documented and reported user feedbacks to management team.
• Reviewing the Requirements specifications, creating Master test plan, creating Test schedules according to the project deadlines.
• Used ALM/Quality Center to manage requirements, enhancements, and change requests.
• Identified test procedures that needed to be automated by isolating the repetitive actions.
• Used ALM/Quality Center for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
• Customized the test scripts using check points, synchronization and parameterization of data.
• Facilitated the User Acceptance Testing (UAT) and documented any issues or defects and eventually got sign off from the right parties.
• Involved in Developing and executing Test Plans, Test Case, and Test Scenarios, also performing functional, usability testing and ensuring that the software meets the system Requirement.
• Involved in converting User requirements into business requirements, functional and technical requirements using Rational Requisite Pro and also created business process models from the requirement specs.
• Created new, and modify existing SQL queries for use in the data integrity testing of the data warehouse application's ETL process.

Environment: Windows, Agile, Oracle, SQL, ALM/Quality Center, KYC, SharePoint, Microsoft Office suite, AML, Microsoft Visio.

Confidential, Reston, VA

Business Data Analyst

Roles and Responsibilities:

• Conducted face to face interviews, JAD sessions and brain storming sessions with stakeholders, subject professionals and other administration teams for the finalization of requirement Documentation.
• Have been part of grooming session and created user stories and acceptance criteria for the development of existing facilities.
• Prepared requirement documents for extraction, data analysis, and loading process on the data collected as a part of data mapping procedures, and prepared BRD and functional/non-functional required documents for the application using Microsoft Word.
• Utilized Agile methodologies to analyze and document any proposed requirement.
• Stakeholders requested development and altercations were traced and maintained using requirement traceability matrix (RTM).
• Developed, maintained and groomed the product backlog with the help of product owner.
• Helped product owner to prioritize and create user stories for the product backlog in JIRA.
• Participated in various scrum ceremonies like sprint planning meeting, sprint review and sprint retrospective.
• Maintain records on syndicated loans, including reconciliation, payment histories, and ensuring the accuracy of agreements versus system of record.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Developed and managed portfolio for all direct and syndicated loans.
• Involved in conducting GAP analysis to understand the AS-IS and TO-BE requirement documents.
• Involved in creating UML diagrams, activity diagrams, workflow diagrams, use cases, wireframes in MS VISIO for featuring design changes in management system.
• Analyzed credit card processing life cycle workflow and documented stamen of work, functional specifications and user requirements specifications.
• Worked with the users to do the User Acceptance Testing (UAT).
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Extensively involved in designing and developing the logical and physical data models to support the data marts and data warehouse.
• Performed all mapping and data dictionary work required for the development of new application products.
• Interprets business requirements from the user community and translates them into functional and technical specifications
• Extensively used SQL for extracting data and joining multiple tables for data analysis.
• Assisted data modelers with their entity relationship (ER) diagrams, conceptual data models, logical data models and physical data models to match with business requirements through Erwin software.
• Joined multiple tables from database using SQL JOIN queries to create business reports.
• Worked with SQL queries to integrate and obtain data for analysis and reporting.
• Performed SQL queries for retrieving, organizing the database with general commands like select, create, update, and joins.
• Worked with developing team to implement data quality processes during ETL, acquisition and delivery stages for business intelligence solutions and changes to data warehouse.
• Coordinated with the ETL team and developed new reports using business objects enterprises on SQL Server, focusing on data verification and query performance.
• Performed data profiling to determine how well data matches metadata, supports stated business rules and relation to other data.
• Created Data Mapping, Database Queries, and Data Dictionaries.
• Verified ETL Procedures and data quality, raised the probable data issues to the connected team for corrective actions (duplicates, Transform, cleansing, etc.).
• Work with business and ETL team to determine strategy and process to capturing and reporting data exceptions.
• Involved in ETL, Data Integration and Migration.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop to track progress of development life cycle processes for large project.

Environment: Agile (Scrum) SDLC, SQL Server, Tableau, MS Access, MS Word and MS Excel.