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.