Odayne Smith Email & Phone Number

Greater Boston Area

Research, test and evaluate commercial and other software products with the primary objective of providing optimal solution, improving my skillset and knowledge base as well as keeping up-to-date with the latest technologies. Offer consultancy to potential users of a variety software products. Offer voluntary service in mentoring and tutoring secondary level students and adults.Informatica PowerCenter 8.6.0Successfully tested and deployed Informatica PowerCenter Server and Client on a standalone computer. Explored and established ETL processes, which utilize workflows comprising of mappings used to transform heterogeneous sources inclusive of Excel, XML and flat files into database source tables, transform data using java, lookup and other native Informatica transformation functions to produce database fact/target tables and flat files. CloverETL, Pentaho DI and Jasper ETLSuccessfully explored and created simple ETL processes in CloverETL, Pentaho DI and Jasper ETL software. In all three software, my research enabled me to create processes that incorporated simple source to target mapping and transformation of data.Mentorship and Community DevelopmentI use my spare time to tutor and assist secondary level students in Mathematics and Information Technology. I also fostered the improvement in literacy for adults who were not adept in reading and those that were not technologically inclined.

Kingston, Jamaica, W.I.

Responsible for extracting, transforming and loading warehouse data from heterogeneous sources spanning 32 markets in the Caribbean and Latin America. Developed and maintained KPIs and Data-Marts to support reporting and dashboard requisites of various business units in each market. Data Services XI 4.1 SAP ETLDeployed, administered and upgraded Data Services version 3.2 to 4.1 for concurrent data processing on Windows and Linux platforms.Oracle 10gR2/11gR2Created PL/SQL packages and procedures to perform ETL operation on heterogeneous data sources. This included normalizing and de-normalizing dimension and fact tables to support reporting.BusinessObjects Enterprise XI 3.1Used reporting platform to create complex star/snowflakes schema to support senior management’s business requirements. Oracle ExadataIntegral in migrating the warehouse to Exadata platform. A key milestone which gave me a wealth of knowledge in RAC architecture and environment, and rewriting queries to leverage speed and power of Exadata to deliver end user business requirement and adhering to SLAs. Generic Unix Shell Scripts Remodeled scripts to produce centralized generic versions which accepts control files as parameter with configuration of feed to extract.AutomationCreated check to detect missing files and alert team via text message and email. Automate XML invoice extract to execute monthly for each market based on market’s billing cycle.Product KPI Data MartCreated product data mart structures to configure and track all products in the market. Improve reporting by eliminating unconfigured revenue streams and making data available in an hour down from previous 4 hour process.Knowledge TransferDesigned documentation and uniform process templates to ease the learning curve particularly for new team members. Provided weekly project updates, shared research discovery to aid team development, mentored inexperience team members and delegate responsibility as they matured.

Bsc, Bachelor Of Science, Computing And Information Technology: Enterprise Computing

Activities and Societies: • Member of School of Computing & Information Technology Football Team (University of Technology, Jamaica).

Certification, Business Communication

High School Diploma, Science