Verified
This profile is verified using an email address.
Mahesh Kumar Kandimalla
Louisville,KY
Summary
Around 18 years of experience including 80+ months of international experience at client sites (UK, Saudi Arabia and currently USA) in various roles of BI Architect, Integration Lead, Sr. Data Analyst, Data Automation Test Lead in the IT services and IT consulting fields specializing in Healthcare Insurance and Telecommunication Domian.
Designing and implementing data architectures to support business intelligence initiatives.
Extensive experience with business intelligence and data visualization platforms like Microsoft Power BI and complete understanding of Tableau, or QlikView.
Providing BI solutions by unifying disparate systems to provide a cohesive view of business operations.
As BI Architect, working closely with stakeholders to understand data needs and translate them into technical requirements. This ensures BI solutions align with organizational goals, bridging the gap between technical capabilities and business priorities.
Very Strong hands-on-experience in Oracle PL/SQL with excellent analytical skills. Proficient in data warehouse modelling with expertise in both Star and Snowflake schema designs.
Complete understanding of ETL (Extract, Transform, Load) processes and working knowledge of Informatica Power Center.
Extensive experience in onshore-offshore model collaboration, mentoring new team members to accelerate project delivery.
Having extensive experience in preparation of Project Plan, BI specifications documents,
Strategy Documents, Test Plans, System Integration Plan.
Experienced on preparing the macros on Excel VBA for the generation of organized reports.
Overview
20
20
years of professional experience
3
3
years of post-secondary education
Work History
Sr. BI Architect
Humana Health Inc
Louisville, KY
07.2019 - Current
- Designing and implementing data architectures to support business intelligence initiatives.
- Ensuring seamless data flow across platforms while maintaining data integrity and accuracy is essential for reliable analytics and reporting.
- Collaboration is also central to the role. BI Architects work closely with stakeholders to understand data needs and translate them into technical requirements.
- This ensures BI solutions align with organizational goals, bridging the gap between technical capabilities and business priorities.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Connecting data sources, importing data and transforming data for Business Intelligence.
- Excellent in analytical thinking for translating data into informative visuals and reports from QlikView files.
- Able to implement row level security on data and understand application security layer models in Power BI.
- Proficient in making DAX queries in Power BI desktop.
- Expertise in using advanced level calculations on the data set.
- Responsible for design methodology and project documentation.
Integration Lead
Saudi Telecom Company
Riyadh
02.2016 - 06.2019
- Responsible for the Integration design and operations of the systems-to-system interfaces, data flows, APIs, and integration middleware.
- Experience with Agile Methodologies such as Scrum and XP, but also with more traditional structured approaches.
- Co-ordinating with all external systems to finalize the integration techniques as well as participating in SIT testing.
- Single point of contact for all integration designs from CMS team.
- Well versed in building in SAS web services, Database and SFTP integration.
Siebel Automation Test lead, Performance Test Lead, Lead Data Analyst, Component Delivery Lead
British Telecom
UK
11.2011 - 01.2016
- Leading team for a major release which included assigning tasks, monitoring the progress on daily basis, report generation, interaction with higher management for issues or concerns.
- Leading the team of 8 resources.
- Attend design calls, understand customer requirements and prepare test cases based on business use cases and ensure all interfaces are covered as per the impacts.
- Prepared high level and low level test cases according to test plan by applying technical and functional requirement knowledge to ensure that maximum scenarios can be covered.
- Arranging internal and external reviews of test cases with various teams in hierarchy and implement the required changes.
- Estimates costs, timescales and resource requirements for the successful completion of each project to agreed terms of reference.
- Identifying any issues with project sponsorship and seeks resolution.
- Maintenance of Project artifacts – Plans, Designs, Minutes, reports etc.
- Have been working closely with the E2E Testing team, UAT & CP Proxy Teams to provide/clarify the fixes for the issues raised while E2E testing.
- Executed test cases on Siebel 7.7 eSales application for order management.
Automation Test lead
Tech Mahindra
India
02.2007 - 10.2011
- Estimating the efforts of automation and preparing the estimation reports.
- Assigning the Tasks as per the technical strength (i/p data sheet, scripting, debugging, execution).
- Tracking the Daily progress of team members and preparing the reports for the same.
- Reviewing the scripts written by team members and suggesting the changes if any.
- Finalizing the best practices in automation and preparing the Automation Framework document.
- Attending the external project reviews with SMEs and ensure suggestions will be implemented if required.
- Ensure all the team members should follow the Framework Document in their daily tasks.
- As a VSS Administrator: Taking regular backups for all the four streams in the project for every release.
- Archiving and restoring the projects in VSS as Backup Contingency plan.
- User Administration and responsible for giving access to users.
- Prepared Automation POC for OR Siebel Project using QTP 9.5.
- Prepared Migration Plan for QC for importing the defects from OMS.
- Conducted QTP Trainings for all teams in the Project.
E2E Tester
Datamatics
India
03.2006 - 01.2007
- The primary responsibilities to understand the Functional specification, preparing Focus areas by taking the inputs from Functional Specification/Design documents.
- Involved in Preparing Test Scenarios/Test Cases, Performed Sanity Testing, Functional testing & System testing to maintain the Quality of the Software Application.
- Responsible for Creating and Updating of Test cases in E2E Testing perspective.
- Functional and Regression Testing carried out in various phases of Test cycles.
- Involved in Pipe Cleaning activity of the different order management processes.
Skills
- Power BI
- Power App
- Power Automate
- Informatica Power Centre
- Azure Data Factory
- Snowflake
- Databricks
- SAS 94
- Snowflake Cloud Datawarehouse
- Oracle pl/SQL
- MS SQL Server 2008
- Data Factory
- Blob Storage
- Python
- Unix Scripting
- GitHub
- JIRA
- HP-QTP
Education
Bachelor of Science - Science
Sri Venkateshwara Degree College
06.1995 - 06.1998
Certification
- Microsoft Power BI certified
- Microsoft Azure Fundamentals
- Microsoft Power Platforms
Accomplishments
More than 10 yrs of International work experience
Handling More than 350M of data for BI reporting
Complex Architecture and data modeling with multi source integrations with power bi
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Sr. BI Architect
Humana Health Inc
07.2019 - Current
Integration Lead
Saudi Telecom Company
02.2016 - 06.2019
Siebel Automation Test lead, Performance Test Lead, Lead Data Analyst, Component Delivery Lead
British Telecom
11.2011 - 01.2016
Automation Test lead
Tech Mahindra
02.2007 - 10.2011
E2E Tester
Datamatics
03.2006 - 01.2007
Bachelor of Science - Science
Sri Venkateshwara Degree College
06.1995 - 06.1998