SUMMARY:

• Over 10+ years of experience in Information Technology and Software development working in all the phases of Software Development Life Cycle (SDLC).
• Solid experience in design and development of Relational Database applications (OLAP and OLTP), Big Data (Hadoop) and implementation & support of complex systems.
• Extensive experience in Performance tuning of SQL queries and PL/SQL code.
• Experience in Database Administration (DBA) and Data Architect (DA) tasks.
• Taking initiative, team player with excellent communication skills, both written and verbal.

TECHNICAL SKILLS:

Big Data: Hadoop, Impala, Hive, Spark, Sqoop

Relational Databases: Oracle 11g/10g/9i/8i/7.x (RAC, Partitioned Tables/Indexes), SQL Server 7

Languages: Python, C, C++, FORTRAN, Pascal, Basic

Scripting Languages: Shell scripts, VB Script, Java Script, HTML, XML

Front End Tools: Visual Basic, Oracle Developer 2000

Reporting Tools: Business Objects 5.1.3, Oracle Reports, Crystal Reports 7, Cognos 6.0, SQR

Formal Training: Java, Cognos 6.0

Operating Systems: MS - DOS, Windows 7/NT 4.0/2000/XP, UNIX/LINUX/AIX (with Shell Programming)

Other Tools: Spring Batch, SourceTree/Stash/GIT, TOAD 9.0, Cygwin, Rational Clearcase 7.0, PVCS, BMC Control-M Desktop/Enterprise 6.4, Visual Source Safe, BMC Remedy User 7.0, FileZilla, WinSCP.

PROFESSIONAL EXPERIENCE:

Senior Oracle/Hadoop Developer

Confidential, Chicago, IL

Responsibilities:

• Design and create Hadoop (HDFS) objects such as tables, partitioned tables, views etc.
• Design, Architect, Code and Test data reconciliation process for flat data files in Hadoop (HDFS).
• Design, code, test and implement Hadoop scripts and Oracle Packages and Stored Procedures/Functions.
• Design and Architect common framework for Oracle Packages.
• Design and create Oracle DB objects such as tables, indexes, views, types etc.
• Code, test and implement Shell Scripts.
• Create Workflows and Sub-Workflows using Spring Batch.
• Schedule process via Control-M.
• Gather business requirements and transform into technical requirements.
• Design and create Oracle DB objects such as tables, indexes, views, types etc.
• Design, code, test and implement Oracle Packages and Stored Procedures/Functions.
• Create Oracle administrative utilities like Capacity Planning, Database column encryption/decryption, Email utility (sending text and attachments).
• Use Oracle best practices: Improved performance by creating Partitioned Tables, Bulk Collects, using Hints in SQL queries; ensuring tables are properly analyzed etc.
• Schedule process via Control-M.
• Post implementation support.

Environment: Oracle 11g, PL/SQL, SQL Developer, SQL*Loader, Java, Weblogic Server, DataStage, Linux, Control-M, Windows 7, MS Office 2007, HTML, FileZilla, WinSCP.

Confidential, Downers Grove, IL

Senior Oracle Developer

Responsibilities:

• Gather business requirements and transform into technical requirements.
• Automated entire Enterprise Database refresh including sending automated emails with Success/Failure messages, Counts, explicit error messages etc.
• Parsing XML data and loading into Oracle tables.
• Created Oracle administrative utilities like Capacity Planning, Database column encryption/decryption, Email utility (sending text and attachments).
• Use Oracle best practices: Improved performance by creating Partitioned Tables, Bulk Collects, using Hints in SQL queries; ensuring tables are properly analyzed etc.

Environment: Oracle 11g/10g, PL/SQL, SQL Developer, SQL*Loader, Linux (Cygwin), Windows 7, Win XP, MS Office 2007, HTML, FileZilla, PSFTP.

Confidential, Hoffman Estates, IL

Lead Systems Engineer

Responsibilities:

• Develop application, including coding, testing, debugging, implementation and daily support of the application.
• Participate in change management, rapid coding development & prototyping, implementation and post implementation support.
• Partnering with internal IT and business teams to identify process improvement opportunities, new business requirements and the development needed to meet SHC needs.
• Complete System Integration & testing and fix issues reported by Business users.

Environment: Oracle 9i/11g, PL/SQL, SQL Developer, SQL*Loader, TeraData, Unix/AIX, Control-M, Win XP, MS Office 2007, HTML

Confidential, Rosemont, IL

Sr. Oracle Developer

Responsibilities:

• Used Oracle best practices to create Packages and Stored Procedures/Functions.
• Created design specification, test plan and test case documents.
• Completed System Integration & testing and fixed issues reported by Business users.
• Created scripts to deploy database objects in UAT and Production.

Environment: Oracle 11g, SQL Developer, PL/SQL, TOAD, Windows 7, UNIX

Confidential, Burr Ridge, IL

Sr. Oracle Developer

Responsibilities:

• Created Oracle Packages/Functions/Procedures to provide data set to Front-End (.NET)
• Performance tuning on existing procedures, packages, functions etc.
• Perform DBA and DA (Data Architect) tasks.
• Take Weekly/Monthly backup of Production Database and refresh Development Database.
• Monitoring production database to ensure availability with minimum downtime.

Environment: Oracle 10g, PL/SQL, TOAD, Windows 7, LINUX with Shell Scripts, .NET 3.5, C#, Java Script, AJAX, ADO.Net, Telerik RAD component for ASP.Net, Dev Express.

Confidential, Chicago, IL

Sr. Oracle Developer

Responsibilities:

• Used Oracle best practices to create Packages and stored procedures/functions.
• Created UNIX scripts to execute Oracle Packages thru Control-M jobs.
• Completed System Integration & testing and supported Data Warehouse applications.
• Monitoring Control-M schedules and fixing broken jobs and any other issues.
• Generalized Oracle Packages and stored procedures/functions to make them C1 and C2 compatible.
• Generalized UNIX scripts to make them C1 and C2 compatible.
• Completed Performance Testing between C1 (AIX/Oracle 9i) and C2 (Solaris/Oracle 10G).
• Changes to configuration tables for all applications to transmit/receive files through CBOESCP-VIP server.
• Coordinated with Infosec group to setup firm accounts on the new CBOESCP-VIP server.
• Coordinated with all external firms for testing file transmission through new CBOESCP-VIP server.

Environment: Oracle 9i/10 (RAC, Partitioned Tables/Index), PL/SQL, Windows 2000, UNIX w/Shell Script, Control-M

Confidential, Chicago, IL

Sr. Oracle Developer

Responsibilities:

• Used Oracle best practices to create Database scripts, packages, and stored procedures/functions.
• Created Oracle Capacity planning monitoring package.
• Created BO universe and reports to view Capacity Planning reports.
• System Integration & testing.
• Monitoring Control-M schedules and fixing broken jobs and any other issues.

Environment: Oracle 9/10, PL/SQL, VB Script, Windows 2000, UNIX w/ Shell Scripts, Control-M, Business Objects 6.5

Confidential, Ann Arbor, MI

Sr. Oracle Developer

Responsibilities:

• Created Database scripts, stored procedures/functions and triggers to be used in the applications.
• System Integration & testing.
• Support and resolving post-production issues.

Environment: Oracle 9i, PL/SQL, Oracle Forms, SQR, Java, Java Script, Windows 2000, UNIX