SUMMARY

• Over all 9+ years of Industry experience as Business Analyst with solid understanding of Business Requirements Gathering,Data warehouse, Data Modelling, Data Marts, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Having diverse experience in Banking, Mortgage and Financial Industry
• Extensive experience in leading and managing requirements across the broad spectrum of projects inAgile - Scrum as well as Waterfall environments.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections.
• Extensive knowledge of GAAP, financial accounting, financial statements, regulatory norms and experience workingwith compliance and regulatory requirements.
• Experience in working on application units such as BOL (Branch Online), CCP (Credit Card Processing), HEJ (Host Electronic Journal), DDA (Demand Deposit System), IDS (Investment Deposit System), TDA (Time Deposit Account system), ACH (Automated Clearing House) and others.
• Adept in consumer and commercial loan analysis,mortgage,credit analysis, profit and loss, balance sheet analysis, cash flow analysis, loan origination, repayment track, eligibility analysis, margin calculation, collateral verification.
• Extensive knowledge on commercial lending life cycle, lending origination,under writing, loan delivery andloan servicing.
• Strong knowledge in products likesavings account, checking account, money market, Time deposits, of deposit(CDs), KYC(Know Your Customer),AML(Anti money laundering), ATM, loans, credit, mortgage, asset & liability products, cash management, Internet baking, wire transfers(EFT, ACH, payments) and SWIFT.
• Strong knowledge in capital market products, Treasury, Asset Liability Management (ALM), Custodianship,Asset management, Derivatives,Futures, Swaps, Options,Alternative investment, Investment banking,Equity, bonds, Money market, settlements, profit and loss, balance sheet and cash flow statement analysis.
• Expert in SQL, DOORS, pivot tables, v lookups, import/export data Quality Center and MS Project
• Strong understanding of mortgagelendingand transportation business domain.
• 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.
• Experience in Developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extractdatafrom various sources and load into target tables
• Experience in designing of on-line transactional processing (OLTP), operational data store (ODS) and decision support system (DSS) (e.g., Data Warehouse) databases, dimensional and normalized data designs as appropriate for enterprise-wide solutions
• Strong understanding ofDataWarehousing concepts and Ralph Kimball and Bill Inmon methodologies
• Experience working in Agile SCRUM environment.
• 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 facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members
• 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.

PROFESSIONAL EXPERIENCE

Confidential - NYC, NY

Sr. Business Data Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Developed BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional using RequisitePro and Rational Rose to create/maintain: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Facilitated and managed meeting sessions with committee of SMEs from variousbusinessareas including MortgageServicing, Loan Monitoring and Asset Management.
• Worked asbusinessanalystto support the re-design of theMortgageAsset Management System.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Worked on Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables. Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Conducted project review meetings and gathered Business Requirement Documents BRD .
• Managed Scope and change throughout the SDLC process of the product.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Worked along with project manager to design, develop and implemente a concurrent processing scheme for checkpointing and restart/recovery. This involved the partitioning of certain application dependent Mainframe DB2 tables.
• 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.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Involved, both technically and administratively, with a project that converted the banks on-line teller system from an IBM mainframe based system to a client/server system.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Ensured that all Lines of Business specifications were consistent in form and function to the Diamond Base System. Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Ensured that project requirements are properly tracked and documented.
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
• The tests also included GUI testing: Testing for validation and display of screens

Confidential, Dallas,Texas

Business Analyst

Responsibilities:

• Preformed financial accounting and analysis for all outside family investments and partnerships
• Gathered requirements and modelled the data warehouse and the underlying transactional database
• Responsible for overseeing the preparation of investment portfolio reports for family members
• Analyze functional specifications delivered by implementation partners and validate the requirements intermsof Usability and functionality directed to satisfyBusinessrequirements on TD,IRA, Account Opening and Customer Interface Platforms.
• Coordinate with functional work streams on User Interface/User Experience aspects and participate in discussions on
• Expectedbusinessfunctionality and integration of work streams involvingDeposits, TD and Customer Information
• UsedmainframeIMS based green screens to create loan test data and to validate loan testing scenarios.
• Prepared Test Scenarios based on business requirements and business rules formainframe application.
• Extensively involved in project to query the SQL database to identify customer for unpaid loan and foreclosure home loan inmainframeenvironment
• Worked on issues withmigrationofDatafrom development toQA-Test Environment
• Provide business finance support for the implementation of newcommerciallendingplatform by performing testing and validations with financial interfaces, preparing business cases, and managing accruals and payments to vendor.
• Wrote SQL queries to verify the data in database and compare it tofrontend
• Monitored investment activity, asset allocations, and performance on a recurring basis and communicated all observations and recommendations to senior management accordingly
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Develop IST and UAT plans and test cases for deposit processing, IVR, ATM, bill pay and teller applications.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Delivered BRD, CR documents, UML diagrams as required to the development team on and off-shore.
• Gathered requirements and modeled the data warehouse and the underlying transactional database. Measured performance of the As-Is process and collected metrics such as defect resolution rate and cycle time.
• Created system use case, functional FRS and technical specifications for trading system.
• Extensively involved in the modelling and development of Reporting Data Warehousing System.
• Analyzed marketing programs and results using all applicable technology solutions to maximize ROI and to help the E-Commerce department meet its overarching goals of increasing sales, acquiring new customers, driving repeat site usage and increasing web site registrations.
• Co-mentored team with PM in establishing war room environment and agile tasking approach. Developed templates, procedures, design documents including Database Structure and Created/ maintained Data Dictionary.
• Supported PMO by mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Adept at performing all teller and cash handling activities, including the facilitation of deposits, withdrawals, traveler's checks, money orders, cashier's checks, and loan/mortgage payments.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process. Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on System Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and System Rules
• Understand and analyze underlying SQL Data; query SQL data to investigate issues or extract
• Created and maintained detailed spreadsheets to identify trends and develop daily, monthly and long-range forecasting reports to effectively manage liquidity.
• Spearheaded initiatives to streamline many investment and intra-family loan reports, increasing accuracy and making the processes much more efficient.
• Aided in the preparation of net worth statements for family members and entities on a semi-annual basis.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• 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.
• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans
• I was responsible for all project deliverables and the technical architecture supporting the Business Intelligence environments including all aspects of data warehouse construction
• Great understanding ofAgileprinciples especially the Scrum Ceremonies -Sprint planning, Sprint review, Sprint Retrospective and daily scrum calls
• Worked on SQL to fix Production issues from the vendor, and provide reports and solutions to the Line of Business.
• Performed data analytics with emphasis on credit scoring, credit risk, behavioral models,loanloss and general purpose risk models.
• Coordinated with the BusinessAnalystand prepared Logical and PhysicalData-models as per the requirements
• Coordinated with DBA ondatabase build and table normalizations and de-normalizations
• Involved in developing triggers, stored procedures, functions and packages using cursors and ref cursor concepts associated with the project using Pl/SQL
• 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
• Defining and scoping parameters for various modules of ERP exclusively on Billing and Insurance modules.
• Created different artifacts such as Business Requirements Documents BRD, Functional Requirement Document FRD, Use Cases and Traceability Matrix
• Supported a variety of platforms and technologies from mainframe applications, client based applications, to web based applications using SOA
• 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.
• Datamapping, logicaldatamodeling, created class diagrams and ER diagrams and usedSQLqueriesto filterdatawithin the Oracle database.
• 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

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
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements
• Involved in designing and implementing frontendForms using Visual Basic for Application in an Access environment to maintain historic Equity data
• 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.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Maintained quality levels with the use ofagiledevelopment practices such as automated testing, continuous integration, and refactoring, in addition to regression testing
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Provided key features, such as file format importers and exporters, impact and traceability analysis and inter-module linking tools to DOORS
• 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
• 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
• Involved in developing and generating PL/SQL and SQL queries for ETL processing, reporting, anddataanalysis.
• Worked with Technical and reporting teams to develop ETL jobs as per the technical specification documents.
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues.
• Retrieving the requireddatafrom the database using SQL for analyzing and updating thedata.
• Created mappings in Informatica to load thedatainto ADW as per the requirements from technical design document.
• 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.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Conduct research on securities through Bloomberg and analyze financial statements to compute client’s holding based on fully diluted outstanding shares of the securities for daily aggregate holding reports and filing purposes.
• Participated in the User Acceptance testing, planning, tracking and managing timelines prior to deployment as well as made recommendations towards associated improvement efforts for any related issues concerning the Empower application
• Involved in Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
• Involved in conducting 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
• Created and maintained SQL scripts/queries for Data Migration, conversion, mapping, validation and data verification at the backend testing on theoracledatabase
• Involved in Implementing 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).
• Worked on the Business ObjectsDataInsight to analyze and monitor the claims reports.
• Involved in creating 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.
• Conducting user interviews, gathering requirements, analyzing the requirements using Rational Rose.
• Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.