Friedrich Rahm
Etobicoke,ON
Summary
- Experienced business and systems analyst with 20 years of IT experience with emphasis in database marketing. Demonstrated strengths include process analysis, technical troubleshooting, project leadership and communication skills
- Senior Consultant with a history of success driving marketing automation liaising between IT and marketing, defining requirements and appropriate testing, SQL and end-user tools from SAS, Cognos, Excel, Amazon Web Services.
- Extensive Experience developing UNICA flowcharts for email campaign deployments and developing UNICA campaign processes to automate list generation, response tracking and lead scoring for complex, multi-wave, triggered B2B campaigns.
- PMP with Experience with Agile/Scrum methodologies and JIRA. Success in driving the full lifecycle of software development from technical ideation, design, testing, and delivery.
- Experience in designing both client-facing solutions and internal enterprise applications. Adept at integrating multiple data sources into custom CRM or reporting solutions.
- Articulate Communicator with the ability to convey technical feedback in user-friendly terms.
Overview
22
22
years of professional experience
Work History
Marketing Systems Analyst
EPSILON
Toronto, ON
06.2016 - Current
- Co-ordinate with internal teams, international developers and external service providers to develop IBM Campaign flowcharts to replace existing processes using Agile methodology; develop Business Requirements documentation, UAT test cases, Source to Target documentation and training documentation
- Led team of 4 analysts to enhance ROI and improve standardization on UNICA campaigns for client Norwegian Cruise Lines
- Document requirements and manage implementation of custom UNIX scripts for campaign post process automation and file delivery
- Use overlays and model scoring tables for predictive acquisition campaigns
- Track SLA for ticket resolution in Operations service team
- Migrate data from Azure DevOps to JIRA
IBM EMM Consultant
TELUS
Toronto, ON
04.2015 - 06.2016
- Managed client relationships during migration to IBM Campaign through regular check-ins and updates on project progress.
- Collaborated with cross-functional teams to successfully deliver campaign history and response tracking
- Created detailed work plans to migrate 30 existing SAS and Oracle scripts to IBM Campaign flowcharts
- Ran A/B (split testing) campaigns
Marketing Campaign Manager
Allstream
Toronto, ON
05.2012 - 03.2015
- Developed UNICA flowcharts for email campaign deployment, response tracking, lead scoring and strategic segmentation
- Developed guidelines for CASL implementation for campaigns and led team of four for implementation.
- Performed ad-hoc analyses on marketing database and UNICA system tables for Demand Generation modelling using SQL, Excel
- Developed ten test cases for business logic redesign and perform UAT testing
- Created campaign templates to refine and automate existing campaign processes, standardize reporting structures
- Developed centralized CRM data repository, migrating from Microsoft CRM
- Increased efficiency between sales and marketing departments via data cleansing and standardization of data within CRM.
- Reduced time to generate campaigns by 50 percent.
CRM Technology Manager
PROXIMITY
Toronto, ON
11.2011 - 03.2012
- Managed project to automate on-going CRM processes for client, reducing internal costs associated with manual development, increasing accuracy and reducing required QA by 25 percent.
- Wrote Business Requirements, Statements of Work detailing work for client projects; allocated budget, resources and tracked costs.
CRM Manager/Data Analyst
DRAFTFCB HEALTHCARE
Toronto, ON
10.2010 - 10.2011
- Developed new approach to campaign design for UNICA applications, saving redundant documentation and simplifying application development for programming staff.
- Identified long standing problem in customer segmentation, increasing campaign ROI by 15 percent.
- Developed plan to correct segmentation and modified project documentation to prevent recurrence.
Database Program Manager
Transcontinenal, Thindata 1
Toronto, ON
04.2002 - 10.2010
- Managed 12 application development projects under strict timelines in coordination with client Project Managers and Programmers.
- Developed implementation schedules and assigned tasks, tracked implementation progress and resolved personality conflicts to ensure successful project completion.
- Migrated 11 client databases into custom designed marketing data marts for reporting and analysis
- Created B2B and B2C database warehouses for clients, integrating multiple data sources
- Developed 25 ETL process to load data from various clients into custom databases
- Applied data modeling for advanced segmentation and profiling customer databases
- Tools included SQL Server (SSIS, SSRS, SSAS), Oracle, (SAP) Business Objects, Crystal Reports, and SAS and SPSS
- Worked with senior analysts to assist in advanced modeling projects
- Led and mentored staff of over four Programmers and Analysts including contract employees while assisting with IS departments budgeting
- Evaluated job performance, assisted with implementation of training guidelines.
Education
Bachelor of Science -
University of Guelph
Guelph, ONPMP – Project Management Professional -
PMI
08.2011
Skills
- Core Competencies - Technical
- Business systems analysis, Database Marketing, marketing automation, Data Warehousing, Data Integration
- ETL Design, SQL and Database expertise, CRM, quality assurance methodology, lead generation
- Technical skills
- Software
- Azure Desktop, JIRA, Confluence, SQL Server, Oracle, TOAD, Interbase, Navision, Aprimo, UNICA, Visual Studio, SSIS, SSRS, Integration Services, DTS services, Analysis services, VBNet, VB 6, VBA, Windows scripts, Delphi, IBM Campaign, UNICA, Cognos, Business Objects, Crystal Reports, Crystal Reports Enterprise, Report Smith, IIS, Apache, Tomcat, Exchange, GroupWise, VMWare, SharePoint, MS Project, Amazon Web Services and Redshift
- Networks
- TCP/IP, Netbui, IPX/SPX, Arcnet
- Methodologies
- Rational Unified Process, Extreme programming, Agile, SLDC, Six Sigma
Timeline
Marketing Systems Analyst
EPSILON
06.2016 - Current
IBM EMM Consultant
TELUS
04.2015 - 06.2016
Marketing Campaign Manager
Allstream
05.2012 - 03.2015
CRM Technology Manager
PROXIMITY
11.2011 - 03.2012
CRM Manager/Data Analyst
DRAFTFCB HEALTHCARE
10.2010 - 10.2011
Database Program Manager
Transcontinenal, Thindata 1
04.2002 - 10.2010
Bachelor of Science -
University of Guelph
PMP – Project Management Professional -
PMI
Similar Profiles
Walter Padgitt Jr.Walter Padgitt Jr.
Mechanic at EpsilonMechanic at Epsilon
MINJUNG MICHELLE KIMMINJUNG MICHELLE KIM
Lead Art Director at EpsilonLead Art Director at Epsilon
CHANDRAMOHAN B VCHANDRAMOHAN B V
Manager, Delivery Excellence at EpsilonManager, Delivery Excellence at Epsilon