SUMMARY

• Over 8+ Years of professional experience as Business Analyst with expensively experience in Banking and Finacial domain .
• Experience in Capital market such as Equities, Equity Derivatives Fixed Income - Corporate Bonds, Government Securities, Mortgage Backed Securities (MBS), Collateralized Mortgage Obligation (CMOs), Asset Backed Securities (ABS), Collateralized Debt Obligation (CDOs).
• Experience in using programs such as Mortgage Express, RCO, MPX, Contact Central, Empower
• Experience in Mortgage Backed Securities, Capital Markets, Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
• Experienced in business analysis, data analysis, use case analysis, requirements elicitation, gap analysis, configuration and change management, process re-engineering, design, testing, problem-solving and project management.
• Experienceusing XML related technologies likeXML, XML Schemas, DTDs, XPath, XQuery, XML parsingAPIs likeDOMandSAX.
• Experienced validating XML schemas adhering to specific data types, and created diagrams to graphically represent XML schema for better understanding of the data type and its validation.
• Experienced in creatingSSA mapping DocumentusingMS EXCELby collecting information from Functional Analyst and feed Data Modeler according to his requirements.
• Extensive experience with Business-to-consumer B2C sales of tangible goods/online services and Business-to-business B2B scenarios.
• Extensive experience in creating Work break down structure (WBS), Use Cases, process work flows, Use Case Scenario and Use Case Narrative, using the UML (Unified Modeling Language) methodologies.
• Experienced with the Loan IQ UAT/Production environments for the Loan IQ (Complex Loans) implementation and managed change software and version control as well as ensuring accurate system
• Strong domain experience across Digital Banking, Core Banking, Retail and Business Banking, Payments, Mortgages, Loan Life Cycle, ITIL, GRC and CRM.
• Extensive experience in leading and managing requirements across the broad spectrum of projects inAgile-Scrum as well as Waterfall environments.
• Hands-on experience on loan origination system (LOS), fixed income products like (treasury, Bonds, notes and bills) and mortgage backed securities, Municipal Bonds, Corporate Bonds, Junk Bonds and Convertible Bonds
• Experience in commercial lending system Loan IQ and Infolease.
• Experience in project management activities including scheduling project kick off meetings, creating project schedule, coordinating with cross functional groups and also well versed in project management tools likeMS - Projectfor status reporting and planning.
• Experience in all phases of theSoftware Development Life Cycle (SDLC)including requirements gathering, design, development, testing and deployment.
• Experience in responding to RFP/RFI, creating SOWs on Risk & Compliance Domain areas such as AML, Fraud by collecting information from various stakeholders.
• Extensive experience in all aspects of consumer loan origination, underwriting and collections.
• Experience in MortgageLoanOrigination,LoanServicing, Investment Banking,Brokerage services, Commercial Banking, Retail Banking, Asset Wealth Management, Cash Management, Capital Market and Credit Risk Fundamentals.
• Subject Matter expertise in Investment Banking, Fixed Income, Trade Life Cycle, Mortgage Origination, Mortgage Service, Secondary Mortgage Market, Loan, Credit Cards, Insurance, and Portfolio Investment Analysis.
• Extensive experience inLending (secured and unsecured), loan life cycle, invoicing and accounting (GL/ IE posting & reconciliation)
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities Visio .
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Worked and extracted datafrom various database sources like Oracle, SQL Server, DB2, and Tera data/Big Data.
• Experience in SQL to fix Production issues from the vendor, and provide reports and solutions to the Line of Business.
• Diversified experience in Business Intelligence Development, Data Analyst, Business Analyst, ETLScripts, ETL Batch Verification, Ad-hoc reporting and DWH Designing & Development.
• Experience in developingUse Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis
• Expert in SQL, DOORS, pivot tables, v lookups, import/export data Quality Center and MS Project
• Experience in design, development, support testing in the field ofDataWarehousing Technologies in the Banking, Financial Domains
• Expert in writing complex SQL queries and optimizing the queries in Oracle, SQL Server and Teradata
• Exposure of end to end SDLC, Agile methodology (Sprint/Scrum) based projects.
• Good experience in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics and Excel data extracts.
• Documented BRD’s, Requirement Traceability Matrix (RTM), Use case documents andUserstories.
• Experience in Developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extractdatafrom various sources and load into target tables
• Expert in performance tuning of Informatica mappings and also excellent in identifying source, target bottlenecks
• Experience in designing of on-line transactional processing (OLTP), operationaldatastore (ODS) and decision support system (DSS) (e.g.,DataWarehouse) databases, dimensional and normalizeddatadesigns as appropriate for enterprise-wide solutions
• Strong understanding ofDataWarehousing concepts and Ralph Kimball and Bill Inmon methodologies
• Experience working in Agile SCRUM environment.
• Involved in writing shell scripts on UNIX for Tera data ETL tool and datavalidation.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus, SQL Developer and Toad.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Experienced in testingDataMigrationand Integration with external applications.
• Experience in test execution - Integration, Functional, System, Regression, Compatible testing and Database Testing using SQL and User Acceptance Testing (UAT)
• 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.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.

TECHNICAL SKILLS

Testing Tools: HP Quality Center, Mercury Quality Center /Test Director, Clear Case

Databases: DB2, Oracle, SQL PL, SQL Server, Teradata, Microsoft PDW,SCMVC VSS, Team foundation server, Clear Quest, Clear Case, IBM CMVC

SDLC Methodologies: Waterfall, Agile Scrum,SAFe, Kanban

Operating Systems: UNIX, Linux, Windows, AIX

ETL Tools: Informatica, SSIS, Ab Initio, Data Stage

BI Tools: Tableau, Cognos, Business Objects

Other tools: Erwin, ERStudio, Infosphere Data Architect, MS Office, Excel, VBA, and VisioFinance Payables, receivables and general ledger

Languages: UNIX Scripting, Perl, SQL, XML

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr.Business Analyst

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans
• Analyzed and documented the Business Requirements, ensuring that the requirement statements are complete, traceable, and unambiguous and that they conform to standards and followed rational unified process RUP with agile scrum model.
• Responsible for business process analysis, requirements planning, elicitation, definition and management, and JAD session facilitation.
• Involved with the technical team in understanding the XML file format required for Split loss process and Policy process.
• Design and develop the data load process using XML Style sheets and ACORD.
• Involved in gathering business requirements by collecting information from the business users.
• Built prototype user interface using MS Paint and PowerPoint to enhance requirements elicitation.
• Defined business processes to facilitate requirements elicitation for business intelligence systems in JAD sessions.
• Understand and leverage output of collateral risk tools (FNC GAAR, ACRP, MLS, MXP, Real Quest, CMS, and EIV (MX) Mortgage Express (SME), in performance of appraisal underwriting functions.
• Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, financing structure, Portfolio Analysis, etc.
• Perform analysis on xml, json messages and normalize the data into structured tables using oracle and Teradata database tables. The data into structured tables using oracle and Teradata database tables
• Worked closely with onshore and offshore developers, and business SME's and IV&V testers to ensure that all Loan IQ API data mapping documents were accurate and up to date.
• Involved in documenting all user roles for new loan origination system LOS Mortgage Express (MPX).
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Designed and developed Use Cases and Use Case scenarios, Activity Diagrams, Sequence Diagrams, High Level and Low Level Process Flow Diagrams, OOAD using UML and Business Process Modeling.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance.
• Responsible for all project deliverables and the technical architecture supporting the Business Intelligence environments including all aspects of data warehouse construction
• Used JIRA to report the hours and issues that are related to the project and Worked with mortgage express vendors to get all the connectivity needed details for the applications for both the production and non-production environment.
• Designing the SSAS (SQL Server Analysis Services) Cubes; SSRS (SQL Server Reporting Services) Reports &Adhoc Querying facilities.
• Worked on ULDD mapping document to map the compass extract fields (Secondary system that is used for pooling and hedging the loans) to ULDD fields. The purpose of this extracts was to pull data from LOS application, save it to ODS database and transform data based on the business need so that data eventually can be transformed in to MISMO standard.
• Created mapping document with Vlookup, hyperlinks to combine 3 different mapping documents, LOS to MISMO, MISMO to Corporate and Corporate to Downstream.
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
• Invloved in complex SQL queries to research, analyze, and troubleshoot dataand to create business reports.
• Used Informatica power center for (ETL) extraction, transformation and loading datafrom heterogeneous source systems.
• Worked extensively throughagilemethodology by dividing the application into iterations and acted as theScrum Masterin each iteration throughout the SDLC.
• Worked withbusinessleads and SMEs to understand and document current state, including identification ofbusinessand technical gaps for future state enhancements work directly withbusinessSMEs to understand and document requirements asuserstorieswith detailed acceptance criteria
• Involved in MortgageBanking Operational Data Store involving data transformations for various channels and loading in the integration layer and semantic layers for further presentation of data to clients.
• Gathered requirements around customization of salesforce.com pertaining to dashboards, reports, custom fields and custom-built applications such as Quotes/RFPs.
• Performed data analytics with emphasis on credit scoring, credit risk, behavioral models,loanloss and general purpose risk models.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process RUP methodology in all areas of the software development life cycle SDLC .
• Performed Gap Analysis of the processes to identify and validate requirements.
• Coordinated with the BusinessAnalystand prepared Logical and PhysicalData-models as per the requirements
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Actively facilitated completeUATprocess - creatingUATschedules, testing guidelines, managing feedback, follow-up, and resolving open issues
• Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high level business requirements to the product backlog using JIRA Agile.
• Invloved in Datamapping, logicaldatamodeling, created class diagrams and ER diagrams and usedSQLqueriesto filterdatawithin the Oracle database.
• Demonstrated expertise in user story definition, preliminary designwireframingand conceptual feasibility.
• Analyzed and designed Use Case diagrams, Class diagrams, Sequence Diagrams, Business Objects, Domain Object Model, and MS Visio to depict process flows and PowerPoint presentations.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) and verified the functionality coverage.
• Conducted design reviews to ensure that deliverables meet business needs, including in-house data share application development
• Prepared documents such as Project Scope, Project Vision, Project Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards
• Communicated business and functional requirements to the development team for design
• Facilitated implementation of new functionality through training sessions, demos, and training manuals

Environment: RUP, UML, Rational Requisite Pro, XML,DB2,ETL, PL/SQL, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor) Enterprise Architect, Agile, PHP,SQL,Sharepoint, UAT, MS Project, MS Office, DOORS, SQL Oracle 8i

Confidential, Detroit, MI

Business Analyst

Responsibilities:

• Involved in application support toanalyzeand fix data correction issues in livedatabaseby interacting directly with various clients.
• Involved inDatamapping specifications to create, execute detailed system test plans and Thedata mapping specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Performs JAD sessions and requirement elicitation, gathers and documents system requirements from users for software selection and development projects.
• Gathered functional requirements and wrote BRD's, FRD's (functional requirements specifications) and FSD's (functional system designs) for numerous Loan IQ downstream applications.
• Analyzed Business, Technical, and Functional requirements for execution of loan origination system LOS for the Mortgage Department.
• Involved in working on interfaces, xml data mapping, web services, integration on multiple interfaces
• Detailed XML and SQL analysis to identify data discrepancies between the newly designed application and legacy data.
• Generating MISMO standard file as described by ‘Uniform Mortgage Data Program Initiative’ from ECF file for respective Interface.
• Uploading the Database tables, from where the MISMO standard XML file picks the Loans from.
• Participate in the maintenance and improvement of best-practice guidelines for B2B Integration processes and procedures.
• Created‌ ‌‌API‌‌Documentation‌ in JSON, XMLusing‌ ‌the‌ ‌POSTMAN‌ ‌API‌ ‌toolandUsed‌ ‌HTTP‌ ‌verbs‌ ‌such‌ ‌as‌‌GET,‌ ‌POST,‌ ‌UPDATE,‌ ‌DELETE‌‌to‌ ‌connect‌ ‌service‌ ‌oriented‌ ‌architecture‌ ‌(SOA)‌with‌ ‌web‌ ‌services.‌ ‌ ‌
• Conducted JAD sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery teams to meet the individual needs of the business functions and worked in agile scrum model.
• Analysis and Design new modules, and support existing ones on MPX (Mortgage Express).
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Tested ComplexETLMappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Involved in Jenkin Build using Gradle script and Deployed the application in Dev-Unix machine using AMP (Application Maintenance Tool)
• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Conducted user interviews, facilitated Joint Requirement Planning (JRP) to reduce the Scope Creep and document analysis in requirements elicitation.
• Conduct needs assessment where appropriate by collecting information pertaining to work procedures, workflow, reports, and other customer business needs.
• Customize and configure Loan IQ API's using LoanIQ SDK and woked extensively on Loan IQ Data Model.
• Responsible for differentDatamapping activities from Source systems to Teradata
• Used Informatica power center for (ETL) extraction, transformation and loading datafrom heterogeneous source systems.
• Analyzed financial statements, extracted relevant information, prepared financial models for financial projections.
• Conducted statistical analyses and complete studies of real estate and mortgage related data
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades
• Created Excel Templates using macros and extensively used VB scripting to create various reports according to end user requirement.
• Worked closely with the ETL SSIS Developers to explain the complex DataTransformation using Logic.
• Verified theDatacompleteness,DataMigrations,Datatransformations andDataQuality
• Responsible for building data warehouse, extract and load data and design dashboards using MSBI tools.
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Responsible for maintaining current and complete project management data documents to team and upper management, analyzes and reports project performance metrics as requested.
• UtilizedSoftware Development Life Cycle (SDLC) to configure and develop process, standards procedures.
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements
• Performed ETL data loads from flat files, DB2, Teradata, PL/SQL etc. to transform data into complex scripts and codes for software application testing
• Involved in Data entry, query and reports request screens and tuned the SQL queries.
• Analyzed the data warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed
• Worked on Elicit,documentbusinessrequirements. Prepared applicable visual models, workflows, process, use cases, and data flow diagrams usingUserStories
• Responsible to create sub-tasks inJIRAfor each User story during the Sprint Planning sessions and assign sub-tasks to the developers.
• Responsible for maintainingAgilebest practices for Scrum team, product owner and stakeholders within the organization.
• Involved using ETL tool Informatica to populate the database, datatransformation from the old database to the new database using Oracle.
• Optimized and update logical and physicaldatamodels to support new and existing design requirement.
• Responsibilities included risk analysis for in house Loan Origination Mortgage System, Mortgage pooling investments
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management
• Involved in SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes
• Worked closely with product owner in Prioritization of User Story in Product backlog & Refining the user story in Sprint Backlog for every sprint.
• Worked with OLAP tools such as ETL,Datawarehousing and Modeling, Used Informatica / SSIS to extract, transform &loaddatafrom SQL Server to Oracle databases.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager
• Gathered and analyzed data and came up with business use cases, proposed projects, and systems requirements for mortgage loan origination system using RUP standards.
• Gathered high levelbusinessrequirements to replaceEmpowertime entry system with payroll team and payroll manager (Subject Matter Expert-SME) input.
• Performed system testing, integration testing, automation testing andUAT.
• Responsible for defining and designingcommerciallendingloan approval process which resulted in data collection and analysis compliance
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Worked with developers to make sure that they understood the Use Cases.

Environment: RUP, MS Visio, Clear Quest, SQL, MS SQL Server, XML,DB2,Business Objects,Sharepoint, DOORS, Oracle 8i, SDLC, MS Office Suite, MS Project, Quality Center, PYTHON,PHP,AgileScrum, UML, Microsoft Outlook

Confidential, Irving, TX

Business Analyst

Responsibilities:

• Gathered requirements and modelled the data warehouse and the underlying transactional database
• Responsible for overseeing the preparation of investment portfolio reports for family members
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Preparing the SDD (Story Definition Document) for the Loan Origination System. Analyzed business requirements for testing phase during execution of loan origination system (LOS).
• Gathered and analysed data in support of SOP’s, business use cases, proposed projects, and systems requirements for mortgageloan origination system using RUP standards
• Conducted Agile refinement sessions for requirements and stories with the business and change management teams.
• Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
• Streamlined the elicitation of inter-departmental stakeholder needs and KPI definitions by implementing hybrid agile methods to gather, and articulate usage and financial calculation requirements, implement UML business visualization techniques and perform detailed Use Case Analysis and transaction mapping techniques.
• Utilizing wireframes and Visio process diagrams to conduct needs assessment where appropriate by collecting information pertaining to work procedures, workflow, reports, and other customer business needs.
• Facilitated and managed meeting sessions with committee ofSMEsfrom various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Involved in extract, transform, and load (ETL) data from multiple federated data sources (JSON, relational database, etc.) with Data Frames in Spark.
• Requirement gathering, BRD preparation for various functionalities like DDA, Fund transfer, Customer maintenance, Loan IQ, Loan origination and non-functional requirements for Flexcube.
• Worked on issues withmigrationofDatafrom development toQA-Test Environment
• Wrote T-SQL statements for retrieval of data and also involved in performance tuning of TSQL queries
• Facilitated interviewing and brainstorming sessions with the stakeholders and SMEs in understanding the requirements pertaining tomortgageapplication process.
• Worked on the ETL Informatica mappings and other ETL Processes (DataWarehouse)
• Createdbusinessprocesses, data diagrams and mappings, as well as proof of concepts and wireframes for new line ofbusinessinvolving mortgage loan pooling for various investors and various product types to sell to new and existing investors.
• Analyzed data from the retail mortgage lending channel, structure and presented change proposals to management.
• Performed requirements modeling and developed Analysis Diagrams, Activity Diagrams, Sequence Diagrams, and State Diagrams, Data Models, and Use-Case relationships using RUP tools in Agile Methodology.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema, star schema and database objects.
• Created and documented User and System Level Use Cases/Scenario views showing how an actor interacts with the Provider system to carry out a business activity.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Designed (ETL) packages for loading data from DB2, Oracle 10g and Flat files to SQL Server 2008 R2/2012 Data base
• Wrote SQL queries to verify the data in database and compare it tofrontend
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Invloved in Datagovernance functional and practical implementation and also responsible for designing commonDatagovernance frameworks
• Created user stories with detailed acceptance criteria (Customer satisfaction criteria) to elicit clear and deliverablebusinessneeds.
• Coordinate test cases for Risk Management, Mortgage: all Commercial, Personal Systems and system security procedures.
• Worked onDataModelling tools ErwinDataModeler to design thedatamodels.
• Invloved source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse
• Documented User Stories with Acceptance Criteria Technique, BRD, Functional spec, UML Diagram, Gap Analysis with process flow
• Deployed builds and patches in Production and UAT environment, created release packages with proper versioning document. Used perforce for version control.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• Understand and analyzed SQL Data query SQL data to investigate issues or extract
• Conducted research and analysis on exchange-traded (ETD) and over-the-counter (OTC) derivatives such as Futures,

Environment: MS SQL Server 2012, SSIS 2012, Sharepoint, DTS, T-SQL, SDLC, Visual Studio 2012, Share point, SQL ServerManagementStudio,AgileScrum,Informatica,Oracle SQL Developer, PYTHON,PHP,SQL Server Business Intelligence Development Studio (BIDS), DOORS, Azure, XML, HP Quality Center,Agile/Scrum, Microsoft Excel, Microsoft access.

Confidential, Plano, TX

Business Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing
• Designed and implementedfrontendForms using Visual Basic for Application in an Access environment to maintain historic Equity data
• Createdbusinessrequirement document,userstoriesand test scenarios.
• Identified incidences of non-compliance within regulatory control on various commercial Investment Bankloansystems(LoanIQ, ARC, Deal Works, I-Vault, Exposure Now and Integrated Credit Risk Desktop).
• Created SQL tables with referential integrity queries using SQL, SQL PLUS and PL/SQL.
• Design, coding, unit testing of ETL package source marts and subject marts using Informatica ETL processes for Oracle database.
• Imported and Exporteddatafrom Microsoft Excel and Microsoft Word to Quality Center where deemed necessary for projectmigrationand test set replication for reusable template assets
• Performed Back-End testing by writing and using SQL queries.
• Documented various sub-sections in the design document like overview of use case, what requirements were satisfied, preconditions, actors, main flow happy day scenario, sub flows, and user interfaces.
• Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MYSQLdb package to retrieve information.
• Worked in importing and cleansing of datafrom various sources like DB2, Oracle, flat files onto SQL Server with high volume data
• Designed Informatica mappings for data loads and data cleansing and experience in using VISIO, MS office and worked in agile scrum model.
• Designed reports and assistedEmpowerBI team for reports.
• Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Documented compliance guideline showing the data flow process for the selection and process of various Loans.
• Documented process flow of Mortgage Default, Foreclosure and Servicing Guidelines with performing and non-performing loans.
• Gathered and documented the requirements that were critical to the business mission and used those requirements to design application software using a Use Case in Requisite Pro
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages.
• Used XML Web Services using SOAP to transfer the amount to transfer application that is remote and global to different financial institutions.
• Developed and maintained relationships with assigned internal business partners including wealth and intuitional management, mortgage, and business banking markets
• Conducted Mortgage relevant to off-shore teams so future releases are delivered defect free.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• Created use case scenarios and documents work flow and business process.
• Documented business workflows textually as well as in UML diagrams (State diagrams) according to RUP, for the stakeholder review
• Prepared business process models using MS Visio and Perform Gap Analysis
• Prepared (BRD), Involved in UAT test Phase for validation.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Created Mock-ups and Wireframes usingwire-framingtool Balsamiq and Mockflow.
• Provided key features, such as file format importers and exporters, impact and traceability analysis and inter-module linking tools to DOORS
• Elicitation and documentation of business and system/functional requirements for all approved changes to business processes, systems and policies for the client.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro
• Involved in Business analysis and Requirements gathering.
• Datamigration- Includesmigrationofdatafrom legacy environment to Oracle System.
• Involved inDataValidation using SQL queries.
• Develop User Acceptance Testing (UAT) and system requirement documents to ensure thatbusinessrequirements were exceeded, and system releases were successful.
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQLdb package.
• Used the ETLDataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loadingdataintodatawarehouse database.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.

Environment: Rational Clear Case,Doors, IBM WebSphere, XML, Sharepoint, Java, J2EE, JSP, DOORS, RUP, EaglePACE, UNIX, Oracle, MS Visio, DB2, Sybase, Loan IQ, Agile, PYTHON,PHP,SQL Server Reports, SDLC, WinRunner, LoadRunner, Quick TestPro

Confidential, Murrysville, PA

Business Analyst

Responsibilities:

• Used SQLs to test various reports and ETL load jobs in development, QA and production.
• Collaborated with various partners including economic, finance, risk, loan servicing, and business strategy team members to gain understanding of business processes, build trust, and attain insight into in the impact to home mortgage default servicing forecast.
• Responsible for gather user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Performed requirements gathering and analysis from the business users of the system and SME's while adhering to SDLC Software Development Life Cycle industry best practices. Used the Agile-scrum methodology for software development.
• Conducted security assessment of the critical parts of the credit card application to check for any loop holes with respect to prevent financial loss through fraud or lost revenue due to unreliable business systems
• Used Agile methodology processes to promote sustainable development by managing sprint backlog, task boards and providing delivery of product in short iterations.
• Designed and developed various analytical reports from multiple datasources by blending dataon a single worksheet in Tableau Desktop.
• Assists in the elicitation, analysis, and realization of critical business needs
• Documented reconciling financial data submitted by Servicers and Trustees for a mortgage loan servicing application.
• Responsible for collecting information from the buyer, Title Company, Taxing authority and Home Mortgage Consultants, Private Mortgage Bankers.
• Gathered requirements to create BRD andUser Story AcceptanceCriteria refining specifications, business processes, and recommendations for system application solutions
• Facilitated meetings with project team and business partner stakeholders
• ConductedJAD sessionswith stakeholders to discuss requirements and project status
• Used JIRA project management tool to trackuserstories.
• Daily use of Oracle 10g, SQLPlus, SQL Developer, SoapUI Pro, XML, IBM RTC, Spring Tool Suite, AGILE/SCRUM methodology.
• Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
• Created test plan and scripts for user acceptance testing (UAT) to ensurebusiness requirements are exceeded.
• Acted as product owner to prioritize and refineUser story in Product Backlog.
• Created and maintained SQL scripts/queries for Data Migration, conversion, mapping, validation and data verification at the backend testing on theoracledatabase
• Created wireframes for the future state to capture new data fields within the banks' Loan Originations (LOS) system.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for variousmortgageproducts likeMortgageBacked Securities, Asset Backed Securities, and Megas & Tranches
• Implemented Agile Methodology for building an internal application.
• Worked extensively on scoping designs of application platform for A&H vertical (entire process was on manual mode and MS excel was the platform for processing).
• Designed elaborative process workflow diagrams and documented scoping parameters for the ERP application to be designed by the IT partner.
• Facilitated business in user story refinement session, gathered requirements
• Worked on the Business ObjectsDataInsight to analyze and monitor the claims reports.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
• Presented test cases at cross functional test cases review meetings with test team, system analyst and product management teams and have emphasized need for better change control process for critical user stories.
• Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams.
• Identified research, investigate, analyze, define and document business processes.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.

Environment: Windows, Oracle, SQL, Basel II, Agile,SDLC, MS Visio, MS Access, MS Project, SOX, PYTHON,PHP,DOORS, MS SharePoint, SOX, UML, ICAAP, XML, Requisite pro, Sharepoint, Rational ClearQuest