Database Software Development Expert Specializing in Data Warehousing and Business Intelligence

Technical Consultant #1981


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
Save Resume #1981
to Contact Form?

You must first click "Yes" to save this resume

Submit Request

You have no Saved Resumes

Add resumes within our various Ares of Expertise by clicking "Add Resume(s)" below.

Add Resume(s)