Agnieszka Tworzewska

Enhanced SQL processes, streamlining procedures, queries, views, triggers, and indexes for improved performance.

Transformed SQL procedures and views into Boomi integration workflows, increasing integration efficiency.

Designed and implemented custom ETL processes to transform client data assets.

Conducted extensive testing to ensure data integrity, accuracy, and high performance.

Collaborated with business units to gather requirements effectively.

Troubleshot and resolved issues in production and UAT environments.

Managed projects and tasks using Jira for efficient tracking.

Documented processes and configurations, recommending improvements to enhance overall project quality.

· Used SQL/PLSQL to support, optimize, troubleshoot and resolve database and user related issues for a telecommunication billing system processing millions of CDRs

· Developed, tested and implemented telecommunication billing system updates

· Wrote SQL/ PLSQL back-end processes to a customer inventory system, keeping track of new orders changes and updates based on gathered business requirements

· Wrote SQL complex queries, views, procedures for business reporting

· Optimized current SQL queries and procedures for better performance

· Created SSIS jobs

· Used SQL/ PLSQL to create stored procedures, views, and queries, triggers and applied indexes for new billing system (legacy DB2 system migration), enabling $1M per year cost saving.

· Developed Informatica Cloud extract-transform-load (ETL) jobs, importing data from mainframe environment into new Oracle system, eliminating manual processes and human errors.

· Designed, created, and implemented processes, including:

o T-SQL sales compensation (based on detailed requirements from business community) allowing monthly financial information to automatically and accurately flow from billing to sales compensation system.

o SQL and Informatica Cloud ETL procedures for loading data from Salesforce into SQL tables, then into AWS S3 buckets, and finally, sending processed files to network locations, ensuring proper data availability for all systems and departments.

· Resolved long-running ETL jobs by converting Informatica Cloud processes into SSIS packages, reducing load time from 20 hours to 10 minutes.

· Led system-integration testing (SIT) on cross-division project, boosting revenue by $300K per month while overseeing testing team to meet project deadlines and maintain data integrity.

· Prepared and supervised execution of test cases and plans based on real-world use cases, producing high-quality results and improving development and implementation timelines.

· Performed functional, regression, and performance tests for new and updated systems, ensuring all aspects of new processes and products were properly implemented.

· Collected and translated requirements from business group, accurately converting system changes and improvements into realistic project deliverables.

· Provided production system and data support during daily operations, preventing negative customer impact using MS Access and SQL.

· Received Power of You award for exceptional effort to meet extremely tight project timeline and multiple Star of the Month awards for outstanding production support efforts.

Developed and implemented SQL features aligned with business requirements to enhance system functionality.

Executed DTS data movement processes to streamline business reporting and improve data accessibility.

Created ER diagrams for both new and existing processes.

Delivered production and UAT support for back-end processes and user front end using MS Access and VB to ensure reliable system performance.

· Normalized MS SQL DB, enhancing data integrity and compliance with relational standards

· Provided user support, resolving issues to improve user experience

· Implemented code changes to align software functionality with business requirements