SUMMARY

• Highly Organized & detail - oriented Data Analyst/Project Lead with advanced knowledge of IBM Unica Campaign Management & Expertise in Statistical data analysis using DB2 SQL.
• In depth designing skills in IBM Unica Campaign Management.
• Expertise in DB2 SQL.
• Proficiency in Unix Shell Scripting.
• Beginner in Base SAS Programming.
• Strive to create value adds & Adaptable to new technologies.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Development & Testing of Campaigns using DB2 SQL.
• Designing of Flowcharts in IBM Unica to automate Campaign executions which are recurring in nature.
• Development of Shell scripts in Unix to schedule Unica Campaign Executions in the background at definite time intervals.
• Development of Shell scripts in Unix to fetch input file from the remote server and post the output file of campaign to remote server.
• Developed Macros in IBM Unica for Selection/Suppression criterias which were consistently part of Campaign developments.
• Played a key role in Unica Migration Project wherein Unica Campaign application was migrating from V7.2 to V8.6
• Played a key role in Creation of Line of Business Datamart which handled Campaign Development & Execution Efficiently.
• Leading Adhoc & Unica Automated Campaign Execution and Reporting team of 6 at offshore.
• Trained new joiners on the Campaign management & IBM Unica Campaign Platform.
• Took part in Business Development Activities such as presenting Confidential ’s expertise on Campaign Management on account level.
• Participated in Technical Audits representing Project and solving the Audit findings through RISK Portal by creating & managing Risk Action items.
• Present monthly metrics to the Client directors/IT team regarding the health of the projects over Project Management Review(PMR) call

Confidential

Data Analyst/Project Lead

Responsibilities:

• Designed dynamic date catchup table logics, Look up tables, SQL file execution partitioning towards development of Line of Business Data Mart.
• Developed Macros in IBM Unica for Selection/Suppression criterias which were consistently part of Campaign developments and globally available to all Flowcharts in Unica.
• Integrated IBM Unica Server with Database Server using UNIX to speed up the high volume query execution.
• Created a customized data dictionary in Unica to sample customers for creating survey.
• Integrated a 6 different streams, 9 subsequent waves & 4 different channels Onboarding process in a Single Flowchart & Automated the execution process using IBM Unica.
• Automated a manual process( Stock Plan Administrator Campaigns) which involved multiple input reports, diversified selection/suppression criterias & required customized data cleansing for each input reports.