About
With extensive expertise in SQL and Data Visualization, covering the entire software development life cycle (SDLC), I offer a versatile skill set aimed at shaping impactful data strategies. Recognized for my goal-oriented and enthusiastic approach, I\'m adept at quickly adapting and thriving in team-oriented settings. My capabilities extend to fine-tuning performance and streamlining processes, ensuring optimal functionality of databases. Following Agile Methods, I possess assertive leadership qualities that resonate with a unified team approach focused on achieving common objectives. I\'m keen to apply my knowledge to elevate your organization\'s data capabilities and play a part in its prosperity.
Portfolio
Forcasting Property Values from 2008 - 2021
The dataset used for this project was obtained from Kaggle, a leading online platform known for its ... ... More
Employment History
-
Power BI Developer
Colaberry Inc
April 2020 - Present
Responsibilities:
Engage with stakeholders to gather business requirements and understand data for
report creation.
Develop KPIs using DAX functions and create visual reports deployed in appropriate
workspaces.
Import data from Azure services like ADL and BLOB, creating Data Flows in Power
BI Service.
Collaborate with cross-functional teams, ensuring effective KPI analysis for business
decisions.
Document processes for future reference and build complex DAX functions for data
insights.
Design and optimize databases based on business requirements to enhance efficiency.
Produce diverse reports (dashboards, tabular reports, charts) using Power BI and
SSRS.
Provide regular updates to business users and manage Report Servers for client
consumption.
Participate in Project Management and SDLC phases, including analysis, testing, and
documentation.
Serve as a key contact for client projects, leading smaller project teams and creating
data pipelines.
Demonstrate dashboard functionalities for end-user understanding and usability. -
SQL Server DBA
Colaberry Inc
January 2018 - April 2020
Responsibilities:
Installed, configured, and maintained SQL Server in clustered and standalone
environments.
Performance tuning and optimization for query efficiency and resource management.
Migrated databases from SQL Server 2014 to SQL Server 2019.
Resolved security issues for logins, users, and linked servers.
Managed critical incidents within SLA requirements.
Automated database refreshes and implemented maintenance plans for backup and
optimization.
Conducted performance tuning, including index monitoring and optimization.
Designed and executed ETL processes using SSIS for data loading and
transformation.
Developed, debugged, and maintained stored procedures and triggers.
Collaborated on database design based on user requirements using ERWIN.
Worked on query tuning, execution plans, and SQL Profiler for performance
enhancements.
Managed code deployments, maintenance tasks, and provided project status updates.