We provide IT Staff Augmentation Services!

Business Analyst/data Analyst Resume

2.00/5 (Submit Your Rating)

St Louis, MO

SUMMARY

  • A progressive Business Analyst/Data Analyst with Seven years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
  • Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
  • Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
  • Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
  • Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity - Relationship Diagrams (ERD).
  • Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
  • Result-oriented Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
  • Excellent relationship database skills including querying in SQL and programming in PL/SQL using interface such as Toad for Oracle 9i.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
  • Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

  • Rational Rose Enterprise Suite
  • Rational Requisite Pro
  • MS Visio
  • Test Director
  • Test Manager
  • Rational Clear Quest
  • PVCS Tracker
  • MS Office
  • MS Project
  • XSLT
  • XML
  • MS Publisher
  • Rational Robot
  • Performance Studio
  • Mercury Win Runner
  • Load Runner
  • C/C++
  • Java 2
  • SQL
  • PL/SQL
  • VB
  • Shell Script
  • Html
  • Crystal Reports
  • Micro strategy
  • Access
  • Excel
  • MS-SQL Server
  • Oracle
  • Sybase
  • SQL* Plus
  • UNIX (Solaris/Linux)
  • MS-DOS
  • Windows 95/ 98/ 00/NT/XP
  • MS FrontPage
  • Dream weaver

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Business Analyst/Data Analyst

Responsibilities:

  • Designed business requirement & systematic approach based on project scope and SDLC.
  • Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
  • Engaged in project planning - Built Project WBS (Work Breakdown Structure) and Project Timeline.
  • Worked with Traders and Brokers teams to identify solutions driven by business requirements.
  • Conducted evaluation of bank’s data governance structure and identified gaps in structure, data and systems.
  • Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.
  • Facilitated joint application development (JAD) sessions by convening project sponsors, group representatives, SMEs’ and technical personnel and documented the minutes.
  • Built analytical framework to quantify impact of inter-company trade aggregation on all the systems in the trade processing flow.
  • Performance improvement of intra-day trading entries, security master file updates and security movement were some of the features of new system.
  • Conducted analysis and optimization of trade processing flow, trade break investigation and liquidity analysis for equity derivative and foreign exchange products which resulted in 45% reduction in trade volume processed by technology systems.
  • Worked with Operations Risk Management division to assess operational risk, determine impact of FX trade transactions on incident reporting.
  • Development of reporting solutions which include MS Access MS Excel and OLAP reporting via HyperionEssbase.
  • Managed and drove continuous improvements in HyperionEssbasedata cubes performed UAT testing and lead migration effort.

Environment: Microsoft Office Suite (Word, Excel, Outlook, MS project,XSLT, Visio, PowerPoint), UML, RUP, SQL Server, Essbase, Windows NT/XP, Java, HTML.

Confidential, PA

Business Analyst/Data Analyst

Responsibilities:

  • Extensively involved in every phase of the RUP process starting from Inception to Transition
  • Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Created context sensitive on-line help files for wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
  • Applied business knowledge of Fixed Income and Foreign Exchange Trading (Bonds, Spot/Forwards, Interest Rate Swap, Credit Default Swaps, Options: vanilla/single barrier/double barrier/digital) and hedge fund.
  • Assigned tasks among development team monitored and tracked progress of project following agile methodology.
  • Interface with the Wholesale Commercial Loan and Mortgage user group to address issues.
  • Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
  • Developed and executed test cases for systems testing and User Interface Acceptance testing
  • Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
  • Was Responsible for development of some custom components based on Flex components to implement some customized functionalities.
  • Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
  • Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
  • Worked with front and back office employees to determine their software needs and implement these custom changes in the Calypso environment.
  • Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
  • Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures.
  • 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.
  • Created User Acceptance Test Plan and coordinated UAT for the site redesign project
  • Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Generated server side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
  • Involve in preparing Trace Matrix to design test cases
  • Performed manual front-end testing to check all functionalities of different modules.
  • Have a uniform confirmation and settlement function as disparate confirmation and settlement processes impact the front office requirement.
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
  • Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products.
  • Trained the future users to coordinate their activities vis-à-vis CORD system rather than ARW.
  • Assisted the SA to document all custom and system modification after the SCR’s were satisfactorily solved.
  • Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the.

Environment: Microsoft Office Suite, Microsoft Visio, CRM, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Mainframe, RUP, VBScript, MS Project, UNIX, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, Test Director, LoadRunner.

Confidential, NY

Business Analyst/Data Analyst

Responsibilities:

  • Obtaining a detailed knowledge of the business process being followed in the project environment.
  • Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
  • Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational ReqPro.
  • Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio.
  • The Credit Risk Evaluator Project is an integrated customer - controlled platform for credit risk management. It is a powerful tool for measuring and monitoring and managing credit risk, thereby offering a broad range of analytical Capabilities and user control.
  • The platform enabled institutions to estimate and stress credit risk measures and rating estimates by using scorecards/models.
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
  • Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market.
  • Created a procedural manual, by documenting the processes of the RSF Collateral Management System. Was the liaison person with regards to back-offices issues including: accounting, clearing, custody and regulatory.
  • Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
  • Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
  • Interacted with database developers for formulating the ER diagrams and data flow diagrams.
  • Created cross-functional flow chart using MS Visio.
  • Used 3rd tool Crystal for ad-hoc reporting.
  • Undertook back end testing using SQL and wrote queries.
  • Effective communication made possible between the developers and the end-clients to guarantee that development efforts were within the scope of the project and the development was as expected.
  • Supported traders for front office operations like order management.
  • Held regular JAD meetings with the system architects, developers, database developers, and quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
  • Carried out defect control and change control in Clear Quest

Environment: Windows, Oracle 9, SQL, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process (RUP), RequisitePro, Clear Case, UML.

Confidential, Minneapolis, MN

Business Analyst/Data Analyst

Responsibilities:

  • Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
  • Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Strong usage of Subject Matter expertise in Fixed Income, Equities, Equity Swaps, Equity Finance, Stocks Trading Cycle, Portfolio Analysis, Asset management, Bonds and Bond Trading Cycle, Bond Pricing, Derivatives (Options-Including Vanilla and Exotic and Futures/Forwards), Credit Derivatives, Interest Derivatives, Alternative investment, Portfolio Management, Sales and Marketing
  • Responsible for creating and reviewing business requirement documentation, functional specifications, project schedules and test plans.
  • Set up market data including zero curves, correlation matrices, dividend curves, etc., and the underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
  • Understanding of OTC/ETD trade life cycle events from F2B for all product types Rates, Credits, Equity and FX covering all life cycle events: Trade capture, Confirmations, Valuations, Margins, Collateral management, Fund accounting, Settlements for OTC & Exchange Traded derivatives.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.
  • Providing valuation and pricing services to internal and external clients across a variety of OTC derivative products including credit, equity, interest rate, FX options and commodities.
  • Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
  • Gathered business requirements and assessed of current OTC derivatives instruction trade management processes, reference data, data attributes and security master database.
  • Checked the schema of Oracle database manually or using TOAD after every upgrade.
  • Involved in the performance tuning of the DataStage Jobs and SQL queries
  • Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
  • Generated ISDA documents of all OTC Derivatives contracts. Executed confirmations with adherence to the industry standards (in view of Fed targets).
  • Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
  • Worked in the Dodd Frank Act regulatory changes in the area of OTC derivative.
  • Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
  • 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.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Worked in mainframe environment and used SQL to query various reporting databases.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director.
  • Evaluated Competitors offerings and products including fixed income and derivatives.
  • Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle
  • Enabled Proper selection of the hash table design parameters for faster table look-up.
  • Created re-usable components using shared containers for local use or shared use.
  • Imported and exported repositories across projects.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Used Aggregator stages to sum the key performance indicators used in decision support systems.
  • Generated XML documents using the XML Output Stage.
  • Troubleshot the designed jobs using the DataStage Debugger.
  • Created jobs sequences.
  • Created job schedules to automate the ETL process.
  • Enhanced the job properties for performance tuning.

Environment: Ascential DataStage 7.5, (Designer, Director, Manager, Parallel Extender) Debugger, DataStage BASIC language Expressions, SAP SD, SQL Server, Windows NT 4.0, XSLT, Visio, Toad, Sybase, UNIX, Java, Oracle 8i, PL/SQL, IBM DB2, Dbase3, SAS, Erwin, MS Access, XML Files, MVS, IMS

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of loan processing workflow model.
  • Modeled AS IS and TO BE processes using MS Visio
  • Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
  • Worked in mainframe environment and used SQL to query various reporting databases
  • Gathered requirements/Worked with WebSphere to set up, operate, and integrate e-business applications across multiple computing platforms.
  • Analyzed the Business and System Requirements of the application.
  • Designed and developed project document templates based on SDLC methodology.
  • Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members
  • Performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Assisted the testing team in developing the Test plans for quality assurance based on functional requirements.
  • Worked with Front-end and Back-end systems
  • 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.
  • Performed User Acceptance Testing (UAT) for various web based and database related applications.
  • Interacting with the development and testing teams to improve overall quality of the software.
  • Developed Use case, Functional, Object diagrams using Rational Rose.
  • Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
  • Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
  • Worked under sprint Iteration model and gained expertise.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Assisted the PM in performing Risk Assessment, Management and Mitigation.
  • Worked extensively with Mercury quality center
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Microsoft .NET technology for Intranet application, IIS, MS SQL Server, VB.NET, ASP.NET, HTML, Windows2000, XP

We'd love your feedback!