James L. Email & Phone Number

Mahopac, Ny, Us

Remote

M365 SHAREPOINT ONLINE DEVELOPERProject Experience- DuPont - Designed, developed, trained, and maintain Safety Audit Power App using mobile camera, lists, database, and Automate to streamline old paper based auditing.- Enablon – Canada - Re-ingest datasets for transformation and delivery helping meet strict environmental standards - Developed Bronze, Silver, and Gold pipelined in ADF transforming and aggregating datasets into Azure SQL Server and Parquet files- Red Hill – Honolulu, HI - Transform water sample lab tested result sets for analysis. - Model dataset in preparation for Power BI Reports and Dashboards that are update whenever data is updated. - Developed Power BI into multiple charts and graphs used by client.- Virginia Department of Transportation - Model Power BI dataset of over 500,000 lines to relate to multiple other sources resulting in cutting half the processing needed to generate dashboards and reports- Siemens Energy - Updated entire workflow from Access to SQL Server and Access reports to Power BI Reporting for tasks from Survey to Report - Built automated series of tasks that data pull from ArcGIS to SQL Server to Power BI Reporting to replacing manually intensive tasks.- Ohio Air - Designing eComponent of new system for the state of Ohio to automate 10 year report requirement by FAA. Uses Azure SQL Server, Power BI, and Power Apps - eComponent pulls from several data sources for all airfields in the state. - Model each sites requirement for use in its reporting needs allowing for it to roll into the state-wide requirements. - Each eComponent processes as the datasets are updated.

Somers, New York, United States

• Design and maintain over 50 3rd party applications used to teach K-12 in an online, hybrid, and in-person environment.• Develop Microsoft Forms with Power Automate and BI for daily • Manage and develop SSIS/SSRS for interface and custom reports• Point person for 3rd party vendors (30+) technical and data interfaces.

Blacksburg, Va

o Design, develop, configure, and tune web applications using ER diagrams, framing, and documentation predevelopment. Used PhpStorm, GIT, CodeIgniter, CAS, jQuery, Ajax, Bootstrap 4, and many more.Sample of Projects: o Registration and check-n for annual 3.2 Run in Remembranceo Train division by department in Microsoft Teams and Office 365o Budget System for recreational sports departmento Inventory System for Corp of Cadets (uniforms and regalia) for Army, Navy, Air Force, Marines, and VPI Battalion. o Design and develop with strict adherence to security like CAS, and PII rules and regulations for the University.

Blacksburg, Va

BUSINESS ANALYST: INSTITUTIONAL REPOSITORY • Responsible/Managed IR client Wiki, Twitter, and other social/support web presents • Discovery of new partnerships like The Paperless Project • Major contributor to RFQ, RFI requests.

Charlottesville, Virginia Area

Application Development for Student Systems Project • Designed and developed interfaces from legacy system including all professional and medical school systems • Used SQR, Application Engine and other PeopleTools for version 9.1

Raleigh-Durham, North Carolina Area

Application Development for Emerging Technologies • Using PERL and JavaScript, support and develop security application used campus wide. Application used to request access permission and roles for all employees at the University. Also workflows request to accept or reject request. • Interface legacy library, bookstore, and All Campus Card data to PeopleSoft Human Capitol 8.9 for Student Administration implementation.

Greater New York City Area

TECHNICAL CONSULTANT Health and Human Services – Greater Washington DC • Oversaw Anderson Consulting regression testing for PeopleSoft Human Resources 8 implementation. City of New York – Manhattan, New York • Oversaw and helped develop the Legacy System Conversion for 25+ New York City Agency systems to PS HR8.12 Oracle platform. Use SQR, Import Manager 8, heavy Access, MS Office, and SQL Loader for data migration.

Greater Chicago Area

INFORMATION TECHNOLOGY CONSULTANT• Led APPO/GL EDI technical team in the design, development, and testing of a customized SQR application using PeopleSoft 7.5 APPO tables structures.

Master Of Business Administration - Mba, Management Science And Information Technology, 3.6

Bachelor Of Science - Bs, Psychology