JULIA RIVERA

ad3xef@r.postjobfree.com

DATA MANAGEMENT SPECIALIST

Data Architect Data Engineer

SECURITY CLEARANCE

- Top Secret

LANGUAGES

- English – Fluent

- Spanish - Some

Delivery Excellence

Project and Program

Management

- 9 Years as Project Lead &

- Technical Lead

- Sr. It Specialist

Communication and

Networking

DATABASES

- ORACLE,

- MYSQL,

- SQL Server

OPERATING SYSTEMS

- Windows

- RHEL

- LINUX,

- UNIX

SOFTWARE/SYSTEM

ARCHITECTURE

- Client Server

- Multi-Tier Architecture

- SOA

PROGRAMMING

LANGUAGES & TOOLS

- Suite of Applications,

- Oracle,

- J2EE, JSP, JAVA, Servlet

- PERL, UNIX, AWK, SED Shell

- C,C C,VBA,

- PL/SQL,SQL,

- XML, XLST,

- Tomcat,

- TOAD, J Developer

CERTIFICATIONS

SECURITY+

CASP

Informatica Developer

PROFESSIONAL SUMMARY

Over 20 years’ experience as an IT Specialist /Data Engineer including;

15+ years Informatica Power Center Application and System Administrator/Developer. Including server installation, migrations, design & tuning

5+ years CRS Data Modeler implementing Kimball Method

5+ years in Business Intelligence; Data Architect (ERWIN Data Modeler)

Over 6 years in Technical Project Management/Technical Lead

5 Years as a Senior Data Engineer & Senior IT Architect leading development Teams.

20+ years in Business Requirements Analysis, software methodologies and SDLC.

20+ years System design and Application Development PROFESSIONAL EXPERIENCE

IT/CS Supervisor: FRCSW Mar 2021-Dec 2023

Serve as the IT/CS Application Management, IT/CS Supervisor.

• I supervise a team of professionals comprised of technical experts and Team leads who provide Data Warehouse services such as Data Architecture, Data Modeling, Universe Design, Report Developers, Application/System Administration local application development and manufacturing application administration to include financial/material systems support, logistics systems support.

• Determine plans and make specific functional work assignments, identify and secure employee training to meet requirements, monitor and evaluate work performance, participation the selection process, approve leave requests and resolve team concerns.

SENIOR DATA MODELER: FRCSW Aug 2019 – Mar 2021

• Served as the Senior Data Modeler for Fleet Readiness Center Southwest

(FRCSW) Center of Excellence (COE) Corporate Reporting System(CRS).

• Lead the development and innovation of data strategy and architectural frameworks.

• Served as the liaison between business data consumers and the data warehouse/BI teams.

• Responsible for defining standards for managing, modeling, and delivering data within the enterprise.

• Partnered with and engaged members of the divisional business leadership, Enterprise Risk Management, Data Warehouse, and business process teams to understand the business requirements and influence the best designs for the solution architectures.

• Provided direction to other data modelers on the design of relational and dimensional models using the Kimball Methodology.

• Developed and validated modeling solutions.

• Integrated and drove modeling solutions into existing business processes.

• Maintained data models and standards documentation on master data.

• Helped customers understand and leverage existing data sets.

• Promoted and supported the basic tenets of good data architecture and governance.

• Performed necessary activities to drive standard definitions of facts and dimensions.

• Create data models and schemas at all levels including conceptual, logical, and physical for both relational and dimensional solutions.

• Integrate disparate data models into coherent enterprise data models.

• Capture business rules that govern how data is transformed, integrated, and used.

• Responsible for integrating several core NDMS applications into our enterprise data warehouse for consumption such as NERP, MAXIMO, MRO, TAP, IPA etc.

LEAD ETL DEVELOPER: FRCSW Mar 2009 - Aug 2019

• Served as the Lead ETL Developer for Fleet Readiness Center Southwest

(FRCSW) Center of Excellence (COE) Corporate Reporting System(CRS).

• Project manager for all Solaris and RHEL Informatica Server installations, migrations, SSL certs, STIG’s, and overall operations of the ETL nightly processing.

• Lead the development and innovation of many ETL standards that the CRS ETL Team uses to date

• Collaborated between data modelers and the data warehouse/BI teams.

• Provided 7/24 support ensuring data was in optimal condition.

• Analyzed the business requirements and designed ETL solution and developed the code using Informatica Power Center.

• Understood the requirement specifications, prepared the functional and technical design documents.

• Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time.

• Collaborated with data modelers to correct any production issues and Provide solution delivery in a short time frame.

• Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.

• Responsible for retrofitting the code to QA environment and extending the support for the QA for fixing the bugs.

• Responsible for batch monitoring and troubleshooting in all environments

• Developed the source definitions, target definitions to extract data from flat files, relational sources.

• Created different transformations for applying the key business rules and functionalities on the source data.

• Developed ETL solutions for reporting designed to sustainably support business outcome requirements.

• Engaged with department and business unit resources to ensure understanding of requirements and data environment.

• Delivered timely, validated, well-tested work product.

• Participated in the development of quality and continuous improvement of standards and protocols.

Contact this candidate