SUMMARY

• 7 years of experience as a Business Analyst with solid understanding of Online Banking, Trading, Property and Casual Insurance, Policy Administration and In - depth knowledge of front office, middle office and back office of Investment Banking.
• Extensive working experience in Banking, Financial, Credit Card, Loan Origination/Processing/Monitoring and Mortgage Domains/ Insurance.
• Expert in Business Requirement gathering, Business Process flow, Business Process Modelling, Data Analysis, Data Mapping, Teradata, application upgrades, and Business Analysis.
• Expertise in broad range of technologies, including business process tools such as MS Excel, MS Access, MS Visio, technical assessment tools, Data Modeling and Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and Testing various methodologies.
• Knowledge of business processes in Capital Market Infrastructure Entities.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Insurance experience includes Personal Property & Casualty, Credit and Market Risk, and Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
• Tested and documented SOX compliance system. Excellent Knowledge of Accountancy, (General Ledger, Financial Statements etc) & Possess adequate Knowledge of ISO statistical rules and reporting
• Extensive experience in conducting Market Research, Feasibility Studies, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Comprehensive knowledge of e-commerce business processes and e-commerce concepts and terminologies.
• Experience with various ETL, data warehousing tools and concepts.
• Expertise in Credit Risk analysis for different deals rated of types (Bonds, Loans, and Derivatives.)
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures..
• Expertise on ETL process, business process analysis/modelling, database design and development of Web Based, and Client/Server applications.
• Hands on experience on working on CRM applications using Siebel and Salesforce.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Involved in UAT with end users and guide them to successfully achieve the desire output.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Extensive experience in developing Use Cases, creating Screen Mock ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong knowledge and working experience of industry standards such as Six Sigma, CMMI, and ISO 9000, SDLC, DMAIC, IIBA, BABOK and PMBOK.
• Excellent knowledge with Data Warehouse and Business Intelligence (BI), Data Management and Database Design, Business Analysis and Information Engineering, Software Quality Assurance, Advance in Data Integration
• Experienced with different Relational databases like Teradata, Oracle and SQL Server.
• Communicated and ensured compliance of all policies and procedures within the retail organization.
• Experience in conducting GAP analysis, SWOT analysis, Risk analysis, Mitigation plan and Impact analysis.
• Widespread interaction with clients, business users, stakeholders and end users.
• 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.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experience in process reengineering and design the new system to meet the end user requirements
• Experience in creating Accounting Periods, users, Assigned role to users and completed unit testing to ensure that the customization work as per requirement.
• Hands on experience of Data manipulation, performance testing on MySQL and MS-Access using SQL scripts
• Strong experience in writing complex SQL queries & Oracle.
• Experience in Implementation, Production support, customization, upgrades and troubleshooting in Accounts Payable, Accounts Receivables and General ledger.
• Experience creating nVision Balance Sheet Reports. Modified and maintained Income Statement, Trial Balances, and Cash Flow Statements for existing business unit.
• Experience in AGILE methodology within BABOK
• Created Risk Analysis Documents, Risk Management Plan, business Process Flows System.

TECHNICAL SKILLS

Methodologies: Rapid Application Development (RAD), Rational Unified Process (RUP), Waterfall, Agile/Scrum, SDLC.

Testing Tools: Test Director, QTP, Win Runner, Load Runner, Manual Testing

Configuration Management Tools: Rational Clear Case, Clear Quest

Business Modeling Tools: Rational Rose, MS Project, MS Visio, BPMN

Requirement Management Tools: Rational Requisite Pro, Telelogic DOORS, MS Office

Databases: MS SQL Server, Oracle 91/8i, DB2, MS-Access

Languages: C/C++, Java, SQL, HTML, VB, .Net, XML

BI Tools: IBM Cognos, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Sr. Business System Analyst

Responsibilities:

• Gathered and documented business requirements from user groups, stakeholders and vendors by conducting interviews and discussions sessions.
• Extensively involved in conducting JAD sessions with different business units and application development team.
• Created Use case diagrams, Data flow diagrams and business process workflow diagrams (Activity diagrams) in Rational Rose.
• Involved in assisting the business groups to provide support for Business Intelligence toolsets like OBIEE.
• Provided Gap Analysis, Cost/benefit analysis and understanding the business perspectives on many financial and operational issues.
• Generated queries in Oracle and SQL Server.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Narrative using the Business Process Modeling Notation (BPMN) methodologies.
• Documented the current business flows for Utilization Management (UM), Case Management (CM) and Disease Management (DM)
• Major functionality provided in the system Use Cases are Loan application, Loan origination, Loan underwriting, Merged credit profile, Property appraisal, Earning verifications, Title search, Rate assessment, Entitlement, Closing statement etc
• Analyzed data requirements, developed complex MS SQL Server queries to extract data using advanced techniques such as inner and outer joins, sub queries, case statements, string functions, and data type conversion.
• Responsible for Analysing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel & Power Point.
• Involved in designing user interface for the different Online Transaction Processing modules using JSP and Controller Servlets.
• Worked with Business Analyst to ensure project implementation within approved timeline and budget.
• Maintained complete and current project documentations.
• Addressed customer and team queries in proactive and relevant way.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data
• Assisted in troubleshooting, testing and maintenance of key deliverables.
• Updated management and stakeholders on project status, key issues, risks and action items in timely manner.
• Served as primary contact for management and stakeholders for project related questions.
• Evaluated team performance and provide feedback.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems
• Worked in software engineering methodologies or SDLC like Agile/Scrum and Waterfall methodologies.
• Developed stories and documented alternate scenarios for brining the catalog and pricing online.
• Involved in collecting customer data from the legacy systems and developing the data dictionaries.
• Involved in designing the loan processing module using Struts Framework.
• Involved in developed prototype of new information processing application module.
• Documented the Requirements Traceability Matrix (RTM) in Requisite Pro.
• Involved in preparing test plan and test cases based of functional requirements using Rational Test Manager for the business requirements verification and validation.
• Develop and produce aggregated and dashboard reports using MS SQL, MS Access and MS Excel.
• Wrapped up the technical documentation for integration points such as customer data, store data and pricing.
• Worked as a Liaison between QA team and Business Units involved in the application development for better understanding of the business and IT processes.
• Managed project performance and reporting through project scorecards and milestone reports
• Involved in Change Control procedures using Clear Quest and reports to track process of repairs and determine the current quality of the application.
• Performed the System, Integration testing and User acceptance testing using Test Director.

Environment: Rational Rose, Rational Requisite Pro, OBIEE, Clear Quest, ClearCase, MS-Visio, RUP, MS-Office, Windows, SQL, Oracle, Eclipse.

Confidential, Fairfax, Virginia

Business System Analyst

Responsibilities:

• Elicited and gathered user and business requirements through open ended discussions, brainstorming and prototyping
• Designed, built, and maintained a data repository with reporting capability that enabled analysis and insight of user behaviours and interactions for Equity, Index, Options, and Bonds
• Gathered requirements from key stakeholders, customers, and subject matter experts to define the scope and requirements of Asset Management portals middle office needs
• Assisted in daily settlement operations of middle office in coordination with back office operations
• Gathered requirements for research data mappings for front office
• Analysed data integration strategies to customize simultaneous analysis of data from new and old environments
• Prepared complete data mapping for the migrated data & Manipulating, cleansing & processing data using Excel, Access and SQL.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Worked closely with Fixed Income and derivatives.
• Liaison between project team and stakeholders to create a cohesive project plan
• Tracked and monitor project status regularly to ensure that deliverables are completed as scheduled
• Developed and maintained contingency and escalation plans for quick restoration.
• Resolved project issues/risks in timely and accurate manner to avoid delays and outages
• Developed UML models for modelling static and dynamic aspects of Online Banking System
• Designed web solution using UI solution in HTML5
• Developed data maps for retrieval of information from existing account systems and outlined security measures for accessibility and transmission of information
• Worked on creating various ad-hoc reports using MS-Excel Worked on various Pivot tables to do the calculations and creating reports accordingly
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Performed Data analysis, data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked with Portfolio Management/Accounting system: Portia and handled Corporate, Municipal, Treasury, Agencies and High Yield Traders.
• Worked in collaboration Finance IT department to process accounting application, accounting modules, data and procedures using Finance Peoplesoft.
• Implemented and maintained Property & Casualty ( data integration, version release) systems of assigned customers
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervising the development of User Manuals for customers.
• Agile/ Scrum Methodologies are used to implement the project.
• Designed, configured and testedACH and check payments.
• DesignedAP Voucher approval workflow.
• CreatednVision Balance Sheet reportsfor new Business Units. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
• Maintained Business Units and Accounts reporting tress usingTree Manager.
• Configured newAllocationsincludingInter-Unit Allocations.
• Applied a standard change control process in tracking defects originating from post-requirement phases
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures
• Analysed and optimized the process, prepared Business Requirements Document, and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite Pro
• Conducted JAD sessions for communicating with the all project directors and stakeholders and created process workflows, functional specifications and project initiation artifacts
• Created UML Diagrams including Use Cases diagrams, activity diagrams/state chart diagrams using Rational Rose and thus defining the Business Process Model and Data Process Model
• Monitored version control and defect tracking activities using Rational Clear Case and Rational Clear Quest
• Created and managed project templates, use case templates, requirement types, and traceability matrix in Requisite Pro
• Generated test cases in accordance to the Test Approach Document

Environment: Windows, Agile, MS Office(MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio), .NET, Oracle, Crystal reports, Peoplesoft Financial, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner.

Confidential, Lincoln, Rhode Island

Business Analyst

Responsibilities:

• Worked on various products likeDirectors and Officers, General Partners Liability, Employment Liability, Construction, Fiduciary, Excess and SurplusLines ofBusiness.
• Developed business requirement specification documents as well as high-level project plan
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data.
• Followed the UML based methods using Rational Rose and MS Visio to create: Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Involved in modifications & adjustments and 32 help desk tickets demonstrating determined work ethic and dedication to providing superior customer service.
• Created Complex SQL queries and used JDBC connectivity to access the database.
• Established a Business Analysis methodology around the Rational Unified Process.
• Involved in extensive data profiling, data quality checks, data mapping sessions and business test cases for Provisions data.
• Involved in Backend Testing to verify data integrity by using SQL.
• Excellent in writing Agile User Stories.
• Conducted meetings with IT, Testing and business to explain the Source to Target mappings and the business logic so as to be consistent in the final output/product. .
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Worked extensively with MS Excel and MS access
• 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.
• Have sizeable adequate hands on exposure in Workmen Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intricacies
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Involved in writing code using data step programming and macros to extract, clean and validate date from external source.
• Managed the development and implementation of the Independent Agent payroll system, Property & Casualty Specialist compensation system, Telesales compensation system, contingent and bonus compensation system and several compensation contract agreements with the Confidential agency sales force

Environment: Mainframes, HP QC, JCL, Db2, Oracle, Rose, MS Project, SQL, MS Word, MS PowerPoint, MS Excel, MS Visio, Load Runner, WinRunner

Confidential

Business Analyst

Responsibilities:

• Study and understand thoroughly the mortgage market and the different risks involved.
• Thoroughly understand the accounting processes that Confidential Bank uses from Loan Origination, Mortgage Servicing to Loan Payoff / Selloff.
• Involved in documenting Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Conducted user interviews (accountants) and interacted with the tech and development teams and SMEs to understand project scope analysis in order to prepare System Requirement Specifications (SRS).
• Act as the primary liaison between the accountants and the development team.
• Interact with the development team and insure that the developers clearly understand the business processes.
• Created Mapping document to map the plans, products, rate keys, commissions, groups/sections and agreements.
• Created Issue logs, Work request template, change request template and problem request template for the users.
• Worked on various methodologies such as Agile Software Development, Rapid Application Development (RAD), Joint Application Design (JAD) and Prototyping.
• Collaborated with the Project Managers in developing business processes and documentation of Business process flows using MS Visio.
• Identify the business and accounting triggers that will initiate the automated journal entry and define the various business and accounting events.
• Write SQL queries for balance conversions.
• Document the different accounting calculations based on the data elements required to process them.
• Used requirement management/Defect tracking tools like JIRA and Test Director.
• Designed and documented test cases and test plan according to the application requirements using Quality Center.
• Experience in conducting User Acceptance Testing (UAT).

Environment: Agile, Clear Case, Clear Quest, Rational Rose, Oracle, MS Office, MS Visio, Project, Windows, SQL.