We provide IT Staff Augmentation Services!

Sql Database / Lead Bi Developer Resume

SUMMARY

  • Over 15 years of experience in designing, developing, enhancing and maintaining large data sets processed through the MS BI stack (SSIS, SSRS and SSAS) of Microsoft SQL Server and Oracle.
  • Proven expertise in all the stages of Software Development Life Cycle including requirements analysis and design, implementation, integration and testing, deployment and maintenance.
  • Experience in multiple developmental environments like onshore/offshore, small/large IT teams, business and finance teams.
  • Extensive experience in data warehousing, data analysis and data mining.
  • Extensive experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)
  • Proficient SQL development skills including writing stored procedures, views, indexes and user - defined functions.
  • Strong ETL skills, knowledge and experience in developing data transfer, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of T-SQL.
  • Experience in developing User and management reports using MS SQL Server Reporting Services (SSRS).
  • Convert procedures with table reads to views or functions.
  • Improve logic and performance of complex stored procedures.
  • Use parameters to avoid table scans of large tables.
  • Add appropriate primary key indexes to tables.
  • Add foreign key table joins for referential integrity.
  • Create SSAS data warehouse for data quality / reliability.
  • Create SSIS packages and automate regularly scheduled ETL jobs.
  • Create SSRS, Cognos, Tableau, Looker reports to track baseline performance trends.

TECHNICAL SKILLS

  • TCP/IP, DNS, DHCP, IIS 6 & 7, Active Directory
  • Windows 10, Win8, Win7, Vista
  • T-SQL, stored procedures, functions table design, constraints, joins, views parameters, data warehouses, OLTP
  • Management Studio, Azure Data Studio, performance tuning and optimization
  • Dimensional modeling, MDX, DAX
  • Business Intelligence Development Studio (BIDS), Data Tools (SSDT) spark lines, drilldowns, cascading parameters
  • Oracle 10 & 11
  • Visual Studio.NET : 2015, 2010
  • PowerBI, Informatica, Tableau
  • VMWare, Azure DevOps / Data Lake / Data Factory / Docker / Kubernetes
  • XML / XAML / JSON

PROFESSIONAL EXPERIENCE

Confidential

SQL Database / Lead BI Developer

Responsibilities:

  • Imported, exported, consolidated and cleansed SAP global revenue data with update statements and SSIS ETL packages.
  • Created dozens of tables & stored procedures in T-SQL for SQL Server 2016 SSAS / MDM tabular data warehouse for staging 2 million records of customer c ontract and pricing data.
  • Worked with large offshore accounting & QA team in the Philippines to cleanse SAP data for GDPR standards .
  • Developed Tableau data visualizations & dashboards to show changes in metadata sums and counts for all imported data.

Confidential - Chicago, IL

SQL Database / Lead BI Developer

Responsibilities:

  • Loaded SSAS tabular data warehouse with SSIS ETL packages for customer propensity and product purchasing analysis .
  • Updated stored procedures, views and charted data trends in Tableau dashboards for all credit union customers.
  • Implemented merge functionality in T-SQL stored procedures and ETL SSIS packages.
  • Deployed database sources for Tableau data visualizations on MDM, DevOps & Azure Data Lake / cloud servers.
  • Created and configured PowerShell commands with Azure Active Directory and Blob storage over a secure HTTPS channel data pipeline.
  • Utilized Azure Data Factory to move data between on-premises and the cloud using a self-hosted integration runtime in the data-flow steps.
  • Implemented 300 primary/foreign keys for SQL table joins and data integrity in the new data warehouse.

Confidential - Rockledge, FL

SQL Database / Lead BI Developer

Responsibilities:

  • Created and updated dozens of T-SQL tables, views, SSRS reports & stored procedures.
  • Managed data migrations from Oracle on DevOps, Azure Data Lake in Azure Data Studio with SQL Server tasks & ETL SSIS packages.
  • Trained 3 junior software developers & 2 business analysts on Tableau and SSAS tabular data warehouse.

Confidential - Baltimore, MD

SQL Database / BI Developer

Responsibilities:

  • Developed SSAS tabular data warehouse for use in project bid tracking analysis with Tableau dashboards.
  • Utilized Visual Basic.NET & Git for source control; implemented subqueries and CTEs in stored procedures.
  • Documented all unit testing procedures in T-SQL and created data flow diagrams in MS Visio for entire project.

Confidential - Arlington, TX

SQL Database / BI Developer

Responsibilities:

  • Completed agile/scrum SSIS ETL migration project for 200 Oracle tables and data with Visual Studio.
  • Replicated table schemas and synchronized surrogate key attributes for migrated T-SQL databases.
  • Automated data imports for development & production servers using merge stored procedures.

Confidential - Charlotte, NC

SQL Database / BI Developer

Responsibilities:

  • Optimized T-SQL stored procedures for Everest financial application and improved management dashboards.
  • Ported numerous complex PowerPivot & SSRS drill-down reports and wrote custom functions.
  • Developed & tested new SSRS reports with user input parameters in SharePoint user environment.

Hire Now