Alejandro Joven Email & Phone Number

Ottawa, Ontario, Canada

Saint John, New Brunswick, Canada

• Managed and coordinated the work of an analyst to ensure timely and accurate delivery of data and insights.
• Analyze data and provide insights to help stakeholders make informed business decisions. Excel, SQL, and Power BI.
• Design and develop reporting solutions.
• Serve as the subject matter expert for Raiser’s Edge donor database and other Blackbaud solutions.
• Analyzes business procedures/problems to provide solutions for process improvement.

Saint John, New Brunswick, Canada

• Establish a streamlined database architecture and outline a clean-up plan that will ensure data integrity and accurate reporting.
• Integration of other constituent related systems, and other donor support functions to assist in maximizing fundraising and donor stewardship.
• Responsible for creating and maintaining a culture of data quality and integrity by establishing and following quality assurance protocols, processes, documentation, and training.
• Create and run complex queries, reports, mailings and exports to support fundraising and outreach efforts on a routine and as-needed basis. Responsible for weekly, monthly and annual donor database maintenance and.
• Collaborate with fundraising team to track and report on fundraising progress, donor trends and analytics.
• Manage and maintain relationship with database vendor including evaluating contract parameters to ensure maximum use of the system.

Montreal, Canada Area

• Worked closely with the business analysts and business users to understand the business requirements.
• Reviewed the PL/SQL code for the development of new requirements. (SQL Developer)
• Built custom stored procedures and packages to support new enhancement needs.
• Analyzed the business object reports to generate reports using ref cursors that were passed from PL/SQL procedures. (SQL Developer)
• Defined new database structures. (Oracle 18c)
• Developed and implemented procedures and triggers that will ensure the accuracy, completeness, and timeliness of data stored in the database. (SQL Developer)

Bogotá D.C. Area, Colombia

• Discovered, structured, cleaned, enriched, validated, prepared, and published datasets in a format suitable for analytics, modelling, and BI for the needs of the business, ensuring business rule conformity by.
• Collected and analyzed data about purchasing patterns and preferences of consumers buying telecommunications services, applying analytical techniques (Teradata, Power BI).
• Used database management systems to analyze data and perform data mining analysis over millions of records. (SQL – PL-SQL).
• Analyzed geographical data in the marketing and network department. (ArcGIS – AutoCAD)
• Developed, maintained, and distributed scheduled reporting over spreadsheets, dashboards, excel templates to appropriate stakeholders. (Excel – PowerBI – PowerPoint)
• Presented, in the form of storytelling, the insights generated through analytics to all types of audiences. (Power BI – PowerPoint)

Bogotá D.C. Area, Colombia

• Identified and documented the client's needs for the IT Department. (Agile)
• Advised on information systems strategies, policies, management, security, and service provision.
• Conducted independent reviews to assess quality assurance practices, software products and information systems.
• Maintained the systems used for provisioning telecommunications services. (WebLogic-Oracle)
• Upgraded systems with new releases. (Managing third-party developers IBM, INDRA)
• Monitored the system’s performance.

Bogotá D.C. Area, Colombia

• Devising ways to optimize inventory control procedures.
• Maintain inventory records and prepare monthly, quarterly, and yearly reports as necessary.
• Develop and maintain procedures and guidelines to sustain inventory system.
• Utilize various computer programs and software applications; resolve computer issues; create and maintain databases to monitor, track, and generate data and reports.
• Perform a variety of general clerical duties, including data entry and maintaining files and records.
• Maintenance information of the fixed network's capacity and availability in the databases to provide accurate information to develop sales plans and network plans.

Bogotá D.C. Area, Colombia

• Resolve customer problems promptly and accurately.
• Report any repairs and maintenances to the maintenance team.
• Maintain a standard filing system for easy and quick document assess and retrieval.
• Provide technical assistance to office staffs as needed.
• Assist in software and hardware upgrades.
• Add or update workstations for office staffs.

Database Administration, Computer And Information Sciences And Support Services, Database Administrator

Project Management In Telecommunications Engineering, Project Manager In Telecommunications

Telecommunications Engineering, Telecomunicaciones, Telecommunications Engineer

Electronic Technology, Electrical, Electronic And Communications Engineering Technology/Technician, Electronic Technologist