Michael Angelo Rejano

Michael Angelo Rejano Contact Number:-- PROFESSIONAL SKILLS Data cleaning, validation, and organization Complex formulas (VLOOKUP/XLOOKUP, INDEXMATCH, IF, SUMIFS, Pivot Tables) Dashboard creation and reporting automation Data visualization using charts and graphs Process automation using Excel VBA Macro creation for data processing, reporting, and workflow optimization Application development and maintenance Data extraction, transformation, and analysis Writing and executing SQL queries WORK EXPERIENCE .NET Developer / Business Analyst Radix - China bank May 2022 - May 2024 Created custom transaction-based modules Built and modified reports based on client requests Maintained Debit Card Management System functions Supported ATM Switch system operations Debugged and fixed production issues Performed log extraction and analysis Handled data queries and investigation requests Gather, analyze, and document business requirements Coordinate with stakeholders and technical teams Assist in preparing functional specifications and reports Support testing and validation of system enhancements Help improve existing business processes and workflows Software Engineering Analyst Nov 2015 - Aug 2020 ACCENTURE INC. Developed and maintained Excel VBA macros Automated repetitive reporting tasks Built user-friendly Excel tools and forms Processed and cleaned large datasets Generated automated reports and dashboards Reduced manual work and human errors Optimized Excel performance and file size Integrated Excel with CSV and text files Validated and standardized data formats SOFTWARE EXPERIENCE Debugged and enhanced existing macros Improved workflow efficiency and turnaround time Microsoft Excel, Google Sheets, Excel VBA (Visual Basic for Applications), .NET Framework, C#, VB.NET, SQL, CSV & Structured Data Handling, Reporting & Dashboard Tools, Windows OS & Office Suite, Putty, WinSCP, Adobe Photoshop, Shell Scripting, NCR/JIRA Ticketing Tool, ServiceNow, Monday.com Software Developer Aug 2014 - Oct 2015 EVOTECH Designed and maintained database-driven systems Created and customized Crystal Reports for business needs Built dynamic reports for transactions, summaries, and analytics Gathered requirements through client meetings and discussions Translated client needs into functional system features Developed UI, business logic, and database integration Optimized report performance and accuracy Debugged and enhanced existing applications(using VB6) Deployed updates and supported production systems Ensured data integrity and system reliability Provided technical explanations and progress updates to clients EDUCATION BULACAN STATE UNIVERSITY(MENESES CAMPUS) BS Information Technology(College Grad)