Power Bi Ms Sql

Broad technology experience delivering high quality, customer focused business solutions in BI analytics and data management. Fifteen years of experience with reporting and extensive knowledge of Power BI, SAP BusinessObjects, Crystal Reports and SQL development.

Professional Experience Summary

Pragmatic Marketing Certified - Level Two

CompTIA SecurityPlus+ Certified CE (Valid until 2024).

Experience in Oil and Gas production environment visual analytics, working to design, develop a variety of reports, ETL jobs and working with ETL teams, developing Data Architecture to aid in self-service analytics and maintaining dashboards, reports, ETL jobs and Power Automate flows.

Designed Visualizations in multiple tools while utilizing industry standards and best practices.

Over 3 years working with PowerBI dashboards using PBI Desktop, Report Builder for Paginated reports utilizing multiple datasources such as MS SQL, Oracle, AS 400 and SnowFlake

Built Power Automate flows to capture excel files from emails / sharepoint to be stored in folders and use these files as source for reports.

Developed PBI Reports using Azure SQL DB and applied Row Level Security with Azure AD.

Worked on UI Path project to automate Power Point report development, appending slides and extracting data from excel files to be added to PPTX.

Used UI Path RPA for accessing, updating excel reports for internal use.

Developed multiple dataflows from disparate sources.

Developed data sources from disparate sources for reports and dashboards.

Over 10 years of experience Developing and Administering SAP BOBJ.

Over 10 years of SQL development experience on MS SQL2000/2005/2008 and Oracle 9i/10g and over two years of experience on DB2 and Netezza, Azure.

Experience in developing advanced Webi reports, Crystal reports, basic BEx queries, dashboards using Lumira.

Initial configuration, designing, developing scheduling, publishing, and updating reports and universes.

Scheduling and administering BI processes and activities.

Conducted dashboard design sessions, created and managed complex dashboards using Xcelsius and Dashboards 4.0.

Business Intelligence data retrieval from DB2, Netezza, Oracle, MS SQL server, SAP BW 7.3 or flat files.

Excellent skills in developing Dataflow Diagram and UML diagrams such as Use Case diagram, Activity diagrams, Class diagrams and Sequence diagrams.

Conducted requirements gathering, design, construction, and implementation of a reporting environment, including modeling, integration/consolidation of multiple data sources, queries, reports, and perform complex data analysis.

Created Functional Design Documents, Technical Design Documents, Peer Review Documents, QA instructions, Unit Testing Documents.

Fiserv Inc– Stafford, TX March 2021 – Current

Data Analyst

Developed PBI Dashboards for Executives to view project health being developed under Azure DevOps with collaboration from managers and Azure DevOps teams.

Migration of reports from On Prem Oracle Hyperion to Cloud MS Power BI as well as on prem SSRS.

Data analysis for Operations related to financial transactions, money movement as well as in house printing jobs, including quality control reports, predictions, and maintenance forecast for printers.

Designed and developed data model for report development and aggregation and other functions in MS Power BI with dataflows sourcing data from Azure SQL, MS SQL 2015, Oracle, DB2, AS400 and excel and flat files.

Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Configured and scheduled data refreshes in PBI, Report Server as well as MS Power Automate for external publications.

Used Power Automate to streamline tasks for data update, cleansing and other redundant tasks.

Developed Datasets from multiple datasources and used them in dashboards as well as for paginated reports.

Complex DAX formulation used for calculating financial forecasts, waste calculations, date/Calendar calculations and more.

EOG Resources – Houston, TX April 2019 – August 2020

BI Architect (independent Consultant)

Developed BOBJ Universes for self service ad-hoc reporting on Production Application databases.

Worked with DB Architects to design ER diagrams for Universes.

Used table aliases, derived tables, custom contexts to avoid loops.

Maintained, supported, and enhanced the business intelligence data backend, including data warehouses for ProCount oil production software.

Planned and mapped configurations of data architectures, ensuring documentation meets current and forecasted needs.

Collaborated and worked with end users to ensure that data and reports meet their business needs.

Worked with Data Architects and provided technical guidance for design and implementation of data storage and governance systems.

Designed and monitored QA and end-user reporting tools and systems, ensuring reports are accurate and up to date.

Designed and developed Universe for ProCount Database on production systems.

Used the universe to convert SQL queries into WEBi and published them.

Created training documents and gave training to employees on AdHoc report development.

Did a data modeling exercise with ProCount subject matter experts to develop a data warehouse using Materialized Views.

Did requirements gathering exercises and created Technical Documents, started development using Agile methodology.

Worked with Data Architects to develop data warehouse to be used with SAP Universes.

DataCraft Partners – Atlanta, GA July 2018 – April 2019

BI Developer (independent Consultant)

Converted reports from Excel and MS SQL platforms into Webi reports.

Administered users on Tableau and developed dashboards.

Converted SQL queries and added objects to universe if needed.

Trained users on BO usage, report use, prompts and User input Controls.

Developed documents and procedures on Webi report use as well as for development of ad-hoc reports.

Performance tuning by improved universe design and better reports design.

Fiserv – Dublin, OH March 2015 – July 2018

BI Developer

Converted reports from Actuate and Cognos reporting platforms into Webi and Crystal reports.

Basic ETL work using Informatica to provide data files to customers.

Converted SQL queries and added objects to universe if needed.

Trained users on BO usage, report use, prompts and User input Controls.

Successfully completed the conversion of 200 reports into BO within two years with a team of three developers.

Performance tuning by improved universe design and better reports design.

Created forecasting webi reports.

Ergon – Jackson, MS January 2012 – March 2015

BusinessObjects Developer

Lead a team of BA for requirements gathering and then a team of developers to fulfill the requirements.

Conducted requirements gathering sessions with executives, business analysts and Subject Matter Experts.

Involved in all phases of installation and configuration, testing, deployment, and support of BusinessObjects implementation

Responsible for overall front-end BI data and technical architecture in response to functional specifications of initial Go-Live anticipated future needs.

Designed and implemented universes for Webi and Dashboard data feeds.

Used existing BEx queries as data sources for new and improved WEBi reports.

Designed, created and maintained multiple complex dashboards.

Performance tuning by improved universe design and better reports design.

Created and managed BOBJ users and BOBJ roles.

Managed SAP Business Objects backups using Import Wizard and Life Cycle Management Tool

Maintained and managed the schedules.

Implemented and managed the Security Setup for SAP BO contents and its various Applications.

Enabled the Audit Events.

Helped with configuration clusters of BO servers.

Set the Row Level Restrictions to the 25 different departmental accounts based on their profile.

Set the User Access rights (Control & permissions) using the Central Management Console.

Educational Qualifications

May 2006 University of Houston Houston, Texas

Bachelors of Science – Management Information Systems

Member of campus Student Leadership Institute since 2005

Houston Rotary club foreign student exchange group participant.

Contact this candidate