Tomasz Janiec

• Create and optimize SQL scripts and PL/SQL.
• Develop new solutions.
• Create and optimize ETL processes.
• Inspected equipment, assessed functionality, and optimized controls.
• Corrected, modified and upgraded software to improve performance.
• Customized or developed Oracle workflows to meet company business processes.
• Estimated work hours and tracked progress using Scrum methodology.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Gathered and documented business requirements to determine capabilities to be delivered.
• Provided technical expertise to support daily operations in Oracle applications.
• Built databases and table structures for web applications.

• Create and optimize SQL scripts and PL/SQL.
• Develop new solutions to meet project requirements.
• Design and optimize ETL processes for efficient data extraction, transformation, and loading.
• Implement database optimization techniques to improve performance.
• Integrate data from multiple sources into the database system.
• Manage database storage and ensure data integrity and security.
• Design and execute verification tests to ensure the accuracy and reliability of database solutions.
• Prepare comprehensive documentation for current and new projects.
• Independently lead projects from conception to completion.
• Address bugs and perform maintenance tasks as needed.
• Conduct business and technical analysis to identify opportunities for improvement.
• Experience working with mixed database types, including Data Warehousing (DWH) and transactional modules.
• Optimized database performance by implementing efficient SQL queries and PL/SQL procedures.
• Developed or customized Oracle reports and forms to meet functional business requirements.
• Provided technical expertise to support daily operations in Oracle applications.
• Built databases and table structures for web applications.
• Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
• Mentored junior developers on Oracle technologies, promoting a culture of continuous learning within the team.

- Customer: One of the major telecommunication companies.
- Project role: Oracle Developer
- Project duration: January 2018 – October 2018

Scope of responsibilities:

- Create and optimize SQL scripts and PL/SQL.
- Develop and optimize ETL processes.
- Create and carry out verification tests.
- Create documentation for current and new projects.
- Create reports in MicroStrategy.
- Create Implementation Scripts.
- Conduct business meetings.
- Perform business and technical analysis.
- Create reports in Apex Oracle.

Customer: One of the major telecommunication companies
Project role: ETL Analyze
Project duration: February 2018 – April 2018
Scope of responsibilities:

- Gather and analyze information from Informatica PowerCenter Repository (Oracle database & MSSQL server).
- Gather and analyze information from Unix servers.
- Analyze Informatica PowerCenter processes – workflows, sessions, commands, etc.
- Analyze log files from Informatica PowerCenter.

Customer: One of the major TV stations
Project role: Business analyst
Project duration: January 2018 – February 2018
Scope of responsibilities:

- Perform technical analysis of existing solutions.
- Create new functionality.

• Conduct business and technical analysis.
• Design and develop the DataWarehouse.
• Create and optimize SQL scripts and PL/SQL.
• Develop and optimize ETL processes.
• Create and execute verification tests.
• Prepare documentation for current and new projects.
• Provide third-line support.
• Optimize support processes.
• Facilitate business meetings.