Serhat Y.

Experience

• 

  Vodafone Turkey (Persona Consalting Company)

  Mar 2008 - Sept 2009

  Billing Operation Specialist

  Analyzing and solving the billing issuesProcessing CDR records on charging system and reporting the quantitiesMonitoring the database processes and analyzing the faultsProcess the mail order payments which arrives through contracted firmsDesigning and scheduling job flow charts for billing-cycle, dunning and MNP processesPrepare bills as hard copy by performing invoice-printing stepsManage the ftp infrastructure to deliver relevant files to users• Operational support for MNP (Mobile Number Portability) project• Ensure operational continuity when flood disaster occurs• Operational support for deployment of new database objects while switching from 2G to 3G Show less

• 

  Vodafone

  Sept 2009 - Apr 2012

  Data Warehouse Data Quality Specialist

  Preparing PL/SQL codes for automatic data quality controlsChecking the codes of new projects for the system compatibility Reviewing changes of ETL packages before the implementation stagePreparing customer reports by using SQL-PL/SQL blocksDetecting and solving problems in the systemOptimization of code for performance improvementsDefine job dependencies with making detailed analysis Taking overall responsibilities for analytics calculations (predictive models, segmentation etc.) Provide reliability of all data mining infrastructure Automate the jobs by using shell-scripting• Migration of database objects and data to Exadata system.• Upgrade for Oracle 10g to Oracle 11g• Transition to Oracle Data Integrator (ODI)• Service support for LBS (Location Based Services) project• Some Campaign Projects (Universal Control Group, Pontis, etc.) Show less

• 

  TTNET

  Apr 2012 - Aug 2015

  Business and System Analyst

  Responsibility of analyzing and project management activities of some application services vendor based products like EasyDone (Dunning), TTS (Collection), I-hope (Legal) and PCF (Payment module on FCBS). Focused on collection and dunning systems- Preparing resource and time planning of projects- Coordinating of project activities with all stakeholders- Collecting and analysing business requirements from customers- Creating technical solutions with high level design that is used to develop new features- Performing impact analysis of new project designs on the existing architecture.- Working as a solution architect in many projects- Planning of meetings with the integrator firm contacts, check over the firm’s documentation give comments and approval.- Assisting the solution team during implementation phase- Coordinating and supporting of integration tests and User Acceptance Tests (UAT)- Working as a Phase Leader or Project Manager in some projects.- Vendor management Show less

• 

  Turk Telekom

  Aug 2015 - now

  Senior Technical Business Analyst

  Working as a Project Manager (PM) or Product Owner (PO) on many projects Responsibility of analyzing and project management activities of some application services vendor based products like EasyDone (Dunning), TTS (Collection), I-hope (Legal) and PCF (Payment module on FCBS). Focused on collection and dunning systems- Preparing resource and time planning of projects- Coordinating of project activities with all stakeholders- Collecting and analysing business requirements from customers- Creating technical solutions with high level design that is used to develop new features- Performing impact analysis of new project designs on the existing architecture.- Working as a solution architect- Planning of meetings with the integrator firm contacts, check over the firm’s documentation give comments and approval.- Assisting the solution team during implementation phase- Coordinating and supporting of integration tests and User Acceptance Tests (UAT)- Vendor management Show less