Bala's InformationTitle: developerWilling to Relocate: NoMember Since: 2012-08-13

-->

Email Id : abp6z0@r.postjobfree.com

*** - *** - ****

Phone Number:

AMIT MAHAJAN

SUMMARY:

Business Analysis: 8 years of IT experience involved with Lead Business Analysis, Domain Analysis,

Data Analysis, Business Rules, Gap Analysis, Prototyping, developing/creating business process related documents while working in the Financial Services, Investment Banking, Fixed Income,

Equities/Trade Cycle, ETF/Securities Trade Processing/Clearing, Anti Money Laundering, FED Compliances, Fraud Detection, Asset Management and Mortgage, Cost Controls,

Capital Budgeting and Capacity Management.

Business Process Analysis: 8 Years of experience conducting and documenting the As-Is/To-Be processes and Business Process Re-engineering (BPR) exercises according to the Rational Unified Process (RUP) and UML development methodology along with understanding of Rapid Application Development (RAD) and System Development Methodology (SDM)

Data Analysis: 7 years of experience in Data Management, Data Gathering, data collection and identifying data functional requirements for users

Identified opportunities for business process improvement and initiate efforts to make improvements

Has worked based on industry best practice, including the Information Technology Infrastructure Library (ITIL), international standards such as ISO:20000

Worked with ITIL based Configuration Management Process design and development for financial sector projects. This process included Closed Loop Change Management, ensuring that all changes to in scope items where validated in both the environment and the database.

SDLC: In depth strong working knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process

Object Oriented Analysis: 7 years of extensive experience in Rational Rose, UML, Rational Requisite Pro, Erwin, MS Visio, MS Microsoft Office Suite, Rational testing tools, Rational ClearCase for test documentation and version control.

Extensive experience in gathering Business/Functional user requirements, creating Use Cases as per user requirements, developing/designing diagrams such as Activity, Class, and or Sequence diagrams, and in addition to creating Business Requirements Document (BRD)

Quality Assurance: Experience in conducting Joint Application Development (JAD) sessions with end users, expert team, QA team, and stakeholders for project related meetings.

Has expertise in working in Dashboard Repository Environment. Has also worked with Sybase Power Designer for requirement gathering and shared Repository with Version control.

Understanding of the AS-IS business processes and collected and maintained business and system requirements for the TO-BE system, created GAP analysis reports from As-Is and To-Be documents. Prepared Visio process diagrams, system architecture/feasibility studies, RFPs, and BPR reports

Data Warehousing Analysis: Understanding of Fact tables, Dimensions tables, Star schema and Snowflake schema, Data Analysis, Data Modeling, BI reporting, logical and physical models with specific reference to Informatica Enterprise

Expertise in generating and executing Ad-hoc Reports.

Excellent communication skills to help facilitate requirements and communication between the client and the project team. Developed and conducted internal training programs for various applications. Developed, updated, and reviewed training documentation and course materials.

Developed/executed test scenarios and use cases to support the development team and business groups. Developed Test Cases for Unit Testing, Regression Testing, and User Acceptance Testing along with issue/bug tracking

Reviewed test scenarios and test cases for UAT and regression testing to support pre and post implementation of applications and production issues along with QA and other business groups, in addition to maintaining Test Matrix and Requirements Traceability Matrix (RTM)

Exposure to SOX (Sarbanes-Oxley Compliance) and Dodd Frank for internal auditing teams

Excellent analytical, interpersonal, communicational, presentational, administration skills through out the product life cycle and within business units

Exposure to Smart boards and Digital Asset Management modules

Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision

Belief in team work, dedication, and professional ethics within the working environment

Exceptional experience in building strong relationships with diverse clientele engaging as a liaison/specialist between clients and staff

Experience working under pressure with minimum supervision in a with devoted leadership experience

Business documentation:

Simplified Business Use Case documentations

Business Process Flows and Test cases

SKILLS SPECIALISATION:

Business Analysis: Requirement Analysis, Business Rules, Data Flow Diagrams, Flowcharts, Business Process Modeling & Improvement, Gap Analysis, Prototyping,

Cause and Effect Analysis, BRD, BRS

Software Packages/ Processes Model Tools:

MS Office Suite 9X/2000/XP(PowerPoint, Word, Excel- High level Macros, VBA, Access, and Outlook), Banner, Lotus Notes, MS Outlook, MS Project, Optimal Trace, MS Visio, Rational Rose; Rational Requisite Pro, Sunguard, Business Objects 8, Sybase Power Designer.

Rational Tools: RUP, UML with Rational Rose, Rational Requisite Pro 6.x, ClearQuest, ClearCase, Together Soft (UML), MS Office Suite, MS Visio, MS Project, Optimal Trace

Databases and Programming Languages:

MS Access 95/97/00/02, MS SQL server 2003/2007, Oracle 10g/9i/8i/7.x,Teradata, J2EE, .Net, PL/SQL

Operating Systems: MS Windows (9X/NT/2000/XP), Linux, Unix, Sun Solaris 8/9/10

Web Servers/Middlewares: MS IIS, Apache, BEA WebLogic, BEA Tuxedo, MQ Series

Data Warehousing: Data Mart, Micro Strategy Design, Design Schemas: Snowflake and Star, OLTP, OLAP, ROLAP, MOLAP

Data Modeling: ER Diagrams, Erwin, Sybase Power Designer, Conceptual, Logical,

Physical schema

Methodologies: Spiral/ RAD, JAD, RUP, Agile, OOA, OOD, UML, Prototyping,

Use Case

Version Control Tools: Rational ClearCase, ClearQuest, PVCS

Testing tools: Mercury Test Director, Win Runner, Rational Suite

PROFESSIONAL EXPERIENCE

Sr Business Analyst September 2008 - Present

CIBC World Markets, NY

CIBC World Markets financial services include credit and capital market products, investment banking, commercial banking and merchant brokerage. The application was developed using J2EE as a product to capture, analyze, calculate and report risks for all asset classes traded by the client bank and Portfolio Managers.

The asset classes consisted of OTC bond options, Repos, commodities, stock loan/borrow, OTC derivatives, ETF, FX options/FX forward. It could generate paths and stress scenarios so that trade can be valued against various paths and scenarios. Used Sunguard solutions for efficient processing of Client Securities and Derivatives. Understood the integrity of BancWare Focus ALM for actively measuring and managing the interest rate and FX risk in the banking book and keeping them in mind while writing the requirements. It allowed traders to perform what-if analysis, stress test and computed VaR and Quantitative Risk Management (QRM) under different confidence levels.

Responsibilities:

Participated in project review meetings and gathering Business Requirement Documents (BRD) for Equities and Stock Options Front Office Trading Application

Conducted user interviews, gathered requirements, analyzed the requirements using Rational Rose requisite pro - RUP

Developed use cases, functional specifications and wireframes associated with system requirements.

Performed in-depth, quantitative analysis to identify key risks and provided comprehensive measurement and reporting utilizing Excel

Assisted groups in Operations with Pivot Tables, Graphs, and complex financial modeling using VBA and Excel.

Front to back office exposure in a derivatives clearing environment including understanding of rates, derivatives clearing, LCH Swapclear and Markit SERV

Experience with FIX Protocols 4.2 and 4.4.

Gathered requirements for application functions featuring changes in credit quality, defaults and delinquency

Integrated the gathering and vetting of planning assumptions directly into your BancWare ALM process

Understood the impact of interest rate volatility on your balance sheet

Designed and developed Use Cases, Class Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams, OOD (Object oriented Design)

Designed documentation pertaining to Informatica data migration applications.

Designed System Logical models for data migration from Mainframe to Application Server.

Drafted detailed Functional Requirements Documents using Used Cases for better accuracy and message pass on.

Developed and designed software in the form of interoperable services as per Service Oriented Architecture (SOA)

Experience with ERDs to analyze the nature of all significant interactions.

Participated in JAD and JRP sessions and interacted with technical leaders from various departments

Worked directly with Portfolio Managers and Traders in getting the Requirements.

Extensive working with data modeling diagrams and creating ER diagrams with the understanding of data flow at back end interfaces.

Managed and lead the whole Functional Team and grafted the requirements road map

Designed the business requirement collection approach based on the project scope and Agile methodology

Have done requirements analysis using Sybase Power Designer and understood the impact analysis and design-time time change effect

Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements

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

Created and Maintained Supporting documents (technical, business, project level and sops) to meet Agile standards

Conducted User Acceptance Testing (UAT)

Worked with Business Intelligence tools like Microstrategy and good understanding of Relational OLAP and Multidimensional OLAP.

Assisted ETL team to redirect the data flow in Datamarts

Extensive Experience in Datawarehousing.

Excellent working knowledge of regulatory requirements

Maintained the Requirement Traceability Matrix (RTM)

Defined various scenarios for testing the application and wrote test cases based on these scenarios as well as ad-hoc test cases based on interactions with users

Developed and wrote test cases for the testing efforts in compliance with Design Control Policy

Has gathered requirements and created used case for Teradata and Enterprise Data Modelling

Updated and wrote several SOPs for day-to-day functioning of the system as well as emergency operation (system recovery, back-up, etc)

Created a detail Requirements, Test plan and procedures for application testing using Rational Test Manager.

Made sure that the current testing practices meet legal compliancy standards

Performed data integrity testing by executing SQL statements.

Environment: Windows 2000, XML, HTML, XML, XSL, MS Visio, MS Project

Business Analyst April 2005 - August 2008

LaSalle Bank [Now BOFA] Troy, MI

La Salle Bank offers complete range of retail, commercial and investment banking solutions.

LaSalle is ranked the largest bank in Midwest in terms of deposit market .The bank needed to revamp its transactional processing infrastructure and system features that supported the Online Banking feature and brokerage transactions. This included re-developing the entire online business solution with more comprehensively defined business and user requirements.

Responsibilities:

Communicated with Business Users to identify needs, define project scope, and detail functional and non-functional requirements

Wrote detailed Functional Requirements Document and Non Functional Requirements pertaining to the future system

Gathered and analyzed business requirements by facilitating JAR/JAD Sessions.

Documented the Business requirements and other artifacts while using the Waterfall Approach for development

Developed ETL process using SQL Server Integration Services (SSIS)

Successfully used RUP Analysis model, gathered requirements, facilitating use case workshops in sessions

Used tools such as Rational Requisite Pro, defined Business and System use cases and Activity diagrams

Reviewed documents/templates to create BRD and implemented the RUP process, identified Gap Analysis and the AS-IS and TO-BE model

Worked on the Flowchart and Process diagrams using MS Visio

Generated Use Case diagrams, Sequence diagrams, Business Objects reports, Domain Object Model, in addition to creating and presenting PowerPoint presentations

Held and attended presentations and meetings to coordinate efforts among all the groups, leading the inception phase

Environment: Rational Unified Process (RUP), MS Visio, MS Project, MS Office Suite, Windows 2000/XP, Oracle 7.3, and Visual Basic 6.0

Business Analyst January 2004 - March 2005

Reliance Telecom, New Delhi, INDIA

Reliance is one of the top Indian CDMA based Telecom Company in India. Its having a huge mobile users of 10 million. The project we did was to develop an application that provides the customers to see their account usage through online, as Reliance was expanding its wireless coverage during 2002. So we also have to develop an application to manage the database of growing number of users.

Responsibilities:

Conducted project review meetings and gathered Business Requirement Documents (BRD).

Conducted user interviews, gathered requirements and analyzed the requirements.

Designed and developed Use Cases.

Participated in JAD and interacted with technical leaders from various departments (Designed the business requirement collection approach based on the project scope and SDLC methodology.

Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.

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

Created and maintained documents (technical, business, project level and sops) to meet SDLC standards.

Conducted User Acceptance Testing (UAT).

Defined various scenarios for testing the application and wrote test cases based on these scenarios as well as ad-hoc test cases based on interactions with users.

Developed and wrote test cases for the testing

Created a detail Requirements, Test plan and procedures for application.

Environment: MS Excel, MS Word, MS PowerPoint, Windows 2000

EDUCATION:

Bachelors in Computer Engineering 2001

Punjab Technical University

Masters in Business Administration 2003

Punjab Technical University

Contact this candidate