Power Bi Data Science

STANLEY C. ACQUAYE

**************@*****.*** 405-***-**** Oklahoma City, OK, 73179

EDUCATION

UNIVERSITY of OKLAHOMA, USA

MSC Data Science & Analytics in Progress

UNIVERSITY of GHANA, GHANA

BSC Computer Science/Physics Awarded June 2008

PROFESSIONAL EXPERIENCE

JOHNSON CONTROLS, NORMAN November 2023-Present

Database Developer and Power BI Analyst

Programming - primarily with SQL

Sisense Development and Administration

Using Power BI to do Analysis and Reports.

Conducting data conversions

Troubleshooting/Debugging software programs

Performance optimization and troubleshooting

Designing, writing, testing, and debugging SSRS reports

Writing adhoc complex queries as requested for users and management

Investigating new technologies as requested

Assisting in creating technical specifications and test plans

Assisting in writing operational documentation for a non-technical audience

Participate in 2 week Sprint cycles in an Agile environment to maximize team synergy and productivity

SQL Server, MS SQL, MS Server Mgmt Studio and other SQL development tools.

Database Backup and Restore

JIRA board for Agile development

REVENUE MANAGEMENT SOLUTIONS, OKC June 2021-November 2023

Database /Sisense /Tableau Developer

Maintains existing databases and analyze, design, and create of new databases

Excellent Postgres SQL skills for complex data analysis and data quality assurance

Building Cubes in Sisense

7 years’ experience with PostgreSQL schema design / creation and stored procedure creation.

Performance tuning of queries.

SSIS Developments

Examine and identify database structural necessities by evaluating partner team operations, applications, and programming.

Experience in creating aggregates, set, joins, data source filters in Tableau.

Hands on experience in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau desktop to tableau servers

Data Governance Role as testing, and implementing computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. Identify, investigate, and resolve database performance issues, database capacity, and database scalability.

Designed, developed, tested, and maintained Sisense functional reports based on user Requirements.

Involved in creating database objects like tables, views, procedures, triggers, functions using MSSQL to provide definition structure and to maintain data efficiently.

Developed Sisense Visualizations using cross tabs, Heat maps, Box and whisker charts, Scatter Plots and Density Chart.

Collaborated with senior developers to identify key data points necessary for new Data Warehouse environment.

Produced SSAS reports that delivered financial and production data to department supervisors automatically.

scripts was made to restore all foreign keys, preserving differences by identifiers.

3 or more years of experience with T-SQL coding;

3 or more years of experience with MS SQL;

Expertise in SQL;

Experience in DML and principles of database design;

J.A OILFIELD MANUFACTURING INC, Oklahoma City, OK October 2014 – February 2021

Manufacturing Data Technologist

Collaborated with Finance team to understand requirements and automate revaluation of financial products and regulatory reporting boosting productivity by 30 per cent.

Wrote complex PL SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).

Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse

Used Tableau Desktop for blending databases and create interactive views and dashboards.

Worked extensively using PL SQL and Excel to validate the data and use the source data files.

Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2014 Reports Services (SSRS)

Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins,Sub- queries and also used concepts like Explain, Stats, Cast and volatile tables on SQL server.

Wrote SQL queries to Spool Reports from E2 shop Management System for Management from the database system.

Performed Data Analysis on daily, weekly, and monthly basis to ensure that the developed dashboards are up to date, live and sent those into production.

Created action filters, parameters, and calculated sets for preparing worksheets and dashboards using Tableau.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards and developing new KPI for Tableau Scorecards.

Worked with client and team members to comprehend and clarify visualization requirements.

Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.

Reviewing and tuning SQL and PL/SQL code

Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.

Worked on all activities related to the development, implementation, administration, query creations using PL/SQL and support of ETL processes for large scale Data Warehouses using SSIS.

Worked on PL/SQL procedures, created views and wrote custom SQL to feed data into Tableau.

PL/SQL programming, coding Procedures, triggers and functions.

ECOBANK GHANA LTD, Accra, GHANA February 2012 – October 2014

MS SQL Developer / Data Engineer

Worked on resolving performances issues involving slow SQL queries.

Optimized transactional SQL queries; reduced runtimes by up to 80 per cent

Used Pivot tables to create reports that did dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.

Created scheduled generated reports using advanced SQL queries in the Business Activity Monitor (BAM).

Leverage Oracle 10g/11g features to their fullest on a large-scale multi-terabyte system.

Designed multiple scorecards and dashboards using Tableau Desktop.

Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).

Used MS SQL server 2012 as a back-end database to design and develop workbooks, dashboards, global filters page, and complex parameter-based calculations.

Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Involved in creating database objects like views, tables, trigger, functions and procedures using T-SQL to provide definition, structure and to maintain data efficiently.

CERTIFICATION AND AWARDS

Safe Scrum Master

AWS Certified Solutions Architect

Microsoft Certified Professional (MCP)

SQL for Data Analytics

R Programming for Data Analytics

SYSTEM EXPERIENCE

Databases: MS SQL Server 2008/2012/2016/2018, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g

Proficient in Microsoft Office: (Excel, Access, Word, and PowerPoint)

Other Tools: MS SQL Server Integration Services (SSIS), Erwin Data Modeler, Data Mapping, MS Visual Studio, Python 3.6, C++, Visual Studio

Querying Tool SQL Management Studio: 2008/2012/2016/2018, SQL Plus, SQL Developer

Business Intelligence Tools: Tableau Desktop, Tableau Server 2018/19 MicroStrategy, Excel and PowerPivot, MS SQL Server Reporting Services (SSRS)

Contact this candidate