PROFESSIONAL SUMMARY:

• 9 years and 2 months of professional experience in Data Warehousing as a Data Analyst,Senior Teradata Developer and ETL Developer.
• Responsible for driving the delivery of data integration capabilities for Cisco projects, providing solutions and architectural guidelines for various functions in Confidential data warehouse.
• Currently working as Onsite Lead, Teradata/ETL Data Analyst and Senior Developer.
• Proven track record in planning, building, and managing successful large - scale data warehouse (size of 40-tera bytes) and decision support systems.
• Hands-on-Experience in preparing High-Level & Low-Level Design Specs, Source system analysis, performance tuning, System Integration, Unit Test Cases, Deployment docs etc.
• Expert in the field of design, development, and implementation of processes for Data Warehousing and Data Integration projects using Teradata, Informatica and UNIX.
• Excellent implementation of data warehouse/data marts using various data warehouse concepts and principles like Change Data Capture, Slowly Changing Dimensions, Normalization/Denormalization (Star and snow-flake Schema Modeling). 
• Worked on Slowly Changing Dimensions (SCD) Type 1, 2 and 3 to keep track of historical data. 
• Worked extensively on Teradata utilities - BTEQ, Fast Export, Fast Load, Multi Load and TPUMP.
• In-depth Knowledge on Data Warehousing concepts, E-R model and Dimensional modeling (3NF) like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Extensively used various Performance Tuning techniques to improve the session performance in Infromatica. 
• Working as Data Analyst and conducted research to collect and assemble data for databases - was responsible for design/development of relational databases for collecting data. 
• Experienced in different Project Management Methodologies like Traditional waterfall and Agile. 
• Responsible for implementing all of the technical Data Warehousing solutions to the client, in accordance with an agreed technical design. 
• Designed ETL architecture, created data flow diagrams, process flow diagrams, and high level ETL design. 
• Provide technical support and input on the application of technology to a defined business segment.
• Strong hands on experience in Designing ETL jobs in Informatica (Power Center, Designer, Manager, Monitor and Repository).
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Proficient in Performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, and
• Optimization Collect Stats.
•  Experience in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings and Shortcuts. 
• Extracted data from various source systems like Oracle and flat files as per the requirements.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• Data reconciliation activities between EDW Oracle and EDW Teradata Database
• Experienced in developing OLAP reports using   Business Objects.
• Contributes to knowledge tools and communities, and ensures project learning's are documented and shared.
• Ability to work independently and as a team Lead and able to effectively communicate with customers, peers and management at all levels in and outside the organization.

TECHNICAL SKILLS:

Operating Systems: MS DOS, UNIX, Windows

Programming Languages: SQL, Shell Scripting

Databases: Teradata (V2R5/R6/R12/R13/R14), Oracle

Teradata tools & Utilities query facilities: SQL Assistant, BTEQ, Fast Load, Multi Load, Fast Export, T Pump, TPT

ETL Tools: Informatica 9.1, 9.5, 9.8

Defect Tracking Tools: HPQC

CISCO tools: Golden Gate, Dollar U, Kintana, PVCS, SRM

Reporting Tools: Business Objects Xi, 6.5 and 6.1

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Senior Data Analyst/ Data Modeler/Sr. Teradata & ETL Designer

• As a data Analyst, gathering the requirement from the business, analyzing the data staged from the Source and profiling the data, giving feedback to the business based on the data profiling if there is any discrepancies in correctness of the data.
• Completely responsible in creating the Technical Specification documents from the BRD’s.
• Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the EDW Teradata using Teradata Parallel Transporter and standalone Utilities.
• Worked on the ER Studio modeling tool for creation of logical and physical models - 3 NF.
• Designed and developed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.
• Designed, developed and documented the ETL processes using Informatica for extracting the data and data transformations.
• Created mappings and applied transformations on the tables and created sessions for running the processes in Informatica.
• Extracted data from various source systems like Oracle and flat files as per the requirements and loading into EDW Tables.
• Build the Bteqs to load dimensions and Facts in the Semantic Layer.
• Building Physical Data Model based on inputs from Logical Models.
• Performed Data Profiling and analyzing the data in EDW to define proper indexes .
• Involved in estimating the space in database that will needed for tables.
• Building Semantic Model based on reporting requirements and maintaining all the artifacts related to data model.
• Extensively worked on Teradata performance optimization by using various Teradata optimization strategies and increased the query throughput.
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies and hash distribution methods.
• Conducted statistical analysis as and when required and provided summaries of analysis.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Created complex stored procedures, views, SQL joins and scripts for applications.
• Involved in daily scrum meetings for agile methodology projects.
• Involved in extensive   DATA validation   using   SQL queries   and back-end testing.
• Played a key role in Unit Acceptance Testing along with Business Users.
• Lead the Offshore team and completely responsible in the PROD GO LIVE activities.
• Handover the Deployment Guide and SRD documents to the System Testing and provide the complete background of the project.
• Worked with several marketing managers and project manager to gather financial data and requirements and build reports using Teradata SQL.
• Perform the post deployment validations.
• Analyze and optimize the performance of the long running jobs- both Teradata and Informatica.
• Written several SQL scripts for large data pulls and ad hoc reports for analysis.

Confidential

Sr. Teradata & ETL Developer

Responsibilities:

• Translating business requirements into technical specifications and impact assessments to enhance the existing production functionality
• Created, modified and tuned complex Informatica mappings to load the Fiscal Datamart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator etc.
• Created partitions at Informatica session level to improve the performance of Informatica workflows.
• Modify and tune complex Informatica mappings to load the Marketing and RAMBO data marts.
• Involved in data analysis from different source systems.
• Responsible for designing ETL strategy for both Initial and Incremental loads. 
• Involved in the performance tuning of Informatica mappings/sessions for large data files by increasing block size, data cache size, and commit interval.
• Loading data from various data sources and legacy systems into Teradata using Teradata Utilities and Informatica.
• Building Semantic Model based on reporting requirements and maintaining all the artifacts related to data model.
• Written a UNIX script which checks the availability of the data in oracle tables and triggers the workflow which populates the Landing Area tables in Teradata.
• Created Source to Staging, Staging to Target mapping documents and jobs to load the data from oracle to Teradata target area with Business Rules applied along with SCD Type - 2 Implementation.
• Development of Complex SQL Queries using UDF’s and SP’s.
• Migrated the loading scripts into Validation and Production Environment using PVCS version control tool and scheduled the batch scripts with the help Dollar U.
• End to End testing and data validations.
• Worked with QC and Prod Support teams and bug fix and followed-up with QC-Tickets.
• Have developed kintana packages to Migrate the code from one environment to another environment
• Responsible for Data quality to make sure there is no gap with existing source system.

Confidential

Teradata and BO Objects

• Working on Process Improvements and enhancing the system performance through Performance tuning activities.
• Monitoring the Production system using the View Point tool.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and Tpump). 
• Query Tuning: Tuning the high CPU consumed Queries to decrease the SUM CPU and IMPACT CPU.
• Build Views using Teradata SQL for reporting the requirements
• Worked on the Collect Stats Remediation.
• Reduced Teradata space used by optimizing tables - adding compression where appropriate and ensuring optimum column definitions. 
• Maintenance activities which includes debugging the defects in the applications and analyzing data quality issues integrated with business rules
• Worked on the Data Remediation activities.
• Converted batch jobs with BULKLOAD utility to TPUMP utility.
• Modified/created the Business Objects Universes based on the reporting requirements Of the end users.
• The data was represented in the form of dimensions, details and measures for usage in Universes and documents and filtered according to the business need.
• Reviewing all the Universes, Reports and design documents and deliver the same with in time lines.

Confidential

Teradata Developer

• Analysis of the specifications provided by the clients.
• Wrote appropriate code in the conversions as per the Business Logic using BTEQ scripts. 
• Analyzed the existing programs for Bug Fixing and Enhancements.
• Creation of Tables and Views in Teradata.
• Developing MTD and YTD reports using MTD and YTD objects created in the Business Objects Universe.
• Participated in the System Testing, User Acceptance Testing and Migration Process.
• Generated Ad-Hoc reports for the users.
• Scheduling the jobs using the Scheduling tool.
• Preparation of Unit Test Case, Functional spec documents.