Harikrishna Dogiparthy
(Teradata/Mainframe Application Developer)
Email-id: aculze@r.postjobfree.com
Mobile +1-412-***-****
Pittsburgh,PA
Professional Summary:
o9.5 years of experience in IT with proficiency as Teradata and Mainframe application development and strong expertise in SQL queries.
oAs part of assignments, involved in all phases of SDLC from interacting with clients, Analysis, Planning and Scheduling, Effort Estimation, Design, Development, Testing, Quality and Delivery activities and implemented projects from scratch in mainframe and Teradata environment.
oExtensively worked with Teradata utilities like BTEQ, Fast Export, view point, sql assistant,Fast Load, Multi Load to export and load data to/from different source systems including flat files.
oGood experience in ETL Tools like Informatica.
oExperienced in Functional Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing (UAT) in both Batch environments. Writing test scenarios, defining test cases and analyzing bugs.
oOver 5 years of experience on Teradata development and operation with Teradata database
oHave experience in Bulk loading data from Flat files into Teradata using Mainframe/informatica workflows
oExperience in understanding High Level Requirements from customer and in Preparing the High Level Design, Low Level Design and Detailed Design Specifications for a Project.
oMade changes to the existing COBOL/DB2/VSAM/SORT programs in mainframe environment to reduce the CPU consumption time and Increase the efficiency of the System.
oExceptional IT technical project planning and implementation, strong customer service attitude, exceptional organizational ability, interpersonal skills and communication skills.
oExcel at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives.
oExperience in Risk Management plans with identification, responses, mitigation and experience in preparation with proper documentation on archival system.
oHighly proficient with JCL,COBOL,DB2,VSAM and Easytreives
oWorked on various mainframe tools QMF,ESP,Endeavor,File–id,SPUFI
oExperience on Domains such as Health and Automobile Insurance.
oAmbitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.
oOutstanding project planning, execution, monitoring and resource balancing skills with ability to support multiple simultaneous projects in a matrix organizational structure with Waterfall and Agile methodology.
Academic Qualification:
Bachelor of Engineering (B. E.) in Electical and Electronics from PCET Coimbatore, India.
Work Experience:
Current Organization/Employer : Accenture india Pvt Limited, from July 2010 to till date
Previous Organization/Employer : Worked with CSC India Private Limited, Hyderabad under the pay rolls of TECHY SOFT from December 2006 to June 2010.
Designation: Senior Software Engineering analyst.
Project experience
Client : Highmark BCBS, Pittsburgh, PA, USA
Project : Enterprise Dataware house
Duration : May 2011 – Present
Role : Test Data management support Lead
Team Size : 8(onshore), 40(Offshore)
Description
Enterprise data warehouse is a unified database that holds all the business information an organization and makes it accessible all across the company. Although there are many interpretations of what makes an enterprise-class data warehouse, the following features are often included: A unified approach for organizing and representing data The ability to classify data according to subject and give access according to those divisions (sales, finance, inventory and so on) A normalized design A robust infrastructure with contingency plans to allow for business continuance, accessibility and a high level of security Scalability
Responsibilities
oExecute LST Reports daily, coordinate test data activities (both Onshore & Offshore), be a single point of contact from IDC during Business hours and provide QA data support to Projects during business hours, connect with BA’s for any test data clarifications, help/support Offshore team.
oLead Five offshore resources ensuring work is assigned to them and has been reviewing their work on daily basis.
oAnalyzing the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
oInvolved in gathering information for various scenario for Change Data Capture.
oExtensively worked with Informatica– Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to analyse various complex mappings, mapplets, reusable transformations, session tasks and Workflows as part of test data support
oAs a Data warehouse ETL test data support resource, am responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
oExecutes system integration jobs for various projects with in EDW in providing needed test data to Business analysts
oExpertise on performing tasks like scheduling workflows, error handling and email notification for failures of test/QA data loads.
oEffeciently communicating with various downstream users where LST data pass through multiple application in HIGHMARK.
oExtensively supported during system upgrades such as Teradata version upgrade in TEST.
oInvolved in moving data from PROD to TEST using Teradata developer utilities such as OLE load
oExtensively involved in maintaining EDW’s control tables through spread sheet Macro process.
oExtensively used Informatica Workflow Manager to run the workflows,
oMonitored the session logs/log files in Informatica Workflow Monitor.
oSolved Various Defects in Set of Scripts which executed through Teradata BTEQ, MLOAD, FastLOAD utilities and Unix Shell scripts
oDeveloped MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
oCreated BTEQ scripts to extract data from warehouse for downstream applications.
Environment: Informatica 9.6.1, Teradata 14.0, IBM Mainframes,UNIX, ESP SCHEDULER, harvest,ClearQuest,Service Manager,View point,Oracle,jcl,db2
Client : Highmark BCBS, Pittsburgh, PA, USA
Project : Member outbound
Duration : July 2010 – May 2011
Role : Application developer
Team Size : 6
Tools/Applications : COBOL, JCL, DB2, File-Aid,SPUFI,Easytrieve
Responsibilities
oEstimate and Develop technical designs and program specifications to match the technical and functional testing requirements of the project .
oInvolved in solution delivery requirements gathering and estimating the efforts based on the requirements .
oPrepare an estimate of the actual cost and then determine the effort in terms of man days to get the change request solved .
oProvide support for System Integration Testing and fixing the bugs in SIT raised by testing team and estimate the efforts involved in these tasks .
oUsed knowledge of Customized Global Estimation Model to help estimate work efforts, scope out work and facilitate the use of V-Model Software Life Cycle in completing deliverables on each phase and on time. This ensures that every deliverable adheres to Accenture proven methodology and standards.
oParticipate in status calls with client Ensuring quality process compliance and timely delivery of applications as estimated .
o Perform analysis, design, detail construction and implementation of batch and on-line components for the Schwab Institutional line of business utilizing DB2
Client : Farmers Insurance, LA, USA
Project : HELPDESK AND ERRORLOG (ZURICH)
Duration : Dec 2006 – June 2010
Role : Aplication Developer
Team Size : 12
Tools/Applications : COBOL, JCL, DB2, File-Aid,SPUFI,Easytrieve,Endevor
Project Description:
Farmers Insurance is America's third-largest insurer of both Personal Lines and Commercial Lines. Help desk and error log team is production team of Farmers company and is part of the Zurich group, which has global presence in most of the developed countries in the world. Farmers Insurance Group currently sells Auto, Home, Life and Commercial Insurance Coverage’s for the customers in US.
APPS is an integral part of Farmers Insurance group. It deals with the various aspect involved in vehicle insurance. This project is a maintenance project. Requests are serviced based on the requirements.
Responsibilities
o New application development.
oEnhancement of existing applications and maintenance.
oAnalysis and Estimation of various service requests and enhancements.
oCreating High Level Design/Low Level Design documents from Project Definition document.
oProgramming following the design documents.
oUnit Testing and Integration Testing.
oSystem Testing and presenting the test results to the US SMEs and the customers.
oUser Acceptance Testing support.
oImplementation activities.
oReviews and Inspection.
oProduction support and monitoring various cycles
oMaintaining the Application Information Documents in the project repository.