John Douet Email & Phone Number

United States

Baton Rouge, Louisiana, United States

• Use of SSIS and MS SQL stored procedures to perform ETL and ELT, doing in hours what older processes that took days to accomplish.• Write and use custom functions in dynamic SQL to enable cross-platform operability.• Use of OPENQUERY against remote databases.• Load data from 17 different medical EMR systems into a single target application database.

Baton Rouge, Louisiana, United States

• Extensive use of SSIS and MS SQL stored procedures to perform ETL.• Parallel development of data structures for legacy and new software platforms.

Baton Rouge, Louisiana Area

• Used SSIS, built data import jobs that save upwards of 160 working hours per week.• Developed procedures to select accounts for financial securitization.• Wrote customer text paging selection jobs accounting for financial laws across nine states.• Mentored junior T-SQL developers and members of other teams.

New Orleans, La

• Integrated hospice care patient data with pharmacies and other third parties.• Utilized TIBCO Jaspersoft ETL for data integration assignments.• Wrote and maintained Postgres SQL queries, views, and functions.• Wrote and maintained reports for company’s flagship product utilizing Jaspersoft Reports.

Baton Rouge

• Architected FLIR infrared camera security analytics.• Lenel Security System administrator.• Built Microsoft SQL Server queries for ad hoc reports for various security needs.• Maintained ASP.NET applications with Visual Basic.• Built new ASP.NET applications as requested and needed.

Baton Rouge, Louisiana Area

• Infor Cloverleaf analyst for a 527-bed hospital system.• Primary integration analyst for the Finance and Revenue Cycle teams.• Developed xlates and TCL procedures for hundreds of threads.• Designed and executed testing procedures.• Documented system maintenance procedures.• Developed scripts to perform monthly maintenance routines.• Responsible for rollout of Cloverleaf sites, new Infor systems, product upgrades, system maintenance, and documentation.• Utilized SSIS to manage data for some integration jobs.• Continuing professional development included Cloverleaf level one, level two, and administration training.

Baton Rouge, La

• Phone systems, data, reporting, internal applications.

• Project manager and software developer across several disciplines and technologies, including ColdFusion, C#, and Visual Basic. • Worked in fields as diverse as cell tower maintenance tracking and LA Department of the Treasury payment processing; these efforts required rapid acquisition of comprehension of new workflows and business processes. • Managed internal support efforts while exceeding expected levels of external customer satisfaction.

• Team lead and assistant project manager for integrating medical transcription systems into hospitals; traveled to numerous hospitals to gather requirements from clinicians and administrative staff. • Project lead for financial dashboard software development group, directing the work of two developers.

Baton Rouge, La

• Hired as an entry-level Applications Analyst developing Internet-based electronic medical records system.• Worked with clinical and business staff to gather business requirements. • Ultimately promoted to Senior Systems Analyst and given the lead role on numerous web development projects for the hospital.• Directed the work of other developers on various projects.

Luling, La And St. Louis, Mo

Hired through the LSU Cooperative Education Program, working every Spring-Summer semester for three rotations. PC troubleshooting, network troubleshooting, responsible for off-site backup storage, and managed plant-wide roll out of then-new Windows for Workgroups (400 workstations).

Computer Science, Sociology, Computing

Education record

Activities and Societies: Valedictorian, Student Council Vice President, Key Club, Fencing Team