SUMMARY

• Around 7 years of experience working on digital marketing and campaign management.
• Expertise in Unica Campaign module, Teradata Aprimo (CIM), campaign flowcharts.
• Hands on experience in IBM Unica, Teradata Aprimo (CIM), Teradata SQL and SAS.
• Strong knowledge of functional aspects of Unica campaign and advanced concepts like custom macros.
• Good experience with big data sets and manipulating them to drive meaningful insights.
• Worked on loyalty program campaigns and post campaign analysis.
• Maintained triggers in UNIX environment and used them to automate campaigns.
• Experience in working with multiple stakeholders for successful campaign planning and execution.
• Worked on post campaign analysis to generate campaign effectiveness reports.
• Goal oriented attitude and excellent interpersonal and communication skills within cross functional teams and vendors.

TECHNICAL SKILLS

OS: Unix, Windows.

Marketing Automation: IBM Unica campaign, Teradata Aprimo (CIM)

Programming: PL/SQL, Unix shell.

Database: Oracle, Teradata, SQL Server.

Web analytics/Reporting tools: Microstrategy, Coremetrics

Also: Putty, BRIO, Cognos, SAS

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Campaign Analyst

Responsibilities:

• Construct campaigns using a combination of Unica campaign, Teradata Aprimo (CIM), SQL based on inputs from the campaign owners.
• Evaluate the existing triggered campaigns and optimize them for better performance.
• Have worked on website traffic analysis and drive special promotional campaigns for them.
• Have designed a cart abandonment campaign in collaboration with business team, web - analytics team and Unica/Aprimo technical team.
• Helped the digital campaigns of reward point redemption reminders.
• Help set up the on-boarding campaign for new customers of the loyalty program.
• Created many campaigns on ad hoc requests of the business team to cater to seasonal and festival based promotions
• Worked with email vendor to pass list everyday timely and properly and bring back responses from there.
• Did a lot of value add by designing complicated flowcharts with derived fields and custom macros.
• Worked extensively on campaign quality checks and created quality control processes for the Unica/Aprimo user’s team.
• Build test campaigns in the test environments and move them to production for deployment.
• Review the current QA process, suggest and document improvements.

Tools: & Technologies: IBM Unica Campaign, Teradata Aprimo (CIM), Oracle, Teradata, Teradata SQL assistant, UNIX, Cognos, Coremetrics, Tableau

Confidential, Garden City NY

Campaign Analyst, Direct Marketing Team

Responsibilities:

• Design campaigns in Unica as per the business requirement
• Build and maintain recurring campaigns.
• Performed the role of Unica business analyst by interfacing with the business users to document campaign requirements.
• Documented the QA steps that need to be implemented in order to make sure the campaign execution is accurate.
• Made on the fly changes to the process to mitigate quality and timeline issues.
• De-briefed higher management on a regular basis the on progress of the campaign development.
• Simplify campaign designs for improved performance in Unica.
• Automate regular campaigns for lesser human intervention and fewer manual errors.
• Refine/simplify SQL queries for improved speed/better performance.
• Perform output validation process to deliver error free campaigns.
• Suggest alternative, simpler designs for campaigns in order to reduce execution times.
• Helped the Campaign migration team in moving data from one database to another database.
• Part of the team that helped evaluate and build a business case of e-message module implementation.

Tools: & Technologies: IBM Unica Campaign, Unica eMessage, Teradata SQL Assistant, UNIX, MS Office.

Confidential

Business Analyst

Responsibilities:

• Primarily Involved in interacting with Morningstar and Business users for gathering requirements
• Wrote Use Case Specifications according to the business requirements
• Vendor software compliance, database integrity and performance evaluation.
• Successful implementation of online transaction processing applications and its associated modules like database testing and validation.
• Regularly scheduled meetings to review the project status/plan with senior technology staff
• Created a SOE reports on a weekly basis about the types and status of tasks pertaining to the data migration for the various mocks.
• Preparation of Data Mapping Documents, SRS and Security control document
• Prepared Business process flow diagrams
• Worked closely with the QA team during the automated testing using the HP Quality Centre
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion
• Created UAT scripts and facilitated User Acceptance testing (UAT) for the application as a Business User

Tools: & Technologies: Mainframe, MS Office, MS Visio, MS Access, UML, Waterfall, C++, Microsoft SQL Server 2005

Confidential

Business Analyst

Responsibilities:

• Proactively involved in defining the scope, business rules and gathering requirements for the project.
• Interviewed stake holders, users and SME’s to discover and document business processes.
• Organized and facilitated JAD sessions as required with fellow Analysts, decision makers, users, key member(s) from the development team.
• Conducted analysis of business issues and challenges and provided solution prioritization.
• Informed project managers and clients about the progress of the project through PowerPoint presentation.
• Analyzed business process requirements, defined functional and non-functional software requirements to be captured in Rational RequisitePro.
• Performed Use Case Analysis, Identified Actors and developed Use Case Models.
• Actively monitored project progress utilizing MS Project and updated change in plans as required. Created Traceability Matrix attributes for the requirements.
• Worked in close coordination with QA and Assisted the testing team in User Acceptance Testing (UAT), business validation and user sign-off.
• Developed Test Plans and Test Cases to be used in testing.

Tools: & Technologies: SQL Server, MS Office, Rational Rose, MS Visio, MS excel, MS PowerPoint, Rational XDE