Data Analyst Assistant

Prakash Bhushan Manohar Keshri

Teradata Application Developer

Phone: 704-***-**** *******.*********@*****.***

Professional Summary

12+ years of software experience in design, development, testing, deployment, data analysis, application management and production support using Teradata, SQL, Mainframes Technologies, Autosys & UNIX Environment.

Teradata-12 Certified Professional with a good experience on leading Design, Development, Enhancement & Maintenance projects.

Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Teradata, Mainframes and UNIX Shell Scripting

Sound knowledge on SDLC process - Involved in all phases of Software Development Life Cycle - analysis, design, development, testing, implementation and maintenance of applications

Good experience with Water fall and agile methodologies. Facilitate scrum ceremonies: sprint planning, daily scrum, sprint review, and sprint retrospective.

Holding a Scrum Master Certification from Scrum Alliance.

Performing application level DBA activities creating tables, monitored and tuned Teradata BETQ scripts using Teradata Explain utility.

Experience with IBM InfoSphere MDM, worked on extensive review of DME and PME algorithms in MDM. Analyzed and helped clients move from DME to PME engine.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and Teradata databases.

Technically proficient, Customer dedicated with remarkable experience in Mainframe development & Maintenance projects built with Teradata, JCL & IBM Tools

Proficient and experience on developing and changing modules programming. Very good experience on developing and changing JCLs, Cobols and Procs. Strong experience on developing and changing Teradata SQLs.

Strong exposure in writing simple and complex SQL, PL/SQL queries.

Experienced as Data Analyst. Have hands on experience in Onsite-Offshore model projects.

Experienced working on modification of views on Databases, Performance Tuning and Workload Management.

Experience in leading a team of developers for workaround with different users for different, complicated and technical issues.

Strong experience in using mainframe systems and worked on various projects using SQL, Autosys, JCL and Teradata on batch systems. Excellent knowledge on developing design documents, technical documents and program specifications based on business requirements

Experience in scheduling the batch jobs using Autosys, Zeke and CA7 scheduling tools.

Involved in writing shell scripts on UNIX for Teradata ETL tool and data validation.

Worked on the multiple projects involving the cross-platform development and testing (Mainframe, Unix)

Strong organizational & presentation skills with excellent analytical & problem solving proficiency.

Skilled and experienced in Agile Development process for diverse requirements

Ability to work both independently and in a team environment. Have a good appetite to learn new tools/concepts at work. Motivated to deliver exceptional customer service proven to result in successful business outcomes.

Good in understanding the business requirements and developing analysis documents for the business requirements.

Technical Skills:

OS : IBM, OS/390, z/OS, Windows

Languages & S/W : JCL, SQL, VisionPLUS, Unix

Databases : Teradata, VSAM

Tools :

Teradata Utilities Fload, (Mload, TPump, FastExport, BTEQ), Autosys and Zeke, SQL Developer, DB2, TSO, ISPF, FILE-AID, LPAD, DFSORT,SAR, CA-7, SQL-ASSISTANT,IBM mainframe utilities and tools, NDM, FTP, Tectia(R).

Documentation Tools : MS-Office, Visio, SharePoint, WebEx, Communicator

Additional Tools MDM,ChangeMan, Endevor, SAR, FileAid, NDM, FTP, SFTP, CA7, Zeke, Autosys,

Teradata Utilities : BTEQ, MLOAD, FASTLOAD, FASTEXPORT, TPUMP, Putty, WinSCP

Incident Management : Peregrine Service Center, Maximo, Remedy

Defect Management : HP Quality Centre 9.2

Configuration

Management Tools : Endevor, Changeman, JIRA, Confluence

Certifications

Teradata 12 Certified Professional

Experience Summary

Bank of America, Charlotte, NC 11/ 2018 – Till date

Application Programmer

Project - Customer & Household Analytical Data Mart.

CHADM has a suite of applications that contain customer and household data on the 'W'(warehouse-Teradata database). The application fetches data from the source systems, process the data and stores on the W. The details will be used by other applications and the W-users for reporting purposes. Owned MRA process on APRTERA platform for Sales Practice Reporting.

Roles & Responsibilities

Worked as a senior developer in meeting the project objectives and manage day-to-day activities.

Preventive & Adaptive maintenance to adapt and integrate with the new enhancements.

Working with team on the production failures. Documenting the same and sharing knowledge.

Identifying the bugs and moving into production through Nexus, iInstall and iAdhoc.

Test environment setup for our team to conduct testing.

Co-ordinate with Users, Architects, Change control board members & Clients about the Changes, Results, Performance.

Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse.

Production job monitoring in AUTOSYS and deploying jobs in Autosys.

Performance tuning of scripts and SQLs.

Data Quality checks to ensure correctness of data that is provided to the down streams.

Coding in Teradata, SQLs, SAS and UNIX Scripting.

Unit & Integration testing of programs.

Reviews and Code Walkthrough of the developed components.

Tracking of Enhancements requests.

Environment & Tools: Teradata Utilities, UNIX, Autosys, SAS, SQL Assistant, WinSCP, Mainframes etc

Lowe's Companies, Inc 04/2017 – 10/2018

Mooresville, NC

Teradata Development Lead

Project: Customer Identifier Expansion

Customer Identifier is the customer key generated by Customer Data Warehouse and it flows through various systems as part of different business flow. The CUS_ID column was currently defined as an integer in the DDL structures on Teradata and CUS_ID generation is a file based process and limited to 9 digit integers only. The same was also referenced and cast as char(9) on the DML code in mainframe (in many instances across systems). Since, there is a challenge of running out of CUS_IDs in near future, it was decided to expand the char(9) cast to char(10) on DML code to overcome the current challenge. This provided a capability to generate CUS_IDs for many more years without any further challenges.

Responsibilities:

Worked on finalizing the complete requirement of the project by conducting extensive interviews with the project stakeholders and business.

Performed requirement analysis to understand the data and to finalize the project scope.

Created impact analysis document and worked with business users throughout the project.

Coordinated with all stakeholder from start of coding, testing till implementation of the project.

Created HLD and BRD and the SSD documents.

Analyzed entire applications, downstream and source systems for impact.

Worked with the DBAs to finalize the required create and alter table structures as per requirement.

Created new tables/views as well as edited the existing ones keeping performance in consideration.

Worked on coding of 144+ components involving Teradata utilities changes.

In addition to the project delivery, provided value adds to the application team by automating certain manual tasks within the project.

Involved in working with Off-shore team and coordinated effectively for the best outcome.

Responsible for performance, Space Management for Perm & Spool Space.

Provided 24*7 warranty support for the Teradata ETL jobs for daily and Weekly Schedule.

Written and deployed mainframe JCLs, Control Cards, edited COBOL programs as required and scheduled jobs in Zeke for developed processes.

Created multiple scripts with Teradata utilities in the final production environment.

Attended daily calls with both the business users and offshore team to ensure there is no GAP in project deliverables.

Was completely responsible for coding and review of code. Was involved throughout in Unit testing, CIT, SIT and UAT of the project. Also, worked with tester in defect closure.

Followed the complete SDLC methodology from requirements, design, building the code, Unit Testing, provide data to UAT testing team and then deploy the code in Production.

Attended meeting with CAB board and made sure to comply with the company’s standards. Implemented and provided post implementation support.

Environment: Teradata, Teradata SQL Assistant, Mainframes, UNIX and Autosys.

Bank of America, Charlotte, NC 09/2015 – 03/2017

Application Programmer

Project: Small Business Data Mart

This Project involves Small Business Optimization where a Data Mart is built for business users and reporting. There are 2 ways of Classification for the small business – Private Bankers which are otherwise called as Small Business Bankers and Client Dev Group (CDG). CDG primarily has a Client Manager for Small Business. The purpose of this project is to provide reporting data on both CDG and SBB. This project provides data to reporting team for handling multiple reports.

Responsibilities:

Worked on finalizing the complete requirement scope of the project which has to be delivered in multiple phases.

Worked with business users and reporting team throughout the project.

Performed requirement Analysis to understand the source data and to finalize the project scope.

Created requirement Scope document, Data Mapping documents and Design Documents.

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 and available data.

Involved in creating Teradata Objects like views, databases and Tables

Involved in performance tuning, audit and backfill and moving forward. Did the Integration testing in both the Layers.

Involved in working with Off-shore team and coordinated effectively for the best outcome.

Involved in monitoring jobs in production daily to ensure accurate expected data is being processed

Responsible for performance, Space Management for Perm & Spool Space.

Extensively used Derived Tables and Volatile Table in many of the ETL scripts.

Provided 24*7 warranty support for the Teradata ETL jobs for daily and Weekly Schedule.

Written and deployed UNIX scripts and scheduled Autosys jobs for developed processes.

Developing Code in BTEQ Teradata to load all the scripts in the final production environment.

Worked with the business team to provide accurate data in the final production target tables.

Attend daily calls with both the business users and reporting team to ensure there is no GAP in requirements.

Follow the complete SDLC methodology from requirements, design, building the code, Unit Testing, provide data to UAT testing team and then deploy the code in Production.

Environment: Teradata V13/V14, BTEQ, Teradata SQL Assistant, UNIX Shell Scripts and Autosys.

Wells Fargo, Charlotte, NC 02/2015 – 09/2015

Sr.Teradata Developer

Project- Mortgage Operation Data Environments. The MODE application exists to provide a technology solution for the acquisition, transformation, storage and delivery of electronic data produced in various system-of-records which are required to support business partners to perform day-to-day critical business processes. MODE acts as a data exchange “broker” between data producers and data consumers.

Roles & Responsibilities

Working as a Data Analyst/Developer in projects of MODE.

Attending meetings with business to understand project requirements and review of BRD documents.

Preparing the FSD (functional specification document) for the project and meeting with other developers and testers to make them understand the requirement.

Provide regular updates to project managers and implementation consultants.

Regular meeting with developers and testers on different phases of the project.

Test environment setup with production similar views and tables along with access similar to production.

Review the test results and be involved in the project till implementation and post implementation validation.

Data profiling, analysis and preparing all project documents and review and coordinate testing.

Post implementation support and validation.

Environment & Tools: Teradata Utilities, Autosys, SQL Assistant, Oracle (11g), SQL Server (2012), UNIX, Windows XP, MS Visio, Toad, Toad for Data Analyst, JIRA

Bank of America, Charlotte, NC 08/ 2014 - 01/2015

Teradata Developer/L3 Team Lead

Project - Customer & Relationship Hub.

Customer & Relationship Hub (CRH) has a suite of 30 applications that contain customer data on the 'W'(warehouse-Teradata database). Two applications that bank supported CDM (Customer Data Mart) and C&RA (Customer and Relationship Application) have been merged together to reduce the duplicate data in application. This new application is built in UNIX and Vertica. There are Autosys batch jobs. This application creates several indicators based on defined bank rules for the Line of business to take critical decisions.

Roles & Responsibilities

Worked as a senior developer leading a team of 5 members in meeting the project objectives and manage day-to-day activities.

Preventive & Adaptive maintenance to adapt and integrate with the new enhancements.

Review of documents prepared by development team before handover to production team.

During production parallel period working with development team on the production failures. Documenting the same and sharing knowledge with onshore and offshore team.

Identifying the bugs and moving into production through Maximo/Remedy RFCs.

Test environment setup for our team to conduct testing.

Co-ordinate with Users, Architects, Change control board members & Clients about the Changes, Results, Performance, Install procedure & dates.

Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse.

Production job monitoring in AUTOSYS.

Data Quality checks to ensure correctness of data that is provided to the down streams.

Conducting Impact Analysis and Program Analysis for the client requests

Coding the SQLs, JCLs & PROCS.

Unit & Integration testing of programs

Onshore / Offshore co-ordination

Reviews and Code Walkthrough of the developed components

Tracking of Enhancements requests.

Environment & Tools: Teradata Utilities, JCL, UNIX, Autosys, SQL Assistant, Changeman, File-Aid, MVS, OS/390, Mainframe Service Oriented Architecture (SOA), Windows XP

Bank of America, Charlotte, NC 12/2009 - 07/2014

Database Developer

Project - Customer & Relationship Application

Customer & Relationship Application (C&RA) has a suite of 20 applications that contain customer and relationship data on the 'W'(warehouse-Teradata database). Each application fetches data from the source systems, process the data and stores in the W. The details will be used by other applications and the W-users. Upon business requirement, new Warehouse applications will be built for improving the quality of customer information in the bank and measure the business. High profile customers are identified based on the set of business rules and Premier line of Business predominantly use the customer information and other affiliated customer information for providing service.

Roles & Responsibilities

Worked as a Senior Programmer/Developer in a team of 6 members in meeting the project objectives and manage day-to-day activities.

Enhancements to the existing functionalities to integrate with the applications and thereby providing more scope for the application.

Preventive & Adaptive maintenance to adapt and integrate with the new enhancements.

Analysis of client supplied documents, Prepare program flow & Business Change documents.

Created Mapping Documents and ETL design documents for both Presentation Layer and Standard Layer. Followed Enterprise Level Metadata and Audit standards while creating design and source-to-target mapping documents.

Preparation of test plans & scripts for Unit testing & User Acceptance testing - Co-ordinate for test environment setup.

Code & Test results review.

Co-ordinate with Users, Architects, Change control board members & Clients about the Changes, Results, Performance, Install procedure & dates.

Production Implementation, Deployment & Post Implementation support.

Business as Usual production monitoring.

Data Quality checks to ensure correctness of data that is provided to the down streams.

Environment & Tools: Teradata, JCL, SQL Assistant, Mainframes, Changeman, File-Aid, UNIX, Windows XP

GE Money, UK, 10/2007 - 11/2009

Asst. System Engineer

GE Money is a part of GE Capital operating division of General Electric. The division, headquarter in London, has 130 million global customers and offers a range of financial product including private level credit card, personal loans, bank card, auto loans and leases, mortgages, corporate travel and purchasing cards, debt consolidation and home equity loans and credit insurance.

Project – SCR (System Change Request).

GE Money used Vision PLUS financial software. This project had several modules. VisionPLUS is credit/debit/prepaid account life cycle processing system. It consists of various modules that work together to manage life cycle of accounts. There were multiple change requests that our team worked on.

Roles & Responsibilities

Coordinating the project. I had been assigned the responsibility of executing the SCR’s successfully.

Delivering the Analysis document.

Code changes.

Unit testing of the code changes.

Test data preparation.

Fixing of issues that came up during testing.

Migration of error free code to production.

Post implementation support.

Providing time and effort estimates for the entire life cycle of the project

Current System Architecture Analysis and Feasibility Study.

System Overview Document and Implementation Process Document preparation

Customization of source codes to cater to UK business specific functionalities.

Testing and issue fixing

SIT and UAT support.

Environment & Tools: Teradata.COBOL, JCL, VSAM, VISION PLUS, Changeman, Zeke, File Aid, SAR, CA7

EDUCATION DETAILS:

Bachelor of Computer Applications

BIT Mesra Ranchi. Jharkhand India

Master of Computer Applications

Sikkim Manipal University. Sikkim India

Contact this candidate