Johanna Ortiz

The Sightline Analytics team focuses on data management and analyses of customer response, engagement, and energy use trends for marketing campaigns and energy reports spanning tens of millions of customers

• Collaborate with engineers data scientists, marketing, business, and delivery teams to maintain large energy usage & customer datasets
• Developed customized reports, summarizing and presenting data in visually appealing format
• Identified patterns and trends in large data sets and provided actionable insights.
• Manage Scrum-related activities (stand-up, sprint planning, sprint execution)
• Generate artifacts for reporting using SDLC & Agile methodologies
• Spearhead team collaboration & documentation initiative using Confluence
• Manage high-profit products requiring time-sensitive data, ad-hoc campaign analyses, and trade ally portal operations
• Orchestrated complex email marketing campaigns using Eloqua and WebHooks APIs to drive engagement and boost revenue for Sightline
• Monitor internal platform designed to leverage utility data for program reporting, planning, and implementation
• Oversee tasks to distribute hundreds of targeted customer lists for residential and commercial energy efficiency program outreach initiatives
• Facilitate product design, development, and communications across internal teams for new email integration product
• Revitalize existing technical documentation for featured products
• Design, document, and implement standardized processes for scheduled releases, demographic data updates, and insights analyses
• Effectively implemented automated processes for scheduled releases, demographic data updates, and insights analyses resulting in 50% time reduction for task tracking

The Data Integration Services team helps state and local government organizations modernize their information infrastructure by providing integration services to courts and public safety agencies

• Liaison between developers and clients' criminal justice experts to transform technical integration solutions
• Present key milestones and roadblocks to external project Board members
• Team Lead for National Incident Based Reporting System NIBRS data conversion project
• Build NIEM-compliant specifications for statewide repository
• Compile, budget, and schedule technical deliverables for client
• Utilize UML design standards for use in service specification packages SSPs): XML/JSON schema subsets, code lists, data structure, messaging architecture, BPMs, POJOs, business rule validation (Schematron)
• Created data models to support decision-making processes
• Translate conceptual client requests into functional requirements
• Identify opportunities for automated integration of data exchanges
• Define, coordinate, and execute end to end enterprise test plans
• Elicit contract purchasing & procurement vehicles (RFPs, SONs, SOWs)
• Manage ad-hoc JIRA reporting & analytics to drive project delivery
• Design & build functional wireframes for inventory management application