SUMMARY

• 7 years of experience in various phases like Data Analysis, validation, Extraction, Transformation and concepts of SDLC, Loading and reporting using TERADATA (V2R5, V2R6, V12), Unica Affinium campaign, Business Objects and Tableau.
• 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.
• Experience in maintaining and developing large financial reports.
• Experience in Banking, Credit Card, Mortgage, Pharmacy business processes.
• Strong ability with standard, non - specialist software tools such as Excel, PowerPoint, Word and good working knowledge of SQL.
• Perform Grant, Revoke table accesses to Database Analysts, Business Analyst, Operational Analysts and Project Manager.
• Experience in Developing Webi, Deski, Crystal, Webi Rich Client and Xcelsius Dashboards.
• Created reports using Business Objects functionalities like Queries, Graphs, Charts, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, etc.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters and developed Tableau visualizations and dashboards using Tableau Desktop.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Experience in designing/building the Universes and assigning user privileges.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• 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.
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring
• Experience in Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
• Extensively Used Access VBA and Excel VBA to efficiently perform reporting tasks.
• Experience in preparing Business reports using Teradata SQL and BTEQ.
• Developed SQL, Stored Procedures, Views, Indexes and Constraints, Query Optimizer.
• Well experience in using Teradata Sql Assistant and Toad Sql.
• Created numerous Teradata BTEQ, MLOAD, FLOAD, and PLSQL scripts.
• Handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Performing Adhoc reports using Oracle, Teradata, Bteq, and UNIX.
• Experience in working on Performance and Optimization of the SQL Queries.
• Hands on experience and proven practices of resolving performance issues at various (Applications, Database) Levels.
• Hands On experience creating, converting oracle scripts (Sql, Plsql) to Teradata scripts.
• Good experience in submission of batch jobs using Oracle and Teradata.
• Team player with ability to adapt to various environments with excellent communication and interpersonal skills.
• 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.

TECHNICAL SKILLS

RDBMS: TERADATA V2R3.0/V2R4.0/V2R4.0.1/V2R4.1, V2R5, Oracle 9i/8i

Database tools: SQL developer, TOAD,Teradata SQL Assitant

Languages: C, C++, SQL, PL/SQL, VBA, UNIX Shell scripting

OLAP Tools: Web Intelligence,Dashboards,Xcelsius,Tableau

GUI Skills: Affinium Campaign (V6.4, V7.2)

Job Function: Data Analysis, Data validation, Business Analysis, System Analysis and Design.

Operating Systems: MS-DOS, Windows 95/98/2000, Win XP, Win NT, UNIX

Web Technologies: CSS, HTML5, PHP, Java Script.

PROFESSIONAL EXPERIENCE

Confidential - Gaithersburg, MD

Data Analyst

Responsibilities:

• Responsible for gathering requirements from Business Analysts and identifying the data sources required for the requests.
• Involved in designing and testing of Webi reports and worked with large data and in the agile environment.
• Created Webi, Crystal Reports and Dashboards based on the END Users andBusinessrequirements and Modified the existing Reports based on the specifications and requirements.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data.
• Customized Universe level Prompts as per Functional Requirements.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created complex reports by linking data from multiple data providers and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Created Standard Reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, and Alerters etc.
• Created alerts and sub-alerts to show different ranges in values and applied drill down analysis for some reports and defined hierarchies.
• Created Breaks, Filters at different Levels of the reports and applied ranking in the Webi reports.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
• Extracted, Analyzed and Presented Data in a Graphical Format, such a way that helped project manager to make Business Decisions.
• Developed SAS Program for Converting Large volume of Text File into Teradata Tables by importing the text file from Mainframes to Desktop.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Used VBA Macro to create Weekly reports.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about the data.
• 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 Logistics and manufacturing departments using Teradata SQL.
• Extracted data from existing data source and performed ad-hoc queries.

Environment: Teradata, BTEQ, VBA, SAS, FLOAD MLOAD, UNIX, SQL, Windows XP, SAS, Business Objects.

Confidential - St.Louis, MO

SQL Functional 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 Sql tables using SAS Proc Import and Fast Load Techniques.
• Worked extensively with Tableau Business Intelligence tool to develop various dashboards.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel and SQL Developer.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Writing SQL scripts for huge data pulls and ad-hoc reports for analysis.
• Develop reports using the advanced techniques like rank, row number and etc.
• 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.
• 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: SQL Developer, UNIX Shell Scripts, SAS, MS Excel, MS Power Point,Tableau

Confidential - Phoenix, AZ

Unica Campaign Analyst

Responsibilities:

• Analyzed user requirements and developed, tested, and tuned various scripts, procedures, and database triggers to validate data.
• SQL scripts were developed for accessing data from the Teradata tables.
• Tuned the SQL queries for optimum performance.
• Developing and executing campaigns manually using Unica affinium campaigns.
• Performed the SEGMENTATION and analyzed using Unica affinium tool.
• Developed the welcome kits campaigns for the new members
• Created various channels of Phone, Email and Direct Mail campaigns
• Extracted data from various production databases using Teradata to meet Campaign data needs.
• Data loaded into Teradata from flat files using data stage dynamic sequence job with schema file concept.
• Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
• Created numerous Volatile, Global, Set, MultiSet tables.
• Used Inner, Outer Join, UNION, INTERSECT, CUBE, RANK, QUANTILE and OLAP functions CSUM, MSUM, MAVG, MDIFF.
• Extensively used data blending, embed functionalities in Tableau.
• Develop, Organize, manage and maintain graphs, tables, slides and develop document templates for the efficient creation of reports.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD.
• Used Basic Teradata Query utility for reporting Purpose.
• Developed Basic Teradata Query (BTEQ) for Interactive & batch queries.
• Used FLoad for loading, Mload for modifying database objects.
• Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, Ms Excel, VBA Macros
• Worked closely with different Marketing Groups in designing and analyzing the data.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Built the Operational data store by using BTEQ, Teradata, Oracle, SQL, PL/SQL, and UNIX.
• Used Proc SQL to connect to Teradata.

Environment: Teradata, Unica Affinium campaign,UNIX Shell Scripts, MS Excel, MS Power Point, Tableau.

Confidential - Charlotte, NC

Data Analyst

Responsibilities:

• Involved in gathering the requirements from Business users.
• Played a key role working closely with and supporting the Project manager and associates.
• Performed numerous huge data pulling requests using SQL Assistant.
• Created tables, views, database links to see the information extracted from SQL files.
• Extracted data from existing data source and performed ad-hoc queries using SQL.
• Extensively used Teradata Advanced Techniques in writing the scripts.
• Worked on tables (Like Set, Multiset, Derived, Volatile, Global Temporary), views, using SQL scripts
• Generated flat files using the Teradata Export for the Segmentation process.
• Proficient in Data Verification and Validations.
• Performed in depth analysis on data & prepared weekly, biweekly, monthly reports by using SQL and UNIX.
• Developed of Fast Load /Multiload scripts for loading purpose.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Specified the Joins and checked the cardinalities and Implemented User Objects in Reports and Created Condition in Universe.Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.
• Used@functions like @select, @where and @prompt function,createpromptswhich helps the user to select the values dynamically
• Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Involved in Performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Extensive use of Teradata Utilities (BTEQ, MLOAD, FASTLOAD, FASTEXPORT).
• Involved in query Performance Tuning for accessing the data fast.
• Provided data to Business analyst in graphical format using MS Office and Power Point Presentations.
• Experienced in exporting data into flat files in .csv, tab fixed delimiters and etc. formats.
• Developed new reports for the end-users and maintained current ones.
• Documentation of scripts, specifications and other processes.

Environment: Teradata, SQL Assistant, UNIX, MS Excel, PowerPoint, Business Objects.

Confidential

SQL Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Stored Proceedures, Functions, Triggers, Indexes and Views using T-SQLin all the environments forSQLServer 2000.
• Involved in loading the data from flat files, CSV files, MS Excel sheets into database.
• Developed DTS Packages to transfer the data betweenSQLServer and other database and files.
• Created report form with Stored Procedure using T-SQL.
• Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
• Created database objects like tables, views and indexes and modified stored procedures, triggers and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to requirement. and made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Developed, Modified, Tested and Debug the UNIX shell scripts, PL/SQLPackages, Materialized Views, Functions, Procedures and Triggers according to the requirements.
• Involved in the changing existingSQLQueries according to the new requirement.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
• DevelopedSQLqueries to fetch complex data from different tables in remote databases using database links.
• Created DDL scripts to create, alter, drop tables, views, synonyms and sequences.

Environment: MSSQLServer 2000/2005, MySQL, MS Access, MS Office Suite (Word, PowerPoint, Excel),Unix.