We provide IT Staff Augmentation Services!

Senior Lead Oracle Developer Resume

New York, NY

PROFESSIONAL SUMMARY

  • 14+ years of IT experience.
  • 10+ years of experience in writing SQL, PL/SQL codes in various RDBMS's like Oracle, SQL Server, Sybase SQL AnyWhere and MySQL.
  • 5+ years of experience in overall ETL concepts like data mining, Data analysis, Data extraction, Data loading, data conversion and data warehousing .
  • 3+ years of experience in data migration, data archival and retrieval.
  • 4+ years of experience in QA, implementation, Go-Live, user training , parallel run, support and customization of OLTP application.
  • Domain knowledge of Banking, Finance, Asset Management and Health Care
  • Worked on multiple projects simultaneously.
  • A self-starter with ability to work independently with good understanding of technologies such as object oriented designing, web based application development, multi-tier Client/Server architecture, reusable components, security and work-flow.
  • Well versed with Project development life cycle (Agile Development methodology), System Business Process Analysis and Gap Analysis.
  • Sound knowledge of Data analysis and Database Design skills.
  • Extensive experience in writing SQL queries, performance tuning, PL/SQL stored procedures, Cursor with parameter, Reference cursor, Functions, Triggers, Packages, Collections (Bulk Collection), In memory arrays, Inline views, data analytical functions Oracle supplied package, DBMS Scheduler and maintenance of application in Oracle 7.x/8.x/10g/11g and SQL Server 2000/2003/2005 , SSIS & SSRS, OBIEE, Sybase SQL Anywhere 5.5, MySQL databases under Windows NT/2000/XP platforms and Unix (HP-UX, SCO-Unix)/Linux (RH Linux 4.0) and Unix/Linux Shell scripting.

TECHNICAL SKILLSL

anguages SQL, PL/SQL, Unix/Linux Shell scripting, JCL, Quick Job, C , MF-Cobol Databases Oracle 10g/8i/7.x, MS SQL Server 2000/2003/2005 , Sybase SQL Anywhere 5.5, MySQL, MS-Access, DB2-400, Btrieve record manager Tools used MS-Access, MS-Excel, MS-PowerPoint, MS-Word, MS-Visio, MS-Front page, MS-Outlook, Mantis (bug tracking), JIRA, SONAR, SVN, Erwin, PL/SQL Developer, SSIS & SSRS, OBIEE Operating Systems Windows 95/98/NT 4.0/2000/XP/7, HP-Unix, RH Linux 4.0 Enterprise, Intel Pentium-III, Intel 80486 based systems, Uptron Mini-frames, Wipro Mighty Frames, Novell Netware 3.x/4.x, EC-1045 Main-frame (IBM-370 equivalent), OS/VS, MS-DOS Domain Knowledge Banking, Finance, Health Care, Data mining, Data Warehousing, MIS, Share Accounting, Public Issue System, Rights Issue System, Bank Reconciliation, Data Conversion, Data migration, Parallel run & Go-Live

Environment HTML, JMS, XML, XSLT, Tomcat 3.2.x, Java Script, JSP, Servlets, Front Page2000, .Net framework 1.1 and 2.0 , Hibernate, C#, AJAX, ATLAS

PROFESSIONAL EXPERIENCE

Confidential New York, NY

Senior Lead Oracle Developer

  • Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
  • Writing ad-hoc queries to analyze the desired output from the relational model.
  • Identify in-efficiently written SQL’s for fine tuning in order to improve performance.
  • Bulk updates/inserts using Merge statements.
  • Optimize the PL/SQL code using collections and bind variable for bulk operations.
  • Writing analytical queries for faster processing and better performance.
  • Using appropriate hints and query techniques for faster retrieval of information.
  • Conversion and mapping of data, verifying the data integrity and validations.
  • ETL activities like retrieval of data from external file using external table for data transformation.
  • Loading detailed atomic data into dimensional structures using SQL*Loader utility
  • Exporting the database using data pump (expdp/exp) utility.
  • Balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.
  • Structure dimensional models around business processes.
  • Creating sample data for unit and integrated testing for end-to-end process.
  • Perform functional testing to ensure technical accuracy based on functional specification document.

Environment: J2EE, TOMCAT, Netbeans, spring, XML, JSP, Servlet, JDBC, RH Linux 4, Erwin, MS Windows 7, Toad

Confidential

Senior Lead Oracle PL/SQL Developer

Rebate Validation System

  • Understanding the existing application architecture, flow of the system and making changes for incorporating business needs.
  • Provide parallel solution to new business requirements for the Second Brand(2nd Brand) Customer without impacting the existing process by analyzing and replicating code incorporating necessary changes for dynamically created parameter table with required values populated.
  • Written PL/SQL stored procedure to Identify Bridge To Value(BTV) customers from the historical data using analytical queries and processing it.
  • Written ad-hoc Queries on the historical data to retrieve business critical needs.
  • Written merge statement for bulk data updates and inserts.
  • Exporting database using expdp (data pump), exp (export) utility.
  • Retrieving and loading the from external file using External table & SQL*Loader utility.
  • Preparation of sample data for unit and integrated testing.
  • Making changes to Unix shell scripts as per the requirement.

Environment: Unix, MS Windows 7 professional, Informatica, Golden Gate, Toad.

Confidential

Memphis, TN

Senior Lead Oracle PL/SQL Developer

  • Database Migration of Pricing Request System (PRS) from Oracle 10g to Oracle 11g Cluster server.
  • Making the necessary changes planned for migration in the stored procedures, packages, scripts etc.
  • Comparison of table data, procedures, packages, functions, triggers make required changes before migrating it to new database.
  • Changes to stored procedures and packages in order to log the information into external file.
  • Changes to TeraData bteq scripts.
  • Job scheduling and monitoring using $Universe.
  • Exporting and loading database using data pump(expdp) and SQL*Loader utility.
  • Creating External table, for uploading the data with significant performance improvement.
  • Making changes to Linux shell scripts of Pricing Request System (PRS), Re-rate & ETL for migration and implementing directory structure as per the new EDC Standard.

Environment: Java, J2EE, JSP, Log4J, JavaScript, Tomcat, CVS, HTML, Eclipse, Struts, Weblogic 10.3, Ant, Red hat Linux 4, MS Windows 7 professional, Oracle SQL Developer

Confidential

New York, NY

Team Lead Oracle DB Developer

  • Review PL/SQL stored procedures/complex SQL queries, packages and triggers for optimal output.
  • Analyze the communications, informational, data based and programming requirements of clients.
  • Understand and make changes to Linux shell scripts for implementing the requirement.
  • Providing technical assistance in systems development and database development activities.
  • Identify in-efficiently written SQL for fine tuning and better performance.
  • Transformation of data into summarized form to perform various data warehousing and business intelligence tasks.
  • Prepare flowcharts using MS Visio and well documented the modules that are developed.
  • Perform functional testing as per the functional specification document.

Environment: J2EE, TOMCAT, Netbeans, spring, XML, JSP, Servlet, JDBC, RH Linux 4, MS Windows 7, MS-Visio

Confidential

Team Lead/ Oracle PL/SQL Developer

  • Collect and review business requirements from the client.
  • Manage workload for quality deliverables and time lines.
  • Escalation of issues that impact productivity or ability to meet expectations, weekly status update.
  • Assist manager in tracking progress, prioritizing work, developing time estimates and work plans.
  • Mentor junior team members.
  • Database design to enable blocking of application bid amount in the investors linked account.
  • Writing ad-hoc SQL queries, creating views and writing stored procedures and performance tuning.
  • Implementing the change requests after identifying the bottle necks/issues, working on the possible solutions, discussing it with the functional analysts and getting approval for the final changes.
  • Used Mantis (bug tracking tool) for tracking and resolving bugs.
  • Review and design development activities for customisation needs of client.
  • Arrange build demo for clients, installation and procedural manuals for support staff.
  • Implementation of business logic, review Stored Procedures, Functions, Views to develop reports.
  • Maintain /Troubleshoot of application.

Environment: J2EE, TOMCAT, Netbeans, spring, JSP, Servlet, JDBC, Oracle Forms, MS Windows 2000/XP, SVN

Confidential

Dubai

Team Lead, SQL, PL/SQL Developer

  • Automating the work flow of reconciliation between HO and branches.
  • Review requirement specs with client and suggest better solutions.
  • Prepare functional specs, assist in database design, ad-hoc SQL queries, view, stored procedures and SSRS reports.
  • Manage workload to deliver quality deliverables that meet requirements and time lines.
  • Weekly status update and escalation of issues that impact productivity or other modules.
  • Assist manager in prioritizing work, prepare time estimates and milestones.
  • Mentor junior team members in best practices, functional knowledge, Unit testing and integrated testing.
  • Application maintenance and troubleshoot.

Environment: VB/ASP.Net 2.0, HTML, AJAX, Atlas, c#, Javascript, XML, MS Windows NT/2000/XP, SVN

Confidential

Delhi

Project Lead Oracle PL/SQL Developer

  • Collect and review business requirements from the client.
  • Manage workload to deliver quality deliverables, meet requirements and time lines.
  • Assisted in designing the database for the application.
  • Written the functional specification documents and interacted with the client for user friendly interface.
  • Data uploading using SQL*Loader, SSIS and export & importing of database dump files,
  • Writing complex SQL queries, inline views, analytical functions, stored procedures and Packages, performance tuning of in-efficiently written SQLs.
  • Used Bulk collect and bulk binding features for handling bulk operations as a measure towards performance tuning.
  • Automated the application for uploading the historical data on as when required basis by the end user having proper access rights with user friendly interface.
  • Implemented user level, menu level, region level and zone level access securities.
  • Support and troubleshooting of application.

Environment: J2EE, TOMCAT, Netbeans, spring, JSP, Servlet, JDBC, MS Windows NT/2000/XP, SVN

Confidential

Mumbai

Team Lead, SQL, PL/SQL Developer

  • Understand business needs and work flows to translate into software.
  • Interact with the Base-24 switch vendor to understand the ISO-8583 messaging.
  • Prepare the functional specification document for the developer and work flow document for better understanding of the flow of ATM/POS request and response.
  • Coordinating with Bank IT Staff, Switch vendor and ATM machine vendor for testing the application.
  • Help the team in designing the database taking into consideration various kinds of ATM/POS transactions.
  • Creation of Positive Balance file and uploading to server for doing offline transactions.
  • Involved in QA, functional testing with the sample messages provided by the Switch vendor.
  • Taking the final approval and sign-off from the Switch Vendor, Bank’s IT Staff.
  • Involved in implementation and going live.
  • Developed Debit Card maintenance interfaces along with reports.
  • Maintenance and support for the application.

Environment: VB 6.0, MS Windows NT/2000, Novell Netware 4.x

Confidential

Mumbai

Team Lead, SQL, PL/SQL developer

  • Written PL/SQL stored procedures for converting the bank’s legacy data to the retail banking format.
  • Involved in ETL activities like Data extraction, Transformation logic as per business rule using PL/SQL stored procedure, data mapping, cleansing, standardizing
  • Verifying business object documents, database design documents. ER Diagrams and maintaining database objects.
  • Revisit stored procedures/views for identified client needs.
  • Written ad-hoc SQL queries, for testing end-to-end process.
  • Escalate critical issues to seniors to take necessary actions.
  • Involved in QA, implementing the application, doing parallel run and day to day support activities.
  • Developed new modules using the application frame work, business frame work in n-tier architectures.
  • Involved in Enhancements and Customization of modules.
  • Given demonstration and user training to end user.

Environment: PowerBuilder 6.5, Windows 95/98, Novell Netware 3/4.x, Erwin

Hire Now