PROFESSIONAL SUMMARY:

• Highly Proficient & focused Certified Oracle Database & Application Developer/Analyst.
• Having a successful 12+ years’ experience developing and maintaining comprehensive Oracle databases and applications.
• Proven database design and architecture skills on high profile projects.
• Extensive experience in all phases of Systems Development Life Cycle (SDLC).
• Demonstrated ability to multitask in fast - paced challenging environments.
• Worked in a variety of industries including;

• Banks and E-commerce
• Telecommunications
• Airlines
• Finance/Accounting/Taxation
• Transportation/Parking Permits services
• A diligent & result oriented team player, with excellent analytical and problem-solving skills.
• Have great written and verbal communication and interpersonal skills.

AREAS OF EXPERTISE:

• Planning/Designing/Creating Databases
• Developing DB Stored Procedures/Functions/Packages
• Requirements Gathering & Analysis and Data Modeling
• System Designing with Impact Analysis
• Classic/GUI/Web Application Development, great working knowledge in most modern languages (Java, C#, C++)
• Database Performance Monitoring and Tuning
• Application Instrumentation, Tracking and Tuning
• Advanced PL/SQL Programming (using PL/SQL tables, Bulk Collect & Forall, Dynamic SQL with bind variables to imprve performance, program monitoring/tracking using DBMS APPLICATION INFO, DBMS UTILITY,.. packages.
• Advanced SQL tuning using explain plan, sql hints, parallel processing, updating statistics, MVs, index rebuilds.
• Prepare and Maintain Technical Documentation (BRD, FRD, HLD, DDD)
• Also have very good hnds-on experience working with SQL Server database, writing SQL queries and T-SQL procedures, creating ETL packages with SSIS, designing repors with SSRS, and some experience with SSAS
• Good working knowledge of other RDBMSs including MySQL, Informix and NoSQL Cassandra database.
• Exposure to latest web development technologies (See details in below sections)
• Writing ETL scripts to migrate data from several source databases/platforms to different target databases/platforms, these included SQL scripts, Unix scripts, stored procedures and Windows batch scripts.
• Cloud Computing experience in Oracle, AWS and Microsoft Azure.
• Proficient with Software life cycle tools including Git, SVN, JIRA, Confluence, Jenkins,…etc.
• Worked in Agile methodology as well as traditional ones.

TECHNICAL PROFICIENCIES:

Databases: Oracle, MS-SQL Server, MySQL, Informix, Sybase and Big data, NoSQL distributed Databases Cassandra, MongoDB.

Languages/Development Tools and Web Based Technologies: Oracle SQL, PL/SQL, APEX 5.x/18.x, Oracle Forms & Reports 9i/10g, SQL Server T-SQL, SSIS, SSRS, Java, Visual C#.Net, VB.Net, C/C++, HTML5, CSS, JavaScript, AJAX, J2EE frameworks, JSP, ASP.Net, SAP Crystal Reports, Jasper Reports, Pearl & Unix Shell scripting.

Other Software/Utilities: Oracle SQL*Plus, TOAD, Oracle-SQL-developer, PLSQL-Developer, SQL*Loader, Data pump, MS Visual Studio, SQL Server Mgmt.-studio, Microsoft BIDS, PhpMyAdmin, Net Beans, Eclipse, CVS, SVN, GIT, Jenkin.

Operating Systems: Red Hat Linux, Oracle Solaris, HP-UX, IBM AIX, Ubunto, Windows-10/8/7/Vista/XP, Windows Servers 2kx, VAX-VMS, IBM DOS/VSE & MVS operating systems.

PROFESSIONAL EXPERIENCE HISTORY:

Confidential

Senior Database Application Developer

Responsibilities:

• Read and Analyze existing system documentation and new requirements, meet business users and discuss requirements
• Read and understand existing system programs written in Unix shell scripts and Sybase SQL stored procedures
• The major tasks are to develop ETL & data migration programs/scripts in Oracle that will replace Sybase and Unix shell script code.
• Change tasks scheduling from Unix schedular to Oracle jobs schedular using DBMS SCHEDULAR package.
• Generate sample data for testing and perform Unit testing of code modules, and compare results based on sample data.

Environment: Oracle 12c SQL, PL/SQL Development, Sybase (ASE and IQ) SQL and program analysis, Unix shell scripting and Java Programming. Used JIRA, GIT and Jenkin for project tracking, source control and build automation.

Confidential

Senior Oracle (Front and beck end) Developer (Contract)

Responsibilities:

• Meeting clients to discuss and gather business requirements,
• Building the business requirements document (BRD) based on these meetings,
• Translate user requirements to functional requirements, and generate functional design spec. document (FDSD),
• Design prototypes and perform actual system designing, and generate high level & detailed design documents,
• Perform actual coding with unit testing, showing completed tasks to business and taking their input/feedback,
• Create deployment scripts, instructions to be used for deployment in QA, UAT & Production environments,
• Worked in both the back end and front end development teams, and also developed java programs to generate .pdf reports,
• Write test cases/plans and support QA, UAT teams with testing,
• Perform post-deployment tasks including Production support and System maintenance.

Environment: Oracle 11g, Oracle 12c, Oracle SQL, PL/SQL Development, Frond end Development in Oracle APEX (v5.1 & 18), Java programming, JavaScript, Crystal Reports, Jasper Reports, and Unix shell scripting. Used JIRA, Bitbucket, Jenkin for software life cycle/source control and continuous integration.

Confidential

Senior Database Developer/Analyst

Responsibilities:

• Gather & identify business data requirements from BSA, understand the information needs and translate those into conceptual, logical and physical database models.
• Perform system analysis & design, programming (coding program units based on agreed design), unit testing and supporting deployments, following Rogers SDLC methodology & adhering to company’s technology standards.
• Produce test plans/scripts and perform test execution using available/appropriate tools.
• Analyzing query performance issues and modifying data structures/application code to fix performance problems.
• Prepare and maintain all technical documents throughout different project phases.
• Generate data in Test database using some ad hoc SQL, PL/SQL scripts and performing Stress testing.
• Used Oracle Developer Suite (Forms, and Reports: 10g) for Rogers devices’ supply-chain system - this system involved designing screens/flash reports for sales and purchase orders, inventory status’.
• Provide support to QA, UAT teams and Production implementation team during deployment phases.

Environment: Oracle SQL, PL/SQL with Oracle 11g, Oracle 12c, Oracle APEX 5.0, Java, MS SQL 2012 (includes T-SQL procedures, SSIS, SSRS), ASP.Net, C#.Net, Javascript, Unix shell scripts. JIRA, GIT and Jenkin for project tracking, source control and automatic deployments.

Confidential

Senior Oracle Developer

Responsibilities:

• Gathering requirements, Understanding/Analysis of Requirements.
• Build a Technical design document, with impact analysis, this included data model and code changes.
• Meetings with project lead for design review, conducting a complete walkthrough of design, with a discussion about further improvements, resulting in a more refined & detailed design document.
• Development - Coding programs based on the approved design, perform Unit testing.
• Checking code into and out of CA SCM (Software Change Manager) and Code Merging
• Integration testing, to ensure that combined changes from all developers are working fine with each other,
• Submit code for code review, and conducting code review for changes from other developers,
• Populating data in the UAT database with some ad hoc SQL, PL/SQL scripts and performing Stress testing (load testing with the amount of data close to production and seeing the performance.
• Providing support in Deployment to different environments (Integration, QA, UAT & Production).

Environment: Technologies used were Oracle SQL, PL/SQL (Platform: Oracle database 11g with RAC, Data guard and advanced replication setups under Linux), Java, JavaScript, JSP & Struts framework. CA SCM for source control and auto deployment, IBM RQM for bugs tracking.

Confidential

Oracle PL/SQL Developer/Analyst

Responsibilities:

Responsibilities:

• Designing and developing applications, this also involved requirement analysis & database designing.
• Develop & unit test Oracle stored procedure, functions, packages & triggers as per business requirements
• Acquire knowledge and understandings of existing Databases & Applications.
• Write database scripts and Unix shell scripts to implement changes for any assigned projects/tickets.
• Developed front end applications using Oracle forms and reports (6i).
• Take an active part in system integration testing, UAT, implementation to the production environment, end-user support, system maintenance, troubleshooting & resolving issues, make improvements, and so on.
• Creating and configuring databases, schemas, and objects for different projects,
• Keep the database available and in a proper functioning state. Fine-tune database performance on a daily basis. Identify bottleneck SQL queries and fix them.
• Refresh schemas and tables from the production database to development/QA environments on-demand.
• Perform data migration, extraction, transformation, loading between different databases, under different OS’s.
• Recommend solutions to developers and project teams on database design and implementation issues.

Environment: Technologies Used: Oracle (9i/10g/11g) database, Oracle SQL, PL/SQL, MS SQL Server 2005/2008 and MySQL, CVS/SVN for Source countrol