Narendra Kotha
Stockholm,
Summary
Seasoned data professional with 15 years of experience in cloud BI and data engineering, specializing in designing data warehouses, data models, and end-to-end BI solutions. Expert in SQL and Python for advanced data understanding and analysis. Proficient in Power BI and Tableau, transforming complex data into actionable insights. Knowledgeable in GCP and Microsoft Fabric for building cloud data platforms, and designing robust BI solutions. Highly motivated to bring this expertise and passion to your team.
Overview
15
15
years of professional experience
1
1
Certification
Work History
BI Developer
SEB Pension & Försäkring
Sweden & Malaysia
07.2017 - Current
- Developed BI solutions to enhance data visualization and reporting capabilities.
- Collaborated with stakeholders to gather data requirements and define project scope.
- Designed and maintained ETL processes for seamless data integration across systems.
- Created interactive dashboards and reports using Power BI for user accessibility.
- Conducted data analysis to support business decision-making and strategic planning.
- Supported cross-functional teams in identifying trends through advanced analytics techniques.
- Created reports, scorecards, and KPIs in Microsoft Power BI to measure business performance metrics.
- Optimized existing SQL queries for better performance when running against large datasets.
- Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
- Maintained documentation on all aspects of the BI environment including data models, ETL processes.
- Analyzed user requirements and designed solutions that meet their needs while adhering to industry standards.
- Implemented security measures to ensure confidential information is protected within the system.
- Developed automated alerts based on predetermined thresholds set by business stakeholders.
- Designed and implemented dashboards using Power BI to provide interactive visualizations of business data.
- Conducted training sessions for end-users on how best to utilize the BI platform or specific toolsets.
Team Leader
J P Morgan & Chase
Bangalore, India
04.2016 - 06.2017
- Led team meetings to enhance communication and collaboration among members.
- Migrated reports from Microsoft Reporting to Power BI.
- Responsible for credit risk daily and weekly reporting.
- Developed training programs to improve team performance and skill sets.
- Coordinated project timelines with stakeholders to ensure timely deliverables.
- Designed T-SQL templates for database objects, like views and procedures.
- Mentored junior staff, fostering professional development and knowledge sharing.
- Oversaw daily operations, ensuring alignment with corporate goals and standards.
- Maintained a positive work environment that promoted collaboration between team members.
- Offered training and support to keep team members motivated and working toward objectives.
- Participated in regular meetings with senior leadership to present Enterprise Dashboards with Power BI, and team progress.
- Monitored daily workflow to ensure adherence to established policies and procedures.
- Established templates with Power BI to migrate legacy reporting.
- Resolved customer complaints in an effective manner while maintaining a high level of customer service.
- Promoted to leadership position in recognition of strong work ethic and provided exceptional customer service.
- Reviewed completed work to verify consistency, quality, and conformance.
- Created training materials and conducted group trainings on new processes or procedures.
Senior Software Engineer
Hexaware Technologies Ltd
Bangalore, India
08.2014 - 03.2016
- Creating an Effort Estimation document based on the requirement.
- Designing QlikView architecture, specifying the development server and production server.
- Requirement gathering and coordination with onsite team members.
- Mentoring / Leading Freshers.
- Extracting and loading data from different sources (SQL Server, Oracle and Access).
- Coding QlikView scripts, developing an associative model, and designing dashboards.
- Creating QVDs and transformations.
- Extracting, transforming, and loading data from multiple sources into QlikView applications.
- Written complex T-SQL statements (queries) for the retrieval of data, and involved in the performance tuning of T-SQL queries.
- Creating packages on the SQL Server Integration Services platform.
- Creating SSIS configurations as per requirements.
- Designed various SSIS modules in order to fetch the data in the data staging environment, based on the different types of incoming data.
- Extracting data from multiple sources, like flat files and SQL Server, and transforming, cleansing, validating data, and loading it into the final destination.
- Used transformations like Aggregate, Merge joins, Conditional Split, and Lookup transformation.
- Working with the control flow tasks such as Execute SQL Task, Data Flow Task, Bulk Insert Task and File System Task…etc.
- Generating reports in the form of tabular, matrix, and chart.
- Created different Parameterized Reports (SSRS 2005/2008/2012) like standard parameter reports, Cascading Parameterized reports.
- Involved in Installation, Configuration, and Deployment of reports using SSRS with Scaleout topology.
- Implementing Agile methodologies in the team and taking initiative to make it understand.
Senior Database Engineer
Prime Ki Software Solutions Pvt Ltd
Hyderabad
10.2010 - 07.2014
- Designed and implemented database architectures for client applications.
- Developed complex SQL queries for data retrieval and manipulation.
- Collaborated with software developers to integrate databases with applications.
- Mentored junior engineers on best practices for database management.
- Evaluated new database technologies for potential integration into existing systems.
- Provided technical expertise in design, development, implementation and maintenance of databases.
- Performed advanced SQL query optimization techniques such as indexing strategies and query plan analysis.
- Conducted data migration from legacy systems to new databases with minimal disruption to operations.
- Maintained an up-to-date knowledge base on all existing databases within the organization's infrastructure.
- Analyzed complex database systems and provided recommendations for improvement.
- Trained junior members of the team on best practices for developing efficient SQL queries.
- Developed, implemented and maintained database architectures to support business requirements.
- Created stored procedures, functions, triggers and views using T-SQL.
Education
Master of Science - Computer Applications
Andhra University
India05-2010
Skills
- T-SQL and Python
- Power BI and Tableau
- QlikView and Power Query
- Tableau Prep and SSIS
- GitHub and Microsoft TFS
- Microsoft Fabric and GCP
Certification
DP-600: Microsoft Fabric Analytics Engineer, 02/25.
Accomplishments
Designed a comprehensive 'One Stop Center' dashboard to support stakeholders with BI reporting solutions, enabling management to efficiently access usage statistics.
Timeline
BI Developer
SEB Pension & Försäkring
07.2017 - Current
Team Leader
J P Morgan & Chase
04.2016 - 06.2017
Senior Software Engineer
Hexaware Technologies Ltd
08.2014 - 03.2016
Senior Database Engineer
Prime Ki Software Solutions Pvt Ltd
10.2010 - 07.2014
Master of Science - Computer Applications
Andhra University