Data Analyst/Project Lead Resume

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

Data Analyst/Project Lead

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.