SUMMARY

• 6 Years of professional hands on experience in software design, and development for the entire software development life cycle using SQL, Teradata in client - server and web applications and data warehouse.
• Experiencein Interacting with Users, Analyzing client business processes, Gathering business requirements, and Design & Development of Financial and Clinical Reports.
• Experienced inFinancial and Health Insurance Domains.
• Experience in Data Verifications and Validations.
• Strong analytical and conceptual skills in database design & modeling in Teradata.
• Experienced with Relational databases like Teradata, Oracle and SQLServer.
• Extensively used SQL quires to manipulate the data.
• Experience in performing Adhoc reports using Teradata, BTEQ, and UNIX.
• Experienced in SQL performance tuning and debugging of existing ETL process
• Extensively worked in Teradata jobs including performance tuning, knowledge in UNIX environment and Scheduling jobs.
• Hands On Experience in Unica Affinium Campaign Marketing Tool
• Automated and scheduled the jobs using UNIX shell scripting (CRONTAB).
• Exposure in extracting, transforming and loading (ETL) data from other databases and text files using SQL Server ETL tools.
• Experienced working on large volume of Data using Teradata SQL and BASE SAS programming.
• Experienced working with Excel Pivot and VBA macros for various business scenarios
• Experiencedin Extracting Data from Mainframes Flat File and converting them into Teradata tables using SAS PROC IMPORT, PROC SQL etc.
• Experience in working on various Business Projects, which requires Dual Data Validation and Data Consistency.
• Working on Business Objectsenterprise ProductsUniverse Designer, Desktop Intelligence, Web Intelligence and Info View.
• Designed and published visually rich interactive Tableau workbooks and dashboards for executive decision-making.
• Designed & developed various Ad hoc and standard report for the finance and health industries.
• Good experience inProduction Support, Identifying root causes, Trouble shooting and Submitting Change Controls.

TECHNICAL SKILLS

RDBMS: Teradata, Oracle, SQL Server

QUERY TOOLS: TOAD, Teradata SQL AssistantScripting Shell Scripting, VBA

Languages: C, C++, JAVA, SQL, BASE SAS, PL/SQL, SAS, HTML, and DHTML.

GUI: MS Office Suite, Tableau, Unica Affinium Campaign

OS: Windows XP, Windows and UNIX.

Business Intelligence Tools: Business Objects, Tableau.

PROFESSIONAL EXPERIENCE

Confidential - Wilmington, DE

Data Analyst/Tableau Developer

Responsibilities:

• Responsible to gather requirements from business users and format them according to the business needs, model the requirements to match the current architecture and also to successfully implement business logic.
• Analyzed logical and physical design requirements of the applications.
• Working closely with the BA to ensure they have captured all the requirements correctly.
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into Confidential database.
• Created Set, Multiset, volatile and derived table.
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, join strategies and hash distribution methods.
• ImplementedIndexes and Collect Statistics while creating tables.
• Experience in using OLAP function like Count, SUM and CSUM.
• Developed scripts using Teradata advanced techniques like Row Number and Rank Functions.
• Worked on performance tuning and Query Optimization for increasing the efficiency of the scripts.
• Extracted data from existing data source and performed ad-hoc queries by using SQL.
• Using advanced Excel features like Pivot tables and Charts for generating Graphs.
• Extensively worked on to convertORACLE scripts into Teradata scripts.
• Experience in scheduling the job and automating scripts in UNIX.
• Reconciliation processwere done in order to account for any variances in reports usingTeradata, BTEQ, Shell scripting
• Helped users byExtracting Mainframe Flat Files (Fixed or CSV) onto UNIX Server and then converting them into Teradata Tables using BASE SAS Programs.
• Used SAS PROC IMPORT, DATA and PROC DOWNLOAD procedures to extract the FIXED Format Flat files and convert into Teradata tables for Business Analysis.
• Working on generating various dashboards in Tableau Server using source as Teradata.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, MS Excel, MS Access, Teradata.
• Developed Tableau data visualization using Dual Graphs, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Stacked Bar Charts.
• Proficiency inprioritizing and multi-taskingto ensure that tasks are completed on time.

Environment: Teradata SQL Assistant, BTEQ, Oracle 10g, Teradata V2R6, Tableau, Windows NT, UNIX Shell scripts, SQL, PowerPoint, MS Excel.

Confidential - Falmouth, ME

Data Analyst

Responsibilities:

• Responsible for gathering requirements from business analyst and functional analyst and format them according to the business needs, identify tables required for data model.
• Provide continuity and accuracy in reporting by validating and testing data, identifying missing/erroneous data, disparities/inconsistencies between data sources as well as validating accuracy/consistency with stated business rules.
• Extracted data from various production databases using Teradata to meet business report needs.
• SQL scripts were developed for accessing data from the Oracle/SQL server tables.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, and Indexes.
• Developed numerousTeradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Experienced in writing complex SQL and using Aggregation Functions.
• Tuning of SQL to Optimize the Performance, Spool Space Usage and CPU usage.
• Generated weekly, bi weekly, monthly reports with help of Oracle, SQL, MS Access, MS Excel, SAS and UNIX.
• Extensive experience in writing and executing BTEQ scripts for validation and testing of the sessions, data integrity between source and Confidential database and for report generation.
• WroteSAS Scripts to read TAB Delimited Flat Files and Convert into Teradata Tables.
• Used VBA Macro to create Weekly reports.
• Working on Business Objectsenterprise ProductsUniverse Designer, Desktop Intelligence and Web Intelligence for creating reports.
• Experience in building and retrieving data usingUniverses, Personal data files,and creating complexad-hoc Reports using theBusiness Objectssuiteapplications and Live Office.
• Worked in advanced reporting functionalities such as Master Detailed,Drill, Filters, Ranking, Sections, Graphs and Breaks.

Environment: - Teradata SQL Assistant, BTEQ, SAS, MS Excel, UNIX Shell scripts Teradata V2R5, Oracle 10g, Business Objects, VBA.

Confidential, Arlington TX

Data Analyst

Responsibilities:

• Gathering of Requirements from various systems business users.
• Communicating with the business users to understand business requirements clearly
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Developing and executing campaigns manually using Unica affinium campaigns.
• Performed the SEGMENTATION and analyzed using Unica affinium tool
• Created tables, indexes, views, string functions and joins in Teradata
• Performedtuningandoptimizationof complexSQL queriesusingTeradata Explain.
• Used variousTeradata Index techniquesto improve the query performance.
• Developed and executed business reports using the Teradata SQL advanced techniques like rank, row number and etc.
• UsedUNIXshell script programming to calculate the date values and assigned to a UNIX variable and used these variable inBTEQSQL Where conditions.
• Automate SQL Jobs in UNIXusing KORN Shell scripting.
• Designed/Developed scripts to move data from the staging tables to the Confidential tables.
• Designed & developed various departmental reports by usingSAS, SQL, and MS Excel.

Environment: - Teradata SQL Assistant, BTEQ, SAS, Unica Affinium campaign, UNIX Shell scripts Teradata V2R5, Oracle 9i.

Confidential, Minneapolis, MN

Data Quality Analyst

Responsibilities:

• Perform and lead testing in order to ensure data quality.
• Define test data needs in partnership with IT and provide technical support on data warehouse teams.
• Lead definition of quality needs with business teams. Include expertise in Data Quality, Data Organization, metadata, and data profiling.
• Provide input for the data governance requirements and standards.
• Plan and define criteria and make go/no go decisions from a quality perspective.
• Involved in test planning, ensuring testing covers all integration points.
• Monitor ongoing data quality and troubleshoot complex data quality problems.
• Define parameters for data integrity and compliance by performing data cleansing, data audit and/or data validation.
• Provide Technical Support on Data Warehouse teams and experienced using data quality service (DQS).
• Design, Development and administration of Transactional and analytical data structures and delivery technologies.
• Recommend methods to strengthen data integrity, quality and availability of information for the business, while tying back to enterprise-wide expectations.
• Communicate quality metrics, issues and resolution to business clients, serve as a primary data expert on underlying business rules and data source.

Environment: Teradata SQL Assistant, MSSQLServer, SQL Developer, Advance Query Tool, MSTR, MS outlook, Quality Center, Windows 7 and Microsoft Word, Excel.