PROFESSIONAL SUMMARY:

Talented and proficient person with over 17 years of experience in Customer Service, Banking, IT Software Development Life Cycle (SDLC) and Business Admin.

TECHNICAL SKILLS:

Software skills: MS - Project, MS-Office Suite, MS-SharePoint, SnagIt screen capturing tool, GoTo

Meeting manager Reporting: Status reporting, SCRUM meetings

Change Management: Impact analysis using Traceability Matrix, Budget/Timeline

INDUSTRIES: Financial, Retail, Manufacturing, Transportation, Insurance, Education, and Pharmaceutical/Biotech, Non Profit Organization, Government, HealthCare and Hi-Tech E-business

LANGUAGES: Basic, Microsoft Access and Visual Basic, SQL, PL/SQL, XML, UML and HTML/HTTP

REPORTING: Crystal Report, Gelco Financial Reporting Mgmt., Cognos

DATABASE & TOOLS: Oracle 9i, MS SQL Server 7.0, MS-Access, DB2, TOAD 7.5, ODBC, 1SO-8583, F-Secure SSH Client, QMF 6.1.1, Ultra Edit, Axio Client 4.4

DEVELOPMENT SUITE: Clear Case, Rational Clear Quest, Rational Rose, Requisite Pro, UML

APPLICATIONS SOFTWARE: Clarify, HOGAN, Retek RMS/RSS, PWS, Microsoft Office Suite (97, 2000) - Excel, Word, Outlook, and PowerPoint, MS Project, Niku, Visio

OPERATING SYSTEMS: Novell, Windows NT/2000/98/95, Novell, MS/DOS, OS/2, VAX/VMS, UNIX, Mainframe, Client/Server

WEB SERVERS: Web Sphere, Web Server, AssetLock BC app Servers

TESTING TOOLS: Mercury WinRunner, Test Director, Rational Rose, Beyond Compare 2

VERSION & SOURCE CONTROL: PVCS version manager, Defect Tracker, Remedy, Bug tracker, Lotus, and, MS Visual SourceSafe, SharePoint

METHODOLOGIES: IBM/ISM (IBM Systems Management), Prototyping, Waterfall, Rational Rose & Rational Unified Process (RUP), Capability Maturity Model (CMM), Rapid Application Development (RAD), Agile 2006

DESIGN AND MODEL TOOLS: Data Warehouse, Data Mart, Data Mining, Database Modeling, Class Diagram, Use Case, Interaction Diagram, Component Diagram, Data Flow, (Microsoft Visio 2000), CaliberRM

SOFTWARE TESTING: Writing Manual and some Automated Tests, Creating Beta, Regression Tests, Testing software developed by outside vendors, Client/Server Testing, Testing Web Applications, Functional, Smoke, Usability, User Acceptance (UAT), Unit/Module, Integration, System, Installation, Black and White Testing.

PROFESSIONAL EXPERIENCE:

Confidential, California

PROJECT LEAD / BA

Responsibilities:

• Answering phone calls while solving customers’ issues and problems
• Developing systems specifications, process flow and conversion strategies
• Creating technical and functional user documentations
• Writing Business Requirement Specifications to deliver a National Website
• Using various requirement elicitation techniques like brainstorming, JAD sessions, walkthroughs, surveys and interviews to gather requirements and define project scope and deliverables.
• Understanding service objectives and capturing business requirements through active listening & questioning techniques.
• Facilitating and participating meeting sessions with the business users and stakeholders to define the project scope and boundaries.
• Writing test cases for conducting Use Acceptance Testing while participated in User Acceptance Testing
• Meeting with clients to establish a working rapport while Providing, installing, upgrading, and supporting the new web application
• Developing site architecture including site map and navigational formats
• Executing page design, html coding, forms, graphics design, interactive design and implementation, multimedia design and implementation.

Confidential, Sacramento, California

PROCESS & DATA ANALYST

Responsibilities:

• Worked with business leads to identify the appropriate data for testing, while preparing creating test cases.
• Executed test plans for a new reporting Targetik application.
• Validated report accuracy to existing Hierarchy reports.
• Documented test procedures in Excel and findings in SharePoint.
• Maneuvered around the directory structure while researching discrepancies.
• Mapped out and provided system architectural reports on Warehouse Management System (WMS); including database design, security, migration, integration, conversion, and capacity planning.
• Developed integration plans between all systems leveraging the TIBCO ESB framework utilized by the company.
• Worked on a small team to develop and implement innovative solutions to business. problems/processes.
• Met daily with End - Users to gather requirements while identifying resolutions for operational problems, and prioritizing requests from end users.

Confidential, Burbank, California

SENIOR IT PROCESS LEAD

Responsibilities:

• Created financial models and P&Ls to forecast revenue, expenses, and profits for all distributed products from Confidential SAP system.
• Highly involved in full life cycle of a complex BI/BW implementation such as Data validation, Data requirements gathering, Gap analysis, face-face interactions with business teams and decision-makers to identify business requirements while defining Disney’s AOP forecast which includes:
• Performing ad hoc planning, requirements gathering and testing to support client’s forecast revenue and marketing plans.
• Capturing client’s requirements for P&L, Balance Sheet trend reports, monthly, Yearly and Year to date showing with Actual vs Budget, Actual vs. Forecast data and integrating them into several financial reports in Cognos.
• Creating and identifying new revenue plans for 5yrs AOP, 1 year AOP and Q1-Flash (Monthly).
• Translating functional requirements to a technical solution with the support of developers using ETL to create competitive database structures, models, and reports from many large systems including:
• Writing Test Scripts to ensure that Actual totals from the Published Tables shows up correctly in the Cognos reports.
• Using cognos analysis studio to verify that client’s Actual data submitted matches what developers pulls from a complex SAP R/3 system into the Olympic Data Mart
• Creating Functional Test Scripts to ensure data posted as actual revenue from the Foundation Mart are stored in the Plan/Actual infoCube while addressing any errors with developers.
• Inspecting /reviewing and updating functional specification, test conditions while preparing Scenario spreadsheets ahead of testing.
• Creating UAT scripts for clients to validate that data from SAP R/3 are displaying correctly in the Cognos while providing additional functional support to the clients

Confidential, Minnesota / Wisconsin

SENIOR BUSINESS ANALYST & PROCESS LEAD

Responsibilities:

• Met with sponsors to prepare project’s objectives and requirements using various techniques and tools to prepare functional Prototype and other design documents (AS-IS and TO-BE states, system architecture, gap analysis, road map, trend analysis, etc.)
• As process lead, liaised with sponsors and development team to report project status, while demonstrating project solutions to clients as part of training for UAT.
• Worked with users, stakeholders, quality assurance and development team coordinating project scopes and timelines while utilizing industry best practices framework (Agile and RUP Methodology)
• Demonstrated leadership and intense problem solving skills on three large, cross functional projects while preparing estimates, project plan (timeline, releases), budget and resource requirements
• Identified client’s organization's strengths, weaknesses and made recommendations for areas of improvement while working with development team and clients to ensure project is built within constraints.
• Ensured issues are identified, tracked in SharePoint, reported on and resolved in a timely manner
• Analyzed business and processes to discover the root causes of problems while presenting each problem to the users for discussion and resolution
• Mentored new team members with software development methods and processes followed in the company

Confidential, Bloomington, Minnesota

IT PROCESS LEAD / BA

Responsibilities:

• Worked extensively in the areas of BA, PM and QA by working with other senior members to develop projects goals, scopes and objectives.
• Gained thorough knowledge and insight into application of Project Management techniques and tools, including in the prioritizing procedures for changing scope (i.e., change management and quality acceptance procedures).
• Participated and worked with report writer/development team to create project deliverables phases.
• Responsible for establishing, supporting and developing best practice methodologies for the system and report process. This includes participating in the development and review of project life cycle phase deliverables, recommendation, selection, architecture, and execution of report testing activities.
• Managed the scope of testing activities for all report applications, including creating QA Plan for testing activities.
• Obtained feedback from team to ensure QA efforts is in line with project stakeholders requirements from a product/quality build perspective and support the hand-off to Release management.

Confidential, Minneapolis, Minnesota

SENIOR QA/BUSINESS ANALYST/ SDLC LEAD

Responsibilities:

• Took a lead role on a $10 million project organizing and defining the SDLC process to manage all constraints including, setting up MS Share Point as a portal for managing all the projects under one umbrella.
• Effectively trained, motivated and mentored onsite and offshore junior members, managers, and developers.
• Met with subject experts to facilitate meetings and create test steps for executing Piper Jaffray’s Company systems such as (PJC) AOM, ACWS, and ICI print Flow
• Organized, setup, and performed testing on ADP connection flow to USBC System Fail Over. (Eagan Location) This test was to validate the flow of Trades to the Eagan System
• Organized training meetings to discuss and educate SME’s lead on how to report defects for each Mock phase.
• Interacted with Design and Implementation Team to provide relevant customer feedback and information requests and follow up on various issues, i.e., migration, performance improvement, and program/project variables.
• Created ADP Master Defect Report Form while assisting and training SME’s on how to update and execute test cases.
• Trained SME’s to perform Regression Test whenever defects are returned or system setups completed.
• Maintained a master daily defect spreadsheet while updating Test Metrics based on the SME’s results with a ‘pass/fail’ status.
• As Defect report came in from each SME, facilitated and met with each developer to discuss defect status and Application Interface Readiness.

Confidential, Richfield, Minnesota

QUALITY ASSURANCE LEAD

Responsibilities:

• Provided high-level estimate for each potential Business SR’s defined prior to the BRS Review. The test estimates include time to create the Master Test Plan, Test Case creation, and Test Case execution.
• Created and reviewed Master Test Plan with the BTA(s) based on the final BRS & SRS reviews.
• Demonstrate expertise with Mercury Quality Center and QuickTest Pro for Business Process Testing
• Used TestDirector to execute all manual and automated test cases into the respectful directory
• Lead in entering Defects in each phase. - Development as Crash n Burn Development Testing, Shared Test, Prod Certification as INTG Testing and PROD as Production Deployment Testing.
• During each Elaboration Phase, assisted in updating the project managers and development team during the weekly ALBC meetings regarding readiness for testing.
• Responsible for preparing and presenting weekly Defect Status Reports to the ALBC team which, provide opportunity to resolve Open issues t the team.
• Provided assistant to listing any Open, Reopened, Fixed, or Deferred defects which, assisted in a making a Go-No Go decision before the final release.
• Assisted in testing scheduled or emergency change requests (CR’s) as they occur.

Confidential, Minneapolis, Minnesota

SENIOR QUALITY ASSURANCE / BUSINESS ANALYST

Responsibilities:

• Reviewed all requirements product requirement documentation (PRDs) while helping to develop and execute each test script.
• Created defects in Remedy and Bug Tracker to ensure that the Bea's Weblogic (JAVA) platform and Tomcat's Pocket PC meets all company standard business rules
• Used Quest Software's TOAD 7.5 to create and set up complex SQL script for testing the application.
• Interfaced with customers to help understand and define the system requirements so as to create test scripts.
• Participated in all phases of each software development life cycle including project planning, requirement definition, design, code, test, and software release.
• Responsible for executing all test manual scripts, while ensuring that the quality control procedures are correctly and effectively implemented.

Confidential, Edina, Minnesota

QUALITY ASSURANCE ANALYST

Responsibilities:

• Created and executed over 50 test scripts to ensure that SIRG will continue to accept completed transactions from MoneyNet, ACH, JTMAN and HOGAN systems.
• Performed complex testing to ensure that each contracts/users created in JTMAN are read by SIRG for matching the appropriate account.
• Assisted in providing direction and leadership to the testing team, while defining and creating test data for the wire team.
• Prepared daily test matrix and status reports to the project manager and team leads
• Reviewed and updated each defects in CLEARQUEST for accuracy.
• Met regularly with test mangers to discuss overall scope and status for the wire-net project,
• Developed test plans and maintained test cases in Test Director for the testing team.
• Responsible for doing all regression test whenever new releases and enhancements are completed for the Online Banking Application.