PROFESSIONAL SUMMARY

• Over 6 years data warehousing projects experience in various phases like Data Analysis, validation, Modeling, Extraction, Transformation, Loading and reporting using TERADATA(V2R5,V2R6,V12), UNICA AFFINIUM CAMPAIGN, ORACLE, SQL SERVER and DB2.
• Primary experience in TERADATA BTEQ, MLOAD, FLOAD, TPUMP and ORACLE (SQL, PLSQL).
• Experience in banking, Telecom and Health care management industry business processes.
• Capable of designing and configuration of complex systems wif best practices.
• Strong Teradata skills that include build/maintain tables, indexes & build/maintain SQL, PL/SQL scripts, Stored Procedures, Triggers and Functions.
• Created Waterfall Reports for the most of the marketing campaigns.
• Performed Tuning the queries and Troubleshooting the errors of the campaign flowchart
• Extensive experience in building complex campaigns in Affinium campaign.
• Developed Test campaign and canary campaigns in the Affinium Tool.
• Experience in writing UNIX Shell Scripts and Database validation scripts.
• Worked on Email campaigns, inbound, outbound, Direct Mail and In Statement Letters using Unica’s Affinium Campaign.
• Involved in gathering business and database requirements.
• Experience in building data marts, data structures, data storages, data warehouses, data Archives, data analysis.
• Experience in understanding Teradata data dictionary and normalization techniques.
• Good interaction wif Business Analysts, Project managers, Operations/ process, Financial analyst and team members to coordinate job tasks.
• Designing, Developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Dataware house tables, views, Materialized Views, Indexes Confidential Database level using PL/SQL, Oracle.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, Ms Excel, Ms Access, and Teradata.
• Create Join Indexes, Primary Partitioned Indexes Added Collect Statistics from better performance.
• Archived the old data by converting them in to SAS data sets and flat files.
• Performing Data validation, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata, Bteq.
• Experienced in developing batch programs by using SQL, PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.
• Very proficient in performance tuning and Query Optimization using utilities like, SqlTrace, Tkprof.
• Excellent skills in Ms Office (Ms Word Ms Excel, Ms PowerPoint, Ms Access)
• Wif Excel/VBA and MS Access Implemented, developed, and supported financial applications regarding Interest Rate Swaps.
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Worked wif the users and testing teams to implement the business logic as expected.
• Good experience working wif very large databases and Performance tuning.
• Creative to understand complex problems and finding right solutions in time
• Team Player as well as able to work independently wif minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace wif latest technologies

TECHNICAL SKILLS

• TeradataV2R4/V2R5/V2R6/V12
• Unica affinium campaign 8.2
• Unica Plan
• Aprimo
• Oracle10g/9i
• SQLserver2000/2005
• MS Access
• Business Objects 5.x/XI R2
• SSRS
• Sun Solaris 8/9/10
• SUSE Linux
• Windows
• 2003/2000/XP/NT
• IBM AIX 4.3/4.5/5.2
• UNIX shell scripting
• PERL
• BTEQ
• Fast Load
• Multi Load
• Fast Export
• T Pump
• SQL*Loader
• Teradata Manager
• Performance Monitor
• TeradataProfiler
• TeradataAdministrator
• TeradataParallel
• Transporter (TPT) and Teradata
• SQLAssistant

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Unica Campaign Analyst

Responsibilities:

• Interacted wif business users and gatheird the requirements.
• Extracted customer data form database using SQL which included analysis of large data sets.
• Developed the campaigns based on business requirements.
• Developed various SQL scripts to create business logic
• Worked on Direct Mail campaigns
• Generated weekly report wif the help of NETEZZA, SQL and MS Excel
• Scheduled the flowcharts to run during night times.
• Build new flowcharts using existing flowcharts and existing templates and data manipulation process of the flowchart.
• Created Derived fields and Uservars depending upon the campaign
• Used snapsot, sample and audience process boxes
• Worked wif various direct marketing campaigns and provided analysis and reports
• Extracted data from various production databases using Netezza to meet Campaign data needs.
• Permformed the SEGMENTATION and analyzed using Unica affinium tool.
• Reported to Campaign manager on excution as well as data needs
• Created test and control populations for Direct Marketing based on the business rules. Interacted wif business users and gatheird business requirements.
• Extensively worked on cell split specifications and ISP campaigns
• Developed monthly campaigns and weekly campaigns based on the requirements.

Environment: Netezza, win SQL Unica Affinium campaign 7.5, 6.01, Oracle, SQL, PL/SQL, UNIX, Windows 2000/NT UNIX, Edit Plus

Confidential, Atlanta, GA

Sr. Unica Campaign Analyst

Responsibilities:

• Provided Data Analysis, gatheird Business requirements and Designed and developed various Business Reports
• Developed the campaigns based on business requirements.
• Developed various BTEQ scripts to create business logic and process the data.
• Generated weekly, bi weekly, monthly reports wif help Teradata, SQL, BTEQ, MS Access, MS Excel, UNIX, SAS.
• Worked on EMAIL, Direct Mail and SMS campaigns.
• Developed the control population for specific campaigns
• Created adhoc campaign, recurring campagins and emergency campaigns
• Worked wif business analysts by providing specific and crucial information through data mining using Teradata, SQL, Bteq and UNIX
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD and Tpump.
• Created custom macro’s and triggers
• Scheduled the flowcharts to run during night times.
• Created Derived fields and Uservars depending upon the campaign
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Permformed the SEGMENTATION and analyzed using Unica affinium tool.
• Kicked off jobs to download flatfiles and SAS data sets using SAS.
• Used Audience, maillist and snapshot process box
• Monitoring the existing code performance and to change the code for better performance.
• Performed data validations, Data integrity before delivering data to operations.
• Created SQL Library for all business related questions.
• Developed SQL queries for Extracting data from production database and built data structures, reports.
• Designed, Developed Ad - hoc reports as per business analyst, operation analyst, project manager data request..
• Performed various data pull from Teradata One View Data warehouse using SQL Assistant and Bteq
• The SQL Assistant has been used to query the database objects to validate the data quality
• Wrote complex SQL for few custom macro’s for use in the flowchart.
• Collected Stats on user tables in pre and post process of a select and segment process boxes.
• Developed monthly campaigns and weekly campaigns based on the requirements.
• Used Fast Exports to generate Flat files after the Change data capture has been accomplished which in turn creates a loadable file that is used to load the database
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel, Unix, Oracle, Teradata being used for data transformation

Environment: Teradata V12, SQL Assistant, Unica Affinium campaign 8.2, Teradata utilities (BTEQ, FastLoad, Fast Export) 6.01, Oracle, SQL, PL/SQL, UNIX, Windows 2000/NT UNIX, SAS 9.1.3, SQL Assistant, SAS .

Confidential, Blue bell, PA

Sr. Unica Analyst

Responsibilities:

• Participated in Requirement collection process and compiled them to User Requirements.
• Developing and executing campaigns manually using Unica affinium campaigns.
• Worked on Medicare part D and part B campaigns
• Developed the welcome kits campaigns for the new members
• Executed the campaigns of drug coverage and temporary coverage
• Created various channels of Phone, Email and Direct Mail campaigns
• Worked on prescriptions of the members
• Extracted data from various production databases using Teradata to meet Campaign data needs.
• Reported to Campaign manager on excution as well as data needs.
• Documented campaign methodology and provided technical/functional help to other team members.
• SQL scripts were developed for accessing data from the Teradata tables.
• Tuned the SQL queries for optimum performance.
• Involved in Analysis, Design, Development and Testing for Finance domain of Alcatel-Lucent.
• Migrated the campaigns from Oracle to Teradata
• FTP ‘ed the files to Vendor
• Developed the waterfall reports in the campaign
• Created and tested BTEQ, MLOAD & FLOAD Scripts
• Solved the production campaign issues.
• Created numerous Volatile, Global, Set, MultiSet tables.
• Used Inner, Outer Join, UNION,INTERSECT, CUBE, RANK, QUANTILE,
• And OLAP functions CSUM, MSUM, MAVG, MDIFF.
• Created numerous scripts wif Teradata utilities BTEQ, MLOAD and FLOAD.
• Analyze, design, code, test, implement and a support data warehousing extract programs and end-user reports and queries.
• Created numerous SQL as per project requirement.
• Used Basic Teradata Query utility for reporting Purpose.
• Developed Basic Teradata Query (BTEQ) for Interactive & batch queries.
• Developed complex campaigns such as Health savings account for new members.
• Assisted in maintaining campaign environment, including development and maintenance of standard and reusable components wif campaign management tool, executing periodic tasks, and maintaining procedural documentation.
• Highly competent in software development lifecycle methodology and feasibility through the evaluation of the existing version of the Affinium campaign.
• Identified the deficiencies of the current version and requested for the Unica enhancements for the system improvements, proposed the new environment which includes new Triggers, Macros and system tables.
• Worked on Medicare Patient’s acquisition and Management campaigns.

Environment: Teradata V2R5,V2R6, Unica affinium campaign 7.2, Unica plan, Aprimo, MLOAD, FLOAD, BTEQ, Tpump utilities, SAS, UNIX, Oracle, SQL and PL/SQL.

Confidential, NC

Campaign Analyst

Responsibilities:

• Interacted wif business users and gatheird the requirements.
• Extracted customer data form database using SQL which included analysis of large data sets.
• Scrubbing and subsetting data for the purpose of sustaining data accuracy as well as maintaining data quality; creating and selecting new variables
• Build new flowcharts using existing flowcharts and existing templates and data manipulation process of the flowchart.
• Worked wif various direct marketing campaigns and provided analysis and reports
• Created test and control populations for Direct Marketing based on the business rules. Interacted wif business users and gatheird business requirements.
• Supported and maintained SAS applications for new campaigns.
• Created Macros and Triggers in Affinium campaign.
• Performed validations on fulfillment tables to make sure we populated right values into the table.
• Mentioned notes in the general tab of the process box to give more understanding of flowchart.
• Participated in analysis, design, coding and development to build staging tables, views and SQL files.
• Retrieved the customer credit limit, utilization and spending of the card from the database.
• Stored account holders credit information into warehouse.
• Generated risk of the customer based on fico score.
• Generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports.
• Supported Monthly and weekly campaigns using Unica’s Affinium Campaign
• Created flowcharts from existing templates and data manipulation process of flowchart in Affinium
• Communicate wif Business Analysts to capture the Business Needs of the specific campaign.
• Create tables, indexes, String Functions, Outer Joins in Teradata.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.

Environment: Teradata, Unica Affinium campaign, SQL, PL/SQL, SAS, Oracle, PL/SQL,Toad, UNIX SHELL SCRIPT, MS ACCESS, SQL*Loader, Micro Strategy, Brio, ETL, VBA, Ftp.