About
As a Microsoft certified Power BI Developer, I bring extensive experience and expertise in developing end-to-end data solutions for clients across diverse industries, including Insurance, Energy, Banking, Retail, and Healthcare. With a deep understanding of Power BI, SQL, SSIS, and ETL processes, I am well-equipped to write complex queries, perform data transformations, and ensure error-free data ingestion. My passion for data visualization, keen attention to detail, and collaborative mindset enable me to deliver best-in-class solutions that empower businesses to make informed and data-driven decisions.
I am a proactive and detail-oriented team player dedicated to delivering exceptional results. With a strong focus on compliance and collaboration, coupled with a passion for innovation, I am confident that I can make a significant contribution to any organization seeking a dynamic and results-driven Power BI Developer.
Portfolio
Global Fossil Fuel Energy Production and Consumption (2001- 2019)
Did you know the last decade was the hottest in 125,000 years? Are you aware the world is l... ... More
Employment History
-
Power BI Developer
Colaberry
December 2020 - Present
⦁ Utilized Power Query in Power BI to pivot and un-pivot data model for data cleansing and data
massaging.
⦁ Implemented several DAX functions for various calculations for efficient data visualization in
Power BI.
⦁Designed, developed and deployed Dashboards and Reports that included; parameterized
reports, drill down and drill through reports using SSRS.
⦁Performed requirement analysis and modeling of data in Power BI for real time dashboards and
other reports.
⦁Worked with end-users and team members at all levels for performance improvement and
suggestions.
⦁Created dashboards and interactive visual reports using Power BI. -
Data Analyst
Client - USAA , Employer - IDC Technologies
March 2018 - February 2019
⦁Sourced business requirements, definition and design of data source and data flows.
⦁Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse
by performing different kinds of transformations like lookup transformations, merge joins, fuzzy
look ups, derived columns, conditional splits, data conversion with multiple data flow tasks.
⦁Created SSIS packages using various transformations and tasks like Sequence Containers, Script,
For- loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System,
Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file
source and destination, OLE DB source and destination, excel source and destination etc.
⦁Designed SQL database tables to maintain historical data and error handling.
⦁Improved Performance of the database by creating Clustered and non-clustered Indexes and
optimized the T-SQL statements using SQL profiler. -
BI Developer
Colaberry
March 2019 - November 2020
Created t-SQL scripts, which generated tables, relationships, based on the finalized er-diagram.
Identified the source, destination, staging area per ETL strategy and performed data cleansing and data profiling.
Created SSIS packages for data loading utilizing various task and transformations within the SSIS.
Performed troubleshooting of SSIS packages utilizing error logs, checkpoints, breakpoints, and data viewers.
Developed various SSRS reports for data analysis.
Digital Credentials
-
Power BI Certification
See Credential
-
Data Analytics
See Credential
-
Microsoft Certified: Power BI Data Analyst Associate
See Credential