SUMMARY:

• Business intelligence/data architect with extensive background in database and data warehouse design and architecture. Experienced in BI methodology, architecture and project management. Strong background in enterprise architecture and governance.
• Proficient in data modeling using Kimball, Inmon and hybrid methodologies.
• I enjoy helping organizations develop strategies and initiatives in the areas of:
• Enterprise architecture
• Business intelligence (BI) and data warehousing (DW) with emphasis on performance management
• Data governance and master data management
• Enterprise data modeling (subject area, conceptual and logical) with emphasis on data integration)
• Dimensional modeling using the Kimball methodology
• I enjoy every aspect of BI and data warehouse design and development

TECHNICAL SKILLS:

Skills: SQL Server Visual Basic 4.0 - .NET C#, XML Unix Web Services Data Modeling, Database Design Data Governance Data Architecture Data Management Data Warehousing Database Architecture Business Analysis M.S. Access Crystal Reports Star, Snowflake Schema/Kimball, Inmon Methodology Data Governance Teradata DB2 XML, SOAP ETL DTS SSIS SSAS SSRS System Analysis Cube Development T-SQL, MySQL, PL/SQL Agile Development Microsoft Team Foundation Server Business Intelligence SQL Tuning

PROFESSIONAL EXPERIENCE:

Confidential, Denmark, Copenhagen/Warsaw

Business Intelligence Architect

Responsibilities:

• Responsible for introducing Power BI governance
• Worked with business stakeholders to document data governance
• Translated business priorities into requirements for enterprise architecture domain and developed architecture roadmap
• Responsible for the project to architect service bus architecture that cleaned and established data lake for various sources and integrated them via service reporting bus architecture. Main goal was to deliver cleaned and one source truth data to reporting layer
• Managed ETL developers on a project that was designed to establish data mart from variety of sources
• Designed new server farm including hardware specs and functional development environment replicated from production server
• Managed platform design and content
• Participated in creation of high-level estimates for prospective BI solutions

Confidential, Orlando, Florida

Senior Data Warehouse Engineer

Responsibilities:

• Provided BI development using SSIS, SSRS, T-SQL
• SQL Server database administration with backups, partitioning, performance tuning and maintenance
• Developed data migration routines and ETL development to accommodate new business requirements
• ETL development and design
• Developed migration and testing procedures
• Developed routines to populate staging and data warehouse
• Developed enhancements to ETL routines and data warehouse design
• SSRS development on existing and new reports
• Dashboard development, KPI with Power BI
• Data mart design and development
• Big Data, Hadoop, Hive, Python taken
• Agile environment

Confidential, Melbourne, Florida

Senior BI Developer (Contract Position)

Responsibilities:

• ETL development and design
• Cube development
• Developed migration and testing procedures
• Developed routines to populate staging and data warehouse
• Developed enhancements to ETL routines and data warehouse design
• SSRS development on existing and new reports

Confidential

Data Warehouse Architect (Consulting)

Responsibilities:

• Data Warehouse design and development
• Business intelligence and analytics using Microstrategy
• SSIS, SSAS, SSRS design and development
• Interacting with clients and gathering requirements
• Data modeling, data architecture
• Documentation
• Business users/junior developers mentoring and
• Applied best ETL principles
• ETL development and design
• Cube development
• Migration scripts and testing
• Developed routines to load into staging area and data warehouse
• Responsible for data analysis and defining meta-data
• Provided development to generate facts, dimensions and cubes for end user query and analysis
• System and data analysis
• Developed enhancements to ETL routines and data warehouse design
• Developed SSIS/ETL packages pulling data from source to staging and data warehouse, maintained and modify existing cubes using SSAS
• Data mapping and dimensional modeling
• Optimized performance using surrogate keys, natural keys, indexes and look-ups between dimension and fact tables
• Migrated data from various sources (Flat Files, Oracle) to MS SQL Server via ETL/SQL scripts/SSIS packages
• Deployed SSIS packages and automated SQL Server agent jobs from development to QA to production
• Optimized stored procedures, SSIS packages, table indexes design, C# script tasking development cd
• Microstrategy development d

Confidential, Las Vegas, Nevada

Senior Business Intelligence Developer, (Permanent Position)

Responsibilities:

• Worked within applicable change management and agile methodology
• Created conceptual and detailed design documents
• Physical data modeling
• Captured and documented ETL Requirements
• Designed, developed, and tested processes for extracting data from legacy systems and production databases
• Designed, developed, and tested processes for validating and conditioning data prior to loading into a data warehouse
• Performed various ETL testing
• Designed, developed, and tested processes for loading initial and cyclical data into a data warehouse sourcing from SQL Server, AS400 and Teradata
• Created or modified programs with or without written program specifications, consistent with department procedures, philosophies, and standards
• Contributed to business intelligence solution design, integration, data sourcing and transformation, database design and development (logical / physical) and tool implementation related to data warehousing
• Participated in 24x7 on call casino operations

Confidential

Data Warehouse Architect (Contract)

Responsibilities:

• Worked with SQL Server 2008 R2, MySQL, developing data warehouse using SSIS, SSRS, Star and Snowflake model with Kimball methodology
• Determined overall data warehousing standards, guidelines, best practices and approved modeling techniques and approaches
• Collected requirements from business users to create logical data model
• Reviewed and developed logical and physical data models, business flow
• Translated business requirements into technical architecture vision and implementation plan
• Responsible for defining the complete data warehouse architecture.
• Defined requirements, data and technical architectures for the data warehouse.
• Planned and designed the ETL processes involving data quality and testing
• Managed the process of discovery
• Defined metadata standards for the data warehouse
• Implemented SQL Server Change Data Capture
• Directed and designed the information delivery and access for the data warehouse
• Developed Functional requirements and design documentation
• Microsoft Team Foundation Server environment

Confidential

Database/SSIS Developer (Data Migration Project) (Contract)

Responsibilities:

• Business Analysis, collected requirements from end business users
• Developed data migration scripts using SSIS and T-SQL from legacy systems
• SSIS C# script tasking development
• Developed ETL packages to transfer and clean data from DB2 to SQL Server 2005, 2008 and DB2
• Created audits and Monitor Data Extraction

Confidential

SQL/Report Developer (Contract)

Responsibilities:

• Teradata scripts development
• Collected user requirements and developed procedures, reports within Teradata environment
• Designe and developed SSIS packages to support financial activities.
• Develope SQL scripts, SSIS packages to transfer large amounts of data through the different systems
• Designed and developed reports to retrieve data from various SQL Servers using SSRS and MS Excel
• SSIS .Net script tasking development

Confidential, San Diego, California

Data Warehouse Developer (Contract)

Responsibilities:

• Worked as part of the business intelligence group using SQL Server 2008, Visual Studio 2010.
• Developed and schedule SQL jobs to run every day to support banking activities.
• Developed ETL packages and SQL jobs using SSIS packages to transfer large amounts of data through different banking systems.
• Participated in daily scrum meetings and provide feedback on how to improve processes.
• Developed SAP BW components
• Crystal Reports/Microstrategy development

Confidential

Report and Data Warehouse Developer (Contract)

Responsibilities:

• Created data marts using star and snowflake schema
• Database modeling and de-normalization
• Created scripts for slow changing dimensions
• Created reports in SQL 2008 (SSRS) within a SharePoint
• ETL development, developed scripts and SSIS packages
• Database development included triggers, functions, stored procedures, views
• T-SQL development
• Analyzed existing architecture and suggest improvements
• Collected user requirements and developed documentation

Confidential

SQL Database Analyst/Developer (Contract)

Responsibilities:

• DTS/SSIS development based on user requirements developed SSIS and added functionality to existing DTS or SSIS packages
• T-SQL development, stored procedures development performance tuning and troubleshooting
• Analyzing existing database architecture and suggested improvements
• Administer various SQL server tasks: backup, performance tune up, jobs
• SSRS development based on user gathered requirements

Confidential

SQL Database Analyst/Report Developer (Contract)

Responsibilities:

• Database design and development
• Upgraded existing SQL database to new functionality and better performance by normalizing database and tuning SQL server
• Upgraded from MS SQL server version
• DTS development for migrating data from different sources on timely basis
• SQL scripting, adding new transact SQL procedures to a database, improving existing ones by analyzing and tuning them, database tuning, views, jobs and triggers development
• XML development
• Developed documentation
• Gathered information from users and recommended improvements

Confidential

T-SQL /VB Developer (Contract)

Responsibilities:

• Database modeling, analyzing and improving query performance, new database development in SQL Server
• DTS and application development using Visual Basic 6
• Creating Active X scripting and VB scripting
• Meeting with users and business analysts to gather new requirements
• Analyzing old and new requirements and business logic flow to create new specs
• DTS development and migrating from previous database versions
• SQL scripting, adding new transact SQL procedures, improving existing procedures by analyzing them, database tuning
• Writing documentation
• Crystal Reports development
• Visual Basic 6 development

Confidential, Pinellas Park, FL

Database Developer /Visual Basic Developer (Permanent Position)

Responsibilities:

• General responsibilities include administering, maintaining all existing SQL servers across enterprise
• Developed and implemented policies and procedures for ensuring the security and integrity of the company databases
• Implemented data models and database design, data access and table maintenance, resolved database performance issues, database capacity issues, replication, and other data issues
• Designed physical data storage
• Designed maintenance plans, backup strategy, disaster recovery plans, evaluated and monitor databases to resolve performance issues.
• Configured database parameters and prototyped design against logical data models
• Responsible for defining data repository, data dictionaries and data warehousing requirements
• Built ODS, cubes, stored procedures and DTS packages.
• Created reports using Crystal Reports
• SSAS development using MDX for home insurance industry
• DTS development
• Data modeling
• Migrated data from Btrieve and M.S. Access to SQL 2000
• Built migration routines in Visual Basic and DTS
• Created logins, groups, users, roles, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• Added and improved existing Active X objects
• Visual Basic 6 and .NET Development

Confidential, Tampa, FL

DBA/Developer (Contract)

Responsibilities:

• Data modeling, SQL Server database and stored procedure design and development Worked on replication design and support
• Created views, stored procedures, triggers and DTS packages
• Developed utilities in Visual Basic 6.0

Confidential, Sarasota, FL

DBA/Developer (Contract)

Responsibilities:

• Designed and created new databases and tables in SQL Server, optimized databases and tables for storing large data types
• Migrated M.S. Access to SQL server 7.0 and linked M.S. Access to SQL server 7.0
• Tuned SQL server logical and physical structures and T-SQL queries
• Maintained applications written in Visual Basic 6.0 with SQL server 7.0 back end
• New software design and development, which included rewriting application into 3-tier architecture using COM and MTS.
• Active X development
• Power Builder development end-users
• Created documentation for developed solutions

Confidential, Clearwater, FL

DBA/Developer (Contract)

Responsibilities:

• Administer SQL server 7.0 and M.S. Access databases
• Migrated M.S. Access to SQL server 7.0
• Designed and developed databases in SQL server 7.0, link databases between M.S. Access and SQL server. Developed stored procedures and triggers
• Designed and developed applications using COM technology in Visual Basic with back end SQL server and M.S. Access
• Developed reports using Crystal Reports.
• Windows NT network administration.

Confidential, Edmonton, AB

DBA/Developer (Contract)

Responsibilities:

• Designed and developed relational database in SQL server, created stored procedures, tables, user data types, indexes and views
• Gathered information from end-users in order to determine application and database scope
• Designed and developed front-end multi user application written in Visual Basic
• Produced help files in HTML, created documentation and trained users

Confidential

Application/Database Developer (Permanent Position)

Responsibilities:

• Designed and developed new software and relational databases in M.S Access and SQL server
• Maintained existing programs using Visual Basic 4.0,Visual Basic 5.0, Access 97, Visual C ++ on Windows 95 and Windows NT platform.
• Developed and update crystal reports based on user requirements and maintained existing reports
• Converted applications from 16-bit into 32-bit version to connect with SQL 6.5 and MS-Access databases
• Generated new stored procedures in SQL 6.5 server environment to improve performance
• Created exe and dll files
• Developed applications in Power Builder

Confidential

Application Analyst (Permanent Position)

Responsibilities:

• Developed and maintained applications in Visual Basic, MS-Access, and Power Builder
• Created and designed database in MS-Access to keep track of employee performance
• Developed and designed application to archive existing data from the database.
• Maintained DB2 database and work on Visual Basic application to retrieve data from the database
• Generated documentation and help files for a new and existing application.
• Provided technical support for users
• Performed upgrade and hardware maintenance