Professional Summary:

• Over 6 years of IT experience as a Teradata Developer/Database Analyst in financial and telecom industries.
• Experience in Designing, Developing, and Implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, Views, Materialized Views, Indexes at database level.
• Good experience in Data Modeling with expertise in creating star and snow flake schemas, fact and dimension tables, physical and logical data modeling.
• Expert in working with Oracle and Teradata.
• Strong experience in Data Warehousing, Data Marts, Data Analysis with RDBMS databases.
• Excellent working experience in creating adhoc reports using Teradata.
• Worked on SQL, PL/SQL, MS Access and Teradata to design and develop weekly, monthly reports for marketing and financial domains.
• Archived the old data by converting them into SAS data sets and flat files.
• Good experience in creating Metadata and Field Mapping
• Experience in Extraction, Transformation and Loading ETL processes on Teradata using BASE SAS.
• Hands on experience in Unica Affinium Campaign tool.
• Extensively performed Data validations, Data integrity, Data quality checking before delivering data to operations.
• Developed Test campaign and canary campaigns in the Affinium Tool.
• Performed tuning the queries and troubleshooting the errors of the campaign flowchart.
• Expert in Automating and Running SQL Scripts in UNIX Environment.
• Good working experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Worked with the users and testing teams to implement the business logic as expected.
• Good Experience in working with very large databases and Performance tuning.
• Creative in understanding complex problems and finding right solutions on time.
• Participated in project meetings and work with teams, project managers, business analysts, statisticians, and internal customers/ end users.
• Excellent Team Player, able to work independently with minimal supervision, innovative and efficient, strong desire to keep pace with latest technologies.

Technical Sills:

Project Experience

Confidential

Data Analyst/Developer

Roles and Responsibilities:

• Provided Data Analysis, gathered Business requirements, Designed and developed various Business Reports
• Created weekly, bi weekly, monthly reports using Oracle, Teradata, SQL, BTEQ, MS Access, MS Excel, UNIX, SAS.
• Extensively worked on exporting data to flat files using Teradata
• Experienced in moving files from teradata to UNIX and then to MVS and vice versa using SAS.
• Kicked off jobs to download flat files and SAS data sets using SAS.
• Monitoring the existing code performance and to change the code for better performance.
• Extensively Performed data validations, Data integrity before delivering data to operations, financial analyst.
• Good working Experience in database monitoring and data stewardship.
• Performed the Segmentation and analyzed using Unica affinium tool.
• Worked on EMAIL, Direct mail and SMS campaigns.
• Developed the control population for specific campaigns.
• Created adhoc campaign, recurring campaigns and emergency campaigns.
• Identifying root cause problems and providing solutions.
• Written SQL queries for Extracting data from production database and built data structures, reports.
• Designed, Developed Ad-hoc reports as per business analyst, operation analyst and project manager data request.
• Performed various data pulls from Teradata using SQL Assistant and Bteq.
• Used SQL Assistant to query the database objects to validate the data quality.
• Extensively 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.
• Analyzed data by pulling data from data warehouse into MS Excel and build graphs.
• Generated various weekly, monthly Business Reports for Business Analyst.
• Extracted data from various production databases like Oracle, Teradata to meet business reports.
• Performed tuning and optimization of large databases for fast accessing of data and reports.
• Exported data from Teradata into various files by using Ms Excel, Ms Access and SAS.
• Performed various check on fulfillment data
• Developed Ad hoc queries, SQL queries to fill business analyst, Operations Analysts, Financial analyst data requests

Environment: Teradata, sql assistant 6.1 ,NCR Teradata utilities BTEQ, Fast Load, Fast Export , Unica Affinium campaign 7.2, SQL,Business Objects, UNIX, Windows 2000/NT UNIX, BASE SAS , SAS PROC SQL

Confidential

Business Data Analyst

Roles and Responsibilities:

• Performed analysis /research, identified impacted population on assigned Risk events under different value chains: Customer Acquisitions CA Value Chain,Customer Management CM Value,Service Customers SC Value Chain
• Interact closely with the business stakeholders to crystallize on the criteria for data mining and drive critical business decision based on the outcome.
• Based on business needs extract relevant data to facilitate desired customer communication.
• Take necessary actions to fulfill business needs and improve customer satisfaction.
• Experienced in working with different channels/systems.
• Interact closely with business to define impacted population.
• Extensively handle the adhoc requests and provided adhoc reports.
• Stored data in the Data Warehouse about Account Holders, Credit limits.
• Performed analysis for Risk events, for instance customers which were purged from TS2 account status and/or balance should have prevented this action. Accounts were pre-qualified for purging based upon criteria provided by PNC
• Performed analysis for Refunding credit balances, FC and send apology letters to Impacted population.
• Worked closely with BA's, Process Managers, Intent Owner and various team to identify customer impacts.
• Responsible for analyzing the criteria/intent provided by BA's to pull impacted population and getting accountable executive signoff's on the financial impacts, customer recovery plan and communication sent out to customers.
• Extensively used SQL, BTEQ scripts in identifying impacted customers and followed different process tool for corrective action.
• Used various tools like Fast load, Unix-SAS etc during data analysis.
• Worked with different channels within the company to recover impacted customers.
• Worked on tables Like Set, Multiset, Derived, Volatile, Global Temporary , Macros, views, procedures using SQL scripts.
• Developed large size flow charts to segment population with added inclusions and exclusions for balance build events.
• As per Ad-hoc request created History tables, views on the top of the Finance Data mart/ production databases by using Teradata, BTEQ, and UNIX.
• Established corrective actions and placed controls to prevent further impacts.
• Extensively used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
• Worked on Testing Primary Indexes and SKEW ratio before populating a table, using sampling techniques.
• Extensively worked on Unix Shell Scripts for automating the data mart scripts , checking daily logs , sending e-mails , purging the data , extracting the data from legacy systems , archiving data in flat files to Tapes

Environment:

Teradata SQL Assistant , BTEQ, Oracle 9i, Teradata V2R5, Quality Center, QTP, ETL, SAS, Windows NT, UNIX Shell scripts, SQL, PL/SQL, SQL Loader, UNIX-SAS, Fast Load, WINSQL, Crystal Reports, PowerPoint , MS Access, Excel

Confidential

Business Data Analyst-1

Roles and Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Highly Experienced in Creating the Data bases and users.
• Worked extensively in designing the ETLs and conducting review meets.
• Involved in implementation of BTEQ and Bulk load jobs.
• Worked ample in coding using BTEQ SQL of TERADATA, wrote Unix scripts to validate, format and executed the SQL's on UNIX environment. Performed tuning the long running queries.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS
• Worked on utilities such as Multi Load, Fast Load, Fast Export, BTEQ Teradata and SQL Plus, SQL Loader.
• Worked on Monitoring ETL jobs until production jobs are stabilized.
• Extensively worked on tuning and optimization of Teradata Queries.
• Using the UNIX wrappers to make the workflows.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Developed mappings to dynamically generate parameter files used by other mappings.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked on Teradata Queryman to validate the data in warehouse for sanity check.
• Scheduled jobs for batch processing using Maestro Scheduler.
• Performance tuning of sources, targets, mappings and SQL queries in transformations.
• Developed unit test plans and involved in system testing.

Environment: Teradata V2R12, Mainframes, JCL, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP, SAS, SAS/MACROS

Confidential

Jr Teradata Developer

Roles and Responsibilities:

• Worked with Business analysts to Provide Business Performance Data and other data using Teradata, Oracle, SQL, BTEQ, and UNIX.
• Responsible for analyzing business requirements and developing Reports using PowerPoint, Excel to provide data Analysis solutions to business clients.
• Created Daily, Weekly, monthly reports related by using Teradata, Ms Excel, and UNIX.
• Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
• Extracted data from various production databases using Teradata to meet Campaign data needs.
• As per Ad-hoc request created History tables, views on the top of the Finance Data mart/ production databases by using Teradata, BTEQ, and UNIX.
• Stored data in the Data Warehouse about Account Holders, Credit limits.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Involved in Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
• Worked on tables Like Set, MultiSet, Derived, Volatile, Global Temporary , Macros, views, procedures using SQL scripts.
• Worked on Converted Flat Files into Teradata Tables using JCL programs
• Written several JCL's and SQL queries in Teradata to extract the data from Teradata tables by using joins and Sub Queries.
• Extensively worked on Unix Shell Scripts for automating the SQL scripts, checking daily logs, sending e-mails, purging the data, extracting the data from legacy systems, archiving data from flat files to Tapes, setting user access level, automating backup procedures, Scheduling the Jobs, checking Space usage and validating the data loads.

Environment: Teradata SQL Assistant, BTEQ,VBA,DB2,JCL,MVS Teradata, UNIX Shell scripts, SQL, PowerPoint, Excel.