Data Analyst Software Engineer

NDEH KHAN

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

https://github.com/ndeh1234, linkedin.com/in/ndeh-khan-5a853189, ********@*****.*** 641-***-****

PROFESSIONAL SUMMARY

Professional Database Developer and Data Analyst, with advanced 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: Apex, Git, GitHub, PowerShell, MS Word, MS SharePoint, Access, REST Services, Excel, Outlook, Informatica, Visio, Jira., Tableau

Operating Systems: Linux, UNIX, Microsoft Windows

WORK EXPERIENCE

Software Engineer/ March 2022 - Sept 2024

Oracle PL/SQL

Implementation partner: Apex Systems

Client: Hilton Grand Vacations/Diamond Holiday Resorts

Participates in Oracle based development projects, including conformance with best practices in Software development life cycle (SDLC); coordinates with business analysts; business subject matter experts and quality assurance staff.

Fixes and develops changes to applications to meet functional and technical designs following best practices and development standards and guidelines.

Supports production systems; analyzes and resolves production problems in a timely manner; resolves end user service requests as assigned.

Escalated user stories from SNOW to ADO

Responds promptly to customer needs; takes a customer-centric approach to problem solving; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments; manages customer expectations

Lead Technology/ March 2021- March 2022

PL/SQL

Implementation Partner: Infosys

Client: CBRE/

Analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.

Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational databases.

Involved in Support and worked on enhancements for the Application.

Analyze application problems, recommend, and develop solutions.

Provide support during various phases of testing as well as production support

Involved in analyzing Schema's, Tables, and Indexes as part of Optimization.

Involved in writing SQL Queries, PL/SQL programs to meet client requirements.

Involved in the maintenance of Database Integrity.

Coordinating with clients and helping them in resolving critical issues to meet SLA

PL/SQL Developer

Meridian Services July 2016 – Mar 2021

•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 analysts to prepare designs for new applications and document 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 databases.

•Evaluated all architecture for Oracle applications and prepared 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

•Migrating data from MS Access database into Oracle Database using SQL Loader and transforming the data before loading into target tables.

Regional chief of bureau at the delegation

Of transport, Bamenda-Cameroon Sept 2003 – Dec 2012

Oracle Database Developer Dec 2012 – Feb 2015

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.

•Migrating large volume of data from MS Access Database into Oracle Database using SQL Loader.

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)

• Designed and developed an app for restaurant online ordering using C# and SQL

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

Bachelor’s degree, Environmental Management Dec 2001

University of Dschang, Cameroon

Contact this candidate