Nagihan Çay

Successfully managing and maintaining a substantial database infrastructure

consisting of over 1000 stored procedures, 600 tables, numerous views, and essential data transfer functions on MS SQL Server for seamless integration between source system databases and the data warehouse, ensuring data accuracy and integrity for the data warehouse.

Contributed to a global data preparation initiative by delivering datasets required across multiple countries.

Conducting comprehensive analysis of business requirements from diverse teams

consisting of 300+ users, and effectively translating them into technical specifications for development

Developing and implementing new reports tailored to meet specific business needs,

rigorously testing them prior to user distribution for acceptance.

Successfully resolving issues pertaining to over 1000 existing reports on SAP

Business Objects (BO) platform to enhance overall efficiency and functionality.

Developing and implementing complex queries to generate views to facilitate

Corporate Business Intelligence (BI) Projects, ensuring data consistency for global

reports

Proactively responding to business team requirements by effectuating necessary changes to existing dashboards or developing new ones.

Successfully executed the migration of 50+ QlikView reports, encompassing multiple interactive dashboards, to Power BI. Resulted in substantial cost savings by

eliminating the need for QlikView licensing and facilitated a seamless integration

with Microsoft products.

Streamlining processes and workflows to optimize team efficiency and productivity.

Established key performance indicators (KPIs) and reporting mechanisms to track

and measure the success of business intelligence initiatives

Collaborated with cross-functional teams to identify business opportunities,

mitigate risks, and drive continuous improvement through data analysis and

reporting.

Demonstrated expertise in maintaining and providing first line support for ERP running on Oracle E-Business Suite, ensuring seamless operations within the country Collaborated with 3rd Party application support and internal teams to resolve incidents and investigate problems, facilitating efficient service recovery Assisted in testing system changes, software releases, patches, and fixes to ensure optimal functionality Provided valuable insight on the operational impact of proposed projects, enhancements, and changes resulting from business demands and technical/service shifts from central IT teams Developed comprehensive reports on logistics, sales, customer service, and tax using SAP Business Objects, enhancing data analysis capabilities Monitored Unix environment job performance, promptly liaising with L2 teams to address and rectify system issues Supported and contributed to risk mitigation plans, actively participated in DR testing, and facilitated seamless patching activities with zero unplanned business disruptions Collaborated with the finance team to conduct yearly access security reviews, meticulously validating user privileges and ensuring

Gathered and interpreted business requirements, effectively translating them into precise technical requirements. Liaised with the data warehouse team to facilitate the implementation of new tables and modifications aligned with the technical requirements. Utilized Netezza, Db2, and SAP Business Objects platform to devise intricate SQL queries, consequently generating comprehensive reports for diverse finance teams. Collaborated on executive dashboard initiatives, successfully delivering an impressive collection of 100+ dashboards catered specifically for the Asset-Liability Committee.