We provide IT Staff Augmentation Services!

Sr Oracle Python Developer Resume

New, YorK

SUMMARY:

  • Having around 11 years of Software Development & support experience on Challenging, mission critical and client facing Oracle based investment banking projects (Derivatives, Credit risk, Liquidity risk, Regulatory reporting - Dodd Frank, EMIR, Deal Pricing and valuation, Forex & ICE Clearing flows ), which includes experience as a Lead Developer.
  • 2 Years of programming experience in Python 3.x
  • Strong exposure to Agile Environment and methodologies.
  • Provide estimates to the Users stories and establish pre-requisites and dependencies.
  • Participate in Incident Management Undertake Complex production issues.
  • Python 3.x development in Object oriented programming as well as ad-hoc scripting.
  • Participate Production Incident meetings. Identify and mitigate gaps in Release and change management and place effective quality controls.
  • Developed Python ETL services to for data loading, file parsing and capturing audit data.
  • Database Tuning/application tuning and Performance Monitoring.
  • Configured SQL Loader - Direct Path Loads, Parallel Load for Bulk data uploads from external systems.
  • Hands on knowledge in UNIX commands and Shell Scripting.
  • Developing new Data Purge strategies and archive the historical data.
  • Analysis of new Enhancements / Change requests/functionality changes and provides accurate estimates / man hours.
  • Creating Test Plans for Major software change Release / Enhancement and UAT.
  • Co-ordinating with Off-shore development team on weekly basis to accomplish smooth transition of software upgrades.
  • Co-ordinate with Partner systems on Integration issues.
  • Involve in Capacity Planning.
  • EOD Batch Support and trouble shooting.
  • Participate in CAB (Change approval board) meeting to promote UAT RFCs to production.

TECHNICAL SKILLS:

Python: 3.x, SQL, PL/SQL, Core java 1.6

Database: Oracle 12c, 11g, 10g

Operating System: Unix, Windows

Database IDE Tools: Toad 10, PL/SQL Developer 9, SQL Navigator

Scripting Languages: HTML, XML, Java Script, Unix Shell Scripting, bash, AWK

Version Controlling Tools: Tortoise SVN, VSS, WINCVS, Serena Dimensions

Control M: AUTOSYS, TWS, IBM MQ series

ETL Tools: INFORMATICA PowerCenter 9

Python libraries: NumPy, SciPY, Pandas

Misc. Tools: Putty, Tectia, Splunk, BMC Remedy, Jupyter notes, Confluence, JIRA, ITRS Geneos

PROFESSIONAL EXPERIENCE:

Confidential - New York

Sr Oracle Python Developer

Responsibilities:

  • Python & Oracle development within Regulatory reporting and Liquidity risk space.
  • Used numpy, scipy, Pandas libraries.
  • Developed the Liquidity Risk Batch monitor to control the sequence of data loading and processing in Python, Oracle, XML
  • ETL of numerous incoming feeding from Enki, Citadel, Plato etc.
  • Analyzed the existing assets data loading and data processing which was taking 1 week and reduced it to 1 day by applying oracle exchange partitions thus saving significant support budget for the bank.
  • Technical stake holder for Assets data stream.
  • Extensive PL/SQL development in US 5g regulatory reporting.
  • Created a new Python service by replacing the legacy DOS service for data loading.
  • Effectively Used Python Lists, Dictionaries, Queues.
  • Involved in Oracle performance tuning of data processing batch programs using AWR, Explain plan and Oracle tuning advisories.
  • Provide 3rd line Production support, root cause analysis and document issues in Confluence /Wiki.

Tools: Python 3.x, Oracle 12c, SQL, PL/SQL, XML, C#, Visual Studio

Confidential

Sr Database Developer -ETL

Responsibilities:

  • Technical SME and component lead for combined data mart (CDM CH)
  • Designed and developed APIs Using Oracle11g PL/SQL.
  • Created micro python service for data ingestion Python shutil.
  • Migrated existing Unix shell scripts to Python 3.
  • Oracle PL/SQL Development with Informatica 9.6 and Control M 7.x using best optimization techniques.
  • Utilized python list comprehension and lambda expressions effectively and confirmed code to PEP8 standard.
  • Resolve issues related to Control M, Unix shell scripting, Oracle PL/SQL and Informatica on Production environment.
  • Developed DAO functions in python using cx Oracle package.
  • End to End application development right from ingesting the data feeds from upstream, Extraction, transformation and loading, Data enrichment using PL/SQL and python.
  • SME for Combined data mart application which stores IB and PB data which is then exposed to Axiom GUI.
  • Perform Production support, UAT Support, Change management and development activities.

Tools: Python 3.x, Oracle 11g, SQL, PL/SQL, Numpy, Scipy, Pandas, Jupiter notes, PyCharm 4, Informatica 9.6, Control M 9.x, Unix shell scripting

Confidential

Sr Database Developer

Responsibilities:

  • Designed and developed DB and APIs for Legal linkage entity program, Dodd Frank regulatory reporting, Marketwire Trade division, ICE clearing flows.
  • Analyze BRDs and prepare Technical design documents and develop the DB APIs and java middle tier components.
  • Developed new Oracle 11g DB APIs and Java DAO methods and Junit tests.
  • Implemented TDD (Test driven development) using UT PL/SQL procedures to test the new DB APIs and cucumber for java tasks.
  • Developed multi session parallel jobs for data manipulation via Unix shell scripts to get the best performance.
  • Reengineered (Derivatives Trading Platform) DTD Application to bring the storage cost of the bank’s Trade management to half million USD per annum.
  • Worked with Marketwire teams to develops new DB XML Schemas and its corresponding DB Objects (tables, views, packages, DML Scripts) to support the framework.
  • Developed new DB APIs to support ICE clearing house messages.
  • Designed and developed DB APIs for Also bulk uploader file extracts.
  • Solo DB Developer for an Agile team of 9 members.
  • Involved in Agile story refinement sessions with BAs and Product owners to get a clear understanding of requirements.
  • Bug fixed Trade/book migration and TriOptima Scripts.
  • Archived data into Rainstor from Oracle and involved in archive schema designs and logical and physical data modelling and data mappings.

Tools: Oracle 11g, SQL, PL/SQL, RAC, Java, Junit, XML, XSLT, XQuery, PL/SQL Developer, Toad, Rainstor, MS SQL Server 2012, Crystal reports, Tectia, Splunk, SNOW, BMC Remedy

Confidential

Associate

Responsibilities:

  • Developed Oracle PL/SQL APIs for Liquidity risk reporting framework.
  • Participated in Requirement gathering and involved in Preparing FS/ Technical design Specifications (TDS documents).
  • Developed PL/SQL packages to perform GL reconciliations.
  • Prepare Technical Design documents and Process flow charts.
  • Extensive experience in implementing & developing SQL in PL/SQL procedures and Packages.
  • Creating procedures, functions, database triggers and cursors/Ref Cursors.
  • Trouble shooting of Database live issues, Code modifications, Providing Data Patches in production environment that comes in day to day activity.
  • Used Oracle 11g new feature such as referential partitioning, composite partitioning, and cross-session PL/SQL result caching etc., which improved the application performance
  • Using optimizer HINTS and improving the performance of QUERIES.
  • Dumping the data from flat files or excels into data base tables using SQL Loader with best techinique’s to improve the speed of loading.
  • Importing and exporting the table data from one schema to anther schema using Oracle Data Pump, Import/Export.
  • Attain Seamless QA and UAT sign off by following release cycle process and delivery of the items on time with best quality and minimal bugs.
  • Generating & Analysing Trace files and TKPROF, AWR for EOD’s and tuning the bad queries.
  • Used Oracle Advanced Queuing - DBMS AQ for message exchange between Phoenix and external systems.
  • Extensive experience in implementing Dynamic SQL in PL/SQL procedures and Packages.
  • Trouble shooting issues on Oracle coherence clusters.
  • Code reading C# and Core Java Class & packages
  • Setup DB/Unix and batch failure alerts in ITRS Geneos

Tools: Oracle 11g, SQL, PL/SQL, Java, JDBC, Java Script, XML, PL/SQL Developer, Erwin, VSS, SYBASE ASE 15, TSQL, Toad 9, Oracle Coherence, Data synapse, .NET, C#

Confidential

Lead Oracle Consultant

Responsibilities:

  • Oracle Backend Development and code reviews.
  • Performing feasibility study of the request.
  • Creating procedures, functions, database triggers and cursors/Ref Cursors.
  • Writing best exception handling mechanisms.
  • Developed and customized AML functionality in FLEXCUBE.
  • Using optimizer HINTS and improving the performance of QUERIES.
  • Dumping the data from flat files or excels into data base tables using SQL Loader with best techniques to improve the speed of loading.
  • Importing and exporting the table data from one schema to anther schema using Oracle Data Pump, Import/Export.
  • Generating & Analyzing Trace files and TKPROF, AWR for EOD’s and tuning the bad queries.
  • Extensive experience in implementing Dynamic SQL in PL/SQL procedures and Packages.
  • Managed a team of 4 members.
  • Delivered Classroom training session on Advanced Oracle concepts, Optimization techniques and Performance tuning.
  • Design and implement ‘Star schema’ for ETL/BI platform

Tools: Oracle 11g, SQL, PL/SQL, Java, JDBC, Java Script, XML, PL/SQL Developer, Erwin, VSS, J Developer, Informatica Power Centre 8.6

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

  • Design Database for High Volume OLTP modules.
  • Cleaned and validated CSV files from different sources and loading data via interface procedures.
  • Performance Change and Impact analysis.
  • Creating Interface procedures/Programs to read the External system files and load data in FLEXCUBE
  • Using UTL FILE package to (read and write the file) and to parse the XML source file.
  • Importing and exporting the table data from one schema to anther schema.
  • Implementing Ref cursors for data pulling activities.
  • Generating & Analyzing Trace files and TKPROF, AWR for EOD’s and tuning the bad queries.
  • Extensive experience in implementing Dynamic SQL in PL/SQL procedures and Packages.
  • Implementing VARRAYS/NESTED TABLES; BULK Collect to speed up the execution time.
  • Implemented DML Error loggind feature of Oracle 10g R2 DBMS ERRLOG.

Tools: Oracle 10g, SQL, PL/SQL, Oracle 10gas forms & Reports, Toad, APEX.

Confidential

Developer

Responsibilities:

  • Developed new PL/SQL procedure, Functions, Packages, Trigger to achieve the compliance functionality with best Optimized techniques.
  • Used Analytical Functions to write optimal queries for reports.
  • Create tables, indexes, materialized views, DB links as required.
  • Dumping the data from flat files or excels into data base tables using SQL* Loader with best techniques to improve the speed of loading.
  • Using optimizer HINTS and improving the performance of QUERIES.
  • Used DBMS LOB to manipulate with Large Objects.
  • Trouble shooting on ETL issues.

Tools: Oracle 9i, SQL, PL/SQL, Java, XML, C, Toad.

Hire Now