Developer Sql

MASOUMEH HAJIJAMALI #** Palmer Ave, Richmond Hill, Ontario, L4C1N7

647-***-**** / ******.*****@*****.***

OBJECTIVE

To secure a challenging and responsible position as Oracle Database Developer and Analyst/

Oracle SQL and PL-SQL Developer

PROFILE

7+ years’ experience in Oracle Database Developer and Analyst, Design Database (database design, analyst and developer in Aviation systems)

7+ years’ experience in Oracle PL/SQL Developer, creating DCL, DML, DDL scripts for database object (Tables, Indexes, Roles, Store Procedures, Functions, Trigger and packages)

Hands-on experience in high-performance Oracle RDBMS, SQL, PL/SQL, Forms and Reports

Experience in translating business requirements into technical solutions and achieving established goals is required, and experience working with large scale and complex projects

Experience in design/development of reporting database/data warehouse, and data relationships, keys and indexing, fact and dimension tables, data modeling and analytics

Solid understanding of SDLC (Software Development Life Cycle), including functional and technical specification development with end users, test strategy preparation, test plan development, test case creation, test execution and bug tracking

Strong skills in effective data modeling and database design and database development

Identify the business needs/problems and propose solutions based on requirement gathering from end-users and stakeholders

Contribute to detailed design documentation (component diagrams, sequence diagrams, data flow diagram, and translate use cases, sequence diagrams, class diagrams into source code)

In-depth knowledge and experience in debugging, deploying, and maintenance of application

Strong understanding in build and maintain data ETL processes for development, test, production environment

Well-developed analytical, problem-solving and decision-making skills in order to identify problems determine possible solutions and select appropriate actions

Hands-on experience in provide advice to other informatics professionals regarding the selection application, implementation of database management tools, collection and availability of data

Knowledge of Linux Shell Scripting

TECHNICAL SKILLS

Database: Oracle 9i, 10g, 11g

Programming Software/Language: Oracle Developer (Developer Forms/Reports 10g, 11g), PL/SQL, Shell Script Design/Development Methodology: UML, OO Design method, SSADM, Power Designer

Tools: PL/SQL Developer, SQL*Plus, TOAD, T-SQL, Crystal Reports

Power Designer, Rational Rose

Operating system: Windows 7, 8, 10, Windows Server, UNIX

WORK EXPERIENCE

PL-SQL Developer/ Oracle Programmer Analyst Jan 2016 – Sep 2016

Peel District School Board (Mississauga).

Package, Function, Store Procedure and Trigger programmed in Server side and Client side

Contributed to technical System Analyst team activities( redesign, review coding and testing), and Participate in project and team meeting, interacting and collaborating with QA and Programming team members

Analyze new request of business and Design new Tables and redesign Database, Develop and Design new Forms and Reports

Participate in project and team meetings interacting and collaborating with team members and other departments as appropriate and Perform programming script modification and Maintenance application

Test and debug SQL units in conjunction with other units and/or systems and integrate with other program modules and systems

MASOUMEH JAMALI P.2

SQL Developer and Analyst Apr 2015- July 2015

Metex Corporation (Toronto).

Provided Business and Technical Document of old application and Analyze Data Process and Develop new SP

Extracted and analyzed massive amounts of data from Oracle Database to another Database

Analyzed Data and redesigned database, Extract data from database and produce complex report

Produced complex Query and Store Procedure, Functions, Triggers, Package

Analyzed data and loaded data from SQL Database to Excel (Pivot table) and produce Macro

Oracle Database Developer and Analyst 2001-Jul 2014

IRAN ASEMAN AIRLINES CO. (Iran)

Integrate transactional data from multiple sources into a Data Warehouse environment. Resolve data integration issues, research complex data mapping scenarios, and assist reporting teams in solution analysis

Worked with developers and end-users to determine project scope and prepare use cases, detailed requirements, and any other technical documentation;

Analyzed aviation’s systems including M.I.S flights system and led multifunctional team to maintain the systems

Contributed to technical team activities (designing, modeling, prototyping, coding, testing, and documentation) in full-life cycle of systems

Control and Provide support and ensure optimal performance of reports and dashboards for end users

Designed Data Modeling, creating ER-Diagrams and Data Flow Diagrams

Worked with the software developers to develop and update new systems as required

Prepared coding, debugging and documenting subprograms and reports

Provided support to the end-users in solving software problems

Oracle Developer (Forms 10g/ Reports 10g) 2001

IRAN ASEMAN AIRLINES CO. (Iran)

Developed, designed, documented and implemented several windows application

Developed custom Forms and Reports for aviation’s systems

Provided help-file within the application

Maintained the application and initial end-user training

Accomplished projects in company “IRAN ASEMAN AIRLINES”:

Team Leader (Design/Analyst and implementation) for Controlling Documents and Publications system, this system runs based on IOSA (IATA Operation Safety Audit) standards related to Documents Control

Team Leader (Analyze, Design, Implement, Test, Integration)

Controlling and Issuing Flying License Management that based on standard of Operation Manual (OM)

Team Leader (Analyze, Design, Implement, Test, Integration)

M.I.S (Management Information System) system monitors and presents the information related to all ongoing or fulfilled flights online and stores and maintains the information related to each flight

Designed, developer, implementation of a Personnel System and FIX TIME’S Flights System

Designed database model, objects, centralized database and connection between all of these systems above

EDUCATION

B.Sc. in Computer Engineering (Azad University, Iran)

PROFESSIONAL DEVELOPMENT

1)ORACLE (Oracle SQL*Plus and PL/SQL, Oracle Forms/Reports, Oracle D.B.A Part I)

2) DELF A2 (French Language Diploma)

Contact this candidate