Resume

Sign in

Data Analyst Developer

Location:
Minneapolis, MN
Posted:
December 25, 2020

Contact this candidate

Resume:

NDEH KHAN

**** ***** *** *. ****** Lake MN

adiye0@r.postjobfree.com 641-***-****

PROFESSIONAL SUMMARY

Professional Database Developer and Data Analyst, with advance knowledge and experience in Oracle SQL, PL/SQL development and Database Administration. Moreover, a seasoned object-oriented and business-oriented programmer, with a proven track record in system planning, analysis, design, development, deployment and maintenance. Enthusiastic professional with excellent critical thinking, project management, problem solving and communication skills.

TECHNICAL SKILLS

Databases: Oracle 11g, 12c & 19c, Oracle 12 RAC, Microsoft Access, MS SQL Server.

Languages: PL/SQL, SQL, Shell Scripting, Java, Python, COBOL, HTML, CSS, C#

Software: Git, GitHub, PowerShell, MS Word, Access, Excel, Outlook, Visio, Jira, Apex.

Operating Systems: Linux, UNIX, Microsoft Windows

WORK EXPERIENCE

PL/SQL Developer

Meridian Services July 2016 – Present

•Developed and provided support to all system interfaces and coordinated with all project managers to provide specifications for all core modules.

•Coordinated with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.

•Analyzed and ensured efficient transition of all technical design documents and developed various PL/SQL packages, Procedures and functions to provide support to all application developers.

•Monitored, developed and recommended changes if required to all PL/ SQL packages and provided stored procedures and design and develop various relational database.

•Evaluated all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.

•Developed ER diagrams, schemas, logical to physical database mapping and data table parameters

•Designed and implemented data definition language (DDL) and data manipulation language (DML) using SQL within PL/SQL stored program units (Procedures, Functions, Packages, Triggers).

•Expertise in Data Extraction, Transforming and Loading(ETL) using BULK Insert

Database Developer /DBA Dec 2012 – Nov 2014

Ministry of Transportation, Cameroon

•Tuned SQL queries, PL/SQL procedures to improve the system performance.

•Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.

•Led PL/SQL development, and coordinated the automation and deployment of all Oracle migrations for the Online Customer Service site.

•Involved in debugging for root cause and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

•Used Cursors both implicit and explicit to capture many rows within a PL/SQL block and applied business rules on them.

•Create and enhance PL/SQL stored procedures, functions, trigger, indexes, views, materialized views, etc.

•Developed complex SQL and PL/SQL queries required to retrieve data from data repository using cursors, joins and sub-queries.

ACADEMIC PROJECTS

•Java and SQL Application Development: MCTC Minnesota Spring 2018

• Worked in a team to build an online shopping center.

• Used ERD diagrams and UML to design both schema and Java classes, respectively.

• Codes with Java to implement classes and methods.

• Developed a graphical user interface (GUI) for easy use of program.

• Made use of method overloading, overriding, invocations, inheritance and polymorphism.

• Build schema objects (tables) using SQL and connected database to Java using JDBC (Java Database Connectivity)

• Overall System development based on SDLC methodology (Planning, Analysis, Design, testing/implementation, maintenance)

Java Application Development: MCTC – Minnesota Spring 2018

• Used Eclipse to develop physics formulae calculator, to make physics calculations easy for students in the survey of physics course.

• Developed a graphical user interface (GUI) for easy use of program.

• Made use of inheritance, polymorphism, method overloading, overriding and invocations.

• Project was successful with the use of the SDLC methodology (Planning, Analysis, Design, testing/implementation, maintenance).

Oracle SQL, PL/SQL: MCTC -Minnesota Fall 2017

• Worked with SQL developer to build tables for Student Information System and established database relationship among the entities.

• Performed Queries, DDL (Create, Alter, drop tables), DML (Insert, Update, Delete rows), transaction control statements (example: Commit and Rollback) and DCL (Grant and Revoke).

• Used PL/SQL codes to create triggers, packages, procedures, functions.

• System implemented based on SDLC methodology (Planning, Analysis, Design, testing/implementation, maintenance)

EDUCATION

Associate of Science, Software Development

Database Administrator Certificate Dec 2019

Minneapolis Community and Technical College

Database Developer Certificate

Bamenda University of Science and Technology Apr 2011



Contact this candidate