PROFESSIONAL SUMMARY:

• 7+ years of professional experience as a Sr. Data/Business Analyst in Mortgage domain.
• Extensive experience in analysing and requirements gathering and writing system functional specifications.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organization.
• Good understanding knowledge of Commercial Lending, Commercial Loan, Risk analysis,
• Strong experience in RUP Business modeling process.
• Comprehensive knowledge of the Student Loan industry and Commercial Lending
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• 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.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Highly effective management and organizational skills with ability to prioritize.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub - reports according to business requirements using SQL Server Reporting Services (SSRS).
• 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.

TECHNICAL SKILLS:

Data/Business Analysis: Requirements engineering, business process modeling and improvement, gap analysis, cause and effect analysis, decision trees, data flow diagrams, data modeling, UAT

Languages: Java/J2EE, JSP, UML, XML, C, C++, SQL & PL/SQL.

MicrosoftOffice Tools: Excel, Word, Project, Access, Visio, PowerPoint and Outlook (2000/2003/2007 )

Rational Suite: Rational Rose, RequisitePro, Clear Quest, Clear Case

RDBMS: Oracle, DB2, MS Access 7.0/2000

Operating Systems: Windows 2000/NT/XP, Unix.

Domain: Banking and Capital Investments (Credit Cards, Loan, Mortgage, Operational Risk Management, Corporate Action Life Cycle)

Tools: PLSQL, TOAD, VSS, Eclipse, Continuum, Netbeans, IBM Rational Rose, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential - Glendale, AZ

Sr. Data Analyst/Business Analyst

Responsibilities:

• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Maintained the data integrity of the Baan ERP system by developing an end-user strategy for data cleansing and engineering revision control
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Served as the primary point of contact, and independently resolved a high percentage of technical support issues for customers Wholesale Management System (WMS) applications.
• Also involved in the design and development of wholesale management system
• Worked in mainframe environment and used SQL to query various reporting databases
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Creation of the data mart from existing Operational data Store and other sources.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, Visual Basic, SQL, MSRS, DB2, UDB, Cognos, Mainframe, Win Runner

Confidential, Plymouth, Michigan

Sr. Data Analyst/Business Analyst

Responsibilities:

• Interview business area experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
• Interact with SME's to elicit business goals and define goal-level requirements
• Collaborate with financial analysts, investment analysts and accountants to collect and understand business requirements
• Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system
• Evaluate technical requirements Created System Requirement Specifications (SRS), Systems Design Specifications (SDS) and System Information sheets to provide concrete inputs for the data mapping processes for Account Analysis, PayPlus & PAM systems, Signature Snippets Data Conversion
• Conducting JAD Sessions to resolve open issues, change requests so that the application meets the business requirements and dead lines
• Worked in mainframe environment and used SQL to query various reporting databases.
• Interact and negotiate with Vendors to complete the tasks related to data conversion
• Was involved in the Test Plan document preparation.
• Developed and designed the test cases for different modules of finance referring to the test plan document and analyzing the test rules.
• Identified, prioritized and designed various test scenarios.
• Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
• Reported the bugs, Email notifications to the developers using Test Director.
• Customized the test scripts using check points, synchronization and parameterization of data.
• Automation of test scripts was done using QTP for test re-usability of different online transaction modules.
• Involved in converting User requirements into business requirements, functional and technical requirements using Rational Requisite Pro and also created business process models from the requirement.

Environment: Visual Basic, SQL, MSRS, DB2, UDB, Cognos, Windows, MS Office(MS Word, RUP, UML,, Mainframe, Win Runner MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports

Confidential, New York, NY

Data/Business Analyst

Responsibilities:

• Responsible for Business Process Evaluation (BPE) and Industry Best Practices analysis for Home Finance and Commercial Lending divisions (separate projects) encompassing analysis of back office systems, processes and consumer-direct web services
• Created functional specifications and design requirements for integration of current Wholesale Management System with Dealer Loan System to meet business requirements.
• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the DataStage Repository by studying the data sources.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Assisted in development of materials for new technology and process improvements
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle, Teradata, UNIX, SQL, Rose, MS office, Cognos, MS Word, MS Excel, MS Visio, SAS, LoadRunner, WinRunner

Confidential, NJ

Data Analyst

Responsibilities:

• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and lending
• 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.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Successfully gathered requirements for online application for lending mortgage loans
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses. Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, Visual Basic, SQL, SQL Server, Oracle, C#.Net, WebLogic, HTML, Web Forms, LoadRunner, WinRunner, DOORS, Project Management, MS Project.