SUMMARY

• Project Management/Business Analyst skills with over 8+ years of experience in the fields of Requirements Gathering, Business Analysis, Process Engineering, Software Development, Quality Assurance and Implementation of various decision support systems. Strong Data Warehousing and Business Intelligence/Reporting background. Well organized and results oriented individual.
• 7+ years of extensive experience in the Business domains of Mortgage, Finance and Insurance.
• Over 3+ years of experience in Quality Assurance and Testing, involved in developing Test Plans, Test Cases, Test Scripts, Traceability Matrix and Test Environments.
• Expertise in Software Development Life Cycle (SDLC), Data Warehouse Design & Development, Business Intelligence & Reporting for various strategic and management purposes.
• Partnering with clients to gather all requirements to formulate business specifications and translating those into application functionality, understanding value proposition of the project.
• Experienced in all areas of project life cycle in a highly structured change management environment using both proprietary methodologies, Agile Techniques and RUP (Rational Unified Process).
• Extensive experience in the field of Analysis - Gap Analysis, Technical Analysis, Risk Analysis, and Software Validations for multi-tier and web based applications.
• Experience on Business Analysis, Requirements Management, Use Case modeling using UML using Rational Rose modeler, Business Process Modeling, Data Modeling, Change Management, Technical Writing, QA testing and Implementation for Data Warehousing and Business Intelligence.
• Excellent analytical, problem solving, communication skills, with ability to interact with individuals at all levels with exceptional skills in forming and facilitating Joint Application Design (JAD) and Rapid Application Development (RAD) teams.
• Possess wide knowledge and experience in reengineering concepts and tools, which I used to modify the process and improve it to make the business effective and efficient.
• Experienced with Object Oriented Analysis and Design (OOAD) using UML, Rational Unified Process (RUP), Rational Rose, Requisite Pro, Rational Clear Case and Visio.
• Hands on experience in Data Warehousing, responsible for the Extraction, Transformation and Loading (ETL) using various tools and generation of Data Marts.
• Very Strong analytical skills, excellent Excel and Database skills using SQL scripts for Database Validation.
• Well-experienced working on HTML, XML and CSS.
• Strong experience working on C, Java, Oracle, SQL Server environments.
• Excellent professional skills by working independently and as a team member to prepare and create test plans, test scripts and test cases for manual and automated testing.
• Extensively involved in all the phases of SDLC including testing methodologies.
• Expertise in creating BPD/BPPs using the tools Infopak, UPerform, UPK and On Demand.
• Experience working on WINDOWS/ MAINFRAME environments.
• Conducting Systems, Integration, Functional, User-Acceptance Testing and improvement of QA Process.
• Experience in Testing Database Applications (ORACLE 8i/9i, DB2, MS SQL Server, Java, Sybase and MS Access).
• Expertise in writing Test plans, Test cases, Test procedures and Test scripts from Requirements and Use Cases.
• Experienced in software analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.
• Experience working with theMercury Suite of Testing Tools and Rational Suite as well as with Rational Testing Tools.
• Expertise in Problem solving and Bug Reports using defect Tracking Tools (Quality Center/ALM).

TECHNICAL SKILLS

Methodologies: RUP, UML, SDLC, Agile, ETL, Data Warehousing, SOX

Business Skills: Business Definition Requirements, Business Process Analysis & Research, Use Case Modeling, JAD/RAD Sessions, Requirements Gathering, Gap Analysis and Impact analysis

Rational Tools: Rational Clear Quest, Rational Rose, Rational Clear Case, Rational Requisite Pro

ERP Tools: SAP R/3, ECC 6, Siebel

Designing: Microsoft Project, Microsoft Office, Microsoft Visio

Languages: C, JAVA, SQL, VB.NET, HTML, DHTML, XML, XSL, CSS, Ab Initio

Utilities: Process Max /Clarity, PACBASE, DOORS, ACBS, Provision, MS Office

Web Design: Microsoft FrontPage, Dream weaver

Testing Tools: Rational Robot, Mercury Test Director 7.x/8.0, QTP 9.2, Win Runner, Mercury Quality Center 9.0

Authoring Tools: Info Pak, On Demand, UPK, uPerform

Databases: SQL Server 2000/2005, Oracle 9i, DB2, MS-Access

Operating Systems: UNIX, Linux, Windows 9X/XP/NT, Novell Netware, Macintosh

Networking: FTP, TELNET, TCP/IP, LAN, WAN

PROFESSIONAL EXPERIENCE

Confidential, Richardson - TX

Business Systems Analyst

Responsibilities:

• Performed Business Analysis, Maintained Requirements, and assigned requirements in CQ and tracked their completion.
• Was responsible for many operational aspects of the 1st phase of planning and analysis
• Underwent rigorous training on system analysis and design methodologies
• Developed weekly business plans and financial goals while providing detailed review sessions to the customers and employees
• Provided technical and business consultation services to the prospective clients
• Attended regular meetings with the prospective clients and prepared documents covering various issues covered during the meetings
• Conducted analysis of client business processes and functional requirements and prepared appropriate documentation to communicate and validate the information Worked closely with the Business User community to gather and define requirements and then conveyed them to the Technical staff via use case diagrams.

Environment: Windows 2000, Microsoft Word, Microsoft Excel, Microsoft Visio, Oracle 9i, SQL, Test Director, CQ.

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

• Elicited and gathered user and business requirements (BRD) through open ended discussions, brainstorming and prototyping.
• Gathered requirements to describe the business needs in creating the requirements deliverables and work products.
• Experience with gathering requirements and interacting with the users on fixed income securities including Corporates, Municipal, Mortgage Backed, as well as, Pass-throughs andDerivatives.
• Interacted with the Subject Matter Expert and business users for requirements gathering by conducting more than one JAD sessions for Enterprise wide Data Warehouse.
• Created various Mapping Specifications and brainstormed the design of the Data Marts.
• Involved in creating the Business Intelligence Reports for their Accounting and Management stakeholders.
• Conducted meetings with onshore/offshore team in order to provide source-to-source staging data requirements/ data definitions for implementation of complex business logic.
• Validated the data using SQL queries for their Star and Snowflake schemas and fact and dimension tables.
• Involved in generating metrics and coordinating closely with the end client.
• Created Data mapping specifications and Data Mart Designs for Reporting purposes
• Analyzed loan approval process using process flow diagrams to automate the processes
• Created Use Cases to document alternate business scenarios and designed UML diagrams using Rational Rose to clearly explain the flow.
• Worked on Misys Loan IQ available as Managed Hosted Software-as-a-Service (SaaS) or in-house installation and also syndicate Loan also shared knowledge ACBS Commercial lending support system.
• Gathered knowledge on MSP of Loan Service Provider for Business Process Improvement - LPS helps you achieve improvements by mapping out current business processes and assisting you in reengineering these processes to optimize business efficiency.
• Used MS. Project to coordinate activities with project manager and requirements team.
• Reviewed test cases and test procedure templates and guidelines to be used by the QA team.
• Worked on Data Modeling to manage data as a resource & submitted to project manager.
• Submitted milestone report on time to time bases to Project Manager.
• Used test director as bug reporting tool and helped QA team in defect tracking and bug fixing
• Part of the regression and User Acceptance Testing.
• Involved in training and documentation of for new product release and also hands on experience with Quick book.
• Involved in testing of the applications in UAT/Beta/Prod environments.

Environment: MS-Office, MS Visio, ETL - Ab Initio, BOXI - Crystal Reports, Microsoft FrontPage, MS Excel, MS Access, RUP, UML, SQL Server, Oracle Server

Confidential, Fremont, CA

QA/ETL Tester

Responsibilities:

• Involved in complete implementation of the Agile process methodology.
• Tested banking software in comparison to specifications and documentation.
• Creation and documentation of Master Test Plan using specifications from the Business requirements.
• Test scripts were written in Microsoft Xls and importing to Quality center based on Functional Specifications, Use cases and Business Requirement document
• Tested ETL mappings created for transformation of data using Informatica.
• Tested the ETL applications and ETL Process using Informatica.
• Developed Test Plans, Test Cases for ETL/Data Warehouse applications.
• Created Test scripts for verifying the Informatica process as part of the Enterprise Data Warehouse.
• Performed data validation testing after the ETL process, Informatica.
• Validated the source database, target database and transformations.
• Validated Conditions, Rules by using SQL and PL/SQL
• Tested the DW / BI reports (Business Objects).
• Extensively worked on Teradata, Oracle, SQL Server Databases to test the back end data.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed and tested ETL mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Expression, Aggregator, Update Strategy, Rank, stored procedure, Joiner, Filter, Lookup and Router.
• Wrote extensive PL/SQL and T-SQL queries to validate conversion of data from the source warehouse tables to target tables.
• Prepared Test cases to test the back-end oracle Database by retrieving the data from the tables using SQL Queries.
• Created Scripts to test the End-to-End Functionality.
• Performed Regression and Sanity testing of the application.
• Unit testing of Java using Junit.
• Performed cross browser testing to ensure functionality on different operating systems to ensure compatibility of the application.
• Validated the Financial data for both Bank and cards internet web site.
• Keeping track of the Hardware Configuration, Operating System, and Tools Used, Testing types and Results on different software versions
• Testing the response times and performance using Load runner.
• Performed End-to-End testing manually and was associated with UAT
• Tracked and Managed defects using Quality Center.
• Attended the Bug Review meetings with results and was actively involved in planning for the next build and the changes to be brought into it.

Environment: Java, J2EE, C#, IBM WebSphere, Junit, HP Quality Center 9.0/10.0, QTP, Informatica, Business Objects, SQL, PL/SQL, SQL Developer, Advanced SQL, SQL Server, Oracle 9i, HTML, AS/400, TIBCO, XML, UML, UNIX (Solaris), IIS and Windows2000/ NT 4.0

Confidential, Pittsburg, PA

Business/Data Analyst

Responsibilities:

• Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Performed Feasibility Analysis and Risk Analysis on the application.
• Created Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Monthly performance analysis for all the business units within Retail Banking Group.
• Maintaining Financial & Nonfinancial databases for Retail Banking Group.
• Revised and enhanced P&L analysis procedures for every client covered.
• Investigated valuation differences between predicted P&L and risk management system.
• Performed Data Analysis of existing data through SQL.
• Designed, structured & implemented the Chart of Accounts for the Retail Banking & Credit Cards.
• Responsible for reviewing the new products launched by the Bank for its retail initiative from the Controlling / Finance viewpoint, including budgets and plans.
• Used Crystal Reports to gather data and design reports based on the database Microsoft SQL Server.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.

Environment: XML, HTML, Agile Methodology, Rational Requisite Pro, Rational Rose, Rational Clear Quest, SQL Server, MS Visio, MS Excel, MS Project, Mercury Quality Centre.

Confidential

Business Analyst

Responsibilities:

• Assisted in preparation of business documents related to financial data.
• Generated periodic reports for clients and for internal review.
• Provided assistance to users to debug operational issues related to usage of financial software.
• Researched on adequacy, competency and compatibility of various software’s related to financial sector with our internal systems and submitted reports to the management.
• Provided assistance in reviewing, analyzing and evaluating business requirements, user needs and functions with the objective of improving business processes and procedures.
• Encompassed strategic business research and analysis in developing business plans and market research in support of organization’s initiatives and future direction.
• Worked closely with team members and then examine existing business models and the flows of data in the business.
• Worked closely with developers and a variety of end users to ensure technical compatibility and user satisfaction.

Environment: Lotus Reports, MS-Word and MS-Excel.