Experience

Joseph C. Sansone Company

• United States
• Real Estate
• 1 - 100 Employee

• Senior Programmer Analyst

  • May 2021 - Present

• Programmer Analyst

  • Aug 2018 - Present



BJC HealthCare

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Senior Analyst (Information Systems - Security - Identity and Access Management)

  • 2013 - 2018

  • Developed Identity and Job Role compilation engine written using NetBeans IDE in Java 7 EE running on Glassfish 4 on Windows Server 2008. Data stored on MS SQL 2008 R2 server. This allowed combination of data from multiple identity feeds to Identity Management System.• Created database for Identity and Job Role compilation engine - MS SQL databases run on MS SQL 2008 R2. Created, updated, maintained, secured these databases and contents that hold all the data for application. Included tables, foreign keys, indexes, constraints, custom scalar and aggregate functions, SQL Server Agent jobs, granular access down to field level. Some processes access data over linked servers.• Developed Role Table Website - Application written using NetBeans IDE in Java 7 running on Glassfish 3 and later Glassfish 4 running on Windows Server 2008 Apache web server. Data stored on MS SQL 2008 R2 server. Uses jQuery and AJAX, CSS. Website allows administration of job role, to application access designation.• SQL Queries against Identity and Access data – Received and handled many requests per week for ad hoc reports based on access and identity data available in support MS SQL tables. Used left, inner and outer joins, nested and sub queries, table and field aliases, temp tables, custom functions, pattern comparison, cursors, and dynamic query building. Provided timely answers to otherwise difficult question regarding access to applications.• Wrote technical documentation related to upkeep and troubleshooting of RSA, Identity Manager, Siteminder systems as well as custom written applications for which I was also the Subject Matter Expert.• Maintained CA IdentityManager, CA Siteminder and RSA SecurID systems.• Worked with RSA and CA for further support RSA, IdentityManager and Siteminder.• Maintained multiple MS SQL 2008/2012 databases, Windows Server 2008/2012 and Linux Redhat 6 servers. • Inspected network packet data to identify communication sources to servers. Show less

• Senior Analyst (Information Systems Access Management)

  • 2011 - 2013

  • Developed Access Management toolset based in Microsoft Access 2000 to assist IS Access Management staff’s ability to review user accounts quickly making use of datasets in a MS SQL database. Toolset with Microsoft Access front end used for application account analysis and updates.• Created databases associated with Access Managment toolset – MS SQL databases originally run on MS SQL 2005, now on MS SQL 2012. Created, updated, maintained, and secured these databases and contents that hold all the data for Access Team Tools 2012. Contains tables, views, stored procedures, custom scalar and aggregate functions, related SQL Server Agent jobs, granular access down to table level. Some views access data over linked server.• Developed Non-Employee Table Website – Written in Visual Studio in ASP.Net / C# running on IIS 6 on Windows Server 2003. Data stored on MS SQL 2005. Access only by members of I.S. Access Management. This site was used to record identity information of non-employee contractors prior to granting application access. Data resulted in automatic account creation via MIIS overnight.• Developed SSIS packages to automate the import of multiple datasets into a MS SQL 2008 database using SQL Server Agent, reducing time and effort needed to update data before queries.• Developed SSIS packages to automate the notification of expiring identity and application records requiring attention.• Created, modified and disabled application accounts for BJC user base of over 50 thousand employees and non-employed workers. Show less

• Senior Analyst (Information Systems Security Services)

  • 2006 - 2011

  • Developed IS Security Website – Application updated from previous version. Written using Visual Studio in ASP.Net / C# running on IIS 6 on Windows Server 2003. Data stored on MS SQL 2005. Unauthenticated portion of webpage displayed Information Systems Security statics and news.o Incident Submission –Allowed report submission of an I.S. Security breach or concern.o Incident Handling – Allowed members of I.S. Security team to work through reported incidents.o On call Schedule – Allowed members of I.S. Security team to review and modify On-Call Schedule.o Firewall Rule Submission Records – Allowed members of I.S. Security team and Network Services team to view Firewall Rule Submission Records.o Conficker Outbreak Tracking – Using data being imported from Active Directory Domain Controller security logs via automated VB script to MS SQL table, identified devices that were rapidly causing lockouts related to Conficker. Combined with IP range to location data, allowed Desktop Support personnel to quickly locate infected computers and report easily that the computer had been turned off or cleaned.o PGP Computer Alternate lookup – Using data from PostgreSQL database, provided alternate means to identify computer to PGP device identity where this data was missing on PGP website.o Active Directory Privileged Group membership changes – Imported to MS SQL table changes to memberships of AD Privileged Groups for review.• Handled weekly Checkpoint Firewall rule changes.• Provided technical assistance to application deployment of Imprivata Single sign-on and PGP Whole Disk Encryption deployments. • Worked with Imprivata and PGP vendors for further support.• Developed end user documentation related to PGP Whole Disk Encryption. To increase consumption of documentation, turned into a Microsoft PowerPoint based video explaining why it was being used and how to use it.• Provided technical assistance and direction for several major virus outbreaks. Show less

• Senior Analyst (Information Systems Access Management)

  • 2004 - 2006

  ● Performed application account provisioning tasks.● Wrote VB Script tools to improve accuracy and increase speed of account provisioning tasks.

• Desktop Support Technician

  • Feb 2000 - 2004

  ● Performed Hardware and Software upgrade and repair on desktops, laptops and printers.



PMSI Consulting

• Greater St. Louis Area

• IT Consultant (BJC HealthCare)

  • 1998 - 2000

  ● Performed Hardware and Software upgrade and repair on desktops, laptops and printers. ● Performed Hardware and Software upgrade and repair on desktops, laptops and printers.