Mirela Waterloo Email & Phone Number

Chicago, Illinois, United States

Greater Chicago Area

- Create and maintain optimal data pipeline architecture- Translate business requirements into data pipelines using ETL/ELT methodologies and SQL- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery

Greater Chicago Area

- Automate and solve complex business issues via T-SQL and MS Business Intelligence- Analyzing healthcare claims, payments, adjustments, detailed charges, ICD9 / ICD10, and other data- Monitor and troubleshoot ETL processes for daily client data and ensure proper loading into a production environment. Responsible to create, redesign and optimize ETL processes.- Custom powershell scripts for mass updates- Engage in service capacity planning and demand forecasting, software performance analysis, and system tuning.- Understand and troubleshoot issues in the database environment, Data Warehouse and Cubes (OLAP)- Supported internal and external users of a SSAS based application- Perform client software version upgrades/go-live’s with coordination from several organizational departments involved- Migrate databases from test servers to production servers and validate all processes are functioning after the transition.- Design and implement internal process improvements, including the improvement of manual processes as well as identifying, developing, and implementation of tools that help automate processes- Working closely with loading and troubleshooting 835 and 277 EDI files, and HL7 messages- Coordinate the receipt and import of historical and on-going data into a database- Performed data scrubbing, validation, and testing results- Automate and design custom reports using SSIS to improve efficiency for analyzing client data.- Responsible for gathering the technical requirements for Waystar’s software support and monitoring the reporting and analysis configuration for each client set-up- Work with client services team members to coordinate research and change requests / work documented and tracked through Salesforce platform- Provide support for Business Analysts and Account Management by creating custom queries or reports, restoring test databases and creating test UI for end user troubleshooting. - Conduct periodic monitoring and/or on call duties

Greater Chicago Area

- Monitor and troubleshoot ETL processes for daily client data and ensure proper loading into production environment. Responsible to redesign and optimize ETL processes to improve efficiency or modify when client data specs are changed.- Design custom tables, views and stored procedures for production databases.- Automate and design custom reports using SSIS to improve efficiency for analyzing client data.- Migrate databases from test servers to production servers and validate all processes are functioning after transition.- Upgrade client databases and UIs from old platform to new platform. Responsible for project plan and testing prior to going live in Production.- Provide support for Business Analysts and Account Management by creating custom queries or reports, restoring test databases and creating test UI for end user troubleshooting.- Responsible for correcting data integrity issues on back end databases when data is incorrectly displayed in client UI.- Designed training process for Production Engineer new hires. Outlined plan to ensure efficient transition into new role.

Schaumburg, Il

Functional Responsibility:- Develop and generate reports to meet the customer's needs and provide them with timely information that enables them to make various program and policy related decisions. - Gather reporting requirements from user and ad hoc requests - Develop, maintain and test complex reports, including sub reports, graphs and statistics using Microsoft Reporting Services and SQL Server- Design layout of reports and determine the best way to present data to end users- Implementation, testing, and maintenance of reports- Troubleshooting issues around reports- Publish and manage the reports on the server and create schedule for reports execution and delivery by email.- Write stored procedures, views, and functions in T-SQL- Create, modify and maintain email templates and landing pages using HTML with dynamic tags- Modify and deploy websites using ASP.NET (C#)

Timisoara, Ro

- Design and develop the web site for the company- Research and analyze using Oracle- Manage multiple task assignments - Perform other appropriate duties as requested, directed, or assigned

Certification, Sql Database Administrator

Certification A+, Network+

B.S., Computer Science