Sumit Yadav

Phone: +91-991*******

E-mail: actbfq@r.postjobfree.com

actbfq@r.postjobfree.com

Objectives

To work in a highly competitive environment that enables me to consistently endeavor to learn new technologies, business domains and latest industry trends. Develop my technical & analytical skills that will enable me contribute to the achievement of the ends of my organization and fulfilling my professional aspirations.

Summary of Experience

7.5+ years of work experience in the development/support of EDW-BI applications across various industry domains.

Highly motivated and energetic self-starter with good analytical, organizational, creative and communication skills. Ability to work independently as well as in a team.

Consistently endeavour to sharpen my skills, take responsibilities, exchange knowledge and mentor juniors.

Education

Bachelor of Engineering in Computer Sc. & Engg. from Career Institute of Technology & Management, Faridabad, Haryana. India (2004-2008)

Experience

ORGANIZATION

DESIGNATION

DURATION

Infosys Ltd.

(Website: www.infosys.com)

Systems Engineer

July 2008 – Jan 2011

NCR Corporation India Pvt. Ltd.

(Website: www.ncr.com)

Software Engineer

Jan 2011 – June 2012

Amdocs(www.amdocs.com)

Senior SME

June 2012 – Sep 2013

Deloitte Consulting US-India Pvt Ltd.

Consultant

Sep 2013 – till date

Skills

Technology

Expertise Level

DW-BI

Teradata

Expert

Informatica

Expert

Scripting

Unix Shell Scripting

Expert

Big Data

HBase (0.92-0.96)

Expert

Hadoop

Intermediate

BI/ EPM

Hyperion (FDQM/HFM)

Basic

App Development

VB/VBA

Expert

Java

Intermediate

Certifications

Successfully passed Infosys technical certifications level 1 and level 2 in Open Systems in 2009 and 2010 respectively.

Successfully passed NCR University teradata/Unix trainings at NCR Corporation in Jan 2011.

Work Profile

Project : WLP Enhanced Personal Healthcare Project Oct 2014 – till date

Client : Anthem INC USA

Technologies : Teradata 14, Informatica PC9.6.1

OS Platform : Linux(Sun-Solaris),Citrix(DAAS)

S/W Tools : SQL Assistant 14, Teradata Viewpoint, CLEARCASE, WLM client

Details:

Anthem INC is a leading healthcare insurance provider in the US. As part of EPHC project the system was enhanced to include primary care physician and shared savings data coming from upstream systems and develop processed data files for downstream systems.

Responsibilities:

To develop high quality code using Teradata Bteq, Informatica mappings and Unix Shell Scripts. Enhance system, add new objects to the CRE system with each successive release.

Enhance informatica mappings when new DB objects, fields are inducted in the systems. Design, develop and debug the ETL flow for the new objects from multiple type of input sources(like SQL server).

Create and debug transformations for smooth load of base tables from staging tables.

Design new table DDLs, determine primary/secondary indexes for proper data distribution across the MPP system.

Created an automation accelerator(PI_Profiler) to analyze table skewness and determine optimum PI column(s).

Coordinate with business users and design solutions to meet user requirements. Monitor development and testing activities to follow project plan and deliver high quality code and documents within project time deadlines.

Performance tune the code to ramp up the system so that it meets the high scale extract generation as the system grows in volume and new datawarehouses get aligned with each acquisition.Monitor and debug poorly performing Teradata queries and Informatica workflows.

Test, debug and migrate new developed code in DEV-SIT-UAT environment. Fix defects during testing and finally migrate the defect free high quality code to production environment.

Project : POC Project Telecom CDR Processing Mar 2015 – Sep 2015

Client : Internal Project (POC)

Technologies : HBase 0.96, Flume, Kafka, Spark

OS Platform : Ubuntu Unix on Cloudera 4.7.0 VMWare

S/W Tools : Eclipse, Cloudera 4.7.0 VMWare

Details:

Project was an internal POC for designing a CDR processing, analysis and reporting for a telecom client. The major outcome of the project was to build a secured connection using Flume/Kafka to upload CDRs to HBase database. Securing a stateful system which can reliably upload bulky CDR logs and do near realtime validations with reference to HBase database and finally uploading processed logs to SPARK downstream system for complex analytical operations and reporting.

Responsibilities:

To design and develop HBase database objects and data model.

Write read scripts to upload CDR logs from an upstream Flume/Kafka system, process and store in HBase database.

To write export scripts to create extracts from HBase database for downstream systems.

This was done a part of firm contribution project.

Cross train peers on HBase concepts.

Project : WLP Senior Risk Project Jun 2014 – Oct 2014

Client : Anthem INC USA

Technologies : Teradata 13.10

OS Platform : Linux(Sun-Solaris),Citrix(DAAS)

S/W Tools : SQL Assistant 13, Teradata Viewpoint, CLEARCASE, Informatica PC9.1

Details:

Anthem INC is a leading healthcare insurance provider in the US. As part of Senior Risk Project, the system in place was enhanced to include MEDICARE(healthcare data for senior citizens) data.

Responsibilities:

To develop high quality code using Teradata BTEQ and Unix Shell Scripts. Enhance system, add new objects to the CRE system with each successive release.

Enhance informatica mappings when new DB objects, fields are inducted in the systems. Design, develop and debug the ETL flow for the new objects.

Create and debug transformations for smooth load of base tables from staging tables.

Coordinate with business users and design solutions to meet user requirements. Monitor development and testing activities to follow project plan and deliver high quality code and documents within project time deadlines.

Performance tune the code to ramp up the system so that it meets the high scale extract generation as the system grows in volume and new datawarehouses get aligned with each new acquisition

Test, debug and migrate new developed code in DEV-SIT-UAT environment. Fix defects during testing and finally migrate the defect free high quality code to production environment.

Project : WLP CRE Project Sep 2013 – Jun 2014

Client : Anthem INC USA

Technologies : Teradata 13.10, Informatica

OS Platform : Linux(Sun-Solaris),Citrix(DAAS)

S/W Tools : SQL Assistant 13, Teradata Viewpoint, CLEARCASE, Informatica PC9

Details:

Anthem INC is a leading healthcare insurance provider in the US. As part of CRE project Deloitte maintains a CRE Client Reporting Extracts system which is an online reporting tool for Clients(Vendors). As part of legacy decommissioning and system upgrade extracts will be generated from a single source datawarehouse and replace legacy extract with highly scalable extraction using Teradata utilities.

Responsibilities:

To develop high quality code using Teradata BTEQ and Unix Shell Scripts. Enhance system, add new objects to the CRE system with each successive release.

Coordinate with business users and design solutions to meet user requirements. Monitor development and testing activities to follow project plan and deliver high quality code and documents within project time deadlines.

Replicate Legacy ETL processes into informatica mappings and create informatica mappings to fetch data from heterogeneous sources.

Performance tune the code to ramp up the system so that it meets the high scale extract generation as the system grows in volume and new datawarehouses get aligned with each acquisition.

Test, debug and migrate new developed code in DEV-SIT-UAT environment. Fix defects during testing and finally migrate the defect free high quality code to production environment.

Mentors juniors and help peers in technical and process related issues.

Project : Amdocs AIS BI Configuration Support July 2012 – Sep 2013

Client : T-Mobile USA

Technologies : Teradata, Oracle, Informatica

OS Platform : Windows Server 2003, Unix(HP-UX),

S/W Tools : SQL Assistant 13, Informatica PowerCenter 8.6, Accurev

Details:

T-Mobile Inc. USA is one of the leading telecom operator.As a part of T-Mobile US account Amdocs provide IT services comprising of middleware services, website maintenance and BI configuration services. Amdocs AIS BI Config support team performs QA testing for DW/BI systems of T-Mobile USA.

Responsibilities:

Coordinating with environment planning team and maintaining sync between all the running projects for managing the available environments.

Extracting the code from ACCUREV and deploying the code in QAT environment Coordinating with the DEV and TEST team, understanding the requirements and business significance of the code change/new development and planning the time deadlines.

Review/Edit Teradata SQL commands in scripts and optimally tune them remove any performance glitch. In case of any performance bottleneck work along with DEV/DBA team, suggest modifications and deliver the most optimal solution. In case of prod deployment week, provide a full week support post deployment and immediately resolve any issue which may come in prod environment.

Project : Hyperion Upgrade 2.0 May 2011 – June 2012

Client : NCR Corporation

Team Size : 3 (Offshore) + 1(Onsite)

Technologies : Hyperion(FDM/HFM), Teradata, VB/VBA

OS Platform : Windows Server 2003 & XP

S/W Tools : Oracle Hyperion Suite 11, Visual Studio 2005

Details:

NCR Corporation is the leading manufacturer cum seller of ATM machines, cash registers and self-serve kiosks. As a part of Hyperion Upgrade 2.0 project the existing finance data consolidation is moved from Hyperion HAL/HFM system to a fully automated Hyperion FDQM/HFM system.

Responsibilities:

Customizing the FDM process for automating it. This was done using the FDM APIs/ DLLS to create executable VB scripts and creating Windows BAT files to call these EXEs.Creating import formats & validation entities and define mappings within the FDM.

The key challenge was to automate the entire FDM internal process using the FDM batchloader dlls in VB code.Embedded the teradata sql code within the VB code to query database in between the process using ADO objects.

Writing code using the HFM DLLS within VB to automate the star schema creation process and extraction process in HFM.

Project : NCR Sales Central Enhancement Project Feb 2011 – Apr 2011

Client : NCR Corporation

Team Size : 2 (Offshore)

Technologies : Teradata

OS Platform : Unix (HP-UX RAS)

S/W Tools : SQL Assistant

Details:

NCR Corporation is the leading manufacturer cum seller of ATM machines, cash registers and self-serve kiosks. Sales Central is a system which acts a source of sales force data to the EDW system. As a part of this project we were supposed to enhance the EDW system for newly introduced OPPORTUNITY data. Term OPPORTUNITY is used for a sales prospect.

Responsibilities:

Analysing the existing system for the impact of the new columns to the existing data flow and population of the final base tables.

Inducting new tables which would be used to capture opportunity data mapped to the respective sales representative.

Creating views to be used for BO reporting.

Project : Apple iTunes Media Research Project Oct 2008 – Jan 2011

Client : Apple INC, USA

Team Size : 8 (5 Offshore, 3 Onshore)

Technologies : Teradata

OS Platform : Unix (IBM AIX 2.0)

S/W Tools : Aquadata studio

Responsibilities:

Writing Teradata DDL and DML scripts to generate data extracts. Using complex joins on big database tables to fetch data with the minimum overhead and finally processing them using shell scripts.Writing Unix shell scripts for automating some of the repetitive teradata DML operations.

Performance tuning of teradata queries and documenting DLDs, Test Plans and Validation documents.

Personal Details

Current Location: Gurgaon Haryana, India

Date Of Birth: 27th July 1986

(I hereby declare that all the details given above are true to the best of my knowledge.)

DATE: 18-Jan-2016

Delhi Sumit Yadav

Contact this candidate