SUMMARY:

• As Senior Data Engineer with Raymond James Financial, successfully managed development and delivery of matching, reconciliation and exception handling framework to consolidate transactions ($4.6 billion a year) on a centralized data quality control store, for all businesses, working with a team of business analysts, legacy system experts and sourcing teams using ODI 12c and PLSQL.
• Designed and delivered PLSQL application for centralized analyst tool to report and maintain data quality
• As Project Lead with Confidential ., led software delivery team to develop and deliver multi - terabyte database and a 24X7 global application and managed delivery of services worth $800K in a single year.
• Managed client relationships and directed team to translate complex business requirements into programming language (Oracle PLSQL, Java/J2EE & Informatica) to ensure accurate delivery of Credit Risk Management reports, on $26 billion business of the Investment bank
• Created roadmaps and strategies for business development, ramped up 35 member, multi-functional team leading to three fold revenue increase in a span of just 4 years
• Optimized resources across multiple simultaneous projects in different technologies, reducing operational costs by 20% year-over-year while continuing to maintain standards for quality and timeliness of deliverables
• As Oracle expert consultant with Confidential ., designed parallel loads for large partitioned tables and a series of technical optimizations, reducing critical reporting wait time by 6 hours. Migrated Informatica to PLSQL, saving over $1.5M in license fees
• As Technical Lead with Confidential ., managed client relationships and translated business requirements, helping technical team create innovative customized software of Audits module, leading to additional revenue of $20K/year.
• Designed and delivered surveys module in short 5 delivery cycles, enhancing the product suite with additional software, increasing profit in licenses by 10%
• As Lead Oracle developer, with United Bank of Switzerland, successfully delivered database enhancements, leading a team of 4 Developers.
• Oversaw all phases of an entire Software Development Life Cycle (SDLC) of database components spanning from preliminary database design to post-implementation rollout and completion. Redesigned Auctions module and created audit framework for data quality
• As IT Consultant with Confidential ., resolved critical application issues, in co-ordination with systems/development team.
• Worked actively with two projects - Entitlements. Gained experience in Release Management, Testing and handling communications for huge customer base in 80 countries. Developed PLSQL APIs for the Admin screens
• As IT analyst with Confidential ., ported legacy data into the ERP structure by mapping of columns after discussion with legacy experts, data correction and controls tallying for the data warehouse, in the form of 46 flat file structures.

TECHNICAL SKILLS:

O.S & RDBMS: LINUX, HP UNIX, SUN Solaris, and WINDOWS NT/2000/XP, Vax VMS 4000, Oracle 9i,10g & 11g & 12c, Oracle Exadata 12c Sybase, MS Accessent or familiar with a vast array of programming languages, concepts and technologies, including:

LANGUAGES: SQL, PL/SQL, Shell Script, Java Script, T sql,C,C++, Unix basic Shell scripting

TOOLS: & UTILITIES: SQL *Plus, SQL Loader, Toad 9, PLSQL developer, ODI 12c, Informatica 8.6, Control - M, Sql Developer, Top Link, Oracle Redgate Deployment Suite, Jenkis, Genisis, Microsoft TFS, Oracle data integrator 12c, Clear case, Git, Source Tree, ERWIN 4.0, Developer 6i/2000 Eclipse

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Engineer Oracle database SME/ODI Sr Developer

Responsibilities:

• Developed and delivered ODI load mappings for transactions business process such as loading with pattern matching transformations, matching with corresponding posting and position reconciliation, involving millions of records
• Along with the team involved in design and development of common exception handling framework using ODI mappings and oracle plsql
• As Oracle SME, worked on technical work items and performance tuning and supported team on Oracle database - Oracle Exadata 12c
• Developed PLSQL APIs for Analyst tool application and did performance tuning of several reporting queries using materialized views and reference partitioning

Oracle datwarehouse Solution Architect / Designer

Responsibilities:

• Designing, documenting and presenting pragmatic solutions to senior business users and stakeholders.
• Data warehouse solution, suggested involve data capture from poorly documented source systems, and 3rd party applications. This role typically involves using data analysis techniques to help understand and document source system structures, and identify data quality issues
• Closely working with a partner firm PROTIVITI to enable them produce audit reports to CFPB

Oracle Technical SME/Senior Developer/Deployment Administrator

RESPONSIBILITIES:

• As SME, designed ETL data loads, laying out the high and low level design documentation for all the components of new data loads as well as adjustments processing as per regulatory reporting requirements of the bank
• Worked closely with the warehouse architect on fact, dimension & stage table design, indexing design, technical book of work items, code modules & standards
• Code reviewed all oracle changes and provided technical guidance and mentorship to 9 member developers team
• As senior developer, developed stage, dimension / fact tables, PLSQL SCD2/COB dated data loads,
• Developed parallel loads for large partitioned tables, migration of complete workflows from informatica to PLSQL
• Developed adjustment APIs for country scenario adjustments, data maintenance, BAU & Scenarios changes
• Developed for issue fixing and enhancements to adjustments rule & scenario calculation engines using jobs which process complex adjustments and calculations based on predefined rules & scenario metadata across multiple COBs
• Developed from scratch the parallel batch data rollback procedures for use in QA/UAT environments to enable testing of Month end COB batch runs for both daily and hist batch tables
• Developed the housekeeping and shrinking routines based on retention policy for small, large and very large tables to be run on every week in off peak hours
• As deployment administrator, created release manifests to capture oracle changes and build release file scripts
• Developed standard scripts to drop, copy partitions & sub-partitions, create public synonyms, providing privileges for all objects created in specific schema and create VPD policies based on metadata in excel sheet
• Developed deployment shell script to create SQL*plus connections and deploy release scripts with interactive log
• Completed several successful planned and exception deployments of releases to QA/UAT & production environments working with release management, production support, DBA teams and change management board
• Worked on batch run support for QA/UAT environments, on Oracle, Sybase, Unix, Informatica & Control- M issues and seeing through fixes working with the corresponding teams
• Developed APIs for weekly cutdown and de-swiss of data from production to CIT environment

E NVIRONMENT & T OOLS: Solaris UNIX, Linux, Oracle 11g, TOAD, PLSQL developer, Sybase, Informatica, Control-M

Technical Lead

RESPONSIBILITIES:

• Developed PLSQL pipelined functions and Infolets using Sql, for drill down reports on various levels of aggregation in Audit Management module
• Involved in debugging and fixing of issues with the audits management module and the customized drill reports
• Handled the requirements capture for extending Audits module to on-field Audits for Cattle & Poultry products
• Designed and developed a new Survey's module, which is a part of COI product, right from scratch which enabled users to create and maintain interactive/conditional survey templates, sending out surveys, taking survey and reporting/mitigation of risks
• Designed and developed the tables for the survey's module and the corresponding PLSQL APIs for all the functionality of the module
• Successfully delivered the customized module to client team within five delivery cycles withing short period a file
• Worked with the client team to do master data setup and organization configuration setup for the products

E NVIRONMENT & T OOLS: Oracle 10g, TOAD, Javascript, Metric stream Apps Studio Infolets

Senior Oracle Developer

RESPONSIBILITIES:

• Lead the database development of banker portal application
• Developed plsql packages, procedures and triggers for coding business logic on various transactions
• Developed complex search function using dynamic sql for producing the deals reports using various search criteria
• Involved in the patch creation for database changes and worked with Architect on code review comments
• Responsible for the complete cycle of database changes to the application from requirements gathering, estimation, development, unit testing and deployment.
• Successfully completed major changes to the application which includes - Audit Framework for History Information section, procedure for search & package to encapsulate discrete procedures
• Redesigned the database tables for Auctions module and completed migration to new model from old
• Resolved complex issues with the natural key generation of client ids using trigger

E NVIRONMENT & T OOLS: SQL Developer, Toplink, Java/J2EE, Unix

IT Consultant

RESPONSIBILITIES:

• Resolved critical application issues, in co-ordination with systems/development team.
• Worked actively with two projects (Entitlements in Metalink & Fast Track), two new functionalities in Metalink.
• Gained experience in Release Management, Testing and handling communications for huge customer base.
• Gained exposure, to a whole set of legacy applications running on various technologies - Perl, PL/SQL, Oracle Forms and reports
• Developed PLSQL APIs for the Admin screens in the Metalink application

E NVIRONMENT & T OOLS: Oracle PLSQL, Unix, HTML DB

Oracle Apps Test Consultant

R ESPONSIBILITIES:

• The assignment involved the preparation of Test Scenarios, Conditions and Scripts r Application Integration Testing for the different Modules
• Worked on various modules - Claim Validation and processing, Inspections, Document Management Unit, Customer Service Centre, Interfaces Etc.
• The assignment also addressed review of functional and technical design documents, defect rising & fixing in the areas of Oracle telesales, customers online and email centre.

ENVIRONMENT & T OOLS: Oracle EBS 11i, Test Director, Oracle application development framework

Oracle 6i Forms and Reports Developer

RESPONSIBILITIES:

• Developed and deployed the module which provides extensive query facility on the impact analysis receipt wise, Base rate change wise, supplier wise etc.
• Supported the modules and planning improvements to the current system, which included the Work In Progress (WIP) correction for assembly and machining shops and the introduction of stage wise WIP, Part no Correction for the import parts and price variance posting for the receipts
• The assignment involved the porting of legacy data into the current ERP structure by mapping of columns after discussion with legacy experts, data correction and controls tallying for the Datawarehouse
• Ported legacy data in the form of 46 flat file structures each 120 numbers for the time period of 1990 - 2002 (around 80 GB of information - 600 tables)

ENVIRONMENT & TOOLS: Oracle Forms & Reports 6i, Cobol and Vax Operating System, Sco Unix Oracle Server