Software Developer Data

Jermaine C. Gilmore

OBJECTIVE

As a dedicated professional, my goal is to become associated with a company where I can utilize my skills and gain further experience in databases while enhancing the company's productivity and reputation. Consistent, hard working and highly motivated. My intent is to build upon my existing database management skillset by expanding in analytics, administration and eventually big data.

EXPERIENCE

July 2015 – current General Motors, Inc., Chandler, Arizona

Customer Care & Aftersales /Software Developer

•Created stored procedures, triggers for inventory application.

•Responsible for Oracle 11g/12c database refresh of dev, test, pre-prod and production environments.

•Error handling of Postgre SQL database and ETL reporting driven jobs.

•Trouble shooting and manual push of ETL jobs by ftp through cmd line.

•Prepared SQL scripts for table creation and insertion of data. Then creating UI with JavaFX to hold data.

•Created installer specifically for newly developed application for easy installation for users using Install Anywhere software.

•Coded inline prepared statements to access database SQL queries.

•Responsible for upkeep of Cognos reports and creation of newly written ones.

•In charge of migration of Cognos reports to MS Power BI tool.

•Written bash/shell scripting code in sync with Autosys.

•Managed workflow consistency in TFS(Team Foundation Server)

•Deployment documentation and Git code reviews.

EDUCATION

September 2009 – May 2015 DeVry University, Mesa, Arizona

Bachelors of Science in Computer Information Systems with Emphasis in Database Management

•Graduated in May of 2015 with Bachelors of Science & Computer Information; with emphasis in Database Management

•Database transaction processing, including error handling, data validation, security, stored procedures and triggers, record locking, commit and rollback. Data mining.

•Administration topics, including capacity planning, database management system(DBMS) architecture, performance tuning, backup, recovery and disaster planning, archiving, reorganization and defragmentation.

•Dynamic SQL, complex queries, data warehousing, reporting capability creation, performance tuning, and data security practices.

•Basics of programming logic, as well as algorithm design and development, including constants, variables, expressions, arrays, files and control structures for sequential, iterative and decision processing. Design and documented program specifications using tools such as flowcharts, structure charts and pseudocode. Program specification validation through desk-checking and walk-throughs.

•Operating system concepts by examining various operating systems such as Windows, UNIX and Linux. This included desktop system hardware, architecture and configuration.

•Broad overview of information systems security in organizations. Topics include security concepts and mechanisms; mandatory and discretionary controls; basic cryptography and its applications; intrusion detection and prevention; information systems assurance; and anonymity and privacy. Various type of controls used in information systems. As well as security issues surrounding the computer and computer-generated data.

•System analysis and design process using information systems methodologies and techniques to analyze business activities and solve problems. Identified, defined and documented business problems, and then develop information systems models.

•Concepts and methods fundamental to database development. Data analysis and modeling. SQL functions and DBMS with emphasis on the relational model.

•Modeling and designing system requirements using UML(Unified Modeling Language). Used cases and scenarios, class diagrams and sequence diagrams.

TECHNOLOGY EXPERIENCE

Java

JavaFX

JSON/ XML

SOAP/REST

WordPress

HTML5/CSS

SQL / PL/SQL

Jenkins/ Git

Virtual Box/ VMware/KVM

Install Anywhere

Bash/ Unix Shell

Oracle Developer

Oracle DB 11g/12c

TFS - Team Foundation Server

Postgres

Cognos

MS Power BI

Visual Basic

Microsoft Office Suite

Sonar

SharePoint

BitBucket

DataStage

Angular JS

Contact this candidate