Sai Ganesh G Email & Phone Number

Hyderabad, Telangana, India

Currently i'm Leading an project involving a 'complete reporting base' migration from Discoverer to Oracle Analytics Cloud, Along with leading/mentoring a team of 5.*Also involved in creation of Bots (involving report export functionalities etc, to reduce the dependency on the external reporting tools, to improve efficiency of the current data flows )

Hyderabad Area, India

During my tenure as an Senior Programmer Analyst , * Lead few projects dealing with gathering requirements & collaborating with multiple teams involving various technologies.* I was provided an opportunity to Lead a project and work on few enhancements in PL/SQL and during this process i had removed few long pending bugs and improved the performance along with providing few insights to improve further.* Provided few End to End solutions involving creation of new ETL processes to load data (In informatic and Infa-Cloud) and Reporting solutions spread across multiple tools.-------- Performance Engineering & Re-Designing ----------* Improved the performance of multiple critical Qlikview apps by more than 90% , by providing or redesigning the existing Data Loading process and by utilizing cloud features of Snowflake DB and Data loading by Infa -Cloud . This helped in cleaning up the Qlik Server processing and also made sure the Qlik Server consumed less memory , improving the overall health.* Worked on Improving the performance of few long running Tableau DataSources by more than 85% .* Lead a project involving migration of Discoverer reports to to Tableau or OBIEE. Was part of analysis and provided insights helping in decision making and understanding which tool is best suited for what.-------- Automations ----------* Have provided few automation solutions (Scripting in Python) to improve the current process . few of the solutions which i have automated are , the QA process for a scheduling tool migration where in the DB objects and Data comparison is required. reducing close 70% of manual effort.*Automated Dashboard/Reports export process using Python scripting , to enhance the end to end flow .

Hyderabad, Telangana, India

During my tenure as Technology Lead in Infosys , my responsibilities would be • Leading a team of 5 from offshore, who would work on different areas as individual contributors. I along with mentoring them , would also gather requirements for those areas, I would also be responsible in gathering the feedback from client for the team as a lead and evaluating the performance annually. • My day - to -day activities mostly involve around Configuring and developing the Analytics which involves in creating Dashboards, Reports, Prompts and adding UI level customizations such as Graph’s, pivot views, Navigation links etc• Would work on Data Modeling aspects such as Creation/Development of repository (.rpd) which involves schema import, Implementing the business logic by customization, dimensional hierarchies, Aggregate Navigation, level-based measures, Security management (Data level/Object level security), Variables, Initialization blocks and cache management.• On demand basis worked on Creating various mappings and scheduling, in Informatica.• Worked on creating few complex scenarios and provided various solutions to enhance the performance of the loads.• Involved in Business review meeting on new features available in OBIEE 11g for upgrade and provided customizations as required.

Hyderabad Area, India

While working as an IT Analyst in TCS , I got an opportunity to work in Western Union project and my responsibilities would be : • Leading a group of 8. This team is responsible for creating a Data warehouse and maintaining. Also acted as POC for TCS team for various management activities, as this project was done under CMC management.• Interacting with customer’s on gathering business requirements and handling issues on the customer site. Creation of various mappings and data flows using different transformations from various source systems (to be specific 17 source systems, sources include files and DB). Created workflows in PL/SQL scripts for handling 17 flows and scheduling the incremental loads in Unix. Monitoring the data flow process including the scheduled Informatica tool runs. Working with the ETL failures to resolve issues.• Automated a complete manual process of Merge – Demerge of Accounts through a complex PL/SQL module. Performance tuning (Adding and removing indexes, creation of bulk loads, adding commit levels based on the mapping, adding procedural transformations) and Improvising or bettering the processes by creating mapplets. Created PL/SQL code blocks such as Procedures, Triggers, Packages and Functions as part of data corrections and cleansing.

Chennai Area, India

As a systems Engineer ,i was fortunate enough to get a chance in working for a Client - British Telecomm and my responsibilities would be :• Developing PL/SQL scripts in SQL Server 2005 , while working as a DB developer in IBM DB2.• Creating and modifying reports in ORBIT application.Few of my noteworthy achievements would be creation of few bots to improve the existing processes in the projects , i was working on , few of them being o RCA (Helps the production support team, in creating documents for production fixes)o NE Tool (Collects the information from an NE tool extension formatted images and creates a CSV file. This automation reduces 240 man hours a day into less than 5 mins effort) .

Bachelor Of Technology - Btech, Computer Software Engineering

Ssc