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. • Perform development of Ab Initio applications, unit and integration testing, code reviews and user acceptance. • Write complex PL/SQL queries used in Ab Initio Run SQL components for more efficient ETL, for mining data in the database to analyze accuracy, anomalies and patterns, and to extract data for reporting purposes. • Sound knowledge and experience of Oracle databases and solid understanding of database performance tuning and optimization. • Control UAT test artifacts (Test Plans, Test Scripts, Traceability Matrix, etc.) and create test data to accommodate test scenarios. • Practice self-directed learning on Alteryx solution in order to provide support for production issues and process changes. Competencies: Data Integration, Data Analysis and Cleansing (Trillium SME), Application Development, Database Design and Management, Quality Assurance and Unit Testing, Release and Deployment Planning, Technical Change and Project Management, Problem Identification and Solutions, End User and Customer Support, and Mentor Developers (onsite/offshore).

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. • Supported operational issues as per on-call schedule. • Interacted with CSRs to independently resolve problems pertaining to Loyalty system function(s) that have been escalated through a problem ticket process. • Applied skills for the debugging and maintenance of existing code. • Executed release engineer responsibilities for production deployment and post deployment validation. • Composed timely status reporting and escalation of issues/concerns. • Provided technical leadership and mentoring to the team (onsite/offshore). • Prepared and conducted knowledge transfer sessions to educate new offshore teams.

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 problem ticketing process. • Set up test environments and performed testing of new processes, patches and functionality. • Performed data integrity analysis and validation to diagnose and maintain data consistency and accuracy. • Prepared detailed status and issue escalation to management, providing root cause analysis and complete problem resolution. • Attained excellent analytical skills to solve complex, cross-functional and technical issues. • Automated, streamlined and fine-tuned the 24/7 production schedule by constructing ETL jobs in the Control-M Scheduler and setting up corresponding job calendars. • Trained offshore teams during the transition of customer solutions, deliverables and documentation.

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. • Helped client team members in the analysis and research of various process failures or issues with over/under customer relationship matching.

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 production team. • 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. • Created extensive documentation including detailed Visio process flows, system architecture design documents, and data dictionaries.

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. • Acknowledged by the department as the team expert on implementing CDM (Trillium) solutions.

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