Praveena Gotru
Senior Data Engineer at TTI, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Hindi Native or bilingual proficiency
-
Telugu Native or bilingual proficiency
Topline Score
Bio
Stephane Bratu
Praveena did a fantastic job building and managing the ETL processes for the analytics group at TTI. She is a great data architect and problem solver. She found effective solutions to architect the loading, cleaning and mapping of complex data streams into our decision support systems as well as delivering the recommendations to the different platforms. Praveena is very easy to work with and does everything possible to ensure the success of the projects she is responsible for. It has been great to work with Praveena.
Stephane Bratu
Praveena did a fantastic job building and managing the ETL processes for the analytics group at TTI. She is a great data architect and problem solver. She found effective solutions to architect the loading, cleaning and mapping of complex data streams into our decision support systems as well as delivering the recommendations to the different platforms. Praveena is very easy to work with and does everything possible to ensure the success of the projects she is responsible for. It has been great to work with Praveena.
Stephane Bratu
Praveena did a fantastic job building and managing the ETL processes for the analytics group at TTI. She is a great data architect and problem solver. She found effective solutions to architect the loading, cleaning and mapping of complex data streams into our decision support systems as well as delivering the recommendations to the different platforms. Praveena is very easy to work with and does everything possible to ensure the success of the projects she is responsible for. It has been great to work with Praveena.
Stephane Bratu
Praveena did a fantastic job building and managing the ETL processes for the analytics group at TTI. She is a great data architect and problem solver. She found effective solutions to architect the loading, cleaning and mapping of complex data streams into our decision support systems as well as delivering the recommendations to the different platforms. Praveena is very easy to work with and does everything possible to ensure the success of the projects she is responsible for. It has been great to work with Praveena.
Experience
-
TTI, Inc.
-
United States
-
Appliances, Electrical, and Electronics Manufacturing
-
700 & Above Employee
-
Senior Data Engineer
-
Jun 2022 - Present
-
-
Data Engineer
-
Feb 2017 - Jun 2022
--> Azure Data factory , Azure Databricks ,Azure Data Lake Gen2 ,PySpark.--> Python--> Data management, automation of processes, as well as developing advanced analytics algorithm.--> Developing high performance demand forecast models using the big data environment and implement different clustering methodologies to identify Key Value Items.--> Data Architect, build the database and does the dimensional modelling.--> Develop packages to extract data from different data sources and from different servers.--> Proficiency in SQL 2008R2/2012/2016.-->Expertise in all reporting services like Power BI, SSRS, tableau ,QlikSense , Crystal Reports.--> Build SSAS cubes, more slicing and dicing with MDX quering.-->Data Analytics with Pandas, Numpys and different packages. Show less
-
-
-
Tata Consultancy Services
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
Data Administrator\BI Developer
-
Jul 2013 - Dec 2016
⦁ Designed Informatica Mappings, Sessions, Workflows and handled data files. ⦁ Developed SQL scripts from scratch like creating tables,triggers,indexes, views stored procedures. ⦁ Experience in SSIS, SSAS, SSRS for creating packages, data flows, control flows, handling data. ⦁ Implemented Many SSIS Packages and Jobs to assist with daily running queries. ⦁ Developed many SSRS Reports and Integrated them to SharePoint. ⦁ Installation and Administration of SQL Server 2008r2, 2012 and 2014 databases on servers in a multiple database server, high availability environment. ⦁ In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views for speedy performance. • Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Sales Force Data according to the business logic. • Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency. • Worked extensively on fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data. Worked extensively on SQL, PL/SQL and UNIX Shell Scripts. ⦁ Performed unit testing and end to end testing for the medical drug online order website. ⦁ Served as a point of contact for vendors and coordinates all transmissions. ⦁ Assisted in designing online website to order medical drugs by its customers. ⦁ • In Informatica Analyzed the source data coming from different sources (Oracle, DB2, Flat files and Mainframes) and working with business users and developers to develop the Model. • Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process. Show less
-
-
Education
-
2015 - 2016
The University of Texas at San Antonio
Master's degree Thesis, Computer Engineering -
2009 - 2013
Jawaharlal Nehru Technological University
Bachelor of Technology (BTech), Electrical, Electronics and Communications Engineering
Community
