Philip Alcala Email & Phone Number

Montreal, Quebec, Ca

Montreal, Quebec, Ca

• Understand business Analysts specification requirements and produce ETL Jobs into SAS Data Integration Studio;• Understand business needs and implement best strategy regarding loading scheduling, dependencies and deploying process;• Produce developer documentation about ETL process, including SQL scripts and testing results;• Following up production ETL Jobs.• Code tuning using best SQL practices, such new index, query breakdown/breakup.• Create data architectures and physical data models for databases and DW.• Design, develop and implement a DW to Integrate data from multiple sources.• Develop strategies for data acquisition, archive recovery, and database implementation.• Manage data migration/conversion and troubleshooting data processing issues • Developing QA POC environment procedures.• Supporting new peers to have a high production and integrated Dev team.

Wattens, Tyrol, At

• Visit clients to identify and document requirements.• Develop, test, integrate and implement information systems business solutions and Traffic Managements devices.• Analyse Government and Private Bidding documents to propose and pricing technical solution• Based on the customer's requirements, document issues on Traffic Management devices and Software.• Develop technical document translation.• Develop technical and training documentation.• Training on the customer's site.• Develop Prototype plan, test and implement on customer site.• Develop Plan for the nationalization of European products.• Develop a telemetric plan, test and implement on customer site.

• Managed the finances, budget, and pricing of 10 products;• Managed the sales, as an online store (B2C), stores (B2B), and customer relationship;• Coordinated the simultaneously over three different third party;• Developed 10 unique products for the motorcycle segment, increasing the branding exposition and company revenue;• Joined as an expositor in an international motorcycle fair, Salao Duas Rodas, the Biggest motorcycle fair in South America of over 260k+ visitors.

Sao Paulo, Sp, Br

• Sybase & Sybase IQ Database administration (DBA);• Modeled Data and Data Administration (AD) of Data Warehouse, OLAP;• Developed, deployed and maintenance ETL process with PL/SQL codding (Stored Procedures, triggers), SQL, Shell Scripts and Informatica PowerCenter from Oracle, MS SQL Server, XLS,TXT and XML files;• CDM for preventive medicine for all active customers;• Executed Data integration and Database migration from different Systems and O.S.;• Created reports using Business Objects tool and SQL codding;• Install, configure and administer related BI applications (Informatica PowerCenter, Sybase, Power Designer, MS SQL server)• Design, build, test and deploy Oracle Database solutions;• Executed Platform, Storage and Database migration and Data integrity;• Executed Backup & Recover using Sybase ASE Backup and Recovery solution.

Blackfriars, London, Gb

• Developed ETL through Business Object Data Integrator tool for Oracle and SAP;• Created business and development specifications;• Performed systems testing.

Pittsburgh, Pa, Us

• Implemented Oracle E-Business Suite, including costs, payables, receivables, and manufacturing, supporting the defaulting reduction, increasing understanding the product composition and improving the product costing;• Developed ETL, Business Areas and Reports to B.I. and Oracle EBS with Oracle Discoverer and other Oracle`s Solutions;• Developed PL/SQL (Stored Procedures, triggers, sequences, views, etc);• Developed Software Integration with Oracle IAS tools;• Created business and development specifications;• Performed systems testing.

• Management and installation of diverse Oracle 9i products;• Development of corporate portals and System using Oracle Solutions;• Data Mart development using Oracle's solutions;• Demo and prototype workshop to customers;• Active participation in the process of development and implementation of RCM Informática's intranet;

Master Of Business Administration (M.B.A.), Business Intelligence Post Graduation

Bachelor'S Degree, Business Administration And Management, General