SUMMARY

• Progressive and innovative software professional with over 7 years of experience in Software Industry as a Data Analyst.
• Well versed knowledge on SQL scripts on various Relational Databases.
• Created Tables with Referential Integrity for implementing business rules and queries were developed using SQL.
• Experience in Data Verifications and Validations.
• Proficient in preparing Power Point Presentations, graphs, tables and charts using MS Excel.
• Perform Grant, Revoke table access to Database Analysts, Business Analyst, Operational Analysts and Project Manager.
• Handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.
• Team player with ability to adapt to various environments with excellent communication, interpersonal skills.
• Performing Adhoc reports by using Oracle and UNIX.
• Attending project meetings and work with teams, Project managers, team members associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks. Strong written and oral communication skills.
• Extracting data from existing data stores. Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Access, and MS Excel.
• Experience working in campaigns using Unica Affinium Campaign Management Tool.
• Good Experience in preparing financial reports using oracle SQL.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell Scripting, VB Script, VBA, ASP

Database Tools: BTEQ, Fast Load, Multi Load, Fast Export, T Pump Teradata, SQL Server, DB2, MS - Access, ADI, TOAD, SQL*NAVIGATOR, Reports Builder.

OLAP Tools: Hyperion IR11 Report.

Front End Tools: Oracle Developer2000, Visual Basic and MS Access

Reporting: Oracle Reports, MS Excel Reports, MS Access ReportsOthers MS Office Suit (Word, Excel, Power Point), MS Project 95,SQL Assistant, Toad

Operating Systems: UNIX, Sun Solaris 8, MS Windows, NT Server 4.0, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Data/Analyst

Responsibilities:

• Responsible for the development and administration of analytical data constructs/structures. Review of UNIX and Teradata scripts for data quality, data organization and metadata.
• Perform QA on scripts in simulated production environment and report findings to team and customer.
• Move new or existing code into Production environment by using Change Control procedures.
• Work with customers to hold, re-run, or cancel production scripts.
• Created tracking system for requests from customers so that metrics can be derived to show value to management and business.
• Running scripts in HP-UX environment and validate outcome
• Work with Project Managers to assist in creating or modifying scripts so that it meets or exceeds the customer’s deadline.
• Assisted to create procedures for customers to follow so that scripts can be promoted to Production in a predictable and timely manner.

Environment: Teradata SQL Assistant 12.0, BTEQ, Oracle 9i, Teradata V2R5, Manual Testing, QTP, ETL, SAS, WindowsNT, UNIX Shell scripts, Edit Plus, HPServiceManager, PowerPoint, MS Access, UltraEdit, MSExcel.

Confidential, New York, NY

Data/Teradata Analyst

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• 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.
• Proficient in importing/exporting large amounts of data .
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per business requirements.
• 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.
• Created daily and monthly reports using SQL and UNIX for Business Analysis.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using SQL.
• Utilized ODBC for connectivity to MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts.
• Experience in Power Point Presentation (Financial Data, Charts).
• Expertise in generating graphs using MS Excel Pivot tables.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents. Unix, Oracle, SAS being used for data transformation.
• Reports generated for various departments like Tele Marketing, Mailing, New Accounts by using SQL, Ms Access, Unix
• Ad-hoc reports developed using Oracle, SQL, and UNIX.
• Designed marketing campaigns using UNICA Affinium Campaign Management Tool.
• Extracted data for the Segmentation Process for different channels like direct mail and e-mail using the Unica Affinium Campaign Management Tool.
• Worked on complete Segmentation Process.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using Oracle SQL, MS Excel.

Environment: SQL Assist, Oracle SQL, UNIX Shell Scripts, MS Excel, MS Power Point, Unica Campaign Management Tool.

Confidential, Charlotte - NC

Data/Teradata Analyst

Responsibilities:

• Responsible for gathering requirements from business analysts and operational analysts and identifying the data sources required for the reports.
• Highly experienced in performance tuning and optimization for increasing the efficiency of the scripts.
• Worked on loading data from flat files to Teradata tables using SAS Proc Import and FastLoad Techniques.
• Experience working on campaigns and loading data into staging tables via views.
• Writing SQL scripts for huge data pulls and ad-hoc reports for analysis.
• Develop reports using the Teradata advanced techniques like rank, row number and etc.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Expertise in generating graphs using MS Excel Pivot tables and creating presentations using Power Point.
• Experience in using OLAP functions like sum, count, csum, etc.
• Created Set, Multiset, Derived, Volatile, Global Temporary tables.
• Experience in writing korn shell scripts for automating the jobs.
• Automate reports by connecting Teradata from MS Excel using ODBC.
• Experience 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.

Environment: Teradata 12.0, SQL Assist, UNIX Shell Scripts, SAS, MS Excel, MS Power Point

Confidential, Mayfield Village, Ohio

Data/Teradata Analyst

Responsibilities:

• Analyzed the customer behaviors on progressive website.
• Analyzed different versions of the site and the traffic for each month, quarter and year.
• Created documentation and updated them so as to reflect the most current process.
• Involved in developing many Dash Boards for home, rental and auto insurance.
• Worked on different Segmentations such as Email Segmentation process.
• Coordinated with several managers in linking information and data within the financial departments.
• Involved in user trainings during system upgrades and enchantments.
• Compiled reports such as Marketing reports, Brand reports and branch reports
• Creating SQL files indexes and calculated the table spaces for each table, tuning the SQL queries (based on the plan tables).Grant and revoke table access to users.
• Created Control files to load data into databases by help of ETL tool (Extract Transform Process).Created Tables, Indexes, Views, Snapshots, Database links to see the information extracted from SQL Files.

Environment: Teradata V2R6, BTEQ, FLOAD, UNIX, SQL, Windows XP, SAS

Confidential, Tampa, FL

Data Analyst

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Experienced in Creating the Data bases and users
• Space estimations and User maintenance on dev machine
• Designing the ETLs and conducting review meets
• Involvement in implementation of BTEQ and Bulk load jobs
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the SQL’s on UNIX environment. Performance tuning the long running queries.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and
• SQL*Plus, SQL*Loader
• Reduced Teradata space used by optimizing tables - adding compression where
• Appropriate and ensuring optimum column definitions.
• Monitoring ETL jobs until production jobs are stabilized.
• 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.

Environment: Teradata V2R12, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP, Sun Solaris 2.8, SAS, SAS/MACROS Erwin Data Modeler..

Confidential

Data Analyst

Responsibilities:

• Studying the Business Requirements Design (BRD) for the enhancements/Physical Data Model changes raised by the business.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets using Explain Plans.
• Graphical representation of the reports using MS Power Point Presentation and MS Excel Charts.
• Allocation and monitoring of work to the project team members.
• Unit, Integration and User Acceptance testing.
• Providing assistance to the Extraction and Reporting team.

Environment: Oracle, Toad, MS Excel, PowerPoint.