PROFESSIONAL SUMMARY

• 7 years of industry experience in Business Analyst, data modeling, process flow and quality assurance skills.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ETL .
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatics.
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Proficient with methodologies like Software Development Life Cycle SDLC , Project Management Methodology PMM , iterative Rational Unified Process RUP , and Rational Tools used in different projects.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD Experience in Software Development Life Cycle SDLC -Waterfall, V-Model and Prototype and worked on reporting tools Cognos, Crystal Reports Microsoft Reporting Services .
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Very good knowledge on SharePoint 2007/2010 as Site Administrator / Site Manager etc
• 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
• Strong knowledge of all phases in Software development life cycle SDLC and the iterative Rational Unified Process RUP
• Knowledge with investment banking regulatory reporting regulations like Basel II Accord
• Expertise in developing Test Plan, Test Conditions, and Test Cases to ensure complete and adequate testing as well as coordinating and conducting User Acceptance Testing UAT .
• Well versed with client server environment and tools like SQL Loader, UNIX shell scripts and TOAD
• Deep understanding of Trading Platform Building Blocks: Static Data Requirement, Market data Structures, Pricing, Model Validation, Portfolio Risk analytics, P L, Risk Attribution
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
• Design and review of various documents including the Software Requirement specifications SRS , Use Case Specifications, Functional Specifications FSD , Systems Design Specification SDS , Requirement Traceability Matrix RTM and testing documents
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Excellent Training skills, facilitation, power point presentations, maintaining performance metrics, devising training documentation communicating to users.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Strong in database design, domain modelling and ER diagrams design
• Highly motivated and a self starter with excellent communication and interpersonal skills
• Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions.

Software/Environment

MS Visio, MS Project, Rational Product Suite, Rational Rose, Perl, RequisitePro, ClearQuest, Windows XP/2000/Me/98/95/3.1/NT, SunOS, MS-DOS, Dream Weaver, Cognos,Adobe Photoshop, SharePoint, Flash, Business Objects, XML, UML, HTML, C , VB.NET,ASP.NET, Java, Access, Microsoft Word, Power Point, Excel, Outlook, PSP Studio, Word Perfect

PROFESSIONAL ACCOMPLISHMENTS

Confidential

Role: Sr. Business Analyst

Confidential is organized into three major business groups - Global Consumer, Corporate Investment Banking, and Global Wealth Management. The Confidential Global Consumer businesses comprise the financial service sector's most diverse consumer product offerings, including banking services, credit cards, loans and insurance. This CreditMart project is a part of the overall effort to build and maintain data repository, which will facilitate Confidential Credit department for their day-to-day MIS activities. With reference to build and maintain marketing data repository this effort addresses migrating Sector CID detail and summary data onto the CBNA Data Warehouse and Marketing DataMart for better BI/MIS facilities

RESPONSIBILITIES

• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Integrated various sources in the Staging area in Data warehouse to perform Integrating and Cleansing data.
• The project was to extract data using SSIS, for designing OLAP cube as per the business requirement using SSAS, creating reports for the business users using SSRS
• Worked on Credit DataMart and Marketing DataMart and responsible for gathering requirements, preparing functional specifications and BI Business/Data Analysis / Modeling and UAT.
• Actively involved in migration of TNC and Sector CID legacy applications to new DW environment. Worked with MIS team/Business Users to understand the BI Data requirement and Business Metrics.
• Working on enhancements in Business Objects, Cognos and Informatica.
• Provided ongoing monitoring of the system, ensuring P L is not lost to incorrect trades, pricing issues or inappropriate trading activity.
• Worked on various source systems analysis and prepared gap analysis documents, impact analysis documents, Source-to-Target Mapping documents and Data Definitions documents. Defined new validation rules and Domains. Worked on data mining and data profiling.
• Prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
• Facilitating JAR sessions for gathering requirements from the FLCLs and defining the user acceptance test standards
• Wrote BRD, FRS, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Wrote Test Cases and performed User Acceptance Testing, documented the in detail defects using the Defect Tracking report.
• Applied sound knowledge of Operational Risk, Credit Risk, Accounting Principles Acts GAAP SOX , Financial Statement Analysis Balance Sheets, P L A/c , for understanding and implementing Basel II framework and compliance.
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
• Worked with Business Development team to perform data analysis/quality and data modeling. Worked with Data Security team to define sensitive data elements and data masking.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various Shell scripts.
• Gather final requirement and draft the BRD and Business Data Flow Diagrams
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed Data Analysis and Data validation by writing complex sql queries using TOAD against the ORACLE database.
• Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.
• Executed SQL and PL/SQL queries on the DB2 Database.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Confidential

Role: Business Analyst

• The project was to enhance Private Banking and Finance division's Customer Accounts and Marketing application CARE , the development for which had been primarily outsourced to India. CARE application was used to create new accounts, to assign Private Bankers and Account Reps to different type of clients, which was categorized by Opportunity and Know Your Customer KYC data. CARE contains the customer information and interfaces with OPS/P1 system, which holds the detailed financial and accounts information. A parallel project was to enhance reports generated using Business Objects for decision making by Business units.
• The Project also involved making changes to the Anti Money Laundering Systems, List screening applications and the integrating those systems to the back end

RESPONSIBILITIES

• Conducted thorough Enterprise Analysis, with the focus towards Organizational feasibility of the enhancement initiative for CARE. Assisted the Project Manger in creating GANTT Charts.
• Prepared an ROI analysis report after evaluating the COTS product of the multiple business lines Consolidated the analysis of multiple business lines after the COTS evaluation. Interface between the departmental clients and the various divisions of MIS Developed a consistent reporting system cash flow, P L and balance sheets. Responsible for identifying business requirements with KYC TEAM, which included Marketi Coordinator, Marketing/Public Relations Director, Marketing/Sales Associate, Marketi Representative, and documented them using Change Request templates in MS Word. Used detailed knowledge of CARE features, and functionality to assess Scope, and impact of KYC on the bank throughout the analysis. Responsible for data integration around BASEL II systems Define the contracting terms based on various plans. Collaborated with Basel II team on credit risk analysis and issue resolution. Created Use Case specification documents for KYC, Business Flow Diagrams involving OPS/P1 system Activity and Sequence diagrams using MS Visio, so that developers and the other stake holders could understand the work flows and business processes according to their perspective with all possible alternate scenarios. Conducted JAD sessions with End-Users, developers, and other stakeholders to understand requirements and to resolve new and already existing issues. Partnered with QA team to create Test scenarios, Test Plans, and Test Cases based on user requirements and functional specifications. Assisted the Project Manager to manage risk by creating Prototypes and getting sign-offs from the Business. Held weekly meetings, as needed with the development and testing team to relay any changed requirements.
• Wrote Test cases for Enterprise Data Warehousing EDW Tables and Data Mart Staging Tables

Confidential

Role: Business Analyst

Assignment involves the implementation of various BRDs and FRDs designed for advanced internal rating based approach to calculate RWA Risk Weighted Asset . I-flexs Reveleus system is being used to calculate RWA using A-IRB Advanced Internal Rating based approach . Role also involved verifying KBRs Key Business Requirement defined for per-processing rules to calculate the RWA. The key responsibilities are to understand BASEL II AIRB approach for calculating risk weights for Wholesale Business and provide the dimensional model for various identified analytics. It also involves writing rigorous SQL script to verify all the identified KBRs for A-IRB approach

Responsibilities

• Analysed User Requirement Document, Business Requirement Document BRD , Technical Requirement Specification and Functional Requirement Specification FRS .
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Used the guidelines and artifacts of the Rational Unified Process RUP to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Discussed with SMEs across different businesses units to gain solid knowledge of the existing Credit Risk Calculation System and assisted in preparing an advanced Risk Assessment and ROI Management.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Develop, build and manage Reporting Services SSRS reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Designed MIS reports to show loan disbursements, region wise product wise
• Captured requirements based on Basel II internal ratings based approach IRB . Allowing certain extent on estimation of credit risk.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents. Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Prepared High Level Logical Data Models and BRD's Business Requirement Documents supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Designed the universes by creating the Business Objects data model.
• Involved in the troubleshooting of universe schema with loops, chasm traps and fan traps, and cardinality problems.
• Responsible to import the parts of the existing reports using Business Objects Live Office to develop the required reports in Microsoft Excel and Word.
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Worked with SQL queries using MS Access for data manipulations.
• Performed functional, integration, regression, system, and acceptance testing
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Environment: Microsoft Office Suite, Microsoft Visio,Cognos, Documentum, UML, Windows SharePoint ,Unix,NT/XP, MS Excel, Oracle, SQL, TestDirector, LoadRunner

Confidential

Role: Business Analyst

The task of this project was to build a central repository of historic data warehouse that could support the bank's various reporting and information needs. Data was spread out in multiple and diverse sources in databases located in different regions. The requirement demanded an integrated, unified data pool that was truly subject-oriented, time-variant and nonvolatile.

RESPONSIBILITIES

• Conducted interviews with the clients for gathering requirements and evaluation/analysis of their data. Converted the business requirements into IT specifications.
• Performed the requirement analysis and documented the requirements.
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software using a Use Case in Requisite Pro.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Worked closely with SMEs and business users in understanding and documenting their current process, gaps and requirements around various aspects of hedge fund management: asset classes, corporate actions, performance reports, client reports, general ledger, P L and reconciliation.
• Created Use Cases, Workflows, and Screen Shots for the Application
• Developed the business and functional requirement specification describing and prioritizing of the requirements.
• Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements
• Developed Project Status metrics for weekly evaluation of Project Status and impact of the Change Request on the Time line.
• Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Followed the RUP methodology for the entire SDLC.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
• Wrote test cases and test scripts for the User Acceptance Testing
• Updated and maintain customer database.

Confidential

Business Analyst

Responsible for creation of corporate compliance program related to Bank Secrecy Act and Anti-Money Laundering BSA/AML efforts, including new accounts and know your customers policies and procedures. Responsibilities included drafting 10 policy and procedure documents, streamlining and updating all aspects of Program, developing and teaching training programs, and managing staff of one. Supported Chief Compliance Officer in all audit/examination matters, tracking, reporting, and maintaining all records relative to BSA/AML program.

Responsibilities

• Managed risk-based audits, due diligence and governance of new initiatives and compliance AML Anti-Money Laundering , SOX, Basel, GLBA, PCI programs to mitigate risks
• Implemented Actimize Anti-Money Laundering AML system to monitor suspicious transactions and enhance regulatory compliance.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Developed data cleansing and data auditing procedures to clean external data and provide audit logs of rejected data.
• Using UNIX console commands to check database has been connected the other functionalities.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Enhanced test cases using GUI checkpoints, Database Checkpoints, Text checkpoints and Bitmap checkpoints
• Performed Functional design/Data Modeling/user interface design of a financial services Client master database/data ware house.
• Performing Gap Analysis to increase the efficiency and compatibility of existing systems and simple add on's with new business requirements.
• Documented the requirements in Rational Requisite Pro.
• Participated in providing analysis to track the activity of the average employee and customer with the front-end
• Created dynamic data cleansing modules to identify duplicate student data using rules from a rules table in the database.
• Perform Business Process Modeling using Visio. Perform customer data analysis.
• Identify research, investigate, analyze, define and document business processes.
• Worked on Oracle e business application suite tools like Depot Repair, Field Service, iSupport to streamline repair processes and business functions.
• Exclusively used SQL, T-SQL for designing modifying and maintaining the SQL Server Tables, Views and Stored Procedures accordingly