Julio Cesar Navarro Ballesteros

• Developed and optimized database objects (Stored Procedures, Functions, Triggers) in Oracle PL/SQL for a leading banking client.
• Analyzed and defined technical requirements by collaborating with development, QA and business teams to deliver robust solutions.
• Executed unit tests to ensure code quality and data integrity before deployment.
• Managed the deployment (promotions) of DB changes into production environments, ensuring operational continuity.
• Generated detailed technical documentation for application maintenance and scalability.

• Administered the database for the core ECM application, collaborating with teams in Chicago and the US.
• Led performance improvement initiatives and planned for DB growth, ensuring stability and efficiency.
• Coordinated production updates and created administrative documentation for compliance.
• Participated in defining technical solutions, assessing viability and alignment with business needs.

• Developed and optimized complex queries, Stored Procedures, and functions in T-SQL for the Analytics department.
• Led workshops with business users to translate their needs into functional data visualizations.
• Designed and built dashboards and reports in Tableau and Power BI for strategic decision-making.
• Identified key technological dependencies and integrations for the success of analytics projects.

I was assigned to multiple projects working as a Database Developer using PL/SQL (Oracle) and T-SQL (SQL Server) within Agile/Scrum environments. Additionally, I contributed as a Business Analyst, performing requirements gathering and analysis, and developing executive and operational dashboards using Power BI and Tableau to support business decision-making.

• Participated as a key PL/SQL developer on the NEO Jupiter project, building the database back-end.
• Applied data normalization principles to optimize the database structure.
• Developed efficient stored procedures for seamless data retrieval and manipulation, increasing application response time.
• Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
• Increased application stability by troubleshooting and resolving complex PLSQL issues in a timely manner.
• Worked within an Agile methodology, managing small deliverables and promoting changes across development, testing and production environments.

• Administered the company's technology infrastructure, including file servers, applications, and networks.
• Managed inventory and maintenance of administrative computer equipment and provided internal user support.
• Created reports, presentations and other materials for executive staff.