Eugenio B. Candelaria

ad2i8p@r.postjobfree.com

571-***-****

Aldie, VA 20105

https://www.linkedin.com/in/eugenio-candelaria-8b0824199

Summary:

• Extensive years of experience Technical Architect

• Experienced as Scrum Master using Jira for a scheduled meeting in implementing AWS RDS using MySQL iCloud relational database development and architecting, RedShift, Oracle dimensional database have worked on fusion HCM cloud OTBI, worked on Upsolver, SnowFlake Data Cloud and Data warehousing, Splunk, Salesforce platform, Devops, Informatica PowerCenter, DataStage, Oracle Financial using Oracle E-Business Suite ver. 11.5.10, PeopleSoft, Costpoint, SSRS, and Data modeling using Erwin and Embarcadero

• Familiar with health environment with and worked at US Pharmacopeia with ICD, EHR data, and HL7 knowledge

Education:

• B. S. in Business Administration, De La Salle University, Manila, Phils. 1971

• B. S. in Computer Science Courses, Jersey City State University, Jersey City, N.J. 1984

Technical Skills:

• Languages: PL/SQL for 15 years, SQL (5 yrs.), SQR, J2EE/Java, C/C++, C#, Visual Basic, XML/XSLT/HTML/ MVS, CLIST, JCL

• Tools (Others): AWS, Azure, MS Access, Excel, OBIEE/OBIA, Oracle OTBI, SAP Business Object ver 3.2, Visual Basic 6, Hyperion, MS SharePoint, SAS, IBM Cognos ver 10.2.1, Toad, SSRS, AutoSys System Interface Monitoring, Microfocus ALM, Mercury TestDirector, MicroStrategy, PVCS, OBIEE (Siebel Analytics), COBOL, FOCUS RDBMScliud

• Database: Oracle 8, 9i, 10g, 11i, SQL Server, Informix Mongo DB, Sybase, DB2, FOCUS RDBMS, mainframe

• Case Tools/ETL Tools: Informatica, and DataStage

• ALM: Version One, Mercury Testing Director and MicroFocus

Professional Experience:

IGATE (General Electric) Aug 2014 to present

Technical Architect

• Participates in departmental reviews of system design and agile development

• Is involved with the implementation of AWS RDS using MySQL cloud relational database development and is architecting, updating Oracle and Redshift, working on Upsolver, and Splunk, using Snowflake Data Cloud and Data warehousing

• Coordinates with the Enterprise Architecture, domain architects and other partners to ensure each site is delivered consistently and safely

• Reviews and approves proposed BI solutions using current development in agile practices during the design phase

• Establishes the Agile Architecture design concept during the initial high-level design phase

• Develops and promotes standards and patterns of delivery for sites in line with the Enterprise Architecture standards

• Works on enterprise software architecture, starting with the validation of the design approach, validation of software service goals, and requirements

• Identifies and outlines the major components required based on specified project requirements

• Involves in Software Architecture, Analysis, and Design

• Records and documents the agile design and development milestones to maintain transparency and facilitate collaboration within the project

• Defines the interfaces API that connect these components and delegates the detailed internal design work of each component to individual development teams

• Oversees the progress of each team, ensuring they deliver their design and development tasks efficiently and accurately in an agile environment

• Implements Cognos reporting solutions using various Cognos components. Also works with Oracle cloud HCM OTBI. Works with business analysts to analyze business requirements for our client General Electric Treasury Department in the Derivative Consolidation Project. Has experience with visualizing data using Big Data Environment like Mongo DB database with terabytes data. Is well-versed in the Microfocus ALM tool, BI tools SAP Business Objects, Xcelsius, Crystal Report, IBM Cognos, and Oracle Hyperion

• Implements data analytics and data science, prepares development tasks, and delivers solutions to production

• Works as a data modeler using Erwin. Adheres to all stages of Application Lifecycle Management (ALM) from gathering specifications, design, development, testing, and UAT

• Acts as a BI Change Control Board approver for changes to be moved to production

• Implements cyber security plans using Splunk to ensure the cloud environment platform is protected.Extensive experience in Software Testing with technologies – Web Application Testing, Mobile App Testing, Mainframe Testing, System Testing and BI report testing and database DB2, Oracle, Sybase and MongoDB testing to verify the validity of report.

Ecomnets (Dept. of Treasury – IRS), Herndon, VA May 2013 to May 2014

System engineer

• Optimized, Analyzed Query, and implemented improvement in the Processing of transmittal of Data Stage ETL workflows in test, development, and production environment on UNIX servers as submitted to us for full implementation in the Dept. of Treasury – IRS systems with 5 terabytes;

• Used SAS and Greenplum in Testing, modifying, debugging, documenting, and implementing data mapping and data migration for the Department of Treasury – Internal Revenue Services using the EDI transactions to support Health Care benefit enrollment, including EHR data and HL7 data analysis and correction of errors; Gathers, and reviews requirements, specifications, business processes, and proposed solution as documented proposal

• Created PL/SQL to verify the Data Stage workflow; Reviewed and Analyzed functional requirements, XML data as stored, EDI, flat files, Excel, data mapping or documents, transformation, and loading of data, assisting in problem-solving and troubleshooting EDI transaction errors

• Work efficiently with different application groups to include Greenplum migration database and architecture, design and deliver effective solutions; T- SQL(TSQL) or Pl/SQL optimized queries in SQL Server or Oracle

• Involved in BI using SAS, Tableau, SAP BOXI, SSRS/other Reporting technology

• Experienced with working with DevOps Big Data environment, data migration/integration, Information Architecture and management strategizing and supporting project deliverables and work products status documentation; implement solutions to any discrepancy on the project success as per decided risk analysis and recommendation

CACI (Dept. of Navy), Fairfax, VA February 2012 to April 2013

Senior Data Analyst/Technical SME

• Worked with Big Data environment, analyzed, optimized query, implemented, updated, and maintained Oracle Financials eBusiness Suite, Oracle Discoverer, and Report Builder as needed by our client to support Tier III helpdesk as needed

Systems Integration & Development Inc. (Dept. of Education) February 2011 to February 2012

Sr. Data/Report Analyst

• Created Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis of underlying datasets and Data Quality Dashboard and created reports using SAP BOXI rel 3.2 for the US Dept. of Education to render custom dashboards

• Analysis and correction of errors in transactions. Initiate the identified and analyzed data discrepancies and data quality issues to ensure data consistency and integrity; Implement solutions to any discrepancy on the project success as per decided risk analysis and recommendation

Arena Technical Resource Inx. (Dept. of Defense) Bethesda, MD February 2010 to January 2011

Senior Middleware Engineer / Data Analyst

• Worked with the PowerCenter Informatica ETL Tools designing, data modeling, and data-mapping of data loads from various sources like DB2, Oracle, Sybase, Excel to staging and finally to target database.

• Worked with PL/SQL scripts creating specialized data views intended for data reporting requirements using Oracle Studio, Toad, Crystal Report, Microsoft Access, and Excel; utilizing IBM Cognos ver 10.2.1 using the Framework Manager, Connection Studio, Query Studio, Report Studio, and Event Studio

• Developed lots of Oracle using SQL server databases utilizing T-SQL

BearingPoint, Mclean, VA August 2004 - January 2010

Sr. Technology Consultant - Database Analyst

• Worked with PowerCenter Informatica ETL tools and Data Stage ETL Tools performing designs, data migration/integration, data modeling, data mappings, extraction, conversion, transformation and data-loads from various sources DB2, Sybase, XML data as stored, EDI, flat files, Excel, Oracle DB’s file to staging and target data storage; Data Integration/input and Data analysis and Data integrity utilizing T-SQL (TSQL) scripting in SQL server

• Worked on the OBIEE Interactive dashboard, BI Publisher for scalable reporting, Business Intelligence Report, and Query Builder using Business Object XI Rel 3.2 and 4 to compare data, Informatica ETL tools, and PL/SQL script in the loading of data based on the mapping from the Legacy system-Peoplesoft to Costpoint.

• Worked on MicroStrategy serving the San Diego County for Business Intelligence Report and providing analytics creating the most flexible, powerful, scalable, and user-friendly management reports

US Pharmacopeia, Rockville, MD Jan 1997– July 2004

Programmer Analyst / Database Admin

• Implemented Oracle eBusiness Suite Ver 11.5.10 components using AIM methodology

• development requirement, system conversion, Data-Warehousing, Business Intelligence

• Worked on the DataStage ETL; used T-SQL, SQL Server, and SSRS/other reporting technology on another system.

• Provided EHR data and HL7 data analysis, collection of errors and correcting them, periodic OBIEE query objects and ad-hoc reports to users, and management reports from the data warehouse. Experience with Oracle Discoverer reports and Oracle Report Builder

• Developed a program in Visual Basic in the processing of barcoding in Distribution and created the API link to DHL Brussel as our remote warehouse in Europe to facilitate the delivery of our products in just two days and saving us delivery fees and tariff taxes

Contact this candidate