SUMMARY

• Oracle certified professional with strong 15 years of programming experience as an Oracle PL/SQL Developer in analysis, design and implementation of business applications using the Oracle Relational Database Management System (RDBMS). His domains knowledge includes Banking (Security/Money Market), Capital Market, Insurance and Automobiles.
• 8 years of expertise in data modeling, evaluating data sources, ETL, BI, OLAP, Oracle APEX HTML - DB, Client/Server applications.
• Proficiency in all aspects of database programming on Oracle SQL / PL/SQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
• Ability to interpret the requirements and build logical and physical relational data models and prepare the PL/SQL requirements and design documents.
• Wrote and maintained SQL and PL/SQL stored program units/packages maintaining the coding standards.
• Strong experience in query optimization, debugging, and performance tuning for improving performance.
• Expertise in data analysis, profiling, cleansing, validation and identifying mismatch.
• Wrote unit tests (document and code) for the SQL & PL/PGSQL stored program units/packages.
• Handled projects which involved all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong skills in using Oracle PL/SQL Collections, Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance.
• Has excellent analytical and technical skills.
• Good at end-to-end solution application development - Design, Development, Implement and handshaking with various stakeholders.
• Knowledge in AWS cloud, snowflake (datawarehouse as service) and matallion ETL - cloud.
• Knowledge in Data Lake repository data pipeline.

TECHNICAL SKILLS

LANGUAGES: PL/SQL, SQL, T-SQL, UNIX SHELL SCRIPTS, C, PERL SCRIPTING, XML

TECHNOLOGIES / TOOLS: SQL LOADER, PL/SQL DEVELOPER, CVS, ETL, SQL DEVELOPER, SQL NAVIGATOR, TOAD, ANT

DATABASES : SYBASE, ORALCE 11G/12C, MS SQL SERVER, MONGO DB, MYSQL, INGRES, PostgreSQL 9.0/9.1

OPERATING SYSTEMS: WINDOWS, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Boston, MA

Sr Oracle/DataLake Developer

Responsibilities:

• Designing, developing, and implementing a Hadoop Eco System - Data Lake CDC Layer data process across various Operational Systems - it can be raw / structured information.
• Develop and maintain ETL processes importing data from multiple Operational Data Sources, including Oracle, Microsoft SQL Server and others.
• Analyze and develop data models that fit into enterprise business processes.
• Process unstructured data into suitable forms for analysis.
• Apply machine learning, natural language processing or data mining techniques to analyze structured and unstructured data from multiple sources.
• Develop and maintain Python scripts working with data in Hadoop and S3.
• Technical and functional design of existing/new changes, custom functions, reports, conversion load programs, interfaces with third party systems.
• Coordinate deployment of change requests and break fixes, act as a liaison between business and development team, provide timelines, estimates, and weekly status updates to project managers.
• Communicate effectively with the development, security, architecture, and other teams involved in the development life cycle of a business requirement.
• Active involvement in requirements-gathering and implementing required features according to software design specifications.
• Providing design and technical consulting expertise for new or existing projects.
• Actively participate on the team responsible for development of data mart to support internal business processes.
• Work with data architect, developers and DBA to identify the source data and load the from source systems to help development and testing
• Data Integration and Synchronization using SQOOP, HIVE, Python and Unix/SQL Scripts.
• Learn new technologies if requested.
• Exhibit excellent verbal and communication skills.

Confidential

Oracle Developer

Responsibilities:

• Existing eTMF system is outdated with no controls and cannot handle correct measures. To implement new solution, perform reverse code engineering of complex algorithms and evaluate existing trade promotion to understand the implication of standardizing in the new Archival system.
• Preparation and review of technical specifications to generate accurate technical requirements for development team based on functional requirements from business stakeholders.
• Work with the business team to perform fit-gap analysis, be an integral part of the design workshops and requirements gathering sessions
• Requirement gathering from business on different interface feeds source to target.
• Identifying the source objects and preparing mapping columns for target system load.
• Developing code using Oracle PL/SQL and Unix Scripting.
• Manage data transmission and ensure the Summary and Aggregation data is properly designed and configured.
• Work with IT team to ensure that the Archival System development meet the development standards and make sure the configuration components are properly configured and documented.

Confidential - Durham, NC

ETL - PL/SQL Developer

Responsibilities:

• Involved in requirements-gathering, prepare design specifications (HLD, LLD) and implement required features according to functional and design specifications
• Provided design and technical consulting expertise
• Wrote Procedure, Function or Packages in PL/PGSQL. to load the data to perform ETL operation till loading final target
• Worked with data Architect and DBA to identify the source data and load the source systems to target systems for development and testing
• Designed and developed efficient ETL jobs using intermediate tables
• Used ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Responsible for Business meetings, conversion of business rules into technical design document.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Gathering requirements from users/business to develop interfaces, packages, Load plans.
• Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Worked closely with the end users and designing the documents to the track changes.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Used Interfaces to load data from Flat files, CSV files in to staging area Oracle and load in to Oracle data warehouse
• Used SQL tools like SQL Developer to run SQL and PL/SQL queries and validate the data loaded into the target tables
• Used Oracle Stored Procedures, Functions and Packages.
• Backend scripting/parsing using Shell Script and Python
• Integrating multiple technology as procedure/package - email, shell/python script and backend procedure/package objects as single unit.
• Developed and fine-tuned PL/SQL stored procedures to increase the performance.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data.
• Develop documentation on best practices with APEX and Oracle PL/SQL development. Also developed sample applications for company to demonstrate APEX features.

Environment: Oracle 11g/12c, Unix Scripting, Python 2.7, SQL*Loader, PL/SQL Developer, PL/SQL, Oracle Data Integrator 12c, PostgreSQL, Oracle APEX