SUMMARY

• Project Management/Business Analyst skills wif over 8+ years of experience in teh 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 teh 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 wif clients to gather all requirements to formulate business specifications and translating those into application functionality, understanding value proposition of teh 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 teh 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, wif ability to interact wif individuals at all levels wif 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 me used to modify teh process and improve it to make teh business effective and efficient.
• Experienced wif 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 teh 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 teh phases of SDLC including testing methodologies.
• Expertise in creating BPD/BPPs using teh 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 wif theMercury Suite of Testing Tools and Rational Suite as well as wif 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 teh 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 teh customers and employees
• Provided technical and business consultation services to teh prospective clients
• Attended regular meetings wif teh prospective clients and prepared documents covering various issues covered during teh meetings
• Conducted analysis of client business processes and functional requirements and prepared appropriate documentation to communicate and validate teh information Worked closely wif teh Business User community to gather and define requirements and then conveyed them to teh 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 teh business needs in creating teh requirements deliverables and work products.
• Experience wif gathering requirements and interacting wif teh users on fixed income securities including Corporates, Municipal, Mortgage Backed, as well as, Pass-throughs andDerivatives.
• Interacted wif teh 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 teh design of teh Data Marts.
• Involved in creating teh Business Intelligence Reports for their Accounting and Management stakeholders.
• Conducted meetings wif onshore/offshore team in order to provide source-to-source staging data requirements/ data definitions for implementation of complex business logic.
• Validated teh data using SQL queries for their Star and Snowflake schemas and fact and dimension tables.
• Involved in generating metrics and coordinating closely wif teh end client.
• Created Data mapping specifications and Data Mart Designs for Reporting purposes
• Analyzed loan approval process using process flow diagrams to automate teh processes
• Created Use Cases to document alternate business scenarios and designed UML diagrams using Rational Rose to clearly explain teh 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 halps 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 wif project manager and requirements team.
• Reviewed test cases and test procedure templates and guidelines to be used by teh 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 halped QA team in defect tracking and bug fixing
• Part of teh regression and User Acceptance Testing.
• Involved in training and documentation of for new product release and also hands on experience wif Quick book.
• Involved in testing of teh 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 teh Agile process methodology.
• Tested banking software in comparison to specifications and documentation.
• Creation and documentation of Master Test Plan using specifications from teh 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 teh ETL applications and ETL Process using Informatica.
• Developed Test Plans, Test Cases for ETL/Data Warehouse applications.
• Created Test scripts for verifying teh Informatica process as part of teh Enterprise Data Warehouse.
• Performed data validation testing after teh ETL process, Informatica.
• Validated teh source database, target database and transformations.
• Validated Conditions, Rules by using SQL and PL/SQL
• Tested teh DW / BI reports (Business Objects).
• Extensively worked on Teradata, Oracle, SQL Server Databases to test teh 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 teh 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 teh source warehouse tables to target tables.
• Prepared Test cases to test teh back-end oracle Database by retrieving teh data from teh tables using SQL Queries.
• Created Scripts to test teh End-to-End Functionality.
• Performed Regression and Sanity testing of teh application.
• Unit testing of Java using Junit.
• Performed cross browser testing to ensure functionality on different operating systems to ensure compatibility of teh application.
• Validated teh Financial data for both Bank and cards internet web site.
• Keeping track of teh Hardware Configuration, Operating System, and Tools Used, Testing types and Results on different software versions
• Testing teh response times and performance using Load runner.
• Performed End-to-End testing manually and was associated wif UAT
• Tracked and Managed defects using Quality Center.
• Attended teh Bug Review meetings wif results and was actively involved in planning for teh next build and teh 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 wif teh 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 teh application.
• Created Business Use-Case Model after accessing teh status and scope of teh project and understanding teh business processes.
• Integrated Requisite Pro wif Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Monthly performance analysis for all teh business units wifin 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 teh Chart of Accounts for teh Retail Banking & Credit Cards.
• Responsible for reviewing teh new products launched by teh Bank for its retail initiative from teh Controlling / Finance viewpoint, including budgets and plans.
• Used Crystal Reports to gather data and design reports based on teh database Microsoft SQL Server.
• Assured that all Artifacts are in compliance wif 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 wif our internal systems and submitted reports to teh management.
• Provided assistance in reviewing, analyzing and evaluating business requirements, user needs and functions wif teh 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 wif team members and then examine existing business models and teh flows of data in teh business.
• Worked closely wif developers and a variety of end users to ensure technical compatibility and user satisfaction.

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