SUMMARY

• Teradata Architect, Administrator and Developer with 20+ years of hands on experience with all aspects of Teradata
• Participated in daily scrum meetings, sprint demo sessions, deployment planning to continue improving the agile process in meeting client’s business requirements on time.
• Created and maintained Erwin Logical and Physical data model for Teradata data warehouse for many companies.
• 10+ years of experience with third party ETL tools like Informatica Power Center and Sagent
• 15+ years of experience with native ETL tools of Oracle, SQL Server, Teradata like spooling files, SQL Loader, BCP, Bulk Load, Fast load, BTEQ, Multi load, and TPT
• Outstanding familiarity with all Teradata tools and utilities for ETL and OLAP application development
• An adept in writing SQL code and PL/SQL. I am more interested in most complex and challenging queries and analyzing and solving them into easy workable solutions.
• Well versed in creating Stored Procedures using PL SQL in Teradata and Oracle
• An expert in analysis, development, testing, and implementation of solutions on time for Teradata Marts or Teradata data warehouses.
• A fast learner of new facts and a keen lover of data who works well in all settings, both independently and as a contributing team member
• Excellent organizational, planning, interpersonal, communication and math skills
• More than 7 years experience with job scheduling tools like UC4 (Automic)
• Used Jira, Git Hub for code review and version control

TECHNICAL SKILLS

Database: Teradata V2R5, V2R6, V2R12, V2R13, V2R15, V2R16 Oracle 11g

RDBMS: Microsoft SQL Server 2005, 2008, 2008 R2

Teradata & Other Utilities: Teradata View Point, SQL Assistant, BTEQ, Fastload, Multiload, Teradata Parallel TransportSagent, BCP, Bulkload, SQLLoader

ETL: Informatica 9.1 Power Center, Teradata ETL tools, Shell scripts

OLAP: Microstrategy, Cognos

Languages: SQL, PL/SQL (Oracle & Teradata)

Other: Shell scripts, ERWIN r9.7, ER/Studio, Unix, Automic

Platforms: Windows 2005, Windows 2008, Linux, UNIX (MP RAS)

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale CA

Teradata Tech Lead / Senior Data Engineer

Responsibilities:

• Worked as Senior Data Engineer for Confidential e - commerce Finance Team.
• Responsible for Requirements gathering, Architectural Design, Development, Testing, and deployment of Confidential E-commerce Finance Datamart Global data requests using Google Big Query, Teradata Environments.
• Worked with Business Users, SMEs, Global team architects, Source application team members to analyze and design to solve issues and problems.
• Worked on online orders for General Merchandise through the life cycle of the orders till they are financially settled to account for Financial Reporting and Controllership.
• Responsible for enhancing and maintaining the Erwin Logical & Physical Data model for Confidential Ecommerce for Finance for Hadoop Datalake & Teradata systems.
• Worked on performance tuning of queries that ran slow or took up more resources to make them more efficient and get the output in seconds
• Worked on the preliminary planning and development of migration of Finance Data mart from Teradata to Google Cloud
• Converted Several Teradata Scripts into Google Cloud Platform using Big Query.
• Worked on scheduling Tool UC4 Automic to run daily, monthly jobs to enable continuous load of source Oracle OMS system to Teradata and from Teradata to Hive and external reporting systems and currently into GCP.
• Worked on building ETL Pipelines to get the real time data using Kafka messages.
• Created Financial reports and created schedules and executed them on Teradata Platform.
• Used Jira and GitHub for code review

Confidential, Sunnyvale CA

Teradata Developer

Responsibilities:

• Joined the Confidential Consultancy Services as a full time employee to work for Confidential Inc. at Sunnyvale, CA
• Developed Teradata stored procedures to load sales data into Teradata data warehouse.
• Developed a semantic layer in Teradata to provide daily, hourly, weekly and quarterly reports of Confidential products supply chain for Asia Pacific

Confidential, Sunnyvale CA

Teradata Tech Lead / Senior SQL Specialist

Responsibilities:

• Performed as the lead developer for the finance department of Confidential .com for online orders of general merchandise and online grocery data
• Maintained the data model for Finance Mart In Teradata data warehouse.
• Enhanced the data model to accommodate the data structure changes for the acquisitions of Confidential like JET, Hay needle, Shoesby.com etc.
• Worked with in-house framework developers for ETL to use the features of Fast load, Multi load and TPump so that ETL framework was user friendly for developers.
• Developed Teradata ETL scripts using framework and loaded Teradata data warehouse for Finance mart
• Worked with UC4 known as Automic to create jobs, workflows and schedules using the arrangement of the ETL scripts in sequence and parallel to carry out the execution of daily ETL jobs that loads Teradata tables
• Created ETL scripts for loading real time data through kafka into Hadoop and finally landing in Teradata.
• Created mappings and workflows using Informatica to load data from Oracle to Teradata.

Confidential, San Ramon CA

Senior Teradata Consultant

Responsibilities:

• Developed mappings and workflows using informatica to load data from oracle sources and SQL server sources to Teradata
• Modified complex mappings in Informatica and converted them to use the power of Teradata by using SQL over-ride at aggregate level.
• Carried out data quality tests on the data populated by informatica by checking the data integrity and accuracy and performed data cleansing process as needed.
• Maintained standards and best practices as suggested by the client environment as well as informatica and Teradata.
• Created stored procedures in Teradata and called them through the informatica stored procedure transformations to carry out multiple tasks in one place and also maintain the synchrony of the data.
• For complex reports I had created SQL with windows analytic functions and called them through the informatica mappings. This made the execution faster and result set captured sooner.
• Created the enterprise data warehouse consisting of the electrical usage data for business analysis.
• Replaced the Oracle data warehouse with a Teradata enterprise data warehouse
• Planned on building the business analysis for gas usage in Teradata data warehouse for the future. Preliminary work on this were done.