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.