Karthik Kunala Venu Email & Phone Number

Adelaide, SA, AU

Adelaide, South Australia, Australia

Adelaide, South Australia, Australia

• Design and develop SSIS packages to move data from various sources into destination flat files and EDW
• Develop tables, constraints, views, indexes, stored procedures, functions, and database mail configuration in SQL Server
• Design data modelling using dimensions and fact tables with STAR schema in SQL Server Analysis Services (SSAS) or Power BI
• Develop high-quality analytical reports with self-service and user-friendly operation
• Develop and maintain a library of standard data visualisations theme such as design templates, font, icons, and colours
• Migrate and automate reports built on traditional tools such as Excel VBA Macros and MS Access database to the latest reporting techniques from the Microsoft BI tool kit

Adelaide, South Australia, Australia

• Understand and analyse business requirements to create efficient data models, and key performance indicators (KPIs) that provide compelling insights to stakeholders
• Collaborate with business stakeholders and technical teams to ensure that data solutions meet business needs and are aligned with company strategies
• Maintain dataflows, paginated reports, datasets, dashboards, subscriptions, scheduling, and apps across multiple Power BI workspaces
• Write efficient and effective Power Query scripts to clean, merge, and transform data
• Design and develop interactive and visually appealing Power BI reports and dashboards
• Provide support and training to business users to help them effectively use Power BI and interpret the data

Adelaide, South Australia, Australia

• Deliver the solution in an Agile methodology and participate in daily stand-up calls, design sessions, knowledge sharing sessions, and feedback sessions from the client
• Work closely with the business analyst in every phase of the project to gain a thorough understanding of the requirements and to ensure effective collaboration
• Develop several intermediate tables for STAR schema (dimensions and facts) when a user uploads raw data in the SOFY application
• Implement the ETL (Extract, Transform, Load) process and database modelling solution as part of the project development, ensuring effective data integration, transformation, and storage
• Monitor and optimise database performance by analysing query execution plans, database statistics, and system resource usage
• Create engaging and informative visualisations in SOFY by connecting SQL views, allowing the business to easily understand and analyse payroll files received from the client

Chennai Area, India

• The chair as a primary point of contact for the project and conduct workshops, meetings, and daily stand-up
• Spark clear communication with management regarding changes needed for the existing system
• Maintain a good relationship with Wal-Mart management and document every success/failure aspect of the project
• Design and implement data pipelines to ETL data from Teradata to various systems such as Mainframe and Unix for store manager reporting purposes
• Enhance the existing Common Business Oriented Language (COBOL) programs and Customer Information Control System (CICS) programs with new requirements from the business, such as adding new fields to reports or updating.
• Collaborate with other developers, testers, and business analysts to identify and resolve issues

Chennai Area, India

Project: Wal-Mart1. Sam's Club Membership Maintenance (May 2016 – June 2018) - The project objective is to manage and streamline membership renewal and promotion processes, automate repetitive tasks, and analyse complex job flows to identify areas for cost-cutting.2. Wal-Mart Store Number Expansion (March 2015 – April 2016) - The project's primary aim is.

Chennai Area, India

• The project was tasked with efficiently managing Engineering Change Orders (ECO) and Bill of Materials (BOM) for Alcatel's manufacturing sites across the globe. The project resulted in automating repeated tasks using.
• Participate in project activities, including prioritising tasks, creating schedules, determining required resources, preparing plans, organising and managing data and documentation, and resolving issues in a timely and.
• Review the BOM and ECO provided by the Alcatel team and implement the changes across the SAP ERP system
• Create macros for comparing the latest file with the previous version to capture data changes over the time
• Preparing charts and graphs to present data visually and analysing trends and patterns in the data to provide insights to stakeholders
• Use advanced Excel functions such as VLOOKUP, INDEX MATCH, TIME, and CONCATENATE to identify errors and ensure data accuracy

Master Of Data Science - Mds, Data Science, 6.31/7.0 Gpa

-> ASPIRE: attended 15+ leadership development sessions on time management, strength finder, event management, teamwork and presentation.

Bachelor Of Engineering - Be, Electronics And Communications Engineering, 6.94 Cgpa - First Class

Activities and Societies:  2nd place in Symposium for general quiz happened in St.Josephs College of Engineering  1st place for paper.

Hsc - 12Th, Mathematics And Computer Science, 80%

The high school certificate (HSC) which is referred to as class 12 in Tamil Nadu is the final public examination for a student. I have.

Sslc - 10Th, Mathematics And Science, 88%

Activities and Societies: I have won "Srinivasa Ramanujam Academy of Maths Talent", for the outstanding merit in mathematics as I scored.