Juliet Lark Basika

I worked on the 2-month Higgins Machinery Data project as a Data Engineer specializing in REST API integration, Azure Data Factory, and data pipeline development.
• Utilized Snowflake’s semi-structured data capabilities to flatten and transform JSON files into relational tables, facilitating enhanced data analysis and integration.
• Effective collaboration with cross-functional teams to deliver data-driven insights and decisions.
• CI/CD: Automated Azure Data Factory data ingestion pipelines to enhance overall system efficiency, leveraging Azure DevOps for continuous integration and deployment
• Implemented Postman for API testing and validation.

• Worked effectively in fast-paced environments.
• Self-motivated, with a strong sense of personal responsibility.
• Organized and detail-oriented with a strong work ethic.
• Strengthened communication skills through regular interactions with others.
• Used critical thinking to break down problems, evaluate solutions, and make decisions.

• Involved in Content data Migration project using Silver Stripe for MOJ
• Migrated and Published Treaty settlements and quarterly reports from an old government website to the MOJ website using Silver Stripe to customer data from source documents, contents, and links within time limits
• Managed Content Management Systems and Tested and monitored websites and applications, reported and fixed bugs by an approved method.

• I contributed technical expertise to design, test, implement, and support insurance technology solutions, contributing to enhanced efficiency and effectiveness of the Managed Services Technology Environment at BNZ Insurance
• Provided 1st, 2nd, and 3rd-level day-to-day technical support to address technology and business needs within the production/business-as-usual environment, ensuring seamless operations
• Contributed to Supporting IBM WAS platform applications and other life insurance applications, troubleshooting APIs and checking SQL scripts to ensure their smooth functioning and availability of data
• Managed change management requests, resources, processes, and signoffs for releasing the correct software version that was deployed into production changes or issues to maintain optimal performance.

• I worked with the Health Sector Agreements and Payments Programme (HSAAP) Analytics team to provide reporting analytics and data migration solutions in an agile framework
• Built data models, created data mapping, developed SQL scripts, and created Qlik Sense Dashboards, providing stakeholders with actionable insights into key performance metrics
• Conducted data profiling for Oral Dental Reporting by analyzing SAS script data flow and creating data mapping documents, resulting in improved data quality and accuracy
• Performed data transformation using Talend and implemented data transformations in DBT and Snowflake, streamlining the ETL process and reducing processing time.

• I was involved in Ariba Data migration and decommissioning project
• Collaborated with ACC subject matter experts and project team to identify, define, collate, document, and communicate the data migration requirements, developed and executed data migration plans and understanding of the project scope and objectives
• Built SQL Scripts to extract source database, standardize matching the source data to the destination formats, manage source-to-target data mapping, and transform data enabling seamless for business needs.

• I have functioned effectively with multi-functional roles to identify and leverage areas for improvement in data systems to meet customer needs and ensure that the Information Assets are safeguarded and performing to meet business outcomes
• Developed source-target mappings, data, and control flows, and implemented them across various sprints during the project timeline
• Adapted best practices amongst other integration analysts/developers for technical design, patterns, and data extraction standardization, validating, cleaning data, and loading from heterogeneous data sources maintained with business rules
• Maintained Continuous Data Integration and delivery (CI/CD) DevOps practices, deployed scripts in QA, UAT, and Production environments, and maintained version control using GIT
• Developed Extract Transfer and Load (ETL) and Extract Load and Transform (ELT) tools using SQL and PL/SQL scripts with business rules to be applied to data from source input to target data repository
• Automated data extraction of load plans to run on a regular schedule
• Analysed data identified data integrity problems, and maintained a large complicated dataset
• For alignment and integration to the data dictionaries and data transformations using DevOps Methodology
• Streamlined the reporting process by tuning SQL and modelling needs, documented Metadata for End users, and automated the daily reporting process
• Performed User Administration for the BI User community for Reporting tools SAS Administration Platform, Oracle Enterprise Performance Management (EPM), and Oracle Business Intelligence Enterprise Edition (OBIEE)11g
• Restarted applications after patching in Webservers
• Performed the SAS server’s maintenance plan, including PIV during patching and applying licenses to SAS servers
• Collaborated with business analysts and data architects to determine data integration requirements, ensuring best practices and standards were followed in design and development
• Demonstrated excellence in operational support activities 24/7 to maintain and monitor complex business-critical data warehouse environments
• Created unit test plans and scripts to support testing for various legislative projects, IR data sets for Child Support, KiwiSaver, Debt, CROWN reporting, and Student Loan redesign
• Achieved 100% error-free Code Deployment into UAT and Production environments.

• Assessed operational performance to identify areas for improvement.
• Investigated and resolved alerts, conducted queries and culled records to assist with maintenance and problem resolution.
• Conducted data analysis to identify opportunities for streamlining client operations and improving customer satisfaction.

• Extracted and validated data from ORACLE, ensuring data accuracy and integrity.
• Analysed and imported data to DBTextworks, facilitating efficient data management and accessibility.
• Researched requests, processed off-site material, and maintained the Ministry’s central file database, ensuring smooth operations and effective records management. Conducted research on rental and income rent-related facts and SAS forms.
• Designed and maintained intranet pages to facilitate communication between internal and external stakeholders, enhancing user experience and information dissemination.
• Responded to information requests such as OIA and PQ from the government’s internal department.
• Structured the filing system and attended Records Management Association meetings to ensure proper data management.
• Contributed to developing and reviewing business rules for MSD and Housing Corporation.