Loading profile…
Efrain Plaza
Looking for a jobSr. Data Analyst
Senior Data Analyst at Cisco Systems, building logistics dashboards and automating analytics workflows.
United StatesSr. Data Analyst at Cisco Systems
Experience
Sr. Data Analyst
Built global security audit analytics dashboard for Global Manufacturing Logistics, partnering with stakeholders to define controls, KPIs, and reporting requirements. Designed and developed shipment consolidation dashboard in Power BI, connecting to Snowflake and creating optimized SQL views.
Power BIDAXTableauSQLSnowflakePythonDBTAsanaSalesforceNetSuiteAILLMData ModelingETLDashboard Development
Operations Systems Manager
Created a weekly updated dashboard based on 5 critical metrics, designed to evaluate strategies crucial for the continued success of the organization. Researched current processes, supported stability, and optimized performance of several packages developed using SQL Server Information Services (SSIS).
TableauSQL Server Integration ServicesT SQLSSRSExcelPower PivotData AnalysisProcess Optimization
Business Intelligence Analyst
In charge of 5 Dashboards presenting critical KPIs to diverse stakeholders at Global Business Services Division. Optimized and generated weekly 2Tier-NG Metrics Dashboard to track Indirect Resellers and Distributors vs. Cisco Service Contract Center adoption.
SQLOracleToad For OracleOBIEEExcelPivot TablesData WarehouseBusiness Objects
Corporate Business Systems Analyst
Automated weekly Medicaid remit processing using T-SQL queries embedded in Excel, reducing manual processing time from 40 hours to 30 minutes weekly. Processed and validated Electronic Data Interchange (EDI 835/837) transactions to extract claim status data from Medicaid and private insurance portals.
T SQLExcelEDISQLCrystal ReportsTableauJDAData AnalysisProcess Automation
Productivity Analyst
Analyzed and designed SQL scripts to enable optimal delivery of complicated data requests linked to CPT codes on clinical services provided and claims status. Provided ongoing Level II support for staff analysts on Crystal Reports and SQL queries.
SQLCrystal ReportsData AnalysisHealthcare Analytics
Education
Johns Hopkins University
Certified Data Scientist program from Johns Hopkins University.
Universidad Metropolitana
Master of Science in Finance from Universidad Metropolitana.
Universidad Metropolitana
Bachelor of Science in Computer Science from Universidad Metropolitana.