SUMMARY:

• To secure a challenging position as a Sr Data Warehouse Architect providing data analysis, OLAP data modeling, design, coding, testing, conversion, documentation, database development, and implementation of multidimensional databases (cube), ETL(extract, transform, load data) packages, enhancements and maintenance of legacy relational data warehouses, OLAP data warehouses, data marts, and application systems. I have over 20 years of Information Technology experience.

TECHNICAL SKILLS

• Mircrosoft SQL Server 2008R 2/2012/2014/2016/2017 , Microsoft Azure Cloud, SQL Server Integration Services (SSIS) ETL Packages), Teradata, MongoDB, Informatica PowerCenter Designer, Toad Data Modeler
• SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T - SQL, MDX Query Language, Oracle PL/SQL, Visual Basic 6, Active Server Pages, ASP, ADO, HTML, Dynamic HTML, XML, .NET Framework, Team Foundation Server (TFS), SQL Server Data Tools for Visual Studio (SSDT), MS SharePoint ServerVBScript, JavaScript, Cascading Style, ActiveX, ASP Components, COM/DCOM
• MS Internet Explorer, SQL Server Management Studio, Business Intelligence Development Studio, Reporting Services, MS Internet Information Server, MS Transaction Server, Windows 2016, Windows NT, MS VisioExcel 2016, Access 2016, Word 2016, Power Pivot, Power BI, Tableau Professional

PROFESSIONAL EXPERIENCE

Sr Data Warehouse Architect

Confidential - Phoenix, Arizona

Responsibilities:

• Gather and analyze the business requirements given by the sales, finance, upper management, and operations in order to build a solid reporting analytic solution to meet business need’s of internal and external customers.
• Designed a Logical Data Model (Toad) for implementing a Data Warehouse. Created SSIS packages (ETL) calling stored procedures using T-SQL to scrub, and pre-aggregate data from various production transactional databases (operations, sales, accounting). Created SQL Agent jobs to auto run on a daily basis for updating the Data Warehouse.
• Created Business Intelligence reports using SSRS, and Tableau for Designer customers and internal business users. Provided documentation on all aspects of the BI platform.
• Maintain and resolve errors due to Transactional Data Replication for seven on-premise SQL Servers for specific databases and tables.
• Implement database maintenance tasks on on-premise SQL servers and on Cloud Microsoft Azure SQL servers: cleaned out out dated processes running in production SQL Servers, set up alerts to notify when agent jobs failed, re-write queries for increased performance, ran auto script on index fragmentation on databases, manage database size, memory, and disk space, find expensive queries running on sql server causing website to run slow, set up backup and restore databases.
• Constant communication with upper management, web developers, and BI team to manage the company’s reporting needs and projects required by website development. Completed all projects with accuracy and within time constraints.

Sr Data Warehouse Architect

Confidential, San Diego

Responsibilities:

• Gathered and analyzed the business requirements given by the City of Hope cancer research team in order to provide a secure and HIPAA compliant data solution for cancer research analytics.
• Created the different types of data models required to implement into the data warehouse and data mart using Toad Data Modeler.
• Developed, implemented, and maintained a data warehouse (relational form) for data processing/massaging of data into staging, and core tables using Informatica Power Center Designer (creating source, target, mappings, mapplets, and transformations).
• Developed, implemented, and maintained a specific data mart (dimension and fact tables) based on data warehouse data, in order to provide analytics and visualization on cancer research.
• Attended team meetings to discuss and write a user change requirements, and implemented changes into the data warehouse, data mart, and Tableau reports.
• Data was composed of participants in the study, cancer registry data on participants, residence addresses, healthcare data from OSHPD, and questionnaire surveys gathered from participants.
• Provided teaching support for front-end analysis tool (Tableau) for the cancer research team members explaining relationships, aggregations and calculation of data in order to produce the answers needed for decision-making.
• Applied effective verbal and written communication skills with research scientists, managers, other BI developers, and data warehouse team to resolve data and programming issues. Completed all projects with accuracy and within time constraints.

Sr Data Warehouse Architect Consultant

Confidential

Responsibilities:

• Analyzed existing database systems for complete understanding of business requirements to create sales metrics for the merchandising team.
• Developed ETL packages using SQL Server Integration Services (SSIS) to extract, transform and load data from various database systems (Teradata, ParAccel, SQL Server) on a daily and weekly basis into development and production data warehouse (dimension and fact tables). Created bteq windows command scripts, bteq logs, ssis logs, package configuration files, event jobs to automate scheduling of SSIS packages using an ESP Scheduling Tool.
• Provided support for various business cubes (merchandising sales) using SQL Server Analysis Services (SSAS). Created around 40 calculated measures for analysis of sales using (MDX) query language. Supported ETL packages for processing of cube by partitions based on measure groups, and set up the bteq scripts, bteq logs, ssis logs, configuration files, event jobs to automate scheduling of SSIS packages using an ESP Scheduling Tool.
• Provided documentation on sale metrics describing the business logic, calculated measures, aggregations, and dimensions.
• Designed a logical data model and implemented the physical data model for an Operational Data Store (ODS) and build the various data marts composed of sales and marketing data.
• Developed ETL packages, configuration files, and SSIS Jobs using SQL Server Integration Services (SSIS) for loading historical data on a daily basis into staging and data warehouse (ODS) databases from various data systems (MongoDB, SugarCRM MySQL, SQL Server) in development, quality control and production environments.
• Developed stored procedures, views, and MySQL for massaging of data, aggregations, and calculations of data, creating measures for various business data marts.
• Gathered business requirements from users to understand the data, build data models, and reporting needs.

Sr Data Warehouse Architect Consultant

Confidential - Miami, Florida

Responsibilities:

• Gathered and analyzed the business requirements given by the commercial operation sales team and finance team in order to understand product data (medical devices) and sales (physicians and hospitals) used for business.
• Provided production support and enhancements for staging and OLAP relational data warehouse databases using ETL packages using SQL Server Integration Services (SSIS) for data processing from various legacy systems (ERP Navision systems, flat files) into the data warehouse on a daily basis. Data was comprised of customers, products, product categories, territories, and sales people for analysis of actual and forecasted sales.
• Developed, implemented, and maintained a multidimensional data model (fact and dimension tables) calling stored procedures for data processing/massaging of data into staging tables and data warehouse on a daily basis.
• Developed, implemented, and maintained various business cubes (sales and finance) using SQL Server Analysis Services (SSAS) database. Created around 50 calculated measures for analysis of sales using (MDX) query language. Set up SQL Job for automation for processing of data into data warehouse and datamart and for processing of cubes on a daily basis. Provided support for front-end analysis tool (Tableau) used by sales and finance team members for creation of reports connecting to the cubes.
• Assisted and provided technical knowledge to fellow BI team members to improve performance and implementation of data processes and cubes. Provided technical expertise for data modeling and creation of calculated measures for analysis.
• Applied effective verbal and written communication skills with business users, managers, other BI developers, and data warehouse team to resolve data and programming issues. Completed all projects with accuracy and within time constraints.

Data Warehouse Architect

Confidential - Sunrise, Florida

Responsibilities:

• Developing and implementing SSIS packages for importing Vendor data files (structured, semi-structured files (txt, xml, dat)) using MS SQL Server 2012/2014 into staging and production tables. SSIS packages include Event Error Handling and auditing of data, calling of incremental load process stored procedures, parsing of data files, and automation. Development of packages using SQL Server Data Tools for VS (SSDT).
• Deployment of SSIS packages from Team Foundation Server into SSISDB environment.
• Developing initial stage of OLAP data model for data warehouse (facts and dimensions tables) in SQL Server 2012 using vendor and transactional data from Oracle data warehouse.