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.