Email: mayank.shekher@gmail.com
Phone: +91-9665093644
Experience Summary
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.
management Activities
Team Grooming & team building
Team appraisal
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.
Technical Activities
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.
Technology
Below is a list of software products and tools that I have worked with.
Software
IBM rational packages (Clear Quest / Clear Case), Perforce,SVN tortoise.
Operating
systems
Linux (RHEL 3 AS), Sun Solaris 9, AIX 5.1, HP-Unix.
Tools / Utilities
Toad, FTP / Telnet / Remote Desk Top & CITRIX, SQL Assistant, Multiload, Fastload, BTEQ, Fastexport, Powerdesignerv13.
Programming Languages
Teradata / Oracle 9i / ANSI SQL, basic shell scripting.
Domain Experience
Telecommunication and HealthCare
Database
Oracle, Teradata (v2R5, 12).
Qualifications
Degree and Date
University
Major and Specialization
BCA 04-July-2006
Symbiosis International University
information technology
Certifications
Introduction to oracle 9i: SQL
Successfully completed for oracle database administration course from SQL star international ltd.
Agile overview
Implementation for software growth and development with current competitive edge in IT industry, completed with 78% from Tech Mahindra.
Career Profile
Company Name : TATA Consultancy
services Limited
Company origin: INDIA
Designation: I.T. Analyst
Duration: 21st July'11 – Till date
Responsibility
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.
Project : ABCD project
Customer : Barclays
Role : Senior Developer
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
Responsibility
Project : SDS Vectus
Customer : Barclays
Role : Senior Developer
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
Responsibility
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
Designation: Analyst
Duration: 14th February’08 – 24th January’10
Responsibility
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
Designation: Developer
Duration: 18th September’06 – 13th February’08
Responsibility
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.
Personal Details
Date of Birth
15-10-1982
Nationality
Indian
Gender
Male
Marital Status
Single
Passport Details
Name as on passport
Relationship
Passport Number
Date of Issue
Expiry Date
Place of Issue
Mayank Shekher
Self
F8857318
14-07-2006
13-07-2016
Pune
Mayank Shekher
ResumeMayank ShekherPage PAGE 7 of NUMPAGES \*Arabic 7
Ad details
- Type:
- Other
India
Free classifieds in India > Jobs & Services in India
Job Offers in India > TERADATA DEVELOPER
Popular Searches