PROFESSIONAL SUMMARY:

• 7+ Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• 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 organizations.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections. Training and some experience in commercial lending, including financial statement and cash flow analysis.
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Strong experience in RUP Business modeling process.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Knowledge with investment banking regulatory reporting regulations like Basel II
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• 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
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• 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.
• 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:

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, 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

Sr. Business Analyst

Responsibilities:

• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created and updated Standard Operating Procedures (Ms Visio 2003) for training, support purpose, operations with the key components of the Enterprise Risk Management (e.g. risk of error or fraud, data privacy, position and valuation) Framework (Basel II, Sarbanes Oxley SOX, Section 404) SAS for money laundering, Fraud prevention and operational risk management.
• Involved in writing Job Automation process i.e. writing shell scripts using Korn shell, as scheduled daily, weekly, monthly, and sending these jobs to clients email-ids.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Deep involvement with Portfolio Management accounting system (PMS) & Distribution of web interfaces (DOW) for reconciliation process and Basel II compliance.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Worked on data modelling and produced data mapping and data definition documentation
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process and revenue streams aimed towards problem solving.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Prepared project plans using MS Project and coordinated timelines as guided by the Project Manager
• 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.
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Creation of the data mart from existing Operational data Store and other sources.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Develop direct mail and email marketing initiatives using Unica Affinium Campaign and SQL.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Assisted in development of training materials for new technology and process improvements

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint) MS Visio, MS Project, .NET, Oracle, Crystal reports, RUP, UML, Visual Basic, SQL, SWOT analysis, Cognos, Win Runner

Confidential

Business Analyst

Responsibilities:

• Addressed all aspects of credit card business.
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse (Oracle dB) is accurate through to the SQL dB in the applications.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Senior level SQL query skills (Oracle and TSQL) in analysing and validating SSIS ETL database data ware house processes.
• Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Handled change request and change management and project management using Clarity Project.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• 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.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• 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.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Visual Basic, Oracle,WebI XI R2/6x, Teradata, UNIX, Rose, MS office, Cognos, SAS, LoadRunner, WinRunner

Confidential

Business Systems Analyst

Responsibilities:

• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Exposed to and worked with Subject Matter Experts in Fixed Income Annuities, Equities, Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing, Derivatives.
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Involved in gathering and preparing the requirements documents for replacing the existing commercial lines of businesses from legacy to web-based system
• Created data journal and data dictionary. Created User Interface Field Matrix, PL/SQL queries using TOAD/DB2.
• Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax/ Market claims to be paid or redeemed.
• SQL Server 2005 Database Administration.
• Worked with Business users to come up with Reporting Requirements. Reports were developed in Cognos.
• Supported web design and user-interface layout for public and internal web based solutions.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• 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.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• 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. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• Worked on Business Intelligence tools like Cognos, Business Objects.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
• Designed and developed project document templates based on SDLC methodology
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.
• Experience developing On Line Transaction Processing (OLTP), On Line Analysis Processing (OLAP) and Data Warehousing data models.
• Responsible for Developing the test modules in the Quality Center for the new requirements
• Provided key input in working with users in defining project and system requirements.

Environment: Mainframes, COBOL, JCL, Db2, HTML, Oracle, Rose, WebLogic, SQL, SQL Server, T-SQL, Cognos, Javascript, Quality Center, Six Sigma, MS Word, MS Excel, MS Visio, MS Project, LoadRunner, WinRunner

Confidential

Business Analyst

Responsibilities:

• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Conducted project discovery through the interviewing of key stakeholders' to flush out business rules, operational specifications and interface specification solutions to address identified business opportunities and/or strategic initiatives.
• Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design.
• Prepared graphical depictions of use cases (activity diagrams, system context diagrams, sequence
• Diagrams use case diagrams, wire frames, etc.)
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro
• Identified system, data and process dependencies for upstream and downstream application data flow.
• Worked extensively in Business Analysis, Data Reconciliation and Data Mapping for ETL process
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Wrote detailed specifications for various reports generated using Cognos
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• 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
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Interfaced between Business new product builders and System platform builders.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MS Word, MS Excel, MS Access, MS Project, Java, MS Power Point, J2EE technology, .NET, ASP.NET, SQL Server, Windows 2000 Advanced Server, UNIX / Oracle Platform