Sr. It Business Analyst Resume
Norman, OK
SUMMARY
- 8+ years of experience as a business analyst in financial services industry
- Robust experience in business & financial analysis and devising project plans
- Expertise in deploying various SDLC methodologies such as Waterfall,Agile(Scrum and XP) and Rational Unified Process (RUP) for business analysis and project management
- Great expertise in agile methodologies.
- Proficiency in facilitating and administering JAD sessions to help in identifying system specifications and convert them into user stories
- Experience in business consulting, Customer Relationship Management (CRM), Enterprise Resource Planning (ERP) and Enterprise Content Management (ECM) solutions.
- Profound experience in eliciting, analyzing and documenting business requirement to produce deliverables such as Business Requirement Document (BRD), Functional Specification Document (FSD), Use Cases, Data Flow Diagrams and Requirements Traceability Matrix (RTM)
- Extensive experience in conducting GAP analysis, Cost - Benefit analysis and risk analysis and assisting the project manager in resource allocation and creating a work breakdown structure
- Proficient in Business Process Modelling (BPO) using Unified Modelling Language (UML) including behavioral diagrams and structural diagrams, data modelling, creating data mapping documents and cross data integration of data feeds from several data vendors like Bloomberg, Reuters and Capital IQ
- Experience in creating master test plans, test cases and test scripts for Quality Assurance Analyst to carry out unit testing, integration testing, installation testing and system testing
- Comprehensive understanding of Trading Systems,FixedIncometrading systems, and Equity trading systems and good understanding of trading lifecycle of financial securities from initiation to clearing and settlement
- Exposure to risk analytics and strong derivatives (Options, Futures, Forward, SWAP's and interest rate derivatives) and credit derivatives (CDS - Credit Default Swap, CDS Nth, Credit Default Swaptions, CLN - Credit Linked Note, TRS - Total Return Swap and Asset Swaps)
- In-depth knowledge offixedincomesecurities (Treasury Bonds, Corporate Bonds, International Bonds, Agency Bonds, ABS - Asset Backed Securities, MBS - Mortgage Backed Securities, CDO - Collateralized Debt Obligation, CMO - Collateralized Mortgage Obligation, Convertible Bonds and Index Linked Bonds)
- Hands-on experience with Derivative understanding of different financial risks (Systematic and Unsystematic Risk, Liquidity Risk, Credit Risk, Operational Risk)
TECHNICAL SKILLS:
Project Methodologies: RUP, Waterfall, Agile (SCRUM)
Requirement Management Tools: Rational Rose, DOORS, Power Designer, IBM Rational Requisite Pro, plain view, Share point, Micro strategy, Business Objects,, Rally
Change Management Tools: Rational Clear Quest, Rational Clear Case, Silk Central Test Manager, MS Project 2010, Quality Centre, Compliance Calibrator, ST03N, Open Pages- IBM
Databases: MS Access, SQL Server, Oracle, TOAD
Data warehouse /BI Tools: Informatics Power Centre 7.1, Oracle OBIEE, Cognos
MSOfficeSuite (365): Word, Excel, Access, PowerPoint, Project, OutlookTesting Tools Knowledge Quality Centre, Test Director 8.0, Load Runner, Win Runner, Test Directory
Operating Systems: MSDOS, Windows UNIX, MAC, Linux
Programming Languages: Java, SQL
PROFESSIONAL EXPERIENCE:
Sr. IT Business Analyst
Confidential
Responsibilities:
- Worked on Requirement Analysis,BusinessAnalysis and Gap Analysis of various source systems sitting and coming from multi systems.
- Build and maintainCCAR(Comprehensive Capital Analysis & Review) operating rhythm and governance framework.
- Works on the RiskDataPlatform system, especially onCCAR, utilizing SQL, DB2/UDB
- Worked on creating new tables and columns to Baseldatamart.
- Worked with Stakeholders /Business partners, Product managers and technical teams following the SDLC process on a multiple projects.
- Work to developCCARend to enddatamapping documents. Also worked on different aspects of CCARrequirements.
- Studied the Basel III accord and Fed'sCCAR. Led the Basel IIIDataGAP Assessments
- Evaluatesdatamining request requirements and help develop the queries for the requests.
- Performed regression testing of the Basel EAD model for the entire OTC derivatives book between the old and the new regulatory capital models.
- Conducted UAT (User Acceptance Testing) for multiple iterations by writing Test Cases and signed off the same after approval
- Involved in documenting project details in a project charter, identify impacts, process/data flowing, business & functional requirements, project plans & schedules, issues log, risk analysis, cost benefit analysis, lessons learned, and project closure documentation.
- Performed the physical database design, normalized the tables, worked with Demoralized tables to load thedatainto fact tables ofDatawarehouse.
- Involved in designing and developing Data Models and Data Marts dat support the Business Intelligence Data Warehouse.
- Heavily interacted withDataWarehousingteam in Metadata Modeling and gathering requirements for product cataloguedataload specifications forDatamapping andDataModeling.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects dat support the business requirement and process.
- Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
- Conducted Joint Application Development (JAD) sessions with stakeholders and business users
- Extract thedatafrom adatawarehouseto create ad-hoc reports, tables, and graphs according to Businessneeds
- Incorporated the Informatics Velocity approach for Mapping design, development and Data Governance.
- Gatheird requirements from the business stakeholders in terms of the type of loans and the type of interest being paid by clients.
- Ad-Hoc Financial Analyses to Support Business Initiatives.
IT Business Analyst (ECM)
Confidential, Norman, OK
Responsibilities:
- Maintain current knowledge of new technologies related to SharePoint, ECM, Portals and Collaboration systems
- Analyzed application requirements with UML modeling (Rational Rose) and documented Dialogue application output management and File Net Enterprise Content Management solutions.
- Prepared and documented Business Requirements and workflows for the Enterprise Content Management Application tool Interwoven.
- Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
- Am acting as the sole focal point and System Administrator for the Procurement Contract Management platform, ECM.
- Involved in content management system based on File net P8 to store, manage and generate documents in PDF format
- Trained and lead efforts on boarding the enterprise Vendor Management community to the ECM Contract Management platform.
- Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP
- Worked on requirement collection and documentation for IMR and defined the project scope in Agile Environment. Maintained all the documents in Single Point Access SharePoint link access in ECM System
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions
- Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Used Rational Rose to model the process using UML to create behavioral and structural diagrams.
- Performed data analysis by using SQL queries using the DB Artisan tool
- Developed business process models in RUP to document existing and future business processes
IT Business Analyst - Front Office
Confidential - New York, NY
Responsibilities:
- Identified, understood and documented business needs for new market risk module and credit risk module or re-usability of an existing module by performing a GAP analysis.
- Mitigate extreme technology risk by retiring unsupported applications for theFixedIncomeTrading platforms.
- Develop trade-related work flows forfixedincometrades flowing through to the settlement and accounting systems.
- UsedAgileScrum and Kanab frameworks to manage product development workflow.
- Assisted in creating and executing Test Cases/test scripts and documented all issues identified during the testing phase and ensured dat all incidents were discovered, tracked/resolved and prepared the UA test cases for end-user testing.
- Represent Muni desk in the development of new trading platform inFrontoffice. Task includes, elicit requirement, analyze and document requirements and validate them while coordinate with users/QA team and Developers.
- Serve as information resource for business users, Provide user/technical support forFrontoffice applications.
- Clearly understood the trade life cycle process and operations of the firm fromfrontofficeto middle officeand backofficewho are the end users of dis application.
- Responsible for developing requirements for customization and enhancement offixedincome trading applications.
- Performed data analysis of wealth management transactions with centralized billing analytics, data conversion and performance reporting, repo and otherfixedincomefinancial products (Repo, Sell/ Buy backs, Coupons, etc.)
- Extensively used SQL queries to conduct data analysis and access various databases.
- Facilitated the discussion involving key stakeholders to gather high level requirements and documented them as BRDs.
- Has hands on experience in writing various simple to complex SQL Queries to extract the data reports from various databases and provide the business stakeholders accordingly.
- EmployedAgilemethodology and played role of scrum master to facilitate scrum meetings to discuss project sprint planning and discussion of updates of each Sprint on daily basis using JIRA software
IT Business Analyst - Fixed Income
Confidential -New York, NY
Responsibilities:
- Created Project Plan for the new applications to capture potential conflicts with existing process and downstream systems.
- Followedagilemethodology.
- Established Business Analysis methodology usingAgileExtreme Programming to create Architecture and Interaction models.
- Assets & Liability and Liquidity reporting by Preparing and reviewing daily Stress Testing reports on Forex,FixedIncomeand Equity Portfolio.
- Managedthe implementation of Investor tools Perform FPC (For Private Clients) Portfolio Management System for the Municipal Bond trading desk including Treasuries as a Business Analyst.
- Analyzed and designed customized data feeds to populate Perform with trade and securities data from diverse databases and the Security Reference Data Master.
- Involved in designing and developing Data Models and Data Marts dat support the Business Intelligence Data Warehouse.
- Conducted formal one-on-one meetings to analyze existing trade process with business users.
- Developed business requirements for proprietary bond allocation models to be processed on Perform.
- Managedend-user and vendor interaction for the migration project including senior officers and portfolio managers.
- Mapped a complete end-to-end pricing data and trade flow -- a first for Confidential .
- Developed an application to facilitate speedier new security set up in the enterprise security master.
- Developed Use Cases for Pricing and other market data flows and transmission of analytics data from a data mart.
- Developed a knowledge base of routine production incidents dat involve user support for an offshore support team.
- Responsible for project planning and allocation of resources both onsite and offshore.