SUMMARY

• Over 8 plus years of IT experience in data migration, data warehousing database design, Analysis and Maintenance projects.
• Extensiveexperience in database design for data warehouses with strong understanding of Dimensional Modeling, Star and SnowflakeSchemas combined with data staging, database design, datawarehouse requirement analysis and Implementation.
• Experience in planning, architectural design and optimization ofTeradatadata warehousing.
• Hands on Experience in ETL, OLAP, Data Analysis, Design, Development, Implementation, Testing and trouble shooting of Business Intelligence, Data Warehousing, and Database applications.
• Very good understanding of Teradata MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes etc. Extensively used different features of Teradata such as Fast Load, Multi Load, BTEQ scripting, Fast Export and SQL Assistant.
• Extensive Experience in ETL/ELTmethodologyas well as architecturefor supporting data extraction, transformation and loading process, in a corporate - wide-ETL Solution.
• Extensive experience in Business Analysis, Data Analysis & clarification of requirements with SME (SubjectMatter Expert). Created documentation of Business process and implemented the same.
• Extensively worked on designing Business views & writing SQL queries in Teradata catering specific business requirement to generate data.
• Experienced in 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.
• Well versed with Teradata Analyst Pack including Statistics Wizard, Index Wizard and Visual Explain.
• Developed UNIX shell scripts and used BTEQ, Fast Load, Multi Load, and Fast Export utilities extensively to load to target database.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the BTEQ scripts.
• Experience in integration of various data sources with Multiple Relational Databases like Teradata, Oracle, and SQLServer.
• Proficient using in RDBMS like Oracle, SQL Server, Teradata, PL/SQL, SQL *PLUS, SQL *Loader and TOAD.
• ExperienceinInformatica(versions9.5), Mappings,Transformations,WorkflowManager, Workflow MonitorandRepositoryManager.
• Excellent communication at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.
• Worked on the Global Delivery Model (Onsite - Offshore) with proven Customer People Management skills.
• Ability to workin-groups as well as independently with minimumsupervision and initiative to learn new technologies and tools quickly.
• Self-motivated, Result oriented approach for task completion and desire to accomplish everything with perfectionand within the stipulated timeframe.

TECHNICAL SKILLS

Operating Systems: Windows XP, 2000, UNIX/Linux

Database: Teradata 14/13, V2R5/V2R6.0, Oracle (8i/9i/10g), SQL Server 2000

Teradata tools & Utilities query facilities: SQL Assistant, BTEQ

Load & Export: Fast Load, Multi Load, Fast Export, BTEQ, Oracle SQL Loader

ETL: Informatica (8,9)

Languages: C, C++, Visual Basic

Scripting languages: UNIX Shell, Perl

Replication Tool: Golden Gate, Data Mover

Others: Business Objects 6.5,OBIEE, Kintana, Quality Center, Defect Tracker

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Senior Teradata Lead Developer/Technical Analyst

Responsibilities:

• Recommend and Implement best practices in Teradata.
• Writing Teradata SQL queries to join or any modifications in the table.
• Tuned the existing SQL and achieved increased performance for faster user query performance.
• Created and Modified Indexes, PPI, Statistics, Character Sets, Materialized tables etc.
• Created proper PI taking into consideration both planned access and even distribution of data across all the available AMPS.
• Acted as a single resource with sole responsibility of Teradata.
• Requirement gathering of VMI report (Sears and Kohl’s) from Users.
• Worked with ETL and Business Object resources to implement the end-to-end change.
• Involved in Unit Testing and Preparing test cases and also involved in Peer Reviews.
• Used Teradata Viewpoint to monitor the warehouse's Teradata infrastructure and report out to management root cause analysis or suggest workarounds for production incidents that occur.
• Used 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 and USI and NUSI and JI etc) etc.
• Involved in production deployment and post deployment support.
• Developed UNIX scripts to load materialized tables in ETL.
• Track performance of report on daily basis.
• Keep track of the VMI report for Sears and Kohl

Confidential, San Jose, CA

Senior Teradata Lead Developer-ETL

Responsibilities:

• Designed, developed, tested, enhanced and maintained Teradata based Enterprise DataWarehouse, using Teradata, Teradata SQL, Teradata ETL utilities, Informatica, UNIX and Teradata Analytical functions.
• Designed, developed, tested, optimize and maintained processes that involve acquisition/extraction, transformation and loading (ETL/ELT) of Tera-byte volumes of data.
• Worked with Datawarehouse Architects on LDM/PDM for ongoing projects.
• Coordinated with business owners to gather requirements and analyzingdata regarding current functionality and operational adequacy of existing EDW to determine recommend and develop various modifications.
• Worked in a DBA team to ensure implementation of the databases for the physical data models intended for the data marts. Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Helped Business Users by writing Complex efficient Teradata SQLs to get a detailed for Data Mining.
• Performance Tuning ETLs as well as reporting queries on Teradata EDW in Cisco, which are run through various,subscribing business applications.
• Developed UNIX shell scripts and used BTEQ, FastLoad, Multiload, and Fast Export utilities extensively to load to target database.
• Employed good design methodologies to design, enhance, improve or otherwise develop systems throughout project life cycle in accordance with corporate and/or client functional needs, requirements, quality controlparameters and standard operating procedures
• Data modeling for new subscriptions and applications as per need basis.
• Worked on Audits implementation for meeting SOX requirements in the system.
• Capacity Monitoring on the Production system with generation of Daily and Weekly reports.
• Analysis and forecasting the performance activities.
• Development and Tuning of ETL processes in Informatica and Teradata for various Data Marts.
• Interacted with various Business teams for new subscriptions on Teradata EDW and supporting theCosting evaluation.
• Created UNIX Scripts to manipulate and Load the data.
• Interacted with the DBA team and Teradata GSC team on various issues representing Cisco EDW.
• Did Project Management activities as per the Client requirements by representing the team in various forums within the Organization as well as allocating tasks to the offshore lead and periodically assessing the task progressand conforming the same within the stipulated timelines.
• Worked on the Global Delivery Model (Onsite - Offshore) for Production Support team.
• Provided 24X7 support to the database activities in case of any errors or issues.

Confidential, San Jose, CA

Replication Solution Analyst/ Teradata Lead Developer

Responsibilities:

• Designed, developed, tested and maintained disasterrecoverysystem forTeradata based Enterprise DataWarehouse using replication tools like Golden Gate and Data Mover.
• Created Golden Gate parameter files to replicate the data to target database.
• Performed data volume analysis to ensure 100% data replication.
• Optimized SQL query to improve the performance of replication of Tera-byte volumes of data.
• Provided replication solution defects resolution ideas/fix to Production support team.
• Interacted with the Golden Gate platform team on various replication solution issues.
• Worked on Audits implementation for disaster recovery system.
• Worked with business users for gathering and developing latency dashboard for disaster recovery system.
• Worked on the Global Delivery Model (Onsite - Offshore) for Architecture Team.
• Monitor progress in all cross-functional areas according to milestones and schedules.
• Interacted with technical and business analyst, operation analyst to resolve data issues.
• Worked on complex queries to map the data as per the requirements.
• Performed load-balancing analysis to move applicationto replication system.

Confidential, San Jose, CA

Teradata Developer

Responsibilities:

• Migration of Revenue related tables from Oracle to Teradata
• Understanding the business processes of Cisco and Requirement analysis.
• Coordination with Business owners to gather Requirements
• Facilitating Business Owners in Decision making by Data Analysis and Data Profiling
• Helping offshore development teams in Requirements understanding and development
• Assisting in Modeling to in corporate new requirements.
• Created Informatica mappings/workflows and tuned the same for performance by implementation of Push Down
• Optimization and strategic placement of collect stats.
• Designed and developed time-bound Informatica processes
• Writing the Unix and BTEQ scripts for implementation of the History Fix.
• Creation of BTEQ, Fast export, MultiLoad, TPump, Fast load scripts.
• Used Data profiler to allow the analysis of data directly in the database, which improves performance, while eliminating the time and costs of moving data among databases.
• Performance tuned Teradata SQL queries by using query plan and creating indexes to minimize query execution times.
• Assisting the QA team in Testing and Dev to QA migration of History and Ongoing code. Also assisted the QAteam to get the Business and IT signoff for my stream.
• Creation of BO Universe for Teradata environment.
• Creating BO reports in Development environment and testing it in TEST environment.
• Created, updated and maintained ETL technical documentation.
• Working on the Global Delivery Model (Onsite - Offshore) for Architecture Team.
• Assisting the Production Control team during PROD turnover and providing warranty support for any production issues that may arise
• Assisting the Business Teams to generate reports and meet the requirements.

Confidential

Software Engineer

Responsibilities:

• Informatica Power Center was used to extract data from various sources like flat files, excel files to load into the OracleData warehouse.
• Created,updated and maintained ETL technical documentation.
• Developing PL/SQL queries and objects using Oracle 8i
• Developed test cases and performing a check on test cases list.
• Development of Informatica mappings, sessions and workflows.
• Created BO Universe for Oracle environment.
• Created BO reports in Development environment and testing it in TEST environment.
• Developed Unix script to load the data into Target database.
• Coordinated with Onsite lead to gather Requirements.