PROFESSIONAL SUMMARY:

• Overall 11 years of IT experience in Teradata, Enterprise Data Warehouse, ETL, SQL/UNIX
• Extensively worked on Architecture, Data Analysis, Design, Development, Implementation, Maintenance and Support on RDBMS Systems and Big Data Technologies
• Strong working experience in Financial, Healthcare, Entertainment Domains/Industries
• Experience in Design, Enhancement, and Development of applications for OLAP and DSS - Decision Support Systems using Dimension Modelling
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling
• Extensively worked on Teradata 15 and load and unload utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump & TPT
• Advanced and Strong working experience on SQL, Performance tuning and Query analysis
• Experience in building Data Marts, Data Structures, Data Storages, Data warehouses, Data Archives, and Data Analysis
• Extensively worked on processing large sets of Structured, Semi-structured and Unstructured data and supporting systems application architecture using Hadoop Hive, MapReduce and Sqoop
• Experience in Designing and Developing Informatica mappings from various transformation logics using filter, expression, rank, router, aggregator, joiner, lookup and update strategy
• Strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Extensive working experience in UNIX Shell scripting
• Strong working knowledge in Agile Project Management methodology
• Ability to coordinate the flow of development initiatives and experience in all phases of Testing - Unit testing, System Testing, Integration Testing, Regression testing, Performance and Acceptance testing
• Exceptional communication skills - Verbal and Written
• Good understanding of Project Management methodologies and SDLC
• Outstanding working relationship with the clients and as well effective communication with the management and within the team

TECHNICAL SKILLS:

Databases: - Teradata 15, 14, 13, V2R6, V2R5

Teradata Utilities: - MultiLoad, FastLoad, FastExport, BTEQ, TPT

ETL Tools: - Informatica PowerCenter 8.1, ERWIN

Scripting Languages: - SQL, PL/SQL, Shell Scripting

Big Data Technologies: - Hadoop Hive, Spark, HDFS, MapReduce, Hue, Sqoop

Reporting Tool: - TIBCO Spotfire Professional and Spotfire Web player

Operating Systems: - Windows 10/7/2000, Unix/Linux, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Teradata Developer/Architect (Project Lead)

• Design and implement the data model needed for the reporting in Teradata
• Implement dimensional modelling, analyze the data, design the tables, indexes and views
• Develop and enhance the Daily, Monthly and Quarterly regulatory reports using Teradata and Hadoop
• Analyze and Develop Regulatory reports to schedule in a dynamic environment on large data sets with a minimum of ~50 Million transactions per day
• Develop and enhance the Daily, Monthly and Quarterly regulatory reports using Teradata and Hadoop and ensure the accuracy of the data as it is a regulatory project
• Build complex reports using Teradata Bteq’s
• Usage of Teradata load and unload utilities like TPT, Multiload, fastload & fastexport whenever needed for adhoc reporting
• Develop shell scrips to implement email functionality and several other features
• Develop strategies for use in high volume, high performance heterogeneous environment.
• To work on Migration of reports from Teradata to Hadoop systems and on reconciliation of the numbers
• To import data using Sqoop to load data from Teradata to HDFS on regular basis
• Developing Scripts and Batch Job to schedule various Hadoop Program
• To write Hive queries for Data Analysis for ad-hoc querying
• To analyze large data sets to determine optimal way to aggregate for reporting needs
• To create HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX and Teradata
• To manage and review Hadoop log files
• To test raw data and execute performance scripts
• Support code/design analysis, strategy development and project planning
• Create and export Regulatory reports using Hive
• Involve in creating tables, partitioning, bucketing of table in Hive
• Review, evaluate and implement process improvements, as appropriate
• To work and co-ordinate with the teams in offshore during the migration of reports
• To work with Management & Operations Teams, and other departments on various requirements across the globe to gather the necessary information and data needed to produce the report
• Produce the data required for ad-hoc requests on external audits and regulatory examinations
• Good Overview and understanding of PayPal's operations, products and process flows in terms of balances, Payments, Deposits, Withdrawals etc.

Environment: - Teradata, Big Data Ecosystems - Hadoop Hive, Spark, HDFS & MapReduce, UNIX-Shell-Scripting

Confidential, Milwaukee, WI

DW/BI Architect & Sr. Teradata Developer

• Responsible for developing the data model (physical and logical model) for the project
• Involved in developing schemas, analyze the data, design the entities and its relationships required for efficient reporting
• Involved in designing the tables, indexes to improve the performance
• Worked as an Onsite Coordinator - Interacting with the Business users on gathering the requirements Implemented the CRQ’s by analyzing the specifications provided by the client
• Designed and developed Informatica mappings, BTEQs (Teradata Utilities) and Job Chains using Cronacle to maintain optimal performance
• Actively involved in development and testing phases like Unit Testing, System Testing, Regression Testing, UAT Support for providing Quality and Defect free code
• Conducted code walkthroughs and review peer code and documentation
• Worked with Junior/Senior developers, DBAs, and systems support personnel in elevating and automating successful code to Production
• Involved in creating dashboards for the reporting standpoint
• Involved in anticipating the customer’s needs and Coordinating with the Architects and the team to meet the deliverables on time

Environment: - Teradata, Informatica, Cronacle, Spotfire, UNIX

Confidential, Milwaukee, WI

Data Analyst

• Involved with the Business and regional teams to understand the data request/requirements
• Analyzed the data and ensure that the data shared is not deviating from the existing Global Catalog Structure
• Primarily involved in developing the data files and was responsible for the smooth data loading process to Stage and Production environments
• Responsible for all phases of testing in different environments
• Maintain the Data Masters for the complete project for all the regions

Environment: - Hybris

Confidential, Milwaukee, WI

Sr. Teradata & ETL Developer

• Involved in interacting with the Business users on gathering the requirements during the backlog/grooming sessions
• Implemented complex transformations by creating custom transformations in addition to using built-in ones
• Excellent experience in creating and managing Database users, Schemas, Roles, Tables views and Projections
• Involved in providing the Optimal ETL Solution to extract and load the data from different source system to EDW
• Strong working experience in Design of scalable, reusable, and minimal maintenance of ETL templates
• Coordinated with the Technical architects and within the team to meet the deliverables on time and was responsible to handle and fix the issues in Stabilization period
• Involved in development and testing phases including Coding, Unit Testing, UAT Support for providing Quality and Defect free code
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Responsible for all phases of Testing in different environments
• Prepared the Support document and Transition the project to the Support team
• To propose the new optimized solutions to make the data available for NRT reporting

Environment: - Teradata, Informatica, Cronacle, UNIX & OBIEE, AWS (EC2)

Confidential

Sr. Software engineer

• Involved in developing a new module for APAC region using Teradata BTEQ’s
• Implemented the CRQ’s by analyzing the specifications provided by the clients
• Provided tech team support and was on-call coordinator for the project
• Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time
• To fix the scheduled jobs on failure, and to re-run the failed jobs through Unix environment
• Ensured the compliance of Quality procedures related to the project

Environment: - Teradata, Informatica, Business Objects, UNIX

Confidential

Sr. Software Engineer

• Implemented the CRQ’s by analyzing the specifications provided by the clients
• Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time
• To fix the scheduled jobs on failure
• Ensured the compliance of Quality procedures related to the project

Environment: - Teradata, Informatica and MicroStrategy

Confidential

Software Engineer

• Analyzed of the specifications provided by the clients
• Developed scripts using TERADATA BTEQ
• Created the detailed design document
• Validated the data by using Unit testing
• Ensured the compliance of Quality procedures related to the project

Environment: - Teradata SQL, Teradata and Informatica

Confidential

Software Engineer

• Involved in monitoring the workflows, re-running jobs on failure, updating the data and fixing the bugs
• Validated the status of the jobs
• Analyzed the root cause for failures
• Handled jobs on failure and then scheduled the jobs
• Ensured the compliance of Quality procedures related to the project

Environment: - Teradata V2R5, Linux Putty, Teradata Utilities, Data stage, Windows XP, 2003 Server, UNIX

Confidential

Software Engineer

• Analyzed the specifications provided by the clients
• Developed Interfaces using Sunopsis
• Prepared Business Rules for the developed interfaces
• Documented the developed interfaces

Environment: - Teradata V2R5, Windows XP, ODI (Sunopsis)