Sandra García Rojas Email & Phone Number

Washington Dc-Baltimore Area

- Provide analytical solutions for decision-making at strategic and operational levels, which allow for better implementation and monitoring of the Bank’s portfolio. - Build innovative and effective dashboards for management reporting, using Tableau, Power BI with DAX, and Power Query.- Standardize, streamline, and automate reporting to server internal clients and the Board.- Perform data analysis that describes changes over time and recognizes trends to support the preparation of portfolio reports like the Quarterly Business Review and Annual Reports.- Collaborate with cross-functional teams to identify business opportunities and propose to better mine and analyze data.- Contribute to the data governance framework by ensuring the Bank’s operations data quality, champion data governance, and promoting the correct usage of data. - Partner and collaborate with the Information Technology Department to develop data management and business intelligence solutions.- Undertake data collection, cleaning, and quality assurance for International Reporting such as the Common Reporting Standard (CRS) for the OECD, and the Aid Transparency Index.- Advice on the use of the latest trends and techniques in data science and apply them to the bank’s data platforms, processes, and analytics.

Washington D.C. Metro Area

- Gathered and analyzed business requirements to develop interactive dashboards using Tableau to provide insights related to grants management and project monitoring. - Designed and implemented advanced data processing solutions using artificial intelligence (AI) techniques, such as leveraging Natural Language Processing (NLP) with Python to analyze unstructured data on technical cooperation projects and identify key topics. - Managed and processed operational and transactional data using SQL to create monthly historical datasets about the Bank’s operations. - Ensured data quality and collaborated with the Data Warehouse team to implement changes to maintain data accuracy and consistency. - Created ad hoc reports and automated the production of monthly, quarterly, and annual reports on the grant financing portfolio. - Designed, and developed tools to disseminate data, like a Reports Portal about trust fund-financed operations for Bank-wide data consumption. - Implemented and maintained data assets like the Donors Portal in Salesforce, and the Trust Funds External Website.

Washington Dc, Usa

- Gathered user requirements for the new Document Management System (DMS) and analyzed the integration with other tools and applications.- Created proofs of concept and demo version of the DMS for the IDB Group, using SharePoint 2013 and SharePoint Online O365.- Designed information architecture of the DMS, including the navigation, metadata, definition of sites, subsites, document libraries, and the search experience.- Worked closely with the Records Department to implement the bank’s taxonomy using term store management and applying content types to document libraries to facilitate navigation and filtering capabilities. - Configured permissions and roles for each element of the architecture to ensure data security and access control.

Lima, Peru

- Assessed business requirements, processes, and objectives with different stakeholders. - Designed solution architecture by selecting the appropriate technology stack, defining technical specifications, and outlining system design. - Developed database schema in SQL Server, creating tables, views, stored procedures, and optimizing database performance. - Designed and implemented ETL to migrate data from Excel and MS Access to SQL Server, using SQL Server Integration Services (SSIS). - Designed and developed a web application to allow Spanish NGOs and the Public Administration to register their projects, using ASP.NET, VB.NET, and SQL Server 2012. - Developed a web application using ASP.NET, VB.NET, and SQL Server 2012 to enable registration of projects by Spanish NGOs, companies, and the Public Administration. - Developed a module for monitoring the execution of the project portfolio using SQL Server 2012 Reporting Services, with statistic reports and graphs. - Created online tutorials using Adobe Captivate and provided end-user training sessions.

New York, Usa

- Designed, developed, and implemented a multi-language reporting tool on military expenditures, for the United Nations country members, using ASP.NET, VB.NET, SQL Server 2012, Reporting Services, and cloud services such as Amazon EC2, and S3. - Designed Intranet architecture for the Conventional Arms Division that unified the United Nations databases on the subject, providing a streamlined platform for data and information sharing.

Lima, Peru

- Analyzed data sources from the Public Prosecutor’s Office, Judicial Branch, Public Defender’s Office, and the National Police Force, and identified integration challenges. - Developed a comprehensive integration plan that includes data mapping, quality, and transformation. - Collaborated with stakeholders to align the integration plan with the definition of performance indicators to monitor the implementation of the Criminal Procedure Code. - Developed a monitoring system to evaluate the operation of the Criminal Procedure Reform.

Lima, Peru

- Designed and developed a custom software solution enabling the National Superintendence for the Control of Security Services to register firearms, ammunition, and explosives, and manage their stockpile facilities, using ASP.NET and VB.NET for front-end development, SQL Server 2000 for back-end data management, and Reporting Services for generating detailed reports.- Developed and presented a demo version of the software solution during a mission to Uruguay and Paraguay, showcasing its features and capabilities. - Gathered and analyzed data requirements for the Firearms Protocol Information System and developed a proof-of-concept for UNODC Brazil.

Master'S Degree, International Cooperation And Project Management

Associate'S Degree, Design And Management Of Social Development Projects

Bachelor'S Degree, Systems Engineer

Graduated With Honors