Lee Truman
South Portland
Summary
Data Analyst and Application Manager with a commitment to operational efficiency. Successfully managed complex upgrades, fostering strong vendor relationships and resolving intricate data issues. Developed actionable dashboards and SOPs that enhanced data integrity and improved user access.
Overview
30
30
years of professional experience
Work History
Data Analyst II
Maine Medical Center
11.2021 - Current
- Managed Maintenance Connection application, supporting Facilities Management, Clinical Engineering, and MBH, ensuring effective application functionality across three key areas.
- Developed and published monthly dashboards and reports for area directors and VP of Facilities; established SOPs for Facilities Management naming conventions, hierarchy, and workflow.
- Led upgrade project for Maintenance Connection, overseeing creation of new test region to facilitate smooth transition to new version.
- Application support: resolve complex application and data issues. Repair custom stored procedures. Manage vendor relationship with Accruent.
- Application security: Review and maintain user access within the MC application, Create and configure LoginHub mapping from Active Directory to application.
- Setup and configure iPads for Maintenance Connection integration.
Sr. Programmer Analyst
LLBean Inc.
01.2006 - 10.2021
- Managed small to medium credit card projects, including Visa DEX replacement and RCS 5.0 upgrade, ensuring timely delivery and adherence to project goals.
- Managed vendor relationships with credit card companies, including TSYS, Visa, Discover, American Express, and Stored Value System, completing settlement and authorization certifications.
- Supported ACI's payment switch and IPA's, implementing RCS 5.0 upgrade, regulatory mandates, data integration, and performing fixes and patching.
- Taxing software management (Taxware (Sovos) and GeoTax). Support taxes from initial tax calculations to backend tax reporting for Mail Order, JPOS-Retail, Ecomm and Direct channels.
- Support a Java based Performance Pay application for HR and compensations. Integrated PPA data into Lawson Payroll system and vice versa.
- Supported various HR business areas such as Payroll, Finance, Compensation and Benefits (Lawson).
Data Specialist
TD Bank
10.2016 - 08.2021
- Started as Sr. Data Analyst and promoted to Data Specialist within six months.
- Moved to team lead for the Dodd Frank Regulatory Retail Data team while ingesting all retail resources into EDPP (Data Lake).
- Coordinated Dodd Frank regulatory data inventory and collaborated on processing documents for ingestion and extraction in/out of EDPP; authored instructions for IDC’s and ODC’s.
- Work with Subject Matter Experts (SME’s), ETL resources, Solution Leads and Data Stewards to process data through multiple landing zones and databases.
- Support Data Stewards with Data Quality and Source To Target Mappings (STTM’s) for regulatory reporting.
- Assisted USBO, Tableau, BOCP, and CHUB with Archer findings; collaborated with Technical Application Owners and BISO to address each finding.
- Facilitated DCJ data encryption controls; organized users for Oracle 12+ migration and coordinated with DBA’s and integration teams to ensure compliance with SHA2 data encryption standards.
Programmer Analyst
Hannaford Bros.
01.1996 - 01.2006
- Developed and supported integration applications transitioning legacy HR-Payroll software to Lawson, enhancing system interoperability.
- Supported Benefits, HR, and Payroll systems using JavaScript, Micro Focus COBOL, SQL, and Access Database applications, facilitating integration between custom and third-party systems.
- Maintained and enhanced homegrown Retail Merit pay application, ensuring seamless integration with Lawson.
Education
Associate Degree - Business Administration
Phoenix College
Phoenix, AZ05-1989
Skills
- Problem-solving
- Data analysis
- Team player
- Leadership
- Vendor management
- Export/import integrations
- Interpersonal skills
- Project management
- Application configuration
- Implementation planning
- Unix
- Linux
- Main Frame
- Windows
- Shell scripting
- FTP
- SFTP
- ETL methodologies
- Source control
- Endeavor
- Clear Case
- GitHub
- JavaScript
- Python programming
- Excel
- Access
- MS Suite
- SQL
- DB2
- Oracle
- SQL Server
- Lawson
- Taxware
- ACI Payment Switch
- Archer
- EDPP
- Hadoop
- Data Lakes
- Hadoop ecosystem
- Data collection
- UNIX system
- Process improvement
- Data warehousing
- Data management
- Data validation
- Query tools
- Gap analysis
- Data mapping
- Data integrity validation
- UNIX platform
- Workflow automation
- Business performance analysis
- Data cleaning
- Data filtering
- Reporting tools
- Analytical thinking
- Data quality assurance
- Relational databases
- Analytical problem solving
- Business needs analysis
- Data governance
- Database management
- Informatica platform
- Data modeling
- Tableau
- Process mapping
- Data science
- Tableau software
- Configuration management
- Statistics and SAS
- Requirements definition
- Microsoft Access
- MS Excel
- Structured query language (SQL)
- Database maintenance
- Product development
- Microsoft Visio
- Time management
- Collaboration
- Attention to detail
- Adaptability
- Complex problem solving
- Data integration
- Regulatory compliance
- ETL processes
- Quality assessment
- SQL querying
- Application support
Hobbies And Activities
- Golf
- Coaching softball and basketball
- Football
- Baseball
- Basketball
- Photography
- Fishing
- Hiking
- Director of Softball for South Portland Little League for nine years
Timeline
Data Analyst II
Maine Medical Center
11.2021 - Current
Data Specialist
TD Bank
10.2016 - 08.2021
Sr. Programmer Analyst
LLBean Inc.
01.2006 - 10.2021
Programmer Analyst
Hannaford Bros.
01.1996 - 01.2006
Associate Degree - Business Administration
Phoenix College