Professional Summary:

• Over 8 years of IT experience for working as Business Analyst, data analyst and application admin with excellent customization and integration of various application experience for Investment Firms, Ecommerce, Finance and Insurance domain.
• Excellent 3 years of experience in Business and Data Analysis, Data Extraction, Data Manipulation ,Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Expertise in creating various project documents like BRD, FRD, Data mapping, data definition document, Data migration related documents , Test Plan, Test case, UAT Document etc.
• Excellent understanding for Data Modeling concepts with good knowledge Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Strong Experience in understanding Stored Procedures, Stored Functions, Database Triggers, OLAP, OLTP and specific data extraction using PL/SQL.
• Hand on Experience for Data extraction, Transformation and Loading for incoming data from different data source system in to Target Data system and Data manipulation by ETL tool.
• Very Good experience in Administration, Design, Development, Configuration, Implementation and support experience with finance related application and salesforce.com platform.
• Strong experience in CRM application Customization, Security Access, Workflow Approvals, Data Validation, Data Utilities, Analytics, Sales, Marketing, Customer Service and Support Administration
• Expertise in gathering requirement from different users and requirement analysis and documentation in desire format.
• Good understanding with interest Rates Swap client clearing process.
• Ability to analyze data in legacy applications to determine data migration/integration complexity, to identify data gaps against new requirements or conflicts across multiple legacy applications.
• Extensive knowledge in creating various UML diagram like Use case diagram, Activity Diagram and Sequence Diagram.
• Expertise in to documenting business case, specification and other technical detail for application.
• Working knowledge of data processing fundamentals including entity relationship diagrams, database models, structured application design and IT infrastructure networking and hardware
• Very Good understanding with Prime Brokerage processes.
• Experience with data quality assessment, cleansing, and improvement efforts
• Excellent experience in working with salesforce.com sandbox and production environments.
• Good understanding about interest rates swap and Other derivatives products
• Well versed in cloud technology and on-premise infrastructure integration for Salesforce.com using Force.com platform, XML, Web Services and third party packages.
• A professional with experience in the areas of Business Analysis, Project Management, Strategic Planning , Business Process Modeling and Reengineering, System Designing, Development, Testing and Validation.
• Strong Experience in end-to-end implementations of a core banking modules like deposits, savings, customer information systems including integrations.
• Excellent knowledge of Portfolio ,Mutual Funds, transfer agency operations and trading
• Facilitated requirement discussion with business owners and technical developers, gathered, documented and managed requirements using Rational Requisite Pro.
• Ability to work independently as well as effectively in team environment with excellent relation making skill with different technical and non-technical users.
• Strong experience in working as liaison between Marketing, Customer Care, Finance and Accounting, IT Development, Claims, Billing and Field Sales Professionals.

Project Summary:

Confidential

Business Analyst

Confidential is a diversified financial institution providing banking, insurance, wealth management and investments, mortgage and consumer finance across Confidential .

Responsibilities:

• Performed GAP Analysis and worked closely with the clients and stakeholders to develop a detailed understanding of the new requirements and features
• Organized JAD sessions with various projects stakeholders to elicit requirements, identify and resolve open issues
• Worked alongside with cross functional teams in order to establish comprehensive business and functional requirements and then translating those requirements into software design specifications using various notations of UML for designing and documenting the detailed business and functional requirements
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns as per department requirements
• Attended stakeholders meetings to document changes and implemented procedures to test changes Identified Use Cases from the requirements and created Use Case Diagrams, Activity Diagrams and Sequence Diagrams, based on UML Methodology using Rational Rose and MS Visio
• Worked closely with the QA Team to review and enhance the Test Plan and Test Cases
• Maintained the Requirements Traceability Matrix RTM between requirements and test cases
• Created Wire Frames and Screen Mock ups in MS Visio
• Involved in User Interface UI analysis with the business team to validate accuracy of the enhancements being developed
• Responsible for getting the sign off from the business on the BRD and wireframes.
• Prepared reports and presentations for weekly management meeting to update senior management on project deliverables, progress and timelines
• Assisted the IS and Technical team in understanding and developing the functionality

Confidential

Business System Analyst

Integro Insurance Brokers is the world's largest insurance broker and provides financial Services.

Responsibilities:

• Identified Business rules, Data mapping, and Application validation.
• Gathered requirements, conducted user interviews, analyzed and documented project plan using Requisite pro.
• Designed and developed Use Cases, Activity Diagrams, Wireframes and Sequence Diagrams using UML.
• Worked on Agile / Scrum based methodology
• Worked on User stories for sprint.
• Managed meetings, documented, and presented summarizations to the peers, and communicated with clients regarding issues and relays resolutions to all appropriate staff.
• Played a key role working closely with the Project Manager in rescheduling the project timelines using MS-Project.
• Participated in the bug review meetings.
• Updated requirement document as per business user feedback and change in functionality of the application.
• Rational Clear Case was used to manage all the changes and change requests in the projects. Clear Quest was used for the bug tracking.
• Assisted in development of training materials for new technology and process improvements.
• Clarified QA team issues and Reviewed test plans to make sure that all requirements will be covered in scripts and tested properly.
• Coordinated in performing Unit testing and Integration testing.
• Worked extensively on Access, Visio, and Excel

Confidential

Business Analyst

Responsibilities:.

• Involved in customer communication management, web-content management, digital asset management, forms processing, and compliance management.
• Identified use-cases from the requirements and write use-case specifications.
• Interacted with stakeholders to get a better understanding of client business processes and gather business requirements for Business Process Analysis and management.
• Created business process workflow diagrams activity diagrams using Rational Rose.
• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvements.
• Interacted with users for inquiries from customers from product purchase order or payment processing related.
• Participated in data design reviews and data preparation for newly build system.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Experience in developing Salesforce.com custom objects and work-flow business rules.
• Developed time dependent workflows as per the requirement.
• Created page layouts, search layouts to organize fields, custom links, related lists and other components on a record detail and edit pages.
• Developed and configured various custom reports and report folders for different user profiles.
• Developed and deployed Workflows and approval process wherever necessary.
• Created profiles, roles and implemented object level, field level and record level security.
• Evaluated Data entry, import processes and ensure proper data quality standards exist for the Salesforce.com application.
• Created multiple visual force pages for various requirement need.
• Experience in using Eclipse IDE to develop different development environment
• Implemented data migration using Informatica on demand.
• Used the sandbox for testing and migrated the code to the deployment instance after testing.
• Created test plan and test cases for user acceptance testing using testing tools.
• Conducted informal sessions to develop an architectural solution that the application meets business requirements, resolve open issues, and change requests
• Used Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.

Confidential

Business Analyst/ Data Analyst

Responsibilities:

• Interacted with clients to finalize the Business Requirements for the application and involved with Business Process Analysis.
• Performed the Requirement Analysis and documented the structured requirements management and Business Process management.
• Responsible to extract specific data set from Operation database ODS by using PL/SQL query in order to data cleansing process and new feed processing purpose.
• Derived As-Is and To-Be Scenarios and performed Gap Analysis and Impact Analysis
• Responsible for receiving data files from our vendors and preparing these files for load into a database for which a job/utility has already been developed .
• This includes reviewing the file structures and values, manually cleansing, manipulating, and filtering the data into the proper formats, understanding and applying proper business rules, etc.
• Involved in ETL specification designing for incoming feed coming from various data source and Data manipulation on it.
• Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
• Good Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling.
• Responsible for Integration of Legacy system in order to load legacy data set and incoming new data feed for TA and Asset data.
• Manage requirement with the help of Rational Requisite Pro.
• Closely interacted with designers and software developers to understand application functionality, navigational flow and updated them about end-user sentiments.
• Analyzed system requirements, developed detailed Test Plan, Test Cases and test scripts for testing the functionality, GUI and security.
• Produced the visual models for the application using Rational Rose to create Use Cases, State Charts, Sequence Diagrams and Activity Diagrams.
• Performed Risk Analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
• Tested the brokerage and financial services applications like Equities, Fixed Income, Investment Research, Investment Deposits, Accounts Accounts Activity, Balance Holdings, Portfolio Management , E-statements, Retail Consumer Lending, Mortgage Modules, Integration Module
• Facilitated weekly meetings with the review teams to improve the QA process.
• Used PowerPoint presentations for conducting walkthroughs with the stakeholders.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Monitored and analyzed the development of cascading style sheets in HTML at front end.

Confidential

Business system analyst

Responsibilities:

• Translates project requirements into project objectives and tasks, managing task assignment to project resources and reporting on and managing project scope throughout the project lifecycle.
• Close interaction with Infrastructure team for Product Evaluations, Prototyping, Development and support for Reusable components, Review on Application Design and Support Integrated Environments, Development and Configuration Management.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Understanding and analyzing the requirements of Clients to manage Business Process.
• Used Loan IQ to cover entire Life cycle of Loan.
• Prepared interview questionnaires for the users and gathered requirements and managed structured requirements.
• Analyzed User Requirement Document, Business Requirement Document BRD , Technical Requirement Specification and Functional Requirement Specification FRS .
• Performed Functional and GUI testing to ensure that the user acceptance criteria are met.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and product knowledge.
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams Activity diagrams, Sequence diagrams, Collaboration diagrams in VISIO
• Actively participated in performing testing for thoroughly understanding of the engineering process and BPM.
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Created Use Case scenarios and work flow diagrams after requirements gathering.
• Coordinated work plan between project manager and client with MS Project.
• Participated in Business Modeling by understanding the needs of the business, and also documenting Business use cases initial as well as System Use cases
• Coordinated with programmers and Testers to solve their problems.
• Participated in Walk Through and Defect report meetings periodically.
• Tested the project according to business rules and specifications.
• Documented Test cases, Test results and Test procedures

Confidential

Business Analyst

Responsibilities:

• Involved in the requirements and design walkthroughs with designers, developers and management staff
• Analyzed and optimized the process by performing various kind of analysis.
• Involved in Creation of UML Diagrams including Use Cases Diagrams, Activity Diagrams/Flow Chart Diagrams, Sequence Diagrams etc.
• Analyzed the business and functional requirements and the master test plan. Created Test Cases for various forms of the application manually. Involved in executing and designing test cases manually. Performed Integration, Functional and Regression Testing of the UAT.
• Involved in various financial calculations and manual validation of the results produced by the application. Involved in booking different types of bonds and calculating the Present values of the bonds.
• Extensively used Test Director Bug Tracker to keep track of bugs. Involved in submission of bugs through modification reports and frequent review of MR by conducting meetings during the development phase.