SUMMARY

• Sr. Business Analyst /Data Analyst/ Associate Project Manager with 10 years Software Development Life Cycle (SDLC) experience to include a specialization in requirements gathering, data analysis and testing of web-based and client/server applications.
• Expertise in developing Use Cases and Use Case Diagrams utilizing MS-Visio.
• Experience in defining business user requirements, managing requirements, analyzing requirements, changing requirements etc.
• Proficient in conducting JAD sessions, interviews to attain a complete set of business requirements
• Ability to mould the business requirements into functional and technical requirements.
• Extensive experience in data mapping, data validation, database querying to supplement business analysis of financial data.
• Assisted the Project Managers in detailing the project plan / project schedules and defining the deliverables and the deadlines.

• Adept in querying databases to include DB2, MS SQL Server, Oracle, Sybase and MS Access.
• Proficient in conducting data analysis
• Strong communication, business understanding, critical thinking and analytical skills.
• Strong leadership skills and flexible in work schedules.

SOFTWARE SKILLS

Internet: HTML, XML, VB Script, JavaScript, Web 2.0
Databases: MS SQL, Oracle, Sybase, MS Access
OS: Windows NT/2000/XP, UNIX
Tools: TOAD, RapidSQL, DB Visualizer, JIRA, Drools
Software Tools: Visual Basic, Visual C++, Crystal Reports
UML Tools: Microsoft Visio
Other Tools: MS Office for Documentation, SharePoint
Version Control: PVCS Tracker, CVS
Project Management: MS Project

PROFESSIONAL EXPERIENCE

Confidential, Jun 2007 – Current
Sr. Business Analyst / Data Analyst /Associate Project Manager
Confidential,is a leading global investment bank with a strong and profitable private client franchise. As a BA/Associate Project Manager, I am involved in the in the Private Client and Asset Management (PCAM) Group in the Private Client Services (PCS) division. My duties and responsibilities range from gathering requirements to managing projects on various levels.
Responsibilities:

• Satisfied the Associate Project Manager / Business Analyst role for Account Purge
• Was responsible for gathering requirements and maintaining a rigid timeline for Account Purge. This entailed doing a system impact analysis of all the Deutsche Bank applications.
• This project resulted in erasing about 60% of the nonfunctional accounts from the daily feeds from Pershing, thereby reducing the load and the processing time significantly.
• Fulfilled the Associate Project Manager responsibilities for Harbor side Disaster Recovery Test.
• Was responsible for maintaining and coordinating a Global Deutsche Bank Fail safe procedure.
• This project helped achieve and maintain the annual audit effort performed to provide the continuous availability of data to users and clients.
• Fulfilled the Associate Project Manager/Data Analyst / Business Analyst responsibilities for a compliance Sungard Data Surveillance application
• Met with the business users to collect detailed requirements for addition and implementation of data alerts.
• Worked with the vendor and the business users to resolve various compliance and audit issues.
• Assisted the business / compliance by supporting the application.
• Responsible for writing the Project Charter, Proof of Concept and the functional requirements for the Sales Assistance Maintenance project
• This project helped link all the sales assistants to their respective brokers
• With the Many to many relationships it was possible to able to a single SA to many brokers and vice versa.
• Assisted in writing test cases and testing once the code was in place in the QA environment.
• Responsible for completing and submitting the dbRAMMs for the various applications in Deutsche Bank.
• dbRAMMs are the audit documentations required for the applications.
• Required extensive meetings with the application owners, technical teams and the external third party vendors of the applications.
• Information required varied from the business use of the application to the encryption methods used to make sure that the information was secure from unwanted sources.
• Responsible for meeting with the clients and gathering requirements for Automated New Account Opening for the Client Advisors and the Sales Assistants. This consisting of understanding the current manual processes and identifying gaps and areas for process reengineering.
• Optimized and brandized the current forms for barcode scanning and linking them back to the client and financial accounts.
• Worked extensively on drools to define the acceptable values for the business rules.
• Conducted extensive JAD sessions with the stakeholders to detail the flow and the requirements of the system.
• Gathered requirements so that retail, retirement and COD accounts could be opened at Pershing.
• Worked with the technical team to ensure that the data collected could be sent across the web services via the API to Pershing.

Environment: PVCS Tracker, JIRA, DbVisualizer, Oracle 10g, Toad, Windows 2000/ NT/98, MS Office 2000, MS Access, MS-Visio, Drools

Confidential, Feb 06 – Jun 2007
Data/Business Analyst
Confidential,is a stock holder-owned corporation chartered by congress in 1968 to keep money flowing to mortgage lenders in support of homeownership and rental housing. By doing so, Fannie Mae ultimately assists homeowners and renters in obtaining lower housing costs and better access to home financing. I participated in the Restatement process on the Securities Data Mart project. Worked on the transition and transfer of data from the source to an auditable database through which the reports were produced.
Responsibilities:

• Developed initial drafts for Financial Reporting Data Storage Systems.
• Created Use cases to define and analyze the requirements
• Maintained constant interaction and communication with business users, developers and testers to ensure all data related business requirements were met.
• Participated in the transition and transfer of data from the source to an auditable database through which the reports were produced.
• Created test plans and test cases for functional testing.
• Analyzed and formulated the test cases and scripts for testing the servicing fees used at the security level.
• Analyzed test results
• Responsible for documenting requirements for a project needing a document management template definition.
• Assisted with the workflow definition for document publishing using SharePoint.
• Regularly conducted data analysis with the ETL team.
• Performed data validation using generated Business Objects XI to ensure data accuracy.
• Used SQL to consolidate, analyze Test Run and Production Run from different data sources.
• Heavily assisted in the User Acceptance Testing of the securities data mart.
• Responsible for Control Validation to ensure the logic desired by the business and the financial analysts was correctly interpreted and applied by the ETL team into the Financial Reporting System.
• Responsible for manually checking the data/numbers in the General ledger, Trial Balance, Mortgage Backed Securities (MBS), Balance Sheets, with the Reporting Data mart and other End User Computing EUC’s to verify their Portfolio and Omnibus accounts.
• Served as an integral member of the On-Tops team. Ensured rare scenarios which had not been accounted for in the system for Restatement were taken into consideration for audit purposes.
• Ensured a traceability and drill down capability for the 10K reports were implemented for the Financial Reporting System. Manually checked numbers in the General ledger with the Reporting data mart and other EUC to verify the Portfolio and Omnibus accounts.
• Facilitated and coordinated the new builds and releases.

Environment: Quality Centre 8.1, Hyperion Essbase, Business Objects XI, Oracle 10g, ETL- Ab Initio, Sybase, Toad, Rapid SQL, Windows 2000/NT/98, MS Office 2000, MS Access

Confidential,Cincinnati, OH Apr 2004 – Feb 2006
Data Analyst
Confidential,is the 8th largest financial services holding company in the United States provides a comprehensive line of banking, brokerage, insurance, investments and mortgage, trust and payment services products. As a QA consultant I was responsible for analyzing data for the EDI Remittance module of Cash/Treasury management group..
Responsibilities:

• Perform data research and financial support duties as assigned.
• Performed Extensive data analysis with SQL Plus in Oracle DB
• Responsible for helping create and draft UAT test cases based on data available.
• Performed UAT and addressed issues for corrections and improvements (including testing live data reconciliation against Brio reporting module).
• Coordinated with the DBA for configuring Data sources in configuration files.
• Extensively used SQL queries for backend testing.
• Performed Compatibility Testing of the application on various system configurations.
• Helped install Installed new builds and releases.

Environment: Toad, Oracle 8.0, TestDirector 7.6, Rational Rose, , XML, , Window 2000/ NT/98, Netscape Navigator 4.7, IE5.5, MS Office 2000.

Confidential,Mayfield Village, OH Aug 2002 – Apr 2004
QA Analyst
The Progressive group of companies ranks third in the nation for auto insurance, with more than 11 million customers. Progressive insurance is one of the major auto insurance providers on Internet. As a QA analyst I was responsible for testing of various Policy Service modules.
Responsibilities:

• Prepared Test Scripts and Test Cases.
• Created Virtual Users script for web protocol and parameterized the script using LoadRunner.
• Analyzed results of Transactions Response time, Transaction under load, Transaction Summary by Virtual users, Hit per Second and Throughput.
• Developed library functions for functional and regression testing of Business Flow using WinRunner TSL scripts.
• Conducted Stress, Load and Performance testing using LoadRunner.
• Tracked and reported defects via TestDirector, which helped to resolve technical issues with developers.
• Tested in Development, Test, Staging and Production Environments.
• Performed Compatibility Testing of the application on various system configurations.
• Performed bug tracking using ClearQuest defect management system.
• Updated FRM’S and RTM’s.

Environment: WinRunner 6.5, LoadRunner 6.5, ClearQuest 4.1, SQL Server, Windows 95/98/2000, ASP 3.0, Visual Basic 6.0, XML, Internet Explorer and Netscape.

Confidential,Carbondale, IL Feb 2000 – July 2002
Software Tester
Confidential,made functional and user interface enhancements to their online banking services. Customer database was updated to meet the new business requirements. The project involved end-to-end system testing to validate the changes.

Responsibilities:

• Devised test cases to test the business requirements and conditions.
• Worked with the lead tester to determine the high-risk functionalities.
• Performed Data Driven and Regression tests using WinRunner.
• Conducted backend testing using stored procedures SQL.
• Wrote extensive SQL scripts for validating data integrity.
• Coordinated meetings and walkthroughs with the management team to ensure steady progress.

Environment: WinRunner 6.0, ASP 3.0, Visual Basic 6, ODBC, HTML, JavaScript, Oracle, IIS 5.0,MS Word, MS Excel, Microsoft Visio.

EDUCATION

BS in Information System Technology