Sabattus, Maine, United States
I turn messy, opaque legacy data into trustworthy, production-ready records that organizations can actually run on. Over the last 15+ years, I've worked the part of enterprise modernization that quietly derails most programs: translating decades of inherited business meaning, undocumented codes, and tangled history tables into clean targets — without missing the go-live date. That's where I do my best work. A few moments I'm proud of: ► Migrated over one million employee activity history records inside a 9-month window, leaving fewer than 10,000 records requiring manual correction at cutover. ► Cut a critical enterprise drug catalog batch run from 24+ hours to under one hour at Cigna Pharmacy, reclaiming an entire operational shift. ► Halved Oracle SQL runtime inside Merck's JAR-based enterprise framework through targeted query tuning and data mapping redesign. ► Reduced production recovery from a full workday to under 4 hours at Webster Bank by automating ETL recovery in PowerShell and SQL. My toolkit: Oracle (incl. 19c), SQL Server, PL/SQL, T-SQL, Informatica PowerCenter, Pentaho Data Integration, PowerShell, Korn Shell, Linux, AIX, Windows. I've delivered across pharmaceutical, banking, retail, and government sectors — most recently for CGI on engagements with Massachusetts BEST Advantage, the Massachusetts Department of Unemployment Assistance, CalSTRS, Merck, and Cigna. What I'm best suited for: ✓ Enterprise data conversion and migration programs where accuracy and timing both matter ✓ Performance tuning on Oracle and SQL Server workloads that have outgrown their original design ✓ ETL architecture and redesign in Informatica or Pentaho environments ✓ Production-critical troubleshooting where the data has to be right before sunrise Based in the Lewiston, Maine area and open to remote, hybrid, and onsite consulting engagements across the U.S. 📩 Reach me at [email protected]
Supporting enterprise data modernization and migration initiatives. Key contributions: • Designed and troubleshot Pentaho ETL mappings for large-scale data conversion projects. • Validated SQL correction scripts for production environments. • Resolved SQL Server migration issues. • Developed Oracle SQL enhancements and performance tuning solutions improving processing time by ~50%.
Planned and supervised installation, configuration, connectors and patching of database objects and application objects for Actimize RCM, UDM, WLF, CDD and SAM modules, using SQL Server, RCM Designer, and AIS Visual Modeler Successfully completed go-live activities for Actimize WLF, CDD and SAM modules. WLF, CDD, SAM Designed software controls of Actimize process flows and ETL jobs, via Power Shell, Python and T-SQL scripting, significantly reducing failures as well as time for recoveries and reruns, from a full work day to less than 4 hours. Managed SQL Server user permissions and privileges Managed SQL Server database links. Identified database tuning and processing flow improvements resulting in reduced run times and rerun recovery times by up to 90%, from 3 days to less than 6 hours. Troubleshoot ETL via Informatica Troubleshoot UDM, WLF, CDD, SAM errors via AIS Visual Modeler
Investigated and collected business and technical system requirements for retailers, and designed system interface flows, batch scripting, and enhanced transactions processing, significantly increasing throughput, using tools such as Korn Shell, PL/SQL, PRO*C and Oracle database administration. Modeled and mapped data entities and components between systems for accurate data conversion and migration during system interfaces (ETL), and for initializing new systems. Resolved database performance issues that reduced run-times from hours to minutes, using SQL analysis and Oracle Explain Plans. Principal clients engaged : Rogers Communications, Canada ♦ American Eagle Outfitters, PA ♦ Burlington Coat Factory, NJ ♦ Gordmans, IA