Business Analyst Resume
Ionia, MI
SUMMARY:
- With Over 6+ years of experience in Business/Data analysis, business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Banking Sectors.
- Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling.
- Have experienced as Business Analysis, with cross functional experience in Real Estate and Financial services industry with Investment Banking, Asset Management, Portfolio management, Trades Lifecycle and Brokerage service
- Knowledge in broad range of financial practices and principles ranging from financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting to trend analysis, investment banking, asset allocation, portfolio management, risk analysis and derivatives.
- Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
- Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence
- Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
- Participation in the Credit Risk Analysis like Estimation of PD, LGD and EAD.
- Expertise in using SAS output delivery system (ODS) functionality for reporting.
- Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
- Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Excellent understanding of Data Models and Information Architecture and sound skills in SQL.
- Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.
- Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
- Proficient in writing SQL scripts for Corporate Data Warehouse’s larger amounts of data
- Involved in Back End Testing using Oracle and MS SQL.
- Involved in Business Analysis and Reporting .
- Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
- Experience with data migration (ETL development), document data manipulation processes and scripts
TECHNICAL SKILLS:
Databases: MS Access, MS SQL Server 7.0, My SQL
Automation tools: WinRunner, LoadRunner, and Rational Suite.
Defect Tracking tools: Rational Clear Quest, Test Director and Mercury Quality Center
Modeling tools: UML, Rational Rose,oops, MS Visio, Rational RequisitePro
BI Tools: Crystal Reports, Business Objects.
Programming: C, SQL, Java, Oracle, VB, TSL, SQABasic.
Operating Systems: UNIX, SWFIT, Windows NT/95/98/2000 & XP
MS Office Tools: Ms-Excel, Power Point, Word, MS-Access
Database Tools: DB Visualizer, TOAD.
PROFESSIONAL EXPERIENCE:
Confidential, Ionia, MI
Business Analyst
Responsibilities:
- Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance .
- Strong experience in Object Oriented Programming (OOPS) concepts.
- Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
- Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
- Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
- Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
- Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
- Created test scripts and plans for UAT Phase
- Managed risk-based audits, due diligence and governance of new initiatives and compliance (AML (Anti-Money Laundering), SOX, Basel II, GLBA, PCI) programs to mitigate risks
- Helped IT developers design the service oriented architecture (SOA) for the application based on the available resources, and the business requirements.
- Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
- Schedule SMEs for Business Process Validation Meetings
- Gathered requirements and modeled the data warehouse and the underlying transactional database
- Designed and developed Project document templates based on SDLC methodology.
- Developed Business Requirement Document as well as High-Level Project Plan.
- Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle. Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
Environment: Microsoft Office Suite, MS Visio, MS Access, MS Project, MS Excel, Windows XP, DreamWeaver, Oracle, SQL, PLSQL, XML, VB, ASP.Net, SWIFT, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner
Confidential, NY
Business Analyst
Responsibilities:
- Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
- Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
- Contributed in defining the scope of the project and defined functional specifications.
- Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
- Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD).
- Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
- Gathered requirements and prepared Use Cases (General System Design documents and Detailed System Design document) by interviewing tax agents, users and clients.
- Extensively involved in data modeling
- Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
- Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
- Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
- Developed requirement reports for day-to-day retail banking needs for opening account, online banking using rational SoDA.
- Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
- Incorporated Data Acquisition, Data Privacy, Data Analysis, Data Mapping and Data Compliance rules in the auditing criteria.
- Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
- Analyzed the Data Entity Relationships and worked on Functional Requirements Document (FRD).
- Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
- Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
Environment: Windows XP, Oracle/SQL Server 2000, SQL, Tele logic DOORS 8.1, Tele logic System Architect 10.6, Mercury Quality Center, Cobol,RUP, UML, MS Visio, MS PowerPoint.
Confidential, Williston, VT
Business Analyst
Responsibilities:
- Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD).
- Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
- Contributed in defining the scope of the project and defined functional specifications.
- Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
- Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD).
- Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
- Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
- Gathered requirements and prepared Use Cases (General System Design documents and Detailed System Design document) by interviewing tax agents, users and clients.
- Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Conducted and participated in JAD/JAR Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.
- Parsing high-level design specification to simple ETL coding and mapping standards.
- Analyzed the Data Entity Relationships and worked on Functional Requirements Document (FRD).
- Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Worked with SME’s in Finance, Investment, Commercial and Personal banking to collect the Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering.
- Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
- Work as Business Analyst for the project to build a MS SQL data warehouse for complex wide profitability reporting.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
Environment: Windows XP, Oracle/SQL Server 2000, SQL, Tele logic DOORS 8.1, Tele logic System Architect 10.6, Mercury Quality Center, Cobol,RUP, UML, MS Visio, MS PowerPoint.
Confidential, Herndon, VA
Operational Business Analyst
Responsibilities:
- Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on MS Access.
- Reconciling General Ledger accounts. Assisted with audit defense, Sarbanes-Oxley 404 compliance, research tax issues as they arise.
- Working with the business to understand and determine system implications in terms of the platform(s), application(s) and business processes .
- Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
- 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.
- Captured Data flow diagrams and formatting of the data flowing through interfaces.
- Written PL/SQL packages to call the API to ship confirm the orders in oracle applications
- Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
- Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
- Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
- Finding, filing and tracking bugs with JIRA using debugging and production databases
- Written Stored Procedures using PL/SQL and functions and procedure for common utilities
- Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
- 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.
- 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.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
- 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.
- Mapped financial data, general ledger data, loss event data, transaction data and people reference data from source to target database for creating a central Risk Data Repository (RDR) as required byI reporting regulations.
- Involved in changing the functionality to calculate due date in the transaction for proxima payment terms and changed the auto adjustments package to pl/sql code instead of pro C code.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
- 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 parties involved with respect to the evaluation criterion
Environment: JSP, Oracle, HTML, XML,DOORS, Clear Case, Clear Quest, Jira, XSL, PL/SQL, Rational Rose, MS Visio, RUP, UML, MS Project, SQL, MS Access, MS Excel and MS Word