Data Oracle

Syed Azhar 312-***-****(Mobile)

Certified SAFe practitioner ********@*****.***

Andover, MA -01810

Professional Summary

Around 12+ years of diversified IT experience in software analysis, design & development using Oracle as backend. Expertise in SDLC, ERP customization, quality process & procedures and agile methodology (SCRUM and Kanban).

Good understanding of banking, financial services, manufacturing and publishing domains.

In-depth knowledge of application design and development, data modeling, data conversion, data migration, bulk data load.

Extensive experience in writing/creating stored procedures, functions, packages, triggers, table and views, clusters, global temporary table etc.

In-depth knowledge of SQL and PL/SQL with advanced features, like oracle text, transaction-based messaging with advanced queuing(Oracle AQ), collections, object types and records, java stored procedures, materialized views(MV), table partitions, pipeline table functions and analytic functions etc.

Expertise in identification performance relates issues in the application by using explain plan, SQL trace & TKPROF, statspack report and tune the application by using query rewrite, indexes(text index & XML index), hints and table partitions.

Knowledge in ETL, data warehouse tool (ascential data stage), data transformation tool (Talend, WTX8), MQ series and BI tool(Business Objects).

Good knowledge of oracle APEX4.0, UNIX, shell scripting, SSH, FTP/SFTP.

Good understanding of agile development and test driven development. Trained in SAFe 4.0 (Scaled Agile Framework) for lean Software and Systems Engineering.

Good knowledge of cloud computing (AWS, OpenStack, Platform9).

Professional Experience

EBSCO Information Services, Ipswich, MA Dec2011- Till Date

Database Engineer-Oracle

Responsibilities

Involve in schema design.

Involve in maintaining EBSCO main interface written in C#.

Involve in writing/reviewing PL/SQL code (packages, functions, procedures).

Query Optimization and PL/SQL code optimization.

Extraction, Transform and Loading (ETL) data into main schema from other data sources using Talend & external tables.

Requirement gathering of ongoing projects and involve in design and discussion.

Data mapping, data import/export and migration from various legacy system into oracle.

Environment: Oracle 10g/11g, TOAD, JAVA/PERL, Talend, C#, MS-Visio.

ISO New England, Holyoke, MA Mar2011–Dec2011

Sr. Oracle Developer

Responsibilities

Involved in BLT system (in house application) design.

Collaborated in preparing functional & technical design document after gathering business requirement.

Wrote procedures, functions, packages and triggers for the BLT system.

Helped in tune the application by optimizing SQL queries and PL/SQL code.

Wrote Unit Test cases and tested application as per user requirement.

Fixed any identified defects.

Environment: Oracle 10g/11g.

ProQuest, Ann Arbor, MI Jan2010–Mar2011

Sr. Oracle Developer

Responsibilities

Designed & code, application components in an agile environment using test driven development approach.

Involved in writing/reviewing PL/SQL code and query/code optimization.

Implemented and managed oracle AQ at Inbound & Outbound flow of the system.

Involved in Schema registration, validation XML document against registered XML schema in Oracle.

Collaborated in various search capability on 800 million XML stored documents by using Oracle Text.

Developed backend interfaces for providing XML processing capabilities by using Xquery, XML Schema, XPATH, XSTL, Oracle XDB, Oracle Text, Stored Procedures, Functions and Packages etc.

Involved in creating/Managing Oracle Text Index, XML index for improving the search performance of application.

Involved in Ad hock report development in APEX 4.0.

Environment: Oracle 10g/11g, TOAD, JAVA/PERL, Oracle APEX 4.0.

Royal Bank Of Scotland(RBS), Chicago, IL Aug2005–Nov2009

Team Lead/SME

Responsibilities

Involved in managing a team of offshore developers.

Involved in gathering business requirements, analysis for new development/enhancements. Based on requirement, designed and developed the database changes.

Responsible for creating functional specification and technical design document for other groups of the project (Business, System test team, UAT team, Production support team etc).

Developed backend interfaces, on around 1TB data volume, by using PL/SQL Stored Procedures, Functions, Triggers, Views and Packages etc.

Involved in Performance tuning of application by using Explain Plan, SQL trace and TKPROF etc.

Created the required tables, indexes, table relationships, views, synonyms and used DB Links to connect the ODS in Data Warehouse to get the status of the customer’s other details.

Wrote complex Materialized Views to refresh the large volume of data from different tables for which data get available for BI tool (Business Objects).

Extensively used advanced PL/SQL concepts like Global Temporary table, Collections (Bulk Collect, Varray, Nested Tables and PL/SQL Tables), Pipeline Table Functions for performance improvement of application

Extensively used Oracle AQ functionality and Implemented Enqueue and Dequeue process to make available data for other entities(WTX8) into queued form for further processing.

Extract, Transform and load (ETL) data into main schema from different data sources.

Provided technical guideline to Production Support Team and worked closely in co-ordination with system test team.

Created database jobs (10g) for data archival from main application tables to history tables for improving performance of application.

Environment: Oracle 9i/10g/11g, TOAD, Servlets, Java, Java Scripts, Mercator 6.7, WTX8, Business Object 6.5, Entrust Authority 7.1, SunOS 8.5, Win2000, WSAD 5.1, WAS 5.0, IBM MQ.

ABN AMRO, Ann Arbor, MI May2005 – Aug2005

Sr. Oracle Developer

Responsibilities

Involved in database design for mortgage and loan processing system.

Collaborated in preparing functional & technical design document after gathering the requirement from business users.

Developed the application and wrote Procedures, Functions and Packages, Triggers.

Collaborated in oracle forms/report development for the application/business users.

Helped the front end team with the integration of the front end and backend components.

Helped in tune the backend application by optimize the SQL queries by using the advanced features of Oracle9i like Bulk Collect, Bulk Update etc..

Worked in very tight schedule due to very short project duration.

Hind Industries Ltd. India Mar2003–Apr2005

Oracle Developer

Matrix Infosoft, India Apr2002–Feb2003

Analyst/ Programmer

Micro Infotech, India Jun1997–Mar1999

Computer Programmer

Technical Skills

Languages : SQL, PL/SQL, Java, C#

Database : Oracle 9i/10g/11g, SQL-Server 2008, MySQL, MS-Access, FoxPro, PostgreSQL

Tools : Toad, PL/SQL Developer, Oracle APEX 4.0, Oracle Forms 6i, Report 6i,

Data Stage 7x, Harvest(Version Manager), VSS, PVCS, CVS, SVN, Entrust MS-Visio, Authority 7.1, Test Director, Quality Center, Business Objects(BO) 6.5, WTX8, MS-Visio, FTP, FileZilla, Peregrine(Incident Management), ServiceNow, Talend, JIRA, Rally(CA Agile Central), GIT.

Operating Systems : Windows2000/2003 Server, Win95/98/NT/XP/2007, Unix(Solaris 8/10), RedHat Linux 7.1, MS-DOS6.22.

Certification: Scale Agile Framework 4.0 (SAFe 4.0) practitioner. Mar 2017 – Mar 2018 License 390*****-****

Cloud: AWS, Open Stack, CloudSQL

Others : EDIFACT, SWIFT, XML etc., MQ series, SPSS, Matlab, Minitab, Docker, CARA, Zabbix, ATDD and TDD.

Education

Masters in Computer Applications (MS) in (1999- 2002) from JHU N. Delhi, India.

Masters in Statistics(MS) in 1995 from Rohilkhand University, U.P.- India.

End of Resume

Contact this candidate