Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Panda Saiteja

Senior Data Analyst I
Hyderabad

Summary

Senior Data Analyst I

Around 5+ Plus Years of experience in Business Intelligence and Reporting tools.

Experienced in providing solutions to variety of requirements and creating the objects using Power BI.

Worked on creating reports, visualizations and dashboards by using Power BI.

Worked on solutions around Power BI Limitations with license like export options, column layouts, column optimization etc. Experienced with Row Level Security using the DAX functions and successful deployment.

Expert with ETL and ELT tools like ODI,Tableau,OBIEE.

Experienced on deploying stored procedures and mappings using ODI components.

Experience with ODI Variables, Sequences, Scenarios, Procedures, Knowledge modules, interfaces and Packages, load plans.

Overview

5
5
years of professional experience
6
6
years of post-secondary education
1
1
Certification

Work History

Developer

Linde Inc:Mexico Cognos to Oracle Migration
06.2022 - 12.2022

Linde plc is a global multinational chemical company founded in Germany and, since 2018, domiciled in Ireland and headquartered in the United Kingdom. Linde is the world's largest industrial gas company by market share and revenue. It serves customers in the healthcare, petroleum refining, manufacturing, food, beverage carbonation, fiber-optics, steel making, aerospace, material handling equipment (MHE), chemicals, electronics and water treatment industries.

Some of the activities / responsibilities include:


• Developed Reports in OBIEE .

• Worked with the team in all aspects of development activities on the project.

• UAT Support such as Data Validation and fixing the issues.

Developer

Williams-Sonoma
06.2020 - 06.2022

Williams-Sonoma is an American publicly traded consumer retail company that sells kitchenwares, home furnishings and one of the biggest multi-channel specialty retailers in the world.


Some of the activities / responsibilities include:


• Completely involved in monitoring the system 24/7 to make sure the jobs are running fine.

• Completely involved in monitoring the system 24/7 to make sure the tableau jobs are running fine.

• Involved in Data profiling.

• Involved in interacting with the business and get the requirements.

Developer

Gildan
01.2019 - 09.2022

Gildan Activewear Inc. is a Canadian manufacturer of branded clothing, including undecorated blank activewear such as t-shirts, sport shirts and fleeces, which are subsequently decorated by screen printing companies with designs and logos. The company also supplies branded and private label athletic, casual and dress socks to retail companies in the United States including Gold Toe Brands, PowerSox, SilverToe, Auro, All Pro.


Some of the activities / responsibilities include:

• responsible for Analysis and developing Extraction, loading and Transformation process using ELT tool ODI 11g.

• Worked on ODI tool- Developer, Operator and Topology.

• Worked with Knowledge modules like LKM’s, IKM’s.

• Prepared QA validation scripts and Unit test case documents.

• Debugging the data issues from warehouse to source.

• Prepared specification documents for the customizations and new developments.

Developer

Hitachi Vantara Project
08.2019 - 03.2020

EDW to EDP Migration EDW system maintains the sales information of Hitachi products from different sources like Oracle, Sales force and Sibel. This enterprise stores complete information ab booking, backlog, and billing (BBB) and reporting must have accurate, timely, and consistent BBB reporting to make quarterly operational decisions, so they can improve sales, margins, fulfillment, customer service, and revenue reporting activities. They need the right summary data plus rapid access to supporting details.


Some of the activities / responsibilities include:


• Converting the reports from OBIEE to Power Bi .

• Implementing the row level security and scheduling the report in Power bi Report Server.

• Created different types of reports like Table, Matrix and graphs. Implemented drill through ,drill down, bookmark and created complex calculation like Running total.

• I implemented work around which are not supported by Power Bi while converting the OBIEE reports in to Power Bi.

Developer

Hitachi Sales Compensation
06.2019 - 08.2019

Migrate the existing Sales Compensation Reporting Process to the Enterprise Data Platform. Keeping this system completely isolated from the rest of the data lake and data warehouse systems Integrate the EBS HR data and Xactly data to the EDP platform Sales Compensation changes annually, need to accommodate this process

Some of the activities / responsibilities include:

• Creating transformations and jobs for stage and target loads in pentaho framework.

• Job Automation for all the file loads.

• UAT Support such as Data Validation and fixing the issues.


Developer

Praxair Prisim
01.2019 - 05.2019

Some of the activities / responsibilities include:


· Worked on the Praxair PRISM Project – Integrating the SQL Server and PL/SQL data into a common data warehouse.

· Analyzed the SQL SERVER queries and PL/SQL queries to develop mappings in ODI 11g and created lineage document for queries

· Primarily responsible for Analysis and developing Extraction, loading and Transformation process using ELT tool ODI 11g.

· Worked with the team in all aspects of development activities on the project.

· Worked on transpose the Columns in ODI

· Worked on Spliting the Columns in ODI.

· Worked on preparing the technical specifications and other requested documents.

· Worked with the team in all aspects of development and migration activities on the project.

Production Load Monitoring

Koos Manufacturing, Inc
02.2018 - 02.2019

Koos Manufacturing, Inc. is the premier denim jeans manufacturer in Los Angeles. The only vertically integrated jeans factory on the West Coast, every step from design, cutting, sewing, washing, and finishing are performed in one facility.

Some of the activities / responsibilities include:


· Production Load Monitoring

Utility Tester

Pacific Gas and Electric
09.2017 - 10.2018

The Pacific Gas and Electric Company (PG&E) is an investor-owned electric utility (IOU) with publicly traded stock [3] that is headquartered in the Pacific Gas & Electric Building in San Francisco. PG&E provides natural gas and electricity to most of the northern two-thirds of California, from Bakersfield almost to the Oregon border which represents 5.2 million households.


Some of the activities / responsibilities include:


· Involved in Data extraction from BQY Files.

· Involved in BQY Files data validation with Exported CSV files.

Education

B. Tech - Computer Science Engineering

Mallineni Peramallu Educational Society
08.2012 - 05.2016

12th -

Gowtham Junior College
05.2010 - 04.2012

10th -

Little Chandra’s Public School
06.2009 - 03.2010

Skills

    Power BI

undefined

Certification

70- 778 Analyzing and Visualizing Data with Power BI certification

Timeline

Developer

Linde Inc:Mexico Cognos to Oracle Migration
06.2022 - 12.2022

Developer

Williams-Sonoma
06.2020 - 06.2022

Developer

Hitachi Vantara Project
08.2019 - 03.2020

Developer

Hitachi Sales Compensation
06.2019 - 08.2019

Developer

Gildan
01.2019 - 09.2022

Developer

Praxair Prisim
01.2019 - 05.2019

Production Load Monitoring

Koos Manufacturing, Inc
02.2018 - 02.2019

Utility Tester

Pacific Gas and Electric
09.2017 - 10.2018

B. Tech - Computer Science Engineering

Mallineni Peramallu Educational Society
08.2012 - 05.2016

12th -

Gowtham Junior College
05.2010 - 04.2012

10th -

Little Chandra’s Public School
06.2009 - 03.2010
Panda SaitejaSenior Data Analyst I