Name: Lightness Cartier

Email: ad3uj9@r.postjobfree.com

Title: Power BI Developer

Phone.no: +1-470-***-****

Location: Suwanee, GA 30022

SUMMARY:

As a seasoned Power BI and BI Intelligence Developer, I have demonstrated expertise in designing, developing, and optimizing data solutions to drive business intelligence and decision-making. Proficient in Microsoft Power Platform, including Power BI, Power Apps, and Power Automate.

My proficiency in T-SQL, SSIS, Power BI, and Oracle databases has enabled me to efficiently handle data processing, ensuring high-quality data handling and analysis. I have successfully developed and optimized ETL processes, implemented complex query techniques, and crafted dynamic, high-performance visualizations and dashboards that provide actionable insights. My work includes rigorous data quality checks, security standards implementation, and the creation of scalable data models, significantly enhancing operational efficiency and data integrity. Additionally, I have a strong track record of collaborating with cross-functional teams, managing projects to meet strategic goals, and training users on new functionalities, further demonstrating my commitment to excellence and innovation in the field of business intelligence.

TECHNICAL SKILLS:

Business Intelligence and Analytics: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Tableau, Qlik, Azure Analysis Services, and Azure Data Factory, SQL programming, Data modeling, and Analysis. PL

Programming Languages: C, C++, Python

Database Management Systems: Microsoft Access, MySQL, SQL Server 2012/2014/2018, SQL, T-SQL,Azure, PL/SQL, (Power Query Language)

Operating Systems: Windows XP/7/8/10, UNIX, macOS X

Software Development Methodologies: Agile, Waterfall, RAD (Rapid Application Development)

Issue Tracking and Project Management: JIRA, Redmine, Team Forge, ServiceNow, Team Foundation

Web Development: HTML 5/HTML, CSS3, CSS2, Bootstrap 3, JSON, XML

Integrated Development Environments (IDEs) and Text Editors: Toad, SQL Developer, Git, Sublime Text, Notepad++, Eclipse, HP Quality Centre 11, Green Hat Tester, Soap UI Tool, Visual Studio

Modeling and Documentation: MS Office Suite, Microsoft Visio,

Additional Tools and Concepts: MS Office Suite, Salesforce.com, Excel, Data Warehouses, Metadata Management, Dimensional Modeling, Data Marts

WORK EXPERIENCE:

HEALTH NETWORK ONE, Fort Lauderdale, Florida

Power BI Developer 2021 - PRESENT

Responsibilities:

Designed and implemented ETL processes using SQL Server Integration Services (SSIS) to optimize data warehouse loading, facilitating efficient dashboard reporting.

Conducted thorough code reviews to uphold company standards, guaranteeing the delivery of high-quality solutions.

Defined and monitored Key Performance Indicators (KPIs) to analyze and derive strategic insights for business growth and performance optimization.

Automated the generation of reports in formats such as PDF and Excel, significantly improving operational efficiency.

Crafted and maintained visual reports, dashboards, and KPI scorecards with Power BI, enabling data-driven decision-making.

Implemented advanced data modeling techniques to address complex business challenges and improve operational efficiency.

Managed Power BI service requests, report solutions, and administrative duties, ensuring smooth and continuous operations.

Utilized QlikView for the development of interactive reports and dashboards, providing critical business insights.

Collaborated with cross-functional teams to identify and address business challenges, translating client requirements into effective database solutions.

Employed Power Query for data transformation, merging, appending, and implementing complex query techniques including multi-valued and cascading parameters in MDX.

Applied various context types in Power BI Desktop, such as Row, Filter, and Query contexts, and conducted data transformations with Power Query (Pivoting, Unpivoting, and Splitting).

Enhanced data source efficiency through Query Folding in Power Query, optimized data visualization with SSRS, and defined report layouts.

Developed complex SSAS cubes, integrating multiple fact measure groups and dimensions, and utilized DAX for measures, calculated columns, and time series analysis.

Published comprehensive reports and dashboards to Power BI Service, ensuring data is current with Power BI Gateways.

Implemented advanced data modeling techniques to address complex business challenges and improve operational efficiency.

Created visual hierarchies in reports using diverse chart types, and managed large data volumes with weekly partitions in SSAS models.

Demonstrated expertise in data modeling, supporting business process requirements and facilitating detailed and summary report generation for strategic analysis.

AMERICOLLECT, Dallas, TX

BI Intelligence Developer 2019 - 2020

Responsibilities:

Developed, optimized, and deployed T-SQL stored procedures and functions, significantly enhancing data handling and processing efficiency.

Built and maintained dynamic reporting solutions to meet evolving business requirements, ensuring stakeholder satisfaction through timely and relevant deliverables.

Optimized SQL query performance and developed advanced queries for superior data retrieval and analysis.

Designed and implemented ETL processes and tools, enabling effective data integration and facilitating in-depth data insights for decision-making.

Utilized Power BI Desktop for creating high-performance data visualizations and narratives, improving data comprehension and storytelling.

Managed project timelines, monitored risks, and maintained transparent communication with stakeholders to ensure project alignment and visibility.

Conducted rigorous data quality checks and collaborated with teams to develop scalable data models, enhancing data system efficiency and reliability.

Implemented robust security measures for BI solutions, safeguarding data integrity and compliance with industry standards.

Executed comprehensive data validation and cleaning using DAX, ensuring accuracy and quality of analytics.

Led the design and development of complex ETL architectures, transforming diverse data sources into coherent data warehouses.

Documented requirements and managed product backlogs to prioritize tasks and ensure timely project completion.

Designed user interfaces and navigation flows for enhanced reporting functionalities, improving user experience and system usability.

Provided extensive training to user groups on new system features, enhancing user adoption and proficiency.

Expertly designed SSIS packages for efficient data migration from various sources to SQL Server databases.

Demonstrated proficiency in utilizing Oracle databases and writing complex SQL and Oracle queries for data manipulation and retrieval.

Developed and managed SSRS and SSIS projects, creating intricate reports with cascaded parameters, interactive charts, and gauges.

Designed complex SSRS reports and embedded RDLC reports in ASP.NET, utilizing C# within SSIS for runtime value capture and file operations.

Collaborated closely with business stakeholders and end-users, addressing process-related issues and optimizing business operations.

EDUCATION

Bachelor of Science (B.S.) in public Administration at the University Of Dodoma

Contact this candidate