Database Engineer

ZIKRI ASKIN INCE

Beaverton, OR ***** · 503-***-****

Interview Availability: 24-hour notice Start Availability: 3 to 4 days from offer

******@*****.*** · www.linkedin.com/in/zikri-askin-ince aince66 (skype)

Involved in application development in both private and government sectors. Participated in full life cycle product development from concept through delivery of a fully functioning product. Love to contribute to the team I am part of at whatever level needed.

Started with waterfall methodology and system development life cycle then worked in agile environments lately with more strict tracking, workflow and communication needs. Thinking critically and keeping it simple to avoid unnecessary complications are important to me. Love iterative development: like peeling layers of onion starting with the outermost then moving onto the next. Layer by layer the solution becomes more visible.

Keep track of latest changes in tools I use and see if they would be beneficial to the teams I am working with. I usually come up with innovative uses of new features giving me the edge.

Brain storming and thinking out loud are so beneficial for solving problems. Love to learn from others as well as sharing what I know with others since no one knows it all.

SUMMARY

•Senior Data Engineer with 10+ years of Application Development in both private and government sectors.

•Strong technical background including SQL, PL/SQL, Python, SSIS, ETL, GIT, Postman and more.

•Strong experience in full life cycle product development from concept through delivery.

•Bachelor’s degree in Engineering, completed credits needed for Master’s degree.

•Solid communication and team building skills with strong Agile/Scrum/SAFE knowledge/experience.

SKILL HIGHLIGHTS:

•Platforms: Windows 10/8/7/XP/98, Unix and Linux

•Database: Oracle, Postgres, SQL Server, MySQL, and SQLite

•Applications: Oracle CASE, Oracle Data Modeler, SQL Developer, PL/SQL Developer, TOAD,, Oracle Developer, Oracle Designer, ERWIN, SQL*Navigator, Python, Anaconda, Jupyter Lab and Notebooks, VS Code, Postman, Swagger, FME Workbench and Server (Informatica, Oracle Data Integrator, SSIS like ETL tool), Oracle Enterprise Manager, MIT Scratch, MS Access, MS Power Query, Eclipse, WebLogic, MS Visual Studio and ColdFusion

•Version Control: SVN, SVCS and Git

•Bug Tracking: Collabnet TeamForge and JIRA

•Other: Confluence, Microsoft Teams, Service Now.

EXPERIENCE

FEBRUARY 2020 – JULY 2020

CONTRACTOR, DATA MODELER, KAISER Permanente

Worked with the Membership Connect (KPMC) group to unite and replace several aging systems under a modernized microservice oriented application bringing Coverage & Demographics to support enrollments, member administration, and premium billing processes.

1.Followed already established processes to make changes to the model, publish them, and prepared “Alter Scripts”.

2.Prepared impact analysis documents for changes asked.

3.Participated in Data Migration sessions.

4.Helped migrating data from Membership Data Warehouse (MDW) to new Postgres microservice databases.

5.Tuned long running SQL.

6.Helped summarize migration documents (mapping) for off-shore development.

7.Reviewed microservice APIs and developed a data model for openAPI (aka swagger). Also reviewed Kafka and Splunk platforms.

JUNE 1997 – NOVEMBER 2019

CONTRACTOR, DATA ARCHITECT, usda forest service

Worked with the Natural Resource Manager (NRM) group of the Forest Service, on both internal and public facing projects and helped in all facets of database system development including user interfaces and business intelligence:

1.Prepared hand-off documents and held meetings for successful transition.

2.Built database structures for effortless data extraction from an OLTP system to support Executive Dashboards in USDA using PL/SQL. Started learning Tableau.

3.Provided support for few legacy applications (Oracle Fusion Middleware – Forms and Reports) as technical lead while their modernized versions are being constructed.

4.Helped migrate legacy data into modernized applications using FME and PL/SQL. Used Jasper, Power Query and MS Excel for reporting of results.

5.Ingested data from several authorities such as US Census, EPA and USGS using APIs they have published, and have run them through parsers to filter as needed to meet business requirements. Done this for both tabular and spatial data via FME.

6.Developed a framework to keep track of scripts executed, summary of results and details of errors using Oracle Data Modeler, SQL Developer and PL/SQL Developer.

7.Helped evaluate Database Change Capture and Replication tools “Oracle Golden Gate” and “Quest Shareplex”. NRM, Natural Resource Manager, purchased licenses for Oracle Golden Gate.

8.Evaluated a few SQL development and Database Modelling tools. Recommended adapting Oracle’s own and free tools: SQL Developer and Data Modeler.

9.Evaluated ETL tools (Informatica, FME, SSIS, Datastage). Team decided to choose FME for its spatial capabilities.

10.Participated in NRM database modernization pilot project. Brainstormed with other database developers to shape the future database solution architecture, maintained database schema for the pilot and developed a test data generation tool for load testing purposes.

11.Helped extract and load datasets including both tabular and spatial using PL/SQL.

12.Database architect for rebuilding of WRU, Water Rights and Uses, module. Tracked tasks with Collabnet’s TeamForge.

13.Implemented VPD, virtual private database, to merge application data stored in individual databases at the unit level into a single corporate database. Developed code to implement data access policy rules.

14.Helped other clients in private sector, in short term projects, with analysis of their needs for dynamic and personalized web interfaces, Oracle ERP implementations, web presence design using ColdFusion, data warehouse and custom bolt-on module development in Oracle eBusiness suite.

15.Developed SQL and PL/SQL scripts to automate code generation taking advantage of Oracle’s data dictionary.

16.Hired for expertise with Oracle Designer, fourth generation CASE, computer aided software engineering, product. Taken the lead developer role under the group’s DBA. Mentored fellow developers on Oracle Designer and provided support and governance as needed. Thoroughly involved from modelling thru its release and on-going maintenance over the years as FS computing architecture and Oracle products have continued to evolve.

SEPTEMBER 1996 – JUNE 1997

CONSULTANT, tower group international

This exporter had locations in Buffalo, NY; Seattle, WA and Detroit, MI.

1.Developed templates and libraries for 100% generation via Oracle Designer.

2.Designed and implemented a user management system for authorized access.

3.Helped build a “Customer Profile” system.

4.Designed and implemented both initial and daily data feeds (ETL) to a 3rd party accounting package from Enterprise Data Warehouse.

5.Trained and mentored other developers on new tools and systems.

JULY 1991 – SEPTEMBER 1996

SYSYTEMS ANALYST, esi technologies

This mid-size computer software company with distributors all around the world was one of the major competitors in small to mid-size ERP market.

1.Served as the project manager and the lead analyst for new product research and development.

2.Researched new technologies and developed the necessary infrastructure for future developments.

3.Analyzed requirements, developed data models, designed business functions and built 100% generated ERP applications using Oracle Designer and Developer.

4.Participated in pre-sales activities and demonstrated the product. Oracle development tools, and methodology used in product development.

5.Wrote product installation and technical training manuals.

6.Thought technical training classes for fellow teammates, customers and distributors.

7.

EDUCATION

JUNE 1989

MS, INDUSTRIAL ENGINEERING, Bogazici university (istanbul, turkey)

Completed required credits, started working on thesis work with advisor.

JUNE 1987

BS, AERONAUTICAL ENGINEERING, Istanbul TechNICAL University

SKILLS

Innovative thinker

Tenacious analytical person

Dedicated team player

Mentor

Leader

ACTIVITIES

Earlier in my career, I have attended and presented in Oracle Conference. Also co-authored a book “Oracle Designer Generation” ISBN: 0-07-882475-3.

Contact this candidate