Ervin A.

Senior Data Engineer working on different backend projects with Microsoft Azure and Fabric and additionally working with Databricks and Azure Data Factory.

• ETL and DWH Development: Designed and implemented scalable data warehouse architectures to support high-performance querying and reporting. Led the development of ETL pipelines using MS SSIS for seamless data integration across multiple financial systems.
• Financial Reporting: Developed complex financial reports and dashboards, equipping stakeholders with actionable insights for strategic planning and regulatory compliance.
• T-SQL & Python: Applied advanced T-SQL for writing stored procedures, triggers, and performance tuning. Used Python for data transformation, analytics, and automation of repetitive processes.
• Data Modeling & Analytics: Created and maintained both logical and physical data models, ensuring data integrity, normalization, and alignment with business objectives. Conducted in-depth data analysis to support decision-making and operational efficiency.

• Product & Solution Design: Led the design and delivery of data-centric products and services with a strong focus on information security, compliance, and privacy standards.
• DWH & BI Development: Built and maintained data warehouse infrastructures to support high-quality business intelligence and analytics workflows. Enabled seamless data integration across systems to improve operational visibility.
• Financial Reporting: Delivered tailored financial reporting solutions using modern BI tools, helping clients convert complex datasets into actionable insights and key performance metrics.

• DWH Development & ETL Design: Spearheaded the development of data warehouse solutions and implemented robust ETL pipelines to aggregate large-scale operational and customer data from multiple sources.
• Reporting & Data Integration: Delivered accurate and timely reporting solutions across business units, ensuring consistent data flow through advanced integration strategies.
• Teradata & DevOps Practices: Leveraged Teradata systems to manage complex datasets and optimize query performance. Collaborated with DevOps teams to streamline deployment workflows and enhance the scalability and reliability of data solutions.
• Analytics & Modeling: Performed in-depth data analysis and modeling to identify trends, optimize key performance indicators (KPIs), and support forecasting and planning in a high-velocity telecom environment.

• Telecommunications Projects: Led and participated in multiple high-impact initiatives involving large-scale data processing, performance evaluation, and strategic reporting to enhance service delivery and profitability.
• Data Warehousing & Analytics: Designed, developed, and maintained data warehousing solutions, ensuring accurate and consistent data collection and reporting across various telecom business units.
• Revenue Assurance: Implemented automated validation checks and control mechanisms to detect discrepancies, reducing revenue leakage and improving financial reporting accuracy.
• DevOps Collaboration: Partnered with DevOps teams to optimize integration, deployment, and monitoring workflows, thereby increasing system scalability and reliability.
• Data Modeling: Designed and implemented data models aligned with evolving business requirements, enabling efficient querying and comprehensive analytics for both technical and business stakeholders.

In this role, Ervin was responsible for the design, implementation, and maintenance of data systems and controls to ensure financial accuracy and operational transparency within the telecom environment. His efforts supported both strategic analytics and core revenue assurance processes.

• ETL & Reporting Infrastructure: Developed and optimized ETL workflows for consistent and reliable data ingestion. Delivered customized reporting solutions to meet business and regulatory requirements.

• Revenue Stream Assurance: Led end-to-end validation and assurance of revenue processes, including rating and billing verification, to identify and eliminate leakage points.

• Data Quality & Consistency: Implemented mechanisms for ensuring accuracy and completeness of financial and usage data across complex systems and platforms.

• Cross-functional Collaboration: Worked with finance, operations, and IT teams to ensure alignment between business needs and technical implementation.

• SQL Development: Wrote advanced SQL queries to support data transformation, reconciliation, and ad-hoc analysis.

As an Oracle Developer at PIOM, Ervin contributed to the modernization and automation of financial data systems in a highly regulated pension fund environment. His focus was on Oracle-based development and data integration, supporting the organization’s digital transformation goals.

• Oracle Development: Designed and maintained Oracle PL/SQL scripts and forms to support internal business processes, including pension data management and reporting.

• Data Integration Projects: Supported key initiatives aimed at integrating external data sources with internal systems, enabling more streamlined and accurate information flow.

• Process Automation: Helped automate legacy workflows, reducing manual effort and improving data consistency across operational units.

• Cross-team Support: Collaborated with analysts and IT teams to gather requirements and deliver solutions aligned with institutional compliance and reporting needs.