Power Bi Data Analyst

C

Results-driven, IT Professional with extensive experience in administration, development,

support and implementation of SQL Servers database and database warehouse.

SUMMARY OF QUALIFICATIONS

20 + Years IT Experience working as an SQL Database Development and Administration with knowledge of Oracle Database.

Extensive hands-on experience in system and network management, installation, maintenance, administration, security, troubleshooting, training, and technical support.

In-depth knowledge of network technologies, architecture, and platforms, with the ability to apply them to the strategic benefit of organizations.

Proven ability to successfully streamline, optimize, and maintain system/network functionality performance, and recoverability in mission-critical environments.

Adept at working with management to prioritize activities and achieve defined project objectives; able to effectively translate operational/network requirements into technical solutions.

EDUCATION AND TRAINING

Bachelor Degree of Professional Studies in Computer Information Systems and Database Management

DeVry College, New York, NY,2017

Certification – Microsoft Power BI Data Analyst, 2025

Certification – (MCDBA)MSSQL Server and Database Administration, 2013

Certification – (MCITP) ASP.Net C# Application & SQL Database Development, 2010

TECHNICAL SKILLS

Desktop Operating Systems: Microsoft Windows XP (Pro/Home) (32/64bit), Windows 7/10 (32/64) (Home, Home Premium, Business), Windows shell script, Windows 2000, Windows NT, Windows 9x (95/98/ME)

Software: MS2015Word, MS Excel, MS Outlook, MS PowerPoint, MS Access/Project, Visio2013, Adobe (Acrobat / Photoshop / Illustrator), GoToMyPC, VNC, VPN Client, RDP(Aventail), RDBMS, Symantec (Antivirus, Ghost), MacAfee (Antivirus, Anti Spyware), MS Visual Studio 2000-2015, T-SQL 2002-2016 Server Management Studio (SMS), T- SQL, SQL Profiler, Configuration Management, Azure DB, MySQL, PLSQL, Oracle Database and DB2 and Linux System, Java and Java Script

Server Operating Systems: Microsoft Windows SQL 2003, 2005, 2008 & 2008R2, 2012, 2014 & 2016 Server, Linux

Server Applications: Active Directory, SQL DB & DB2, File and Print Services, Terminal Services

Wired Networking (LAN/WAN): Switches, Routers, Firewalls, Modems, Network Printers and Scanners

Network Protocols: TCP/IP, DNS, FTP, TFTP, Telnet, IIS, Ping, HTTP, HTTPS, RDP, SOAP, REST

PROFESSIONAL EXPERIENCE

SQL DATA ANALYST/ADMIN REMOTE

DEPT OF DEFENSE JULY 2023- MARCH 2025

Monitor and Support Talent Data Factory, ETL Talent Pipeline and Power BI Dashboard.

Collect all data from EDI and various flat file sources for MHA Talent ETL Data Factory for Power BI and SSRS reports.

Assist database administration team with data confirmation for implementation to production environment.

Perform daily on perm and cloud server connection health check for weekly data transfers of large data sets.

Prepare and distribute daily Talent and SharePoint sever health care data transfers Power BI and SSRS reports.

Perform weekly SQL API code review for ETL, Power BI and SSRS reports, database maintenance and backup.

Lead personnel for ALL weekly and monthly ETL/ data loads into Talent Azure data factory.

Monitored MHA employee and contractor dashboard for Ad hoc reporting request ticketing system.

Monitor and support DoD employees and contractors with all API DHA Health reporting issues on DOHA website.

Developed and maintained SQL stored procedures for weekly and monthly DHA reporting updates and backup.

Assist other teams for Talent data factory, data issues for All Talent pipeline and Power BI jobs scheduling.

Distribute All email announcement for All New DoD Data Loads and All Data updates.

Collaborate with different data management teams for support for data analysis and reporting data updates.

SQL DEVELOPER/ADMIN REMOTE

DEPT OF VETERIANS AFFAIRS JULY 2021- JULY 2023

Monitor and Support Azure Data Factory, ETL and SharePoint Pipeline and Power BI dashboards.

Trouble shoot all Azure ETL Pipeline job failures and ETL, SSRS and Power BI Reports.

Assist database admin team with ETL package and Power BI, API developments and requirement gathering.

Testing New ETL workflow development for implementing into the production environment.

Prepare and distribute daily Azure and SharePoint sever and Power BI dashboard health care email.

Perform weekly SQL code review for Power BI/SSRS reports, database maintenance and backup.

Lead personnel for ALL weekly and monthly ETL data loads into API Azure data factory.

Developed new Power BI dashboard item for reporting veterans benefits claims status on monthly bases.

Monitor and support VA Help Desk for ICAMP website SSRS and API Power BI reports.

Monitor and support VA employees and contractors with all VA ICAMP website data issues.

Developed and maintained stored procedures for ALL weekly and monthly reporting updates and backups.

Assist other teams for Azure data factory, Power BI data issues and All pipeline jobs scheduling.

Served as SME with several clients to retrieve and manage client EDI and flat source data.

LEAD SQL DEVELOPER/SQL DBA NEW YORK, NY

TEACHER’S RETIREMENT SYSTEM NYC NOV 2019 – DEC 2020

Analyze and test migrated data from legacy system to new SQL RDS system and Azure Database.

Assist lead developer with Data Migration and Bridge mapping for ALL SSRS reports from cloud SQL 2017.

Maintained and Support ALL SSRS reports, distribution and data updates using SQL 2019

Monitor Client Azure cloud database and Support end users with data access and any ad hoc reports request.

Create and execute migration test cases from business specs and data mapping for testing migrated data.

Assist developers with report layout changes, new data mapping, data modeling and documenting updates.

Lead team in Scheduled Maintain and Support all daily, weekly, and monthly reports on AWS RDS.

Scheduled and monitored reports database and client azure database for weekly and monthly backups in AWS.

Build, monitor database tables, triggers and indexes using replication data from migration.

Using SQL Server replication for server modernization and data migration and clustering indexing.

Using Availability group with always on for standard and ad hoc database reporting SSRS and SSIS

Maintained and support all Stored Procedures for the SSRS reports using Jupiter software.

Lead developer support for offshore clients with ALL .Net C# applications and troubleshooting all SSRS &SSIS reports.

SQL DEVELOPER/ADMINISTRATOR IRVINGTON NY

EILEEN FISHER NOVEMBER 2018 – JUNE 2019

Assist with SQL PLM System Migration from Windows 8r2 server to AWS RDS Windows 10 cloud servers with live data.

Lead developer with Migration for Live data for SSRS reports and ALL SSIS Packages from SQL 2008R2 to cloud SQL 2012.

Maintained and Support ALL SSRS reports and SSIS Informatica packages using SQL 2012 & 2008R2.

Lead Support for ALL PLM users and Vendors accounts from NYC, Hong Kong, and the UK using Azure virtual DB

Lead Support for all ETL/EDI Informatica cloud data transactions to Hong Kong on Azure virtual machine.

Lead team in Scheduled Maintain and Support all API daily, weekly, and monthly reports on AWS RDS.

Scheduled and supported all PLM style and material daily and weekly bridges.

Build, unit testing and deploying new and updated reports using SQL 2012, 2014 and Visual Studio 2012, 2014 and 2017.

Maintained and support all Stored Procedures for the API SSRS reports using bit bucket.

Lead Support for all offshore clients for troubleshooting SSRS &SSIS reports.

Knowledge of SDLC working with BA and Account managers for reports specs to create New SSRS reports.

Performed daily, weekly, and monthly PLM/SQL database and C# application backups using SQL 2012.

Configured IIS for new AWS RDS server, adding role permissions and monitor web site/service for EL and SSRS server.

Lead developer to Trouble shoots ALL report errors, All data cleaning and documentation process for PLM System.

Maintain and Support Zendesk and Bugzilla trouble ticket systems.

SQL DATABASE/ETL DEVELOPER BRONX, NY

AFFINITY HEALTH PLAN MARCH 2017 – AUGUST 2017

Monitor and maintained Data warehouse with 4+ Tera bytes of data for daily processing and reporting.

Monitor and support secured online vendor staging database for updates with Meta data and various data formats.

Perform daily, weekly, and monthly database backups and coordinate files for offsite storage.

Unit testing migration and data cleaning of over 750 API ETL Informatica cloud packages for server upgrade from SQL 2003 to SQL 2016 for daily processing.

Unit and performance testing for all ETL Informatica packages including connections to MSSQL, MySQL, PL/SQL Databases.

PL/SQL, SQL and MSSQL Query performance tuning, optimization, and table normalization

Database reporting via EDI for SSIS, SSRS, SSAS, Crystal, T-SQL and TABILAU for financial, statistical and membership enrollments.

Use ASP.Net C# and BI Studios to create shell scripts for Data warehouse updates and modify SSIS packages.

Coordinate weekly server upgrade status meetings with three different teams and team members, supervisors, and managers.

DATABASE ADMINISTRATOR/SQL DEVELOPER NEW YORK, NY

MAXIMUS INC. AUGUST 2015 – MARCH 2017

Lead for Analyzing & preparing client EDI data files of various formats for conversion and load into SQL/Azure RDBMS.

Maintained secured online data warehouse for updates with API & EDI and various data formats on Azure cloud DB.

Perform daily, weekly, and monthly database backups and coordinate files for offsite storage.

Assist state workers, external and internal clients with remote access issues, file storage and file recovery.

Maintaine and monitored several database performances including Oracle, MSSQL, MySQL, PL/SQL, and Access.

PL/SQL, Oracle, MSSQL and T-SQL Query tuning, optimization, and table normalization

Assist Network dept with IIS monitoring for SSRS web server reporting.

Database support via SSIS/ETL Informatica, SSRS, SSAS, Crystal and TABILAU for financial, statistical data.

Use ASP.Net C# and Alteryx to create and modify database reporting interfaces and SSIS packages.

Support All ETL/EDC data transports to NYS department of health and department of Finance.

Coordinate weekly database status meetings with three different teams and team members, supervisors, and managers.

SQL DATABASE/ETL ANALYSTS NEW YORK, NY

EMBLEM HEALTH SEPTEMBER 2014 – MARCH 2015

Lead Developer for email notification web service using BIDS 2008 and Alteryx for some SSIS packages.

Automated Inventory Forms Order Process with T-SQL stored procedure and SSIS 2008 package.

Processed daily, weekly, and monthly Mass Merge Mailing SSIS 2008 Production Packages.

Created SQL SSIS Informatica and SSRS reporting database and automated the reporting process using ETL 2008.

Converted DTS/SSIS 2000 packages to ETL Informatica 2008 packages and updated all outdated stored procedures.

Created Shell scripts and API interfaces Using ASP.Net C# and Alteryx

Assist Account manages with daily excel spreadsheet extractions for download and uploads.

Preformed daily, weekly, and monthly database backups.

SQL DATABASE ADMINISTRATOR LONG ISLAND CITY, NY

EAST COAST LIMOUSINE OCTOBER 2013 – NOVEMBER 2013

Installation and Implementation of MSSQL Server 2008R2 & 2012 and Server updates.

Use ASP.Net C# and BIDS to create dashboard for Automated Reports Generation.

Designed, Analyze & test new versions of the Client Relational DB2 RDBMS with clustering Indexes.

Program script and API for Oracle Database Tables and Table Nominalization for Client Databases.

Created and Design T-SQL SSRS, ETL Informatica and SSAS & Crystal Financial Reporting System.

Assign access permissions, roles, and privileges to client T-SQL Database & Oracle Database.

Import/Convert Access database and excel spread sheet to T-SQL & Oracle Database.

Ensured that storage, archiving, back-up, and recovery procedures are functioning correctly.

Monitored performance and managed parameters to provide fast query responses.

WEB/SQL DATABASE DEVELOPER SCARSDALE, NY

ZACHY’S WINE & LIQUOR JUNE 2012 – February 2013

Lead Developer with Single Sign-On development for Zachys website.

Lead Developer C# .Net Active Directory Application to create New User Profile.

Developed several SAP Crystal, Cube & SSRS Reports for Inventory, and Invoicing.

SQL 2008R2 & Oracle Database backup, recovery and data analyst using OLAP & MySQL profiler.

Trouble shoot bottle neck issues on Zachys web site for retail, auction, and storage.

Maintain internal IT helpdesk for several companies.

Responsible for importing access and excel flat file to T-SQL DB for weekly cost report distribution.

Program and Process DB2 Production jobs for billing department.

Programmed stored procedures & triggers to create customers statements.

All Development done within the Microsoft Visual Studio ASP.Net 2010 & SQL 2008

.NET/SQL DATABASE DEVELOPER VALHALLA, NY

BRS SYSTEMS L.L.C. MARCH 2010- August 2011

Developed Client Statement SSRS & RTE web reporting service using C#, MVC & SQL 2008R2.

Developed SharePoint Reporting Service with 50 trea byte of data source.

Development of SharePoint 2010, C# .Net and MVC Imaging Dental Application,

Developed QB T-SQL applications for ADP system interrogations, using Visual Studio C#

Process and Monitor DB2 Production Jobs for report distribution on Oracle Database.

Lead developer for EDC data cataloging and transmissions to multiple dental offices.

Lead Oracle DBA on a team of three, Trouble shooting Oracle & MySQL database for bottle neck processing via OLAP.

Developed .Net Web form Invoicing Application using C# Created RDBMS clustered Index.

Automated Billing system with .Net windows shell script & web form Application, Config IIS control.

Developed and Design T-SQL database & C# Stored Procedures and triggers.

Designed, Created and Backup Oracle Database for Production processing.

All Development done within Microsoft Visual Studio ASP.NET 2010 C# & T- SQL environment.

DATABASE ADMINISTRATOR/DEVELOPER WHITEPLAINS, NY

KRASDALES FOOD INC MARCH 2008-NOVEMBER 2009

Database error handling and performance tuning processing AS400 DB2 production Jobs.

Create & Update Dept. database via MySQL Query Analyzer & Enterprise Manager.

Designed logical & physical databases for RDMS & SSRS & Crystal reporting.

Developed ETL Informatica & SSRS and MySQL SSAS Cube reports for product inventory.

Created clustered Index and database Replication preformed all DB backups.

Programmed stored procedures, scripts and triggers for reporting services using C# .Net.

Documentation for installation of all new SQL Server 2005/2008 DB apps.

All work done within a SQL 2005/2008 Database environment.

ASP.NET C# PROGRAMMER SECAUCUS NJ

THE CHILDREN’S PLACE September 2002 – November 2007

Perform testing of New Apps created with T-SQL server2000.

OOP coding and Implementation of new programs in C# & MVC, setting IIS for web calls.

Maintain dept. data warehouse via T-SQL 2005 Server Manager.

Developed New Web form & Win form applications for P.O.S. posting using C+, C# & MVC.

HTML & XML code modifications, Windows shell scripting for DB reports.

Created Crystal and cube Reports for Dep. Head using ASP.Net and BI in C#

Created weekly and Monthly SSRS report based on Child Support System.

Responsible for scheduling SSIS production repots using CA-Scheduler.

All programming work done in Visual Studio ASP.Net 3.0/3.5 environment in C+.

Contact this candidate