Career Summary

• Over 6 years of strong IT experience in Analysis, Design/Development, and implementation of applications using Oracle, SQL Server, Teradata, Shell Scripting, Unix.
• Proven track in interacting with Business Analysts, Project Managers, Financial Analysts and team members to coordinate job tasks, gathering business and database requirements etc. Experienced in Extracting, Analyzing data and presenting data in graphical format that helped managers to make business decisions.
• Proficient in Oracle 11g, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
• Strong Oracle skills that include create/design tables, indexes and script PL/SQL scripts, Stored Procedures, Functions and Triggers. Experienced in coding Teradata SQL, Teradata Stored Procedures, Macros, Triggers, String Functions, Joins etc.
• Well capable in preparing Financial Reports, On-Demand Reports using Oracle SQL, Teradata, BTEQ. Developed Adhoc queries and Reports using Oracle, SQL, PL/SQL, and UNIX to fulfill business analysts, Operations Analysts and Financial analysts’ data requests.
• Perform automation of Teradata scripts in UNIX/Linux environments
• Familiar with using Set, Multiset, Derived, Volatile and Global Temporary tables in Teradata for larger Adhoc SQL requests.
• Extensively used Teradata advanced techniques like OLAP functions CSUM, MAVG, MSUM MDIFF etc.
• Developed Reports using the Teradata advanced techniques like Rank, Row number and etc.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts on large database for fast accessing data and generating reports.
• Experience in writing the Korn Shell Scripts to run batch jobs in UNIX and communicate the messages to the database analysts.
• Expertise in Data Analysis, Business Analysis, Data Extraction, Data Marts. Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts and Project Manager.
• Proven capabilities in Extraction, Transformation and Loading (ETL) processes on Teradata using BASE SAS.
• Worked with Quality Assurance team to evaluate test results for fulfillment of all data requirements.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.

Technical Skills

SQL, PL/SQL,BAS SAS, C, C++, C#, UNIX Shell Scripting

Databases:

Teradata13 , Oracle10g, SQL server 2005, MS Access, DB2

DB Utilities/Tools:

BTEQ, fast Load, Multi Load, Fast Export, T Pump, SQL *Loader, Informatica Power Center 7.1.1/8.1.1

Modeling Tools:

Administrator and Teradata SQL assistance, Business Objects4.0, Visio and Erwin (Dimensions, Star schema and Snow flake)

Operating Systems:

Unix, Windows2003 /2000/ XP/NT, IBM AIX

GUI:

MS Office Suite, Visual Basic 6.0

Educational Qualifications
Master of Computer Applications

Professional Experience

Confidential, Richmond, VA
Sr. Data Analyst
June 2010 — Present

Project-I:

Worked with IT Strategy & Analysis team that is responsible for all the infrastructure of Confidential and manages the servers that support different processes. As part of this team I was involved in migrating data from SQL Server to Teradata, developing reports based on the business requirements using Teradata and BOBJ and analyzed data in existing data warehouses.

• Involved in migrating/assembling data as per business process management requirements
• Created Reports, Presentations, Graphs and Charts in SAP Business Objects (BOBJ) tool and created SQL Scripts
• Interfaced with business process users/customers to understand specific requirements and translate them into teradata/SQL scripts.
• Utilized wide variety of data analytics tools & techniques with large scale data systems
• Implemented programs, methodologies and scripts for analyzing and presenting data using Teradata.
• Perform complex data analysis of various change management objects and generate graphical reports using complex SQL queries at different levels of granularity and automating Teradata Scripts.
• Experienced in developing scripts in SAS.

Environment:
Teradata SQL Assistant 13.0, BTEQ, SQL, BOBJ4.0, SAS, Windows NT, UNIX Shell scripts, SQL, SQL *Loader, UNIX-SAS, INSQL, Crystal Reports, PowerPoint , MS Access, Excel

Project-II:

Worked with CMC (Customer Management Center) Risk Event Management Team which manages the customer recovery for CMC generated, or impacted Risk Events. Events reported to card operation event team are taken care by containment, customer and business process recovery. The main goal of EMS team is to recover the customers or the impacted line of business as a whole or restored to a pre-event status. Risk events are managed through the Governance, Risk management, and control system work flow application.

• Performed analysis /research ,identified impacted population on assigned Risk events under different value chains:
• Customer Acquisitions (CA) Value Chain
• Customer Management (CM) Value Chain
• 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.
• Performed analysis for Risk events, for instance customers which were purged from TS2 although account status and/or balance should have prevented this action. Accounts were pre-qualified for purging based upon criteria provided by Capital One
• Worked closely with BA\'s, Process Managers, Intent Owner and various channels/teams to identify customer impacts and perform analysis for Refunding Credit balances, FC and generate apology letters to impacted customers
• 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, BTEQscripts 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 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, used sampling techniques, Explain Plan in Teradata before Query Large tables with billons of records and with several Joins.
• 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 12.0, BTEQ, Oracle 9i, Teradata V2R5, Manual Testing, QTP, ETL, SAS, Windows NT, UNIX Shell scripts, SQL, PL/SQL, SQL *Loader, UNIX-SAS, FastLOad, WINSQL, Crystal Reports, PowerPoint , MS Access, Excel

Confidential, Charlotte, NC 
Data Analyst
June 2008 - May 2010

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Experience in extracting, analyzing and presenting data in a graphical format such a way that helped business managers to make business decisions.
• Coordinated with several managers for Financial Data within the Financial Departments.
• Performed numerous data pulling requests using SQL for analysis.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, project manager data requests.
• Connected to several sources and targets to extract data from different data sources and targets, transform and load the data into target systems using ETL tool Informatica
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using the Teradata advanced techniques like Rank, Row number and etc.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Experienced in using OLAP functions like Sum, Count, Csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Experience in Power Point Presentation (Financial Data, Charts).
• Worked on loading data from flat files to Teradata tables using SAS Proc Import and FastLoad Techniques.
• Worked on different Segmentations such as Direct Mail, Email segmentation processes.
• Expertise in generating graphs using MS Excel Pivot tables.
• Experienced in writing korn shell scripts for automating the jobs.
• Experienced in scheduling the jobs in UNIX using crontab and sleep functions.
• Good at modifying UNIX existing scripts.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Experienced in writing Macros.
• Data manipulation occurs as part of the application process.
• UNIX, Oracle, Teradata being used for data transformation.
• Reports generated for various departments like Tele Marketing ,Mailing, New Accounts by using SQL, BTEQ, Ms Access, Unix
• Extracted data from existing data stores and performed ad-hoc queries.

Environment:Teradata SQL Assistant 7.0, BTEQ, Oracle 11g, Teradata, Informatica, Windows NT, UNIX Shell scripts, SQL, SQL *Loader, PowerPoint, Excel

Confidential, Herndon, VA 
SQL Server Developer/Database Analyst
Dec 2007 - Apr 2008

Sales to Order Confidential is an information access database designed to provide Sales person information about the Premium, commissions, YTD Sales on each product sales such as Life, Annuity, and Mutual Funds. It provides recognition of each producer based on Time Qualified and their financials Commissions, Lapse Percentages and Trend analysis. It also provides the Compliance Profile on Marketing Complaints, Customer Contact Survey Issues, Replacement Issues, Compliance Department Issues and New Business Review Issues. Producer Profile can be used to check the performance of producer on each product and to make decision support for Producer Performances on YTD Sales.

• Developed scripts, triggers, stored procedures, forms, and tables using SQL and PL/SQL for a call center application.
• Developed Ad hoc queries and reports using Oracle, SQL, PL/SQL, UNIX to fulfill business analysts, Operations Analysts and Financial analysts’ data requests.
• Exported data into various formats by using MS Excel and MS Access.
• Performed a crucial role in the gathering of Report requirements and preparation of the report design documents.
• Created tables, indexes, String Functions, Outer Joins in Oracle.
• Performed data validation, Data integrity before delivering data to operations and financial analysts.
• Used SQL * PLUS, Oracle to perform data extraction, data manipulation, data validations.
• Created Account based performance analysis reports using Oracle, SQL, UNIX and Vb as front end.
• SQL scripts were developed for accessing data from the Oracle tables.
• Created reports using SQL, PL/SQL, UNIX for daily and monthly payment reports.
• Stored data in the Data Warehouse about Account Holders, Credit limits.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Experience in designing the procedures for getting the data from all systems to Data Warehousing system.
• Daily Transactions were stored in History Tables for Analysis.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL,PL/SQL, MS Excel, MS Access, Teradata
• Performed data loading and SQL tuning/optimization using SQL*Loader, import and export, Explain Plan and hints.

Environment:
Java, Teradata 12.0, SQL Assist, UNIX Shell Scripts, SAS,Macros, MS Excel, MS Power Point, SQL, SQL *Loader.

Confidential, Columbus, OH 
Data Analyst
Feb 2007 – Nov 2007

• Worked with business analysts by providing specific and crucial information through data mining using Oracle, SQL, Teradata, Bteq, UNIX and Toad.
• Highly experienced in Performance Tuning and Query Optimization for increasing the efficiency of the scripts.
• Wrote Bteq, SQL scripts for large data pulls and ad hoc reports for analysis.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), Macros, views, procedures using SQL scripts.
• ETL process design, implementation and performance tuning (SQL, Teradata macros and stored procedures).
• Used Teradata V2R5, Fastload, FastExport,BTEQ,Multiload, Queryman/SQL assistant, unix shell and Erwin
• Pull and prepare data needed for marketing and legal support

Environment: 
Teradata SQL Assistant 7.0, BTEQ, Oracle 9i, Teradata V2R6, Windows NT, UNIX Shell scripts, SQL, PL/SQL, SQL *Loader, PowerPoint, Excel. SAS