Post Job Free

Resume

Sign in

Data Etl

Location:
Loveland, OH
Posted:
February 19, 2021

Contact this candidate

Resume:

Naveen Kumar Bonam

512-***-****

adkbp4@r.postjobfree.com

Professional Summary:

Having 9 years BI-DW experience as an ETL developer and ETL Tester, Where I have worked on ETL, Business Analysis, Requirements, Development, Testing using industry accepted methodologies and procedures.

Worked in Development, Testing, Data migration and Production Support Projects using Informatica Power Center ETL tool.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing

Extensive experience in working with Informatica Power Center along with relational databases Oracle, Netezza, SQL Server and heterogeneous data sources Flat Files, Excel, JSON files and XML.

Strong in analyzing and writing complex queries using SQL in Oracle, Netezza and SQL-Server.

Experienced in UNIX work environment, file transfers, job scheduling and error handling.

Expertise in Job Scheduling tool CA Workload Automation (ESP).

Experience in ETL Testing on Data Warehousing Applications.

Hands of experience in PL/SQL stored procedures and packages for moving the data from staging area to data marts.

Created database objects like tables, views, materialized views, indexes, and procedures using oracle tools like Toad and SQL Developer.

Professional experience in Integration, Regression and System Testing.

Created ETL Test Data for all ETL Mapping rules to test the functionality

Well versed with performance tuning for ETL's and SQL's in Oracle, Netezza and SQL-Server.

Extensive experience in implementing projects using Agile (Scrum) and Waterfall methodologies.

Good understanding of source to target data mapping and Business associated with the ETL processes.

Expertise in detail-oriented documentation and converting the Business Requirements into Technical Design documents.

Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.

Experienced in working with automated ETL testing tool Informatica Data Validation Client (DVO).

Involved in review meetings with Project Managers and meetings related to Agile Scrum (Sprint Planning, Daily Scrum, Sprint Review and Retrospective).

Experience in multiple business domains (HealthCare, Banking, Wealth Management, Sales)

Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Good in gaining Functional Knowledge, Worked with SME for few modules in Health Care Management.

Strong in Data warehousing concepts (Star Schema, Snowflake, SCD, Normalization/ De-Normalization) RDBMS concepts and skilled in Oracle, Teradata and Netezza (SQL).

Quick adaptability to new technologies and zeal to improve technical skills.

Strong team player with ability to work in a team and an individual contributor, Ability to work independently with minimum guidance.

Educational Profile:

Master of Computer Applications (MCA) from GITAM College (Andhra University)

Certifications:

Certified Scrum Master (CSM)

Professional, Academy for Healthcare Management (PAHM)

Technical Skills:

Development Tools (ETL) : Informatica 8.x,9.x, 10.x and Informatica Developer (IDQ).

Automated ETL Testing : Informatica DVO.

Strategic Planning Software : Agile Rally.

Case Tools : Toad, SQL Developer, Teradata SQL Assistant, Putty, Win SCP

Configuration Management : IBM Rational Clear Case

Test Management Tool : HP ALM

Databases : Oracle, MS SQL-Server, Teradata, Netezza, DB2, Hive

Cloud : Azure Cloud SQL-Server

Programming Languages : SQL, PLSQL, Unix Scripting

Job Scheduling : CA Workload Automation, Tivoli Workload Scheduler (TWS)

Data Modeling : Erwin

Operating Systems : Windows 2000/XP/7, Unix, Linux

Projects:

Kroger, Blue Ash, OH Nov 2018 to Till Date

Informatica (ETL) Developer

Platform & Skills : Informatica Power Center 10.1, SQL Server, Oracle, DB2, JIRA, HP ALM, MS Visio 16, Beyond Compare, SQL, Shell Scripting, Unix, Tivoli workload scheduler (TWS), DB Visualizer, Flat Files, JSON data, Informatica IDQ, Azure Cloud SQL-Server

Project Detail: Kroger is an American retailing company founded by Bernard Kroger in 1883 in Cincinnati, Ohio. It is the United States largest supermarket chain by revenue ($115.34 billion for fiscal year 2016),

the second-largest general retailer (behind Walmart) and the seventeenth largest company in the United States.

Kroger Technology strives to be the most valued technology organization in retail. Technology has created a competitive advantage in several parts of our business and innovation investments are accelerating. Each day technology systems and infrastructure play a critical role in supporting our associates and Customers.

Enterprise Item Strategy (EIS)is a program designed to maximize data available for customer engagement methods. A program designed by Kroger to integrate all their item data into one single platform using Informatica PIM which would be the “single source of truth for item data”. All the downstream systems (Stores, Ecom) would consume data only from this source of truth. The project will streamline our item setup and digital asset management approach for Category Management and suppliers by centralizing product information.

Project Contribution: As a reliable team member, I

Engaged in understanding existing data model and Analyzed the specifications provided by the client

Design and develop complex ETL mappings that perform Extraction, Transformation and load of source Json data into Derived Masters schema using various power center transformations.

Prepared the error handling mechanism to maintain the error handling process, used existing ETL standards to develop these mappings

Prepared scl, ksh scripts (to trigger the workflow) and rcp files to migrate the code to higher environments using Unix.

Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.

Extensively used IDQ Parser in Informatica PC to parse Json source data. worked with parsing and creating XML and JSON files

Ensure the daily and weekly production schedules and tasks are completed accurately and timely without any issues.

Prepared detail design document, mapping document and migration document to move the mappings from development to testing and then to production repositories.

Extensively used DB Visualizer for executing SQL queries and worked on SQL for enhancing the performance of the conversion mapping.

Migrate SQL Server database to Microsoft Azure Cloud SQL database.

Automated ETL jobs to load data into new Azure SQL database.

Prepared all the support documents for the ETL code developed like (ETL code details, TWS Job Stream details, inbound and outbound files, lookup, intermediate files, and API request details for all the sources)

Attend daily scrum calls, weekly meeting, PI Planning to discuss current activities/ schedules and future.

Attend meetings with business users to understand the existing system and identify new business requirements.

TMNAS, Philadelphia, PA Oct 2017 to Oct 2018

Informatica (ETL) Developer and QA

Platform & Skills : Informatica 10.1, MS SQL Server, SAP, Win SCP, HP ALM, Reports, Flat Files, PL/SQL

Project Detail: TMNA Services, LLC was established in 2012 as the shared services company to Tokio Marine North America, Inc. (TMNA). TMNAS provides value-added services to all TMNA Group Companies including Philadelphia Insurance Companies (PHLY), First Insurance Company of Hawaii (FICOH), Tokio Marine America (TMA), and its insurance companies.

Informatica ETL tool is used to integrate the claims data from various vendors and transfer the data between SAP, Bank and Source applications. As a QA Engineer, I used to run the test cases for the end to end process in that claims application. Involved in Functional Testing, User Interface Testing, Regression Testing and Performance Testing.

Project Contribution: As a reliable team member, I

Engaged in understanding existing data model and business of the client.

Preparing Unit test plan, test execution and performing code reviews.

Performing ETL validation, preparing test scripts and recording the evidence.

Release documentation and coordination, application support and maintenance.

Involving in Enterprise-level ETL Testing and understanding the flat file structures.

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Participated in regular project status meetings and QA status meetings.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Create, maintain and execute automated and exploratory user testing strategies.

Gather, analyze and present to IT management the QA program metrics.

Working on ETL/BI (Informatica) SIT, Regression testing and Performance testing.

Interactions with BA and Dev teams to resolve the issues and reporting daily testing status.

Performed Data validations and verifying the data in source systems and target databases, Validated the results with the reports (registers).

Developed SQL-Server PL/SQL Stored Procedures for automate testing.

Worked on SQL-Server database for preparing the test scripts.

Yana Software Inc, Austin, TX ` July 2017 to Oct 2017

ETL Developer and Tester

Platform & Skills : Informatica 10.1, DVO, Teradata, Oracle, Win SCP, Putty, UNIX, HP ALM, Agile Rally, Erwin and Flat Files

Project Detail: Indian Eagle works with suppliers to provide you with travel related services and products. The site is focused on travel information and trip fares to offer the lowest airfare. Indian Eagle main function is to act as an agent, selling travel products and services on behalf of a supplier.

The Project involves building a Data Warehouse system to improve overall quality and productivity of existing processes and deploying reliable and accurate information. Worked as ETL developer and tester for data warehouse application. I was involved in multiple projects including ODS (operational data store) I performed both Business Analysis and Data Analysis for consolidation project on the web interface and the reporting interfaces.

Project Contribution: As a reliable team member, I

Engaged in understanding existing data model and business of the client.

Prepared the mapping specification documents by understanding the business requirement.

Developed the mappings, sessions, workflows and reusable mapplets according to the requirement.

Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs. Also involved in migration/conversion of ETL processes from development to production.

Extracted data from various sources across the organization (Oracle, SQL Server and Flat files) and loading into staging area.

Participated in user meetings, gathered Business requirements & specifications for the data warehouse design. Translated the user inputs into ETL design docs.

Participated in Testing and performance tuning by identifying bottlenecks in mapping logic and resolving them, setting cache values and creating partitions for parallel processing of data.

Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.

Conducted knowledge transfer sessions with client resources and documented Data Mappings/ Transformations as per the business requirements.

Involved in writing Test scenarios, Test cases and Test scripts. Done the data validations, Regression testing and performance testing.

CGI, Hyderabad, India. ` May 2016 to June 2017

ETL Developer

Platform & Skills : Informatica 9.1, 10.1, IDQ, Informatica Analyst, DVO, MS SQL Server, Teradata, Oracle, Win SCP, Putty, UNIX, HP ALM, Agile Rally, ESP Scheduler, Erwin, XML, JSON and Flat Files

Project Detail: Cigna is an American worldwide health services organization. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services. Cigna also offers Medicare and Medicaid products and health, life and accident insurance coverage’s primarily to individuals in the U.S. and selected international markets. Cigna have sales capability in 30 countries and jurisdictions, and more than 90 million customer relationships throughout the world

UMCM (Utilization Management and Case Management) is an independent, not for profit organization whose mission is to ensure consistent quality of care for clients and customers. In this Inbound process we receive data in Files and tables after applying all the transformation rules, Data is loaded from legacy systems to TruCare database, after loading the data into target database authorization is created and validated.

Project Contribution: As a reliable team member, I

Trained on Healthcare Management, Certified on Professional, Academy for Healthcare Management.

Attended transition sessions given by client and prepared understanding and reverse KT documents.

Worked on Agile methodology and Delivering the code in very short time.

Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Extracted the data from legacy systems and loaded the data to the XML Files which are the feed for the TruCare System.

Worked with System Analyst on Analysis User Stories and prepared the Mapping Design Documents for the Business requirements.

Developed the ETL code as per the business standards, validated and tested the code

Created and scheduled Sessions and Batches through ESP Scheduler.

Involved in migrating the code from Informatica 9.1 to Informatica 10.1.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Performed Unit Testing, Integration Testing and Regression Testing for the Unix Shell Scripts (Files distribution in NAS path).

Prepared the Migration template for code migration.

Worked with SME on logical/physical data model level using Erwin according to requirements

Coordinated with ETL Testing team for fixing the defects.

Extensively worked on JSON and XML files.

HTC Global Services, Hyderabad, India. Apr 2015 to Mar 2016

ETL Developer

Platform & Skills: Informatica 9.6.0, Netezza, Teradata, DB2, SQL Server, Hive, HP ALM, Putty, UNIX, Erwin, Agile Rally

Project Detail: UnitedHealth Group offers a spectrum of products and services through two operating businesses UnitedHealth care and Optum. OPTUM Rx AND CATAMERON together called ORCHARD (3rd largest PBM Organization in the World).OPTUM is a leading health services and innovation company dedicated to helping make the health system work better for everyone

Current Project, Orchard (Optum Rx Consolidated Home For Research and Development) is Migration and Enhancement Project deals with PBM (Pharmacy Benefit Management) Life Cycle data. Migrating DataMart’s from I Series (DB2) to Netezza database environment. Added some additional functionality for all the DataMart’s according to the client requirement, Introduced Data Fabric Layer to integrate all the Source Systems, Migrated to Agile Methodology from Waterfall development

Project Contribution: As a reliable team member, I

Attended KT Sessions given by Project Manager and Leads.

Engaged in understanding the existing 9.1 code and its functionality.

Prepared the mapping specification documents for development of code in Informatica.

Involved in migrating the code from SSIS to Informatica ETL Tool.

Prepared the Mapping Spec, Unit Test Cases and ETL Check list document.

Worked on Hive to Stage mappings which involves Hive (Data Fabric) as Source.

Migrated the code to Test Environment for all the jobs which completed development and testing in Dev Environment.

Involved in the development of mapping related to SCD’s, Incremental and Data Migration.

Presented the Product Demo for the work done on the particular sprint.

Engaged in performance tuning activities for the 9.1 Informatica code.

Applied the Netezza Bulk Writer at the session level to increase the performance.

Given KT to the newly joined employees in our project regarding Orchard Standards.

Supported for QA team for mapping specs, data loads and defects

Reviewed the code done for mappings in Dev environment and prepared the Test cases for the same.

Daily attended the Scrum Calls for the status of the work done and any blockers.

Iinteracted with the DA’s and Onshore leads regarding any issues.

Experis IT, Hyderabad, India. Aug 2014 to Apr 2015

ETL Developer and Tester

Platform & Skills: Informatica 9.1.0, Putty, UNIX, Oracle, Netezza, Clear Case, SSH, HP ALM, Clear Case

Project Detail: The Canadian Imperial Bank of Commerce commonly (CIBC), is one of Canada's chartered banks, fifth largest by deposits. The bank is headquartered at Commerce Court in Toronto, Ontario. The bank's two strategic business units, CIBC World Markets and CIBC Retail Markets, also have international operations in the United States, the Caribbean, Asia and the United Kingdom. Globally, CIBC serves more than eleven million clients, and has over 40,000 employees

Business Banking Customer Profitability (BBCP) is a data warehouse application undertaken to replace the old profitability application for Business Banking called Client RAROC (Risk Adjusted Return on Capital).Currently the Client RAROC (Risk Adjusted Return on Capital) is Business Banking’s primary tool for tracking client returns for business decisions and performance management. The actual risk-adjusted client returns are reported monthly by region and relationship manager using a web-user interface. Client RAROC is currently only used for Business Banking clients in the over $5M credit segment

Project Contribution: As a reliable team member, I

Gone Through the Frame work developed in i2 data model.

Attended KT Sessions by i2 Leads.

Extensively worked on Analysis of the i3 High level Mapping Documents and prepared the Technical Design Document.

Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of procedures for code enhancements.

Developed the Stored Procedures in Netezza based on the business requirement.

Analyzing requirements, executing test cases, Performing manual testing by performing the operations mentioned in the design steps.

Developed UNIX shell scripts to move source files to archive directory.

Responsible for creating complete test cases, test plans, test data and reporting status ensuring accurate coverage of requirements and business processes.

Created Stored Procedures to update several tables and insert audit tables as part of the process.

Performed Integration, End-to-End, system testing and Involved in Functional Testing & Regression Testing.

Involved in debugging process to check for data errors and data validation.

Involving in writing SQL queries and Database Checkpoints to verify data quality calculations and reviews.

Performed data validation testing writing SQL queries.

Experis IT, Hyderabad, India . Apr 2013 to Aug 2014

Tester, Developer and Supported the Application

Platform & Skills: Informatica 9.5.1, Oracle, Win SCP, Putty, UNIX, SAP BW, HP ALM, HPSM, GL-910 Files

Project Detail: The BB&T Corporation (Branch Banking & Trust) is an American bank. offering commercial and retail banking services along with other financial services such as insurance, investments, retail brokerage, mortgage, corporate finance, consumer finance, payment services, international banking, leasing and trust. Based in Winston-Salem, North Carolina, BB&T operates more than 1,800 financial centers in the United States.

Project ONE is an enterprise-wide initiative that will significantly revitalize and simplify BB&T’s financial system platform. This transformation will include replacing BB&T’s general ledger (GL), fixed asset and accounts payable systems (collectively referred to as “financial system”), redesigning the chart of accounts and automating business processes to make our company more efficient and agile. Currently, we are using multiple and obsolete GLs throughout BB&T along with a disparate chart of accounts. To remain competitive in the financial services industry, we must simplify and standardize our systems and processes throughout the company. As a result, we are transitioning to one financial system and one chart of accounts for BB&T Corporation. This new financial system will enable us to significantly reduce system complexity and fragmentation

Project Contribution: As a reliable team member, I

Engaged in understanding existing data model and business of the client.

Developed new mappings based on the existing mappings.

Extensively worked on Data Quality Issues.

Worked exclusively on flat files (fixed width and delimited files).

Designed the mapping with reusable objects (Mapplets), Created shortcuts and parameter files.

Prepared the Unit Test Case and Migration documents.

Tested the workflows using Unix Wrapper scripts.

Prepared Functional Specification and Technical Specification (TS) documents.

Iinteracted with the client for requirements gathering and to give status for the work completed.

Delivered KTS to the new Team members on the work done.

Used Debugger to test the mappings and fixed the bugs.

Worked on L1 Support for sub ledger interfaces.

Monitoring the Jobs and reporting on SLAs

Handling production call on daily basis. Prepared PPT of the load summary and failure for client.

Infostep India Pvt Ltd, Hyderabad, India. Oct 2010 to Sep 2011

ETL Developer

Platform & Skills: Informatica 8.6.0, MS SQL Server 2008, Oracle, HP ALM, Win SCP, UNIX, Flat Files.

Project Detail : Barclays is a global financial services provider, engaged in retail and commercial banking, credit cards, investment banking, wealth management and investment management services all over the world. Barclays Wealth management is an investment advisory discipline that incorporates financial planning, investment portfolio management and a number of aggregated financial services to High Net worth Individuals (HNWIs), who desire the assistance of a credentialed financial advisory specialist call upon wealth managers to coordinate retail banking. Barclays Wealth is committed to meeting the needs of wealthy clients and those aspiring to become wealthier

Project Contribution: As a reliable team member, I

Analyzed the specifications provided by the client.

Worked with different sources such as Oracle, MS SQL Server and Flat files.

Loading the data into targets depending on the frequency (Daily and Weekly) of the source data.

Preparing Design Document, ETL specifications, Unit Test Cases and Migration Documents.

Worked on various tasks like command task, event wait task, event raise task etc.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables

Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.

Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Scheduled the Workflows to run several sessions and batches concurrently and sequentially.

Significantly done the data validations.

Extensively worked on migration of Informatica sessions and mappings.



Contact this candidate