PROFESSIONAL SUMMARY:

• Possess strong tactical and solution based Business Analytical skills, with seventeen years of experience which includes leading full life cycle projects, JAD session facilitation, creation of Business and System Requirements specification documentation, wire frames, utilize various software development life cycle methodologies. Led projects within the following business areas: Basel, Benefit Services Administration, Consumer Real Estate, Data Quality Management, Finance, Health Care, Hospitality, Human Resources, Pharmaceutical, Procurement / Supply Chain Management, Retail, Risk and Compliance, Telecommunication, Software and Product Development, Software Delivery and integration
• Project initiatives include: Consolidation of multiple Systems, metric reporting, Business Intelligence, Content Management systems, CRM - Customer Relationship Management, Dashboard Development, Data Analytics, Data Lineage, Data Quality and Performance, Data Profiling, Data Warehousing, Hypothetical Modeling, MDM-Master Data Management, Metadata repository establishment, Operational Reporting, Portal and Web based applications.
• Possess strong Project Management skills, with twelve years of experience including project assessment, project scope determination, developing detailed project plans and road maps, appropriate resource allocation, Key Performance Indicators / CTQ’s, Project Charters, and ensuring projects remain on track. Able to create RFQ’s in order to assess and recommend third party vendors selection. Provide written and verbal updates to all management levels regarding project status and budget. Ability to reduce risk associated with project implementation utilizing various PMP, dPMM, AGILE, Six Sigma and Waterfall SDLC methodologies. Implemented large complex projects which include: Data Warehousing, Call Center Management, Healthcare, Financial Banking applications.
• Deadline driven and able to ensure project deliverables timelines are met on time and within budget. Interact well with all organizational levels including Senior Management, Project Stake Holders, Developers, Analysts, Q/A Testers, System Architects, Implementation and Production staff. Able to quickly and efficiently obtain requirements from cross functional groups and provide conflict resolution as needed. Assess and communicate business and process streamlining/re-engineering recommendations where appropriate.

TECHNICAL SKILLS:

Hardware: Windows NT ServerOperating Systems: SQL Server, Windows NT, Windows XP

Communications: FTP, ETL

Databases: DB2, BAAN, JDE, JDE One World, Netezza, Oracle, SAP, SQL Server, Teradata

Languages: Visual Basic, MS-Access, SQL

Software: Ab Initio, Alfresco, Art Plan, Axure, BluePrint, Business Objects, Google Docs, Hyperion Essbase and Intelligence, Informatica, MicroStrategy, Visio, MS-Access, MS-Excel, MS-Power Point, MS-Project, MS-Word, Vitria, Web Methods, Requisite Pro, Sales Force.Com, SharePoint, Subversion, Teradata SQL Assistant, CA 7, Mind Mapper

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Business Analyst

Responsibilities:

• Provide Business Analyst support as it relates to the development life cycle of reports for various sectors throughout the Organization. Acts as liaison between Business Stakeholders and report developers to ensure reporting requirements are captured and developed to internal and external customer’s specifications.
• Demonstrate reporting tool capabilities to various Users. Develop high to medium fidelity wire frames to elicit Stakeholder feedback. QA reports for accuracy, coordinate Stakeholder UAT sessions. Manage the process to identify, acquire and funnel data from various source systems to an Oracle and Teradata enterprise data warehouse.
• Work with third party vendors and create source to target data mappings from various source systems. Utilize SQL to view data for accuracy. Responsible for ensuring on and off-shore development resources are kept apprised of scope changes. Manage project budget and minimize scope creep from a development time and materials bases. Responsible for the documentation and enforcement of the Change Management process. Ability to influence business partners, drive results and manage competing priorities. Possess effective written and verbal skills to communicate business requirements and project statuses to Management and Business Stakeholders.

Environment: includes: Oracle, Teradata, SQL and Business Objects

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• Led JAD Sessions with cross functional Stakeholders to elicit requirements to aid in the customization of the Sales Force.Com application and development of Analytical Reports and Dashboards.
• Developed Data Specifications documentation for the purpose of migrating data from Oracle to a new Teradata Enterprise Data Warehouse Platform.
• Developed and facilitated report prototyping reviews with Business Stakeholders and technical teams. Led solution feasibility exercises to ensure data exists to support requested reporting metrics and the underlying business need. Responsible for ensuring delivered solution met the goals of the Business Stakeholders. Provided daily SCRUM updates to Business Stakeholders and Technical Teams.
• Initiatives required: Detailed analysis, development of Business and Functional Requirements, process and data flow diagramming using Visio, utilization of Alfresco, Google Docs and Business Objects Reporting tools.
• Projects included: Analytical Performance and Operational Reports and Dashboards, consolidation of reports from multiple acquired systems from various regions. Various Multi-level reporting hierarchical structures, and Enterprise data solutions. Customization of the Sales Force.Com application.

Environment: included: Oracle, Teradata, Business Objects, Sales Force.COM, Initiate - Master Data Management - (MDM)

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• Led and facilitated JAD sessions with various level of Business Stakeholders to elicit, translate and document reporting needs into a Requirements document for the purpose of developing analytical reports. Developed Technical documentation for the purpose of migrating data to a new Enterprise Data Warehouse to be accessed by Business Objects.
• Developed current and future state process flow diagrams to help determine areas of Optimization and efficiency improvement. Developed and facilitated report prototyping reviews with Business Stakeholders and technical teams. Led solution feasibility exercises to ensure data exists to support requested reporting metrics and the underlying business need. Elicited and documented requirements to automate and develop a Graphical User Interface to aid in streamlining adjustments of customer orders.
• Responsible for ensuring delivered solution met the project established goals and expectations.
• Initiatives required detailed analysis and documenting, project management, process and data flow diagramming using Visio, utilization of SharePoint, Business Objects Reporting tools.
• Projects included: Performance and Operational Reporting, consolidation of reports from multiple systems within various regions. Various Multi-level reporting hierarchical structures, converted a manual adjustment process to an automated process.

Environment: included: Business Objects, Oracle, SQL

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• Led and facilitated JAD sessions with all levels of business team stakeholders to elicit and document functional and technical requirements to aid in the development of an Executive multi navigational Dashboard.
• Assessed, determined and recommended processes for loading of multiple source files to populate various quadrants of an Executive Dashboard. Developed error handling and correction process to enforce data integrity.
• Provided guidance and validation to on and off shore technical development, architectural and design resources
• This initiative required detailed analysis, prototyping, data analysis, data mapping, developing of Use and Test Case scenarios, process and data flow diagramming using Visio and BluePrint.
• It further required the ability to conceptualize and gain an understanding of various data sources which were used in conjunction with complex business rules for the display on the newly developed Dashboard.
• Project included: The development of a predictive analytics Dashboard to aid in early quality risk detection.

Environment: included: Agile/Waterfall SDLC, SQL Server, Business Objects, BluePrint Requirements Tool, iRise Simulation Tool, and SharePoint for document storage and issue tracking.

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• This initiative required detailed analysis, project management, resource management, process and data flow diagramming using Visio and obtaining a conceptual understanding of various metadata, data cleansing and data profiling applications.
• Project included: Metadata repositories, Process and work stream Development, Process Flow Modeling, Data Quality Improvement and enforcement, SharePoint List development

Environment: included: Oracle, Teradata, Informatica, SharePoint

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• Led and facilitated JAD sessions with various levels of business Stakeholders to elicit, translate and document Analytical Reporting needs into a Business Requirements document.
• Developed current and future state process flow diagrams to help determine areas of Optimization and efficiency improvement. Developed and facilitated report prototyping reviews with Business Stakeholders and technical teams. Led solution feasibility exercises to ensure data exists to support requested reporting metrics.
• Responsible for ensuring delivered solution met the project goals and expectations.
• Initiatives required detailed analysis and documenting, project management, process and data flow diagramming using Visio, utilization of SharePoint, MicroStrategy Reporting tools.
• Projects included: Performance and Operational Reporting, Re-engineering of Organizational System Access Request Process, Various Multi-level reporting hierarchical structures, Enterprise data solutions, ecommerce Web Base Solutions, Third party vendor data and reporting gap assessments

Environment: included: DB2, IBM Mainframe, MicroStrategy, Oracle and Teradata

Confidential

Sr. Business Analyst - (Consultant)

Responsibilities:

• Led and facilitated JAD sessions with developers to elicit, translate and document existing legacy application code into a multi stage process flow document.
• Developed business logic phrases to aid in the development of a Metadata lineage traceability application. Collaborated with cross functional development, data warehouse and ETL resources. Provided guidance and validation to on and off shore resources. Developed current and future state process flow diagrams to help determine areas of Optimization and efficiency improvement. This initiative required detailed analysis, project management, process and data flow diagramming using Visio, utilization of SharePoint and various utility querying tools.
• Project included: Metadata Lineage, analysis and translation of legacy code, Hypothetical Process Flow Modeling

Environment: included: Oracle, Teradata

Confidential

Sr. IT Analyst

• Led and facilitated JAD sessions with varied lines of businesses to elicit and document Use Cases and specific project features to in corporate into a System Requirements Specifications document. Developed medium to high fidelity wire frames using Axure prototyping simulation tool in order to obtain validation of project requested features. Developed project Use and test cases. Developed release schedules to aid in the planning of parallel work streams. Primary project entailed the re-development of an existing Supply Chain Management Procurement system into an enhanced web based User friendly application. The solution interacted with various subsystems and data marts which includes Siebel.
• Content management system stored data and graphics to provide the requester with a visual representation of their requested items.
• Developed current and future state documents to aid in the visualization of system redesign. Conducted requirements document reviews with executive sponsors, and subject matter experts to obtain approval signoff. Project required full life cycle engagement. Provided on-going status updates to varied lines of businesses as needed.
• Projects included: Web Based Healthcare Supply Chain Management Procurement application, Mirco Strategies Data Analytics Hypothetical Modeling Reporting tool, Compliance Tracking Analytics Reporting Tool, Application Usage Tracking Reporting Tool, Content Management Application, Pharmaceutical Bid and Analytics application and reporting tool

Environment: included: Oracle, Teradata, Axure Simulation Tool

Confidential

Change Consultant/Project Manager

Responsibilities:

• Supported GCIB - Global Consumer Investment Banking Finance line of business unit as it related to Hyperion Essbase Business Intelligence / Data Analytics financial management reporting development. Acted as liaison between business units and report developers to ensure reporting requirements were captured and developed to internal customer’s specifications. Supported multiple business units to ensure clear and concise understanding of existing and future Hyperion Business Intelligence tools capabilities by demonstrating functionality and coordinating sessions. Influenced adoption from a legacy financial reporting system to a multi-dimensional analytical cube environment. Managed multiple complex application development projects and initiatives. Coordinated local and off shore resources across various lines of businesses to ensure process standardization.Ability to influence business partners, drive results and managed competing priorities. Possess effective written and verbal skills to communicate business requirements and project status to management and business stakeholders.
• Project included: Development of Financial Management reporting models

Environment: included: Oracle, SQL, Insight, CLPR and Hyperion

Confidential

Business Analyst - (Consultant)

Responsibilities:

• Led and facilitated work sessions with assigned Consumer Real Estate lines of business owners to obtain and document requirements. The documented requests detailed and outlined requirements to migrate and consolidate varied systems into an enterprise data warehouse. The solution provides data marts sourced from one Teradata repository and accessed via a customized Business Intelligence Portal. Developed current and future state documents to aid in the visualization of system architectural re-engineering. Conducted requirements document reviews with executive sponsors, subject matter experts, data warehouse team and Center of Excellence leaders. Provided on-going status updates to assigned Lines of Business leaders. Worked in Unisom with other project assigned Business Analyst’s to strategically approach the business requirements gathering and analytical process.
• Project include: Consumer Real Estate hierarchical data

Environment: included: Oracle, TeraData, Metadata, and Hyperion

Confidential

Lead Business Systems Analyst - (Consultant)

Responsibilities:

• Led and facilitated work sessions with various warehouse domain owners to obtain and document specific requirements to consolidate into a master Business Requirements document.
• Developed business requirements document, which detailed process system re-engineering specifications to migrate Retirement Services, Insurance Annuities, and Life Insurance data to an Operational Data Store.
• Created process, and workflow documentation to aid in the visualization of process re-engineering. Conducted requirements document reviews with executive sponsors, subject matter experts, technical developers and testing resources to obtain signoff. Provided on-going status updates to Senior Management. Facilitated the change management process.
• Projects included: Insurance Annuities, Life Insurance and Retirement Services.

Environment: included: Oracle, TeraData, MetaData, Micro Strategies, Brio, Ab Initio and Rational Tools.

Confidential

Business Systems Analyst - (Consultant)

Responsibilities:

• Led and facilitated work sessions with numerous cross-functional business and technical groups.
• Created business requirements and system requirements documents, which detailed process and system re-engineering specifications to migrate manual desktop applications to an automated Data Warehousing environment.
• Conducted requirements document reviews with executive sponsors, subject matter experts, developers and testing resources to obtain signoff. Provided on-going status updates to Senior Management. Facilitated change management process.
• Projects included: Credit Disputes, Cross Sell, Fee Waivers, Online Account Servicing, and forecasting.

Environment: included: Oracle, TeraData, MetaData, Micro Strategies, Brio, Ab Initio and Rational Tools.

Confidential

Project Manager/Business Analyst - (Consultant)

Responsibilities:

• Lead member in successfully creating and conveying communication strategies to obtain buy-in from various business units regarding Data Warehouse, eSolutions, and other business intelligence initiatives using Six Sigma methodology. Successfully communicated business initiatives, purpose, savings, benefits, and resource requirements to obtain senior management approval. Provided verbal and written project status updates to management and facilitated project kickoff meetings. Worked with various Data Warehouse teams to ensure legacy system migration success and enforcing internal controls by conducting pre Warehouse data audits, and developing data exception handling processes. Worked with various metric leaders to elicit, document and design various Business Object reports. Managed the implementation and integration of third party document customization software throughout various business units.

Environment: included: Oracle 11i - 11O3, JD Edwards, SAP, and other non-standard ERP Systems.