Kranthi Borugadda

Contact: 224-***-****

ac7oef@r.postjobfree.com

PROFESSIONAL SUMMARY:

Around 10 years IT experience in Informatica Powercenter, Informatica MDM, Teradata, Oracle, Cognos in the fields of Application Design, Development, Testing, Implementation, Migrations and Data Warehousing specifically.

Worked in various areas including Informatica Powercenter, Informatica MDM, Teradata, ETL INFORMATICA SQL, UNIX, Oracle, SQL Server.

MDM/ETL Consultant with experience in implementing MDM solutions, working with Data Warehouses, Data Marts, Data Architecture, Metadata Management, and/or Data Governance.

Have the ability to work in multiple instances of Informatica, SQL Server Integration Services (SSIS), Oracle ETL INFORMATICA tool, and Legacy Systems.

Highly skilled in MDM Hub Configurations – Data modeling & Data Mappings, Data Validations, Match and Merge rules, Batch Jobs, Batch Groups, Hierarchy Manager Tool, Customizing/Configuring Informatica Data Director (BDD/IDD).

Good Knowledge in OBIEE to generate reports in different formats according to the requirement of business users.

Proficient in Data warehousing concepts including Data mart, Data mining using dimensional modeling (star schema, snowflake schema design)

Extensively worked in various areas of Oracle, SQL.

Proficient in archiving and backups. Used tar, cpio, dd, ufsdump, ufsrestore commands. Day to day administration of the Development, Test, Stage and Production environment.

Generated keys using keygen and also configured SFTP and FTP.

Resolve the UNIX requests or issues for SAP developers.

Created shell scripts and updated the scripts as per the requirement.

Developed scripts for inbound and outbound of the data on servers.

Supported all the UNIX requests for various applications.

Efficiently managed disk by deleting old log files.

Extensive space allocation to various applications upon requirement, detaching and clearing the devices if not in use.

Day to day administration of the Development environment and Test environment systems.

Responded to all UNIX systems problems 24X7 and resolved them on a timely basis.

Experience with all aspects of Project Development life cycle from Analysis, Modeling, Design, Implementation and Testing.

Highly familiar with monitoring activities viz, session monitoring, space allocation and memory usage.

Extensively worked on UNIX.

Worked extensively on Informatica Tools – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Extensive experience on Migration of Mappings/workflows.

Extensive experience in creating the Mapping Specification Documents to develop complex Mappings.

Schedule, Run, Load processes and monitor sessions by using Informatica workflow manager and workflow monitor.

Highly familiar with production monitoring activities viz., session monitoring, space allocation and memory usage.

Good debugging abilities of Informatica mappings, workflows/sessions.

Ability to execute technical and functional troubleshooting of software bugs and performance issues related to data warehousing and business intelligence applications.

Optimized and modified the triggers, complex stored functions, procedures, user base datatype using PL/SQL.

Highly experienced with SQL and PL/SQL for testing Database integrity/Data validation.

Coordinated and mentored offshore for various design reviews and Production issues.

Excellent knowledge of Quality assurance and SDLC Process.

TECHNICAL EXPERTISE:

ETL INFORMATICA Tools: Data Stage, Informatica Power Center 10.2, SAP

OLAP Tools: Business Objects 6.1, Cognos7/8.3, OBIEE 11g

Database: Oracle 10.0, Teradata

Batch Scheduling Tools: Control M, Autosys, Redwood Cronacle Scheduler, TWS (Tivoli’s Job Scheduling tool).

GUI Tools: Oracle SQL Developer, Terada SQL Assit, SAS

Languages: C, C++, Java, VB 6.0, SQL /PL SQL

OP. Systems: Windows NT/XP/2000, UNIX Shell Scripting

Tools: iKnowMed, Salesforce, Informatica MDM, SQL Developer, SSAS/SSRS, TOAD, Citrix, Erwin Data Modeler, MS Excel, Word, PowerPoint, and Access.

EDUCATON: Master of Science Computer Applications - 2006; JNT University, Hyderabad, India

Bachelor of Computer Applications; PBN College, Nidubrolu, India

CERTIFICATIONS: Teradata Certified Master

IBM Certified Designer - Cognos 8 BI Reports

PROJECT DETAILS:

Mckesson, Woodlands, TX Feb 2018 – Current

Sr. Informatica Powercenter 10.2 Developer/Analyst

Here Iam involved in collecting requirements from Client and based on their inputs, requirement documents, develop the logic and build and then communicate next steps like PROD sign off to CI(Commercial Intelligence) team.

Extensively involved in scrubbing Monthly MPLI(Master Practice Location Index) incremental records

Extensively involved in loading and debugging Monthly Market Connect HIDM data loads.

Involved in Business meetings very often to discuss and finalize the requirements.

Involved in Performance tuning of different Materialized views. Debugged in Informatica/Oracle to resolve issues and communicated effectively with DBAs/Informatica Admins.

Actively communicated to Client about the updates.

Interacted with client very friendly to get the exact requirement of the project and communicated to the respective teams.

Involved in Salesforce to check Information about patients and their billing and used iKnowMed to access patient’s EMR records.

Involved in different client meetings to understand and proceed further with the project process.

Involved in Preparing Project plan, Analysis document, Excel sheets.

Anthem, Houston, TX Jul 2017 – Dec 2017

Business Analyst

Here Iam involved in collecting requirements from Client and based on their inputs, design documents and communicate to design team for development activities.

Involved in Business meetings very often to discuss and finalize the requirements.

Actively communicated to Client about the updates.

Interacted with client very friendly to get the exact requirement of the project and communicated to the respective teams.

Involved in different client meetings to understand and proceed further with the project process.

Involved in Preparing Project plan, Analysis document, Excel sheets.

Involved in differentiating Non functional and Functional requirements.

Involved in client meetings to discuss in detail regarding Billing team, Enrollment team etc.,

Involved in meetings to discuss in detail regarding Patient reporting, Maintenance, Underwriting, Indiviual etc.,

JcPenney, Plano, TX Jul 2016 – Dec 2016

Sr. Informatica Powercenter 9.6 Team Lead

Here I was involved in Cyclecount Project where Stores do precount and post count of all inventory. We had to generate files according to client requrements. So I was handling offshore and onsite team to deal with these activities.

Performed ETL Informatica Powercenter 9.6 Error Handling, Error logging mechanism by going through Error Log files from Informatica Powercenter 9.6 Workflow Monitor.

Involved in development of mappings in Dev and migrated to INT, TST and Prod Environments.

Involved in UNIT Testing and group testing as well.

Involved in Business meetings very often to discuss and finalize the requirements.

Actively communicated to Client about the updates.

Created Deployment groups to move the data to upper environments.

I was also handling offshore calls with offshore and explain them the process and assigned them tasks on day to day basis.

Used JIRA to create, manage and track tasks/Issues related to RMS project.

This involves reviewing their project work and assigning back if it needs to be redone.

Interacted with client very friendly to get the exact requirement of the project and communicated to offshore accordingly.

Involved in different client meetings to understand and proceed further with the project process.

Involved in Preparing Project plan, Analysis document, Technical Design document, Mapping docuement etc.,

Environment: Informatica Powercenter 9.6, Toad 13, SQL Developer, ALM tool.

BP, Houston, TX Dec 2015 – May 2016

Sr. Informatica Technical Lead

Here I was involved in two projects. First one is ODS Flush that is moving all the data from ODS to EDW after applying the given logic. Second Proejct involves correcting the Production data which was incorrect for millions of records.

Performed ETL Informatica Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.

Involved in development of mappings in Dev and migrated to INT, TST and Prod Environments.

Involved in UNIT Testing and group testing as well.

Created Deployment groups to move the data to upper environments.

In Second Project, I was handling offshore team to take calls with offshore and explain them the process and assigned them tasks on day to day basis.

This involves reviewing their project work and assigning back if it needs to be redone.

Interacted with client very friendly to get the exact requirement of the project and communicated to offshore accordingly.

Involved in different client meetings to understand and proceed further with the project process.

Involved in Preparing Project plan, Analysis document, Technical Design document, Mapping docuement etc.,

Environment: Informatica Powercenter 9.5.1, Toad 10, SQL Developer, Clearcase tool.

SYSCO, Houston, TX May 2013 – Sep 2013

Sr. ETL Informatica Analyst

This is a 212 Redwood CPS Scheduling project currently delivering Intime solutions for existing 5 OPCOs. It was a Production project for Data Mart which involves Medium development, handling enhancements and day to day schedule/Job failures and address data quality issues raised by end users in a complex environment with various sources and different SAP target systems.

Gained an understanding of the existing Business Process.

Developed strategic testing plans to achieve performance quality by coordinating with the project manager.

Created and Ran Jobs according to the requirement.

Involved in database design and documentation, normalization and de-normalization.

Monitored the Jobs in Redwood Cronacle and addressed tickets raised by customers.

Reviewed testing documentation to ensure it met software development and testing standards.

Provided recommendations to improve testing process for supporting quality assurance initiatives.

Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.

Involved in SQL development to support SAP BW design and analysis.

Environment: SAP BW, SAP Basis, Oracle, SQL, UNIX, Redwood Cronacle, TWS (Tivoli’s Job Scheduling tool).

HALLIBURTON, Houston, TX Aug 2012 – Oct 2012

Sr. ETL Informatica Developer/Redwood Cronacle Analyst

This was a Production project for Data Mart which involves Medium development, handling enhancements and day to day schedule/Job failures and address data quality issues raised by end users in a complex environment with various sources and different SAP target systems.

Gained an understanding of the existing Business Process.

Developed strategic testing plans to achieve performance quality by coordinating with the project manager.

Created and Ran Jobs according to the requirement.

Monitored the Jobs in Redwood Cronacle and addressed tickets raised by customers.

Reviewed testing documentation to ensure it met software development and testing standards.

Provided recommendations to improve testing process for supporting quality assurance initiatives.

Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.

Involved in SQL development to support SAP BW design and analysis.

Environment: SAP BW, SAP Basis, Oracle, SQL, UNIX, Redwood Cronacle, TWS (Tivoli’s Job Scheduling tool).

Pepsico Inc, Plano, TX Nov 2011 – Dec 2011

Sr. ETL Informatica Programmer (short, quick 2 month enhancement project)

This was a Development project for Data Mart which involves Medium development, handling enhancements and day to day batch failures and address data quality issues raised by end users in a complex environment with various sources and different SAP target systems.

Gained an understanding of the existing Business Process.Involved in database design and documentation, normalization and de-normalization.

Developed strategic testing plans to achieve performance quality by coordinating with the project manager.

Handled tasks of reviewing testing documentation to ensure it met software development and testing standards.

Evaluated defect metrics data and updated the finding report to the appropriate management.

Provided recommendations to improve testing process for supporting quality assurance initiatives.

Worked out data requirements from SMEs and implemented through workflows and code.

Performed Informatica ETL Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.

Worked on Teradata Bteq, Mload, Fload scripts.

Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.

Involved in PL/SQL development to support ETL (Informatica) design and analysis.

Delivered Performance Tuning methods in Informatica with large volumes of data load.

Designed and developed ETL Informatica processes to meet requirements.

Debugged Data Stage ETL Informatica processes and tuned for performance.

Provided assistance with ETL Informatica standards and design for future supportability and ease of enhancements.

Debugged and analyzed various issues and applied appropriate fixes. This involved extensive work on Informatica mappings, workflows, session logs and fetching the data from Oracle/Teradata.

Developed PL/SQL Scripts/Macros in SQL Developer.

Checked SIDs status using Teradata SQL Assistant and run jobs accordingly.

Ran Fastload, Multiload, and TPUMP Scripts to recover failed loads.

Environment: Informatica Powercenter 8.6.1, Teradata SQL Assistant 13.0, SQL Developer 12.0, Control M (Batch Scheduling tool), UNIX.

Nike Inc, Beaverton, OR May 2010 – Dec 2010

Sr. ETL Informatica Developer

Oct 2010 – Dec 2010

This was a KLO project for Data Mart which involved Medium development, handling enhancements and day to day batch failures and address data quality issues raised by end users in a complex environment with various sources and different SAP target systems.

Performed ETL Informatica Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.

Involved in database design and documentation, normalization and de-normalization.

Involved in running different batch jobs using Autosys and Workload Control Center.

Involved in identifying the reason for delay of long running or slow jobs.

Actively involved in discovering the solution or root cause for slowly running jobs.

Worked on Teradata Bteq, Mload, Fload scripts.

Debugged on Teradata Bteq, Mload, Fload scripts.

Performed responsibilities of developing and implementing test cases under the guidelines of senior ETL Informatica tester.

Assigned the tasks of testing functional applications and, validating testing procedures.

Provided Performance Tuning methods in Informatica with large volumes of data load.

Developed data migration strategies and procedures for production deployment. Designed and configured stored procedures, constraints, indexes, cursors using established PL/SQL Server coding conventions.

Designed and configured stored procedures, constraints, indexes, and cursors using established SQL Server coding conventions.

Developed PL/SQL Scripts/Macros in SQL Developer.

Debugged/Analyzed the PL/SQL Scripts to find out the solution for fixes.

Conducted unit testing of ETL INFORMATICA code as well as experience with Oracle and Flat Files.

Performed administration activities such as user access accounts, roles, setting standards, etc.

Created transformations [XML, unconnected lookup, Normalizer] and mappings using Informatica PowerCenter and processing tasks using Workflow Manager to move data from multiple sources into targets.

Environment: Informatica Powercenter 8.6.1, SQL Developer 12.0, Autosys (Batch Scheduling tool), UNIX.

May 2010 – Sept 2010

This was a Support project, which involved in handling day to day system integration testing batch failures and addressed data quality issues raised by end users in a complex environment with various sources and different SAP target systems.

Gained an understanding of existing Business Process. Studied existing system/ review using Nikepeida.

Checked SIDs status using Teradata SQL Assistant and run jobs accordingly.

Checked Error log files through UNIX for different jobs and solve the issues.

Ran Fastload, Multiload, and TPUMP Scripts to recover failed loads.

Ran queries through Teradata SQL Assistant.

Monitored, scheduled jobs and fixed bugs in QA using WCC (Workload Control Centre).

Reviewed and Deployed code

Uploaded all the Release related documents into Nikepedia.

Environment: Informatica Powercenter 8.1.1, Terdata SQL Assistant 12.0, SQL Developer, UNIX, Autosys (Batch Scheduling tool).

AVIVA GROUP CLIENT-NUI, U.K. Feb 2008 – Nov 2009

Asst Systems Engineer, TATA Consultancy Services Ltd.

(ETL Informatica Developer)

One of Aviva’s key marketing objectives is to place the customer at the heart of marketing activities. This requires a transformation from the current fractured marketing process, which uses fragmented, brand-led data environments & independent teams, to a more integrated capability that is truly customer-centric and competitively advantageous. Investment in this capability is critical to profitable growth in the future. Consequently Marketing would like to undertake this transformation to a marketing environment which is customer value focused, deriving maximum ROI through optimized multi-channel communication with existing and future customers through.

Designed and built a data infrastructure (single customer view)

Provided an integrated tool-set to for planning, analytics, decision and reporting

Implemented a new organization structure and associated processes

Gained an understanding the specification and analyzed data according to client requirement.

Extensively worked in data Extraction, Transformation and loading from source to target system using Bteq, FastLoad and MultiLoad.

Ran queries through Teradata SQL Assistant.

Scheduled Jobs in Redwood Cronacle.

Monitored jobs in Redwood Cronacle and skipped the jobs, kicked off depends on requirement.

Gave permissions to Roles and users and partly played the role Admin.

Monitored, scheduled jobs and fixed bugs in production using Redwood Cronacle Job Scheduler.

Involved in writing scripts for loading data to target data Warehouse for Bteq, FastLoad, MultiLoad.

Performed statistical analysis of the data

Involved in unit testing and preparing test cases.

Used Mload scripts on UNIX platform for Teradata loads using Informatica.

Environment: Informatica Powercenter 7.0, Teradata SQL Assistant 6, Redwood Cronacle Scheduler, UNIX, SQL PLUS.

GE Health Care, USA Jul 2006 – Jan 2008

Asst Systems Engineer, TATA Consultancy Services Ltd.

(ETL Informatica Developer)

GE Healthcare is the world’s leading manufacturer of medical diagnostic equipment. Business Intelligence Systems provide reliable service to its clients with optimal response time and efficiency. The Business Intelligence system of the company has over 50 data marts that pull data from servers spread across the world.

Gained an understanding of existing Business Process, data transformation like parsing, mapping and serialization processes.

Involved in database design and documentation, normalization and de-normalization.

Studied existing system/ review using MD120 and migration checklists.

Developed Informatica mappings and workflows according to the given specifications.

Tested Informatica mappings, workflows and migrating these objects to QA and Production Environments.

Ran workflows through workflow monitor and checked the status.

Reviewed Cognos Reports, Models, Cubes, Cubeviews, and Packages in development environment and migrated these objects to QA and Production Environments.

Reviewed Bteqs, scripts, Jobchains in development dnvironment and migrated these objects to QA and Production Environments.

Scheduled Jobs in Redwood Cronacle.

Worked on Teradata Bteq, Mload, Fload scripts. Debugged on Teradata Bteq, Mload, Fload scripts.

Monitored jobs in Redwood Cronacle and skipped the jobs, kicked off depends on requirement.

Gave permissions to Roles and users and partly played the role Admin.

Monitored, scheduled jobs and fixed bugs in production using Redwood Cronacle Job Scheduler.

Reviewed and Deployed code from Dev to QA environment and from QA to Production environment.

Involved in migrations

Gained Advanced IIS 6 server administration and troubleshooting experience.

Capable of handling and deploying network-related equipment and hardware.

Involved in creating and managing repositories using Repository Manager in Informatica.

Solved Support central cases from users.

Ensured completion of jobs and communicating with the users in case of delays and failures.

Started and shut down different schedulers in Production, QA and Development environments.

Environment: Redwood Cronacle Scheduler, ETL/Informatica Powercenter 6.0, Terdata SQL Assistant 6, UNIX, SQL PLUS, Cognos Framework manager, Cognos Reportnet.

Contact this candidate