Highlights

• Experienced developer with a strong background in designing, implementing and optimizing analytical business reports and dashboards.


• Have 3 years of work history with proficient knowledge in SQL queries with integration with Pentaho-kettle, Power Bi, python and various other small applications.


• Strong problem-solving and communication skills contribute to successful project outcome.


• Productive employee with proven track record of successful project management and producing quality outcomes through leadership and team motivation.


• Works with clients to determine requirements and provide excellent service.

Skills

Primary Skills

ETL

Power BI

Python

Secondary Skills

PSQL

SQL Queries

SSRS

Projects

Project - 1 - IT Industry

Role : Senior Developer





Responsibilities : 






• Extracted data from Src System and created query as per the business rule.


• Strong knowledge in Power BI using SQL Server. Involved in Requirement Analysis, Design, Development and Maintenance of Power BI Application.


• Developing and maintaining ETL process to extract data from different source, transform it as required and load it into the database.


• Responsible for building reports in power bi from the Scratch and publishing Power BI reports on dashboard in Power BI Server.


• Wrote, maintained and executed SQL queries to validate the integrity of the database.


• Identify and resolving database related issue, errors through analysis and troubleshooting.


• Writing complex queries and optimizing existing queries to improve performance and efficiency.


• Utilized SQL to query and structure large datasets for analysis and reporting.


• Executed fine tuning of database for better performance.


• Used Pentaho-Kettle platform to design reports.

Project - 2 - IT Industry (9 months)

Role : Developer





Responsibilities : 






• Developed stored procedure, triggers and functions that automated manual processes and improved performance.


• Writing complex queries and optimizing existing queries to improve performance and efficiency.


• Developing and maintaining ETL process to extract data from different source, transform it as required and load it into the database.


• Responsible for building reports in power bi from the Scratch and publishing Power BI reports on dashboard in Power BI Server


• Executed performance tuning with the help of optimized queries for ETL process.


• Developed and automated reporting system, dashboard and interactive reports that provided business stakeholders with real- time business insights to make effective decision.


• Had a good hands-on DDL, DML commands, stored procedure, joins etc.


• Work on SSRS and SSIS tool

Project - 3 - IT Industry (6 months)

Role : Senior Executive





Responsibilities : 






• Created reports and dashboard as requested by Business for the target BI Model.


• Developing and maintaining ETL process to extract data from different source, transform it as required and load it into the database.


• Wrote, maintained and executed SQL queries to validate the integrity of the database.


• Built strong relationships with customers to ensure satisfactory execution of business requirements.


• Monitored system performance to identify issues and proactively addressed potential causes that might affects customer’s data.


• Hands-on DDL, DML commands, stored procedure, joins etc and POWER BI.

Project - 4 - IT Industry (4 months)

Role : Intern





Responsibilities : 






• Worked on MSSQL Server 2014 and power BI.


• Managed to create dynamic dashboards and reports for the target BI model.


• Have a good hand on DDL DML commands, Stored Procedure (SP), function and Joins.


• Able to perform basic SQL queries and Stored Procedure