Sivanarayana YAGANTI
Wilsele,VBR
Summary
Business intelligence professional with strong history in delivering impactful data solutions and analytics. Adept at harnessing data to inform strategic decisions and optimize business processes. Known for fostering collaborative team environments and adapting to evolving project requirements, showcasing skills in data visualization and stakeholder communication.
Overview
19
19
years of professional experience
1
1
Certification
Work History
BI Consultant
Quest-Tek Solutions BV
11.2022 - Current
- Monitoring the 'Test' and Production Qlik dashboards as part of daily OPS
- Responsible for getting the requirements from the Business users and developing the Qlik sense dashboards
- Fixing the data and reload issues
- Creating automated BODS jobs for checking the data issues in Qlik reports and to identify any data quality issues
- Giving training to business users on Qlik dashboards
- Responsible for developing and testing jobs for new releases
- Involving in code review
- Responsible for migrating the code to different environments
- Checking the Qlik dashboard and comparing with Test before moving the code to Production
BI Consultant
European Dynamics
05.2022 - 10.2022
- Responsible for getting the requirements from the Business users and developing the Qlik sense dashboards
- Fixing the data and reload issues
- Creating automated BODS jobs for checking the data issues in Qlik reports and to identify any data quality issues
- Giving training to business users on Qlik dashboards
- Responsible for developing and testing jobs for new releases
- Involving in code review
- Responsible for migrating the code to different environments
- Checking the Qlik dashboard and comparing with Test before moving the code to Production
BI Consultant
OneSource Consulting SPRL
03.2020 - 04.2022
- Creating automated BODS jobs for checking the data issues in Qlik reports and to identify any data quality issues
- Monitoring the TEST and ACCEPTANCE Qlik dashboards as part of daily OPS
- Involved in meetings with the Business stakeholders and prepared technical documentation by understanding the business logic
- Created guidelines to follow throughout the development process
- Documenting and involved in discussions within the team about the solved issues
- Responsible for developing and testing jobs for new releases
- Responsible for creating and updating the data model changes in SAP Power designer
- Involving in code review and supporting the team wherever needed
- Responsible for moving the code to different environments
- Checking the Qlik dashboard and comparing with acceptance before moving the code to Production
- Involved in sprint planning and updating tasks in JIRA
- Created Confluence page with all the information for each development task
IT Consultant
GeekSoft Consulting GMBH
11.2018 - 01.2020
- Company Overview: Germany
- Involved in quoting the estimated hours for the given requirements
- Responsible for extraction of data from different ERP systems and apply transformation rules and load to target system
- Responsible for migration of the projects by getting mapping rules from the business
- Created reports in Qlik sense and validating the data in the report
- Modified existing reports and loader files as per business needs
- Worked as shadow resource for Qlik activities
- Loading data to SAP MDG and running the consolidation after loading
- Created jobs, workflows and data flows as per the requirements
- Used different transformations like query transform, table comparison etc
- Involved in unit testing by reconciling the BODS data with Oracle data by running the queries
- Germany
Module Leader
IDC Technologies
05.2018 - 07.2018
- Company Overview: Chennai, India
- Supporting the project by monitoring the Production jobs
- Responsible for daily activities apart from the development activities
- Monitoring the report activities and sending mails to the team with latest update
- Involved in daily meetings with the client and business to understand the enhancement requirements
- Created incidents and tickets by using SNOW (Service now) tool
- Developing and unit testing the jobs
- Did lot of analysis on existing jobs and made changes to make the output accurate
- Working on production issues and given solution by understanding the business
- Involved in cross team code review
- Chennai, India
Module Leader
Kumaran Systems
07.2015 - 04.2018
- Company Overview: Chennai, India
- Designed BODS Jobs by understanding the Informatica code
- Involved in meetings with business users to get clarifications about the requirements when needed
- Worked on up gradation of the projects from BODI 3.2 to BODS
- 4.2
- Prepared the DB scripts when needed and involved in deployment procedure
- Responsible for monitoring the QA jobs through Data Services Management Console as a daily activity
- Used SVN tool for version control and responsible for deploying the code from development environment to QA environment
- Responsible for running the jobs in QA and sharing the output results
- Worked on production issues, apart from regular activities in the Sprint
- Applied various performance-improving techniques like Pushdown SQL etc to reduce the run time of the job
- Involved in ETL code review and end to end testing
- Prepared the Unit testing documents and QA testing documents for getting UAT approval
- After getting the approval checking-in the latest code to central-repository to keep in sync with Production code
- Chennai, India
IT Consultant
DP World
10.2014 - 06.2015
- Company Overview: Dubai
- Worked individually from onsite
- Converted PL\SQL code into BODS jobs by understanding the Procedures
- Preparing the requirement specification documents
- Designed ETL Jobs based on the business requirement by using BODS Tool
- Monitoring the production jobs through Console
- Implemented Delta load approach by creating LOG Tables
- De-bugging the previous developed jobs and gave solution
- Dubai
Sr. Technical Specialist
Thirdware Technology Solutions
03.2013 - 09.2014
- Company Overview: Chennai, India
- Understanding the requirement specification document and updating the issue log wherever clarifications are needed
- Designed ETL Jobs for the Staging and Presentation database tables
- Used SAP BODS tool to design and develop various jobs for DWH tables
- Used different Objects for creating Workflows and Dataflow for initial and Delta loads
- Worked on files and loaded to target Database by applying validation rules using validation object
- Responsible for exporting the ATL files to place in central repository
- Prepared the Unit Test and Reconciliation SQL queries for data validation as per ETL requirement
- Documenting the test results
- Chennai, India
ETL Developer
Thirdware Technology Solutions
01.2011 - 03.2013
- Company Overview: Chennai, India
- Worked on Agile methodology for quick deliverables
- Understanding of ETL specifications and develop the jobs
- Responsible for extraction, transformation and loading of data from flat files to data warehouse
- Worked on couple of e-trackers
- Involved in attaching test results and all the documents to the e-tracker
- Used various Data Integrator Transformation Objects
- Created BODI jobs by understanding the Data stage jobs
- Implemented SCD Type-1 and Type-2 Jobs
- Worked on some enhancements using Data stage tool
- Attending weekly code reviews with business analyst and Project Manager
- Attending weekly status meetings APA (Asia Pacific Africa) as well as NA(North America) and explaining the status of the week
- Running the jobs in QA using Autosys scheduler Tool
- Chennai, India
ETL Developer
iGrid Technologies
12.2008 - 01.2011
- Company Overview: Hyderabad, India
- Worked on Agile methodology for quick deliverables
- Understanding of ETL specifications and develop the jobs
- Responsible for extraction, transformation and loading of data from flat files to data warehouse using data stage
- Worked on couple of e-trackers
- Involved in attaching test results and all the documents to the e-tracker
- Used various Transformations in data stage
- Implemented SCD Type-1 and Type-2 Jobs
- Attending weekly code reviews with business analyst and Project Manager
- Attending weekly status meetings APA (Asia Pacific Africa) as well as NA (North America) and explaining the status of the week
- Running the jobs in QA using Autosys scheduler Tool
- Hyderabad, India
ETL Developer
Info biz Technologies
09.2005 - 12.2008
- Company Overview: Chennai, India
- Worked on Agile methodology for quick deliverables
- Got training and supported team in development activities
- Understanding of ETL specifications and developed Data stage jobs
- Responsible for extraction, transformation and loading of data from flat files to data warehouse using data stage
- Implemented SCD Type-1 and Type-2 Jobs
- Supported the team in documentation
- Attending weekly status meetings APA (Asia Pacific Africa) as well as NA (North America) and explaining the status of the week
- Chennai, India
Education
Bachelor - Computer Science
Vinayaka Missions university
06.2005
Skills
- SAP DATA SERVICES
- Qlik Sense
- Data stage 75x
- Power Designer
- SAP MDG
- Oracle 11g
- Teradata
- SNOW ticketing tool
- Autosys Scheduler tool
- JIRA
Accomplishments
Got appreciation certificates from the client FORD.
Received a very positive feed back in Linkedin from my previous manager from Merck,Darmstadt.
Worked in Dubai,Australia and Germany.
Personal Information
- Date of Birth: 08/17/84
- Nationality: Indian
Certification
Qlik sense Data Architect
Manual Testing
Athletics (Sprinting)
Got several medals including University gold medalist with 100 mts 10.90 second best timing.
Got 4th place in PK masters-2024,Belgium with 13.04 seconds 100 mts in 2024.
Languages
Telugu
Bilingual or Proficient (C2)
Tamil
Intermediate (B1)
English
Advanced (C1)
Dutch
Intermediate (B1)
French
Beginner (A1)
Timeline
BI Consultant
Quest-Tek Solutions BV
11.2022 - Current
BI Consultant
European Dynamics
05.2022 - 10.2022
BI Consultant
OneSource Consulting SPRL
03.2020 - 04.2022
IT Consultant
GeekSoft Consulting GMBH
11.2018 - 01.2020
Module Leader
IDC Technologies
05.2018 - 07.2018
Module Leader
Kumaran Systems
07.2015 - 04.2018
IT Consultant
DP World
10.2014 - 06.2015
Sr. Technical Specialist
Thirdware Technology Solutions
03.2013 - 09.2014
ETL Developer
Thirdware Technology Solutions
01.2011 - 03.2013
ETL Developer
iGrid Technologies
12.2008 - 01.2011
ETL Developer
Info biz Technologies
09.2005 - 12.2008
Qlik sense Data Architect
Manual Testing
Bachelor - Computer Science
Vinayaka Missions university
Similar Profiles
RamyaSri KoyaRamyaSri Koya
Jr Pega Developer at Rayon Tek Solutions INCJr Pega Developer at Rayon Tek Solutions INC
Lilly McDanielLilly McDaniel
QA Automation Tester at Alliance Tek SolutionsQA Automation Tester at Alliance Tek Solutions
Durga S LDurga S L
Java Developer at SL Tek Solutions IncJava Developer at SL Tek Solutions Inc