Eric Castillo Email & Phone Number

Makati, National Capital Region, Philippines

• Serves as the Manager for Global Analytics department of Concentrix.• Responsible for the analytics/forecasting support to understand the business and provide technical feasibility and effort estimation.• Analyze the different case studies presented by different directors to enhance productivity and produce ROI for the company.• Responsible for developing the analytics department’s online app using PowerApps.• Coordination with both internal and external clients for both report/s and project/s prioritization, planning and progress.• Responsible for the timely and mannered deliverable of all analytical reports as requested by the different directors across all clients of Concentrix.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Serving as the Tech Lead for developers under IT/SG EDS department of the client (Unionbank). Responsible for business team support to understand the business and provide technical feasibility and effort estimation using Agile methodology. Development and/or support of projects, reports, and dashboards using Informatica BDM, SQL (MS or DBeaver) and MS PowerBI. Responsible for the team’s projects, progress reports and work breakdown for each member. Responsible for the bank’s projects about data, data analyzing and master data management (MDM) – wherein I help create a uniform set of data on customers. Evaluate the skills and recommend the team members for training. Lead the developers to do software architecture design/review. Coordination with clients for the project/s prioritization, planning and progress and conducts meeting with the client base on using project/s specifications. Responsible for assigned projects to be done/created on or before deadline specified/requested by different clients in the bank (Unionbank).

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of MS Sql Server Management and SQL Server Reporting Services jobs used for reports generation being done for the company in order to produce a more accurate and timely result. Development/enhancement of MS Power BI Desktop creating dashboards to use data for data visualizations and business insights. Development/enhancement of SQL Developer queries used for reports generation for the company. Documentation of reports being done and developed for the company. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of MS Sql Server Management and SQL Server Reporting Services jobs used for reports generation being done for the company in order to produce a more accurate and timely result. Development/enhancement of MS Power BI Desktop creating dashboards to use data for data visualizations and business insights. Development/enhancement of SQL Developer queries used for reports generation for the company. Documentation of reports being done and developed for the company. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of MS Sql Server Management and SQL Server Reporting Services jobs used for reports generation being done for the company in order to produce a more accurate and timely result. Development/enhancement of MS Power BI Desktop creating dashboards to use data for data visualizations and business insights. Development/enhancement of SQL Developer queries used for reports generation for the company. Documentation of reports being done and developed for the company. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of MS Sql Server Management and SQL Server Reporting Services jobs used for reports generation being done for the company in order to produce a more accurate and timely result. Development/enhancement of SAP Business Intelligence (Data Services platform) to use data for data visualizations and business insights. Development/enhancement of SQL Developer queries used for reports generation for the company. Documentation of reports being done and developed for both client and company. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of MS Sql Server Management and SQL Server Reporting Services jobs used for reports generation being done for the company in order to produce a more accurate and timely result. Development/enhancement of Qlikview Business Intelligence platform to use data for data visualizations and business insights. Development/enhancement of Oracle SQL Developer queries used for reports generation for the company. Documentation of reports being done and developed for both client and company. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of Data Integrator jobs used for reports being done for the company in order to produce a more accurate and timely result. Generate reports for query and exporting using SAP Business Objects, Oracle (10g)and SQL Report Server systems from the company. Documentation of reports being done and developed for the client. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Development/enhancement of reports being done for the company in order to produce a more accurate and timely results Generate reports for query and exporting using GSIS, SAP Business Objects, COMS, RKEM and SQL Report Server systems from the company. Documentation of reports being done and developed for the client. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Develop backend program to provide daily, weekly and monthly data to client, using SP’s from SQL. Generate reports for query and exporting using Bullant program Documentation of SQL Server 2007 tables, stored procedures, triggers Conduct testing for developed SQL queries by other team in Dubai. Developed batch run program using Stored Procedures in SQL to pull and back up data. Bug / Defect finding on Bullant program used by the client. Conducts meeting with the client base on using program specifications. Technical support to clients for queries and problems encountered.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Develop backend program to provide daily, weekly and monthly data to client, using SP’s from SQL. Creates Macro program in MS Excel for generating reports. Documentation of SQL Server 2007 tables, stored procedures, triggers Conduct testing for other application developed by other team. Developed batch run program using Stored Procedures in SQL to pull and back up data. Develop and maintains the internal Adhoc program use in generating reports by project and by client using VB.Net and SQL. Developed and coded the enhancements on the online registration for Client and vendor information. Provides Technical support and training to vendor and clients. Conducts meeting with the client and vendor base on program specifications.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Develop scripts that was used and read by TSR in the call center operation using ScriptMaker. Develop backend program using Visual FoxPro to pull data from SER database and convert it to dbf format use in reporting and for creating data need by the client. Develop AD-HOC Reports in enables the business leaders to formulate intelligent decisions in implementing their plans & programs. Administer, design, query databases Provides technical support for all users in scripting problems, and troubleshooting and software support and training to users especially using the script and their functions. Exercise good judgment in structuring and organizing work and setting priorities, balancing the interests of internal clients and re-adjusting priorities to respond to support demands. Make sound technical decisions concerning information systems design, architecture, infrastructure and applications. Create custom formulas, function and macro programs for Excel using VBA to automate quality check on data and data cleansing before uploading to the database Create programs on raw data processing that migrate txt, csv, and excel raw data and transform it using Trained end-users with new and existing systems. Develop scripts that are used and read by TSR in the call center operation using ScriptMaker. Manage the workflow and supervised the document control team for data updates into the system.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Make Telemarketing calls (outbound) for the company

Manila, National Capital Region, Philippines

Roles and Responsibilities: Handles clerical work with technical encoding skills and maintenance of Sybase Dbase for Pre-paid Accounts of the company. Assures client satisfaction (pre-paid subscribers) by providing accurate solutions to each of their concerns regarding the consumed balances of their mobile phones.

Manila, National Capital Region, Philippines

Roles and Responsibilities: Acts as a part-time faculty member who teaches Microsoft Applications (MS Word, MS Excel and MS Powerpoint).

Manila, National Capital Region, Philippines

Roles and Responsibilities: Clerical works such as maintenance and preparation of files/documents used by the company. Technical knowledge in Microsoft Applications.