SUMMARY

• 6 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, fixed income.
• 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, operational 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.
• Good knowledge in STAR Schema and Snow Flake Schema.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Hands on experience on PLSQL, SSIS, SSAS, SSRS, Power Pivot and Power View reports.Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
• Experience in Designing Business Intelligence Solutions with MicrosoftSQLServer 2008 and 2012 using MSSQLServer Integration Services (SSIS), MSSQLServer Reporting Services (SSRS) andSQLServer Analysis Services (SSAS).
• 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
• 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 AccountsPayable, 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.
• Developed, implemented and evaluated metadata and cataloging workflows and standards.
• Prepared and maintained metadata templates and documentation for digitized and digital library collections.
• Developed, analyzed, improved and maintained metadata information.
• Interpreted and adhered to established cataloging and metadata standards.
• Generated queries in Oracle and SQL Server.
• Have a knowledge on highly intelligent individuals each seeking to make BiSam/BarraOne the best provider of information and analytic services to its client base.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Worked in debugging and tuning the PL/SQL code, explain plan, tuning queries and optimization for the Oracle database.
• Experience of Data modelling (both transactional OLTP and dimensional OLAP).
• Extensive experience in Database query and Performance tuning of Reports and troubleshooting Oracle Application issues on OLTP systems.
• Experience in Designing Business Intelligence Solutions with MicrosoftSQLServer 2008 and 2012 using MSSQLServer Integration Services (SSIS), MSSQLServer Reporting Services (SSRS) andSQLServer Analysis Services (SSAS).
• Extensive testing ETL experience using Informatics 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor. functional systems analyst experience with Oracle Taleo solutions (client is on version 15a)
• Hands-on system configuration experience with Taleo Recruiting Enterprise Edition and On boarding
• Strong PeopleSoft HR - functional expertise
• Experience with labor relations software (disciplinary and grievance) - functional (is a plus )
• Complete understanding of the Oracle Taleo architecture.
• Extensive experience with setup and configuration of Oracle Taleo module
• Experience with Taleo integration and interfaces
• Experience in implementing, integrating legacy, or Oracle HRMS/ HCM applications with Taleo cloud based ERP
• Experience providing functional support for loading data using Oracle Taleo tools
• Good knowledge on sparx system With Enterprise Architect the Business Analyst can model high level processes of the business with Analysis diagrams.
• Excellent skills in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, excel sheets, Flat Files and MS Access.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• 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).
• Responsible for the SIT/SIT/UI testing and on boarding of new Client SWIFT messaging system using the Brown Brothers Proprietary Infomediary SWIFT
• Worked closely with Fixed Income and derivatives.
• Worked with loan IQ andResponsible for creating the business and/or functional requirements necessary for creating software products that meet customer needs, expected delivery dates, and exceptional quality standards.
• Analysis of new business requirements / strategic road map for client specific enhancements and translation into product-specific designs/ detailed Requirement Definitions/and Use Cases.
• Serve as liaison between the development team, strategic partners or/and the business users.
• Develop use cases, mock up screens, Data Flow Diagrams etc. to explain/demonstrate business requirements/specifications to development team.
• Lead offshore QA teams on understanding the business requirement and prioritizing testing paths.
• Assist Customer Support on L3 issues by providing the workaround and suggesting the solutions.
• Assist solution managers for strategic product enhancements.
• 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
• 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.
• Involved in designing user interface for the different Online TransactionProcessing 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, operational risk management 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) inRequisite 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

Sr. Business 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.
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Worked closely with Fixed Income and derivatives.
• 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
• Have a knowledge on highly intelligent individuals each seeking to make BiSam/BarraOne the best provider of information and analytic services to its client base.
• 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 traceabilitymatrix 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