PROFESSIONAL SUMMARY:

• 6+years of experience as a Business Analyst wif solid understanding of Online Banking, Trading, Property and Casual Insurance, Policy Administration and In - depth noledge 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 noledge 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 wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate effectively wif 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 noledge of e-commerce business processes and e-commerce concepts and terminologies.
• Experience wif 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 wif end users and guide them to successfully achieve teh 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 teh Requirements using Requirement Traceability Matrix (RTM) which halped in controlling numerous artifacts produced by teh teams across teh deliverables for a project
• Strong noledge and working experience of industry standards such as Six Sigma, CMMI, and ISO 9000, SDLC, DMAIC, IIBA, BABOK and PMBOK.
• Excellent noledge wif Data Warehouse and Business Intelligence (BI), Data Management and Database Design, Business Analysis and Information Engineering, Software Quality Assurance, Advance in Data Integration
• Experienced wif different Relational databases like Teradata, Oracle and SQL Server.
• Communicated and ensured compliance of all policies and procedures wifin teh retail organization.
• Experience in conducting GAP analysis, SWOT analysis, Risk analysis, Mitigation plan and Impact analysis.
• Widespread interaction wif 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 wif teh 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 teh new system to meet teh end user requirements
• Experience in creating Accounting Periods, users, Assigned role to users and completed unit testing to ensure that teh 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 wifin 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 wif 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 teh business groups to provide support for Business Intelligence toolsets like OBIEE.
• Provided Gap Analysis, Cost/benefit analysis and understanding teh business perspectives on many financial and operational issues.
• Generated queries in Oracle and SQL Server.
• Hands on experience on swim lane to creating teh flow charts.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Narrative using teh Business Process Modeling Notation (BPMN) methodologies.
• Documented teh current business flows for Utilization Management (UM), Case Management (CM) and Disease Management (DM)
• Major functionality provided in teh 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 teh reports by writing Teradata SQL Queries and using MS Excel & Power Point.
• Involved in designing user interface for teh different Online Transaction Processing modules using JSP and Controller Servlets.
• Worked wif Business Analyst to ensure project implementation wifin 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 teh 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 teh catalog and pricing online.
• Involved in collecting customer data from teh legacy systems and developing teh data dictionaries.
• Involved in designing teh loan processing module using Struts Framework.
• Involved in developed prototype of new information processing application module.
• Documented teh Requirements Traceability Matrix (RTM) in Requisite Pro and swim lane.
• Involved in preparing test plan and test cases based of functional requirements using Rational Test Manager for teh business requirements verification and validation.
• Develop and produce aggregated and dashboard reports using MS SQL, MS Access and MS Excel.
• Wrapped up teh 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 teh application development for better understanding of teh 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 teh current quality of teh application.
• Performed teh System, Integration testing and User acceptance testing using Test Director.

Environment: Rational Rose, Rational Requisite Pro, swim lane, 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 wif 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 teh scope and requirements of Asset Management portals middle office needs
• Assisted in daily settlement operations of middle office in coordination wif 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 teh 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 wif 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 teh 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 wif 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 teh development of User Manuals for customers.
• Agile/ Scrum Methodologies are used to implement teh 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 teh process, prepared Business Requirements Document, and tan converted business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite Pro
• Conducted JAD sessions for communicating wif teh 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 teh 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 teh 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 tan submitted to project management on a weekly basis in MS project.
• Used SQL, Data Warehousing and Data Cleansing for teh arrangement of customer data.
• Followed teh 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 halp desk tickets demonstrating determined work ethic and dedication to providing superior customer service.
• Created Complex SQL queries and used JDBC connectivity to access teh database.
• Established a Business Analysis methodology around teh 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 wif IT, Testing and business to explain teh Source to Target mappings and teh business logic so as to be consistent in teh final output/product. .
• Successfully conducted JAD sessions, which halped synchronize teh different stakeholders on their objectives and halped teh developers to have a clear-cut picture of teh project.
• Worked extensively wif MS Excel and MS access
• Planned and defined system requirements to Wire Frames wif Use Case, Use Case Scenario and Use Case Narrative using teh 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 teh development and implementation of teh Independent Agent payroll system, Property & Casualty Specialist compensation system, Telesales compensation system, contingent and bonus compensation system and several compensation contract agreements wif teh MetLife 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.