SUMMARY

• Having 8+ 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.
• Exposed to diverse business processes in the Banking industry.
• Extensive experience in leading and managing requirements across the broad spectrum of projects in Agile - Scrum as well as Waterfall environments.
• Strong knowledge of Fixed Income instruments, Bonds, Equities, Trade Cycle, Derivatives, REPO & Reverse REPO, CDs & Futures/Options.
• Proficient in developing complex database objects like Stored Procedures, Functions, Packages, cursors and Triggers using SQL and PL/ SQL.
• Exposure in analysing detailed finance and accounting processes to identify improvement opportunities in internal and external reporting
• Extensive experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Experience in IDS Infolease and Rapport used for booking Equipment Leases such as True Leases, Lease Purchases, Leveraged Leases, Conditional Sales and Municipal Leases along with their cash flows.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections.
• Expert in SQL, DOORS, pivot tables, v lookups, import/export data Quality Center and MS Project
• Strong understanding of mortgage lending and transportation business domain.
• Experience in design, development, support testing in the field of DataWarehousing Technologies in the Banking, Financial and Telecom 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. Worked as a scrum master
• Experience in Developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from various sources and load into target tables
• In depth knowledge in the Investment Banking Industry, Mortgage Loan Origination, Loan Servicing, Brokerage services, Commercial Banking, Retail Banking, Asset Wealth Management, Cash Management, Capital Market and Credit Risk Fundamentals.
• Experienced in valuation of equities, management of IPO's, Commercial Lending loan processes.
• 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 of Data Warehousing concepts and Ralph Kimball and Bill Inmon methodologies
• Experience working in Agile SCRUM environment.
• Liaising between Deutsche Bank Middle Office/ Front Office, Counterparty and other Market Participants to resolve the issues.
• 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 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 testing Data Migration and 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, Manhattan, NY

Sr. Business Analyst

Responsibilities:

• Interacted closely with the users and conducted numerous user interviews, gathered business requirements and analyzed the requirements
• Write Business Requirements Documents, Technical Design Documents and Test Plans.
• Maintained Agile Project Board including backlog and sprint; conducted daily scrum meetings and sprint activities.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades
• Management of multiple product improvement requests simultaneous for InfoLease. These are customer recommended product improvements to enhance the product to better satisfy their financial software needs
• Provided analytical support to customers using InfoLease for their financial software solution; answering questions, troubleshooting issues, and owning the call until resolution or until hand-off was appropriate.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements
• Used Agile Methodology and facilitated various teams like Development and QA teams to get on boarded into the agile for IHC/CCAR reports in Axiom.
• 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
• Based on business needs prepared conceptual data models for long-term solutions, created logical and physical data models using best practices to ensure high data quality.
• Interacted with teams in AFS, ACBS and Infolease to extract the information for the reports
• Processing Cheque Deposit, Cheque Inward Clearing, Demand Draft, TT Inward/Outward and Term Deposits
• Responsible for maintaining Agile best practices for Scrum team, product owner and stakeholders within the organization.
• Preparation of data dictionary / business glossaries and also integrating Data dictionary into datamodels
• Optimized and update logical and physical data models to support new and existing design requirement.
• 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
• Developed SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes
• Acted as liaison between business users and Axiom configuration team.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro
• Gathered high level business requirements to replace Empower time entry system with payroll team and payroll manager (Subject Matter Expert-SME) input.
• Use Axiom software to check on the workflow and data feed of CCAR reporting
• Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Worked with Counterparty Credit Risk space related to core risk management and Basel II/III, created deliverables to satisfy internal and external regulatory requests.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Instrumental in development and implementation of standard BA methodology based on industry best practices.
• Created high-level process flow diagrams of the different Credit Risks, Market Risk and Operational Risk, which were presented to regulators
• Supports the product that helps in collateral management (CAARS) and payment management (CashWire) also assist the client with client margin calls and exposures
• 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.
• Worked with developers to make sure that they understood the Use Cases.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database

Confidential, Minneapolis, MN

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.
• 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 of Agile principles especially the Scrum Ceremonies -Sprint planning, Sprint review, Sprint Retrospective and daily scrum calls
• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, cash flow, Financing Structures, CapitalManagement, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements
• Designed and developed the data dictionary and Meta data of the models and maintain them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations
• Strong working knowledge on Security reference data such as Counterparty Reporting, GDPR Compliance, Trading Order Management System
• 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.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• 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.
• Lead client facilitation to gather requirements (Inception phase), there after assisted tech leads in Analysis & Design of architecture using OOAD approach using UML & Rational Unified Process.
• 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.
• Worked with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in regulatory reporting application Axiom.
• Developed timelines for project delivery and managed projects and resources to successful completion.
• Conducted design reviews to ensure that deliverables meet business needs, including in-house data share application development
• Communicated business and functional requirements to the development team for design
• Facilitated implementation of new functionality through training sessions, demos, and training manuals
• Developed and executed systems integration test scenarios.

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
• Business Analyst for InfoLease release upgrade and various system transition projects.
• Designed and implemented front end Forms using Visual Basic for Application in an Access environment to maintain historic Equity data
• Worked on enhancing the traceability of Data Provider Template uploads from different up streams to Axiomin order for the Business users to analyze and streamline the Data updates.
• Imported and Exported data from Microsoft Excel and Microsoft Word to Quality Center where deemed necessary for project migration and test set replication for reusable template assets
• Performed Back-End testing by writing and using SQL queries.
• Assist with placement of exposure externally when required, manage counterparty relationships.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Business analysis, BRD, HLD, LLD creation and project coordination of InfoLease Software release upgrade. CCAR and FY 14 Federal Compliance reporting.
• Researched and evaluated identified loan origination software vendors and their products. Mapped functional requirements against software capabilities of each product to help customer identify the best solution.
• Designed reports and assisted Empower BI team for reports.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Reporting defects to development team through the HP ALM (Application Lifecycle Management).
• 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
• Performed data analysis and data mapping to bring the data originating from seven source systems in the commercial banking database to Basel II database.
• Involved in Business analysis and Requirements gathering.
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Worked on Banking applications encompassing online banking, core banking software, Lending applications (Retail and Commercial), Home Insurance applications
• Worked on small work requests and production incident fix for online banking and lending applications
• Followed waterfall and agile software methodology for business process re-engineering and software enhancements.
• Worked extensively in the back-end Oracle database using PL/ SQL.
• Performed software web testing for multi-family lending group commercial loan origination packages.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Lead analysis efforts on complex Loan IQ system issues to determine where opportunity for automation or functional improvement exists.
• 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, Columbus, GA

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
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Worked with catastrophic risk assessment models, property exposure and loss data along with other general insurance aspects.
• Conducted Agile refinement sessions for requirements and stories with the business and change management teams.
• Analyzed business requirements thoroughly for the Counterparty Management System as well as the Credit Risk Approval Process and the CRM Oracle Data Warehouse. Duties also included interacting with the Business users and the Project Management team
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with Capital Markets and Investment Banking solution.
• Facilitated interviewing and brainstorming sessions with the stakeholders and SMEs in understanding the requirements pertaining to mortgage application process.
• Design RO user and Credit Grading user request/Modification/Deletion forms and "RO UAT User Guide" for methodology owners of each business unit including syndicated loan group, vendor finance, small business lending, equipment finance group etc.
• 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.
• Assist in the development/redesign of end-to-end processes in support of First Tennessee Bank's Commercial Lending team and the iCL Commercial Workflow system using Process Flow maps.
• Used DOORS to link requirements to test cases, business rules, and design items to maintain traceability
• Data governance functional and practical implementation and also responsible for designing common Data governance frameworks
• Prepared various Customized applications for sales purposes and Reporting purposes using SalesForce
• Worked on Various Customer Health Reports and Inventory Reports in Salesforce using Various Features of SalesForce.
• Perform database operations, write complex SQL queries and Implement PL/ SQL programs to generate accurate reports from the application which are business critical
• Collaborated with QA team to create and instrument test plan and test cases for User Acceptance Testing and worked with the team on resolving product and document issues.
• Prepared various Customized applications for sales purposes and Reporting purposes using SalesForce
• Extensively working on Data Modelling tools Erwin Data Modeler to design the data models.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse
• Deployed builds and patches in Production and UAT environment, created release packages with proper versioning document. Used perforce for version control.
• Sound understanding and previous exposure to corporate treasury product, trade finance products, and international banking products.
• Got in depth understanding of the processes of the mortgage industry related to plans, rates, fees and underwriting systems.
• Monitored testing resources to ensure project tasks are completed successfully and according to development specifications and deadlines.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• 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.
• 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 Server Management Studio, Axiom, Agile,Scrum,Informatica,Oracle SQL Developer, SQL Server Business Intelligence Development Studio (BIDS), DOORS, Azure, XML, HP Quality Center,Agile/Scrum, Microsoft Excel, Microsoft access.

Confidential, Troy, MI

Business Analyst

Responsibilities:

• Used MS Visio to make use case models, activity diagrams, class diagrams, depicting whole business workflows in these diagrams.
• Managed design and production of client projects and served as the lead designer for the company's visual design efforts and website landing page redesigns.
• Managed requirement gathering of Commercial Lending, identified "As is" and "to be", derived GAP analysis for building new lending analysis model, producing lending analytic metrics to support BAU reporting. Automated reporting lending model for retail products - Overdrafts, Loans, Mortgages.
• Investigate counterparty disputes for collateral margining calls
• Involved in creating several PL/ SQL packages, standalone procedures, and standalone functions.
• Involved on Commercial lending concepts and implemented BPM process in order to make lending process more efficient and cost effective and easy to manage.
• 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
• Created and annotated the Business Process Flows and Process Flow Diagrams for Credit Rating of Counterparty and Ratings Approval Process by using MS Visio
• Created and maintained SQL scripts/queries for Data Migration, conversion, mapping, validation and data verification at the backend testing on the oracle database
• Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches
• Conducted daily scrum meetings with on-shore and off-shore teams for both revenue and instrument data mart.
• Conducted in depth analysis of different source systems and instrument types for data mapping.
• Implemented Agile Methodology for building an internal application.
• Designed elaborative process workflow diagrams and documented scoping parameters for the ERP application to be designed by the IT partner.
• Worked on the Business Objects Data Insight 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.
• Conducting user interviews, gathering requirements, analyzing the requirements using Rational Rose.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams.
• Identify, research, investigate, analyze, define and document business processes.
• Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.