Estela Braza Email & Phone Number

Dulles, Virginia, United States

Data Integrity and Reporting providing technical support for PRISM, reporting and related data ( consisting of both ad-hic and dashboard reporting). Communicating and troubleshooting third party software Cognos. Data migration between PRISM and client's financial system.

Reston, Virginia, United States

Translated business requirements into user stories in Jira. Analyzed and derived meaning from business to provided data-driven insights and storytelling. Produced ETL workflows, dashboards, reports, views, and tables, for different projects, including Signature Required, SOX compliance, UPS Exit, Backorder, and Undeliverable packages. Collaborated on identification of metrics to track organizational performance via dashboards. • Reduced 10% of errors in handset setup by creating visualizations that allowed production teams to find specific setup issues with handsets.• Prevented out of stock inventory by providing planners and executives with “Low Inventory” alerts per store when new iconic handsets were launched.• Received special recognition for creating dashboards, combining Sprint and T-Mobile datasets.• Applied extensive expertise in SQL, improving quality of data, drafting logic and optimizing queries utilized as base for downstream tools like SSIS ETL packages, Power Bi and MicroStrategy.• Researched and identified trends and gaps in reports and dashboards, assisting in insights delivery, problem solving and analysis, and addressing issues prior to production implementation of many projects.• Conducted SDLC from requirements gathering, developing, testing, implementing, and maintaining of different graphical user interfaces, including views, dashboards, and reports related to supply chain data.

Reston, Virginia, United States

Subject Matter Expert of Data for different inventory fulfillment processes. Created and provided technical support for reports, dashboards, and other data tools. Gathered requirements, developed reports, tested outcomes, and implemented data solutions. Created views, triggers, functions and store procedures.• Established report logic for retail stores rolled out to entire country including 7K Sprint and T-Mobile Stores, allowing sales associates to execute in near to real time fashion including reports such as sales, serial number history, inventory adjustments, receiving, and stock value, serial number aging, physical inventory count, inventory transaction summary, and vendor returns data.• Developed and implemented transaction reconciliation report logic between Sales System (RMS) and Order Inventory Management System (OMIM) required for SOX compliance identifying issues and reducing them from 30% down to 1%. • Recognized for implementation of Data Feeds (Interface 15) aggregated to data warehouse from Sprint's Order Fulfillment Center (Ingram Micro), saving $250K in reporting needs.• Established reporting criteria and standards based on data analysis and application of business rules resulting in accurate and complete data presented to users.• Identified performance issues with hundreds of reports, optimizing execution times by at least 20%• Supervised data flowing in and out of data warehouse, such as order management inventory system (OMIM), retail management sales system (RMS), interfaces with external vendors, customizing data sets to centralize digital repository for reporting and data analysis ensuring data integrity. • Identified data inconsistencies prior to production by working with various departments / IT teams and vendor for Datawarehouse Integration. • Gathered requirements, identifying data sets needed and developing more than 500 queries and views for data to be easily accessible for sales, inventory and forecasting dashboards.

Reston, Virginia, United States

Organized and planned tasks and schedules, managed projects for prepaid, postpaid, and insurance business data. Collaborated with cross functional teams and vendors, such as Apple, Samsung, Virgin Mobile, Brightpoint, and UPS. Projects included EDI communications, Forecasting Handsets / Accessories, Inventory, Sales, and Service Level Agreements (SLAs). Developed and solidified MicroStrategy and Crystal Reports due to projects and initiatives being implemented.• Ensured integration of projects, adjusting project scope, timing, and capacity as needed, aligning with business needs.• Executed project deliverables, coaching and delegating team members to guarantee project success, and implementing interface data feeds from vendors into Sprintʼs data warehouse. • Served as liaison between developers and stakeholders, confirming requirements and design considerations were incorporated and created presentations, providing project status to stakeholders and executives.• Reduced execution time 300% by developing and implementing DTS packages, oracle views, triggers, functions and store procedures for critical sales and inventory reports.• Migrated more than 100 Crystal Reports into MicroStrategy new tools, streamlining 30% of reporting portfolio. • Developed and monitored reports, tracing certain trends and identifying fraud activity, saving company thousands of dollars.

Bachelor'S Degree, Electronic Engineering

Engineering