Power Bi Sql Server

NWAKAEGO PRISCILLA BALAN

Email: **********@*****.***

Phone: +1-214-***-****

LinkedIn: www.linkedin.com/in/ego-balan-45b583360

PROFESSIONAL SUMMARY

A results-oriented SQL Developer and Power BI professional with a strong foundation in finance (specializing in financial management and reporting, treasury, Account Payable, intercompany accounting, implementing financial strategies that drive profitability, enhancing operational efficiency, and ensuring compliance with industry standards), internal auditing, business process optimization, Project management, and risk control. Proficient in SQL database management, development and optimization with over 5 years’ experience in writing simple to complex SQL queries, stored procedures, triggers, and functions to manage and manipulate large datasets efficiently.

Experienced in designing and developing interactive Power BI dashboards, transforming raw data into actionable insights, and optimizing reporting solutions which enabled leadership in logical business decision making, Well-versed in DAX and Power Query.

Proficient in designing and implementing efficient ETL workflows (SSIS Package) to extract, transform, and load data from various sources into structured databases and data warehouses. Ensure data integrity and optimize data workflows for business intelligence and analytics.

A seasoned Chartered Accountant with over 15 years of experience in various financial and operational roles in the Oil and Gas Industry.

Highly analytical and detail-oriented Developer with a strong ability to problem-solve, adapt, and collaborate in fast-paced environments. Adept at critical thinking and troubleshooting. A team player, good leadership skills, a fast learner and works effectively in cross-functional teams, promoting knowledge sharing and innovation, committed to fostering a positive work culture, driving efficiency, and continuously enhancing technical and soft skills to deliver impactful solutions. TECHNICAL SKILLS

Databases SQL Server

Database Tools SSMS, Configuration Manager, SQL Server, MS SQL Server, Power BI

Technical Tools Database MS-SQL Server, Power BI, DAX, ETL, (SSIS), Git Hub, Outlook, Excel,

Visio, SharePoint.

Operating System Microsoft Windows, Apple’s MacOS. Methodologies Agile, Waterfall, Scrum,

SDLC, Technical Documentation.

Financial Systems Lawson ERP, SAP

PROFESSIONAL EXPERIENCE

TechAdvantage Global Resources LLC

Business Solution Analyst II Jan 2022 – Present

Reviewed and optimized SQL code to enhance query efficiency, database performance, and system scalability.

Designed, created, and managed relational database structures, including table creation, data manipulation, and updates in SQL Server to maintain data integrity.

Diagnosed and resolved performance issues in complex SQL queries and stored procedures, ensuring seamless database operations.

Developed and optimized SQL queries utilizing analytical and aggregate functions to extract valuable insights and support data-driven decision-making.

Implemented advanced data transformations, including Pivot Transformation, Slowly Changing Dimensions (SCD), Merge Joins, and Union operations, to improve data analysis and readability.

Designed and developed interactive Power BI dashboards to visualize fund performance, key financial indicators, and operational metrics, enhancing decision-making.

Developed dynamic DAX measures and calculations to enable real-time data analysis, KPI tracking, and business performance evaluation within Power BI.

Implemented advanced DAX functions to compute key financial metrics such as ROI, contribution growth rates, and variance analysis, ensuring accurate financial insights.

Designed and deployed SSIS packages for Extract, Transform, Load (ETL) processes, leveraging transformations like Lookup, Derived Columns, Conditional Split, and Aggregation to enhance data integration.

Utilized SSIS workflow components, including For-Each Loop Container, Sequence Container, Execute SQL Task, Variables, Send Mail Task, FTP Task, and Package Execution Task, to streamline business processes.

Fostered collaboration and maintained strong working relationships with corporate stakeholders to align data solutions with business goals.

Documented development processes, including program logic, coding, corrections, and version control, ensuring maintainability and scalability.

Performed timely and insightful data analysis, generating actionable insights to support business operations and decision-making.

Analyzed and interpreted data trends to identify business challenges and improvement opportunities.

Developed data mapping documentation, outlining the transformation of source files to target structures, ensuring data consistency across systems.

Identified and assessed user requirements, proposing process enhancements to improve operational efficiency.

Generated key departmental performance metrics and ad hoc reports, providing leadership with data-driven insights.

Developed design specifications, test plans, and scripts to align with business requirements and enhance system reliability.

Conducted user acceptance testing (UAT) to validate system functionality, performance, and user satisfaction before deployment.

Perez Medcare Hospital

SQL Developer / Power BI Aug 2017 – Nov 2021

Designed, developed, and optimized complex stored procedures, tables, views, subqueries, triggers, materialized views, and functions to support scalable and efficient application development.

Implemented advanced SQL query techniques, leveraging multiple joins, subqueries, common table expressions

(CTEs), and SQL merge joins to incrementally load dimension and fact tables in data warehousing solutions.

Authored and optimized SQL stored procedures and user-defined functions (UDFs) for seamless integration with SSIS packages and SQL scripts, ensuring efficient ETL processes.

Developed and maintained database architectures and data models, ensuring optimal structure, integrity, and performance for large-scale business applications.

Developed reusable SQL scripts to streamline data wrangling and transformation processes, improving efficiency by 10% and enhancing data processing workflows.

Designed, tested, and optimized T-SQL stored procedures and SQL functions for ETL processing, efficiently staging and transforming data from multiple heterogeneous sources.

Engineered and deployed SSIS packages using SQL Server Data Tools (SSDT) in Visual Studio, ensuring robust and scalable data transformation workflows.

Designed and maintained complex SSIS packages to automate ETL tasks, facilitating seamless data migration across multiple sources, including Excel, flat files, CSV, and OLE DB, to support enterprise reporting needs.

Leveraged SSIS to validate, extract, transform, and load (ETL) data into databases, ensuring high data quality, consistency, and integrity throughout the processing lifecycle.

Developed calculated columns and dynamic measures within Power BI Desktop, enhancing data visualization, KPI tracking, and performance monitoring through advanced DAX expressions. Schlumberger Oilfield Services

Data Analyst Jul 2016 – Jun 2017

Transitioned into a dual-role function handling both backend SQL development and front-end Power BI visualization.

Designed and managed relational database tables, ensuring accurate data structuring, manipulation, and updates within SQL Server environments.

Optimized and troubleshot complex SQL queries and stored procedures, enhancing database performance and resolving query execution inefficiencies.

Performed exploratory data analysis (EDA), identifying trends and patterns to support business intelligence and decision-making.

Developed interactive Power BI dashboards to present key insights, trends, and performance indicators, enabling stakeholders to make data-driven decisions.

Extracted, integrated, and processed data from SQL-based systems, ensuring data quality, accuracy, and completeness.

Formulated advanced SQL queries incorporating analytical and aggregate functions to drive meaningful insights from complex datasets.

Assisted in the development and enhancement of reports and dashboards, ensuring optimal data visualization and user accessibility.

Participated in user acceptance testing (UAT) to validate data integrity, business rule compliance, and system functionality before deployment

Schlumberger Oilfield Services

Regional Operations Controller & Internal Auditor (West Africa) Jul 2012 – Jun 2016

Managed financial accounting and reporting, budgeting, strategic planning, operational control, and audit for multiple regional business units.

Supported sales team in pricing deals, bidding, contract reviews, and evaluation of risk and reward projects.

Developed interactive Power BI dashboards to visualize P&L statements, balance sheet trends, and variance analysis, enabling real-time financial performance monitoring and decision-making.

Prepared annual budgets, quarterly rolling forecasts, implemented and analyzed variances.

Created dynamic DAX measures to perform advanced financial calculations, enhancing variance tracking, KPI analysis, and performance reporting for improved strategic insights.

Implemented advanced DAX calculations to compute key financial metrics such as ROI, contribution growth rates, and financial variances, ensuring accurate performance evaluation and forecasting.

Mentored segments’ supervisors, managers, and key stakeholders on financial principles and intelligence, internal controls, and appreciation of cost/benefit impacts in all business decisions.

Established standardized procedures for asset disposal, vehicle registration, fueling, diesel supplies, and financial control (cash advance, petty cash, and retirement) processes across the geo-market.

Led internal and external audit coordination, ensuring 100% closure of all agreed findings.

Increased profitability by $10 million in two years through data-driven business initiatives.

Reduced Days Sales Outstanding (DSO) to less than 60 days, optimizing cash flow.

Implemented data standardization processes, reducing inconsistencies by 30%. Schlumberger Oilfield Services

Regional Internal Auditor & Business Process Optimization Manager Nov 2010 – Dec 2012

Conducted financial, operational, and compliance audits for multiple business units across the region.

Developed and maintained a risk-based audit plan aligned with corporate strategy.

Created interactive Power BI dashboards to visualize audit findings and financial trends.

Coordinated and Liaised with all business units, area, global internal auditors, and external auditors during special audit of the region – reviewed audit reports and work papers to ensure all observations were supported.

Provided training in financial intelligence, internal controls, and cost-benefit analysis to key stakeholders.

Led the business process optimization projects to ensure full implementation, sustainability, and effective cost savings.

Saved $3 million annually by optimizing diesel consumption through data monitoring.

Identified and mitigated $800,000 in tax exposure, ensuring regulatory compliance. Schlumberger Oilfield Services

Business Process Optimization – Accounts Payable Outsourcing Management May 2007 – Oct 2010

Led the AP BPO project across Nigeria, Ghana, Cameroon, Equatorial Guinea, Ivory Coast, and Chad.

Reviewed current (As Is) Account Payables processes, and implemented best practices for Accounts Payable processing, ensuring improved efficiency and compliance

Introduced the AP BPO project and change management to all stakeholders and met all deliverables within specified timeframe.

Trained all stakeholders on the new invoice reviewing and approval process tool (PRT).

Prepared various KPIs on the AP BPO project performance to all stakeholders.

Reviewed current business processes & identified areas for improvement (Application of LEAN in the processes)

Trained and implemented Changes in the processes

Coordinated the AP BPO business initiative through its various phases across the geo-market.

Coordinated all process documentations requested by Service Providers, and all dependencies achieved as scheduled.

Coordinated Knowledge Transfer schedules with SMEs, and Service Provider’s Successors.

Initiated and coordinated regular meetings on Transition status, raised issues, and made recommendations where necessary.

Regular updates of metrics on BPO performance to Management at Central and Segment levels.

Knowledge transfer successes to internal and external stakeholders including the service providers. Schlumberger Oilfield Services

Intercompany Accountant /Management Accountant May 2005 – Nov 2007

Managed monthly, quarterly, and yearly financial reporting, ensuring accurate post in the general ledger, and compliance.

Prepared monthly, quarterly and yearly Profit and Loss Account as well as Balance Sheet with detailed commentaries on the movement of cost and revenue.

Provided financial insights and cost analysis for operational decision-making.

Supervised and trained newly recruited accountants and finance professionals.

Prepared full year budget for support location, and financial analysis for segment controller and Operation manager.

Reviewed and reconciled Received Not Invoiced (RNI) transactions

Raised, processed, allocated and confirmed all intercompany invoices via Lawson Billing module

Prepared monthly and quarterly intercompany suspense analysis report per EAF(Europe & Africa) reporting guidelines

Obtained and reviewed all documentation and supports relating to suspense items for completeness and validity.

Prepared monthly closing control schedule for all intercompany related accounts and ensure reconciling items between General Ledger and Sub Ledger are analyzed and explained.

Reconciled and controlled the differences between General Ledger and Sub ledger balances for Intercompany accounts.

Provided commentary on Financial Procedure 23 liquidity analysis for intercompany movements

Balance sheet account review, reconciliation and preparation of Associated balance sheet notes

Reconciled and cleared out the general and sub-ledger balance differences to zero. This achievement was celebrated, and I was given a good commendation from EAF

Schlumberger Oilfield Services

Treasury / Payable Accountant Aug 2001 – Apr 2005

Mentored & supervised the payable team to ensure development & progress

Vendor payment and reconciliation of vendors’ statement

Recorded all non -AP interfaced payments (direct debits, credits, cheques, etc)

Funding

Invoice Processing

Prepared bank reconciliation for all foreign bank accounts and resolved all related issues; reviewed of local currency bank reconciliation statements

Supervised the foreign treasury unit.

West African Institute for Financial and Economic Management (WAIFEM) Account Officer Apr 1997 – Jul 2001

Prepared the Monthly budget utilization statement

Prepared the monthly Bank Reconciliation statement

Prepared the monthly Trial Balance.

Prepared the Quarterly Financial Statement.

Recorded accounting data in the various books of the institute

Apportioned interest earned and updated staff provident fund

Updated stock records for control purposes

EDUCATION & PROFESSIONAL AFFILIATIONS

2016 -FRCN Associate Financial Reporting Council of Nigeria

2011: CRA Member, International Academy of Financial Management.

2002: FCA Fellow, Institute of Chartered Accountants of Nigeria

2001: MBA, Finance. Tafawa Balewa University, Bauchi

1996: HND, Accounting Yaba College of Technology, Lagos TRAINING ATTENDED

SQL

Lawson ERP (incl. General Ledger, project accounting, inventory control, cost allocation, asset management, Account Receivable & Account Payable, purchase order & warehousing)

Siebel software overview

Petroleum Exploration and Production

Credit Analysis and Management

ICAN MCPE, 2 every year

Financial Training Level 2 (FT2) (Paris)

Certified Risk Analyst

Effective Communication (USA)

REFEREES

Available upon request.

Contact this candidate