PROFESSIONAL SUMMARY:

• 7+ years of hands - on experience in analyzing, deploying, maintaining & administering IBM Unica platform, Adobe Campaign, Interact, database marketing, Marketing Automation skills, Unix Shell scripting and ETL.
• Have extensive experience in working with business partners and develop campaigns in marketing automation tools like IBM Unica, Adobe Campaign.
• Have very good understanding of customer segmentation and audience list creation accurately and timely.
• Manage and design marketing automation and CRM integration that activate inbound and outbound activities in Unica/Exact-Target.
• Proficient in Campaign Management and Email Marketing products and IBM Unica implementation methodology.
• Expertise in Unica application upgrades & implementation of new Unica modules, environment migration, Unica database maintenance, Unica partition creation, Interact Channel creation and configuration, creating Unica user groups with privileges, defining audience key & creation, Configuring Unica application and campaign level settings, table mappings, setting Contact and Response History Tables for Additional Audiences, creating Custom Campaign/Offer Attributes, Offer Templates, Logs & Server Configuration Settings and all other Unica Platform admin/owner tasks.
• Experienced in all Support activities like troubleshooting application errors with logs, flowchart failures, complex trigger based campaign Unica scheduling and defining best practices and processes, setting automated Cron based email alerts for flowchart runs, failures, disk space monitoring, Interact channel deployments.
• Experienced in Segmentation, valuation, response modeling and cross selling to solve specific marketing problems by using the IBM Unica Suite
• Efficient in using Data manipulation, Run and Optimization processes in Unica campaign flowcharts
• Expert in requirement gathering and analysis, feasibility study, design preparation, implementation, coding, testing, mentoring and reviewing.
• Hands on experience in writing SQL queries in Teradata, Oracle and MS SQL to perform pre and post campaign analysis
• Have hands on experience in Unica campaign flowchart development and quality check.
• Experience working with multiple Email Service Providers like eDialog, YesMail and Responsys and setting up automated file transfers.
• Domain experience with various industries; Retail, Pharmaceuticals, Telecommunications.
• Strong knowledge of ETL, Control M and UNIX shell scripting.
• Comprehensive knowledge of Agile Methodology, Scrum, FDD and Waterfall Methodology.
• Good communication and interpersonal skills with ability to work in a dynamic team environment.

TECHINICAL SKILLS:

Operating System: Windows, Macintosh, Linux.

Databases: Oracle, SQL, DB2

Java Technologies: Java, J2EE, SQL, Struts, Servlets, VB.NET, ASP.NET

Marketing Platform: Marketing Tools IBM Unica

Campaign Platform: IBM Unica Interact, Unica Plan, Unica optimize, Unica Campaign, Campaign Studio. Adobe Campaign, Adobe Survey Module, Adobe MRM

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Unica Developer

Responsibilities:

• Administrating Unica Campaign and Interact including configuration setup, setting table mappings, table catalogs, custom macros and all sort of admin tasks including Unica utilities.
• Creating Unica Interact audience, Creating and maintaining Unica partitions, user groups and managing Security for users & objects, setting up and managing automated triggers, Campaign and session scheduling, persistent segments, configuring Unica application.
• Analyzed active passive availability of the environment under site failure
• Performed in-place upgrade of Unica platform and Unica Campaign upgrade from v8.2 to 8.6 successfully
• Did gap analysis of the integrations and designed more optimal solution for file transfers, database archival, data migrations, configuration of marketing data marts, response upload processes
• Designed test and development environments and migrated flowcharts from one environment to other.
• Development and deployment of complex marketing Campaigns through multiple channels.
• Support the day-to-day execution of marketing activities and campaigns across multiple channels via enterprise marketing management system / processes.
• Create and maintain campaign business rules documentation, including: Best Practices, Unica Campaign/Brand/Exclusion Templates, Process Flow, Promotion Coding Schedule Templates, etc.
• Worked on optimizing the design architecture of the campaigns and making them more efficient in order to reduce load on database.
• Performed scalability test and concurrent users test to check system performance from power user point of view.
• Did data integrity test of lists pulled through Unica by cross checking through direct SQL pulls
• Supported client in the creation and execution of campaigns & list pulls
• Supported end users by creating flowcharts and executing their own campaigns
• Managed entire campaign management environment from L2 and L3 support perspective
• Worked in co-ordination with DBA teams, ETL support teams and Unica user team and ensure smooth execution of multiple campaigns simultaneously
• Create & manage new table catalogues, templates, system tables & audience keys.
• Restarting of Unica listener, restarting of WebSphere for performance tuning
• Periodically cleaned up temp tables and killed sessions for better server performance.
• Optimized all automated campaigns for performance before going live.
• Involved in requirement gathering, requirement analysis and proof of concept submission, mapping complex requirements to Unica Campaign Management System.
• Responsible to ensure the availability, stability and sustainability of the application server and providing server maintenance round the clock.

Confidential, Auburnhills, MI

Adobe Campaign Developer

Responsibilities:

• Working closely with Business to understand the current system and new business requirements
• Working with Adobe product team to set up the base installation and configuration and Involved in setting up a cloud based hosting platform and configure as per business needs to meet the product and marketing goals
• Designing a new Survey application using adobe API’s, Data Model, Customization as per project needs and multi-channel integration touch points i.e. CR, CE and WEB to launch surveys
• Designing and implementing Real time email solution in which customer will receive email in RT manner based on various identified business scenario’s
• Designing and implementing integration with External Database to load customer profile data and other transactional data into Adobe to drive multi-channel marketing campaigns and managed them through the complete campaign lifecycle
• Customizing Adobe Product to replace current functionality provided by vendor (Unica by Epsilon)
• Worked closely with cross-functional teams to drive improvement in components of profitability, response, churn, and sale
• Designed a automated campaign approval process to avoid manual involvement and remove dependency on support and business team
• Designed and integrated adobe Web portal with adobe campaign module to provide a stream line and automated campaign execution system to business users
• Worked with 3rd Party vendor to design and integrate Customer data mart and export/import process with Adobe cloud instance\

Confidential, Boston, MA

Adobe Campaign Developer

Responsibilities:

• Participate in weekly kick off meetings to discuss segmentation criteria and upcoming campaigns with Marketing group and other vendors as required.
• Performed scalability test and concurrent users test to check system performance from power user point of view.
• Designed, test and development environments and migrated workflows from one environment to other.
• Worked on the UAT of the entire system by creating test cases and designed load optimization techniques.
• Worked in co-ordination with DBA teams, ETL support teams and Adobe Business user team and ensure smooth execution of multi-channel campaigns simultaneously.
• Document the requirements and take sign offs from the business and distribute the finalized version with the team of CRM Analysts.
• Responsible for all aspects of individual campaign set up including offer set up, audience selection, testing plans, quality assurance and campaign performance measurement activities.
• Design, develop, test, maintain and modify Unica multi-channel campaigns (email, DM, SMS) for loyalty and pharmacy customers. Build campaign, sessions and strategic segments by data selection and manipulation.
• Working proficiency with Unica Campaign, including the design and set-up of flowcharts and the ability to mentor and collaborate with other team members on design best practices within Unica Campaign.
• Create Target Cell Spreadsheets for campaign execution. Create and use flowchart templates as well as strategic segments.
• Build queries with macros and user variables and configure queries based on derived fields.
• Create dimension hierarchies by mapping base and dimension tables as well as external files.
• Schedule flowcharts for off hours processing and provide monthly rotation of production support
• Create custom Offer Attributes and assign offers. Create and distribute operational reports: Waterfall, File quantity (count) reports, cell reports and contact history audit reports.
• Present results of flow chart logic and validate counts to business partners.

Confidential, Chicago, IL

Unica Developer

Responsibilities:

• Design, develop, test, maintain and modify Unica multi-channel campaigns (email, DM, SMS) for prospects and customers to solve client and/or internal business needs.
• Create Target Cell Spreadsheets for campaign execution.
• Create custom data queries to build segmentation to map to client audience needs using strategic segments.
• Create macros, derived fields, custom attributes for campaigns, offers and cells. Create templates for creating offers.
• Create table catalogs for use in flowcharts. Setup and configure campaign system database. Create data dictionary.
• Manage user and system table mappings. Manage and view details of data sources.
• Create and manage dimension hierarchies required in business operations.
• Design, develop and execute integrated marketing campaigns involving complex business rules using Unica Campaign.
• Create and manage audience levels required in business operations.
• Create inbound and outbound triggers to execute after mail lists and after campaign flowcharts process.
• Create treatments codes and package IDs for client specific offers.
• Manage extensive campaign quality assurance processes prior to campaign execution.
• Support communications in production; monitor existing campaigns, troubleshoot campaign and technical issues, make modifications to existing campaigns and ensure campaigns are being executed correctly.
• Support clients' marketing campaigns across multiple channels including Direct Mail, Email, Outbound Telemarketing and other.
• Perform daily tasks including but not limited to Unica campaigns, data manipulations, reports, issues/investigation troubleshooting and scheduling of these tasks.
• Collaborate with account team and client to understand business requirements and specifications.
• Understand the client's business and provide technical strategy and insight into solving their business problems.
• Translate requirements to design, recommend and guide technical solutions for client based systems.
• Schedule flowcharts using IBM Unica Scheduler.

Confidential, Naperville, IL

Unica Developer

Responsibilities:

• Setup weekly kick off meetings to discuss segmentation criteria and upcoming campaigns with Marketing group and other vendors as required
• Document the requirements and take sign offs from the business and distribute the finalized version with the team of CRM Analysts
• Responsible for all aspects of individual campaign set up including offer set up, audience selection, testing plans, quality assurance and campaign performance measurement activities.
• Responsible for generating the target list pull for direct marketing campaigns (email, mail, etc.) that provide maximum ROI based on segmentation criteria received from business.
• Creating and executing SQL queries where needed to extract data from the underlying database (Teradata), and to validate counts generated in UNICA.
• Create targeted customer lists for direct mail and/or email campaigns which increase customer relevance and drive ROI
• Work cross-functionally with other teams and departments to gather insights which will improve targeting efforts and generate buy-in for targeting decisions
• Ensure targeting list pulls are timely, accurate, and effectively target the most relevant customer populations
• Ensure all campaigns are set up and executed according to appropriate specifications and rules
• Design and execute valid test and control strategies for campaigns, offers, and seasons
• Mentor other campaign staff as and when required by discussing best practices and documenting the same.

Confidential

Unica Developer

Responsibilities:

• Design, develop, test, maintain and modify Unica multi-channel campaigns (email, DM, SMS) for prospects and customers to solve client and/or internal business needs.
• Create Target Cell Spreadsheets for campaign execution.
• Create custom data queries to build segmentation to map to client audience needs using strategic segments.
• Create macros, derived fields, custom attributes for campaigns, offers and cells. Create templates for creating offers.
• Create table catalogs for use in flowcharts. Setup and configure campaign system database. Create data dictionary.
• Manage user and system table mappings. Manage and view details of data sources.
• Create and manage dimension hierarchies required in business operations.
• Design, develop and execute integrated marketing campaigns involving complex business rules using Unica Campaign.
• Create and manage audience levels required in business operations.
• Create inbound and outbound triggers to execute after mail lists and after campaign flowcharts process.
• Create treatments codes and package IDs for client specific offers.
• Manage extensive campaign quality assurance processes prior to campaign execution.
• Support communications in production; monitor existing campaigns, troubleshoot campaign and technical issues, make modifications to existing campaigns and ensure campaigns are being executed correctly.
• Support clients' marketing campaigns across multiple channels including Direct Mail, Email, Outbound Telemarketing and other.
• Perform daily tasks including but not limited to Unica campaigns, data manipulations, reports, issues/investigation troubleshooting and scheduling of these tasks.
• Collaborate with account team and client to understand business requirements and specifications.
• Understand the client's business and provide technical strategy and insight into solving their business problems.
• Translate requirements to design, recommend and guide technical solutions for client based systems.
• Schedule flowcharts using IBM Unica Scheduler.