Post Job Free

Resume

Sign in

Project Data

Location:
Mumbai, MH, India
Posted:
May 04, 2016

Contact this candidate

Resume:

Name: Himani Soni

Email: acum2t@r.postjobfree.com

Phone: +1-408-***-****

PROFESSIONAL SUMMARY:

Over 7+ years of experience as a Business Analyst, majorly in Finance domain where responsibilities included implementing on-site business analysis, requirements management and data analysis for application development.

Worked in diverse domains like Internet Banking, Private Banking, Investment Banking, Retail, Mortgage, Insurance

Diverse Financial Domain Knowledge with experience in several sub domains like Asset Management, Fixed Income, Risk Management, Risk Analysis, Credit Risk & other Financial Derivatives

Demonstrated use of standard techniques JAD (Joint Application Development) interviewing, Use case modeling, GAP-fit analysis, process definition, requirements management for gathering requirements.

Experience in conducting Joint Application Development (JAD) sessions for requirements.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Gathering, analysis, design and Rapid Application Development (RAD).

Preparing graphical depictions of use cases including state diagrams, activity diagrams, sequence diagrams, use case diagrams, component-based diagrams, collateral Diagrams, including the business workflow.

Extensive experience working on MS Visio, Excel, Power point, Word, Access, Outlook, Pages, Keynote, Numbers and Concept Draw Pro

Excellent knowledge of industry standard methodologies of Software Development Life Cycle (SDLC), like Rational Unified Process (RUP).

Proficient in Test Director, Rational Requisite Pro and Agile Methodology

Extensive experience in Agile (Scrum, XP), RAD, Waterfall

Good experience in feasibility studies, Document generation and conducting sessions.

Comprehensive knowledge of the testing lifecycle within web, client server & Mainframe Environment.

Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.

Proficient in customizing already existing business practices, workflows, activities and Deliverables.

Good experience in developing User interfaces and requirements sessions.

Good experience in Requirements gathering, Data modeling, System Architect. Feasibility studies, Scope Documents, Requests for Proposal (RFP).

Proven ability to serve as a liaison between technical developers and product management.

TECHNICAL SKILLS:

Analysis Methodologies

Scrum, UML, Agile methodology, Waterfall methodology, SWOT, Cost-Benefit Analysis, Gap Analysis.

Databases and Tools

MS SQL Server 2008, SAP Sybase, MySQL, DB2, Oracle, Hadoop

Operating Systems

Microsoft Windows XP, UNIX

Quality Management

HP ALM, Quality Center, RM Track

Business Modeling Tools

Microsoft Visio, Share Point

Reporting

Crystal Reports, Business Objects, QlikView

Project Management

Microsoft Project, Microsoft Office Suite.

PROFESSIONAL EXPERIENCE:

Client: Bank of Tokyo, Jersey City, NJ Jan 2015- Present

Role: Business Analyst

Description: The Bank of Tokyo is the largest bank in Japan, which was established in January 2006, with the merger of the Bank of Tokyo-Mitsubishi, Ltd. and UFJ Bank Ltd. The bank serves as the core retail and commercial banking arm of the Mitsubishi UFJ Financial Group. The project was about Online CMS Application, an intranet application for clients and banking employees.

Responsibilities:

Responsible for Requirement gathering, Business Process Flow, Business Process Modeling and Business Analysis with Document and Records Management

Worked with the business community to define business requirements and analyze the functional requirements and gathered the requirement from stakeholder and SME’s

Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD) and involved in sign-off process

Prepared Change Request Document for the maintenance of the software

Conducting user interviews, gathering and analyzing requirements using Requisite Pro.

Conducting JAD sessions with the portfolio team to capture business requirements and system behavior using RUP.

Used the Agile (SCRUM) Methodology on the project.

Worked in the Scrum team and participated in backlog review and sprint planning sessions

Researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.

Refined and realized Use Case models created UML diagrams to reflect use case text narratives.

Participated in the Bug Review meeting to discuss outstanding issues with QA team and developers.

Worked with the UAT team to validate that the developed application will meet the business requirements.

Assisted with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Interview stakeholders and departmental Subject Matter Experts to identify process pain points in their business-critical imaging and printing workflows.

Define Business and Reporting requirements for reports. End-to-End Report Development.

Development of SQL logic, Analysis and Validation of data.

Responsibilities included Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing

Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test

Logged and resolved defects using JIRA

Developed Black Box testing and Provided support for User Acceptance Testing with UAT cases and resolving any issues with the users and performed UAT and participated in writing test plans

Environment: Oracle, UML, RUP, Microsoft Suite (Access, Excel, Word, PowerPoint, Visio), Rational Requisite Pro, SQL, SharePoint, Quality Center.

Client: Fifth Third Bank, Cincinnati, OH Aug 2013- Dec 2014

Role: Business Analyst

Description: Fifth Third Bank has its headquarters in Cincinnati, OH. Involved in implementing one of the top 25 IT projects, which included the integration of the current Corporate Banking solution product at 53 bank with the Sybase product ‘Financial Fusion’ which encompasses a full range of services like Multi-user access, User profile management, Entitlements, Account management and Cash management.

Responsibilities:

Gathered business requirements from stakeholders and translate them into detailed requirement specifications.

Used SDLC (System Development Life Cycle) methodologies like the RUP and the Waterfall.

Performed requirements gathering process in iterative approach using RUP methodology.

Prepared Business Requirement Document (BRD) and Software Requirement Specification (SRS)

Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams (UML)

Worked in designed and development of Project document templates based on SDLC methodology.

Created a Technical Specification Document which would be used all across business streams to implement the solution

Helped with data modeling and defining the conceptual and logical model of the data warehouse.

Work with architects and Business Analyst to design SRS as well as HLD.

Performed Gap analysis and implemented updates for the Data Warehousing Application.

Employed SDLC for the purpose of monitoring the project and also followed the step-by-step procedure

Facilitated JAD sessions with management, users and other stakeholders to define the project and to reduce the time frame required to complete deliverables

Worked with Team Foundation Server

Assisted Project Manager to get CAB approval for various sprint releases.

Managed and documented the change requests.

Maintained Requirement Traceability Matrix.

Environment: Agile Scrum, Windows XP, MS Office, Access, Visio, Project, SharePoint, MS SQL Server, Rational Rose, Requisite Pro, Clear Quest, Clear Case, Oracle, Rational Requirements Composer, HTML.

Client: Bank of the West, Monterey Park, CA Aug 2012 – July 2013

Role: Sr. Data Analyst

Description: The project involved in extracting data from different sources and loading into Data Marts. The major job involved in cleansing the data and transforming the data to the staging area then loading the data in the Data Marts. The Data Marts is an integrated Data Mine that provides feed for extensive reporting. It enables an insight into the current and future financial situation/needs based on the information received from the Data Warehouse.

Responsibilities:

Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.

Dealt with conflicting scenarios when the requirements and the reverse engineering communicated different cleansing rules.

Always patient in analyzing the root cause of data issues and clarifying it with the data owners.

Performed Reverse Engineering of the legacy application using DDL scripts in Erwin, and developed Logical and Physical data models for Central Model consolidation.

Worked with DBA’s to create a best fit Physical Data Model from the Logical Data Model using Erwin.

Administered and maintained the model updates using Model Mart for the entire project team.

Employed process and data analysis to model a Customer Information Business System.

Conducted logical data model walkthroughs and validation.

Conducted team meetings and JAD sessions.

Developed data mapping documents for integration into a central model and depicting data flow across systems.

Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models

Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.

Involved in performing extensive Back-End Testing by writing SQL queries and PL/SQL stored procedures to extract the data from SQL Database using Hadoop.

Developed the data warehouse model (star schema) for the proposed central model for the Project.

Developed Process Methodology for the Reverse Engineering phase of the project.

Developed and maintained the central repository, populated it with the metadata.

Used Business Objects for validating the metadata and testing the data of reports.

Designed and developed reports for the data in the Data Warehouse using Business Objects / excel.

Analyzed data using Slice/Dice and Drill up/Drill down to analyze data to meet the end user’s requirements.

Environment: Oracle 11g, Erwin 4.0, MS Visio, MS Office, MS Excel, SQL, Hadoop, SAP Sybase adaptive Server enterprise, SAP Business Objects 4.1,

Client: Bank of America, San Francisco, CA Oct 2011 - Aug 2012

Role: Data Analyst

Description: Reporting features as part of website was required to be redefined to make money management more efficient for customers. The new reports helped customers track expenses and income by category, set budget goals and monitor performance against goal for all of their financial accounts.

Responsibilities:

Performed source data identification and analysis to get a clean master data to report to customer

Liaison between stakeholders, system users, clients and managers, software development team and the QA term to gather requirements.

Designed and implemented complex SQL queries for QA testing and report/ data validation.

Data analysis and reporting using MY SQL, MS Power Point, MS Access and SQL assistant.

Monitored performance, integrity to optimize SQL queries for better efficiency

Performed data cleansing, data validation and mapping as described in the business requirements.

Write down the SAS programs for processing of data sets and perform data mapping in the data warehouse.

Created interactive reports and dashboards using tool tips and customized features such as subtotal, alerts, color coding and drill maps to better understand business trends

Proficient in downloading SAS flat files to Microsoft Word, Access or Excel for additional database for manipulation and analysis.

Tested dashboards and reviewed the data for various KPI.

Extensive use of EXCEL PIVOT tables to run and analyze the result data set and perform UNIX scripting.

Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.

Analyzed, build and documented the different Metadata and Data dictionaries that will be required

Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure

Environment: SQL, MY SQL, Erwin, Data Stage 6.0, Model Mart, MS Sharepoint, PL/SQL and SAS.

Client: ICICI Bank, Mumbai, India Dec 2009 - Sep 2011

Role: Business Analyst

Description: ICICI is an Indian multinational bank and provides financial services to corporate and retail customers. The project contains the automation of the Mortgage Loan Origination Process. It begins with the customer initiation to title transfer. It was supposed to perform all the business functions of the loan process as New Loan setup, Credit and Income, Title functionalities and Appraisal.

Responsibilities:

Responsible to drive process from analysis till implementation using SDLC methodology including testing, quality assurance and gathering business requirements.

Conducted Data Analysis for existing project and identified new conflicts, situations and/or project to recommend alternative strategies for accomplishing desired goals.

Assisted Program Manager to ensure project coordination and timely document review and approval.

Establish and maintain activity logs, performance metrics, project plans, and other pertinent forms and documents to provide the basis for resource allocation, reporting, budgeting, and forecasting.

Used Six-Sigma (DMAIC) tools for process improvement and achieving desired goals.

Managed Change Requests and performed impact analysis.

Created and managed a master project plan with work breakdown structures in MS Project.

Responsible for project defining: Define business process, functionality and participate in new systems evaluation and adoption.

Providing liaison between engineering teams, business areas, and end users.

Environment: Windows NT, MS Visio, MS Project, MS Outlook, MS Office (Excel, PowerPoint, Word).

Client: Bajaj Allianz, Mumbai, India Jun 2008 - Dec 2009

Role: Business Analyst

Description: Bajaj Allianz provides Health insurance in India. In order to cater to a bigger customer base an online account services was developed that could be used to make customer profile, see bill payment, check billing history.

Responsibilities:

Involved in all phases of software development life cycle.

Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.

Contributed in defining the Scope of the project and defined functional specifications.

Analyzed and documented the system specifications, Business requirements; used the tool Telelogic DOORS for documenting, tracking and analyzing the requirements.

Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.

Used UML to produce Use-Cases, Use case diagrams and Activity diagrams to explain process flows and functional specifications.

Used the tool Systems Architect and MS Visio to create use case diagrams and process flows.

Used Mercury Quality Center to look up defects and issues raised by testing activities.

Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Produced and managed documentation on release activities to support problem resolution.

Review prototypes, solution blueprints, and project scope to ensure that the needs of the business are being met

Used the Agile (SCRUM) Methodology on the project.

Worked in the Scrum team and participated in backlog review and sprint planning sessions

Translated the requirements to the IT and web production teams in building their HTML for the projects

Used MS Project to document the project progress and manage the project resources

Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using MS Visio according to UML methodology

Responsible for giving Knowledge Transfer (KT) sessions of the project to the Production Support Team.

Environment: MS Office, MS Visio, RUP, UML, SQL, Oracle 8i.



Contact this candidate