Oscar Bernal

Data Integration Engineer 3 at W3R Consulting
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Miami, Florida, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • Data Integration Engineer 3
      • Feb 2023 - Sep 2023

      United States

    • Software Engineer
      • Nov 2021 - Jan 2023

      Chesapeake, Virginia, United States ● Created and presented estimates to team manager for projects that needed to be worked on ● Utilize technical / procedural skills to support an assigned team’s work within a specified application set or on discrete system elements. ● Engage in design and development discussions, helping the team conceptualize desired outcomes from a Software Engineering perspective. ● Serve as a participating member on teams tasked to develop, improve and deliver product / system elements and… Show more ● Created and presented estimates to team manager for projects that needed to be worked on ● Utilize technical / procedural skills to support an assigned team’s work within a specified application set or on discrete system elements. ● Engage in design and development discussions, helping the team conceptualize desired outcomes from a Software Engineering perspective. ● Serve as a participating member on teams tasked to develop, improve and deliver product / system elements and features. ● Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers. ● Develop and maintain complex SQL queries and / or scripts. ● Making jobs to perform the Informatica workflows using the scheduling tool. ● Using Oracle queries in source qualifier to simplify Informatica mappings. ● Analyzed existing stored procedures in Oracle and converted them to Informatica mappings for a clearer data flow ● Participating in code reviews in accordance with ETL / Informatica best practices ● Break down functional and business requirements into tangible, clear and estimable objectives, providing recommendations to management and project team members ● Ensure quality, performance and adherence to specifications of assigned development tasks and adjacent technology solutions ● Reduced complex ETL coding and mapping requirements from high-level design specifications ● Worked on the development of the ETL architecture, the EDW, and the source-to-target mapping for data loading into the data warehouse ● Work with fellow team members to ensure design, development and execution align with and support adjacencies and adhere to established architectural standards ● Offer technical guidance to less experienced team members ● Advise the development team on technical issue and best practice approaches ● Develop proactive processes to fine tune performance ● Schedule, monitor, and build Informatica jobs in a development, system testing, QA, to deployment in production environment. Show less

    • Senior Engineer, ETL Developer
      • Feb 2014 - Nov 2021

      Norfolk, Virginia Area ● Analyzed and approved requirements that were brought to my team ● Created Stored Procedures in Oracle in order to be called by Informatica ETL tool ● Created and maintained mappings, mapplets, sessions and workflows in Informatica ● Analyzed existing Oracle stored procedures and converting them to Informatica mappings in order to have a clear flow of the data ● Maintained active relationships with customers to determine business requirements ● Converted SSIS control flows into… Show more ● Analyzed and approved requirements that were brought to my team ● Created Stored Procedures in Oracle in order to be called by Informatica ETL tool ● Created and maintained mappings, mapplets, sessions and workflows in Informatica ● Analyzed existing Oracle stored procedures and converting them to Informatica mappings in order to have a clear flow of the data ● Maintained active relationships with customers to determine business requirements ● Converted SSIS control flows into Informatica workflows ● Collaborated with engineers and graphic designers, analyze and classify complex change requests to review and evaluate possible enhancements ● Worked with the Designer, Repository Manager, Workflow Manager, and Workflow Monitor tools in the Informatica Power Center ● Reduced complex ETL coding and mapping requirements from high-level design specifications ● Contributed to the creation of the ETL architecture and the Source to Target mapping for data loading into DWH ● Led development team to develop and define application scope and objectives and prepare functional and / or technical specifications ● Developed Informatica sessions using Informatica workflow manager to run PowerCenter mappings / Mapplets ● Built Data Warehouse Staging and Target tables for data loads, built triggers and stored procedures logic during load cycles, created views for reporting ● Tested and migrated ETL mappings from Development and Test environments into the Production environment (using SDLC methodologies) ● Analyzed and evaluated detailed business and technical requirements. Coded and maintained complex components of information systems ● Mentored others on coding standards and performed code reviews. Developed and performed system testing and fix defects identified during testing and re-execute unit tests to validate results ● Integrated activities with other IT departments for successful implementation and support of project efforts Show less

    • Police Officer
      • Apr 2007 - Feb 2014

      Norfolk, Virginia Area Criminal Investigator role included planning, organizing, conducting self-initiated investigations. Additionally responsible for conducting interviews and interrogations in both English and Spanish languages to recognize, explore, and exploit leads. Analyzing gathered information from investigations to evaluate the reliability of leads and communicating such analysis to personnel is a significant responsibility of the role. Administrative and communications roles consisted of preparing… Show more Criminal Investigator role included planning, organizing, conducting self-initiated investigations. Additionally responsible for conducting interviews and interrogations in both English and Spanish languages to recognize, explore, and exploit leads. Analyzing gathered information from investigations to evaluate the reliability of leads and communicating such analysis to personnel is a significant responsibility of the role. Administrative and communications roles consisted of preparing various reports and documents to supplement and complete investigations; presentation of evidence and testimony in court proceedings. In addition to these presentations, the briefing of superiors and colleagues on ongoing cases is a regular responsibility throughout this role. ACCOMPLISHMENTS: Completed bike patrol officer school, Doppler Radar School, Detection of Deception and Critical Interviewing Skills Training School sponsored by the Department of Criminal Justice Services (DCJS), F.I.S.T. Suit Role Player/ Scenario Training school mandated by the Norfolk Police Training Center. Show less

    • Mobile Application Developer / Owner
      • Jul 2012 - Jan 2014

      Virginia Beach Being an extremely goal oriented individual, I have the ability to adjust to any situation; whether the situation requires for me to work with a team setting or as an individual, my goal is to bring excitement and the re-usability of applications to the users. I am committed to my line of work and my experience varies from the graphic design and development of video games to developing educational applications. I currently have a Masters Degree in Information Systems Management with a focus in… Show more Being an extremely goal oriented individual, I have the ability to adjust to any situation; whether the situation requires for me to work with a team setting or as an individual, my goal is to bring excitement and the re-usability of applications to the users. I am committed to my line of work and my experience varies from the graphic design and development of video games to developing educational applications. I currently have a Masters Degree in Information Systems Management with a focus in mobile development. The ultimate goal that Dev Dynamics has is to provide innovative services globally for pioneering businesses. Show less

    • Programmer Analyst
      • Oct 2012 - Feb 2013

      Virginia Beach Responsibilities: Perform routine assignments to develop program logic for new applications or analyzes and modifies logic in existing applications. Follows established procedures to modify application programs from detailed specifications. Follows standard practices to code, test, debug, document, implement and maintain software applications. Reads and interprets design documents. Create simple design documents. Reads, interprets, creates and maintains simple conceptual, logical and physical… Show more Responsibilities: Perform routine assignments to develop program logic for new applications or analyzes and modifies logic in existing applications. Follows established procedures to modify application programs from detailed specifications. Follows standard practices to code, test, debug, document, implement and maintain software applications. Reads and interprets design documents. Create simple design documents. Reads, interprets, creates and maintains simple conceptual, logical and physical models to include context diagrams, data flow diagrams, process flow diagrams, data dictionaries and logical flow charts. Assist in ensuring that system improvements are successfully implemented. Resolve simple to moderately complex design issues utilizing software development lifecycle and development methods. May develop multiple, modular objects and the messaging interface between objects to create a moderately complex software package. Perform complex queries. Performs simple database updates. Ensures compliance and requirements of current license and support agreements are met. May obtains vendor quotes and validates invoices. Perform basic application administration and support. Show less

    • United States
    • Armed Forces
    • 700 & Above Employee
    • Hospital Corpsman
      • Jun 2002 - Mar 2007

    • Hospital Corpsman/ Optician
      • Jun 2002 - Mar 2007

      Regularly assisted in the prevention and treatment of diseases and injuries, administering immunization, rendering emergency medical treatment, and maintained treatment records and reports. Other responsibilities included the performing of all phases of fabrication of single vision and multifocal spectacles from prescriptions. ACCOMPLISHMENTS: Represented the command with over 20 color guard ceremonies in the Tidewater Region. Selected over more senior opticians to work in the… Show more Regularly assisted in the prevention and treatment of diseases and injuries, administering immunization, rendering emergency medical treatment, and maintained treatment records and reports. Other responsibilities included the performing of all phases of fabrication of single vision and multifocal spectacles from prescriptions. ACCOMPLISHMENTS: Represented the command with over 20 color guard ceremonies in the Tidewater Region. Selected over more senior opticians to work in the specials department on complex prescription eyewear orders. Contributed to the fabrication of 1.2 million pairs of optical devices, helping to decrease the production backlog. Helped train a full shift and senior personnel on proper use of equipment. Nominated for Junior Sailor of the Quarter, while E-4.

Education

  • ECPI University
    Master of Science (M.S.), Information Technology Project Management
    2011 - 2012
  • ECPI University
    Bachelor's Degree, Criminal Justice
    2009 - 2011

Community

You need to have a working account to view this content. Click here to join now