We provide IT Staff Augmentation Services!

Business Intelligence Systems Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Data Analyst - Functional Analyst with extensive experience designing and implementing software solutions in the Retail, Software, Supply Chain and Finance sectors.
  • Current focus is on Product Owner deliverables from traditional software feature development to data mining for data migration into the cloud or to a new platform.
  • My passion is collaborating with customers to deliver progress and improvement in software and analytic tools. Applying my eye for detail and enthusiasm in the Blockchain, Machine Learning / AI space would delight my curious, results driven work style.
  • Open to all short-term or long-term projects and appropriate support opportunities, onsite and/or remote.
  • DATA ANALYTICS / AZURE / DATABRICKS / BUSINESS INTELLIGENCE / RETAIL / SUPPLY CHAIN / FINANCIAL APPLICATIONS
  • AGILE / WATERFALL METHODOLOGIES
  • APPLICATION + VENDOR COLLABORATION / SERVICE DELIVERY

TECHNICAL SKILLS:

Productivity Tools: SQL Queries, Data Modelling, Collibra - Data Governance, Databricks, Azure Data Lake, Oracle SQL Developer, DbVizualizer, PostgreSQL, MongoDB, xml, JIRA, Confluence, VSTS, Confidential Project, SharePoint, Lync, Excel, Word, Visio, PowerPoint

Environment: s: Big Retail Data migration, Mainframe/EDI Migrations, Supply Chain/Logistics, KAFKA, Government Agencies, Wireless - Credit Risk Management, BI & Reporting Analytics, Software Licensing, Release Management, eCommerce, Capital Markets, Data Migration, Trading Systems, Citrix, Virtualization, Grid, Acceleration, Storage, VPN, Firewalls, SOX / Basel Compliance, Multicasting, Telecommunications

EXPERIENCE:

Confidential

Business Intelligence Systems Analyst

Responsibilities:

  • Creating Simphony Point of Sale (POS) Data Products for Data Scientists so that they can be used for executive sales and forecasting dashboard used by the CEO.
  • Migrated Oracle “On Prem” Data Warehouse to Azure Data Lake by identifying the data attributes, applying data governance standards and improving business rules for most accurate POS data.
  • Researched existing data in both Oracle “On Prem” Data Warehouse via SQL queries and Azure Data Lake using Databricks. Compared data and performed SME aggregation validation, QA and User Acceptance as needed.
  • Advocate for the adoption of Data Governance and Catalog tool Collibra for Data Engineers’ requirements and metadata for Business and Data Scientists.
  • Building parameters for future POS regression testing.

Confidential

Order Management Business Analyst

Responsibilities:

  • Analyzed EDI Customer orders, business rules and data quality with goal of optimizing Supply Chain application flow.
  • Defined functional requirements for java web-based Customer Order Management tool to migrate business rules from mainframe/Cobol and cumbersome EDI translations.
  • Heavy UX collaboration with UX Designer and Product Owner for improved user experience and interactions.
  • Process documentation for new customer onboarding.

Confidential

Business Analyst

Responsibilities:

  • Assessed Customs and Compliance shipping logistic processes and defined requirements driven by Confidential Product team, government agencies and internal technology strategy.
  • Heavy collaboration with business stakeholders to identify US Customs workflows, business rules, UI interfaces and validations required to enable successful import processes.
  • Researched, documented and validated mainframe workflows for migration into new java-based US Customs and Compliance application. Workflows include Customs and Compliance rules and calculations, migration to Customs digital imaging, identifying and addressing the various needs of government agencies such as FCC, DOT and EPA.

Confidential

Business Analyst

Responsibilities:

  • Analyzed Obama Exchange technical requirements that Confidential had to meet to participate in the healthcare marketplace.
  • Evaluated guidelines and rules for financial transactions for Confidential to participate in Obama Care/Market Exchange.
  • Analyzed Oregon State Health Care Exchange requirements for communicating insurance premiums, government financed amounts and Exchange cost overhead between Exchange participants.
  • Developed workflows along with accompanying requirements to ensure secure, successful xml and EDI file submittal and transmission.

Confidential

Credit Risk Business Analyst

Responsibilities:

  • Defined complex requirements to enhance credit risk assessment processes and systems to help control bad debt.
  • Created comprehensive wireless Use Cases and associated UML diagrams, data inputs and outputs for the diverging wireless marketing channel workflows.
  • Collaborated with key Channel and Marketing stakeholders and subject matter experts to gain consensus on new workflows and requirements for improving fraud gaming, customer identification and marketing campaign functionality.

Confidential

Project Manager

Responsibilities:

  • Project managed v1.0 delivery of MS Cloud, a business intelligence tool for analyzing and tracking revenue of Confidential cloud services.
  • Delivered Baseline Metrics to track MS Cloud services such as Office 365, Intune, CRM Online, Azure and eventually Xbox.
  • Led stakeholders and technical daily triage meetings with Business/Finance Analysts, SMEs and Business Intelligence Engineering/Test Teams. SharePoint collaboration for Issue tracking.
  • Managed UAT end to end including Business/Core team meetings, Product Test Case development and execution, issue triaging and extensive Training documentation development to support Production launch.

Confidential

Software Project Manager

Responsibilities:

  • Led development, operations and UAT teams to assess requirements, impact and plan for support.
  • Architectural and security management to ensure robust solutions for the gaps in Azure support and security limitations.
  • Drove best practices for the development of repeatable processes for future Confidential IT application migration.
  • Reclamation of significant distributor revenue leakage
  • Stakeholder management including WWLP business, VL Solution Management, VL Engineering and an extensive validation / test team.
  • Heavy SDLC compliance and creation of Kick Off, Pre-Baseline, Baseline and Go/No-Go decks.
  • Impact and risk analysis related to SAP global Pricing List and frontend UI.
  • Managed scope change, business justification and bug triage facilitation.
  • Software licensing optimization
  • Automated and improved the user experience of channel partners and online software purchasing clients - Laminar v1.3 and v1.4.
  • Conducted engineering focus meetings for review of quarterly risks, issues, bugs and next steps for solutions while administrating communication of project status and deliverables weekly in minutes, status reports and project audits.
  • Facilitated triage meetings with Business stakeholders and development teams for review of business or future release impacting bugs.

Confidential eCommerce Business Analyst

Responsibilities:

  • Defined wamu.com requirements driven by the businesses, regulatory demands and technology issues / advancements.
  • Conducted usability research and analysis to determine feasibility of new online banking functions and features such as fund transfers, account management, payments, security, alerts and cross-product marketing.
  • Utilized Agile framework principles, in conjunction with user experience designers and product owners, to create functional design specs which allowed for efficient developer interpretation.

Confidential

Capital Markets Business Analyst

Responsibilities:

  • Defined business requirement and functional specs for a new Risk Management MS SQL 2005 Database to enable value-at-risk evaluation.
  • Led market risk application stabilization effort ensuring robust, timely and transparent IT communications.
  • Facilitated and tracked status concerning change requests, release management, defects, root cause analysis, and day-to-day offshore team performance.
  • Implemented 3rd party software enabling an outdated and error-prone risk analysis process to become fully automated.

Confidential

Project Manager

Responsibilities:

  • Managed US Infrastructure / Application Development $4M budget process, US eCommerce infrastructure upgrade as well as disaster recovery, compliance and audit processes.
  • Root cause analysis of trading floor system issues and problem resolution to correct and contribute to future project definition.
  • Built business cases providing developers with infrastructure resources, including network design, firewall requirements, new servers, technology software and storage area networks.
  • Collaborated with performance and operation teams to identify opportunities of improvement and drove changes triggered by application expansion and infrastructure usage, resulting in enhanced scalability and reliability.

We'd love your feedback!