Monica Johnston Email & Phone Number

Chandler, Az, Us

Delray Beach, Florida, Us

Responsibilities:• Design and maintain the analytics data model in our Enterprise Data Warehouse• Manage a team of Data Engineers who support the Data Lake in BigQuery• Manage a team of Workato developers who build and support the Enterprise system integrations• Runs bi-weekly Data Governance meeting to determine data impact of new projects• Communicate with various stakeholders during production issues and perform RCAsKey Accomplishments:• Transitioned the Data Analytics organization from dependency on contractors by building a lean but highly productive team of data engineers• Redeveloped existing data mart with supportability and performance in mind translating to a significant BigQuery cost savings as well as faster dev team cycles• Implemented data quality dashboards and alerts. P1 alerts using audit table to track record counts and flag when there is data missing (rows). Data Quality views for identifying sparse data (columns).

Delray Beach, Florida, Us

Delray Beach, Florida, Us

Bangalore, Karnataka, In

• Consulting in System Implementer role on Core Banking Transformation program for a regional bank client to modernize their deposit platform for checking and savings • Data Conversion Lead for a team of six resources (both in US and offshore) • Coordination between legacy system owners at bank and replacement software vendor • Resource allocation and project planning in jira • Provided architecture, technical design and coaching for conversion Wipro team

Tempe, Arizona, Us

• Designing and developing data model for new data warehouse for the consumer business unit• Create tables in SQLDW on Azure platform• Gather business requirements and analyze data to define business rules for ETL developers• QA testing and troubleshooting of data issues• Write queries to assist analytics teams and data scientists with data pulls

Tempe, Arizona, Us

• Provided support for legacy reporting during LifeLock's acquisition by Symantec• Created Informatica mappings to pull data from various source systems (Teradata, Oracle, flat files) and load into SQL data warehouse database on Azure platform• Provided complete production support for nightly ETL loads• QA testing and troubleshooting of data issues• Wrote queries to assist analytics teams and data scientists with data pulls

Tempe, Arizona, Us

• Create Informatica mappings to pull data from various business applications and load into data warehouse.• Provided complete production support for nightly ETL loads.• Create dimensional data models to support business reporting needs.• Assist Reporting Analysts with Business Objects Universe design.

Irving, Texas, Us

• Collaborate with reporting analyst to gather requirements and design new internal/external reports.• Design and implement star schemas and supporting data warehouse tables for reporting (Oracle).• Document system design/coding standards for DW and ensure team understanding and adoption.• Create Informatica mappings/workflows to pull data from source systems to data warehouse.• Develop ETL code to create flat file extracts per client specifications.• Ensure project deliverables are met by contract resources and liaise with business and IT management.• Research and resolve data quality issues in data warehouse and source systems.• Educate extended IT team on importance of data quality and assess downstream impact of system changes.• Onboard new contractors, mentor team members new to Informatica tool, and perform code reviews.• Maintain team members’ Informatica user accts, roles, folders, etc. and migrate code to production.

San Francisco, California, Us

• Supported compliance team by pulling sample data for testing purposes.• Created SSIS (Integration Services) packages to pull data from DB2 data warehouse.• Queried database to produce statistics on compliance testing results and error rates.• Created reports using Sql Server Reporting Services.

Atlanta, Ga, Us

• Built from scratch, in a changing business environment, a data warehouse to support the new ERT (Executive Reporting Tool). Completed first phase of project star schema design, Informatica ETL, and supporting documentation.• Created Informatica mappings to pull data from an Oracle repository of web site clickstream data. Created Siebel repository and dashboard reports per business owners requests and facilitated user acceptance testing.• Working within Siebel Analytics’ OEM Informatica environment, designed and built custom Informatica mappings to supplement those provided ‘out of the box’.• Performed bug-fixes/enhancements to Siebel Analytics repository and dashboard reports to support an Operational BI environment with data Siebel CRM tool.• Provided complete production support for nightly ETL loads.

Palo Alto, Ca, Us

• Analyzed business requirements, technical specifications, source databases and physical data models to create source-to-target mappings and process flows.• Completed design & development of ETL (Extract/Transform/Load) components using Informatica Power Center to build an enterprise-wide data warehouse.• Converted PL/SQL scripts to Informatica mappings.• Managed sub-project team of ETL developers. • Established and promoted ETL best practices.• Performed weekly migrations of ETL code to production environment and ensured adequate documentation provided for change management audit trail.• Provided Informatica administrator services such as creating database connections, new repositories, new folders, setting up users and applications, migrating code, managing permissions etc. • Provided third level production support (escalation point for complex issues) with initial response team located offshore in India.

• Supported enterprise level supply chain visibility ODS for internal /external users.• Designed database elements to meet business and web app. requirements. • Enforced Enterprise Data Architecture standards.• Maintained Oracle Designer meta-data repository and Logical/Physical diagrams.• Designed, tested, and managed implementation of real-time & batch interfaces.• Researched data quality issues and worked to resolve issues.• Supported supply chain initiatives from IT perspective.• Gathered business requirements and adhered to scope of each project.• Developed project plans and documentation at appropriate level of detail.• Developed process/data flow charts and system architecture diagrams.

Bs, Management Information Systems

Bachelor'S Degree, Management Information Systems, General