SUMMARY

• Over 7 years of Business Analysis, Software Validation and Business Process re - engineering in Capital markets, Insurance, Loan and Retail. Wif a proven track record of managing and delivering IT projects, collaborating successfully wif other teams (both technology and business) to ensure success
• Functional experience in Use Case models (Activity Diagrams, Sequence Diagrams and Collaboration Diagrams), Business Process Models, UML diagrams, Data Modeling, Change Management, SDLC methodologies (Waterfall, Agile, RUP), PMLC and TDLC including BI reporting (Cognos, Business Objects, Tableu)
• Strong project management skills including planning, scheduling, monitoring and budgeting
• Hands on expertise in requirement gathering, creating BRDs/SRS/FRS documents, Gap Analysis, Data flows, Root Cause Analysis, Feasibility studies, Risk Assessment studies, Test strategy, Test plans, Flowcharts, Screen mock-ups and Systems requirements specifications.
• Gained good understanding of Trade Finance Life Cycle and Capital Markets- financial instruments, OTC, and exchange traded derivatives, equities, commodities, forex, fixed income assets, and mutual funds, financial strategy, capital market principles, and analysis
• Strong understanding of information technology capabilities and dependencies, including platforms, content management and process mapping
• Ability to identify business needs, analyse issues, diagnose problems and determine appropriate solutions.
• Strong expertise on tools including MS Visio, Rational Requiste Pro, other documentation/testing and defect management tools
• Proficient in coordination of issues, defect tracking/reporting and monitoring teh status of teh project
• Experience in conducting Joint Application Development (JAD) sessions wif end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews
• Strong interpersonal, time management, communication, problem-solving, and organizational skills across all levels of management
• MBA Graduate wif high level of multi-tasking abilities having strong command on corporate finance, accounting and project management methodologies

TECHNICAL SKILLS

Modeling & Design Tools: Rational Rose, UML, MS-Visio.

Requirement Management Tools: Requisite Pro, DOORS, MS office

Defect Tracking Tool: Rational Clear Quest, JIRA

Version Control Tool: Rational Clear Case

Operating Systems: Windows XP/Net/2000, UNIX and MS DOS.

Languages: C++, SQL, PL/SQL, Visual Basic, HTML, J2EE, XML, JDBC, .Net, JAVA, HTML

DBMS: SQL Server, Oracle 10g/9i, DB2, Siebel, SAS.

MS-Suite: MS-Office, MS-Excel, MS-Access, MS Outlook, MS Power-point, MS- Project, Pivot tables

Testing Tools: QTP, Quality Center, HPQC, Load Runner, JIRA, HP ALM

Business reporting: Cognos, Business Objects reporting tools

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Worked wif business stakeholders and other SMEs to assess current reporting capabilities, understand business requirements and created System Requirement Document SRS to address reporting needs
• Worked on gathering and documenting Cognos and Business Objects reporting requirements associated wif several projects
• Delivered current and future state data analysis document to teh project team which are used to create Gap Analysis, created WBS (work breakdown structure) and Report to management, Project Planning, Resource Allocation, and Budgeting
• Worked wif IT Specialists (Solutions Designers, Data Modelers) to translate user and system requirements into functional technical specifications by creating star schemes for reporting purposes
• Designed, developed and conducted project related presentations to teh executive teams
• Coordinated and Conducted Joint Application Development (JAD) sessions for teh business users and Subject Matter Experts (SMEs)
• Worked wif teh software architects/developers to ensure dat teh applications confirm to customer requirements
• Authored data lineage document and performed data profiling in teh source systems dat are required for BI Reporting
• Adhered to existing processes and standards, including teh System Development Life Cycle (SDLC), business technology architecture, production capacity guidelines, and escalate issues where necessary
• Generated ad hoc reports using SQL as requested by teh business
• Facilitated between Report developers, Business and Report owners for creation of reports used for Superintendent of Financial Institutions (OSFI) regulatory audits by assisting in data flow, system analysis - risk, dependency & limitation
• Extensively used SQL for data extraction and manipulation
• Worked wif development and testing teams to accomplish timely release objectives

Environment: RequisitePro, JIRA, MS Access, MS Excel, MS Visio, MS Word, MS PowerPoint and MS Project, Cognos, SQL, HP-ALM

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Gatheird requirements using interviews, requirements workshops, by Interviewing SMEs, medium to large stakeholder groups and carefully recorded teh requirements in a format dat can be reviewed and understood by both business people and technical people
• Involved in identifying business process and developing business process flow diagrams for pre-approvals
• Demonstrated strong analytical and project management skills, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements
• Worked extensively wif lending officers, underwriters and other stakeholders to identify teh AS-IS and To-Be models
• Validated various business processes wif a committee of Subject Matter Experts (SME's) like Mortgage Servicers, Underwriters, Credit Analyst etc, to ensure teh rules and guidelines has been met
• Developed BI reports and dashboards using Cognos
• Resolved issues, queries and performed regression testing to make sure teh accuracy of data flow
• Understand teh business requirements and identified gaps in different processes and implemented process improvement initiatives across teh business improvement model
• Functioned as a liaison between various business users and teh technical team throughout teh project lifecycle
• Worked wif business stakeholders and other SMEs to assess current reporting capabilities, understand business requirements and created System Requirements Specifications (SRS) to address reporting needs
• Produced Test Data plan, Test Scenarios and Test Cases for Releases and different critical business processes
• UsedToad to write SQL queriesagainst teh database for data validation processes
• Performed SIT wif in application and integration wif all modules in teh system and conducted UAT, BAT, PAT wif teh cross-functional business teams to ensure teh system was aligned wif teh vision of teh business teams
• Identified and investigated defects in teh application under test
• Reviewed identified defects in teh Change Control Board and decided its resolution process
• Partnered wif Development and Release management teams to coordinate all teh releases
• Involved in creating User Manuals, providing user training and post-implementation support

Environment: - Rational Rose, MS Visio, MS Office, TOAD, JIRA, MS Excel, MS share point, MS Powerpoint, Informatica, Cognos, XML, Oracle DB, Mercury Quality Center, HP ALM, Agile, Waterfall, Loan IQ

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Gatheird, analyzed, documented business and technical requirements from both formal and informal sessions and validated teh needs of teh business stakeholders
• Performed Requirement Analysis, Cost benefit, ROI studies. Conducted user interviews, documented business and functional requirements, developed UML Use Cases, Activity Diagrams to understand teh requirements
• Gatheird and documented teh To-Be process to optimize teh process work flow
• Proactively managed scope, issues, and risks to ensure project success. Followed change control procedures effectively
• Performed in depth analysis to identify risks and to identify root causes of problems
• Involved in creating business processes and modeling diagrams using Rational Rose
• Worked wif portfolio managers, funding managers, traders and risk managers who trade in instruments including derivatives, equities and fixed income assets
• Gained good understanding about trade booking life cycle for equity, equity derivatives, fixed income, assets trading
• Documented requirements associated change requests wif requirements and connected requirements wif Use cases.
• Performed extensive data mapping, data profiling, data modeling and process modeling diagrams
• Worked wif developers to design conceptual data model, physical data model and schema
• Designed teh UI of teh application, prototyping and wire framing in MS Visio for better illustration of teh application
• Facilitated project meetings/presentations, opening lines of communication and promoting cross team interaction
• Actively involved in developing system flows from front-to-back office operations
• Worked on regulatory reporting and implementation- Dodd-Frank- Volcker rule, FATCA, Basel II/III (LCR)
• Worked on gathering and documenting Cognos and Business Objects reporting requirements associated wif several middle and back office projects
• Acted as a liaison between database administrator, network department, and Accounting department for teh financial systems throughout integration testing
• Responsible for creating test scenarios, test cases and involved in test and defect management
• Involved wif all teh phases of Software Development Life Cycle (SDLC) methodologies throughout teh project life cycle
• Extensive experience in reporting, created data lineage document, data mapping using SQL across databases and running ad-hoc queries
• Prepared UAT Materials, UAT Test Cases, RTM for proper coverage of requirements
• Generated test data using SQL and involved in back end testing using SQL Queries
• Used Mercury Quality Center for updating teh status of all teh Test Cases dat are executed during testing process

Environment: - Rational Rose, MS Visio, MS-Suite, Windows XP, MS Office, MS Excel, SQL Sever, C#.NET, XML, SAP, VB.NET, RDBMS, Wallstreet, Informatica, BPMN, Unix, Oracle DB, MDM, Mercury Quality Center, Murex, Monte Carlo Simulation, Agile, MS SharePoint, Cognos, JIRA, HP ALM, Waterfall, MS Office

Confidential

Sr. Business Analyst

Responsibilities:

• Analyzed client’s systems and business processes and worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
• Collected & documented teh requirement of Business Teams from Claims, Under Writing, Quotes, Policy Team, Project Sponsors & Actuaries
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions
• Worked wif clients to better understand their needs and present solutions using structured SCRUM approach
• Created Functional Specification Document. Created UAT plans wif several test cases for each project to ensure dat teh system runs smoothly after teh proposed enhancements or changes has been made
• Played a key role in teh User Acceptance Testing, and Implementation of system enhancements and conversions. Given Presentations using MS Excel, MS access, MS Powerpoint and MS Project
• Generated test data using SQL and involved in back end testing using SQL Queries
• Planned and defined system requirements to Wire Frames wif Use Case, Use Case Scenario and Use Case Narratives using teh UML (Unified Modeling Language) methodologies
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated
• Performed extensive Requirement analysis and developed use cases and workflows. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and User Manuals
• Conducted JAD sessions for communicating wif Stakeholders and Project directors

Environment: - MS Visio, Windows XP, XML, MS-Suite, Oracle DB, MS-SQL, Agile, MS Project, Guidwire

Confidential

Sr. Business Analyst

Responsibilities:

• Identified teh key Stakeholders and teh business users of teh application
• Elicited requirements using interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios, JAD sessions, and business analysis
• Involved in GAP Analysis and Technical Feasibility study wif teh technical leads and other SME's.
• Defined quality attributes, external interfaces, constraints, and other non-functional requirements
• Identified Use Cases from teh requirements and created teh Business Requirement Documents (BRD) and teh Functional Requirement Documents (FRD)
• Created UML Diagrams including Use Cases Diagrams, Activity Diagram, Data Flow Diagrams (DFD), ER Diagrams using Rational tools thus defining teh Business Process Model and Data Process Model
• Worked wif QA team in delivering detailed Test Plan, Test Cases and Scripts. Highly involved wif unit testing, system testing and integration testing
• Reviewed test cases and maintained teh Requirement Traceability Matrix (RTM)
• Involved in creating User Manuals and training end users
• Worked wif teh UAT team to validate dat teh developed application will meet teh business requirements
• Created Supplemental Specifications in RequisitePro and updated teh RequisitePro Global Glossary

Environment: - Rational RequisitePro, MS Visio, Windows XP, XML, MS Office Suite, JIRA, SQL server, QTP, Cognos

Confidential

Business Systems Analyst

Responsibilities:

• Worked closely wif Business Owners and Stakeholders to outline Business Requirements using rational requisite pro
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database.
• Created context and workflow models, information and business requirement models, use case and object models, Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend teh most efficient solution for system design.
• Used MS-Visio for flow-charting, Use- Case process model and architectural design of teh application.
• Used Test Director for creating planning progress graphs, bug tracking, logging defects and reporting.
• Exclusively used Test Director & Quality Center to write Test Cases and for reporting. All teh Scripts are maintained using Test Director & Quality Center.

Environment: - Rational RequisitePro, MS Visio, Windows XP, MS-Suite, Win Runner, Test director, SQL