• Create and optimize Power BI semantic models using various data sources (star schema)• Implement features such as Incremental Refresh, Manage Aggregations, Calculation Groups, Field Parameters, and Row Level Security• Create and optimize Power Query ETL (dataflows and Power BI Desktop)• Create complex DAX for various metrics• Develop complex custom SQL and Snowflake views• Develop Power BI reports that utilize golden models with interactive or auto filtering• Develop… Show more • Create and optimize Power BI semantic models using various data sources (star schema)• Implement features such as Incremental Refresh, Manage Aggregations, Calculation Groups, Field Parameters, and Row Level Security• Create and optimize Power Query ETL (dataflows and Power BI Desktop)• Create complex DAX for various metrics• Develop complex custom SQL and Snowflake views• Develop Power BI reports that utilize golden models with interactive or auto filtering• Develop Power BI reports that identify issues and generate alerts• Train staff in Power BI, Excel, and best practices• Mentor junior team members and lead Quality Assurance• Automate franchisee financial reporting using Excel VBA and Power BI• Conduct requirements-gathering sessions and document requirements/designs Show less

• Developed Power BI reports/dashboards, focusing on financial and operational KPIs for construction projects• Developed Power Query ETL, transformed and cleansed data• Created data models in Power BI• Created measures and calculated tables using DAX• Conducted requirements-gathering sessions and documented requirements• Created data mapping for a variety of data sources, and a data dictionary

• Developed Power BI reports/dashboards, focusing on financial and operational KPIs for both established and emerging markets• Developed Power Query ETL, transformed and cleansed data• Created data models in Power BI• Created measures and calculated tables using DAX• Developed SQL queries for data analysis and validation

• Consulted with clients to understand business needs and recommend solutions• Developed reports/dashboards using Power BI and Business Objects• Designed and supported SQL Server databases, including database administration• Developed T-SQL scripts (including DDL and DML) and database objects• Acted as liaison between IT and business users• Configured and supported business intelligence platforms• Performed testing and quality assurance• Performed troubleshooting and… Show more • Consulted with clients to understand business needs and recommend solutions• Developed reports/dashboards using Power BI and Business Objects• Designed and supported SQL Server databases, including database administration• Developed T-SQL scripts (including DDL and DML) and database objects• Acted as liaison between IT and business users• Configured and supported business intelligence platforms• Performed testing and quality assurance• Performed troubleshooting and provided timely resolutions Show less

• Supported and optimized the Business Objects 4.2 reporting environment• Developed SQL queries for SQL Server and DB2• Compiled the master report list and developed a process for dynamically generating the master report list• Identified and collected report metadata

• Contributed to the design and implementation of a new data warehouse (Microsoft platform)• Supported the data warehouse and ODS (data ingestion, enhancements, and production support)• Developed T-SQL and PL/SQL scripts (including DDL and DML) and database objects• Developed reports/dashboards using Business Objects, Tableau, Power BI, and SSRS• Managed quality assurance, including developing test cases and resolving defects• Managed upgrade to Business Objects… Show more • Contributed to the design and implementation of a new data warehouse (Microsoft platform)• Supported the data warehouse and ODS (data ingestion, enhancements, and production support)• Developed T-SQL and PL/SQL scripts (including DDL and DML) and database objects• Developed reports/dashboards using Business Objects, Tableau, Power BI, and SSRS• Managed quality assurance, including developing test cases and resolving defects• Managed upgrade to Business Objects 4.1• Gathered and analyzed business requirements Show less

• Developed reports using SAP Business Objects and Crystal Reports• Developed PL/SQL and ANSI SQL queries• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed reports using SAP Business Objects, Crystal Reports, and PS Query• Developed PL/SQL queries and views• Designed Business Objects universes for both enterprise and ad hoc reporting • Guided the Business Intelligence team in the extraction of PeopleSoft data• Managed the implementation of row-level security in the reporting environment• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed PeopleSoft nVision reports and PL/SQL queries• Developed Visual Basic scripts for complex reporting• Performed data modeling (implemented in PeopleSoft)• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed PeopleSoft nVision reports and PL/SQL queries• Developed Visual Basic scripts for complex reporting• Developed PL/SQL scripts to convert data from PeopleSoft 7.02 to 8.9• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Modified the reporting environment to accommodate a company-wide reorganization• Developed PeopleSoft nVision reports and PL/SQL queries• Developed Visual Basic scripts for complex reporting• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed PeopleSoft nVision reports and PL/SQL queries, including pricing dashboards that provide insight into club profitability• Developed Visual Basic scripts for complex reporting• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed PeopleSoft nVision reports and PL/SQL queries, including labor reports that enable management to understand the labor component of the manufacturing process• Developed Visual Basic scripts for complex reporting• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Developed PeopleSoft nVision reports and PL/SQL queries• Developed Visual Basic scripts for complex reporting• Analyzed and resolved production issues in the reporting environment• Gathered and analyzed business requirements

• Supported PeopleSoft 8.4 GL, nVision, and Query • Developed nVision reports and T-SQL queries for Financials and Projects • Designed ChartFields, trees, allocations, consolidations, combo-edit rules, and timespans • Developed Visual Basic scripts for complex reporting • Created and supported a data warehouse using SQL Server, Visual Basic, and Excel • Developed a change request application using Visual Basic and Access • Developed ETL tools using Visual Basic, Access… Show more • Supported PeopleSoft 8.4 GL, nVision, and Query • Developed nVision reports and T-SQL queries for Financials and Projects • Designed ChartFields, trees, allocations, consolidations, combo-edit rules, and timespans • Developed Visual Basic scripts for complex reporting • Created and supported a data warehouse using SQL Server, Visual Basic, and Excel • Developed a change request application using Visual Basic and Access • Developed ETL tools using Visual Basic, Access, and Excel • Converted legacy systems to PeopleSoft and performed data integrity audits • Gathered and analyzed business requirements• Drafted training materials and trained users in GL, nVision, Query, and Tree Manager Show less

• Architected and developed a data warehouse and reporting solution encompassing numerous acquisitions with disparate data structures and multiple currencies• Developed ETL scripts using SQL and Visual Basic that standardize financial data, generate and distribute a full spectrum of reports, and create data files that feed other systems• Gathered and analyzed business requirements