- 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.
ConfidentialData Analyst/Project Lead
- 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
Data Analyst/Project Lead
- 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.