Post by RisingSoftRoles and Responsibilities - Summary
Responsibilities include providing Technical and Functional support
for the Oracle Application including Procurement, General Ledger,
Accounts Payable and Fixed Assets and AOL(Application Object Library).
Technical support includes day to day troubleshooting, onsite
development activities (ie) creating new process, as well as
customization of existing reports, forms and workflows.
Work with On-Demand to ensure smooth production operations as well as
cemili rollover from Development to Production.
* Strong communication skills and ability to communicate with end
users, developers and Oracle On Demand with respect to Production
problems, errors, functionality and reports.
* Strong problem and service request solutioning skills.
* Strong troubleshooting abilities for all work requests, including
problems logged with Oracle On Demand. Ability to review Sr's daily,
provide updates, and ensure that customer status SR's are responded
to promptly.
* Leadership/proactiveness/resourcefulness associated with reviewing
Sr's, existing environment, networking with IBM's Oracle Practice,
making suggestions, recommendations for improvements etc..
* Ability to participate in projects and testing related to patches,
upgrades for databases and application components.
Roles and Responsibilities
o Workflow administration.
o Adhoc Reporting (create queries to provide information to internal
customers including auditors)
o Support monthly close activities
o Troubleshoot issues (ie: identify bugs) Define problem
o Work with Oracle through Metalink to log and resolve issues
o Work with business users in analyzing and defining business
requirements and translate those requirements into functional and
technical design specifications.
o Configuration of new features
o Testing (involves setting up of test cases and test scenarios)
o Work experience in 11i Financial Applications (11.5.9 and 11.5.10 )
o Full understanding of Oracle modules. (FA, AP, PO, GL)
o Experience in multi-org environments
o Experience with multi currency operations
o Work experience with multi language installations
Technical Skills
o Expertise in Oracle 9i, SQL, PL/SQL. Database 10g
o Expertise in Oracle Forms, Oracle Reports, Oracle Alert and Oracle
workflow builder.
o Experience working in Unix / Linux operating systems.
Please forward resume with rate and contract details to
Mohammad Sheraz
***@yahoo.com
1520 Ocean Ave, #3E. Brooklyn. New York
Phone :-( 646)436-9397
Summary:
* Seven years of IT experience in all phases of software development
life cycle including analysis, design, development, testing and
implementation, which includes four years in the United States.
* Good experience in Business Objects Suite (5.x/6.x/XIR2), Designer,
Desktop Intelligence, Web Intelligence, Broad Cast Agent, Central
Management Console/ Supervisor, Performance Management/ Application
Foundation.
* Extensive and proven experience using Oracle 9i/8i/8.0/7.x, SQL, PL/
SQL, SQL, Forms 6i/5.0, Reports 6i/3.0, SQL*Loader, UNIX (Shell
Scripts), JAVA, PERL, PRO*C on UNIX and Windows NT/2000/95 platforms.
* Strong experience in designing, building medium to large-scale
client-server applications using Oracle, PL/SQL, Stored procedures.
* Extensive working knowledge in Analysis, Design, Documentation and
Deployment.
* Performed Data Migrations using SQL*Loader and PL/SQL scripts.
Developed SQL.
* Programmed to load data from Excel file into temporary table and
developed PL/SQL program to load data from temporary table into base
Tables.
* Involved in various activities like preparation of functional and
technical documents, discussions with the client regarding the
proposed solution, PL/SQL programs scripts, related reports and forms,
unit level and user acceptance testing.
* Extensive experience in writing SQL queries, Procedures, Functions
and Triggers.
Strong Math Fundamentals with problem solving and analytical skills.
* Performing and monitoring Database Backup and Recovery.
* Expert in using Database Tool like SQL * Loader, Import and Export.
* Used Repository manager to create Repository, User groups, Users and
managed users by setting up their privileges and profiles.
* Have excellent analytical abilities & strong work ethic.
Consistently demonstrated strong teamwork and ability to make a long-
term commitment to projects.
* Experience in Designing, Building and maintaining the universes,
resolving the issues like loops and Traps using Alias and Context.
* Handled administrative tasks via Business Objects XI R1/R2 for
reports publishing, scheduling and user security. Set up predefined
access levels for the deployed reports. Setup the new user group and
assign the security privileges to inherit to all added users to the
group.
Gathered requirements and wrote functional and technical
specifications for developing crystal reports.
Education:
Master in Computer Science. 1992 - 1994
The City College Of New York.
City University of New York(CUNY).U.S.A.
B.Sc. Computer Engineering. 1983 - 1987
University of Engineering & Technology.
Software/Hardware:
Oracle 10g/9i/8i/8.0/7.x, Ms-Access, SQL, PL/SQL, TSQL, C, C++, PRO*C,
SQL*Plus, Java2, Forms 6i/5.0/4.5, Reports 6i/3.0/2.5, V.B 6.0/5.0,
SQL*Loader, ETL, TOAD, SQL Navigator, Export/Import, SQL*Net/Net 8,
HTML, DHTML, XML Schema, Perl, Java Script, MS-Office, MS-Word, Excel,
Power Point, Windows NT/XP/2000/98/95, MS-DOS, UNIX , Business
Intelligence Tools Business Objects XI R2/ 6.x/5.x (CMC, Designer,
Desktop Intelligence, Web Intelligence, Info View, BCA, Import
Wizard), Crystal Reports XI.
Experience:
Mid First Bank,
NY Apr
2005 - Current
Oracle Developer (SQL, PL/SQL)
Mid First Bank is a diversified financial services company that
provides a broad range of personal banking, business banking,
investment services and rapid loans. The main transactions are Account
balances, Transfer funds, Check imaging, Current and previous session
summaries and online statements.
Responsibilities:
* Involved in System Analysis, Design, Coding, Testing, Data
conversion, Development and Implementation.
* Coded SQL Scripts to create the Development Database, Testing
Database, Production Database, including Table spaces, added data
files to table spaces, managed redo log files & control files,
Rollback segments creation, Users, Synonyms, Roles, profiles.
* Involved in creation of Database Tables, Global Temporary Tables,
Cluster Tables, Partition Tables, and Index-by Tables using storage
parameters, created Database Links and Snapshots using Oracle 9i.
* Extensively involved in writing SQL queries (Sub queries and Join
conditions), PL/SQL programming.
* Involved in creation of Sequences for automatic generation of
voucher numbers and views for hiding.
* Written many stored procedures, stored functions, Packages and used
in many Forms and Reports. Importing/Exporting data from/to different
databases using utilities like SQL*Loader, Import/Export, Textron
Package and Copy Command (Migration).
* Involved in writing External Routines using Pro*C and PL/SQL
Wrappers.
* Written many database triggers for automatic updating the tables and
views.
* Involved in doing Service Center Tickets every day depending on the
severity level.
* Involved in interaction with the End Users and implemented reviews
of the application.
Environment:
Oracle 9i/8i Pro*C, SQL*Plus 8.6, PL/SQL 8.6, Designer/2000,
SQL*Loader, UNIX (IBM AIX 4.0), Windows NT/2000/95, SQL Navigator 4.3,
MS Outlook 98/2000
Canadian Imperial Bank.Toronto,
ON Dec 2002 - Apr 2005
Oracle Developer
CIB working to expand homeownership opportunities by creating products
and technologies that help more people own homes. This project is
design and developed for complete automation of all Front Office and
Back Office operations of the organization, which consist of modules
like Over Draft, Bills, Cash, Clearing and Cash Management.
Responsibilities:
* Involved in CBO - Cost Based Optimization. Did designing, PL/SQL
programming and worked in ETL applications, SQL tuning and data
modeling.
* Created PL/SQL, Stored Procedures, Functions and created several
database triggers for implementing integrity constraints. Developed
DLL's and Scripts and did SQL loading.
* Involved in creating SQL queries. Developed forms and reports using
Forms 4.5 and Reports 2.5. Re-linked Oracle applications programs.
* Wrote SQL statements, SQL Query tuning, views, cursors, schemas and
PL/SQL code.
* Created SQL*plus reports as per client's various needs, and
developed business objects.
* Involved in creating package, external and stored procedures and
database triggers.
* Involved in Software Code Analysis.
* Developed database triggers include the part of an existing trigger
framework
* Implemented in PL / SQL code and external procedures. Analyzed
existing trigger framework.
Environment:
Oracle 9i, PL/SQL, SQL*Loader, Stored Procedures, SQL Query, DLL,
Forms 5.0, Reports 3.5, SQL, WindowsNT/2000/98
Copperkey Technologies, Boston,
MA Feb 2001 - Nov 2002
Oracle Developer - DBA
During the development of Integrated Material System, I was working as
an Oracle Developer, involved in Designing Logical and Physical
Structure of the Database, Installing Oracle, Creating Oracle
Database, Creating table spaces, Creating Users, Backup and Recovery
Strategy, Performing Backup and Recovery, Performance Tuning.
Responsibilities:
* Extensively worked in Client-Server application development using
Oracle 9i/8i/7.x, PL/SQL, SQL*Plus, SQL*Loader, SQL Trace, Explain
Plan, Pro*C.
* Extensively worked on Procedures, functions, stored packages,
database triggers.
Extensively worked on Shell Scripting for automating the jobs.
* Held positions where major responsibilities included coding and unit
testing reports.
* Involved in DBA activities like taking Physical backup / Logical
Backup and space management.
Involved in writing PL/SQL Packages, Functions and Stored Procedures
and DBTriggers.
Writing stored procedures and complex SQL queries.
* Involved in database activities like taking logical Backups using
import and export Utilities.
* Developed database objects like tables, views, indexes, and
sequences.
* Wrote SQL Scripts for reports and creating views for reports.
Environment:
Oracle 7.x, PL/SQL, Stored Procedure, SQL*Loader, Solaris 7 and NT
4.0, Microsoft Visual Basic 6.0, Oracle 8i, Windows NT
UBTEC Canada Inc., Ontario,
Canada Sep 1999 - Jan 2001
Oracle Developer
Responsibilities:
* The reports were built to help the top-management and policy-makers
of the department to perform different types of analysis. The reports
enabled the top-management to discover the trends in sales & purchases
across the financial year. The development and deployment of reporting
system using Business Intelligence technology.
* Actively involved in Analysis of the product. Creating and
maintaining the data base. Connecting and querying the database.
Interacting with team members. Testing and debugging the errors.
Implementing the code. Developed technical and documentation of the
project.
* Developed complex Oracle forms providing extensive GUI features
(multi-selects drag and drop, graphical charts, mail notifications,
automated system alerts and notifications, System Timers etc).
* Extensively written PL/SQL code for Procedures, Functions, Packages,
Libraries and other database triggers etc.
* Written interfaces to transfer/interact data with various external
systems.
* Created and standardized object libraries and coding standards.
Implemented various code-review procedures for achieving consistent
look and feel across the application.
* Created form templates and report templates. Creating visual
attributes, property classes, object libraries and sub classed them to
objects in the form to give a standard look and feel. Used reusable
components.
* Added calendar list of values window to buttons associated with date
items. Created timers to repeat certain processes after a certain time
interval expires.
* Designed and developed reports of important shipping documents such
as Chain of Custody, Transfer of Samples to Lab, Label printing etc.
* Managing Table spaces, Rollback segment, Indexes for various
applications like Financials Accounts, Inventory Control System and
Payroll & Personnel Administration System.
* Designing tables before creation. I am responsible for planning and
setting storage parameters for tables based on information from the
programming staff about how application works and the type of data
expected.
* Ensuring the database backup is regular by doing regular offline
table spaces and data files backup.
* Gathered requirements from end users to create reports. Built full
client and Web Intelligence reports. Created Ad-hoc reports using
Business Objects functionalities like Slice and Dice, Drill Down,
@Functions, Cross Tab, Master Detail and Formulas etc.
* Created Report Templates for consistency in the look and feel of
the reports. Created graphical representation of reports such as Bar
charts,
* Pie charts as per End user requirements. Created variables, formulae
and detail objects at report level. Created User Prompts, Conditions
and Filters, Alerter to improve the report generation.
* Used various Business objects functionalities like Sections, Breaks
and in generating documents. Scheduling and monitoring reports using
Broadcast Agent server.