Employment History 

• SQL/ Power BI Developer

  Colaberry, Inc.

  May 2014 - August 2022

  • Work with business teams to gain a rich understanding of their business, analytical and reporting needs to design, build, and deploy business intelligence reports and solutions.
  • Involved in the complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
  • Translate business needs to technical specifications by writing Business Requirements Documentation (BRD), Test Plans, Proof of Concepts in a Scrum centered environment.
  • Experience with Power BI components (Power BI Service, Power Pivot, Power Query, Power View, Power BI Desktop, Power BI Map).
  • Experience designing graphs and charts that easily aid the understanding of business impact, correlations, or discrepancies within SSRS and Power BI (Desktop, Service and Mobile).
  • Develop dashboard reports using SSRS report model and ad-hoc reporting using Report Builder.
  • Experienced with various DAX functions that include, but not limited to, date and time, time-intelligence, filter, logical, math and trig, text, etc., and developing complex calculated columns and measures.
  • Develop reports in Power BI Desktop and deploy to both Power BI Report Server and Power BI Service.
  • Build and maintain the self-service BI applications that will interoperate with data warehouses and other BI solutions.
  • Develop complex SQL queries like stored procedures, common table expressions (CTEs), user-defined functions (UDF), temporary tables, views, joins and nested subqueries to support Power BI and SSRS reports.
  • Develop, maintain, and schedule drill-through and drill-down reports, parameterized reports, linked reports, sub reports, matrix reports, and chart reports using SQL Server Reporting Services (SSRS).
  • Experience implementing security guidelines by using filters and row-level security.
  • Locate tables using database diagrams in MS SQL Server to establish relationships between multiple tables using Foreign and Primary keys.
  • Develop complex stored procedures utilizing transactions, merge statements and dynamic T-SQL to perform various tasks including, but not limited to, index maintenance, data profiling, metadata searches and loading the data mart.
  • Design and develop various SSIS packages to import data from multiple sources like OLEDB, Excel, XML, flat files, and .csv files to consolidate them into staging tables.
  • Experience creating complex ETL solutions using proper Control and Data Flow elements with error handling along with scheduling and deploying SSIS Packages.
  • Responsible for providing oral and written feedback interpreting the results of the reports.
  • Update and track tasks in various project management tools dependent on respective client like Project Planner, JIRA, Basecamp, Asana, DevOps, and Kanban boards.
  • Assist in the requirements gathering for business questions of management and staff and translated those technical specifications into user-friendly dashboards and reports to enable data-driven decision making.
  • Develop complex reports and dashboards and support the existing reports using SSRS and Power BI based on the end-user requirements.
  • Design, build, test, and debug SSRS and Power BI report solutions based upon specified requirements and deploy to Power BI Service or Report Server.
  • Develop interactive dashboards and reports, focusing on user experience, that clearly outline business KPIs through various visualizations using SSRS and Power BI visualization tools.
  • Implement tasks (both personal and On-Premises) to schedule Power BI Gateway and Dashboard refresh at regular intervals and appropriate dependencies.
  • Develop SQL queries to validate the data such as checking for duplicates, null values, truncated values and ensuring correct data aggregations.
  • Create database objects using stored procedures, views, joins, system functions, indexes, and merge statements to run insert, update or delete operations using T-SQL.

• Power BI Developer and Trainer

  Peraton

  April 2021 - January 2022

  • • Served as a member of the business intelligence/data warehouse team, during acquisitions that increased staff from 6k to 30k, focusing on harmonization efforts to both integrate and migrate all data processes.
  • Lead requirements meetings and collaborate with DBA in data mapping sessions with stakeholders to understand business needs to translate into Business Requirements Document (BRD) for stakeholder approval; develop and implement advanced analytics and reporting that drive better and faster decision making, provide insight and analysis and identify opportunities for improvement.
  • Perform detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
  • Interact effectively with business partners to understand business requirements and assist in creation of, updating and maintaining technical requirements.
  • Participate in architecture, technical design, and product implementation discussions.
  • Designed and documented the entire architecture of Power BI in new GCC High instance.
  • Create and modify tables, stored procedures, views, indexes, UDFs, CTEs, and triggers as required.
  • Assist in various types of stages of the SDLC processes including analysis, design, development, testing and implementation.
  • Create dashboards and analytical reports by implementing several DAX functions for various fact calculations to ensure efficient data visualizations in Power BI.
  • Develop interactive and user-friendly visualizations in PBI Desktop, Service and Azure Synapse for various reports and dashboards based on BRD.
  • Installed and configured enterprise gateways in Power BI Service to manage scheduling refresh automation requests.
  • Designed and developed SharePoint team site for Power BI training and support to drive internal adoption of Power BI for all analytical and reporting needs.
  • Led open Power BI training sessions via MS Teams, on a weekly basis, to provide additional support and influence self-service BI to business users across all experience levels (beginner-advanced).
  • Provide desktop support to project stakeholders to assist with Power BI troubleshooting, navigation, etc.
  • Design, develop and implement BI solutions for management dashboards, financial reporting, and various business operations leveraging AI and ML in Power BI.
  • Create and maintain workspaces and content packs for business users to view and collaborate on reports and dashboards while implementing Row Level Security (RLS) as defined by workspace owner.
  • Publish, schedule, and maintain all Power BI content as applicable. Combine related reports and dashboards and make them available in mobile apps for stakeholders to easily view key metrics and collaborate with project team members.