| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Address: Street Address Phone: H PHONE NUMBER AVAILABLE C PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEOBJECTIVEObtain a position where I can help a company develop and execute a data strategy to support reporting and analytics at the Enterprise level. I have a strong blend of technological experience and business leadership.SUMMARY OF QUALIFICATIONSA highly trained and experienced BI/Data Architect who possesses both a solid technical computing background, and understanding of business fundamentals and Management Information SystemsA technical background which includes extensive training and experience with Oracle 10g, Microsoft SQL Server 2000/2008/2012/2014, and SQL Server BI tools including SSIS, SSAS and SSRSExtensive training and experience with Business Intelligence (BI) Software Stratum ViewerExtensive experience implementing the Star Schema.Strong Power BI SkillsLooker (BI Analytic Bolt On)Strong communication skills coupled with an understanding of the actual needs and technical needs of both end users and technical staff bridges the communication gap between them.Patience, kindness, and practical teaching skills to assist end users who may lack computer experience.Analyze the needs of both upper management and end users to design and implement Web-based Business Intelligence (BI) solutions.Implemented Business Intelligence (BI) solutions at over 150 different clients in the manufacturing, distribution, publishing and food industries.Strong background in database design, including SQL, T-SQL, PL/SQL and ETL (DTS and SSIS)Data Warehouse architecture including Kimball Methodology (Star Schema)Big Data/HadoopSAP data extraction and transformation into staging tables to load data into Data Warehouse dimension and fact tables.Project Management & Business Analysis and Agile MethodologyTECHNOLOGIESDatabases: Microsoft SQL Server Azure (Data Warehouse), Microsoft SQL Server 2000/2008R2, 2012, 2014, TFS, Oracle 8i/10g, Teradata, DB2 (AS/400), FoxPro, DBASE III Plus, Maximo, Quick Silver, Watcom SQL Server, Microsoft Analysis Services, Microsoft Reporting Services, Microsoft Azure SQL Database, Microsoft Azure SQL Data Warehouse (a.k.a. Synapse), Microsoft Azure Data Factory V2, SnowflakeOS: Linux (Red Hat), AIX, UNIX, Windows NT/2000/XP/2003/Vista/2008, OS/400Software/Development: T-SQL, SSAS, SSRS, SSIS, PL/SQL, Shell Scripting (Korn Shell), C, Visual Basic (Active X), CL on the AS/400, Crystal Report Writer, Microsoft IIS, POSE Case Tools, DTS, Stratum Viewer, Developer2000, Oracle Forms, Oracle Reports, Power BI, Looker, Google Analytics, Microsoft Azure Data Factory, Idera ER Studio Data Modeling, Orchestrator, Microsoft Team Foundation ServicesPROFESSIONAL EXPERIENCE05/2022- 06/2023: RedManeBusiness Intelligence Developer/Data Warehouse ArchitectData Profiling Curam DB 2 database using DBeaverWas involved with the JAD sessions from which the FDD (Functional Data Design) was createdCreated the Technical Data Design (TDD)Worked with the Business Analysts to create the TDD from the FDDDesigned Dimensional Data Marts using Idera ER Studio Data Modeling tool for the Data warehouseBuilt staging tablesBuilt dimension and fact tablesUsed ADF to populate tablesBuilt the Dimension and Fact tables in the SQL Azure environment using Idera ER StudioMentored junior co-workers in SQLResponsible for getting the initial work environment in Curam and Azure data Factory set up for the teamWorked with Managed Services in setting up the Microsoft Azure and Azure SQL Server environmentsDocumented the Design of the Data Warehouse12/2019- 06/2021: Reyes HoldingsBusiness Intelligence Developer/ArchitectResponsible for maintaining legacy system in Microsoft SSISCloud Development using Snowflake databaseBuilt staging tablesBuilt Dimension and Fact tablesCreated Pipelines in Microsoft Azure Data Factory to load and schedule the loading of DataMart Dimension and Fact tablesDeployed code via TFSProvided analysis of the data and made suggestions on how to improve business processesOn boarded new warehouses into Dematic Data MartInvolved with rolling data into the Reyes environment from acquisitions.Data ProfilingWorked with Business Analysts to develop new tables and loading processes to support the new Power BIReporting Environment.Worked with offshore teams10/2017- 08/2019: Liquidus Marketing, Inc.Business Intelligence Developer/Data Warehouse ArchitectResponsible for a corporate wide strategy to support the reporting and analytic functions at an Enterprise level and execute that strategy.Collaborated with C-Level management and SMEs to address pain points and design the data warehouse.Created list of criteria to assemble the technical team to implement the data warehouse.Created the road map for creating the Enterprise Data WarehouseCreated the Data Warehouse design for the AdTech Data MartResponsible for creating PowerBI Reports for the Account ManagersCreated the POC for LookerCreated the Repository that Looker uses (Reseller, AdTech, Third Party Pixel Tracker) in Microsoft Azure Data Ware HouseLooker AdministratorLoaded Looker repository via Data FactoryProvided Help Desk Support on existing reports and resolved data issuesCreated the road map for creating the Enterprise Data WarehouseCreated the Data Warehouse design for the AdTech Data MartSecondary support for Google Analytics Reporting toolCreated the Staging tablesCreated the Dimension and Fact tablesUsed ADF to populate the Dimension and Fact tablesProvided mentoring in SQL to associatesAssisted with Jira Tickets02/2016- 08/2017: TRUE (McDonalds Corporation)Technical Business AnalystResponsible for data accuracy and qualityWorked with the Global Supply Chain Visibility Analytics teamTrained/mentored and Provided support writing queries in Oracle and TeradataCollaborated with Tableau designers and Modified Teradata view that Tableau usedSupported the on-boarding of new markets and provided gap analysis and pointed out data anomalies of incoming data from the new markets. This included, but was not limited tooVerified that Facility WSIs were in MDMoVerified that Global Item Numbers were in the global data WarehouseoCreated SQL Scripts to analyze the dataoVerified the source files were correct and pointed out issues when they existed.Loaded tables in Oracle to do gap analysis of the Facility WSs and Global WRINSWorked on the End of Year Spend Reports for all markets(reporting on spends and volumes)Optimized the data load process of the monthly market data into the Oracle tablesWorked with the Merlin Support team to resolve user issues with processes and reportsModified and corrected reports that were not working correctly.Completed Merlin Formatting Report Enhancements in Microsoft SSRSMentored associates in SQL and Analyzing the data (gap Analysis)04/2015 01/2016: NvisiaData ArchitectWorked as a member of the newly created Data Management teamWas a member of a development team that created the SSIS packages to extract data from multiple sources into the Staging area and then the Data Warehouse for an Insurance related companyWas a member of a development team that worked on defects on SSRS reports and extracts that were mostly in the form of Stored Procedures.04/2013 03/2015: Plano SynergyLead BI Consultant\ManagerManaged the Business Intelligence (BI) Team, set priorities for the (BI) Team, interfaced with C-level Management and Upper Management, and Identified Corporate Wide reporting needs for SalesCo-developed the Data Stewardship/Data Governance process and proceduresCreated the Charter, Enterprise, and Dimensional Data Model for the Sales Data Warehouse using Visio.Led the Evaluation and selection of Data Access Tools to create analytical reports against the presentation layer.Created the Conceptual Design for the Sales Data Warehouse (using Kimballs Star Schema Methodology)Designed Plano's corporate wide Business Intelligence (BI) Data Enterprise Model.02/2012 03/2013 NeudesicSenior Business Intelligence ConsultantWorked with the Microsoft Business Intelligence (BI) stack for a variety of customersUtilized the Agile Methodology on projectsUsed Master Data Management and Data Quality Services (DQS)Created Visualizations with Microsoft Power Pivot and Power ViewDesigned and developed reports in SSRS 2012Developed ETL Packages in SSIS 2012Contributed to the creation of the SQL Server 2012 Framework which included advanced logging and designing a more robust algorithm for handling SCD type 2, than is available in SSIS 201210/2011 - 02/2012: SteriCycle (TEK)Business Intelligence (BI) Developer / ConsultantDeveloped and maintained SSRS ReportsWrote and maintained extraction packages in SSIS 2008 R2Wrote and maintained stored procedures that the reports utilizedPerformed Performance tuning to Store Procedures to improve performance of SSRS reports.Used Microsofts TFS (Team Foundation Services) for source code control05/2010 - 06/2011: Victaulic Corporation (Speridian Technologies)Data Warehouse Architect / ConsultantManaged the implementation of Stratum Planner and Stratum Viewer (BI Tool), and served as a Data Warehouse Architect. After making a substantial investment in Stratum technologies, the system wasnt working, and the customer had lost track of system documentation, and confidence in the Stratum solution to effectively serve as the corporate reporting tool.Provided Team Leadership, identified and assessed problems, determined courses of action to correct the problems, and get the project back on schedule, re-engaged the user community, and saw the various projects to successful conclusions.Used T-SQL to extract packages to populate data warehouse. Also used to troubleshoot, transform, and create database objects and new table views.Provided architectural guidance regarding the data storage warehouse, and migrated the Data Warehouse from the iSeries to SQL Server 2008R2.Conducted User Acceptance Training (UAT), including creating class material for training users to access data using both the Thick Client User Interface (Stratum Planner) and the Web-based User Interface (StratumViewer).Ran key stakeholder meetings regarding the design of the Data Warehouse.Analyzed raw data, re-structured the historical tables, and created detailed documentation thereon.Extracted data sourced from DB2 on the AS/400 (BPCS) into the Data Warehouse using Microsoft SQL Server Integration Services (SSIS).09/1996 - 04/2010: Silvon Software, Inc.Senior ConsultantWorked closely with more than 100 different client stakeholders as a Project Manager, Analyst and Consultant; implemented Business Intelligence (BI) software; and provided in depth training on how to successfully manage the Data Warehouse and on other uses of the Silvon BI software.Consulted for various clients to implement BI solutions ranging from large manufactures such as Sony Corp.; food companies such as Multifoods International / Best Brands; smaller distribution companies like MJ Pipe; and publishers such as Hachette and Penguin.Utilized T-SQL to create stored procedures, triggers, and functions for a POS System, and created queries for SQL and AS400i series.Utilized StratumViewer to create BI analytic solutions for clients. (StratumViewer is Silvon Softwares web-based BI business tool used for analysis of sales history, open orders, POS, inventory, demand, etc.)Managed and maintained the StratumViewer Inventory Optimization Module to pull in key items of data (Planned lead time, Actual lead time, Forecast Units, and Demand Units) as inputs to calculate safety stock, and other performance indicators.Created, maintained, and expanded the POS module to interface with Excel spreadsheets, text files, and EDI transfers as data sources to be loaded into StratumViewers Storage Warehouse, and ultimately processed into a Cube for Microsofts Analysis Services.Installed, configured, and maintained all hardware and sizing recommendations for all programs, including StratumViewer software.Conducted Planning-Design-Sessions with the stakeholders, project sponsors, and the stakeholders IT representatives. Documented the agreed upon design.Created the Metadata pursuant to the Planning-Design Sessions, wrote extracts via DTS used to load data into the Data Warehouse (Initial Load, Nightly Net Change, and Master File loads) from the ERP, ODS, or other sources.Trained the technical staff on administering the Data Warehouse and maintaining the StratumViewer applicationProvided appropriate StratumViewer training to the end user community.Educated the project sponsors on the various modules available to augment the existing implemented modules, and thus, maximize the stakeholders Return on Investment for the StratumViewer software suite.Additional responsibilities included: running the Planning-Design-Session of the Data Warehouse, (i.e., what dimensions, measures, and categories will be needed, and granularity of the categories), documenting the design of the Data Warehouse, documenting future Data Warehouse phases, and fine-tuning the Data Warehouse for optimal load and inquiry performance. The Data Warehouses ranged in size from several hundred gigs to several terabytes.Created POCs (Proof of Concepts) to support the sales team by shortening the sales cycle.Used Crystal Reports and Microsoft Reporting Services at many manufactures to provide large custom reports.Utilized various Microsoft reporting tools to generate reports against Source and Data Warehouse repositories on the iSeries as well as SQL Server 2000.12/1995 - 09/1996: Vancom Corporation, Inc.Programmer AnalystCreated and populated Oracle databases via Developer 2000 in a client server environment using Windows 3.1 on a Novell LAN.Developed and maintained an Oracle based Help Desk Hotline Application, utilizing Oracle 7.2 and Developer 2000 tools.Created MIS reports via Oracle Forms and Oracle Reports 2.5.04/1990 - 12/1995: Viskase Corporation, Inc.Senior End User AnalystDesigned and developed sales budgeting database using Oracle 5.1C on the PC.Performed feasibility studies on replacing the hub networks AS/400 database with Oracle on an IBM mainframe and UNIX box including a study regarding the feasibility of Client-Server architecture for Oracle (Oracle Server).Provided ongoing PC support and training, including setting up 5250 and 3270 emulation on the PCs.Created reports using IBM Assist from flat files on the 4341.Wrote database applications in dbase.Used AS/400 PC Support to download and upload files between the PC and AS/400.Used CFOs Round Trip to create .wk1 worksheets, and Panasophics FUSION to generate reports from the AS/400 database.Diagnosed and rectified hardware problems.Extracted data from JDE on the AS/400 and transformed it into the Maximo (Gupta based) database for applications used by the engineering department.EDUCATIONNorth Central College, Naperville, IL 1984B.S. Majors: Computer Science and History |
