We provide IT Staff Augmentation Services!

Odi / Informatica Power Center Subject Matter Expert (sme)/developer Resume

2.00/5 (Submit Your Rating)

Miami, FL

SUMMARY:

  • An Information Technology, Business Intelligence professional with extensive experience in Relational Database SQL development, ETL/ELT Tool Development, and Administration, Advanced Data Analytics and Data Migration, Innovative and Holistic Problem Solving, Technical/Team Leadership, Mentoring and Training, Project Management.
  • Proficient in data mining/predictive modeling, advanced data analytics, creative/agile design, innovative and holistic problem solving, technical and team leadership, mentoring & team building, project management.
  • Exemplary communication, presentation & customer/client relationship development skills.

SKILLS:

  • ETL / ELT development
  • INFORMATICA PowerCenter
  • Oracle Data Integrator
  • SQL Expert
  • PL/SQL Expert
  • Team Management/Leadership
  • Teradata Assistant
  • Teradata SQL
  • Teradata Utilities (BTEQ, MLoad
  • UNIX/LINUX (Shell Scripting)

WORK EXPERIENCE:

ODI / Informatica Power Center Subject Matter Expert (SME)/Developer

Confidential, Miami, FL

Responsibilities:

  • Tasked with transforming IDS, SALESFORCE, Unstructured Data file(s) (UDT), and other Cloud sources into via Informatica Power Center, and ODI into the data warehouse.

Senior ETL Developer

Confidential, Rochester, NY

Responsibilities:

  • Tasked with the development and implementation of a Student Data Warehouse.
  • Developed ODI ETL processes to source data from Workday Cloud ERP Systems via XML exports integrate into relational Student Data Warehouse.
  • Boomi integration tool was used to source Workday source data and deliver XML file(s) into staging environment. Completed Boomi Essentials training.
  • Developed complex bridge table(s) for multi - instance dimensions.
  • Also tasked with training University technical staff to migrate OWB processes into ODI.
  • Cognos & Tableau reports were developed for user presentation and analysis.

Senior ODI Specialist

Confidential, Canonsburg, PA

Responsibilities:

  • Primarily tasked as ODI SME to implement ODI 12c as Confidential 's enterprise integration tool. Crown Castles' data is sourced from a JDE platform via CDC and GG into Oracle EXADATA databases.
  • Additional responsibilities included the development and conversion of intermediate and complex PL/SQL code into ODI processes.
  • Further, train PL/SQL developers on ODI 12c application and best practices.
  • Implement common SDLC practices.
  • Setting up dynamic and parallel processing.
  • Command line execution of ODI processes via TIDAL Scheduler.
  • Recent projects include development of RestFul Services XML streaming via HCM / Ultipro (Cloud-based HR and Payroll Management System) data targeting Service Now (Dynamic CRM database).

Senior ETL Developer

Confidential, Deerfield Beach, FL

Responsibilities:

  • Tasked with the development of ETL Processes utilizing ODI ETL Tools, also developing and maintaining PL/SQL processes.
  • In addition, interpret and convert existing PHP processes into ODI where appropriate.
  • Task assignments are maintained in JIRA.
  • Record work progress in JIRA. GIT/Bitbucket for source control.
  • Testing and execution of developed SQL processes may be performed in SQLPLUS, as well as ODI as appropriate.

Business Analyst & Senior Oracle Data Integrator 12c Developer

Confidential, New York, NY

Responsibilities:

  • Primarily tasked with the conversion and integration of Legacy Batch processes into ODI (12c).
  • Legacy processes received flat-files from a mainframe system.
  • BAT files were utilized to source and load into Oracle database table(s).
  • Developed the conversion of SQLLDR scripts into ODI utilizing ODI SQLLDR knowledge modules, or other knowledge modules in order to optimize processes.
  • Modified existing SQLLDR knowledge module to using ODI variables to dynamically assign Oracle SID at execution.
  • Developed control table(s) to record and maintain process statistics such as filenames, record counts, etc.
  • These statistics provided value to ensure that data validation through target table(s) were accurate.
  • This provided quality to the presentation layer for COGNOS reporting.
  • Continued to provide value joining the team to assist in the implementation of a single integrated SAP solution.
  • Primarily as a Business Analyst consultant, while the company ramped up the BA team.
  • Then during the development phase re-joined the development team to assist with the ETL development, testing, and implementation.
  • Also, development complex calculations for aggregating monthly reporting. Created VISIO diagrams and detail documentation in Confluence.

Oracle Utilities Analytics, Data Integrator Development and Support

Confidential, Spokane, WA

Responsibilities:

  • Primarily tasked with the support and maintenance of Oracle Utilities Analytics framework via ODI.
  • Golden Gate application was used for real-time data replication.
  • Developed custom interfaces in ODI to correct production issues.
  • Developed data retention routines in ODI to maintain data capacity in ARREARS process.

ODI / Informatica PowerCenter Subject Matter Expert (SME)/Developer

Confidential, Richmond, VA

Responsibilities:

  • Tasked with the ODI Administration of Security - setting up user access and profile maintenance for ODI Suite of tools.
  • Orchestrating ODI schedules, and Scenarios, and ODI Processes.
  • Trouble-shooting process failures with developers.
  • Evaluating error logs and production issues. Involved with system migration efforts. Agent setup (Local, Co-located, J2EE as necessary.
  • Tasked with the migration of INFORMATICA Essbase platform to ODI 11g (SQLServer database).
  • Configured Topology.
  • Designed and re-developed all workflows, worklets, tasks into Packages, Interfaces, etc.
  • Utilized ODI utilities as needed for MAXL script and dtexec execution.
  • Installed collocated agent for dtexec execution.

Oracle Data Integrator Developer

Confidential, Calabasas, CA

Responsibilities:

  • Redeveloped INFORMATICA Workflows in ODI 12c. Installed and implemented SALESFORCE using BristleCone Adapter in ODI.
  • Implemented the following Use cases via ODI. Developed Jython/Python scripts in ODI.
  • Pick up address from table MOVE RLT ROSTER. Concatenated RRaddress1, RRaddress2, RRCity, RRState, RRZip. Called Restful service (SOA) for Address parsing.
  • Create functions to populate additional address fields with the Standardized Address based on a valid verification.
  • Sourced the data from 4 different SQL Server databases into Oracle.
  • Transformed and applied filter conditions.
  • Created functions to standardize commonly used Fields like Phone number, Email, First Name, Last Name that can be used throughout the Enterprise and can be applied to any source data.
  • Extracted incremental data from Source tables and push it to Cloud applications lSALESFORCE using BristleCone Adapter in ODI. Compared data between multiple sources and loaded variances into exception tables for auditing.
  • Expose certain Enterprise data as a Service (SOA).

Senior ODI (SME)

Confidential, Miami, FL

Responsibilities:

  • Tasked with the near real-time Oracle Data Integrator (ODI) development, test, and deployment of Confidential Casino projects. ODI Subject Matter Expert (SME) - Oracle Data Integrator Developer.
  • Initially installed and configured ODI Tools (versions 11g/12c). Configured necessary Topology architecture for relational database (Teradata/Oracle) sources/targets, file sources/targets, etc.. Installed and configured agents. Reversed necessary models. Imported necessary knowledge models.
  • Casino projects included developing/testing/implementing ELT objects to capture marketing related data related to slots/table revenue.
  • The data capture was used for various marketing purpose not limited to profiling and categorizing of Casino guests and their gaming behavior. The marketing data captured and analyzed may result in various gaming customer offerings.
  • In addition, capturing shipboard revenue concurrently from 101 Cruise ships, respectively either in port or during travel into shore-side database.
  • This process would later compare shipboard revenue against shore-side revenue executing various pre-defined queries.
  • Developed a number of queries utilizing various SQL analytic functions to capture, Rank, Aggregate, etc. data from the various Confidential worldwide market headquarters (West Coast, Europe, etc.). This effort would later support or assist in Big Data related projects. Conducting analysis to identify anomalies in normal customer patterns or behaviors that can affect the outcome of a business or processes.

Senior ODI (SME)

Confidential, Tampa, FL

Responsibilities:

  • Tasked with the near real-time ODI development, test, and deployment of Product, and Pricing data from a SQLSERVER environment into an Oracle platform.
  • Utilized Change Data Capture (CDC) via J$ tables to identify, and capture change data. Key column(s) identified the source data for extracting, loading, and transformation per business requirements.
  • Product, and Pricing data once loaded, and transformed in Oracle for subsequent COGNOS reporting, was also exported to an XML file.
  • ODI was also utilized to export to XML, and transmit to a message queue.
  • Workflows, Packages, SENARIOS, and Agents were developed or setup for orchestration purposes.
  • Control-M will schedule SENARIOS within the Execution repository.

Programmer Analyst - Oracle Data Integrator Developer

Confidential, New York, NY

Responsibilities:

  • Responsible for architecting the design and implementation of a data warehouse that will house a core set of data elements from disparate State and City systems.
  • The data will be centrally located and accessible for the creation of required reports necessary for critical decision making by ACS field and executive managers.It was necessary to architect the solution, develop the appropriate relational model, as well as develop the ETL processes in ODI (interfaces, packages, etc.)
  • Directly worked with ACS to clarify their requirements that would formulate the technical design
  • Oracle Data integrator was utilized for the transformation of ODS data into the Data Warehouse. Interim temporary data stores were targeted, and sourced in order to properly assemble the data into the dimensional model. OBIEE was utilized for reporting and dashboard development
  • Data validation, error detection, and exception handling processes were also developed to handle data inconsistencies.
  • Worked with the testing team to ensure that the results were consistent with the agreed upon requirements.

Senior ODI Developer

Confidential, Englewood, CO

Responsibilities:

  • Responsible for the re-design, re-development, and testing of existing processes to support OBIEE reporting and dashboard development.
  • Dimensional models were developed as result of the analysis.
  • Aggregate tables were also developed as needed. ODI and PL/SQL processes were developed to populate table(s).
  • Packages and senarios were created for initial and incremental processing.
  • In addition, it was necessary to install separate development, QA, and production environments. Clear Case was utilized for code management

Senior Teradata/Oracle/ODI Architect/Developer

Confidential

Responsibilities:

  • Responsible for assisting in the design, development, testing and implementation of Confidential, Toronto, ON Canada migration to Teradata platform.
  • Produced High Level, and Technical designs
  • Teradata/ INFORMATICA ETL Developer - ETL Lead on a team tasked with Confidential data integration, ETL Design, Development, Testing, Deployment, and business unit integration from SQL Server, Oracle, Oracle EBS, Flat-file into Teradata. Utilize INFORMATICA 9.1.0 (PowerCenter Designer, Workflow Monitor and Workflow manager) integration development tool to load data from various source systems, including flat-files.
  • Perform testing, and optimizing of ETL (Extract, Transformation, and Load) scripts. Audit & Error table checking routines were also designed into an Audit / Error Handling Framework. Developed INFORMATICA (PowerCenter Designer, Workflow Monitor and Workflow manager) mappings/workflows/etc. utilizing PowerCenter 9.1.0 to drive varying data sources into production.
  • As a part of development created associated repositories, source to target mappings/mapplets, workflows, and transformations.
  • Utilize TIDAL as the enterprise scheduler.
  • Data validation routines were written to ensure data accuracy.
  • Managed offsite (Manila) ETL INFORMATICA resources

Senior Oracle/ODI Architect/Developer

Confidential, Carson City, Nevada

Responsibilities:

  • Responsible for the design, development, testing and implementation of Confidential benefits and contribution system.
  • Claimant and Employer Legacy system data was sourced from various systems to include Main - frame, DB2 and flat-files. PL/SQL scripts, and ODI interfaces, procedures, etc. were utilized to clean, extract, load, and transform data into Oracle relational table(s).
  • Utilized constraints, and triggers to maintain relationships among related table(s) in the database.
  • ODI processing was architected to respect these constraints.
  • Architected database design, and data migration solutions in order to properly load data. Assisted in the creation of requirements, business rules and data mapping requirements.
  • Packages, senarios were built within the ODI structure in order to organize workflows.
  • Created and executed test senarios and data reconciliation routines.
  • Data reconciliation requirements were needed table to table in order to validate loads, and exceptions. Error reporting processes were also built.
  • Successfully implemented Conversion, and Bridging processes.

Senior Oracle/ODI Architect/Developer

Confidential, Chelmsford, MA

Responsibilities:

  • Confidential Computer Systems provides embedded computing systems and software that combine image, signal, and sensor processing with information management for data-intensive applications.
  • Confidential serves a broad range of industries that include aerospace and defense, homeland security, telecommunications, and other computationally challenging markets.
  • Architected the design and implementation of the star schema for the Confidential project (Revenue Forcasting model).
  • The ELT provides the functionality to capture data from disparate systems, translate and integrate the data and apply business logic. Installed and configured ODI environment. Oracle DDL structures.
  • Designed, developed, tested, and implemented ODI packages, interfaces, procedures, etc.
  • Sourcing data from SALESFORCE.COM as well as Oracle database table(s) populating star schema.
  • The implementation will provide data to the OBI-EE reporting Revenue Forecasts.

Senior Oracle ODI Analyst

Confidential, Mount Laurel, NJ

Responsibilities:

  • Installed and configured ODI environment. Installed and configured Hyperion Financial Management (HFM) Adaptor.
  • Gathered Requirements.
  • Created necessary Source and Target DDL s to support development
  • Developed/Tested/Implemented ODI processes

Senior Oracle ODI Lead/ELT/ETL Developer

Confidential, Brooklyn, NY

Responsibilities:

  • Installed and configured ODI environment.
  • Created Oracle DDL s, Sequences for surrogate key generated.
  • Migrated various sources (flat - file, Oracle, etc.) into the new Data Warehouse table(s) via Oracle ODI.
  • The migration will provide data to/ from the newly developed BISP front-end application, and the OBI-EE reporting Star Schema.
  • Setup Topology Layer (Physical, Logical, Context, Agent)
  • Utilized Designer to develop Interfaces, Procedures, Variable (Global/Local)
  • Generated necessary Senarios
  • Created/Utilized AGENT to execute via UNIX shell
  • Utilized ODI Toolbox to perform a variety of functions including operational functions
  • Created/Modified a series of UNIX shell within the /bin structure as needed
  • Created necessary directory structure to facilitate file disposition
  • Monitored/Validated Operator production logs

Senior Oracle/Teradata ODI/FDM/Hyperion Developer

Confidential, Cincinnati, OH

Responsibilities:

  • Oracle ODI Developer assigned to migrate Oracle/SQL Server data into Teradata via ODI.
  • Developed transformation algorithms/expressions to transform source data.
  • Setup Topology Layer (Physical, Logical, Context Agent)
  • Utilized Designer to develop Interfaces, Procedures, Variable (Global/ Local)
  • Generated necessary Senarios
  • Created/Utilized AGENT to facilitate batch execution
  • Utilized ODI Toolbox to perform a variety of functions including operational functions
  • Created/Modified a series of UNIX shell within the /bin structure as needed
  • Created necessary directory structure to facilitate file disposition
  • Monitored/Validated Operator production logs

We'd love your feedback!