SUMMARY

• 8+ Years of total IT experience and Technical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modelling, Development, testing and documentation.
• 5 Years of experience in Teradata Database design, implementation and maintenance mainly in large scale Data Warehouse environments, experience in Teradata RDBMS using FastLoad, MultiLoad, TPump, FastExport, Teradata SQL Assistant, Teradata Parallel Transporter and BTEQ Teradata utilities.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning, technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Technical expertise in ETL methodologies, Informatica 7.1/8.6 - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Analyzed, Designed and documented requirements for data migration projects between numerous source Legacy/Oracle application feeds and the new Teradata platform.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, Teradata, Mainframe Files, Flat Files, MS Access.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Informatica, Macros and Triggers.
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing UNIX korn shell scripts to support and automate the ETL process.
• Experience in different database architectures like Shared Nothing and Shared Everything architecture.
• Very good understanding of MPP architectures.
• Experience in Tableau,Microstrategy reporting tools.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring experience in ensuring compliance to coding standards and review process.
• Experience in Full Cycle of Software Development (SDLC) including Requirement Analysis, System study, Design, Development, Unit testing, System Testing, Integration Testing, System Maintenance, Production Support and Documentation.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Excellent communication skills.
• Aptitude for analyzing, testing, debugging code, identifying problems, creating solutions and documentation.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.
• Good aptitude for problem solving and logical analysis.
• Highly motivated, team player with excellent interpersonal and communication skills, organized and quick learner.

TECHNICAL SKILLS

DATABASE: Teradata 12/13.10/14.10 , DB2, Oracle 7.x / 8.x / 9.x, MS Access, MySQL, Hbase, Informatica

ETL TOOLS: DataStage 7.5.1 / 7.1, Abinitio (Co-op 3.0), Informatica

REPORTING TOOLS: Business Objects 6.x / 5.x, Seagate Crystal Reports 6.x / 5.x / 4.x / 3.x, SQR 6.x,Microstrategy reports and MS access reports, Tableau.

PROGRAMMING: PL/SQL, VBA, UNIX Shell Scripting, Teradata SQL, ANSI SQL, Transact SQL, C, Python Intermediate level.

O/S: Sun Solaris 2.6 / 2.7, HP-UX, IBM AIX 4.2 / 4.3, MS- DOS 6.22, Novell NetWare 4.11 / 3.61,Mainframe,Linux,Macintosh.

LANGUAGE: SQL, UNIX Shell Script, Hive(HQL),Pig, Sqoop.

SCHEDULING TOOL: Autosys, CRON, UC4.

VERSION CONTROL: Git, SVN

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

TERADATA Developer

Responsibilities:

• Worked on finalizing the complete requirement scope of the project which has to be delivered in multiple phases.
• Experience in conducting weekly team meetings which involves projects planning, distribution of projects within the team. Also conducted weekly meetings with business, analytics and reporting teams to discuss about projects and give the status updates.
• Involved in code review meetings.
• Single point of contact for the whole project both from business users and reporting team.
• Worked as the interface between the developers and the project manager. Lead a team of 4 people onsite and 2 people offsite.
• Supported and guided the team in terms of work prioritization.
• Supported in performance reviews and determines professional development needs and opportunities for other teammates.
• Worked to ensure data quality and accuracy by implementing business and technical reconciliations via scripts and data analysis.
• Responsible for development and run test scripts to ensure the quality of code and integrity.
• Worked on Account level summary reporting project, this involves in automating manual generating report. Experience in writing SAS script to send excels report through email.
• Worked on many enhancement projects and also responsible for restating history data.
• Involved in Requirements Analysis, Design, Development and implementation of the whole project.
• Responsible for development of BTEQ scripts and UNIX Scripts across the whole project.
• Created all the Target Table DDLs and as well the Source table DDLs in Teradata.
• Worked with the Metadata Team to finalize the table structures as per the given naming conventions.
• Created complex scripts using CASE statements, Coalesce function, Qualify Row Number in Teradata.
• Responsible for creation of data models that meets the Reporting and Analytics team needs.
• Developed Code in BTEQ Teradata to load all the scripts in the final production environment
• Experience in writing JIL scripts in Autosys scheduling tool.
• Worked with Teradata utilities like MULTI LOAD, FASTLOAD,BTEQ.
• Working with the business team to provide accurate data in the final production target tables.
• Followed the complete SDLC methodology from requirements, design, building the code, Unit Testing, provide data to UAT testing, Informatica team and then deploy the code in Production.
• Reviewed logs in order to fix the failure jobs.
• Performance tuning the long running queries.
• Performed Data verification and validations to evaluate the data retrieved is apt according to the data requirements and specifications.
• Experience in working with production team. Responsible in fixing production failure job code and raise ticket for production team to implement it.

Environment: Teradata Utilities TPT, ESP, Teradata SQL Assistant, Putty, WinSCP, Atsclae, Hadoop, Hue, Hive Impala, Tableau, Fitnesse, Podium,Informatica.

Confidential - Sanjose, CA

TERADATA Developer

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Performed Data Analysis utilizing SQL programming and analytical skills.
• Experience with advanced MS Excel skills like macros, pivot tables, vlookup.
• Automated and scheduled recurring reporting processes using UNIX shell scripting.
• Performed data query, extraction, compilation, and reporting tasks using SQL, Teradata, MS-Excel.
• Developed, managed and manipulated report and data structures with the use of advanced Excel functions.
• Involved in getting data requirements from business users and generated reports in Excel as per the business requirement.
• Handled enhancement requests and adhoc requests.
• Written complex SQL queries in Teradata for the purpose of data analysis. For this purpose used complex Joins (Inner, Left Outer and Right Outer) to join multiple tables for getting desired data. Also used CASE statements and Qualify row number inorder to get desired data.
• Maintained historical data in Teradata for the purpose of generating reports and Data analysis for ad-hoc requests.
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
• Refreshed data using FASTEXPORT and FASTLOAD utilities.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, MULTILOAD,FASTLOAD.
• Performed Data verification and validations to evaluate the data retrieved is apt according to the data requirements and specifications.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Created daily processes to load data into tables by automating BTEQ scripts.
• Writing SQL scripts to manipulate data for data loads and extracts.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Worked on complex queries to map the data as per the requirements.
• Worked on Numerous Ad-hoc Data Pull request for Business Analysis by SQL using Advanced SQL techniques.
• Worked in Agile Environment.

Environment: Teradata Utilities (TPT, MLOAD, FASTLOAD, BTEQ, XPORT, TPUMP), Autosys Teradata SQL Assistant, UNIX, CRON, Putty, Mainframe.

Confidential, Richmond, VA

TERADATA/ETL Developer

Responsibilities:

• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Participated in the Analysis, Design and Development Phases of report development.
• Worked in Recoveries team which involves in Asset Sales, Legal and bankruptcy businesses.
• Handled multiple projects simultaneously by prioritizing accordingly.
• Responsible for moving UNIX Timer jobs to Production environment.
• Reviewed logs in order to fix the failure jobs.
• Experience with advanced MS Excel skills like macros, pivot tables, vlookup.
• Created Complex Teradata BTEQ scripts to generate ad-hoc reports that supported and monitored Day to Day Branch Operations.
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities.
• Queries against multiple data sources and transitions to new data sources quickly. Has a strong understanding of data and how data relates to business needs. Has ability to recognize trends in data and relationships to business questions.
• Involved in Branch Operations specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Generate weekly and monthly asset inventory reports.
• Involved in training programs and got experience in Hadoop ( Hive) for data analysis purpose.
• Involved in performing the analysis for all the Projects/Maintenance Requests.
• Support project through all stages of design, development and testing.
• Exported large volumes of formatted data from Teradata, Informatica to a host file or user-written application using FAST EXPORT.
• Used for loading, updating or deleting data to and from populated tables, typically with batch inputs from a host file using MULTILOAD.
• Created Multi set volatile tables, set tables as per requirement in Teradata.
• Extensive usage of Inner and Outer joins for retrieving data from multiple tables.
• Created complex scripts using CASE statements, Coalesce function, Qualify Row Number in Teradata.
• Collected statistics on all the tables used in the query as needed.
• Loaded large amount of data from external file into an empty table at high speed using FASTLOAD.
• Performance tuning the long running queries.
• Performed Data verification and validations to evaluate the data retrieved is apt according to the data requirements and specifications.
• Worked in Agile Environment.

Environment: Teradata 13 and 14, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, Informatica 8.1, Cognos, Tableau, UNIX, Korn Shell scripts, SAP BW, ECC, Teradata Analytics for SAP.