$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Senior IT professional with extensive experience in C# and Oracle
Prashant Kotak
,
Bedford, United Kingdom
Experience
Other titles
Skills
I'm offering
Senior IT professional with extensive experience in a range of roles including Programmer, Analyst, Database Design/Coding, Solutions Architect and Team Lead. Proficient in C#, VB.NET, Oracle, VBA, SQL Server, MySql, C, Perl. Core expertise areas around databases: modelling, data analysis, coding, ETL, SQL, performance tuning, creating scalable n-tier systems. Experience of Banking, Telecoms, Retail, Utilities, Insurance. Strong at creating innovative solutions, integrating disparate systems and technologies and mentoring. Qualifications:
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - 2020
freelance
Software Developer - C#/Oracle
Sky.
- Content Supply Chain (CSC)
- Development, design and bug-fixing in BSS, the in-house platform for Rights
- C# - WCF, Winforms, WPF, Oracle PL/SQL/SQL development. Technologies: VS2015./2019 C#, Oracle 11g/12c, Messaging ActiveMQ and MSMQ
- Git, Jira, Bitbucket, Teamcity, Octopus, Agile
- Development, design and bug-fixing in BSS, the in-house platform for Rights
- C# - WCF, Winforms, WPF, Oracle PL/SQL/SQL development. Technologies: VS2015./2019 C#, Oracle 11g/12c, Messaging ActiveMQ and MSMQ
- Git, Jira, Bitbucket, Teamcity, Octopus, Agile
Wpf, Oracle PL/SQL, Teamcity, Software, Development, WinForms, Developer, WCF, Content, Design, Pl/sql, C, Agile, Jira, Oracle, Git, Sql
2016 - 2018
freelance
Oracle/Database Analyst/Developer
Kobalt Music.
- Creating a Data Sub-setting framework in PL/SQL.
- Harmonisation/synchronisation across production databases.
- Managing/manipulating high-volume data with PL/SQL, SQL and scripting, Multi-threading with DBMS_PARALLEL_EXECUTE. Performance tuning queries and code with pipelined functions, materialised views, partition-exchange, compression.
- Technologies: Oracle 12c, (Exadata and Amazon RDS AWS), Some DBA work, PL/SQL, Analytics, Built-In Packages, SQL*Loader, Impdp/Expdp, Toad, Git, Jira, Bitbucket
- Harmonisation/synchronisation across production databases.
- Managing/manipulating high-volume data with PL/SQL, SQL and scripting, Multi-threading with DBMS_PARALLEL_EXECUTE. Performance tuning queries and code with pipelined functions, materialised views, partition-exchange, compression.
- Technologies: Oracle 12c, (Exadata and Amazon RDS AWS), Some DBA work, PL/SQL, Analytics, Built-In Packages, SQL*Loader, Impdp/Expdp, Toad, Git, Jira, Bitbucket
Pl/sql, Multi-threading, Framework, Tuning, Production, Amazon, Analyst, Developer, Analytics, Sql, SoMe, Database, Scripting, Exchange, Jira, Oracle, AWS, Git
2015 - 2016
freelance
Oracle Data warehouse Developer in the MI Team
Chubb Insurance.
- Core project-work was generating data to feed the regulatory reporting Solvency II package SIIAssist, and to generate associated user-reports for the business.
- Data population of new base tables from staging using PL/SQL ETL (processing, and extraction) via complex views, tokenized using Oracle PIVOT/UNPIVOT, processing in PL/SQL to generate XML/CSV.
- Participated in the regular work-stream of enhancements and fixing defects in the EMIR data mart.
- Excel VBA automation to create quarterly Lloyds submissions/extracts for the Finance team.
Technologies: Oracle 11g PL/SQL and SQL (including extensive use of Analytic functions), Data warehouse ETL, PL/SQL Developer, FSAssist/SIIAssist, Subversion, Jira, SQL Developer, UNIX scripting, Excel VBA.
- Data population of new base tables from staging using PL/SQL ETL (processing, and extraction) via complex views, tokenized using Oracle PIVOT/UNPIVOT, processing in PL/SQL to generate XML/CSV.
- Participated in the regular work-stream of enhancements and fixing defects in the EMIR data mart.
- Excel VBA automation to create quarterly Lloyds submissions/extracts for the Finance team.
Technologies: Oracle 11g PL/SQL and SQL (including extensive use of Analytic functions), Data warehouse ETL, PL/SQL Developer, FSAssist/SIIAssist, Subversion, Jira, SQL Developer, UNIX scripting, Excel VBA.
Data Warehouse, Processing, Regulatory, Developer, Finance, Pl/sql, Subversion, VBA, ETL, Sql, Scripting, Unix, Automation, XML, Jira, Oracle, Excel
2015 - 2015
freelance
Oracle Developer in the Fixed Income and FX Team
BNP Paribas Bank.
- Coding new functionality and bug fixing in PL/SQL and C/C++ in the FXO engine.
- Coding enhancements to the Swift message processing engine and the Confirmations engine
- Developing/enhancing reports using PL/SQL and SQL.
Technologies: Oracle 11g, PL/SQL, Subversion, Jira, Linux, Python, C/C++, Eclipse, VMS DCL.
- Coding enhancements to the Swift message processing engine and the Confirmations engine
- Developing/enhancing reports using PL/SQL and SQL.
Technologies: Oracle 11g, PL/SQL, Subversion, Jira, Linux, Python, C/C++, Eclipse, VMS DCL.
Sql, Python, Linux, Swift, Oracle, Jira, C, Subversion, Pl/sql, Eclipse, Developer, Processing
2014 - 2015
freelance
(low cost broker) in Canary Wharf
Selftrade.
Position: Rapid Application Developer in the KYC team (regulatory reporting).
- Developed ACD, a workflow application for managing the KYC status of customers in Winforms
- Designed/managed the ACD database (Oracle 11g) for storing KYC data and workflow
- Developed and maintained a number of small subsidiary applications for the KYC workflow: Batching, Scanning, SOW Destruction, KYC QA, Compliance management etc. in WPF
- Developed a number of live Excel MI reports, to track the status of the KYC project and generate mass letters/emails to customers requesting KYC related details (Excel VBA automation)
- Took over and maintained the Transaction Reporting project (reporting trades to Unavista and the FCA)
Technologies: VS 2102, .NET 4.5, C#/VB.NET, WinForms, WPF (MVVM), Entity Framework, WCF, Web API/MVC4 REST Services, Excel VBA, Oracle 11g PL/SQL, ETL, Data Cleansing, SOLID principles, TDD (xUnit), LINQ/Lambda, Enterprise Architect (UML, Database design).
- Developed ACD, a workflow application for managing the KYC status of customers in Winforms
- Designed/managed the ACD database (Oracle 11g) for storing KYC data and workflow
- Developed and maintained a number of small subsidiary applications for the KYC workflow: Batching, Scanning, SOW Destruction, KYC QA, Compliance management etc. in WPF
- Developed a number of live Excel MI reports, to track the status of the KYC project and generate mass letters/emails to customers requesting KYC related details (Excel VBA automation)
- Took over and maintained the Transaction Reporting project (reporting trades to Unavista and the FCA)
Technologies: VS 2102, .NET 4.5, C#/VB.NET, WinForms, WPF (MVVM), Entity Framework, WCF, Web API/MVC4 REST Services, Excel VBA, Oracle 11g PL/SQL, ETL, Data Cleansing, SOLID principles, TDD (xUnit), LINQ/Lambda, Enterprise Architect (UML, Database design).
Regulatory, UML, WCF, Compliance, Net, Workflow, LINQ, Developer, WinForms, MVVM, REST services, TDD, SOLID, Web, Lambda, XUnit, Enterprise, Vb, KYC, Framework, Just 4.5, ETL, Sql, Excel, .Net, API, Oracle, Automation, Database, REST, C, Design, VBA, Vb.net, Entity Framework, Pl/sql, Database design, Wpf, Management, QA, Web API
2013 - 2014
freelance
Analyst/Developer in Credit Cards/Core Systems/Client and Development Services
Royal Bank of Scotland (Credit Cards), Aldgate Union.
London
Position: Analyst/Developer in Credit Cards/Core Systems/Client and Development Services
- Analysed existing credit card mainframe screen-scraping code-base built in VBA and VB6 on Attachmate Extra, a terminal emulator screen-scraping engine with VBA and VB6 (OCX) interfaces.
- Analysed options for replacement. Proposed replacement solution of Reflection 2014 (which has .NET and Web interfaces as well as supporting legacy). Built prototypes to verify that all existing VBA and VB6 code could be successfully ported to the proposed framework
Technologies: VBA, .NET, Visual Studio, VB6/VBS, Oracle 10g, Attachmate Extra and Reflection, UML.
Position: Analyst/Developer in Credit Cards/Core Systems/Client and Development Services
- Analysed existing credit card mainframe screen-scraping code-base built in VBA and VB6 on Attachmate Extra, a terminal emulator screen-scraping engine with VBA and VB6 (OCX) interfaces.
- Analysed options for replacement. Proposed replacement solution of Reflection 2014 (which has .NET and Web interfaces as well as supporting legacy). Built prototypes to verify that all existing VBA and VB6 code could be successfully ported to the proposed framework
Technologies: VBA, .NET, Visual Studio, VB6/VBS, Oracle 10g, Attachmate Extra and Reflection, UML.
Oracle, VBA, Visual Studio, UML, Net, Mainframe, Developer, Analyst, Development, Web, Framework
2012 - 2013
freelance
C# .NET SQL Developer
Barclays Global Payments (through Consultancy NMQA).
The project was to create a system (called the DIMU/DIS) for storage, search and delivery of account and transaction (SWIFT) data, in a Banking Payments landscape with a large number of data-holding systems, and Payments Engines GPP and AFTS. Created processes to interface to the GPP and AFTS databases to extract relevant data into the DIS database
. Data could then be delivered into enterprise test tools like GreenHat/Rational Integration Tester by the application making REST calls into DIMU/DIS web services. The solution was built in C#, with SQL Server as the workflow database and an Oracle data-warehouse repository of account and transaction data from systems in the Payments landscape.
- Designed the DIS database (Oracle 11g warehouse) with an EF model and WCF services for structured representation and storage of Payments landscape data
- Designed the DIMU database (SQL Server 2008) with EF model and WCF services, for managing the process of test data searching and delivery.
- Coded a large .NET solution (60+ projects) for accessing and managing the DIS and DIMU databases with Entity Framework, WCF services and WinForms front-end.
- Created a multi-threaded data loading harness in PL/SQL for populating the DIS data repositories with volume account and transaction data from the banking landscape.
Technologies: Visual Studio 2010 and 2012, .NET 4.0, C#, LINQ/Lambda, Entity Framework, WCF services including SOAP/XML, OData Data Services (REST), and Web API/MVC4 REST Services delivering JSON, schema design on SQL Server 2008 and Oracle 11g PL/SQL and T-SQL, ETL, performance tuning, Interfacing to and extracting data from payments systems GPP and AFTS. Complex UI developed in WinForms using Model-View-Presenter, started to migrate this to WPF/MVVM, Windsor IOC, AutoMapper, ODataLib, SOLID principles, GoF Design Patterns, TDD (nUnit, Moq), SVN, Enterprise Architect (UML, Data Modelling).
. Data could then be delivered into enterprise test tools like GreenHat/Rational Integration Tester by the application making REST calls into DIMU/DIS web services. The solution was built in C#, with SQL Server as the workflow database and an Oracle data-warehouse repository of account and transaction data from systems in the Payments landscape.
- Designed the DIS database (Oracle 11g warehouse) with an EF model and WCF services for structured representation and storage of Payments landscape data
- Designed the DIMU database (SQL Server 2008) with EF model and WCF services, for managing the process of test data searching and delivery.
- Coded a large .NET solution (60+ projects) for accessing and managing the DIS and DIMU databases with Entity Framework, WCF services and WinForms front-end.
- Created a multi-threaded data loading harness in PL/SQL for populating the DIS data repositories with volume account and transaction data from the banking landscape.
Technologies: Visual Studio 2010 and 2012, .NET 4.0, C#, LINQ/Lambda, Entity Framework, WCF services including SOAP/XML, OData Data Services (REST), and Web API/MVC4 REST Services delivering JSON, schema design on SQL Server 2008 and Oracle 11g PL/SQL and T-SQL, ETL, performance tuning, Interfacing to and extracting data from payments systems GPP and AFTS. Complex UI developed in WinForms using Model-View-Presenter, started to migrate this to WPF/MVVM, Windsor IOC, AutoMapper, ODataLib, SOLID principles, GoF Design Patterns, TDD (nUnit, Moq), SVN, Enterprise Architect (UML, Data Modelling).
Web, WCF, Banking, Net, Workflow, LINQ, Developer, WinForms, MVVM, NUnit, REST services, Storage, SOLID, UML, Server, Search, Lambda, Enterprise, SVN, Patterns, Tuning, Framework, MOQ, Processes, Sql server 2008, Design Patterns, Sql, API, SQL Server, Swift, Oracle, JSON, XML, UI, Database, REST, C, ETL, Design, Entity Framework, Pl/sql, Web Services, Visual Studio, Wpf, Integration, SOAP, T-SQL, Test, Web API, TDD
2011 - 2012
freelance
C# and Oracle PL/SQL Developer
Syniverse Technologies.
- Designed and coded the Flexible Invoicing core process in FCSS (Financial Clearing and Settlement System) to allow mobile operators to group together and produce single composite invoices for multiple roaming partners.
- Created specifications for and coded the automation of the Billing Interface, the process for generating the feed to the billing system.
- Coded the "Document Receive" component of the Document Capture process, which receives incoming invoices from vendors and feeds into FCSS.
- Test driven development using NUnit and NMock
Technologies: C, C++, XML,, Oracle 10g and 11g PL/SQL.
- Created specifications for and coded the automation of the Billing Interface, the process for generating the feed to the billing system.
- Coded the "Document Receive" component of the Document Capture process, which receives incoming invoices from vendors and feeds into FCSS.
- Test driven development using NUnit and NMock
Technologies: C, C++, XML,, Oracle 10g and 11g PL/SQL.
Sql, Oracle, XML, Automation, C, Pl/sql, Test, Developer, NUnit, Development, Oracle PL/SQL, NMock
2010 - 2011
freelance
.NET/SQL Server/Winforms/WinMobile Developer
Vennsys Consortium Smart Metering.
on the Smart Metering Project for Thames Water.
- Producing design documents from the requirements specification supplied by business analysts
- Coding new functionality in JTE in VB.NET, a system used by utility companies for managing property visits. Coded Winforms front-ends in VB.NET, wrote T-SQL stored procedures on SQL Server 2005 DB.
- Created interfaces to an ArcServer based online Map server to add online maps to the scheduling system.
- Created interface to the Traffic Management Authority (TMA) communicating with Insight (Symology) Gazetteer and Works web services for the application of road dig notices.
- Enhanced SSIS packages communicating with Routestar (external system) web service data feed into JTE.
- Developed a number of cutover scripts using SSIS, reading Excel input cutover files to facilitate data migration from legacy systems.
Technologies: VB.NET, SQL Server 2005, Visual Studio 2008 Team Foundation Server, Winforms with DevExpress controls, Web Services, Services, ETL using SSIS, Enterprise Architect (UML), C#, Windows 2003/2008.
- Producing design documents from the requirements specification supplied by business analysts
- Coding new functionality in JTE in VB.NET, a system used by utility companies for managing property visits. Coded Winforms front-ends in VB.NET, wrote T-SQL stored procedures on SQL Server 2005 DB.
- Created interfaces to an ArcServer based online Map server to add online maps to the scheduling system.
- Created interface to the Traffic Management Authority (TMA) communicating with Insight (Symology) Gazetteer and Works web services for the application of road dig notices.
- Enhanced SSIS packages communicating with Routestar (external system) web service data feed into JTE.
- Developed a number of cutover scripts using SSIS, reading Excel input cutover files to facilitate data migration from legacy systems.
Technologies: VB.NET, SQL Server 2005, Visual Studio 2008 Team Foundation Server, Winforms with DevExpress controls, Web Services, Services, ETL using SSIS, Enterprise Architect (UML), C#, Windows 2003/2008.
Service, SQL Server 2005, Vb, Team Foundation Server, Online, Enterprise, Server, Web, WinForms, Developer, Net, Ssis, UML, Windows, Design, Stored procedures, T-SQL, Management, Visual Studio, Web Services, Vb.net, ETL, C, SQL Server, .Net, Excel, Sql
2005 - 2010
job
Permanent, shareholding partner
Supplenta Ltd.
Position: Solution Designer/Programmer/Development Manager.
- Architecting, specifying and coding solutions; managing a team of 6 developers our office in India.
- Designed and developed several large client/server applications which are widely deployed with customers.
- Jointly created Call Manager, a full call-centre system with a predictive dialler, based on Asterisk, utilising complex multi-threading in Perl and C and a web front-end for agent and admin applications.
- Re-designed and migrated Call Manager, from Perl and C on Linux into .NET with an ASP.NET UI. Designed the database, coded many of the modules and built the reporting system of the original system on Linux. Managed a team of developers and coded some of the core modules (C#).
- Designed and coded CIAS, a distributed IVR Lock Management system of Cencon ATM locks used by Coop Bank and National Australia Bank. Coded in .NET (VB.NET, Winforms, Silverlight), with an Oracle database, using Remoting, MSMQ, PL/SQL and Apex.
- Architected R2G, a Portal and PDA client/server solution with a SQL Server 2005 database, for inventorying properties with a WinCE Windows Mobile 6 PDA app and sending media back to the Portal server-side for auto-generating the property inventory report; also coded some of the modules.
- Developed many other smaller programs and solutions, and maintained several older applications written in VB6, C, Microsoft Access and Excel VBA.
Technologies: Windows 2003/2008 Server, Linux, Visual Studio 2005 and 2008, VB.NET, C#, C, COM Interop, Remoting, IIS Web Services, ADO.NET, Winforms & WPF, ASP.NET & WebForms, MSMQ, Multi-threading, XML, VB6, Perl, Mysql, Oracle 10g, PL/SQL, SQL Server, T-SQL, Triggers, Web Services, Services, Silverlight, Bash scripting, Asterisk Open Source switch, WinCE, Windows Mobile 6, HTML, JavaScript, AJAX, JQuery.
- Architecting, specifying and coding solutions; managing a team of 6 developers our office in India.
- Designed and developed several large client/server applications which are widely deployed with customers.
- Jointly created Call Manager, a full call-centre system with a predictive dialler, based on Asterisk, utilising complex multi-threading in Perl and C and a web front-end for agent and admin applications.
- Re-designed and migrated Call Manager, from Perl and C on Linux into .NET with an ASP.NET UI. Designed the database, coded many of the modules and built the reporting system of the original system on Linux. Managed a team of developers and coded some of the core modules (C#).
- Designed and coded CIAS, a distributed IVR Lock Management system of Cencon ATM locks used by Coop Bank and National Australia Bank. Coded in .NET (VB.NET, Winforms, Silverlight), with an Oracle database, using Remoting, MSMQ, PL/SQL and Apex.
- Architected R2G, a Portal and PDA client/server solution with a SQL Server 2005 database, for inventorying properties with a WinCE Windows Mobile 6 PDA app and sending media back to the Portal server-side for auto-generating the property inventory report; also coded some of the modules.
- Developed many other smaller programs and solutions, and maintained several older applications written in VB6, C, Microsoft Access and Excel VBA.
Technologies: Windows 2003/2008 Server, Linux, Visual Studio 2005 and 2008, VB.NET, C#, C, COM Interop, Remoting, IIS Web Services, ADO.NET, Winforms & WPF, ASP.NET & WebForms, MSMQ, Multi-threading, XML, VB6, Perl, Mysql, Oracle 10g, PL/SQL, SQL Server, T-SQL, Triggers, Web Services, Services, Silverlight, Bash scripting, Asterisk Open Source switch, WinCE, Windows Mobile 6, HTML, JavaScript, AJAX, JQuery.
Office, Management, Oracle database, T-SQL, Bash, Perl, Windows, Net, Open source, IIS, WinForms, Development, Client/server, Wpf, Web, Server, App, Asterisk, Vb, Portal, Silverlight, Manager, Multi-threading, Agent, SQL Server 2005, UI, Html, Mysql, Sql, Jquery, Excel, .Net, Linux, HTML/CSS/Javascript, SQL Server, ASP.NET, Oracle, XML, Javascript, Scripting, Database, C, SoMe, VBA, AJAX, Vb.net, Pl/sql, ASP, Web Services, Visual Studio
2004 - 2004
freelance
Oracle Developer for Geneva Enterprise Billing
Convergys Emea Ltd.
- Coding PL/SQL and Pro*C on the Geneva Enterprise Billing platform.
- Writing bill generators and post-processors with complex billing business rules.
- Bug fixing and designing and writing Regression tests (including test harnesses) in C, bash, a little Java.
- Writing, reviewing and updating of functional, design and test documentation.
- Development DBA tasks like creating, importing and exporting Database schemas etc.
Technologies: Windows 2000, UNIX (AIX, HPUX and Solaris) Oracle 9i, PL/SQL, Pro*C, shell scripting, Java
- Writing bill generators and post-processors with complex billing business rules.
- Bug fixing and designing and writing Regression tests (including test harnesses) in C, bash, a little Java.
- Writing, reviewing and updating of functional, design and test documentation.
- Development DBA tasks like creating, importing and exporting Database schemas etc.
Technologies: Windows 2000, UNIX (AIX, HPUX and Solaris) Oracle 9i, PL/SQL, Pro*C, shell scripting, Java
C, Enterprise, Aix, Development, Developer, Windows, Bash, Test, Pl/sql, Design, Database, Scripting, Unix, Oracle, Writing, Java, Sql
2003 - 2003
freelance
Oracle, Por*C and VB ETL Analyst/Programmer
INVESCO Perpetual.
- Coding data extracts using PL/SQL and Pro*C from specifications.
- Generating Pensions regulatory reports and letters using Excel and Word Automation.
- Coding modules and scripts for migration from the Scottish Life Pensions system to Aquila.
- Writing Technical and Design specifications for generating regulatory reports and extracts from the Oracle based Aquila Administrator Pensions System.
Technologies: Windows 2000, NT4, UNIX (IBM AIX), Oracle 8i and 9i, PL/SQL, Pro*C, Excel and Word Automation using VBA and VBScript, Wscript/Cscript.
- Generating Pensions regulatory reports and letters using Excel and Word Automation.
- Coding modules and scripts for migration from the Scottish Life Pensions system to Aquila.
- Writing Technical and Design specifications for generating regulatory reports and extracts from the Oracle based Aquila Administrator Pensions System.
Technologies: Windows 2000, NT4, UNIX (IBM AIX), Oracle 8i and 9i, PL/SQL, Pro*C, Excel and Word Automation using VBA and VBScript, Wscript/Cscript.
VBA, Vb, Administrator, Aix, Regulatory, Analyst, Vbscript, Windows, Pl/sql, Word, Design, ETL, C, Unix, Automation, Oracle, Writing, Excel, Sql
2000 - 2002
freelance
Oracle PL/SQL/C Programmer and Retek Consultant
CSC Inc.
- Performance tuned many long-running back-end PL/SQL and C modules in Retek RMS and RDW.
- Designed and coded (in Pro*C and PL/SQL) the complete solution to implement new Contracts functionality with complex business rules for RMS.
- Did the Business analysis, specification and then architected the Franchise Stock Planning solution
- Provided the architectural steer for the RDW Reclass project (Product hierarchy items reclassified to different departments) and coded several modules. Co-ordinated Unit and Integration testing.
Technologies: Retek Merchandising System (RMS), Retek Data warehouse (RDW), Windows 2000, NT4, UNIX (Sequent Dynix and AIX), Oracle 8 and 8i, PL/SQL, Pro*C, Shell Scripting, UNIX multi-threading in C, Oracle 9i.
- Designed and coded (in Pro*C and PL/SQL) the complete solution to implement new Contracts functionality with complex business rules for RMS.
- Did the Business analysis, specification and then architected the Franchise Stock Planning solution
- Provided the architectural steer for the RDW Reclass project (Product hierarchy items reclassified to different departments) and coded several modules. Co-ordinated Unit and Integration testing.
Technologies: Retek Merchandising System (RMS), Retek Data warehouse (RDW), Windows 2000, NT4, UNIX (Sequent Dynix and AIX), Oracle 8 and 8i, PL/SQL, Pro*C, Shell Scripting, UNIX multi-threading in C, Oracle 9i.
Sql, Business Analysis, Oracle, Contracts, Unix, Scripting, Data Warehouse, C, Pl/sql, Integration, Windows, Testing, Aix, Oracle PL/SQL, Contracts, Multi-threading
2000 - 2000
freelance
Oracle DBA and Analyst/Programmer, on Project Blue" (Internet based Estate Agency)
Anderson Consulting.
- Development DBA (Oracle 8i), managing several databases and responsible for improving application performance when accessing the database.
- Developed a PL/SQL Package library of stored procedures to provide uniform access to the data.
- Wrote an Access97 and Excel based Report Generation program in VBA which interfaced with Oracle, and pulled data on a nightly feed for the Finance group.
- Developed a utility, similar to SQL Loader, written in C using OCI, to load JPEG files and other binary data into the database.
Technologies: Windows 2000, NT4, UNIX (Solaris), Oracle 8i, PL/SQL, Pro*C, OCI, Shell Scripting, C, Oracle 9i (evaluation), VB6, VBA, ODBC, Oracle Objects for OLE.
- Developed a PL/SQL Package library of stored procedures to provide uniform access to the data.
- Wrote an Access97 and Excel based Report Generation program in VBA which interfaced with Oracle, and pulled data on a nightly feed for the Finance group.
- Developed a utility, similar to SQL Loader, written in C using OCI, to load JPEG files and other binary data into the database.
Technologies: Windows 2000, NT4, UNIX (Solaris), Oracle 8i, PL/SQL, Pro*C, OCI, Shell Scripting, C, Oracle 9i (evaluation), VB6, VBA, ODBC, Oracle Objects for OLE.
Sql, Excel, Oracle, Unix, Scripting, Database, C, VBA, Pl/sql, Finance, Stored procedures, Windows, Analyst, Development, Internet, Oracle dba
2000 - 2000
freelance
Oracle Analyst/Programmer / UNIX C Programmer
T-Mobile.
working on the Up2You system.
- Wrote half of the Transaction Manager, a 30000 line C program that receives Call transaction details from a memory resident database and feeds them into an Oracle Database, using multi-threading with pthreads.
- Wrote a suite of services in C using OCI (Oracle Call Interface), appropriate for p-thread based multi-threading. Porting of historical data from Oracle 7.3 to Oracle 8i, utilising partitioned-table technology and also ported a number of programs, modules and reports.
Technologies: Windows 2000, NT4, UNIX (HPUX), Oracle 8 and 8i, PL/SQL, Pro*C, OCI, Shell Scripting, C, UNIX Systems Programming (POSIX, multi-threading, LWPs, pthreads, Shared Memory, Sockets)
- Wrote half of the Transaction Manager, a 30000 line C program that receives Call transaction details from a memory resident database and feeds them into an Oracle Database, using multi-threading with pthreads.
- Wrote a suite of services in C using OCI (Oracle Call Interface), appropriate for p-thread based multi-threading. Porting of historical data from Oracle 7.3 to Oracle 8i, utilising partitioned-table technology and also ported a number of programs, modules and reports.
Technologies: Windows 2000, NT4, UNIX (HPUX), Oracle 8 and 8i, PL/SQL, Pro*C, OCI, Shell Scripting, C, UNIX Systems Programming (POSIX, multi-threading, LWPs, pthreads, Shared Memory, Sockets)
Sql, Oracle, Unix, Scripting, Database, C, Pl/sql, Oracle database, Windows, Technology, Analyst, Manager, Multi-threading
1995 - 1998
job
Team Leader/Senior Systems Programmer. C, Oracle, VB/VBA, Team Lead
Retail Business Solutions Ltd.
Oracle, C, VBA, Vb
1994 - 1995
job
Software Engineer
Santa Cruz Operation.
Writing device-drivers into SCO UNIX, C, UNIX, bash
Writing, Unix, C, Bash, Software
1990 - 1994
job
Software Engineer
Datafit Ltd.
Writing Systems software and device drivers in C and QAB (4GL).
Writing, C, Software
1988 - 1990
job
Technologist. Writing support and diagnostic software in DAL, BCPL and OCCAM
Inmos Ltd.
Writing, Support, Software
1987 - 1987
job
Hardware/Software Development Engineer
Meterquest Ltd.
Programming in 'C' and providing hardware support for and coding for PC Graphics cards designed around the Hitachi ACRTC-63484 chip.
Software development, C, Support, Hardware, Development, Software, PC
1986 - 1986
freelance
Occasional freelance programming
DI-AN Microsystems.
for DI-AN Microsystems writing hardware drivers for the IBM PC.
Writing, Hardware, PC
1985 - 1986
temp
Part-time Teaching Assistant
EE&E Dept., Univ. of Manchester, Institute of Science and Technology.
Employed by the University of Manchester as a Part-Time Teaching Assistant in the E.E & E Dept. I supervised undergraduates during lab sessions.
Teaching
My education
1983
-
1988
University of Manchester Institute of Science and Technology
Doctorate, ATE Design for VLSI Testing
Doctorate, ATE Design for VLSI Testing
1982
-
1983
University of Manchester Institute of Science and Technology
MSc, Integrated Circuit System Design
MSc, Integrated Circuit System Design
1979
-
1982
University of Kent at Canterbury
BSc (Upper second (2.1), Computer Science and Cybernetics
BSc (Upper second (2.1), Computer Science and Cybernetics
Prashant's reviews
Prashant has not received any reviews on Worksome.
Contact Prashant Kotak
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Prashant directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark