SriHari Melika
Abu Dhabi,UAE
Summary
16+ years of comprehensive IT experience in software development, emphasizing design and implementation with a major focus on Power BI, Azure Data Factory, ETL (SSIS-SQL Server Integration Services), SSRS, and SSAS, including Microsoft Fabric for data warehousing and database applications.
Takes on challenging new role harnessing interpersonal skills, collaboration and problem-solving. Driven to deliver high-quality service and consistent results.
Loyal employee with solid understanding of training and mentoring employees. Dedicated team player, proactive and hands-on in task completion.
Overview
18
18
years of professional experience
Work history
ETL Developer
Property Shop Investment
Abu Dhabi
2025.07 - 2026.06
- Designed and developed SSIS/SQL ETL solutions to acquire and prepare data from multiple upstream systems for CRM processing.
- Debugged and tuned SSIS and other ETL processes to ensure accurate and efficient data movement.
- Builds data transformations with SSIS including importing data from files, moving data from one database platform to another.
- Design and develop SQL Server stored procedures, functions, views to be used during ETL process.
- Created visualisations and dashboards using Power BI service to enhance data presentation.
- Implemented Row Level Security (RLS) in Power BI.
- Utilised various visualisation types including Table, Matrix, Bar, Card, Gauge, and Slicers in reports.
- Scheduled automatic and manual data refresh in Power BI service to maintain up-to-date reporting.
- Working with Data Gateways for Automated and Manual Data Refresh from on-premise.
- Presented reports and changes to business users weekly.
- Build data transformations with SSIS including importing data from files, moving data from one database platform to another.
- Involved in creating power bi model and creating reports using power bi desktop.
Architect
Wipro
Hyderabad
2022.04 - 2025.05
- Tailored designs according to client requirements for personalised outcomes.
- Reduced cost overruns by implementing efficient design strategies.
- Facilitated productive meetings with stakeholders for collaborative decision-making processes.
- Coordinated with consultants and contractors to streamline project timelines.
- Requirement specifications collected from several parties and individuals
- Provided all technical support for developers.
Mainly participated in Development, test environment and Implementation stages. - Extensively worked on building business components, database, server and client system designs.
Working with Visualizations & Dashboards using Power BI service. - Implemented Row Level Security (RLS) in Power BI.
Used Table, Matrix, Bar, Card, Gauge and Slicers Visualizations. - Scheduled Automatic refresh and scheduling refresh in power bi service.
- Working with Data Gateways for Automated and Manual Data Refresh from on-premise.
Weekly presentation to business users about reports and their changes as required. - Created New Calculated Columns and Measures using DAX Expression.
- Involved in creating POWER BI model and creating reports using POWER BI desktop.
- Extracted large volumes of data from different data sources and loaded data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Optimization of stored procedures used as source for reports.
Implementing logging and deploying. - Having hands-on experience in Migration DBs and SSIS Migration from SQL Server 2000 (Rewriting SSIS packages in 2012), SQL Server 2008 to 2012.
- Supporting end user Applications and working on enhancement requests.
- Used Best practices for package design, Data Flow techniques, deployment and management in SSIS.
- Developed Power BI reports and dashboards from multiple data sources using data blending.
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- Automated Power Query refresh using power shell script and windows task scheduler.
- Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc.
- Extensive experience in onshore/offshore coordination and responsible for project deliverables.
Senior Consultant
Hitachi Vantara
Hyderabad
2019.09 - 2021.10
- Working with Visualizations & Dashboards using Power BI service.
- Used Table, Matrix, Bar, Card, Gauge and Slicers Visualizations.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Working with Data Gateways for Automated and Manual Data Refresh from on-premise.
- Weekly presentation to business users about reports and their changes as required.
- Created New Calculated Columns and Measures using DAX Expression.
- Involved in creating power bi model and creating reports using power bi desktop.
- Requirements specifications collected from several parties and individuals.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
- Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2016.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- Implementation of MS SQL Server 2008/2012 and 2016 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for reports.
- Extensively worked on building business components, database, server and client system designs.
Created stored procedures for reports Process.
Unit level Testing and Bug Fixing. - Implemented cost-effective solutions, contributing to budget control.
- Established performance metrics, enhancing overall productivity.
- Analysed financial data to drive business growth strategies.
- Spearheaded change management initiatives resulting in smoother transitions during organisational restructuring.
Tech Lead
ATMECS Technologies Pvt Ltd
Hyderabad
2016.11 - 2019.08
- Supported developers with technical guidance, resolving issues to enhance project progress.
- Contributed to development, testing, and implementation stages of projects.
- Developed business components and designed database, server, and client systems to meet project requirements.
- Extracted large volumes of data from different data sources and loaded data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Optimised stored procedures to improve report generation efficiency.
- Working with visualisations & Dashboards using Power BI service.
- Created visualisations using tables, matrices, bars, cards, gauges, and slicers.
- Configured automatic refresh schedules in Power BI service.
- Working with Data Gateways for Automated and Manual Data Refresh from on-premise.
- Requirement specifications were collected from several parties and individuals.
- Tested functionality of applications before roll-out ensuring user-friendly interface.
Senior Consultant
Virtusa Polaris
Hyderabad
2013.04 - 2016.11
- Developed and tested MicroStrategy reports, optimised performance through tuning, and scheduled ad-hoc report delivery and alerts for timely insights.
- Created Datamart reports in MicroStrategy based on user requirements, resolved access issues, and provided necessary report access in MicroStrategy web to enhance user experience.
- Extensive experience in creating Datamart reports in MicroStrategy as per user requirementsExtensively worked on user requests to resolve Access issues and provided required access to particular area of reports in MicroStrategy web.
- Worked on MicroStrategy Report data issues and provided solution to users. Good exposure to data query tools like SQL Developer and TOAD.
- Tracing performance tuning through Query Analyzer and SQL server Profiler.
- Optimization of stored procedures used as source for reports.
- Supported and enhanced SSIS packages by implementing SSIS controls, Package Configuration, Message Logging, and Auditing.
- Extensive experience in creating Datamart reports in MicroStrategy as per user requirements
Extensively worked on user requests to resolve Access issues and provided required access to particular area of reports in MicroStrategy web. - Managed ITSM resolutions, created change requests for enhancements, and facilitated weekend release processes to ensure seamless system updates and continuous service improvement.
- Working as Release Manager to process CR release in the weekend and co-coordinating with Onshore/Offshore team and responsible CR release to Production.
- Extensive experience in onshore/offshore coordination and responsible for project deliverables.
- Handling ITSM and JIRA's resolutions
Involved in Unit Level and Peer Testing
Senior Software Engineer
Aditya Birla Minacs
Bangalore
2012.04 - 2013.04
- Developed business components and designed database, server, and client systems to meet application requirements.
- Implemented SSIS packages for loading claims details into database and processed PDF compression and decompression.
- Collected requirement specifications from multiple stakeholders to ensure comprehensive understanding of project needs.
BI Developer
Manthan Systems
Bangalore
2010.03 - 2012.03
- Extracted large volumes of data from different data sources and loaded data into target database by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Implementing logging and Deploying.
Used Best practices for package design, Data Flow techniques, deployment and management in SSIS. - Monitoring ETL schedules while loading data Working with KPI related Issue resolutions. Budget loadings and validating data.
- Monitoring ETL schedules while loading data
Working with KPI related Issue resolutions.
Budget loadings and validating data. - Created Drill down and drill through reports in SSRS.
Expertise in scheduling reports to end-users and giving access to report server. - Developed and scheduled cached reports in SSRS Extensive experience in onshore/offshore coordination and responsible for project deliverables.
- Developed and scheduled cached reports in SSRS
Extensive experience in onshore/offshore coordination and responsible for project deliverables.
Software Engineer
Solvent Software Solutions
Hyderabad
2008.08 - 2010.03
- Created tabular, cross-tab, chart, drill-down, and drill-through reports using SSRS, facilitating informed decision-making.
- Designed and developed conditional formatting reports using SSRS to enhance data visualisation.
- Developed reports in report wizard by connecting to data sources in SSRS, improving data accessibility for stakeholders.
- Analysed client's traditional database and designed data warehouse architecture to enable seamless integration with existing systems.
- Defined business process requirements to align technical solutions with client needs.
- Provided technical support during installation process, ensuring smooth transition for users.
Education
Bachelor of Technology (B. Tech) - Computer Science & Engineering
Bapatla Engineering College
Bapatla01.2008
Skills
- MS SQL Server
- SQL Server databases
- Microsoft Business Intelligence (MSBI)
- SSIS and ETL tools
- SSRS and reporting tools
- SSAS and OLAP tools
- Power BI and Microstrategy
- Azure Data Factory
- Azure Databricks
- Microsoft Fabric
- Windows operating systems
- Informatica PowerCenter
- Version control with VSS and SVN
- MS Office Suite and Visio
- ITSM with Jira and ServiceNow
- Problem-solving skills
Timeline
ETL Developer
Property Shop Investment
2025.07 - 2026.06
Architect
Wipro
2022.04 - 2025.05
Senior Consultant
Hitachi Vantara
2019.09 - 2021.10
Tech Lead
ATMECS Technologies Pvt Ltd
2016.11 - 2019.08
Senior Consultant
Virtusa Polaris
2013.04 - 2016.11
Senior Software Engineer
Aditya Birla Minacs
2012.04 - 2013.04
BI Developer
Manthan Systems
2010.03 - 2012.03
Software Engineer
Solvent Software Solutions
2008.08 - 2010.03
Bachelor of Technology (B. Tech) - Computer Science & Engineering
Bapatla Engineering College