We provide IT Staff Augmentation Services!

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.

Hire Now