Sql Server Power Bi

Jose M Lopez, Database Developer

Miami, *****, US, 786-***-****, ***********@*****.***, ***********@*****.*** SUMMARY Dynamic Database Developer with over 8 years of experience in SQL Server administration and development. Proficient in ETL processes, performance tuning, and database design, with expertise in tools such as SSIS, Power BI, and Tableau. Achievements include streamlining daily operations through automated reports and optimizing database performance, ensuring data integrity across platforms. Committed to utilizing unique skills to enhance database solutions and drive business intelligence initiatives. WORK EXPERIENCE

Apr 2018 – Present SQL Developer / DBA Administration, UAIC Miami Supported SQL Server versions 2008 R2, 2012, 2014, and 2017. Engineered ETLs utilizing the SSIS tool to empower business intelligence platforms.

Designed and implemented robust Microsoft SQL Server databases. Executed performance tuning, indexing, and development of stored procedures.

Oversaw high-volume Data Warehouse solutions.

Documented storage processes, including full-text indexing and retrieval. Assisted production users and diagnosed production-related issues. Formulated database access security controls.

Created and redesigned dashboards and reports using Tableau, Power BI, and PowerPivot for Excel.

Aug 2017 – Apr 2018 SQL Developer / DBA Administration, Tracfone Inc. Miami Performed various types of complex data analysis.

Built models for business and financial analysis.

Conducted comprehensive financial and business reporting. Managed data and executed process audits.

Created SSIS (ETL) packages to transfer data from Oracle, text files, and Excel to SQL Server.

Delivered reporting solutions and data visualization utilizing Power BI and PowerPivot.

Coordinated root cause analysis initiatives for effective issue resolution. Dec 2016 – Jun 2017 SQL Developer / DBA Administrator, Mount Sinai Medical Center Miami Created and developed automated reports, stored procedures, and SQL jobs to streamline daily operations.

Devised reusable SSIS packages to extract data from multi-formatted flat files, Excel, and XML files into SQL databases.

Conducted thorough data analysis and generated reports using Excel, Visual Studio, Power BI, and Tableau.

Developed an application in Visual Studio and SQL Server to evaluate and track the Quality Food Nutrition Program.

Managed the migration of databases from SQL Server 2012 to 2014. Jul 2013 – Sep 2016 SQL Developer / Reporting, Golden Trail Inc Miami Authored stored procedures to centralize core business logic. Refined the database model to eliminate data discrepancies. Executed logging and deployment of various packages in SSIS. Developed diverse operational reports using SSRS.

Assisted in resolving data conversion issues.

Apr 2000 – May 2013 Computer Programmer / Database Developer, UPS Miami Developed scripts to automate the archiving of data biannually. Increased database capacity and optimized storage solutions. Developed and deployed high-quality T-SQL code.

Consulted with the marketing department to craft queries and generate reports.

Involved in troubleshooting and fine-tuning database performance. EDUCATION

Jun 1989 – Jul 1992 University of Havana

Matemathics, Mathematics, Computer Science

Havana

SKILLS MS SQL T-SQL

MSDE SQL Express

SSRS Oracle PL/SQL

.NET Technologies (VB.Net, ASP,

ASP.NET)

Visual Basic 6

Visual Basic MS Access

VBA Business Objects

CSS HTML

Visual FoxPro Tableau

Power BI Crystal Report

MS Office (Excel, Word, PowerPoint) Fast learner

Analytical Strong troubleshooting skills

Problem solving skills Ability to work independently Team player Agile Methodology

Ownership of work Honesty

LANGUAGES English

Contact this candidate