I am a Software engineer with more than 6 years of experience in software design, development and implementation.
Technical expertise in Teradata / ANSI sql queries, and utilitieslike Fastload, Multiload, BTEQ, Fastexport, SQL assistant and exposure to unix machines for running and managing Teradata scripts.
I have worked on Sybase Powerdesignerv13 tool in designing Teradata warehouse data-model in healthcare domain.
Seasoned professional, with good project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure.
Team Grooming & team building
Conducting technical recruitment drive for Teradata
Work allocation and review status reports
Effort and buffer time Estimation
Execution timeline planning for schedule/ad-hoc outage
Conducting brain storming sessions
Initiate new responsibilities and help to plan for the growth of organization
Suggest and recommend best practices prevailing in the market for the industry where ever applicable which enhanced the quality of technical delivery.
Code Analysis, Code Design and Peer code - reviewing.
Experience in utilities like Multiload, Fastload, Fastexport and BTEQ, SQL Assitant.
Working exposure in unix, linux and solaris platform.
Experienced in sql script writing for Teradata v12 SQL / Oracle 9i SQL.
Data model creation by use of PowerdesignerV13.
Provide post go live support.
Below is a list of software products and tools that I have worked with.
IBM rational packages (Clear Quest / Clear Case), Perforce,SVN tortoise.
Introduction to oracle 9i: SQL
Successfully completed for oracle database administration course from SQL star international ltd.
Implementation for software growth and development with current competitive edge in IT industry, completed with 78% from Tech Mahindra.
Company Name : TATA Consultancy services Limited
Company origin: INDIA
Designation: I.T. Analyst
Duration: 21st July'11 – Till date
Project : CH – Fusion DA Data modelling
Customer : Cardinal Healthcare
Role : Senior Developer
PowerdesignerV13 tool used for designing data-models (CDM,LDM, PDM) in teradata warehouse.
Extensively worked on SQL query optimization concerning performance challenges.
Owner for powerdesigner main repository and authorising every code updates to main from SVN tortoise.
Providing complex Teradata SQL queries to supports business justification.
Designing objects based on existing warehouse ( oracle ) to create a place for accepting feeds from realtime.
Providing and authorising realtime scenarios for source to target mapping generation.
Exploring unix user level commands for running Teradata utility scripts.
Knowledge transition to new team members before taking them onboard to any new assignment.
Extensively used teradata utilities like fastload, mload ,fastexport for data transfer & management in devdata team.
Did error handling and performance tuning in Teradata queries and utilities.
Did unit testing for many modules before taking the code changes to dev box.
Avoiding skewness and to maintain evenly data distribution applied strategies and research techniques.
Worked accross various database of Teradata warehouse in our project like stage,target and work and datastage.
Authorising and approving peer codes before making it sign-off from off-shore.
Designing store procedures which runs during maintenance window for data cleansing from environments which got sign-off from dev.
Company Name : Cognizant Technology Solutions Corp.
Company origin: USA (New Jersey)
Designation: Associate - Projects
Duration: 10th November’10 – 21st June'11
Potentially maintaining referential integrity to boost up the teradata loaders speed at time data loading.
Designing ANSI sql query which supports cross platform when running in different environment for adhoc business requirements.
Understanding the business specification and analysing data based to client requirement.
Data extraction from source to target on fastload, bteq.
Arranging brain storming sessions for team to fill gaps when new challenges arrives.
Providing query for performance issues over cost, budget and resource sharing.
Worked on fact and dimension tables, designed views for data protection over env.
Acted as a liaison between the offshore and onsite teams.
Active participation in proof-of-concept ( POC ) over different environments like build, stage, SIT,dev and prod.
Creating and modifying loader scripts for loading data into integrated data warehouse (IDW).
Prepared Unit test specification requirements document.
To support data center and teradata dual active system efforts, worked with the team to clone jobs, programs and teradata tables and ensuring both systems get updated simultaneously and in sync all the time.
With the in-depth expertise in the teradata identifies 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. In-depth knowledge of teradata explain.
Company Name : Tech Mahindra Limited
Company origin: INDIA
Designation: Assistant Business Analyst TG1
Duration: 25th January’10 – 11th October’10
Project : Product and build artisan
Customer : British telecom
Role : Developer
Designing result driven transition plan of teradata logical to physical architecture from based on AS-IS and TO-BE model which follows purely Agile methodology.
Working in co-ordination with data handling team for exporting / importing data from landing area to different target systems of warehouse to build summary tables.
Analysing complex requirement’s providing optimal code solution based on Teradata, oracle db.
Handling reports to business by running complex query on Teradata functions.
Query bug-fixing and query optimization in Teradata to save resource consumption’s at peak.
Ensuring rigorous data validation before data loading on different client servers.
Working with Teradata12 utilities like BTEQ ,FastLoad ,MultiLoad ,Fast Export and Queryman.
Worked across ET,UV,WT and LT Tables.
Familiar with complete data warehousing development life cycle.
Involved in peer to peer reviews.
Conducted research to check data accuracy in Teradata database tables and the possibility to use Teradata tables instead of tables created by different vendors.
Establish data governance and data quality principles, standards and policies.
Involved in production implementation of new systems and Teradata system upgrades as part of maintenance.
To overcome realtime scenarios / challenges, creating and managing the partitions at table level using index technique.
Company Name : Amdocs Limited
Company origin: Israel
Duration: 14th February’08 – 24th January’10
Project : Data Dev
Customer : Sprint
Role : Developer
Closely working on reference / application / operational tables for data migration using Teradata.
Writing joins for data manipulation and report generation for stake holders requirements over geographic data.
Developing / designing DDLs / DMLs to support ongoing business of Telecom.
Experienced with mentoring Teradata development teams, program code development and datasets creation.
Fastload utility were used for multiple data insertions, when huge data has to populated in fresh environment for POCs under short period of time, in absense of ETL.
Worked as a focal point for core invoicing dev team in India and able to manage responsibilities independently.
Understand and monitor service performance targets, escalate as appropriate when required.
Providing support to ongoing release / builds / Golive.
Collaborate with other development group to determine and confirm the issue prevailing is product defect or new enhancement.
Implement database changes and updates for application releases following established procedures.
Creation and maintenance ksh shell scripts for application deployment and development to make teradata system more independent and automated.
Work as development lead and is responsible for resource allocation, managing resources (onsite and offshore), prepare ETL Design (source to target mapping documents), helping developers in developing efficient code, ensure coding standards are followed, perform code reviews, delivery of quality code, meeting the timelines for development, perform end-to-end testing and provide weekly status on projects to management.
Company Name : Ameriteck Global IT Solutionz
Company origin: USA
Duration: 18th September’06 – 13th February’08
Monitoring system status, process and session levels, memory utilization, disk subsystem and upgrades to meet service level agreements.
Handling triggers for updating history tables which get delta updates on regular basis.
Managing temporary tables in dev schema for unit testing and performance issue over space.
Identifying / creating partitions on tables to avoid full table scan when huge records exist.
Designing SQL scripts to automate services for development to have more accuracy by avoiding human errors.
Troubleshooting to unix machines which runs teradata.
Writing fastload scripts used to perform quick bulk insertions.
Analysing Service and Infrastructure Problems from alerts/system-logs to develop and implement temporary/permanent solutions.
Verify and analyse correct teradata / oracle sql fixes in dev / prod.
Creating, implementing, monitoring, administering and documenting file system backups, off-site storage and recovery.
Demonstrated ability to meet deadlines, and set priorities.
Developing and managing sql joins, co-related sub queries and OLAP functions for business report for customers/ stakeholders over demographic facts.
Carrying out data reconciliation through queries in various source systems.
Date of Birth
Name as on passport
Date of Issue
Place of Issue
ResumeMayank ShekherPage PAGE 7 of NUMPAGES \*Arabic 7