Jeevan Yarragudi
Domino’s Pizza
Carver,MN
1
Certification
15
years of professional experience
Detail-oriented Software Developer with extensive experience in the Software Development Life Cycle and Software Quality Assurance testing. Skilled in SQL, PL/SQL, and UNIX Shell scripting for relational databases, and proficient in ETL processes using Talend and Informatica. Experienced with multiple relational systems and file formats, and knowledgeable in OLTP/OLAP analysis and database schema development.
Work History
Sr. Data Operations Specialist
4 Years 10 Months- Performed regular system audits to verify the accuracy of various environments and applications, monitored Control-M batch processes, and troubleshot issues using Talend ETL tool, Database SQL scripts, Unix scripts, and SFTP Linux directories.
- Experienced in monitoring Databricks workflows and making sure that on-prem data is copied into the cloud daily.
- Extensively worked with the Data Warehouse team to create and export data scripts.
- Monitored file transfer activities via FTP, SFTP, MoveIt, and Axway to ensure data integrity and timely delivery.
- Assisted with data migration and disaster recovery activities.
- Checked Windows and Linux logs, and resolved performance issues by coordinating with DBA and data engineering teams.
- Extensively experienced in resolving ongoing Database issues/ ETL code bug fixes.
- Deployed new code and hot fix changes in production weekly.
- Extensively interacted with developers, business, and management teams to understand the project requirements and ETL design specifications.
- Documenting the resolution for known issues and being responsible for updating and maintaining the articles in the Confluence pages.
- Communicated issues to the incident teams to provide information to the vendors and customers.
- Identifying the risks proactively and proposing solutions to resolve them.
- Remain calm under pressure and ensure IT management and business stakeholders are kept fully updated on the progress of critical issues.
- Escalate issues and remediation steps effectively and promptly.
- Utilized Kafka and Confluent for real-time streaming applications to ensure data accuracy in dashboards.
- Environment and Technologies: MS SQL Server, Talend 8.0.1, Control-M, Kafka, Couchbase, Axway, File Zilla /WinSCP, Aqua Data Studio, Unix, Databricks, Github.
- Achievements:
- During the disaster recovery (unexpected power outage) on the weekend, actively participated in the Sev1 call and made sure that all ETL/Axway/Control-M/SFTP servers were turned on and functional as expected. Management appreciates my active participation efforts during the outage.
- Successfully upgraded Axway and Control-M servers to higher versions.
- All domestic and international stores send daily files (example: sales, orders, forecasts, inventory) through Axway secure transport. Axway servers went offline, and files were stuck in the middle layer. I manually collect all the files moved to the landing zone, where ETL files are processed. Later, I successfully automated the transfer of the files when they were stuck.
Software Developer in Test/ ETL Test Lead
1 Year 11 Months- Created complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
- Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
- Validated ODI packages to test ETL batch jobs and exceptions built in the jobs.
- Performed ETL Testing on ODI and SQL developer on Data Warehouse to validate source to target mapping.
- Logged defects using Quality Center and TFS while adhering to Agile/Scrum methodology for effective project management.
- Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using ALM.
- Coordinated user acceptance and quality assurance testing of mainframe and GUI applications, identified test data, prepared user manuals, conducted training seminars, and installed applications for end users.
- Extensively involved in the Performance testing of the programs, ETL Procedures and Processes.
- Conducted performance testing on programs, ETL procedures, and processes to ensure optimal system functionality.
- Used JIRA for Sprint stories creating, tracking and update for entire sprint.
- Achievements:
- Opportunity to lead and mentor team members.
Sr. Software Engineer (ODI ETL Developer)
5 Months- Collected analytics for business group for yearbook 2.0 application by extracting data from multiple sources and loading it into target as per business requirements, providing SQL scripts to business team for generating up-to-date reports.
- Extracted data from multiple sources and transformed it according to business logic, loading it into data warehouse for enhanced business reporting.
- Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
- Modify existing ETL jobs in Oracle Data Integrator (ODI).
- Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios, ODI Functions, ODI Mappings, ODI Load Plans.
- Created variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
- Experience in Performance Tuning and Debugging of existing ETL processes.
- This project involved extraction of data from multiple sources and transform the data as per the business logic and is loaded into the data warehouse which is finally used for business reporting.
- Performed daily, weekly, and monthly ad-hoc analysis and communicated with the business to present relevant results.
- Created Informatica mappings, mapplets, worklets, and workflows to effectively populate data from various sources into the data warehouse.
- Created Global Prompts, Narrative Views, Charts, Pivot Tables, and Compound layouts to design the dashboards.
- Facilitated load testing and benchmarked the developed product against the set performance standards.
- Responsible for facilitating load testing and benchmarking the developed product against the set performance standards.
- Environment and Technologies: Oracle Data Integrator 11.1, Oracle 11g, Flat files, Toad, SQL developer, WinSCP, UNIX.
Data/System Quality Analyst
1 Year 10 Months- Extensively performed ETL testing process to ensure the quality of the application.
- Participated in daily status meetings, facilitating communication between development and business teams.
- Created test Scripts, test plans, test summary and Traceability matrix documents based on technical specifications documents, BRD and FSDs.
- Designed and executed test cases on the application according to organization and project standards.
- Design and execute the test cases on the application as per Organization and Project standards.
- Identified duplicate records in the staging area to ensure data accuracy. in the staging area before data gets processed.
- Identifying duplicate records in the staging area before data gets processed.
- Executed test cases and test scripts for ETL testing. Defects are raised in the HP Quality Center/HP ALM for logging or send email notification to Development and BA team.
- Worked in multiple projects for EDWH Group for all testing activities related to ETL.
- Reviewed and updated the team to provide timely processes that increased productivity.
- Executed test cases for ETL testing to validate data transformations. and test scripts for ETL testing. Defects are raised in the HP Quality Center/HP ALM for logging or sending email notification to Development and BA team.
- Environment and Technologies: Teradata SQL Assistant, Oracle 11g, Flat files, Toad, SQL developer, Abinitio ETL tool.
Software Engineer (ETL Developer)
8 Months- Design, develop, test, migrate and implement ETL mappings and jobs for a new regulatory subject area within Valspar’s Enterprise Data warehouse.
- Develop and execute optimized ETL mappings and jobs as per industry best practices and standards.
- Identified impacts to ETL data flows to enhance data quality and maximize organizational value of information.
- Performed tactical data analysis, data integration, migration, unit testing, and regression tasks during application development life cycle with limited supervision.
- Proactively identify any impacts to ETL data flows and data to maximize the value of information across the organization.
- Perform tactical data analysis, data integration, migration, unit testing and regression tasks as part of application development life cycle with limited supervision to provide a high data quality solution.
- Created ETL technical documentation and knowledge transfer materials to facilitate team understanding and project continuity.
- Collaborate with business analysts, project managers, data architects, technical leads and DBA’s to understand and implement the business and technical requirements.
- Involved in Migration process of moving all the informatica objects from Informatica 8.6 to Informatica 9.6 and in this process building an entirely new enterprise data warehouse (BIW).
- Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
- Extensively worked on Data warehouse Administration Console (DAC) to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads.
- Involved in actively working with the BA's, SA's to verify all requirements are met and worked closely with the Project Managers on quality deliverable.
- Participated in the migration process to move all Informatica objects from Informatica 8.6 to Informatica 9.6 and built a new enterprise data warehouse (BIW).
- Perform code review process with technical ETL team.
- Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.
- Involved in actively worked with the BA's, SA's to verify all requirements are met and worked closely with the Project Managers on quality deliverable.
- Used SQL Developer to execute SQL queries and perform any query tuning etc. UNIX shell scripts to write wrapper scripts to call ETL Jobs, FTP, and File-watcher Automation, PMCMD Automation, etc.
- Environment and Technologies: Informatica Power Center 9.6.1, Oracle 11g, Flat files, Toad, SQL developer, WinSCP, UNIX.
- Environment and Technologies: Informatica Power Center 9.6.1, Oracle 11g, Flat files, Toad, SQL developer, WinSCP, UNIX.
ETL Consultant
3 Years 6 Months- Contributed to the EDW team as a junior developer by building and maintaining data pipelines that extracted data from various sources, transformed it into a usable format, and loaded it into a data warehouse or other target systems. They ensure data is accurate, reliable, and readily available for reporting, analytics, and business operations.
- Collaborated with business analysts and DBA to gather requirements, analyze business needs, and design data warehouse solutions.
- Designed logical and physical models for staging, transition, and production warehouses using Erwin 4.0, ensuring alignment with project specifications.
- Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin4.0.
- Developed a mapplet to streamline data transformation processes. and used them in different Mappings.
- Utilized sorter transformation to organize data sets for improved processing. and newly changed dynamic lookup.
- Established events in workflows to automate data processing tasks. and tasks in the workflows using workflow manager.
- Developed and optimized Informatica mappings, enhancing performance for data extraction and transformation processes.
- Created schema objects like Indexes, Views, and Sequences.
- Environment and Technologies: Informatica Power Center 8.6, Workflow Manager/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL, TOAD, SQL
- Loader, Sun Solaris 2.6, UNIX Shell Scripting.
- Key Achievements:
- Delivered production support for the ETL of the DCS (distribution control systems) mainframe application in Cobol and Informatica to the IW (Information Warehouse) Oracle database.
Education
Master of Science - Information Security Systems
Masters degree - Electrical Engineering (Digital signal processing)
Skills
Operating systems expertise
Programming Languages: SQL
PL/SQL
Python
ETL tools: Talend
ODI
Informatica
DataStage
Domains: E-commerce
Banking
Logistics
Food Industry.
Data visualization
Operating Systems: Windows (XP
Vista
7
8)
Linux
UNIX
Tools: MS Office
HP QC/HP ALM
Ethereal
Data Visualization
MS Access
Data Engineering
Scheduling tools knowledge
Certification
Azure Basic fundamentals (AZ-900)
Timeline
Sr. Data Operations Specialist
Domino’s Pizza
10.2021 - CurrentRead More
Software Developer in Test/ ETL Test Lead
Wells Fargo
10.2019 - 09.2021Read More
Sr. Software Engineer (ODI ETL Developer)
Lifetouch Studios
04.2019 - 09.2019Read More
Data/System Quality Analyst
Wells Fargo
06.2017 - 04.2019Read More
Software Engineer (ETL Developer)
Valspar
09.2016 - 05.2017Read More
ETL Consultant
Keymouz Technologies
01.2012 - 07.2015Read More
Blekinge Institute of Technology
Masters degree from Electrical Engineering (Digital signal processing)
Read More
University of the Cumberlands
Master of Science from Information Security Systems
Read More