SUMMARY:

• Over 6+ years of experience in all phases of software development life cycle (SDLC), including Requirement gathering and documentation, Data Analysis, Data modeling, Data Mapping and Designing etc.
• Responsible for interfacing with the business unit to review requirements, lead JAD sessions, schedule meetings, prepare test plans, and create system requirement documents for use by system analyst to produce detail design documents for specific projects.
• Specializing in banking, finance and mortgage domain.
• Strong business analysis skills and experience in the Software Development Life Cycle (SDLC) and used methodologies such as Agile/Scrum, Waterfall etc.
• Conducted overall business management and data management by using Microsoft Excel and database tools including SQL, MySQL, and MS Access.
• Experience in Requirements gathering, Logical and Physical database design, Data Warehouse Design, Data Modeling, Data Mining, Data Standardization, Data Cleansing, Data Profiling & Quality, ETL, schema design, Data Integration, and Data Governance.
• Involved in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Expertise in successfully creating diagrams and graphs using Business Process Model and Notation (BPMN) to facilitate an understanding of performance and processes.
• Strong experience in Scrum/Agile methodology and proficient in writing user stories of core business systems.
• Implemented data modeling techniques including data visualization, data warehousing and data mapping.
• Expertise in conducting in - depth Problem Analysis, GAP Analysis, SWOT Analysis, Root Cause Analysis and Impact Analysis.
• Expertise with defect management tools such as HP ALM, Quality Center, JIRA etc.
• Good Knowledge in using ER modeling tools such as Erwin and ER/Studio, Teradata and MDM
• Familiarity with numerous data warehousing concepts like pivoting, data slicing/dicing, data cleaning/scrubbing, metadata, data mart, fact table, dimension table, star schema, snowflake schema, fact less fact table, etc.
• Utilized complicated SQL queries to analyze and validate test databases for data integrity
• Strong financial product knowledge of Capital Markets, IPO, Lending Systems, Loan Origination Systems (LOS), Fixed Income Securities, Deposit system, Fixed income derivatives such as swaps and Equity Markets.
• Good knowledge of The Mortgage Industry Standards Maintenance Organization (MISMO)
• Created Product Backlog, Sprint Backlog, Burndown chart, and managed User Stories.
• Worked with the Team Foundation Server (TFS) defect management system.
• Extensive experience within the Enterprise Data Warehouse (EDW) Department.
• Experience in providing analytical solutions with the help of ETL Reporting and Dashboards
• Expertise in SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services.
• Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Hands on experience in creating Test Plan and Test Cases using HP ALM based on the system/functional requirements
• In-depth knowledge of Relational Database, Data modeling, Data mapping, and design using UML (Unified Modeling Language), Rational Rose and Visio.
• Experience developing SQL queries for data mining delimited text file/excel file to SQL Server table columns.
• Experience working with Enterprise Project Management Office (PMO).
• Maintained Test Matrix and Requirement Traceability Matrix.
• Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing, System Testing, Black box testing, Positive Testing, Negative testing, Performance Testing, Stress Testing, Load Testing, Volume Testing, Data Driven Testing, Back end Testing and Regression Testing.
• Experience in working with various departmental teams, developing interactive relationships with business and IT colleagues, having a thorough understanding of needs, and perspectives of both the business users and the technical team.
• Team player, energetic, result-oriented, fast learner, excellent communication skills with strong research capabilities.

TECHNICAL SKILLS:

Platforms: Windows 7/8/10, UNIX

Methodologies: Agile, Scrum and Waterfall

Change Management Tools: Rational Clear Quest

Business Modeling Tools: Microsoft Visio

Database Designing Tools: MS SQL Server, MS Access, TOAD, Teradata, Oracle, DB2

Web Technologies: HTML, XML

Database/ Business Applications: MS SQL Server, MS Visio, MS Word MS Excel, MS PowerPoint,MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr. Business Systems /Data Analyst

Responsibilities:

• Analyze client’s existing business systems, procedure, data and propose changes that would result in overall system enhancements.
• Evaluate new or modified solutions, data structures and decision - support mechanism to support the industry best practice.
• Followed Agile (SCRUM) methodology for the entire Software Development process (SDLC).
• Involved in analyzing different source systems and assist the BA and technical team to understand the systems and data.
• Responsible for data modeling - creating logical and physical model.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using Erwin.
• Using the tool HP ALM (Application Lifecycle Management) to gather, map and trace all solutions and strategies defined towards a particular problem and use the same solution as a reference incase a similar problem arises.
• Involved in Extracting, Analyzing, Merging and Summarizing Data conversion and Data migration aspects from the existing Financial Systems.
• Determine if compensating factors are sufficient to warrant an exception for loan origination approval.
• Created tables, views, procedures and SQL scripts.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Encapsulated new and existing Business rules based on Industry Standardized MISMO rules as well as tailored validation rules.
• Created data set reports for users by writing SQL queries which then were used for UAT and defined data dictionaries for identified sources by working with data stewards and subject matter experts.
• Worked with developers to create requirements and ran SQL queries to extract data from specific tables from database (DB2).
• Gathered requirements for data analysis & reporting needs and presented information rich reports for decision making
• Create UML diagrams like Use Cases, Activity and data flow diagram using Rational Rose and MS-Visio and consistently translate business requirements into IT solutions.
• Working closely on reporting tools such as SQL for underlying database tables to resolve data issues.
• Assist in customizing operation procedure to increase operating efficiency.
• Created business process flow chats using VISIO for Credit Analysis, Mortgage Origination, Loan Endorsement, Loan Origination (LOS).
• Work with developers, BI team, solutions/delivery teams to implement data quality processes during acquisition, ETL, and delivery stages for Business Intelligence solutions and changes to Data Warehouses.
• Created and maintained a Requirement Traceability Matrix (RTM) to see if all the requirements are being captured and are being worked on.
• Brainstormed with stakeholders & gathered requirements for data analysis & reporting needs and presented information rich reports for decision making.
• Performed backend testing using SQL queries to validate data.
• Well versed with web services, Rest, SOAP and WSDL along with web methods used to develop business logics.
• Validated XML schema for system data documentation including the data requirement document.
• Followed Unified Modeling Language (UML) methodology using Requisite Pro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Present the process improvement solutions to the client, perform Project Management Office (PMO) activities, and develop training programs for the process solutions.
• Scripted Business Rules for Client Side & Server-side validations, Web Services, assisted UI team in drafting agreements for various web methods in XML.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Involved in functional requirement and test case development for data flow in the form of XML messages between internal systems for appropriate distribution of data.
• Worked with Informatica developers to design mappings using Informatica coming from different sources like databases, flat files into Oracle staging area.
• Performed data analysis task using SQL queries on Enterprise Data Warehouse (EDW) and various source systems.
• Performed Database integrity testing by executing SQL statements.
• Used JIRA as a bug reporting tools.
• Prepared project status reports and represented BA team in PMO meetings
• Create Test Plan and Test Cases for the desired functionality described in the Business documents.
• Translate information between business teams and technical teams using object-oriented models or other techniques.
• Performed functional testing of SOAP and RESTFUL Web Services using SOAP UI.
• Completed Project Status Reports & led PMO meetings to update senior management and other stakeholders on the progress, issues and deliverables of the project.
• Scheduling and Facilitating WPR (Work Product Review) meetings for review of a specified document before submitting the final Document to the State (client)

Environment: Agile, Scrum, HP ALM, LOS, Informatica, Rational Requisite Pro, MS Project, PMO, JAD, SQL, Enterprise Data Warehouse, MS Visio, MS Excel, MS Access, Rational Clear Quest, XML, SOAP, API’s, REST, Web Services, JAVA, HTML, Tableau, JIRA, MISMO, Erwin, Microsoft SQL Server, Oracle, MS SharePoint, UNIX, DB2.

Confidential, Warren, NJ

Business Systems Analyst

Responsibilities:

• Collaboratively worked with business analysts, developers, leads and customer SME’s.
• Implementing Agile Methodologies to break the project into sprints, develop and deploy components on time.
• Analyzed business rules, functional requirements and specifications to create test plans and test cases.
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, and Sequence Diagrams.
• Performed Root Cause Analysis and Re-engineered business processes, and implemented performance measures, presented project presentations to executive management.
• Wrote SQL statements by inserting, deleting, updating data from the database to test new entry, update, and delete actions of the client application or interaction of application and database with database server
• Prepared statistical reports for presentation to management, boards and committees using report writing tool such as Excel and SSRS.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Responsible for entering, tracking bugs in ALM/Quality Center and reporting the defects to the developers for Modification Request.
• Analyzed various Steps in the Loan Lifecycle and designed the system to identify & monitor the riskier loans.
• Assisted with the new business process and working with Finance and Business Managers.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Created and maintained SQL Scripts and UNIX Shell scripts to perform back-end testing on the oracle database.
• Use Agile systems and strategies to provide quick and feasible solutions, based on Agile system, to the organization.
• Responsible for coordinating JAD sessions with business users to analyse the investment tracking system, application life-cycle, gather and define the key performance indicators, document and present the requirements specifications.
• Performed data mapping which specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Responsible for interacting with client for requirements gathering, analyzing requirements, and creating detailed specifications.
• Connected to SQL Plus in UNIX and created and executed complex SQL queries.
• Performed back-end testing by extensively using SQL commands to verify the database integrity.
• Performed Project Management Office (PMO) activities and Coordinated with the PMO group in defining timelines & schedules for the project.
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, Access and Lotus Notes.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Worked with Database team, involved in writing SQL queries, extracting data, creating modifying tables, functions procedures. Performed data validation and Web Services testing.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios.
• Wrote use cases and relevant UML diagrams such as Use Cases, Activity and Sequence diagrams
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.

Environment: Agile/Scrum, UAT, Web Services, ORACLE, MS SQL Server, MS Access, SSIS, SSRS, Erwin, JAVA, Data Warehouse, LOS, ETL, UNIX, XML, SOAP, REST API, MS office, MS Visio, MS Excel (Macros, VLOOKUPS, and Pivot Tables), HP ALM/Quality Center, Tableau, Windows.

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Facilitated requirement gathering workshops and interviews to identify, translate and document business and user needs into detailed, testable and verifiable business, functional and system requirement specifications.
• Developed detailed Technical Requirements Document/User Stories/Document of Understanding used for envisioning the development effort.
• Conducted User Interviews, Gathered Requirements, analyzed, and documented business requirements based on the analysis of Loan Processing Workflow Model.
• Conduct Agile Scrum meetings to discuss project progress and plan
• Analyzed and prioritized key reports for day to day servicing needs for loan monitoring processing and Inspection.
• Addressed all aspects of the Loan Lifecycle, starting from identifying a deal right up to loan closure.
• Provided Functional Specification to development team to build Enterprise Reporting Systems.
• Used Rational RequisitePro/DOORS for overall Requirements Management and to build the Requirements Traceability Matrix.
• Involved in Backend Testing to verify data integrity by using SQL.
• Facilitated communications between solution architects, developers, quality assurance analysts and business users as required throughout the requirement analysis, design and testing phases to ensure the defined requirements are interpreted correctly.
• Collaborating with IT Data Modeling team to ensure data model design is consistent and accurate with the business requirements.
• Creating functional requirements and source-to-target mappings including data transformation rules to the development team for implementation.
• Participated in various meetings and discussed enhancements and modifications request to resolve issues and expand capability of the systems.
• Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.
• Experience in conducting scrum meetings and sprint planning.
• Collaborating with business partners and cross-functional teams and supporting system documentation.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server
• Organized and facilitated meetings with the management and development teams.
• Conducted requirement gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD) using Rational Requisite Pro

Environment: Agile, Quality Center, SQL Query, UAT, JAVA, ORACLE, DOORS, MS SQL Server, MS office, MS Visio.