Susan Patterson Email & Phone Number

Wilmington, MA, US

Wilmington, Massachusetts, United States

Wilmington, Massachusetts, United States

• Participate and provide technical leadership in all phases of development projects from discovery and planning through implementation and delivery.
• Play key roles in collaborative efforts and projects (e.g. business analyst, solution architect, software developer, QA analyst).
• Collaborate with internal and external customers and their vendors to gather requirements, identify gaps and determine design specifications or details.
• Analyze business requirements and provide end-to-end solution design including data feeds, ETL, data mart, business rules, report requirements, etc.
• Recognized as a Trillium SME on data integrity modules used for data cleansing and matching in the CDM solutions.
• Manage Loyalty Program CSR inquiries from card holders that need registrations corrected, passwords reset, missing store visits added, free up email address already in use, etc.

Wilmington, Massachusetts, United States

• HCL Client: Harte Hanks
• Collaborated with customers and their vendors on requirements gathering, gap analysis and estimation.
• Presented accurate cost estimates, resource requirements and schedules for development efforts.
• Designed and developed technical solutions for defined customers.
• Reviewed requirements and control UAT test artifacts (Test Plans, Test Scripts, Traceability Matrix, etc.) with Project Stakeholders.
• Played an integral role while participating in team meetings and collaborative efforts.

Chelmsford, Massachusetts, United States

• Supported Client Services as a technical expert in client discussions and meetings.
• Worked with customers and their vendors on requirements gathering, gap analysis and estimation.
• Provided accurate cost estimates, resource requirements and schedules for development efforts.
• Demonstrated ability to manage and introduce complex changes to existing production systems.
• Applied skills as the Trillium data cleansing and matching SME.
• Managed inbound CSR inquiries, originating from Loyalty card holders, correcting card registration errors and resolving problems such as password resets, missing visits, email already in use, etc. escalated through a.

Chelmsford, Massachusetts, United States

• Acted as the lead technical resource for client interactions, including onsite discovery, design and UAT meetings and regular conference calls.
• Coordinated physical database construction with the DBA group; managing database modifications and table loads/updates.
• Accountable for technical scope definition, detailed design, ETL process design and implementation, performance tuning and QA.
• Independently tested and debugged the next generation of the CDM product with Ab Initio ETL technology.
• Developed a comprehensive QA checklist for the Ab Initio solution.
• Trained developers on Ab Initio and standard CDM processing using Ab Initio.

Chelmsford, Massachusetts, United States

• Acted as project manager in addition to technical lead and developer on a national sports league’s marketing database build, wrote process documentation and led the transition of the project to the Account Services.
• Contributed to the overall design of new solutions and responsible for architecting, developing and testing the CDM and Trillium portions of the new solutions.
• Provided guidance and assistance to other client teams and recognized as a trusted CDM and Trillium SME.
• Worked with project managers to build Statement of Work and Project Plan.
• Lead technical discussions in multiple phases of the development life cycle: Design, Development, Testing and Transition to the production team.
• Participated with a team that tested and implemented the next generation of CDM scripts and automation.

Chelmsford, Massachusetts, United States

• Technical lead and developer on several marketing database implementations and maintenance for major US Banking and Retail clients including the team’s top Banking client who was an early adopter of
• Business Advantage, a direct marketing product aimed at business-to-business marketers.
• Developed QC procedures for process integrity and customer deliverables.
• Participated in the development of the QA plans.
• Ensured data integrity across Staging, ODS and Data Marts.
• Trained and assisted new Analysts on technical and administrative tasks.

Chelmsford, Massachusetts, United States

• Created, tested and implemented new and enhanced techniques for the Business Advantage product and related data cleansing and matching services.
• Designed, developed, implemented and maintained marketing databases for major Banking and Automotive clients.
• Responsible for all technical aspects of database maintenance and support including data processing, process automation and change management.
• Analyzed business requirements and developed technical requirements.
• Supported the sales process by assisting in the development of Proof of Concept solutions.
• Developed and maintained technical design documentation.

Chelmsford, Massachusetts, United States

• Worked with project managers to ensure that solutions met the user requirements and service level agreements.
• Implemented process improvements and strategic enhancements.
• Provided user education to clients on their custom database construction processes as well as best practices for successful updates.
• Created detailed documentation for running and maintaining client solutions.
• Independently implemented database builds.

Chelmsford, Massachusetts, United States

• Performed database builds with minimal direction, leading discovery and design stages of the project, completing the majority of development and QA tasks unaided.
• Independently designed, constructed and analyzed customer database processes according to client specifications in the financial industry using JCL and ETL tools.
• Executed client change requests in a timely manner; proactively made recommendations to the client to deliver the most effective modifications.
• Participated in client conference calls and face-to-face presentations to offer creative solutions in database construction.
• Maintained internal and external process documentation.

Wilmington, MA

Wilmington, MA

Wilmington, MA