Project Management Sql Server
Resume:
Jayne Hills
SUMMARY
** *****’ SQL/PL Oracle, 10 years MySQL, 4 years Postgres, 15 years SQL Server
** *****’ integration, data migration, etl & data transformation
** *****’ experience data mining, data architect, statistical analysis
17+ years’ experience in full life cycle/full stack development
9 years ERP Analyst/Development Sage 100 MAS 90, Lawson & Syteline
8 years EDI experience using various formats
6 years DBA MySQL, SQL Server & Posgres
6 years network administration for Unix, HP, Solaris Sun, RedHat, Debian & NT
Snowflake Data Warehouse & SQL Development with Snowflake
Development with Big Data Hadoop & Hive
Experience in Project Management, Documenting Requirements, ER & Testing Requirements
Database experience in architecting a variety of database schema’s & indices for efficiencies
Software Analyst, Data Integration, Migration, Data Analyst & Project Management
BI Development with Tableau, Tableau (Prep) Lawson BI, SSIS, Power BI, Dataiku, MicroStrategy & Pentaho
Reporting Development in Google Suite development, SSRS and Crystal Reports
Expertise developing integration applications with general ledger, accounts payable, accounts receivable, fixed assets, tax, HR employee benefits, payroll, logistics, planning, legal, real estate, inventory, supply chain, job cost, performance, and special ledger for both manufacturing and service-oriented business
Developmental languages (C/C++/C#, VB, VBA (Project/Excel), .NET Framework, Perl, Java Oracle PL/SQL, PHP, Python, R, PL/SQL, Unix Scripting, Java Script, HTML, CSS)
Strong knowledge of Microsoft Office products including Outlook, Word, Excel, Project, Access, PowerPoint, SharePoint and Visio
Established proficiency writing accurate and effective documentation such as project and task planning, development, and testing
Natural ability to promote products through creativity with the stakeholders and build rapport by designing effective tools through excellent listening, verbal and written communication skills
Creative, resourceful, and flexible, able to adapt to changing priorities and maintain a positive attitude and strong work ethic
Q Security Clearance for Department of Energy
Six Sigma Green Belt
WORK HISTORY
Honeywell KCNSC 04/2024 – Current
A73 Data Analytics Platforms - Data Engineer
Tableau, Dataiku & MicroStrategy
SSIS. NIFI
SQL Server & Oracle Developer
Share Point, Confluence, JIRA Admin
Special projects: Collibra, IT Vulnerabilities
Advantage Tech Consulting (Capital Federal) 07/2023 – 04/2024
Data Engineer
TSQL. VBA (Excel & Project) & C# Programming using .Net Framework
Power BI, SSMS & SSIS
ETL, data modeling, data migration, data audits, data mining & statistical analytics
SQL Server & Oracle Developer
Project Management & agile development
Develop Ghant Charts, Work Flow, Best Practices, SSIS Training
Review Task Plans, Software Requirements, Test Plans
Visio for Database & Wireframe Development
Development in Visual Basics and C#, TSQL
SSIS Training
Triple Crown Consulting (L3 Harris/Department of Defense) 04/2021 – 07/2023
Sr SQL Developer Consultant
TSQL. VBA (Excel & Project) & C# Programming using .Net Framework
Power BI, SSMS & SSIS
Tableau & Tableau Prep for extracts and dashboards
ETL, data modeling, data migration, data audits, data mining & statistical analytics
SQL Server, Oracle Developer & Snowflake Datawarehouse
Jira ticketing system & agile development
Develop/Review Task Plans, Software Requirements, Test Plans
Confluence - Code Reviews
Visio for Database & Wireframe Development
Orizon 11/2019 – 4/2021
Software Engineer
TSQL Development, SSMS, SSIS & SSRS
Data mining, ETL, data transformation, data audits, billing & statistical analytics
ERP Development Syteline
Development in Visual Basic, C#
Apex Consulting 12/2018 – 11/2019
Consultant Data Engineer
TSQL Development, SSMS & SSIS
Data mining, ETL, data transformation, data audits, billing & statistical analytics
LAMPP (Linux, Apache, MySQL, PHP, Perl)
Development in Visual Basic, C#
Tableau, SharePoint & Power shell Development
Market Share Marketing 01/2018 - 11/2018
SQL Development Consultant
TSQL Development, SSMS, SSIS, Power BI & Report Builder
ETL, data transformation, data audits & analytics
Salesforce (PAAS)
LAMPP (Linux, Apache, PHP, MySQL, Perl, Python)
Development in Visual Basic & C#
SQL Server Azure & SourceGear
Verizon Wireless 01/2015 – 12/2017
Engineer III Planning Specialist
Project Management of New tool development for developers on our team
Responsible for designing, creating, deploying & managing the territories data architecture
Provide or enable full stack development of (mobile ready) applications, audits, interfaces & reports for performance teams that analyses raw data to show performance related trends
My SQL & Oracle Database Administration development (sql programming) & database design
Linux & Apache System Administration
Tableau API Development
Google Scripts Development (GWS)
SharePoint Development
Pentaho, BI Development
LAMPP (Linux, Apache, MySQL, PHP, Perl, Python)
Development in Visual Basic, Java, C# & C
Java Script, AJAX, JQuery, Bootstrap, HTML, XHTML, CSS
CBIZ 12/2013 – 12/2014
Consultant Meyers & Stauffer
Responsible for developing applications, modules, interfaces & reports for applications
Scripts including imports, exports, & data conversions
Develop application services to interact with customer systems
Create & debug SQL Server stored procedures, functions, and views
MS SQL Server 8 Database Administration
Software Development: Visual FoxPro, C#, Perl, PowerScript, SSRS & SourceGear Vault V10
Databases: MS SQL Server V8.0 & V12.0
Sisters of Charity Health System 06/2007 – 12/2013
ERP Application Developer
Application developer for HRIS, Finance, Procurement, Legal, Security, IT & Supply Chain
Developed various audits, report, interfaces including EDI, SQL PL – Oracle, C, Perl, Unix Scripting for many hospitals and clinics including alarming, business process automation, security administration and system migration/integration.
ERP development Lawson Process Flows, BI Reporting and Dash Boards
ERP Systems Administrator for Development Systems
Project Management for contract developers, plan assessment, risk analysis, Gantt, Perts Charts.
Serve as a mentor to Business Analysts for SSRS, Crystal Reports and advanced SQL
Managed projects delegated to consultants and oversaw project scheduling for cross functional teams, defined tools and processes best suited for each project, worked with clients on requirements and wrote documentation for Development/Testing/QA/Rollout/Support.
Software development: In Perl, C, PHP, Java Script, Java, CSS, SSRS, ProcessFlow, LBI, Kronos, Taleo, Crystal Reports, HTML & KSH - Unix Scripting
Databases: Oracle 11g R1, MySQL, MS SQL Server V8.0
HP Unix 11.23, Linux
U.S. Bank 08/2006 – 06/2007
Software Engineer
Develop & maintain financial applications for multiple charge card lines.
Maintain applications that process the data received from batches of credit card transactions.
Develop embedded SQL Statements in Pro*C/C++
Software development: In ProC, Perl, XML, XHTML & KSH
Databases: Oracle 8i & 9i
Subversion VCS
Sprint Nextel 12/2001 – 08/2006
NTAC Integration Engineer II
Developed applications and provided troubleshooting to systems and software for the National Sprint Nextel network.
Developed an automated reporting tool that evaluated servers (software, maintenance and updates) saving 762 man hours resulting in an annual savings of $41,184.00
Developed an application that automatically evaluated all switching platforms nationwide (100+) prior to upgrades for required parameters, saving 487 man hours, resulting in a $26,000.00 savings per upgrade
Assisted in the upgrading and maintaining a program for Customer Service that analyzed subscriber data eliminating the need to inquire on multiple platforms. This application saved access time by 50%, saving the company 1516 man hours with an estimated annual savings of $81,864.00
Software development full stack: In C, Perl, KSH, C#, VB & TCL/Expect.
Databases: Oracle 8i, 9i, 10g, 11g, No SQL, My SQL, SQL Server & Postgres (Pro C, PL/SQL)
Web based development: PHP, Perl CGI, C GCI, HTML, XML, CSS & Java Script
Unix HP, Solaris Sun and Linux Administration on LANs and WANs
Apache Web Server Administration
MySQL and Postgres Database Administration
Self Employed or Contractor while attending College Full Time 1997 – 2001
Independent Consultant
Independent consultant for various clients while attending college full time
Clients included: TRAMCO Inc., Boeing of Wichita, Galachia Medical Clinic, Diamond J Aircraft Instrumentation Manufacturers, Excel Food Products, LSI Logic, BCBS
Provided software, hardware, network (Novell & Sql Server), database & programming services
Duties included programming, migrations, upgrades, data modeling and system analysis
SQL Plus and SQL PL on Oracle Database, MS Access, My SQL
Pro C compiler, P+ Software Engineering Methodology
Programmed in Unix Scripting, C, PHP, VBA, DAX, C++ and Assembly Language (MASM)
Developed test program for RAID Administration Systems using Silk Test/Java
Graphic Design using Adobe Photo Shop, Auto Cad for brochures and web pages
Designed web pages utilizing HTML, Hot Dog Professional, Frontpage, Perl, Dreamweaver, Coldfusion
TRAMCO, Inc. 1994 – 1997
ERP, LAN and Office Administrator
ERP integration, administration, and development on MAS 90 (aka Sage 100 ERP)
LAN Administrator utilizing Novell Netware & Windows NT; all hardware and software support; addressed and controlled security issues and maintained intranet utilizing Lotus Notes for a company of approximately 150 employees.
WebSite Developer & Editor customer sales journal, technical documentation & brochures for a customer base of approximately 5,000.
Responsible for all computer-based training & technical documentation for employees.
Prepared budgets, financials, and account reconciliation; approved all payments and fund transfers.
HRIS, Mentored & Supervised Accounting Clerk Work for AP, AR, HR and Payroll
EDUCATION
Bachelor of Science - Computer Science from Wichita State University, Wichita, KS
Minored in Math & Statics
Contact this candidate