PROFESSIONAL SUMMARY:

• Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
• Experience in designing and developing reports using Microsoft Reporting Services MSRS , Crystal Reports, MS Access, and Data View web par
• Comprehensive knowledge of the Student Loan industry and Commercial Lending.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Strong experience in RUP Business modeling process.
• Good understanding knowledge of Commercial Lending, Commercial Loan, Risk analysis,
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Seven years of professional experience as a Business Analyst in Finance domain.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Experienced in SQL Server Reporting Service SSRS , Executing Queries and Running Store Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Strong business analysis skills and a sound understanding of the Software Development Life Cycle SDLC utilizing Rational Unified Process RUP methodology.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.

Software/Hardware:

Rational Rose Enterprise Suite, Rational Requisite Pro, MS Visio, Test Director, Test Manager, Rational Clear Quest, PVCS Tracker, MS Office, MS Project, MS Publisher, MSRS, Rational Robot, Performance Studio, Mercury Win Runner, Load Runner, Korn Shell Script, C/C , Java 2, Teradata, SQL, PL/SQL, VB, Shell Script, Html, Crystal Reports, Micro strategy, Visual Basic, Access, Excel, MS-SQL Server, Oracle, Sybase, SQL Plus, UNIX Solaris/Linux , MS-DOS, Windows 95/ 98/ 00/NT/XP, MS FrontPage, Dream weaver

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Confidential is the most complete source of integrated Data, Information security and technology applications in the global financial services industry. The project was dubbed Thomson-ONE , where Thomson Financial developed common product delivery architecture. The Microsoft GP framework was chosen to meet customer needs and reduce the complexity of the IT infrastructure.

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observations using agile method.
• Conducted controlled, brainstorming sessions with project focus groups.
• Prepared Business Requirement Documents containing the essential business elements, detailed definitions of terms, analysis of business data requirements, SoD controls and detailed descriptions of the relationships between the actors in the existing business process workflows.
• Planned and defined system requirements by writing Use Cases, Use Case Scenarios and Use Case Narratives using the UML.
• Leaded conferences with customers and prospects, and administered billing in Dynamics GP
• Created Use Case Diagrams with Visio, Business Flow diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
• Facilitated JAD sessions with management, SMEs, users and other stakeholders for open and pending issues to develop specifications and used Agile Management throughout the project.
• Wrote full functional and technical specifications and communicated requirements to development teams.
• Created and maintained complete development plans that included functional specifications, Use Cases and credit risk assessments with principles prescribed under Basel II.
• Implemented team connect. to create a robust solution development framework
• Performed several Microsoft Great Plains database migrations/upgrades from various databases to the latest Microsoft SQL Server versions.
• Conducted User Acceptance Testing on the application resolved issues from the participants, prepared Test Analysis Reports and participated in Product Readiness Review and Product planning.
• Conducted presentations and walkthroughs with end users and stakeholders prior to formal training sessions.
• Conducted user and other appropriate stakeholder training sessions.

Environment: Rational Suite, SAS/ Base, Microsoft.NET, Crystal Reports, Basel, MS-Visio, MS-Project, MS-GP, Rational test Suite, UML, Windows NT 4.0, UNIX, PL/SQL.

Confidential

Business Analyst

Confidential is a leading provider of consumer and business-to-business financial services. Countrywide is one of the nation's leading retail mortgage banking companies. They are in the business of making, servicing and selling non-prime loans. The project that I worked for was to develop a web based application which would automate the loan life cycle process. Loan officers used to use a system based on Excel sheets for Risk Analysis and disbursement and managing its loan portfolio. The project was to move from this manual, labour-intensive process to an automated, integrated web based system, which could encompass the entire life cycle of a loan. The new system had to address all aspects of the loan lifecycle, starting from identifying a deal right up to loan closure. There were certain compliance issues which needed to be given special attention, regarding the credit risk and operational risk according to Basel II.

Responsibilities:

• Helped in defining Change Management Process for Release Management Team.
• Prepared for GAP Analysis identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Designed and developed project templates based on SDLC Methodology
• Very closely involved in all phases of SDLC from gathering requirements to testing.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Enhancing supporting documentation policies, frameworks, standards, methodologies, and modeling documents to demonstrate compliance with the Basel II Accord.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits including Medicare .
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Delivered presentations on Project Status and Current Open Issues Report to Users, Stakeholders and other involved groups
• Identified gaps in the business process.
• Defined roles and responsibilities of participants in the business process.
• Developed and maintain information and documentation related to developing and modifying business processes and systems.
• Recommend system/process solution approaches to minimize risk and workflow impacts while capitalize strategic goals.
• Gathered requirements from users of the Clear Quest CQ tool for any Enhancements or change requests for any defects.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed and developed project document templates based on SDLC methodology
• Established RUP Rational Unified Process methodology and provided assistance in developing Use cases and project plans.
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Environment: Mainframes, COBOL, JCL, Db2, Calypso, Risk Watch, Oracle, Rose, Basel II, MS Word, MS Excel, MS Visio, MS Project, MS SharePoint, LoadRunner, WinRunner

Confidential

Business Analyst

• Confidential provides a wide range of financial services. The Group's financial services include consumer and business banking, commercial banking, middle-market lending, asset-based lending, leasing, cash management, trade finance and government banking.
• The intent of the project was to have a single web portal that provides access to the end state applications. It included adding functionalities and Rebranding with the use of CSS along with SSO Single Sign On to Private Wealth Management, Compliance Reporting for some new investment business and BOA specific applications and also Basel II accord reporting compliances.

Responsibilities:

• Worked directly with Risk Analytics/Users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information.
• Undertook back end testing using SQL and wrote queries.
• Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non financial transactions and trading operational processing in Comerica's global wealth management platform.
• Assisted in creating business requirements, technical specifications, implementation and test plans.
• Used Activity cost flow diagram to meet business requirements.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Developed BRD documents for Securitized Inventory CMO, ABS, MBS, and ABCP . BRD targeted new Basel Compliance requirements.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Completed a GAP analysis to identify problems in the existing system.
• Conducted JAD sessions between the development team, business stakeholders, and end users.
• Analyzed the user requirements and translated them into functional requirements prepared functional requirement document for SpreadMatrix Phase II and product stress testing phase IV.
• Analyzed data quality issues to improve product coverage of different product groups like Swaps, Bond in Product Stress Testing, software to calculate stress mark to market and mark to market of various portfolios improved product coverage of CDS system to 78 from 7 , EQRMS system to 82 from 70 .
• Prepared the Use Case views for a clear understanding between the vision document and the stakeholders using Microsoft Visio and Rational Rose. Prepared UML Diagrams such as Activity, logical, Component and Deployment views to assist development and engineering in understanding the requirements using Rational Rose.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Created job schedules to automate the ETL process.
• Developed backend calculations required to produce volatility and correlation matrix using SAS.
• Interacted with the developers to report and correct bugs.
• Provided test data to all the testers including UAT Business Edge team and UI testing team.
• Worked together with the development team and the Project Coordination Team to ensure client satisfaction.

Environment: Windows, Oracle 9, SQL, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process RUP , RequisitePro, Clear Case, UML, SAS, Java.

Confidential

Business Analyst

Confidential is a global financial service company dealing with online trading, investment banking, mutual funds, wealth management, trust and custody, foreign exchange, securities lending, performance analytics, fund administration, stock transfer, proxy solicitation, and portfolio management. The application system enabled the trader to input, retrieve, review and store the Daily Trading Activity. The system calculated and displayed the companies LIVE Profit and Loss, accessing data from Bloomberg.

Responsibilities:

• Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Offered excellent Cash Management Services including Account Reconcilement Services, Automated Clearing House, Balance Reporting Services, Cash Concentration Services and Sweep Accounts to large business customers
• Utilized Commercial Lending banking application and was responsable for the design and process flow of the system.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Worked on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives Options and Futures , Portfolio Management, Wealth Management, and Sales and Marketing.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives and Futures including Commodity Futures Contracts and Financial Futures
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Implemented and managed the formal SDLC implementation using the RUP/Agile Methodologies depending on the client and project
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.

Environment: Rational Clear Case, Doors, IBM Web Sphere,XSLT, XML, Java, J2EE, JSP, RUP, UNIX, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, Win Runner, Load Runner, Quick TestPro

Confidential

Business analyst

The project involved building intelligent and user-friendly web based interface to capture commercial Mortgage Products, Pricing, and loan-servicing information like rent roll, occupancy ratio, financial statements, and inspection report etc. The project also involved considerable risk management for the mortgage investors. I collaborated with the Project Managers in the development of weekly and monthly status reports, documentation of process flows, policies and procedures.

Role Achievements:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Created and scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Also used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Coordinated activities with project manager and various other teams using MS Project.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications FRS and User Requirement Specification URS .
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner