SUMMARY:

Accomplished professional with record of managing and contributing to IT projects that exceed client expectations. Skilled in identifying and clarifying business requirements, performing data / requirements gap analysis, designing data integration, process and system solutions. Strong interpersonal skills for facilitating decisions with stakeholders.

CONTRIBUTION AREAS:

• Business / Functional Analysis
• Agile / Scrum
• Data Analysis / Integration
• SQL / Relational Databases
• Process Analysis & Solutions
• Data Modeling
• Functional / Feature Analysis
• Project Management
• UAT Validation
• Business Requirements (BRD)
• BI / Data Warehousing
• PowerBI / PowerPivot

TECHNICAL SKILLS:

Database: SQL Server, PowerBI, some COSMOS, Oracle and Teradata

Data Modeling, Business Requirements, Process Modeling: Visio, Excel, PowerBI, ERWin Modeler

Project Management: Smartsheet, TEAMS, MS Project, Excel, Visio, JIRA, Confluence, SharePoint

ETL, Analytics: SQL Server, PowerBI, DAX, SSAS (Analysis Services); SSIS (Integration Services)

Development & Testing: SQL Server Management Studio, MS BI Development Studio, Test Director, HP Quality Center, Remedy, JIRA, Confluence

Programming / Scripting: SQL Server T - SQL / SSMS, some PLSQL / TOAD

ERP: SAP; Oracle and PeopleSoft

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst and Project Manager

Confidential

Responsibilities:

• Guided implementation of Oracle R12 EBS / core financial modules for 1500 - store acquisition in East China.
• Managed high-level requirements and workstreams (GL, AP, AR, fixed assets, reporting) in concert with IT and master data workstreams.

Confidential

Sr Program Manager

Responsibilities:

• Implemented pilot program to establish anti-bribery management system in cloud infrastructure group, Romania and Hungary.
• High-level scope included project management elements, mapping the standard to risk assessments, policy development and management training and implementing risk management and reporting tool.

Confidential

Sr Program Manager

Responsibilities:

• Guided evaluation of SOX control gaps for client’s manifest and invoice payment ($16B annual spend) processes.
• Completed as-is / to- be gap analysis, applied Agile / Scrum project approach, developed user stories around SOX control requirements.
• Worked with developers to deliver 1st iteration functionality requirements.
• Facilitated working sessions with developers in Hyderabad, managed resources remotely.
• Completed 1st and 2nd iteration artifacts for client’s governance and risk management platform.

Confidential

Sr Data Analyst, Sales & Marketing Digital Services

Responsibilities:

• Delivered analysis and evaluation comparing Confidential versus FY18 metrics for senior sales management.
• Innovated meta views of KPIs / metrics to pinpoint FY18 data requirements. Employed PowerBI / Power Query (pivoted / unpivoted views) creating visualizations (heatmaps, bar charts).
• Clients are channel managers preparing their FY18 reporting metrics.

Confidential

Sr Business Analyst

Responsibilities:

• Performed in-depth user acceptance testing for new revenue recognition standards.
• Scope was end-to-end testing of post-paid systems.
• Managed creation and validation of business use cases and executed test scenarios.
• Employed SQL, QuikView, Watson, HP Quality Center and advanced Excel PowerPivot and PowerBI, for progress / status reporting.

Confidential

Sr Business Analyst

Responsibilities:

• Produced dashboard and metrics reporting for retail and online store ( Confidential Store) senior management.
• Reporting included financial and non-financial measures for physical and ecommerce operations in over 230 markets.
• Heavily employed PowerBI tools for data analysis and visualization: PowerPivot, PowerView and PowerQuery. Updated DAX to produce reporting changes.
• Engagement suspended due to unanticipated budget reduction.

Confidential

Sr Business Analyst

Responsibilities:

• Contributed analytical and database and systems experience to successful enterprise ETL / data integration project.
• Analyzed and documented existing and new data structures; worked business requirements process with stakeholders to determine workflows for cleansing and moving financial metrics into data warehouse.
• Developed detailed data maps. Contributed with business analysis, T-SQL and advanced Excel (PowerPivot, Pivot-Tables) to elicit, develop and document increasingly robust solutions.
• Performed UAT and project management.

Confidential

Sr Business Analyst

Responsibilities:

• Developed and validated nearly 200 functional use cases for upcoming accounting system (SAP) enhancements.
• Employed business analysis, SAP and T-SQL queries with advanced Excel to discover, evolve and validate as-is and to-be use cases.

Confidential

Sr. Data Analyst

Responsibilities:

• Completed rollover / update for Excel financial and operational reporting (over 100 worksheets) that source data from SSAS tabular databases.
• Performed validation of new entitlement and usage data across data integration of Confidential and MS Sales platforms.
• Leveraged Excel (query sets) and PowerPivot to build MDX queries that reduced query response times.
• Created data dictionaries on SSAS cubes for quick identification of data attributes and measures.
• Developed set of automated SQL queries for team to build data dictionaries across multiple databases.

Confidential

Sr. Business Analyst

Responsibilities:

• Developed business / functional requirements use cases for data integration, extraction and reporting from data warehouses.
• Engaged with development / QA team and business users to put in place significant data model changes driven by new accounting system implementation.
• Quickly digested complex SQL queries to document data lineages (source to target) for multiple data feeds into and out of data warehouses.

Confidential

Sr. Data Analyst

Responsibilities:

• Contributor to implementation of MS Cloud data warehouse for data integration, performance / metrics reporting.
• SQL-based deliverables enabled client to evaluate growth and actual vs. target performance across Office 365, Dynamics CRM, Windows Azure and other offerings.
• Primary users were business analytics teams and their senior management.
• Work products entailed use cases, data requirements, determining new data relationships and implementing SQL code to meet requirements.
• Analysis included relational (OLTP) and dimensional databases.

Confidential

Sr. Functional Analyst

Responsibilities:

• Engaged users to determine data attribute and data model changes required for integration of customer insight and campaign management platforms.
• Developed source system analysis and use-case functional requirements documentation.
• Evaluated complex business requirements documents.
• Created as-is and to-be artifacts such as workflow and data flow diagrams, logical data models and user stories.

Confidential

Sr. Business Systems Analyst / Project Manager

Responsibilities:

• Developed and conducted / facilitated business process improvement initiative (including data model changes) across 5 (five) enterprise business processes and resulted in painpoint / gap evaluations, business use case justifications, prioritized business requirements.
• Engaged SMEs in highly interactive group processes that increased enthusiasm for change and created buy-in for next steps.
• Developed methodology that visually integrated data flow and workflow views for quick identification of painpoints / gaps and their corresponding costs and risks.
• Delivered workflow / data flow analysis / data model packages that formed foundation for business and IT process improvement.

Confidential

Sr. Project Manager

Responsibilities:

• Developed and deployed IT issue management process for the enterprise cost accounting group with responsibilities across all supply chain processes.
• Supported Oracle ERP implementation (supply-chain, procure-to-pay).
• Developed and managed agile / scrum issue (Kanban) system that integrated defect descriptions, business requirements, business impact and blocking issues from multiple sources: Quality Center, Remedy, stabilization work logs, solution track meetings and superusers.
• Launched issue tracking whiteboard and agile / scrum stand-up meetings, resulting in increased focus on business impact, accountability for follow up and resolving blocked issues.
• Created weekly issue dashboard reporting, resulting in integrated view across multiple resolution work streams.
• Documented business requirements for defect correction and enhancements, resulting in increased levels of effort from IT groups on cost accounting / supply chain issues.