Affuenti Bakia

**** ********** **, *****, **, ***74

ac84dj@r.postjobfree.com

385-***-****

PROFESSIONAL SUMMARY

Experience in extracting, transforming and loading of data from various sources like OLEDB, excel, XML and .csv files.

Excellent understanding of relational database concepts, constraints, referential integrity and normalization.

Good experience in writing queries in T-SQL, Stored Procedures, indexes, Triggers, views and CTEs

Excellent in writing queries involving multiple tables, joins and queries to delete duplicates.

Good at creating triggers at different levels of database objects to apply security constraints and indexes for optimization.

Experience optimizing queries, indexes, stored procedures, reports and SSIS packages.

Experience in performance tuning, automation and job scheduling.

Experience with developing reports in SSRS, report management, report delivery and automation.

Experience in resolution of Data mismatch issues in SSIS.

Experience in Extracting, Transforming and Loading (ETL) data from different source into Staging environments and Data warehouses.

Hands on experience in designing different types of reports: tabular, funnel, charts, gauges, graphs, dashboards using SSRS and including functionalities like drill through, drill down, sub reports conditional formatting and KPIs based on client requirements.

Experience in developing reports using Microsoft Power BI.

Good knowledge of data warehouse concepts and terminology.

Thorough knowledge of all phases of Software Development Life Cycle (SDLC), agile methodology, quality procedures and standards while executing projects.

Ability to learn new technology in a short span of time integrating well in any environment and working well under pressure.

Good communication skills, dedicated team player with strong interpersonal skills and the ability to take new roles.

WORK EXPERIENCE

Hilton Worldwide – June 2016 - Present

Employer: I-Ping Solutions

Client: Hilton Worldwide

Role - BI Developer: I was responsible for taking a lead role in the implementation and utilization of Business Intelligence and data visualization tools across different client’s SharePoint platforms. Create HHonors relational database and tables within the database, where all customers signing up for HHonors membership’s information are entered. Created Stored Procedures to get the membership history and records of customers who became HHonors members in a time range.

Responsibilities

Built Business Intelligence and data visualization dashboards using various technologies such

as Microsoft Power BI, and Tableau

Created Data Connection, Report, Document and other custom libraries in SharePoint.

Built custom web part templates to manage assets, funds and portfolios for different clients in

SharePoint.

Developed Management and operation reports using SSRS.

Utilized various modeling techniques such as PowerPivot to design multidimensional models.

Designed Entity Relationship (ER) Diagrams to proposed Database.

Carried out any miscellaneous BI duties as assigned by Solution Architect.

Maintained existing database and BI systems.

Worked closely with key customers to troubleshoot and resolve data and report related

Issues.

Leveraged key performance indicators to maximize profitability and performance.

Environment: MS SQL Server2012,2014, 2017, Tableau, Power BI, SQL Server Profiler, Visual Studio 2017, SQL Analyzer and SQL Server Agent.

Kennecott Utah Copper (RIO TINTO) - May 2012 - June 2016

Employer: Kennecott Utah Copper

Client: Kennecott Utah Copper, Magna, UT, 84044

Role: Database Analyst: Used data from databases to create reports for management, which carried visuals on the company’s sales’ performance, forecasts, trends, and portfolio dynamics. Use of joins and Sql operators to combine customer and production records from the various tables within the database to know what transactions were carried out at what particular time and date.

Responsibilities

Created packages in SSIS to load data from different sources to staging tables transforming this data and loading in to an ODS.

Actively engaged in client meetings in requirement gathering and development updates.

Wrote views, stored procedures, CTEs and functions which I used extensively in the development process.

Actively engaged with other team members to gather requirements, design, code, debug, document, implement and maintain various database objects.

Extensively used joins and sub queries for complex queries involving multiple tables from different databases.

Performed operations to optimize and trouble shoot packages, queries, stored procedures, indexes and reports.

Analyzed meaningful use report requirements and developed the reports using visual studio.

Developed parameterized report, sub reports, tabular, drill through reports and dash boards using matrices, gauges, charts, maps to show patient demographic details, patient drug details, patient visit, patient referral location and patient appointment productivity.

Scheduled reports based on day to day and sent them through email in required format (excel, PDF).

Managed day to day activities to ensure the completion of deliverables on time by providing a weekly status report on progress made.

Education

Bachelor of Science degree in Mathematics( minor in computer science)

University of Dschang, Cameroon

Bachelor of Science degree in Industrial Chemistry

University of Jos, Nigeria – January 2001 - December 2005

Hobbies

Hiking, reading, football.

References

Upon request.

Contact this candidate