Oracle PL/SQL Developer - Data Analyst - SQL Developer
Resume:
Hassan Moghbeldoost
************@*****.***
Irvine, CA
SUMMARY:
. 12 Years of IT experience which includes Analysis, Design,
Development, Implementation and Software Configuration Management of
Client/Server based Business Applications in an Automotive Parts
industry.
. Proficient in writing Stored Procedures, Functions, Packages, Database
Triggers, Create Tables, Views, Complex SQL queries, Indexes and
Constraints using PL/SQL (Oracle), Oracle SQL Developer Data Modeler
and Oracle Form/Report Builder and good on Studio Management (SQL
server) and Microsoft Access.
. Proficient in Analyze Client Requirements, Logical Data Modeling and
Database Objects Design.
. Hands on experience in Software Configuration Management using
Microsoft Visual Source Safe.
. Excellent Experience in Inventory Management Systems, Ordering (MRP),
Delivery Systems and Integrated SCM (Supply Chain Management) Systems.
. Equally effective in working independently as well as a Team Player
with problem solving capabilities.
. Excellent Interpersonal skills, Good Communication and Presentation
skills.
TECHNICAL SKILLS:
DB Programming SQL, PL/SQL,T-SQL
Languages
Database Oracle 8i/9i/10g/11g, SQL Server 7/2000/2005/2008 and
Microsoft Access
Oracle PL/SQL Developer, TOAD, SQL Developer, SQL*PLUS, Oracle
Tools Designer, Oracle Form/Report Builder 6i &11g, Oracle
Discoverer, Oracle SQL Developer Data Modeler
SQL Server Tools SQL Server Management Studio, Query Analyzer, DTS, SSIS,
SSRS
Project Mgmt. Tools MS-Project, Concept Draw Office Project
Software Visual Source Safe 6.0
Configuration
OS Environments Windows XP/7
Education:
. Bachelor of Science in Applied Mathematics from Sharif University of
Technology, Tehran-Iran. (Best University in Science and Engineering
in Iran)
Some Certificates:
. Develop PL/SQL Program Units
. Oracle Forms Developer
. Oracle Application performance Tuning
. Oracle iDS Designer First Class
. Oracle iDS Designer System Modeling
Job Titles History:
Planning Systems and Web Chief Feb 2006 - March 2013
Information System Developer and April 2001 - Feb 2006
Analyzer
EXPERIENCES:
SGS CO (Sazeh Gostar Saipa Co-Tehran-Iran)
04/2001 to 03/2013
Some Implemented Systems
I worked on Supply Chain Management projects. SGS is SCM Company
mainly dealing with Suppliers and Car Manufacturers.
1- VMI (Vendor Managed Inventory) System
In this project define a maximum and minimum for a part-producer in
our inventory and a vendor must balance their stock in the inventory
between minimum and maximum. We had a web based system that producers could
inform of their minimum, maximum and the inventory that system didn't
permit to deliver up to maximum. We evaluated their operation by
fluctuations inventory, then calculate their minimum and maximum by their
operation.
2- ASN (Advanced Shipment Notice) System
In this project, our producers entered their shipment information
before transportation and we could create all system controls before
transportation such as packaging, quality control, scheduling orders and so
on. After enter the ASN system created a barcode then they could print the
ASN and send their shipment to our inventory.
3- Just in Time System (Customized Kanban)
This project belongs to supplying and planning program introduced by
SGS. Main features in this application are data gathering (in data
warehouse) and decision making based on gathered data like customers
inventory, customers production plan, suppliers inventory, suppliers
production plan, transportation information and packaging information for
delivery auto parts to customers stock. This system tried to keep
customer's inventory up to a maximum number defined by customers and
prevent from lack of auto parts to produce the planned cars (as quantity
and quality).
4- Stock Inventory System
This client/server application was developed for SGS. This Product
save any received & sent parts information and control the inventory and
packaging and locating to the proper place and shelf and gave many useful
reports and indexes.
5-Track & Trace System
In automobile companies, tracking the main parts is essentials. By
this project we could trace these parts. The system was making a unique
serial number (by formula) with check digit on the part, carton and pallet
that connected together in the production line and be transferred by EDI
systems to our database.
6- Charge Line of Packaging System
This client/server application is developed for our contractor of
packaging. This system has packaging rules for export and stock inventory
that the system makes delivery order based on packaging rules and stock
inventory then create shortage list and packing list for export office.
7- Implement the Total System to the other similar Companies (As a Project
Manager)
We had a total system with Oracle DB (11g) developed by oracle form
and report 6i including about 2000 forms and reports that implemented to
other holding companies. Tool was used for transferring data between
previous software and new one was Microsoft Visual Studio 2010 (SSIS).
8- Implement the Indicators of Organizational Processes System
The processes were divided to three parts based on APQC (Strategic,
Maintenance and Operational). KPIs were defined monthly, seasonal or annual
based on type and importance of the process. To monitoring the performance
of processes and deviation from target, we gathered data from operational
systems and represented by SSRS.
Responsibilities:
. Data load packages.
. Tune and Requirement Analysis, Design, and Documentation.
. Normalization and Confirmation Data Modeling.
. Develop analyze queries in terms for performance.
. Co-ordinate with different other application group for data analysis
and gathering.
. Analyze data.
. Analyze explain plan.
. Creating tables, views, PL SQL packages, functions and stored
procedures.
. Apply performance tuning majors.
. Education and expanding the system among producers.
. Participate in enhancement meetings and analyze the new changes.
. Team leader.
Technical Environment:
. Tools: Oracle Form & Report 6i - PL SQL Developer - Oracle SQL
Developer - Oracle SQL Developer Data Modeler - Toad - Oracle
Discoverer - Oracle Designer 10g - SQL Server Management Studio, DTS,
SSIS, SSRS
. Database: Oracle 11g, SQL Server 2008 R2
Contact this candidate