We provide IT Staff Augmentation Services!

Affinium Camign Developer Resume

PA

SUMMARY

  • Nearly 7 years of cumulative experience as a Data Analyst.
  • Worked on Teradata Utilities BTEQ and SQL Assistant to maintain the database.
  • Experience in Utilities like BTEQ, FastLoad, MultiLoad and Tpump
  • Experience in creating tables in Teradata to be appropriate, for better performance and compatibility with the scripts in BTEQ.
  • Executing sequence of TeraData SQL statements as a single operation.
  • Performing Ad hoc reports in TeraData by using Basic TeraData Query.
  • Performing BTEQ Output, BTEQ Commands, BTEQ Variation (TeraData).
  • Extracted data from production database (Oracle) and prepared financial reports using oracle SQL, PL/SQL, Teradata, and BTEQ.
  • Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse with SQL * LOADER.
  • Good Knowledge about Basic Teradata Utilities.
  • Used Teradata Utilities (BTEQ, Mulitload, and FastLoad) to maintain the database.
  • Skilled in designing data warehouse databases for OLAP processing
  • Worked with Database Utilities, Export/Import, SQL*PLUS, PL/SQL, SQL Server Enterprise Manager, and SQL Loader.
  • Expertise in GUI development using Visual basic 6.0 and Unix Shell Scripting
  • Experience to modify existing scripts and check daily logs for automating backup procedures.
  • Perform in depth analysis and prepares reports by using Ms Excel, Ms Access, SQL, PL/SQL and UNIX.
  • Expertise in maintenance of database objects such as tables, indexes, views, synonyms etc and extensively exposure in performing ETL.
  • Extensive experience with Relational Database Management Systems (RDBMS) including Triggers, PL/SQL Stored Procedures, Packages.
  • Performing Ad hoc reports, Financial reports in TeraData by using Basic TeraData Query
  • Experience in creating SAS datasets by extracting data from raw data files.
  • Experienced in developing batch programs by using SAS, SQL, PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.
  • Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios
  • Experience in all phases of the project life cycle including project definition, analysis, design, coding, testing, implementation and support
  • Strong analytical, diagnostic and problem solving abilities

TECHNICAL SKILLS

Operating Systems: Windows NT/95/98/XP, UNIX, MS - Dos

Languages: SQL, PL/SQL, C

E-Commerce Skills: HTML, DHTML, Java Script and VB Script

RDBMS: Oracle 8.x/9.x, Teradata, MS Access, Crystal reports

Tools: Win Runner 6.0/7.5, Load Runner 6.0/7.0, MS Visio, Test Director,TOAD

PROFESSIONAL EXPERIENCE

Confidential, PA

Affinium campaign Developer

Responsibilities:

  • Interacted with clients to understand their direct marketing needs and gathered business requirements.
  • Developed campaigns to implement FICO Model and perform segmentation based on FICO exchange processing and scoring
  • Developed legacy Confidential campaigns that support the SHD Products: Simple Choice, Active Choice & Select Specialty to identify members who will need to take action in order to continue to fill at Retail.
  • Created tables, views, SQL Scripts.
  • Used Teradata SQL Assistant to process adhoc and business requests and to extract data from various data stores.
  • Developed marketing campaigns with the primary objective to move members from retail to mail.
  • Built campaigns to segment the population based on the communication channels.
  • Wrote Macros for versioning and segmenting data to various call queues.
  • Responsible for adhoc changes in various communication campaigns.
  • Built triggers to automate the FTP process to various vendors like ACXIOM, VERTIS etc.
  • Used Schedulers and created triggers, batch files, ini files to produce automated reports.
  • Developed WELCOME TO MEDCO campaign which Welcomes the patient to mail, answers questions, assists with problems, reviews the patients account and helps patient to maximize their benefit.
  • Developed campaign which produces OB files to a downstream vendor to market the Medco By Mail service.
  • Used Select and snapshot process to load data from files to tables and also from tables to create files.
  • Used Inner Join and Outer join to retrieve data from multiple tables.
  • Have used AFFINIUM PLAN to update the tasks status and upload reports for business reviews.
  • Used APLAN workflow to provide real time visibility into status and effectiveness.
  • Analyzed and documented information system requirements and the corresponding impact on business processes.
  • Involved in writing Unix Shell Scripts for automation to ensure that data captured and stored in database is correct and accurate.
  • Monitoring the existing code performance and to change the code for better performance using Explain, collect stats.
  • Create CRE tickets for running campaigns and resolving other campaign issues.

Environment: Teradata, BTEQ, SQL, PL/SQL, UNICA AFFINIUM CAMPAIGN, MS Access, Windows XP, UNIX.

Confidential, NJ

Sr.Data Analyst

Responsibilities:

  • Interacted with clients to understand their direct marketing needs and gathered business requirements.
  • Used Teradata SQL Assistant to process adhoc and business requests and to extract data from various data sources.
  • Extracted data from production database (Oracle) and prepared financial reports using oracle SQL, PL/SQL, Teradata, and BTEQ.
  • Developed and optimized stored procedures for use as a data window source for complex reporting purpose.
  • Configuration, scheduling, and execution of Teradata utilities (BTEQ, TPump) to maintain the database.
  • Created tables, views, SQL Scripts.
  • Used Teradata Utilities like BTEQ to access the database.
  • Used Joins like Inner join, Outer joins while creating tables from multiple tables.
  • Created BTEQ Scripts to access data from Teradata source System and to generate Reports using MS-EXCEL, SQL and UNIX for weekly and monthly.
  • Responsible for developing and creating Tables, Views using DDL, DCL, and DML.
  • Took an active part in conversion of Oracle based Scripts to Teradata, Bteq scripts.
  • Modified/developed UNIX shell scripts to automate pre-session and post session- tasks and BTEQ scripts.
  • Created Multiset tables and Set tables with proper Unique/Primary Key constraints in the Teradata database.
  • Created and managed tables in Teradata to be appropriate, for better performance and compatibility with the scripts in BTEQ.
  • Extracting data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, PLSQL, procedures, packages, functions, database triggers.
  • Executing sequence of TeraData SQL statements as a single operation
  • Performed Ad hoc reports in Teradata by using Basic Teradata Query.
  • Performed BTEQ Output, BTEQ Commands, BTEQ Variation (Teradata).
  • Took an active part in conversion of Oracle based Scripts to Teradata, Bteq scripts.
  • Created and managed tables in Teradata to be appropriate for better performance and compatibility with the scripts in Bteq.
  • Used Excel Pivot Tables to represent data and presentation
  • Monitoring the existing code performance and to change the code for better performance.
  • Used Inner Join and Outer join to retrieve data from multiple tables.
  • Have used analytical skills and quantitative knowledge for problem solving.
  • Responsible for the analysis, design, development, coding, generation of reports using SQL, testing and documentation.

Environment: Teradata, BTEQ, SQL, PL/SQL, MS Access, Windows XP, UNIX.

Confidential, Milpitas, CA

Data Analyst

Responsibilities:

  • Created and managed tables in Oracle for better performance and compatibility with the SQL scripts.
  • Used SQL to process adhoc and business requests and to extract data from various data stores.
  • Responsible for loading data from flat files in UNIX, MVS into Oracle tables.
  • Performed data validations for business requirements.
  • Worked with Oracle Utilities, Export/Import, SQL*PLUS, PL/SQL, Oracle Enterprise Manager, and SQL Loader.
  • Extracted data from existing data source and performed ad-hoc queries by using SQL, PL/SQL, Ms Access, SQL server and UNIX.
  • Designed & developed various Ad hoc reports for the finance (Oracle SQL, PL/SQL, SAS, and Brio).
  • Extracting data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, PL-SQL, procedures, packages, functions, database triggers.
  • Created tables, views, procedures using SQL and PL/SQL.
  • Worked on Script remediation to enhance the scripts as per the departmental and business requirements.
  • Used UNIX Shell scripts to run batch Jobs and communicate the messages to the users.
  • Good Analytical and Documentation skills and ability to perform in a Team Environment.
  • Used SQL to perform Backend testing.
  • Experience in Release engineering and Version Control system using Designer.
  • Prepared training materials, taught classes and provided individual training.
  • Created reports by using tools such as Oracle Reports/SQL Report Writer.
  • Experience documenting customer problem information, recommendations, and resolution utilizing call tracking tools and/or methodologies.
  • Managed user privileges, roles and user accounts.
  • Used Explain Plan to assist the end user in SQL tuning.
  • Experience Performing Problem troubleshooting, Problem resolution, and root cause analysis for Application and batch related issues.
  • Tuned and verified queries using tools such as SQL Navigator.
  • Provided 24 x 7-production support on database side
  • Performed data validations for business requirements.
  • Provided support and fixed issues during testing of the products and after go live.

Environment: MS Access, Oracle 9i, PL/SQL, UNIX Shell Scripts, Windows NT/2000, UNIX.

Confidential, NY

Data Analyst

Responsibilities:

  • Used Teradata Utilities like BTEQ, SQL Query manager to maintain database.
  • Actively involved to develop GUI interface for the applications.
  • Responsible to load data from flat files to Oracle and Teradata.
  • Used Joins like Inner joins, outer joins while creating tables from multiple tables.
  • Extracting data from existing data stores.
  • Developing and executing departmental reports for performance and response purposes by using oracle SQL, database triggers, Visual Basic (Macro's).
  • Implemented with the group for enhancement of the segmentation.
  • Utilized ODBC for connectivity to Teradata & Excel.
  • Used SQL*LOADER to load data into oracle application tables by (control files, data files)
  • Performed in depth analysis on data & prepared weekly, biweekly, monthly reports by using Excel, SQL, and UNIX.
  • Used Unix Shell scripts to run batch Jobs and communicate the messages to users.
  • Good Analytical and Documentation skills and ability to perform in a Team Environment.
  • Used SQL to perform Backend testing.
  • Utilized skills for problem solving.
  • Did Quality Analysis.
  • Developed baseline scripts for testing the future releases of the application.
  • Conducted functionality, and regression testing during the various phases of the application.

Environment: MS Access, Oracle 9i, Teradata, PL/SQL, UNIX Shell Scripts, Windows NT/2000, UNIX.

Hire Now