SUMMARY:

Experienced professional with proven success within Business/Systems Analysis and information service venues. Strong ability to forecast and report finance and budget data. Demonstrated skills in collateral management and documentations. Extensive knowledge of business requirements gathering, business process analysis, BPM (Business Process Management), business logic, case tools, and data analysis. Expertise in mortgage loans, commercial/consumer lending, credit card, and credit risk. Well - versed in IT service management, ITIL best practices, and data management.

AREAS OF EXPERTISE:

• Web Services/XML
• Project Management
• Agile/Waterfall Methodology
• Data Cleansing
• COTS Applications
• Entity Relationship Diagrams
• Database Backup Systems
• Business Process Redesign
• Requests for Proposals
• SQL/Reporting & Dashboards

TECHNICAL SKILLS:

Processes: MS Visio, Rational Unified Process (RUP), Rational Rose, RequisitePro, IBM Rational Tool, ClearQuest, ClearCase

Languages: C/C++, Java, SQL, XML, HTML, VB Script, JavaScript

Test Tools: Quality Center (QC), ALM, Quick Test Pro (QTP), WinRunner, Load Runner, Test Director

Database: UML, RUP, SDLC, WATERFALL, AGILE, SCRUM, XP, SOA MS Access, SQL Server 2000, Oracle 9i/8.x/7.x

PROFESSIONAL EXPERIENCE:

Confidential

Management Consultant - Senior Systems Analyst

Technical Scope: Oracle DB, Oracle Toad SQL tool, Business Objects, MS Project, MS Word, MS Visio, Power Point, SharePoint ALM, MS Excel, Java, Web Logic, DB2.

Responsibilities:

• Facilitate joint requirement sessions with business partners to identify and document Confidential and reporting requirements.
• Develop URD (Universe Requirement Document) and report tractability matrix across different Portfolios, to assist with number of Universes needed for reporting purposes.
• Mapping of Application Processes with Physical Data Models.
• Inspecting, cleansing, transforming and modelling data.
• Led teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches, depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Develop Enterprise Life Cycle documents.
• Act as a subject matter expert between business line Senior Management and US Technology/ Information Management technical groups.
• Used HP Quality Center ALM as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.
• Support Development System Integration Testing & Release Level Testing.
• Facilitating JAD sessions, conducting stakeholder interviews, focus groups and workshops.
• Ensure accurate completion of project artifacts as defined by SDLC standards.
• Identify and escalate project issues as appropriate, ensure data quality and integrity of BASEL reportable data mapping.
• Compiling of high level work estimates, identifying project timelines and task dependencies, and providing issue mitigation or resolution.
• Provide ongoing reporting and project oversight. Make recommendations for handling and use of data within the Confidential as well as for the mitigation, filtering, or correction of data quality issues.

Confidential, Columbus, OH

Management Consultant - Principal Business Systems Analyst

Technical Scope: Oracle DB, Oracle Toad SQL tool, MS Project, MS Word, MS Visio, Power Point, SharePoint ALM, MS Excel, Java, Web Logic, IBM Blueworks, DB2.

Responsibilities:

• Collaborated with IT groups on Joint Application Development sessions identifying key changes, and participating in stakeholder management forums/meetings to communicate effectively.
• Served as liaison between business users and development resources to facilitate large- and small-scale changes and complex problem solving.
• Assist PM in maintaining project schedules, work breakdown structures (WBS), issue/decision logs, meeting summaries and status reports to ensure effective, ongoing communications across all team members.
• Used IBM Blueworks to map high level business process flows and participants.
• Knowledge of dashboard and report creation and analytical concepts using excel, BO, Repository and Dashboard.
• Create extensive SharePoint documentation for end users, business owners and site collection administrators.
• Develop and maintain documentation, BI dash boards and reports.
• Review, analyze and evaluate detailed business and functional requirements, documentation, process flows and data models to contribute to the development of project plans including project charter, project deliverables, cost/benefits analysis, time line estimates, scope and control.
• Analyzed product portfolio data to identify areas for improvement and assisted PMs in implementing the improvements. Contributed to an innovative solution that resolved problematic GUI and compatibility issues without compromising release readiness, budget or deadline.
• Develop use cases, defining and documenting user procedures and workflows, and how each class of user interacts with east system function.
• Participate in daily Scrum meetings. Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Worked with Internal Architects/Developers and, assisting in the development of current and target state enterprise data architectures.
• Defined source to target data mappings, business rules and data definitions.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Gather, validate, document, and facilitate implementation of business requirements for technology initiatives (includes business/data requirements, data flows, data modeling, workflow context and design, and user interface designs). .
• Participated in the review process of Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing.
• Execute test cases and test scripts for manual and automation testing. Raised defects HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Develop staff user manual and reported on systems and processes for senior management.

Confidential, Birmingham, AL

Management Consultant - Lead Business Systems Analyst/UAT Lead

Technical Scope: IBM Rational Tools, Rational Unified Process (RUP), Rational Suite (MS Visio, MS Project, Oracle, HP Quality Center & ALM, MS SQL Server, MS Access, Micro-Strategy, Power Point, Microsoft SharePoint, Moody’s Risk Analyst, AFS (Automated Financial Services)

Responsibilities:

• Expertise in system design and development required for business process with solid understanding of Business analysis, Business Requirements Gathering, Software Requirement Specification (SRS), and Translating Requirements into Specifications, Project Management, Application Design, Data Modelling and Testing.
• Blueprinted technical and operational training manuals and led Power Point/Visio presentations for the development of financial and technical applications for the departmental user base and for audit purpose.
• Assist with multiple release rollout and SPOC between the CCB (Change control Board) and internal team.
• Used MS Word & Visio to document data flow of the AS IS process and TO BE process with stakeholders.
• Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL and Confidential customization.
• Successfully created logical/physical data model and loaded tables in data warehouse.
• Involved in daily Scrum meetings. Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.
• Performed GAP and Impact Analysis against requirements specifications.
• Co-ordinate requirement management for upstream and downstream applications.
• Prepare and maintain complicated dashboards reports through the use of Excel.
• Administer and analyze the data in physical, business model and mapping layers.
• Proficient in creating Use Cases, Sequence Diagrams, and Collaboration diagrams, Activity Diagrams, Class Diagrams and Business Intelligence Tools etc.
• Worked with Internal Architects/Developers and, assisting in the development of current and target state enterprise data architecture. Developed Use Cases and process/data flow diagrams.
• Work with Project Sponsor and Stakeholders to complete project charter outlining scope, goals, deliverables, required resources, budget and timing.
• Demonstrated strong interpersonal skills, including the ability to liaise effectively with fellow team members to anticipate technical limitations and glitches and effect smooth system deployments.
• Facilitating JAD sessions, conducting stakeholder interviews, focus groups and workshops.
• Involved in designing Report Layout for Pipeline & Exceptions with MIS and present to Business Stakeholders and Business Sponsors.
• Complete Work Breakdown Structure (WBS) to estimate effort required for each task.
• Used HP Quality Center ALM as a test management tool in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results.

Confidential, Birmingham, AL

Management Consultant/Senior Business System Analyst

Technical Scope: Rational Unified Process (RUP),Rational Clear Quest, IBM Rational Tools, SDLC, UML,MS Word, MS Excel, MS Visio, MS Project, MS Power point, HP ALM, UAT, Use Cases, SQL, Microsoft SharePoint, Power Point.

Responsibilities:

• Authored high level/detailed test plan and strategies to integrate system and UAT testing.
• Maintaining Requirement document repository and stored documents in Microsoft SharePoint and providing updated version as required.
• Ensure the security and accessibility of data and leverage the integration process on a common platform.
• Identify the data requirement list and analyze the data to be extracted or added. Created and maintained Reports and Dashboards.
• Developed detailed Use Cases to show user and system interaction.
• Analyzed & suggested business requirements, specifications, apprised the same to the Project Lead of the project for any additional improvements; its subsequent impacts on to the job flow. It includes finalizing the time frame to finish the task and complete project implementation.
• Successfully delivered product on time and within budget.

Confidential, Memphis, TN

Senior Business/Data Analyst

Technical Scope: Rational Unified Process), IBM Rational Tools, Rational Suite (RequisitePro, Rational Rose, MS Visio, MS Project, Oracle, HP Quality Center & ALM, MS SQL Server, MS Access, SAP Business Objects.

Responsibilities:

• Drafted requirements traceability matrix for each stage of requirement gathering process and documented testing GAP aided by test administration team.
• Develop dashboard and report for business users by using Excel and BO.
• Developed use cases, activity and sequence diagrams based on UML methodology and business process flow diagrams.
• Improvised on process improvement activities to remove redundancies in new environments.