Database Software Development Expert Specializing in Data Warehousing and Business Intelligence

Expertise

Technical Skills

• Microsoft SQL server 2014, SQL server 2012, SQL server 2008; SQL Data Tools
• Oracle PL/SQL and Oracle SQL and Oracle SQL PLUS
• Data Base Administrator (DBA) and Data Architect.
• Data Architect, Metadata Architect, Data Warehouse Architect.
• Software development life cycle; Agile and Waterfall
• Data analysis, data analytics and data mining
• Data scientist
• Metadata architect
• Business Analyst - Requirements gathering and documentation; source-to-target mappings.
• Interviewing business users; needs assessment and analysis; C-Level Presentations.
• Business Analyst - Business Intelligence: Requirements gathering and documentation; source-to-target mappings.
• Master Data Management, MDM and Master Data Services (MDS)
• Microsoft SQL server, SSRS, SSIS, SSAS, SQL server data tools, BIDS, T-SQL
• Cognos suite of business intelligence tools.
• SQL complex queries, stored procedures, functions, triggers
• SQL optimization and performance tuning; SQL Profiler; Database Engine Tuning Advisor
• SQL in the cloud; cloud computing
• Crystal; Toad; TFS; Subversion; SharePoint
• Best practices for data management, data warehouse and software development.
• Data steward and Data Governance Board
• ETL (Extract Transform and Load)
• OLAP, OLTP, Star Schema, Snowflake Schema
• Medical, hospital and clinical data; data outcomes in health care, HEDIS, HIPAA and medical data privacy.
• Health care data; Medicare; Medicaid and Compliance
• Big data - The 5 V's: Volume, Velocity, Variety, Variability and Veracity
• Best practices in data cleanliness, data scrubbing, data purity and data compliance.

Experience

Undisclosed Financial Institution, 2016 - Present

Principal SQL Server, SSIS, SSRS Developer and Data Architect

• Database developer and business intelligence development.
• SQL Server: Design, build, and test 2 new SQL systems.
• For the U.S. Government, high priority project ('Too Big To Fail'): Business intelligence and reporting, Federal Government compliance for mortgage insurance and flood insurance; and Intraday Liquidity Monitoring System.
• ETL and using SQL stored procedures and SSIS (SQL Server Integration Services) packages.
• Create SQL Server objects (tables, views, stored procedures, functions, triggers).
• Write test scripts for all use case scenarios and all processing paths, and automate scripts.
• Document all development and testing work and results.

United Health Group, Minnetonka MN, 2016

Principal SQL Server, SSIS, SSRS, Data Architect, Server Developer, Consultant, Cloud Computing

• Design, build, and test a new system.
• Business intelligence and reporting, Federal Government compliance for TriCare (military, veterans and dependents) health insurance analytics.
• ETL and using SQL stored procedures and SSIS (SQL Server Integration Services) packages.
• Create SQL Server objects (tables, views, stored procedures, functions, triggers).
• Write test scripts for all use case scenarios and all processing paths, automate scripts.
• Document all development and testing work and results.

Lumbini Medical College - Teaching Hospital - Research Center, Tansen, Nepal, 2016

Principal SQL Server Developer, Consultant and Cloud Computing, Data Architect, Database Developer, and Business Intelligence Developer

• Data Architect, Database Developer, and Business Intelligence Developer for the SQL Server 2016.
• Created the first "Database in the Cloud" (Microsoft Azure) for Lumbini Medical College
• Gave a 2 hour lecture with open invitations to the entire campus and faculty, on cloud Computing and first database in the cloud design, development, security and performance.

Independent Consultant, 2016

• Technical lead and data warehouse manager, superior written and oral communication skills.
• A seasoned IT International Consultant (London, Hong Kong, Beijing, Phnom Penh, Kampot, Shanghai, Singapore, Kuala Lumpur).
• Subject Matter Expert, developing business intelligence end-to-end solutions, ETLs, reports and in understanding OLAP, business intelligence and data warehousing, complementary to traditional OLTP architectures and methodologies.
• Explain complicated ideas in simple terms to colleagues.
• Professionally critique and peer review an idea when appropriate building teams and professionals.
• Subject matter expert, mentoring less experienced staff in developing Business Intelligence end-to-end solutions, ETLs, reports and in understanding OLAP, Business Intelligence and data warehousing as different from yet complementary to traditional OLTP architectures and methodologies.
• International Consultant: Consulting clients in: London, England; Hong Kong, Beijing and Shanghai, China; Kuala Lumpur, Malaysia; Singapore; Phnom Penh and Kampot, and Kingdom of Cambodia.

Wilson McShane Company, Bloomington, MN, 2015 - 2016

Principal Data Architect and Principal SQL Designer and Developer

• Data Architect, Database Developer and Business Intelligence Developer.
• SQL Server 2014: Design, build, and test from scratch a new system for Business Intelligence and Reporting and Federal Government compliance reporting including "ObamaCare" 1095.
• ETL design and development using SSIS 2014 and complex stored procedures.
• Report design and development using SSRS 2014.
• Extreme Agile design and development with daily early morning scrum with CIO.
• Principal "back end" designer, data architect and developer.
• CIO was principal solutions designer: Work closely with CIO on day-to-day basis.
• Design and Develop Business Intelligence Reports, Queries, solutions.
• Microsoft SQL Server Data Tools, BIDS.
• Created source-to-target mappings.
• Mentored less experienced developers; Peer reviewed other developers' work.
• Introduced and pioneered new processes and technologies.
• SQL Server 2014 optimization and performance tuning.
• Full ETL life cycle - design, develop, test, verify, sign-off, implement, go-live.
• Technology: Microsoft SQL Server 2014; T-SQL, Data Tools, SSRS and SSIS.

Dakota County Government, MN, Principal Business Intelligence - ETL Developer, 2011 - Present

• Data Architect, Database Developer and Business Intelligence Developer.
• ETL Software Development Team Lead
• Write complex SQL queries and stored procedures: Both SQL Server and Oracle PL/SQL.
• Design and develop business intelligence reports, queries and solutions.
• Microsoft SQL server data tools, BIDS, Cognos suite of business intelligence tools.
• Create source-to-target mappings.
• Mentor less experienced developers; Peer review other developers' work.
• Introduce and pioneer new processes and technologies.
• Business analyst, data profiling and data analysis: Metadata modelling.
• Full ETL life cycle - design, develop, test, verify, sign-off, implement, go-live.
• Technology: Microsoft SQL Server 2008, 2012, 2014; SSRS, SSIS, SSAS, TFS 2010, Agile, CDD Reports, Zena scheduler, SunGard/IFAS ERP, SharePoint, Oracle PL/SQL, Cognos suite of business intelligence tools, BIDS, SQL server data tools, SQL server 2014, and SQL server 2012.

SurgiSoft Inc., Dallas, TX, Principal Consultant, 2013 - 2014

• Company experiencing explosive growth needed SQL server optimization and performance tuning due to seemingly small design imperfections and violations of "Best Practices" suddenly grew into major problems, slowness and deadlocks.
• Deadlock resolution, index optimization and database partitioning.
• Optimization of stored procedures; query optimization; and execution plan optimization.
• Technology: Microsoft SQL server 2008 - 2012, Windows Performance Monitor, SQL Profiler, SQL Database Tuning Advisor, and SQL Trace.

U. S. Bank Inc., Minneapolis, MN, Principal Business Intelligence - ETL Developer, 2012 - 2013

• Data Architect and SQL Developer for Dodd Frank project in capital markets - foreign exchange.
• Developed complex T-SQL queries and stored procedures.
• Data base developer and data management.
• SSIS, SSRS, complex SQL queries and stored procedures.
• Crystal and Toad.
• Created and automated SQL ETL testing library.
• Peer reviewed other developers' work.
• Automated testing and regression testing in SQL Server.
• Technology: Microsoft SQL Server 2012 - 2008, SSIS, SSRS, SSAS,T-SQL, Agile, and Crystal reports.

CHS Inc., Inver Grove Heights, MN, Principal Business Intelligence - ETL Developer, 2012

• SSIS, SSRS, complex SQL queries and stored procedures.
• Created and automated 1450 file ETL testing library.
• Created source-to-target mappings.
• Mentored less experienced developers and peer reviewed other's work.
• Performed business analysis, data profiling and data analysis.
• Data warehouse design and development (Star Schema and Snowflake Schema).
• Automated testing and regression testing in SSIS.
• Technology: Microsoft SQL Server, SSIS, SSRS, T-SQL Stored Procedures, TFS 2010, Agile, and SQL Server Agent scheduler.

Health Partners Inc., Minneapolis, MN, Principal Business Intelligence and Report Developer, 2011

• Report software development team lead.
• Wrote complex SQL queries, SQL stored procedures, SQL functions.
• Performed data profiling and data analysis and data analytics.
• Deployed new reports to Microsoft Dynamics CRM - Customer Resource Management system.
• Created library of test data for testing and verification.
• Mentored less experienced developers; Peer reviewed other developers' work.
• Technology: Microsoft SQL Server R2, SSRS R2, TFS, Agile, Microsoft Dynamics CRM; Subversion.

King Sihanouk Hospital Center of Hope - Sonja Kill Memorial Children's Hospital, 2010 - 2013

Data Architect and Data Management Best practices Consultant - On site in Kingdom of Cambodia

• Review data management practices at hospital and clinics.
• Best practices for SQL programming and software development.
• Review DBA practices at hospital and clinics.
• Performance monitor and tune-up data bases.
• Advise and mentor technical staff and upper management on best practices for data management.
• Data Architect for business intelligence design and development.
• Peer reviewed DBA's work.
• Technology: Microsoft SQL Server 2012, SQL Server Maintenance Plans, and SQL Server Catastrophe Planning.

University of Minnesota, Senior Data Architect and Senior Data Scientist, 2009 - 2010

• Report software development team lead.
• ETL - Extract Transform and Load - development team lead.
• Created testing and verification libraries, lead testing team.
• Wrote complex SQL queries, SQL stored procedures, SQL functions and triggers.
• Performed data profiling, data analysis and master data management.
• Performed business analysis and business requirements gathering.
• Wrote technical specifications: Created source-to-target mappings for ETL.
• Mentored less experienced developers and peer reviewed other developers' work.
• Designed and developed with end users, master data services for dimension tables updates.
• Technology: Microsoft SQL Server, SQL Server Maintenance Plans, SSIS, SSRS , Visual Source Safe, Oracle Data Warehouse interfaces with Microsoft Business Intelligence Development Studio (BIDS 2008); Sharepoint.

Hennepin County Government, Minneapolis, MN, 1999 - 2008

Positions held serving IT Department and District Court

• Manager of Business Intelligence and Reporting.
• Principal Data Architect and Data Warehouse Architect.
• Principal Business Intelligence Developer.
• Senior DBA.
• Senior Business Intelligence Developer.
• Report Software Development Team Lead.

Functions

• ETL - Extract Transform and Load - development team lead.
• Created testing and verification libraries, lead testing team.
• Wrote complex SQL queries, SQL stored procedures and SQL functions and triggers.
• Performed business analysis and business requirements gathering.
• Wrote technical specifications and peer reviewed other developers' work.
• Project Manager, data architect, data warehouse data architect and data mining.
• Performed data profiling and data analytics with statisticians.
• Served as Data Steward for District Court data and served on Data Governance Board.
• Created source-to-target mappings for ETL; OLTP and OLAP.
• Mentored less experienced developers in Software Development Life Cycle and Agile and Waterfall.
• Management of IT: Mentoring and Interviewing.
• Best Practices in Data Cleanliness, Data Scrubbing, Data Purity and Data Compliance.
• Technology: Microsoft SQL Server, SQL Server Maintenance Plans, DTS, SSIS, SSRS , Visual Source Safe and Microsoft Business Intelligence Development Studio.

Allina Health System Inc., Minneapolis, MN Data Warehouse Developer - Resource, 1997 - 1999

Business Analyst and Data Architect

• Design and develop enterprise data warehouse and data marts; Data Architect
• Best practices for data management and data bases and data warehouses.
• Testing and verification of data warehouse with end user involvement.
• Star and Snowflake Schema data modeling.
• ETL - Extract Transform and Load senior developer: Created source-to-target mappings for ETL.
• Wrote complex SQL queries.
• Data Steward and Data Governance Board.
• Performed business analysis and business requirements gathering.
• Wrote data warehouse technical specifications.
• Performed data profiling and data analytics of health care data with statisticians.
• HIPAA trained and certified.
• Full business intelligence development life cycle (end-to-end BI solutions).
• Technology: Oracle Data Warehouse with Microsoft SQL Server Business Intelligence reporting front end, Excel and Access front end applications.

University of Nebraska Medical Center, Omaha, NE, Principal IT Specialist, 1993 - 1997

• Design and develop data bases and applications for health care data.
• Outcomes reporting and health care reporting and data analytics.
• Data Steward and Data Governance Board.
• Project management and project estimates.
• Medical and hospital - clinical data.
• HIPPA and Medical Data Privacy
• Data outcomes in health care; health care data; Medicare and Medicaid data and compliance.

University of Texas Southwestern Medical Center, Dallas, TX, Principal IT Specialist, 1989 - 1993

• Design and develop data bases and applications for health care data.
• Health care reporting and data analytics.

University of Minnesota, St. Paul, MN, Senior IT Specialist, 1981 - 1989

• Design and develop data bases and applications.
• Software Instructor; business analyst and data analyst.
• Help Desk, database help desk and walk-in consulting.

Unisys Inc., Minneapolis MN and China, Systems Software Programmer Analyst, 1976 - 1981

• Design, develop, test, implement and document operating systems and data base management

Honors & Publications

Languages

• Italian; semi fluent conversation, reading, writing. (U.S.A. citizen, dual citizen with Italy, European Union, and ability to work and reside in European Union without visa or permissions.)

Academic and Professional Affiliations

• DAMA Data Management International Association - Minnesota Chapter
• Phi Kappa Phi (National Honor Society)
• Tau Beta Pi (National Engineering Honor Society)
• Delta Epsilon Sigma (National Catholic Honor Society)

Publications

• Author of articles and invited talks, subject matters in: Data Management and Database Design and Development.

Education

• M.S. Data Management and Applied Software, University of Texas at Arlington, TX
• B.S.C.S. Computer - Information Sciences (High Distinction) Institute of Technology, University of Minnesota, Minneapolis, MN
• B.A. Mathematics and Liberal Arts, (Summa Cum Laude) University of St. Thomas, St. Paul, MN