Business Analyst

Rai, K. Ashish

Technology Consultant

************@*****.***

517-***-****

https://www.linkedin.com/in/ashishrai123

SUMMARY

Over five years of IT experience in banking & finance sector. A proven track record of managing regulator’s expectations and coordinating with IT vendors. Good experience of software implementation in field of Business Intelligence Solution, Data warehouse, Data Analysis, Data Modelling, and Enterprise Resource Planning. I have completed my Master in Business & Information Systems (with 3.96 GPA) from New Jersey Institute of Technology (NJIT) University.

SKILLS & TECHNOLOGIES

Requirement Engineering/Analysis

Business Analysis

Quality assurance & Testing

SQL Programming – T-SQL, Oracle w/ PL-SQL

Data Analytics – Tableau / SAP BI / Excel / R programming

ETL – Informatica Power center, Oracle w/ PL-SQL, SQL Server w/ T-SQL

Enterprise Data Warehouse – Informatica Power center, Oracle w/ PL-SQL, SQL Server w/ T-SQL

Prototyping & Scenario building – Axure

Vendor management

Enterprise Resource Planning (Finance / Accounting) – Ramco ERP

MS Office - MS-Excel, MS-Power point, MS-Word

EXPERIENCE (5+ years)

New Jersey Institute of Technology (NJIT) University

Intern – Business Analyst

May 2015 – Dec 2015

Requirement elicitation

Designed & Developed prototype using Axure tool

Created scenario based story board

Assisted in Data modelling using MS-SQL

SQL Query writing

Data Analytics on collected data sets using Tableau 9.0

Tools Used: Axure Prototyping Tool, MS-SQL Server, T-SQL Programming, Tableau 9.0, Microsoft Visio, MS Excel, MS Word

Corporation Bank Ltd

Sr. Business Analyst for implementation of Enterprise Data Warehouse (Business Intelligence Solution)

Jun 2011 – Dec 2014

Requirement elicitation through Brain Storming, User Observation, & Prototyping

Goal Modeling in UML using Use Case Diagrams, Misuse Cases

Modeling Context using Gap Analysis, SWOT, & PEST

Modeled business processes by analyzing the bank’s business scenarios

Framing the Data Extraction and Migration strategies on the basis of business requirement.

Involved in Data Modelling

Assisted vendors in designing and developing the ETL process for extracting data from different sources

Write Test Cases and coordinated in User Acceptance Testing (UAT)

Collaborated with end users, regulators and Vendor team and Served as a single point of contact for all communication

Tools Used: Informatica 9.1, MS-SQL Server, T-SQL Programming, Oracle w/ PL-SQL, Tableau 8.0, Microsoft Visio, MS Excel, MS Word

Business Analyst for SWIFT Data migration & Data Analysis project

Analysed the upgrade requirements through Discussions and User Observations with vendor & business team.

Conducting the Impact Analysis and establishing the disaster recovery site as the result of the same

Coordinated with the vendor for the application & server upgrade

Conducted approximately 5 workshops for the users to train them future system

Identified & closed GAPs in requirement

Tools Used: SWIFT 6.0 tools, MS-SQL Server, T-SQL programming, Microsoft Visio, MS Excel, MS Word

Business Analyst for system integration of Treasury system & Core banking system

Implemented STP (Straight Through Processing) for integration of Treasury Management System & Core banking System

Analysed Business Logics and gather requirements through discussions and prototyping with vendor and business team

Designed & Developed the process for synchronizing data between the two applications

Write test cases and coordinated in System Testing and User Acceptance Testing (UAT)

Tools Used: MS-SQL Server, Oracle w/ PL-SQL, Microsoft Visio, MS Excel, MS Word.

CBS Pvt Ltd

Junior Business Analyst for ERP solution implementation

Nov 2007 – Apr 2009

Analysed requirements through discussions with client business team & previous implementation team

Designed and developed the business reports

Developed different procedure to populate data for those reports

Developed different utilities as per business requirement using EDKs (Extension Development Kit)

Created Store procedures and views

Developed Drilldown reports using SQL Server

Developed reports using SQL Server with Crystal Software reporting tool

Tools Used: MS-SQL Server, T-SQL, Cristal report tool, MS Word, MS Power point.

EDUCATION

New Jersey Institute of Technology (NJIT) University

Jan 2015 – Dec 2015

Master of Business Information Systems

GPA 3.96

Institute of Management Studies -

Jun 2009 – May 2011

Master in Business Administration, Finance/IT GPA 3.48

Contact this candidate