About
With proven experience in SQL and Data Visualization, encompassing the full software development life cycle (SDLC), I bring a dynamic skill set to drive effective data strategies. Known for goal-driven and energetic contributions, I am a fast learner who excels in collaborative team environments. My proficiency extends to performance tuning and processing, ensuring optimal database functionality. Adhering to Agile Methods, I bring assertive leadership skills that align with a one-team, one-goal philosophy. I am eager to leverage my expertise to enhance your organization's data capabilities and contribute to its success.
Portfolio
Predicting Occupancy Rates in Dallas AirBNB
Embarking on an exploration of the Dallas Airbnb landscape from 2014 to 2023, this study seeks to sh... ... More
Global Suicide Trends: Analyzing Demographics and Generational Patterns. (1985 - 2015)
This project aims to show how Suicide is a silent killer and it needs a serious attention throughout... ... More
Employment History
-
Senior Power BI Developer
Colaberry Inc
November 2020 - Present
• Build complex DAX functions in Power BI for data insight.
• Write useful calculated columns, measures in my dataset and display in visuals including KPIs.
• Successfully plan, define, and design database based on the business requirement to increase efficiency.
• Produce applicable dashboards, Tabular reports, Matrix reports, Charts and Graphs as per customer/ Business requirements for data analysis using Power BI and SSRS.
• Present weekly updates to the business users about the reports, status, and take note of changes they wish to be made.
• Construct database and Tables (DDL, DML, DCL), perform database tuning, SQL tuning, and performance planning.
• Carefully configure both Report Servers to manage paginated reports, mobile reports and KPI’s, allowing clients to consume them using a web browser, mobile device or as an email in their in-box.
• Participate in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing, and documentation, and planning for redesign or transition to another platform.
• Working as a contact person with clients to work on projects requirement and to apply changes needed.
• Lead junior team members on Medium to smaller projects
• Create Dataflows and Data Pipelines.
• Present the Dashboard functionalities for end user. -
Business Intelligence/ SSRS Developer
Colaberry Inc
September 2018 - October 2020
• Transform complex business logic into database design and maintain it by using SQL objects like Stored Procedures, UDFs, Views, T-SQL scripting, and jobs.
• Design SSIS packages to validate, import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed & developed SSRS dashboards, Identified and worked with multi-value parameterized reports.
• Experience in using T-SQL for developing complex Stored Procedures, Tables, Views, User-Defined Functions.
• Generate Sub-Reports, Drilldown, Drill-through, and Parameterized reports using SSRS.
• Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
• Scheduled, maintained, and supported the distribution and access to reports at Server level.
• Configured and maintained Report Manager and Report Server for Power BI Gateway and SSRS.