• 9 years experience in rendering IT services and experience in ETL methodologies worked in all the phases of the Data Warehousing life cycle for Data Warehouses and Data Marts. Worked with various customers to understand and translate business use cases and/or requirements into data models and serve as an expert resource on matters of data architecture to business and IT resources in all phases of data warehouse and data mart development, implementation and support.
• Extensive knowledge with Teradata Load Utilities, Fast Export, Fast Load, Multiload, BTEQ, and Tpump. Coded complex scripts for the Teradata Utilities and fine-tuned the queries to enhance performance.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing technical specifications and other helpful ETL documents following respective client's standards.
• Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
• In-depth expertise in the TeraData cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations PI/USI/NUSI/JI etc etc.
• Performed tuning and optimization of complex SQL queries using TeraData Explain. Created several custom tables, views and macros to support reporting and analytic requirements. Involved in the collection of statistics on important tables to have better plan from TeraData Optimizer.
• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Involved in troubleshooting the production issues and providing production support.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the BTEQ scripts.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
• Involved in Requirements gathering/analysis, Design, Development, Testing and Production Roll outs of Reporting and Analysis Projects.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Expert level experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center/7.x/8.x/9.x. Knowledge of Informatica tools Power Exchange, PowerCenter, DataAnalyzer and MetaData Manager.
• Experience in Informatica Power Center Client tools and Server Administration Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Performed Teradata SQL troubleshooting and fine-tuning of scripts given by Analysts and developers.
• Well versed with understanding of Explain Plans and confidence levels. Very good understanding of Database Skew.
• Good experience on multiple Operating Systems Windows NT/2000/9x, UNIX, AIX
• Experience in scheduling and running jobs using control-M
• Skilled in creating custom transformations, functions and routines.
• Good experience on multiple Operating Systems Windows NT/2000/9x, UNIX, AIX
• Experience in scheduling and running jobs using control-M
• Worked extensively on different stages like Transformer, Aggregator, Merge, Join, Copy, Lookup, Lookup File set, Filter, Change Capture, Oracle Enterprise, Column Generator, Dataset stages for Data cleansing and Data Transformation.
• Expertise in handling Data sources like Teradata, Oracle, DB2 UDB
• Skilled in creating custom transformations, functions and routines.

Technical Skills:

Professional Experience:

Confidential

DW Architect

• This position is responsible for the business analyses, data analysis, and design and solution architecture for DW applications.
• Participated in discussions of creating conceptual, logical and physical database models as well as process and data lineage diagrams.
• Conducted user interviews, gathered requirements, and analyzed the requirements by using Rally.
• Conducted User stories grooming sessions.
• Composed Business requirements document for Application design, and High level Design document based on customer requirements
• Introduced Tableau to my team to produce appealing data visualizations to clients and to help them make effective business decisions
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Ensured design meets the requirements.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Sourced data analysis / profiling where necessary to support ETL design.
• Documented Functional Specifications, Design Specifications documents and created ETL Specifications documents for various transformations built using Informatica Power Center tools - Designer
• Provided continuous relationship among business and technical teams
• Expertise in using Visual Explain, Index wizard, Statistics wizard to tune the bad queries and analyze the plans implement the recommendations to gain the performance.
• Teradata performance tuning via Explain, PPI, AJI, Indices, collect statistics or rewriting of the code.
• Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart
• Developed scripts to load high volume data into empty tables using Fast Load utility.
• Writing SQL queries and matching the data with database and reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Used Fast Export utility to extract large volumes of data at high speed from Teradata warehouse.
• Performance tuning for TERADATA SQL statements using huge volume of data.
• Created Fast Load, Fast Export, Multi Load, TPUMP, and BTEQ to load data from Oracle database and Flat files to primary data warehouse.
• Wrote transformations for data conversions into required form based on the client requirement using Teradata ETL processes.
• Experience in preparing documentation such as High level design, System requirement document, and Technical Specification document etc.,
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases. Tuning the queries to improve the performance of the report refresh time.
• Involved in performance tuning on the source and target database for querying and data loading.

Confidential

DW/BI Consultant

Responsibilities:

• Created database objects like Tables also global/volatile , macros, views, and procedures.
• Involved in determining the UPI, NUPI, USI, and NUSI for the data application layer tables as part of tuning the high CPU impact queries.
• Created System Interface Agreement SIA between source system and target systems, which has the escalation procedures in case of issues and SLA.
• Designed ETLspecifications with transformation rules using ETL best practices for good performance, maintainability of the code and efficient restart ability.
• Created multiple visualizations like HeatMaps, BarGraphs, BulletGraphs.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Defined best practices for Tableau report development.
• Extensively used data blending, embed functionalities in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant Query man front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Worked on Space considerations and managed Perm, Spool and Temp Spaces
• Worked as a team with database administrators to determine indexes, statistics, and performed table partitioning the data warehouse, in order to improve performance for end-users.
• Worked with backup team in setting up Optimal Backup strategies Worked as a single point of contact for all Backup issue and monitoring. Involved in scheduling
• Use SQL to query the databases and do as much crunching as possible in Teradata, using very Complicated SQL Query optimization explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc. to achieve better performance.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases. Tuning the queries to improve the performance of the report refresh time.
• Involved in performance tuning on the source and target database for querying and data loading.
• Developed MLoad scripts and shell scripts to move data from source systems to staging and from staging to Data warehouse in batch processing mode.
• Exported data from Teradata database using Teradata Fast Export.
• Creating, loading and materializing views to extend the usability of data.
• Automated Unix shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency
• Making modifications as required for reporting process by understanding the existing data model and involved in retrieving data from relational databases.
• Defined Functional Test Cases, documented, executed test script in Facets system.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Understanding the specification and analyzed data according to client requirement.
• Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad, MultiLoad.
• Involved in working with SSA requestor responsibilities which will be assigned for both project and support requests.
• Managing queries by creating, deleting, modifying, and viewing, enabling and disabling rules.
• Loading the data into the warehouse from different flat files.
• Database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.

Confidential

DW Consultant

Responsibilities:

• Interviewed Business Users to gather Requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
• Gathered requirements and modeled the data warehouse and the underlying transactional databas
• Conducted extensive requirement analysis using Rational requisite pro
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Re-write most complex queries from Oracle to Teradata and Performance tuning enhancement tasks and helped meet SLP
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Created Functional Spec Technical Spec documentation also documented the issues found in the end-to-end testing.
• Defined best practices for Tableau report development.
• Involved in creating dashboards and reports in Tableau 6.1
• Created report schedules on Tableau server
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Created and assisted users in Tableau dashboard development
• Defined and created procedures to install Tableau desktop in silent mode.
• Assisted testing team by creating SQL Queries for data testing.
• Developed shell scripts for invoking Teradata Data utilities to load DW tables
• Performance Tuning Worked on TD performance enhancement projects by identifying the potential set of columns based on the data demographics, collecting stats and changing the SQL to use Primary and Secondary indexes in queries and TD load scripts.
• Extensively worked on PMON/Viewpoint for TeraData to look at performance Monitoring and performance tuning
• Optimization of Queries in a Teradata database environment
• Performed DBA tasks on Teradata Data Warehouse using indexing, table partitioning, and Collect Statistics to enhance performance of Systems.
• Performed Capacity Planning with inputs from Application owners.
• Implemented Dual Active systems for mission critical applications, and ensured availability of system for the same.
• Strong experience with performing installations, upgrades, patches, system trouble shooting and optimizations
• Implementation of TASM for performance Tuning and Workload Management
• Usage of analyst tools like TSET, INDEX WIZARD, STATS WIZARD to improve performance
• Was part of 24/7 production support team
• Interacted with business users, MSI reporting team to resolve data issues.
• ETL - Used TD utilities like Fast Load, Multi Load, Fast Export and BTEQ extensively and conversant with diagnosing and fixing load related issues.

Confidential

Retail Data warehouse Designer/ Analyst

Responsibilities:

• Worked closely with Business end-users and developers for detailed understanding of the opportunities for improvements of systems in order to gather Requirements and prepare a comprehensive set of documents to define the specifications and business value of the system.
• Verified the current state documents by the Business and IT group in the respective meetings.

• Analyzed IT and Process Gaps on the identified Current state for all channels and transactions.

• Identified Metrics for Future state opportunities/Recommendations.

• Developed technical specifications and other helpful ETL documents.
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Responsible for creating new views as per the requirements. Gathered and defined business rules which allowed for the accurate processing of corporate actions.
• Created tables, views in Teradata, according to the requirements.
• Created staging Tables, Indexes, Sequences, Views and performance tuning.
• Collected stats every week on the tables to improve performance.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Considering both the business requirements and the factors to create NUSI, created appropriate NUSI for smooth fast and easy access of data.
• Performed bulk data load from multiple data source ORACLE 8i, legacy systems to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• Used BTEQ and SQL Assistant Query man front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart Developed scripts to load high volume data into empty tables using FastLoad utility.
• Used Fast Export utility to extract large volumes of data at high speed from Teradata RDBMS.
• Performance tuning for TERADATA SQL statements using Teradata EXPLAIN command.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
• Documented the business process through Business Requirement Document and Functional Requirement Specification Document

Confidential

Teradata DW Consultant

Responsibilities:

• Developed shell scripts to perform ETL activities.
• Built load scripts on UNIX for FastLoad, MultiLoad, BTEQ to load data from UNIX flat files to TD staging and target tables.
• Developing technical specifications and other helpful ETL documents following CME Group's standards.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Modified System flow diagrams using SDLC.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.
• Reverse-engineer several databases, such as research, business, and clinical in order to extract metadata to leverage it for ETL design and reporting.
• Designed the universes by creating the Business Objects data model.
• Involved in unit testing, system testing and integration testing.
• Involved in tuning initiatives and achieved efficiencies in load process.
• Performed high level data validations using sql assistant to resolve defects.
• Troubleshooted errors/issues with Production reports. Used Oracle and Teradata database stages extensively in the DW development, instrumental in achieving significant performance milestones
• Participated in team meetings, status meetings.
• Used ctrl-m scheduling tool extensively.
• Used Mercury Quality Center to resolve and create tickets on data load errors

Confidential

Systems Analyst - Teradata

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Used Teradata Sql to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Involved in the analysis and implementation of their system.
• Granted Revoked Object Rights, System Rights on Databases / Users / Roles.
• Performed bulk data load from multiple data source ORACLE 8i, legacy systems to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
• Used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer, WorkFlow Manager, Workflow Monitor.
• Performed Space Management for Perm Spool Space.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Collected statistics every week on the tables to improve performance.
• Developed unit test plans and involved in system testing.
• Conducted extensive Joint Application Development JAD sessions for all business related issues.
• Managed Scope and change throughout the SDLC process of the product.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program. Used Micro strategy dashboards for data analysis and custom reports.
• Developed test plans with QA team and helped test every scenario using Mercury Test Director Tool for system testing
• Participated in the support of BI applications with IT applications and technical staff.
• Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.

Confidential

Database Specialist

Responsibilities:

• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Involved heavily in writing complex SQL queries based on the given requirements.
• Involved in developing Multi load, Fast Load and BTEQ scripts.
• Created and automate the process of freight and shrink loading process using Shell Script, Multi load, Teradata volatile tables and complex SQL statements.
• Created a generic email notification program in UNIX that sends the emails to the production support team if there are any duplicate records or error in load process.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant Query man front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Created a BTEQ script for pre population of the worktables prior to the main load process.
• Used FastLoad for loading into the empty tables.
• Utilized Teradata Explain for the various performance issues in the databases
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Created an archive process that archives the data files and FTP to the remote server.
• Created a Clean up process for removing all the Intermediate temp files that were used prior to the loading process.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Involved in troubleshooting the production issues and providing production support.
• Streamlined the Teradata scripts and shell scripts migration process on the UNIX box

Confidential

Technical Support Engineer

Responsibilities:

• Troubleshooting networking and hardware issues.
• Served as the Subject Matter Expert SME within the second level Tier2 technical support team.
• Carried out expert level diagnostic investigation for highly-complex issues or issues with substantial service impact and collaborated with peer support teams to generate a support plan to resolve the issue in the shortest timeframe possible.
• Required support was performed over a wide array of platforms in the Network including, but not limited to VOIP, Database, networking or Services equipment.
• Primary interface between Vonage and the user and, as such, requires the engineer to manage day-to-day compliance to the support service level agreements.
• Technical troubleshooting and leadership skills throughout the Tier2 organization.
• Ensured that performance goals are maintained across the team.
• Developed and delivered training programs and documentation to other departments on new operation, maintenance and troubleshooting procedures.
• Produced technical bulletins in order to provide short-term work-around solutions and guidance on current Network issues. This required some out of box thinking and analysis of software problems within the network. Provided mentoring to others within the position's team or customers' team.