Krishna Prasanth Email and Phone Number
• Having around 5.5 years of experience of Professional experience in IT industry, Involved in projects with extensive usage of ETL tool like SQL Server Integration Services (SSIS) and SQL Server, Dataware House and Data Modelling• Experience in Data Modeling, data warehousing, data descriptive analysis.• Experience in data model creation technologies.SQL and TSQL:• Develop high-quality database solutions,Use T-SQL to develop and implement procedures and functions.• Review and interpret ongoing business report requirements.• Analyze existing SQL queries for performance improvements.• Develop procedures and scripts for data migration.• Provide timely scheduled management reporting.Data warehousing concepts:• Have a good knowledge on data warehousing concepts.• Good at data warehouse architecture• Good at identifying dimensions and facts.• Good at OLAP types and its operationsSSIS (ETL TOOL):• Good exposure to building ETL solutions using SSIS.• Used transformations for building data flows as per business requirements.• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse.Tableau:• Good in creating visualizations based on requirement. • Experience in development of Sheets, Dashboards. • Good experience regarding creation of different types of graphs and charts. • Have a good experience on different data source formats such as excel etc. Data Modelling:• Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and MSSQL) and data tools (reporting, visualization, analytics).• Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.• Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.• Hands-on modelling, design, configuration, installation, performance tuning, and sandbox POC.• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
Circana
View-
Senior Software EngineerCircana Feb 2024 - PresentBengaluru, Karnataka, IndiaProject: Campari, Heineken, LindtClient: Campari, Heineken, Lindt Technologies: SQL Server, SSIS, AS Model, Unify, Linux Project abstract:The objective of this project is to process the data and help client in generating the report as per their requirementRoles and Responsibilities:• Loading the data from end to end i.e., receiving the source files to the data release team.• Load the data using the ETL process to the database.• Make the required changes in the reference data whenever there are issues with the predefined data.• Load the data into a QC model and perform the QC. If there are any issue identified during QC, address and fix them. Once everything looks good then inform to CS team.• Once CS team confirm then we will push the data to LV model.• Creating Unify report.• Finding the root cause and fix the issues if any.• Loading the data within the deadline time
-
Senior Software EngineerHarman India Jan 2023 - Jan 2024Bengaluru, Karnataka, IndiaProject: IRI App Services and ADC expansionClient: IRI Role: Data ModelerSkills: Data Modelling, Data descriptive analysisTechnologies: AS modelling workbench, OMS tool, Automation, MONET DB, Linux Project abstract:IRI is a data analytics and market research company, headquartered in the U.S. which provides clients with consumer, shopper, and retail market intelligence and analysis focused on the consumer-packaged goods, retail, and healthcare industries. IRI is focused on Market Performance and Strategy market Performance and Strategy Analytics and In-Market Execution.Roles and Responsibilities:• I am part of data modelling team which delivers data models for European countries. • Specifically, I am part of France and Italy team. We use AS workbench for model creation and validations. • Daily tasks include DB management, data integration and validation. • Based on client request workflow includes use of Automation, OMS tool, Repo Audit etc. • Our team provide model for prediction and data insights to various clients. • Also, not only France and Italy model now I have experience of working on other country models. -
Software EngineerAroha Technologies Sep 2018 - Dec 2022Bengaluru, Karnataka, IndiaProject: VKS Foods Private LimitedClient: Source Edge Role: Software EngineerTechnologies: SQL & SSIS, TableauProject abstract:VKS Farms Private Limited is the most renowned company that involved in processing, supplying, exporting, and trading a wide array of Processed Chicken, Yellow Maize, White Salt, Buffalo Meat and White Egg. It was emerged in the year 2000 at Coimbatore in Tamil Nadu, India. The company has a diverse product mix of chicken, egg, meat, and salt and apart from catering to domestic market; it exports to over 30 countries. The analysis of complete end to product cycle right from farming to delivery of finished goods was losing visibility with the growth of the company and hence the solution was delivered to ensure full visibility. The data from each phase of the product finishing is pushed into a single consolidated area for analysis.Roles and Responsibilities:● Involved in understanding the project requirements and the entities available in the project.● Document designs based on requirements.● Created the database objects like Stored Procedures, Functions and Views● Developer SSIS solutions for data moves from the source to target systems.● Connected to file systems and database systems as sources.● Handled loads of dimensions and facts and aggregate tables● Implemented incremental extract and loads.Responsibilities as a Tableau Developer● Analysed the business logic and requirements.● Developed different visualizations as per requirement using various graphs such as Bar graphs, Line graphs, Maps, Bubbles, Heat maps and combination charts.● Worked on parameters, filters, groups, and calculated fields while generating dashboards.● Used MS Excel sheets, SQL Server databases as data sources to generate Tableau worksheets and dashboards.● Worked on importing and exporting workbooks.● Created interactive Dashboards for different related worksheets.● Developed dashboards and stories as per requirements in Tableau.
Krishna Prasanth Education Details
-
Mechanical Engineering -
Dhalakshmi Srinivasan Higher Secondary SchoolComputer Science
Frequently Asked Questions about Krishna Prasanth
What company does Krishna Prasanth work for?
Krishna Prasanth works for Circana
What is Krishna Prasanth's role at the current company?
Krishna Prasanth's current role is Senior Engineer in Product Development at Circana | Ex-Harman | MS SQL Server | SSIS | Dataware House | Tableau | SSRS | Linux | Data Modelling.
What schools did Krishna Prasanth attend?
Krishna Prasanth attended Rajalakshmi Institute Of Technology, Dhalakshmi Srinivasan Higher Secondary School.
Not the Krishna Prasanth you were looking for?
-
-
Krishna Prasanth (KP)
Founder - Slate Education Foundation | Global Recruitment Manager - Lewis University, Chicago | Consultant - Strategic Initiatives & Market EntryChennai -
-
Krishna Prasanth
Cse Student At Mar Baselios College Of Engineering And Technology(Autonomous) | Thiruvananthapuram | KeralaThiruvananthapuram
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial