Information Technology Sql Developer

RESUME C/V

ANDREW SOBCZAK

mobile phone: +48-515-***-*** in Poland

email: *****************@*****.***

--- PROFILE ---

An information technology professional experienced with client/server and cloud architecture. Proficiency in : business analysis and reporting

strategic planning

capacity planning

systems analysis

data modelling

database design, administration, performance tuning, disaster recovery data warehouse design and administration

GUI design

Procedural and object oriented development, unit and QA testing, all phases of SDLC Quick learner, performing effectively in a team environment as well as independently. Strong interpersonal, communication, and organisational skills, highly ethical behaviour and dedication. Excellent verbal & written communications skills. Canadian and Polish citizen. Methodologies:

business process modelling

structured analysis, design and development

data flow diagrams

prototyping

Technical Skills Summary:

Cloud Integration with AWS, Azure, GCP

Oracle PL/SQL and SQL development

Oracle database design, administration, performance tuning with AWR and ADDM reports Business reporting (Oracle BI Publisher, Reports & Forms, SQL*Plus, Pro*C, Powerbuilder, Crystal Reports) Data modelling with Erwin

Oracle Financials (General Ledger)

Oracle Developer 2000, 6i, 9i Suite

MS SQL Server, MS SSMS, and Transact SQL

Perl, JSP, XML, Java,Unix shell scripting, Apache and Tomcat Web server VisualBasic, MS Access

C programming on Unix (Pro*C) & VAX/VMS

Powerbuilder objects design and development

Prograph CPX (visual programming on Mac)

Operating Systems:

Unix (HP, Digital, Sun Solaris, SGI Irix, IBM AIX, RedHat Linux), MS Windows 10, Apple Macintosh OS, VAX/VMS. Applications:

AWS, MS Azure, GCP, Oracle Financials GL, Oracle BI Publisher, Oracle Developer Suite (JDeveloper, Designer, Forms, Reports), Oracle Enterprise Manager, Oracle PL/SQL developer, SQL Developer, Toad, SQL*Plus, Oracle Application Server, Oracle IFS, Oracle Workflow, Oracle Pro*C, Powerbuilder, C compiler on VAX/VMS and Unix, Page 1 of 5

Prograph CPX on Macintosh OS, ERWin, Perl, Unix shell scripting, Apache and Tomcat Web server on Unix, StarTeam, PVCS Tracking, CVS, MS Visual SourceSafe, GIT Hub, MS VisualBasic, Crystal Reports, Remedy Ticket Tracking System, Lotus Notes, Jira, Kanban, WorkDay, ServiceNow, MS SSMS, Sharepoint, Enterprise Architect, UC4 job scheduler, UCD code deployment.

Databases:

Oracle 12 and 19 on ExaData Machine, MS SQL Server, Sybase, H2, MySQL, ButlerSQL, FoxPro, VAX RDB

--- PROFESSIONAL EXPERIENCE —

GFT Poland, Warsaw, Poland Oracle Developer July 2021 to present Oracle PL/SQL development and DBA role for a major stock exchange company in Europe. Database and application code troubleshooting and performance tuning, updating system documentation. Oracle 12, Linux, Jira, AWS, GitLab, BitBucket, Sharepoint, Confluence, Citrix networking, SQL Developer and PL/SQL developer apps, Agile Scrum, Windows 10 environment. Technical Analyst / Oracle PL/SQL Developer / L3 Technical Support roles at a major European bank. Online banking application, data migration Oracle 12 to Oracle 19 on ExaCC machine. Analysis of new business requirements. ETL data integration with Oracle sqlldr and DataGuard / GoldenGate. Troubleshooting legacy online banking code (SQL scripts, PL/SQL packages, Unix shell scripts). Application code deployment with UCD. Using Oracle Data Modeller. Monitoring and troubleshooting batch processing jobs scheduled with UC4 on Unix. Performance tuning and optimisation of application code utilising Oracle AWR/ASH/ADDM reports and explain plan. Reconciliation of data discrepancies between various data sources using SQL, PL/SQL with SQL Developer application on Windows 10 also shell scripting on Unix platform. Involved in systems migration to Google Cloud Platform. Took courses on BigQuery, AirFlow, Python. In training for GCP Architect and GCP Data Engineer certificates. Blue Yonder, Warsaw, Poland Technical Architect April 2020 to July 2021 Supply Chain Management company. Oracle PL/SQL development, SQL code optimisation, database and application performance tuning, batch jobs scheduling, monitoring, troubleshooting, daily interaction with business users, estimation of project timelines, participation and support in unit testing, SIT, UAT, designing system enhancements, mentoring junior team members, multitasking on several client projects, updating system documentation. MS Azure, Oracle 12, Mulesoft 4.3, Jira, GitHub, Sharepoint, Windows 10 environment. Lingaro Group, Warsaw, Poland Oracle Technical Expert and PL/SQL Developer Sep 2019 to Jan 2020 IT consulting contract. Oracle PL/SQL development and maintenance of manufacturing planning and logistics application. XML messaging, Tibco web services, Tomcat web server, Jira, Agile Scrum, GIT Hub, Confluence, ServiceNow, Sharepoint, Jenkins, Windows 10 environment. Prudential Insurance, Warsaw, Poland Oracle PL/SQL Developer May 2019 to Aug 2019 IT consulting contract. Insurance business reporting. Oracle PL/SQL development. Oracle Web Services used with XML SOAP messaging. SQL Developer, Confluence, Jira, BitBucket GIT, Jenkins, Windows 10 environment. Societe Generale, Warsaw, Poland IT Consultant Jan 2019 to May 2019 IT consulting contract. Upgrade and enhancements of a banking application written in Powerbuilder 12. Used Enterprise Architect for modelling of business processes. Oracle, Sybase, MS SQL Server, Windows 10, Jira, Confluence environment.

Cushman & Wakefield, Warsaw, Poland IT Developer and Analyst May 2018 to Nov 2018 IT consulting contract. Real estate commercial leasing industry. Upgrade of Yardi system and data migration from Oracle to MS SQL Server. Development of business reports. Jira, Kanban, WorkDay, ServiceNow, Jenkins, MS SSMS and MS Windows 10 environment.

Page 2 of 5

Sollers Consulting, Warsaw, Poland Senior IT Specialist Feb 2018 to Apr 2018 IT consulting contract. Insurance business sector. Upgrade of Guidewire framework. Obtained certification for Claim Centre 9 Configuration Specialist. Jira, Agile Scrum, Oracle, MS SQL Server, H2 DB, Windows 10 environment. Omtronix Engineering, Mississauga, ON, Canada, Database Developer and Analyst Apr 2005 to Dec 2016 Engineering Oracle 12 DBA, PL/SQL, Pro*C, and Powerbuilder developer. Database development supporting research and development of hardware and software solutions for industrial (mold, tool, die, aerospace, rapid prototyping) automation and DNC and CNC machining. Developed a framework of applications with Powerbuilder 12 on Windows frontend including: parts and equipment inventory database, research data analysis, simulation and reporting tool, marketing contacts and accounting/billing database. ESI Canada, Mississauga, ON, Canada, Oracle PL/SQL Developer Jul 2004 to Mar 2005 Dental and Pharmacy benefits management system. Maintenance of Dental Claims application. Visual Basic, Pro*C, PL/SQL, Tuxedo application servers and Oracle backend. HP Unix, MS Windows XP and Oracle 8 environment. RBC Insurance, Mississauga, ON, Canada, Oracle DBA and PL/SQL Developer Jul 2003 to May 2004 Marketing DBA, monthly data refresh (Home and Auto Insurance, Critical Illness Insurance and Travel Insurance)

(data upload with SQL*Loader), conversions and validations. Business logic PL/SQL code maintenance and new development of marketing reports (using SQL*Plus) and PL/SQL stored procedures validating data being migrated. Involved in data migration from Oracle to NCR Teradata data warehouse. Oracle 8i, MS Windows 2000 environment. Ministry of Natural Resources, Peterborough, ON, Canada, Systems Analyst Apr 2003 to May 2003 The OC ADS System project for integration between the CTT ADS IVR System and the OCIS database management system. Development of detailed functional specifications, programmer specifications, writing code, conducting unit tests. Oracle 8i, MS Windows NT 4, Pro*C, Vax/Open Vms environment. CFG, Mississauga, ON, Canada, DBA and Analyst/Developer Mar 2002 to Apr 2003 Oracle 9i database design, administration, maintenance, performance tuning on Linux, Sun Solaris Unix, MS Windows 2000 and Macintosh OS X platforms. Oracle software installations, upgrades and troubleshooting. Development of a Web-based publishing management system developed with Oracle Application Server, Workflow 2.6, IFS, Designer, JDeveloper 3, JSP, PL/SQL, SQL*Plus, Java, MySQL and CVS source code control system. AGF (CGI client), Toronto, ON, Canada, Database Analyst Aug 2001 to Mar 2002 Database performance tuning, SQL and PL/SQL code maintenance and optimisation of mutual funds applications: error correction of processed wire orders, XML based system processing wire orders, data amalgamation process. Oracle 8i and Unix HP environment. Data modeling with ERWin 3.5. Powerbuilder 7, Toad, SQL Navigator, StarTeam. Nortel Networks, Brampton, ON, Canada, Support Analyst and Developer Jul 2000 to Jul 2001 Oracle PL/SQL, Pro*C, Perl 5.6.1, Unix shell scripts code maintenance and optimisation of a corporate finance reporting system developed in-house. Migration from Oracle Financials 10 (HP Unix 10) to 11i (HP Unix 11). Re-write of business logic from Oracle Forms 4.5 to 6i. Data modelling with ERWin 3.5. Installation and configuration of Apache 1.3.19 Web server for a Web-enabled financial reporting application. Implementation of a global user authentication technique based on URL redirection scheme. Provided hotline technical support for production environments and users responding to emergency requests using Remedy ticket logging and tracking system. Toronto Dominion Bank, Toronto, ON, Canada, Oracle Database Analyst May 2000 to Jun 2000 Oracle software installation and configuration on Oracle 8.0.5 and IBM AIX 4.2 Unix back-end. News America Marketing, Norwalk, Connecticut, USA, Database Analyst Nov 1999 to May 2000 Oracle 7.3, PL/SQL code maintenance and enhancements of an in-store marketing analysis system. Powerbuilder 5 on MS Windows. Sun Solaris 5500 Unix server. Database performance tuning. Data modeling with ERWin 3.5. Page 3 of 5

Paratech Innovations, Mississauga, ON, Canada, Oracle DBA Oct 1999 to Feb 2000 Oracle 8i software installations, upgrades and troubleshooting on Unix (Sun Solaris 7, SGI Irix 6.5), MS Windows NT 4 and Macintosh OS 9. Database design and administration Development of Oracle PL/SQL stored procedures. Cott Beverages, Mississauga, ON, Canada, Oracle DBA and Analyst/Developer Dec 1998 to Nov 1999 Oracle 7.3 SQL (SQL*Plus ) and PL/SQL code maintenance and optimisation on HP Unix and NT 4 servers. Database administration, maintenance and performance tuning. Development of corporate business reports and POS application with Powerbuilder 6.5 on Windows 95. Y2K code maintenance. Allstate Insurance, Markham, ON, Canada, DBA and Analyst/Developer Oct 1997 to Dec 1998 Oracle 7.3 data warehouse design, administration and maintenance. Home and Auto and Travel Insurance data. Oracle SQL (SQL*Plus), PL/SQL and Pro*C code development and performance tuning on Digital Unix server. Development of an analysis system generating summarised insurance reports with PowerBuilder 5 on Windows 95. Implementation of a process feeding data (monthly and daily) into an Oracle data warehouse. Developed techniques maximising the process throughput. Data modelling with ERWin 3.5. CIBC Mellon Trust, Toronto, ON, Canada, Oracle Database Analyst Aug 1997 - Oct 1997 Oracle database design, administration, performance tuning. Oracle SQL (SQL*Plus) and PL/SQL development. DBA support for large group of PowerBuilder developers, coaching them through code optimisation process. AL’s Cartage, Kitchener, ON, Canada, DBA, Analyst, Developer Jun 1997 - Aug 1997 MS SQL Server 6.5 database design, maintenance and performance tuning on MS Windows NT 4 server. Development of a truck dispatch system in PowerBuilder 4 and Transact SQL. Implementation of a process migrating production data from a proprietary system into new MS SQL Server database. Optimisation of process throughput. Northern Telecom, Milton, ON, Canada, Database Analyst and Developer Dec 1996 - May 1997 Oracle 7.2 SQL*Forms 3.0, SQL (SQL*Plus), PL/SQL and Pro*C code maintenance, enhancements, and optimisation on HP Unix back-end. Developed techniques to boost performance in database and reporting module of the application. Development of a customs duty management and corporate finance reporting system. AGF Management Inc., Toronto, ON, Canada, Database Analyst and Developer Mar 1996 - Oct 1996 Oracle 7.2 SQL (SQL*Plus )and PL/SQL code maintenance and optimisation on Unix server. Development of a mutual funds inquiry application with PowerBuilder 5 on MS Windows 95. Optimisation of reporting process. 2020 Funds Inc., Oakville, ON, Canada, Database Developer and Analyst Jun 1994 - Mar 1996 Merged with AGF Management Inc. in March 1996. ButlerSQL databases design, administration and maintenance on Macintosh platform. Development of a mutual funds inquiry application in Prograph CPX on Macintosh with Cobol/ RPG and AS/400 back-end. Also development of a document workflow management program archiving scanned documents on optical jukebox in Prograph CPX with ButlerSQL database on Macintosh. KPMG Peat Marwick Thorne, Toronto, ON, Canada, Database Developer and Analyst Aug 1993 - Jun 1994 ButlerSQL database design, administration, and maintenance on Macintosh platform. Office automation application

(data sent PC to IBM mainframe via MS Mail server) in Prograph CPX with ButlerSQL database on Macintosh. Infonet, Toronto, ON, Canada, Programmer Analyst Feb 1993 - Aug 1993 Developed a phone banking application with Borland C++ and FoxPro on MS Windows 3.1, DecForms and VAX RDB database on VAX/VMS 5. GUI design, code optimisation in Borland C++ on PC and DecForms on VAX. Carswell, Scarborough, ON, Canada, Systems Analyst Apr 1991 - Feb 1993 BRS Search flat-text database design, administration and maintenance. Development of legal publishing applications in VAX DCL, BRS Scribe on VAX/VMS 4.5. GUI design in BRS Menu on VAX. Stockholm University of Technology, Sweden, Programmer Analyst Sep 1987 - Jun 1990 Research project at Electric Engineering Laboratory. Research and analysis, computer vision development in C language on VAX/VMS, road traffic image processing in LabView software on Macintosh. Page 4 of 5

--- EDUCATION ---

Master Degree in Electronics, Telecommunication Faculty, from Warsaw University of Technology in Poland.

--- PROFESSIONAL DEVELOPMENT

MS Azure Fundamentals course, Warsaw, Poland, 2020 Guidewire insurance framework course for Claim Centre 9 Configuration Specialist. Warsaw, Poland, 2018 Fast Track to PowerBuilder 5 at Visual Systems, Toronto, ON, Canada, 1996. Project Management Course at York University, Division of Executive Development, Toronto, ON, Canada, 1994. Page 5 of 5

Contact this candidate