Wiktoria Cichosz

Worked on the implementation of a normalized data framework for an insurance industry client, covering policy, claims, and quote data. • Designed and built a multi-level T-SQL view hierarchy where each lower-level view referenced its parent, ensuring consistency and traceability across the data model • Analyzed SSIS packages to understand source data transformation logic (Excel, Access) and migrated that logic to stored procedures or Azure Data Factory pipelines • Built ADF pipelines from scratch and modified existing ones — including FTP-to-SQL file transfers and iterative stored procedure execution across multiple files • Participated in data mapping and gap analysis with the client, identifying fields without a counterpart in the target model and implementing automated extensions in T-SQL • Conducted SIT/UAT testing by comparing data and aggregations between DEV and UAT environments at the view level

• Lead Automation Engineer: Spearheaded the automation segment of a bank-wide project related to the merger of Credit Suisse and UBS, ensuring seamless integration and process efficiency. • Integration Support: Supported the integration function by tracking key milestones and providing extensive change request automation, which ensured data accuracy across various divisions. • Power Automate Workflows: Delivered approximately 5 production-level Power Automate flows, enhancing workflow automation and operational efficiency. • Alteryx Data Transformation: Assisted the workforce team by transforming monthly allocation data in Alteryx, which is utilized in at least 7 Power BI dashboards for comprehensive reporting and analysis.

• Python Automations: Developed various automation scripts including scraping task scheduler logs using xml.etree library for reading .EVTX files, executing data lake queries via Python and storing results in MS SQL Server. • Tableau Server Scraping: Extracted table connections from dashboard queries on Tableau Server to streamline data dependencies. • NLP Clustering: Implemented NLP clustering techniques to identify and categorize the most common error groups, enhancing error resolution efficiency. • Tableau Dashboard Development: Created comprehensive Tableau dashboard to present project's history dating back to 2010, enabling clear and insightful data visualization. • Invoice Automation: Automated invoice preparation and email dispatch to vendors using Python libraries such as smtplib and email.MIME. • BAU Data Lake Tasks: Managed business-as-usual tasks involving the Data Lake, including data onboarding and creation of current tables to support ongoing data needs. • ServiceNow Data Management: Collaborated within a team responsible for owning and managing ServiceNow data, ensuring accurate and efficient data handling.

Key Responsibilities: - Developing dashboards (collecting data in SQL, data preparation, visualization) - Maintaining dashboards (implementation of new requirements, fixing bugs, enhancing usability/performance) - Deep-dive R Studio retrospective data analysis project - Ad hoc SQL/Excel data analysis for business cases - Preparing PROD releases (GIT versions, documentation) - Preparing training videos, maintaining confluence pages (UAT test cases, change log) - Active participation in Scrum meetings