AMIR SHAHARYAR SIDDIQUI

Email: ad2vdm@r.postjobfree.com, Cell: 416-***-****

PROFESSIONAL SUMMARY

Highly Proficient & focused Certified Oracle Database & Application Developer/Analyst.

Having a successful 15+ 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;

oBanking & E-Commerce

oTelecommunications

oInsurance (Auto/Property)

oFinance/Accounting/Taxation

oTransportation/Parking Permits

oGovernment Billing / Payments

Possess a Master’s degree in Computer Science and Oracle certification.

A diligent & result oriented team player, with excellent analytical and problem-solving skills.

Have strong interpersonal, verbal and written communication skills

AREAS OF EXPERTISE

Planning/Designing/Creating Databases, Developing DB Stored Procedures/Functions/Packages/Triggers

Application Development in classic desktop CUI/GUI platforms as well as Web based n-tier applications

Requirements Gathering & Analysis and Data Modeling using ERD/O-ERDs

System Designing (using Flow chars, Data flow diagrams, Process flows,..) with Impact Analysis

Advanced Oracle PL/SQL Programming (enhancing performance using PL/SQL tables, Bulk Collect & Forall, Dynamic SQL with bind variables, Code instrumentation/tracking using DBMS_APPLICATION_INFO, DBMS_UTILITY,.. packages.

Advanced Oracle SQL tuning using explain plan, SQL hints, parallel processing, updating statistics, MVs, index rebuilds.

In-depth Web application development in Oracle APEX, which includes both SQL, PL/SQL expertise as well as several other WebDAV technologies including HTML5, JavaScript, CSS3, JQuery, AJAX. Report Designing in Oracle BI Publisher.

Prepare and Maintain Technical Documentation (Business and Functional Req. Docs, HighLevel & Detailed Design Docs,.)

In addition to Oracle database & tools, also have very good hands-on experience with MS SQL Server database, writing SQL queries and T-SQL procedures, creating ETL packages with SSIS, designing reports with SSRS.

Good working knowledge of other RDBMSs including MySQL, PostgreSQL, Informix and NoSQL Cassandra database.

Exposure to latest web & cloud-based technologies, proficient in most modern languages (Java, C++/C#, Python)

Great working experience in different ETL/EL-T tools for data manipulation/migration. These include tools like Oracle Data Integrator (ODI), MS SSIS, and writing several types of scripts such as SQL*Plus script, Shell scripts, Stored procedures.

Experience with Business Intelligence tools like Oracle BI Publisher & EBS applications and Microsoft SQL data tools.

Proficient with Software life cycle tools including Git, Bit-bucket, SVN, JIRA, Confluence, Jenkins,…etc.

Worked in Agile, DevOps methodologies as well as traditional ones (Waterfall, RAD,..)

TECHNICAL PROFICIENCIES

Databases:

ORACLE (Ver: 9i to 20c), MS-SQL Server, MySQL, Informix, PostgreSQL, Sybase and Big data, NoSQL distributed Databases Cassandra, MongoDB.

Languages/Development Tools and

Web Based Technologies:

Oracle SQL, PL/SQL, APEX 5.x/19.x, Oracle Forms & Reports 10g/11g, SQL Server T-SQL, SSIS, SSRS, Java, Visual C#.Net, Python, C/C++, HTML5, CSS, JavaScript, AngularJS, JQuery, ReactJS, AJAX, JSP, ASP.Net, PHP, Crystal Reports, Jasper Reports, VB6, 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, MySQL Workbench, Net Beans, Eclipse, CVS, SVN, GIT, Jenkin.

Operating Systems:

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

EDUCATIONAL QUALIFICATION AND CERTIFICATIONS

Master's Degree in Computer Science

Oracle Certified Associate (Oracle PL/SQL Developer Certified Associate)

Numerous Computer courses and on-the-job training

PROFESSIONAL EXPERIENCE HISTORY

Ontario Public Service, Ministry Sep. 2020 – Current

of Education Ontario, Toronto ON.

Role: Oracle APEX and PL/SQL Developer/Analyst

Project(s): Design and Develop multiple applications related to ministry financial systems.

Currently working as an Oracle APEX/PL-SQL developer. Working on multiple applications related to ministry financial systems. Here are brief details of responsibilities and projects.

Responsibilities:

The main responsibilities include development of new system enhancements, working on business CRs, as well as maintenance of multiple existing web applications using Oracle APEX, Oracle SQL & PL/SQL and Oracle BI Publisher tool. Involved in all phases of SDLC including requirement analysis, database/application designing, developing back end and front-end components, unit testing, helping in QA and UAT testing and Implementation to PPE, QA and PROD environments.

Projects:

Working on multiple projects to automate the financial systems that involve payments from the ministry to different educational institutions and boards in Ontario. There are many different systems, which are named EFIS (Educational Financial Information System), FMA (Funding Model Administration), CFIS (College Financial Information System) and many other similar systems. EFIS basically deals with all payments to Ontario’s school boards and Early Years (Child care) centers. FMA deals with payments to province’s Universities, Colleges and some 3rd party organizations, CFIS deals with specific requirements for college finances. All these systems are huge and involve many Oracle databases, procedures/functions/packages, Oracle APEX applications, BI Publisher reports layouts and queries, Oracle Data Integrator (ODI) jobs, and some Unix shell scripts. Involved in working with all these tools, developing front end application pages, Reports and back end DB program units. We also work on AODA compliance for our web applications and many of our applications are fully AODA compliant now.

Environment:

The main technologies used are Oracle APEX 18/19.1, SQL, PL/SQL(19c), Oracle BI Publisher, Oracle ODI, Unix scripts & GIT for source control.

Virtusa Canada, Toronto, ON Oct 2019 – Jul 2020

Role: Sr. Database Application Developer

Project: Migration from Sybase to Oracle (Programs and Data)

Application: Oasys Financials (Client: Citi bank)

Worked on a project that involved Sybase to Oracle database migration. This project deals with trade capture data for over the counter derivative deals. The amount of data is huge and there are thousands of Unix shell and Sybase SQL scripts that need to be converted to Oracle PL/SQL Procedures. In addition, worked on a linked system which was using MySQL database, from which data had to be extracted and based on that, the data in Oracle database needed to be updated, wrote MySQL Scripts and Stored procedures for it.

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 scripts/stored procedures

Develop ETL & data migration scripts & PL/SQL programs that will replace Sybase and Unix shell script code.

Did Java development for accessing data via WS, used Autosys & Oracle jobs schedular (DBMS_SCHEDULAR) to schedule jobs.

Develop MySQL procedures and batch scripts. Generate sample data for testing and perform Unit testing of code modules

Environment:

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

City of Toronto, SCC, Scarborough, ON Oct 2017 – Oct 2019

Role: Senior Oracle (APEX and PL/SQL) Developer (Contract)

Applications / Projects:

Solid Waste Management system (SWMS),

On-Street Parking Permit and Car-Share Vehicle Parking Permit systems (OSPPA, CVPP),

Road Allowance Control System (RACS), and support tasks in multiple other related systems.

Many other small changes such as PCR’s, small enhancements in other systems, and support their deployment.

Worked in a contract job as Sr. Oracle Developer at the City of Toronto. Took part in the analysis, design, and development of multiple projects. Mainly used Oracle APEX and SQL, PL/SQL development, and also worked on Java development, Crystal Reports and Jasper Reports for different kinds of tasks, especially report development & printing. Also worked on some projects which used MS SQL Server database, wrote MS SQL stored procedures. This was truly a multitasking role, with active involvement in all phases of SDLC.

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, system maintenance and migrate new Apps/DBs to Oracle cloud.

Environment:

Oracle 11g & 12c, Oracle SQL, PL/SQL Development, Front end Development in Oracle APEX (v5.1 & 18), SQL Server, Java, ASP.Net, C#, JavaScript, Crystal Reports, Jasper Reports, and shell scripting. Used JIRA, Bit-bucket, Jenkin for software life cycle/source control and continuous integration.

TCS Canada, Brampton ON Jun. 2013 – Oct.2017

Role: Senior Database / Application Developer

Applications/Projects (Client: Rogers Communication Canada)

Rogers.com and Fido.ca portal’s product catalog support including a few sub-systems,

Rogers dispatch tool (Technicians scheduling), It had 4 sub-systems,

Rogers E-Biz system for their devices supply chain,

Rogers Common Inquiry systems (RCIS) for Rogers customer care (For combining data for all customers including wireless, Home Phone, Cable TV, High speed Interne &, Smart Home monitoring systems and place it in 1 common Oracle database).

Worked as Senior Database developer in a fast-paced Agile based environment. The major role was as a Sr. Oracle Developer/Analyst, with active involvement in requirement analysis, system designing, coding with unit testing and QA, UAT & Production support. Also used MS-SQL Server database and .Net languages for some systems and deployed these systems to MS Azure cloud.

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 in PL/SQL, 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.

Generate data in Test database using some ad hoc SQL, PL/SQL, T-SQL scripts and performing Stress testing.

Develop Rogers devices’ supply-chain system in Oracle APEX 5, this system involved designing screens/reports for devices sales, purchases, inventory updates & others related operations. It had interactions with other systems in Java Spring framework, JSP,.etc.

Develop RCIS system to consolidate data for all customers from different sources in different types of DBs to 1 Oracle database(DW).

Supported Rogers Dispatch tool built in Windows Desktop application in C#.Net, using MS SQL Server(2012) database at back end.

Provide support to QA, UAT teams and Production implementation team during deployment phases.

All these systems were huge. For example, in product catalog, the company offers many different services including Wireless & Home Phones, Cable TV & internet service and smart home monitoring. The Rogers dispatch tool, Devices supply chain and Rogers's customer care systems are even bigger and complicated. All these systems include several sub-systems, configuration settings and geo-spec rules.

Environment:

Oracle SQL, PL/SQL with Oracle 11g & 12c, Oracle APEX 5.0, Java, MS SQL 2012, C#.Net, MySQL, Javascript Unix shell scripts. JIRA, GIT and Jenkin for project tracking, source control and automatic deployments.

Elavon Canada Inc, Toronto ON Mar. 2011 – Jun. 2013

Role: Senior Oracle Developer

Application: Virtual Merchant (E-Payments Processing) Application

Projects: Multiple projects in 2.5 years period

Worked on a big system that handled electronic payments processing of all major electronic card types. These include Credit cards (Visa, Master, Amex…), Debit cards, Gift cards, e-Checks, Cash benefit cards, and Food stamps. This is a huge system and growing continuously. This system is being used on the internet worldwide, and thousands of merchants use it for e-payments. Worked on multiple projects in this system (+ many sub-systems). We had tight deadlines, I was involved in all phases of SDLC as a senior Oracle resource. Did major development in Oracle PL/SQL, but also worked on some Java tasks. Used both waterfall and agile methodologies.

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 (in PL/SQL, Java, JSP, Struts framework), 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 bulk data in the UAT database (clode to PROD data) with some ad hoc SQL, PL/SQL scripts and performing Stress testing.

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.

Sigma Software Solutions. Toronto ON. May. 2010 – Dec. 2010

Role: Oracle PL/SQL Developer/Analyst

Project: Design and Develop Billing system for CAN

Application: Telecommunication Billing multitier application

Worked as a Database back end developer. The main responsibilities include requirement analysis, database/application designing and developing back end procedures/functions/packages in Oracle PL/SQL. Also did routine DBA tasks to support DBA team.

Responsibilities:

Worked on a project to automate the billing process of ACN telecommunications (Canada/US). This was a huge system and included billing requirements for multiple products/services like home/cell phones, long-distance services, calling cards, multiple features and rate plans. This was the main project of the job. The role was basically a back-end programmer/analyst (with taking part in tasks like requirement analysis, system designing, testing, deployment & support) The project was high profile and had very tight deadlines.

Environment:

The main technologies used were Oracle SQL, PL/SQL (11g), UNIX shell scripts and some Java/C++ programming, CVS for source control

Rogers Media Inc. Toronto ON. Dec. 2007 – May. 2010

Role: Database Developer / DBA

Applications / Projects:

User management system (UMS), for maintaining data for users registered online to Rogers Media (Magazines) web sites.

Emailing systems which keep data about user subscriptions to newsletters, and automatically send emails to those users.

Systems for online discussion forums, which maintained information of all registered users, and forums information like topics, forums, threads, messages, attachments, etc..

Some other small web apps like shopping carts, recipes, contests, etc.

Worked as Oracle Developer/DBA. This position was responsible for performing both the development and DBA tasks. As a developer, developed comprehensive database back-end procedures and packages (PL/SQL). As DBA, supported other developers, QA teams & project managers about all aspects of database configuration/maintenance throughout full SDLC. The overall responsibilities can be summarized as below:

Responsibilities As Database Developer:

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 tasks/tickets. This included both Oracle & MySQL.

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.

Responsibilities As Database Administrator:

Creating and configuring databases, schemas, and objects for different projects,

Keep the database available and in a healthy 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

References Available Upon Request

Contact this candidate