Desiree Lochen - Lead Designer Resume Simple
10+ years of experience in IT industry with expertise in business Intelligence, data warehousing, ETL, BI, BI tools, and data modeling.
  • test, test plans, teradata, analysis, data analytics, informatica, project management, project, etl, design, implementation, solutions, production, management, analytics, offshore, database, database systems
  • sftp, project, ftp, test, server, network, validation, progress, basis, test scripts, pmo, shell, unix, shell script, teradata, shell scripts, informatica, reports, exchange, project plan, management, data management, file, unix shell
  • 2017-12-262017-12-26

    Lead Designer


    • Perform analysis, design, development, testing, implementation, and support of ETL solutions, including bi-weekly, monthly, and quarterly production releases.
    • Bi-weekly project Manager, business Intelligence, data warehouse, ETL, data quality, and test management.
    • Responsible for documenting the business requirements and technical specifications. Worked with offshore team to develop the data model and database design.
    • Developed Informatica mappings, workflows, and user defined data types to extract data from multiple sources and to cleanse the data and to validate the business rules.
    • Involved in the development of BI analytics and data analysis strategy to create a logical and physical data model. Created and maintained the conceptual, logical and physical models.
    • Work with business Analyst to understand the data model and provide the best possible solution for ETL development. Involved in data analysis and coding of the BI tool.
  • 2017-12-262017-12-26

    Technical Project Manager

    Northrop Grumman

    • Developed UNIX shell scripts for file transfers, data migration, archiving and reporting, IT audit, project plan, test case, and trouble shooting.
    • SAP basis: The billing system, the data warehouse, the ETL process, the Server, and the reports were used to monitor the performance of the infrastructure.
    • Responsible for the development of the ETL process for the data migration from legacy mainframe to the new system using COBOL, DB2, and TSQL.
    • Responsible for the data migration from legacy mainframe to a new billing system using Java, Perl, and SQL.
    • O worked with the IBM DB2 team to fix the issues related to the data migration process. This includes the creation of the performance of the application, and troubleshooting the issues.
    • Lead the team to develop a data warehouse for the business Intelligence infrastructure for the global billing system. Worked with the data Center to create a new table for the entire ETL process.

 Hike Maui