Sql Server Oracle

Feroz Wahid

Cell: 647-***-**** ***********@*****.***

Summary

Over eleven years of extensive experience in Information and Technology focusing in banking, logistics, and retail industry

11+ years experience working with and developing RDBMS schemas (Oracle, SQL server and MySQL).

Strong hands on experience in Oracle database administration, production support, installation, configuration, performance tuning, and backup/recovery on multiple platforms like Sun Solaris, Red Hat Linux and Windows

Database software installation, patch and upgrade to BAT and production servers.

3 years experience in Data Warehouse and worked on ETL tool such as Informatica.

Created database objects like Stored Procedures, Functions, Packages and Triggers in Oracle and SQL server.

11 years experience working with Crystal reports,

3+ years experience working with OBIEE, Cognos, Oracle reports and Oracle forms.

2+ years experience working with VB, Java, HTML 5 and Javascript.

Excellent team player with problem-solving and troubleshooting capabilities; quick learner, highly motivated and results oriented.

Education

Bachelors in Computer Engineering 2002

MD University, India

Advanced Diploma in Computers 2014

Sheridan College, Canada

Technical Skills

Databases:

Oracle DB (9i-12c), MSSQL (2005-2012), MySQL

Development Tools:

Crystal Reports (8-11i), OBIEE, Cognos, Oracle reports, Oracle forms, SSRS, PowerBuilder, Toad, Sql*Loader, Eclipse, Netbeans, Informatica, Warehouse Management System(Exceed), Oracle Retail (RMS, ORSIM, ORPOS, RPM, ReIM, RIB), Oracle E-Business Suite R12

Languages:

PL/SQL, T-SQL, VB6.0, Java, JSP, HTML 5, JavaScript, PHP, XML, Mobile jQuery

Platforms:

Windows, Linux, Solaris

Web Servers:

Tomcat, WebLogic

Fusion Middleware:

Oracle SOA Suite, BPEL Process Manager, WebLogic

Packages:

MS Office, Visio, Project

Professional Experience

Database Analyst TD Bank, Toronto, Canada May 2014-Till date

Responsibilities

Daily management, administration, monitoring, and support of Oracle databases on Linux Platform.

Maintaining various databases in production and development environments using SQL Server 2008/2012 on windows platform.

Strong experience in report development using Oracle OBIEE tools

Working on Oracle Fusion HCM Cloud (11.1.8.0.0).

Creating complex reports and dashboards using Crystal Reports and OBIEE (11.1.1.7.20) in Oracle 11g and SQL server which comprise of sub-reports, graphical reports, drilldown, conditional formatting, complex formulas and running totals.

Experience gathering and documenting report requirement s, process mapping and data mapping.

Developed and maintained Oracle PL/SQL code, including packages, stored procedures, and database schema structures.

Working knowledge of PeopleSoft application.

Provide training to users about DMTR and OBIEE tools.

Prepared test scripts, conducted performance testing and documented test execution results.

Oracle Developer Zawyamart, Dubai, UAE Mar 2011-Jan 2013

Responsibilities

Installed and configured Oracle 11g (11.1.0.7.0) and Oracle Application 10g (10.1.3.4) on Linux platform.

Managed daily administration, maintenance, monitoring, and support of Oracle databases.

Responsible for regular backup, recovery & tuning of databases.

Administration and configuration of ORPOS, ORSIM, RIB, ORRMS, ReSA and RPM.

Created reports and dashboards using OBIEE (10.1.3.4).

Worked on Oracle Fusion middleware (SOA suite and WebLogic Server).

Ran daily batches and processed RTLOGS.

Updated items & price files for back-office. Monitored daily health on POS (Queue clogged).

Installation, administration and configuration of POS, BO and CO for new stores.

Validated sales data of POS, RMS & ReSA.

Implemented and tested Oracle Financial R12 GL, AP, AR and purchasing modules.

Performed configuration setup for AP, AR and GL, including budgets, multi-org & multi reporting currency.

Performed business requirements mapping for GL, AP, AR and Purchasing.

Logged, monitored and closed Technical Assistance Requests (TARs) online: Oracle Metalink and Oracle Applications Patch Management

Application Analyst, Dubai, UAE

Ayezan Logistics Feb 2011-Mar 2011

Agility Logistics Aug 2009-Nov 2010

Zainal Mohebi Group Jun 2007-Jul 2009

Responsibilities

Responsible for administration, maintenance, monitoring, tuning, support, backup, and recovery of Oracle databases on Solaris and Windows platform.

Created and maintained various databases in production and development environments using SQL Server 2005. Installed and configured SQL Server Reporting Services.

Created reports using Crystal reports, SSRS and PowerBuilder 5.

Created procedures, packages and functions in Oracle and SQL Server.

Created and implemented put-away, replenishment and picking strategies.

Administered and configured WMS, Portal and Boomi.

Configured WMS as per user requests; checked and resolved billing automation process for errors.

Deployed new Wex files. Integration of WMS with other client software’s through Boomi.

Created documents/SOP on DR Exceed servers.

Installed, configured, and administered of TAMS and Biostar.

Monitored RF devices & troubleshooting errors.

Programmer BMA International, Dubai, UAE Mar 2006-May 2007

Responsibilities

Administered and maintained Oracle 9i/10g and SQL Server 2005 on Linux and Windows platform.

Performed tuning, backup and recovery of Oracle/SQL databases.

Client/Server technology using Forms 6i & Reports 6i as front-ends with Oracle 9i as back-end.

Prepared advanced reports using SQL Server Reporting Services and Crystal reports.

Created procedures, packages and functions in Oracle and SQL Server.

Datawarehouse Analyst GE Capital, India Mar 2003-Jan 2006

Responsibilities

Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.

Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup .

Supported multiple business functions, like risk analytics team, CRM analytics team, sales and marketing, and collection teams, for their analytical requirements, scorecard development and implementations. Customer interaction on functional and technical matters.

Managed the production data-warehouse upload. Ran 11 upload procedures used for monthly uploading of data from OLTP database to data mining database.

Defined and managed Service Level Agreement (SLA) with business users.

Developed procedures, and created packages and functions in Oracle and SQL Server.

Created reports in Crystal reports and Cognos using Oracle 9i and automated them for weekly, monthly and yearly schedule using Crystal reports.

Contact this candidate