Nick Cocco Email & Phone Number

Columbus, Oh, Us

Newport Beach, California, Us

Dayton, Ohio, Us

Facilitated multiple requirements sessions to build a business information model to help validate business processes and be a starting point for data modelingLead the design of databricks code patterns utilizing spark streaming to pull near real time information into a medallion architecture Develop Synapse PySpark notebooks to pull data from delta tables and into Cosmos DB for Mongo DB Utilize the Power BI APIs to kick off dataset refreshes after data pipeline jobs have completed. Build and maintain Power BI dashboards that are reusable across multiple clients by utilizing conditional formatting and other dynamic binding. Create a modern analytics platform utilizing parquet files for staging and delta tables as the target to reduce the costs for the client Build out a proof of concept utilizing Azure B2C in conjunction with Power BI Embedded to handle customer facing analytics Perform source system analysis to conform multiple legacy systems into a conformed business domain model Guide clients on architecture decisions by helping facilitate conversations and bring research and best practices forwarded Design ETL patterns for full and incremental loads utilizing Azure Data Factory Facilitate fact finding sessions to build out a roadmap for the future of modern data warehouse Monitor daily Dynamics 365 F&O data entity refreshes to ensure they are completed on time Work with Dynamics 365 F&O to help incorporate data into the existing SQL Server data warehouse Create Azure Data Factory jobs to incorporate new data sources from Salesforce to Snowflake Design and create Power BI dashboards for tracking data migration processes Work on migrating data from a legacy system to modern system utilizing python to ensure the work being done is portable to the cloud when the client decides to move there within the next few years Manage the relationship between the project stakeholders and Centric

Dayton, Ohio, Us

Work on migrating data from a legacy system to modern system utilizing python to ensure the work being done is portable to the cloud when the client decides to move there within the next few years Facilitate business requirement sessions with the client

Dublin, Oh, Us

Work with clients to help facilitate architecture decisions Determine best practices for Tableau implementations related to deployments, dashboard design and platform decisions Analyze data to determine profile statistics and data anomalies Completed Qlik Data Catalyst accreditation to receive NFR license Facilitate meetings and gather requirements for end user dashboards and reports Design and develop SSIS packages to move data from multiple sources to an ODS database Provide insights on modeling decisions to verify that the model satisfies the defined business use case

Columbus, Oh, Us

Lead the facilitation of requirements, manage the JIRA backlog and document the business requirements effectively Lead the design of data mart solutions utilizing Kimball methodologies to be consumed by the business usersEvaluate new reporting tools to help give insights into the pros and consTurn business requirements into raw vault tables and structures, following the data modeling processAnalyze disparate data sources to determine how to integrate the data in meaningful way for the businessFacilitate scrum events (stand-ups, retros, planning, grooming)Learn new business areas and analyze the corresponding data to be able to deliver a solution as fast as possibleWork with the business to drive the design and architecture of the business vault and information mart (star schema) of the data vault architectureFacilitate user acceptance testing to ensure the quality of the products we produceDevelop and test star schema facts and dimensions using scriptsDevelop Tableau dashboards for various end usersAnalyze SAS Enterprise Guide queries to replace with more sustainable solutionsAdminister ER Studio to add new users and maintain existing usersMentor developers to help them follow standards and understand the business requirementsManage the ongoing relationships with key business stakeholders and product ownersParticipated in an AWS proof of concept utilizing kinesis, lambda, quicksight and tableau to ingest and display FAA related dataParticipated in an Azure proof of concept to ingest FAA data and display it using PowerBI and TableauCompleted lean six sigma yellow belt training for process improvement

Nashville, Tn, Us

Develop dashboards and reports with varying degrees of complexityDesign and implement transaction services documents to take inputs and perform updates through the MicroStrategy interface by utilizing SQL Server stored proceduresInstall and configure Cloudera Manager on RedHat with YARN, HDFS, and HueCreate Sqoop commands to move data from SQL Server to Hive and HDFSWork with data science concepts utilizing excel and RConfigure and maintain MicroStrategy 10.1 and SQL Server 2014 for use as development boxesWork with infrastructure team for platform upgrades and troubleshoot any issues throughout the processImplement various jquery, jquery ui and javascript scripts within MicroStrategy to increase user experience that is not achievable out of the boxDesign and implement an ad hoc querying solution within MicroStrategy that utilizes user level security, intelligence cubes, and visual insightImplement beta functionality within MicroStrategy that gives added features to a limited user baseWork closely with the infrastructure team to help increase performance for reports and queries generated by MicroStrategyHandle deployment of code through the numerous environmentsCollaborate on data model design decisions with Architecture and ETL teams

Columbus, Ohio, Us

Perform thorough data analysis by gathering requirements and using SQL extraction queries to build prototypes for the front end users to verify the data.Perform quality assurance testing on data loaded by ETL applications to ensure its accuracy and correctness, and to work with the developers to help solve any underlining issues found by the testing.Extract, transform, and load data to a target system based on business requirements and/or mapping documents that are defined by the client or business analyst. Develop Business Objects Data Services jobs in conjunction with Oracle and Informix databases to load data based on the ETL standards, mapping documents, and requirements.

Richfield, Minnesota, Us

Consistently meet and exceed sales goals and customer expectations by connecting with customers to understand their requirements, and recommend specific products and services to meet their individual needsTrain and mentor new employees while demonstrating the Best Buy philosophy of technologyDevised and implemented a strategic plan to create packaged merchandise each week to successfully and dramatically increase sales and attach rate of high-margin accessories and servicesSix time store MVP at Best Buy, two time department MVP

Atlanta, Georgia, Us

• Created a product video for Delta Cargo, from start to finish, to be used at five different tradeshows annually with a budget of $20,000• Researched trade show booth vendors, created a request for quote, and presented my recommendations to management• Presented different ideas and recommendations to upper management regarding the Delta Cargo product video and the trade show booths• Organized the GSSA Conference on June 15-16 in Las Vegas, Nevada, and created nametags, programs, and bags to be given to conference participants all while staying below the intended budget• Trained, implemented, and allocated budgets for the electronic non-cash incentive sales tool• Designed numerous collateral items to use as promotional items at events and tradeshows

Us

- Worked to improve accessibility on the New York State Deferred Compensation web site according to ADA standards- Converted multiple websites to the new web management system to increase efficiency and consistency- Implemented cleaner, more efficient HTML into the new system to significantly decrease load times- Collaborated with several departments to create business plans for current web projects

Troy, Michigan, Us

Created stocking guides to help increase sales and created business plans for multiple product linesIdentified cross references between manufacturersRan queries in AS400 and MS Access to retrieve and organize dataCreated News Bulletins and edited catalogs and flyers

Woodridge, Il, Us

Performed extensive data analysis for pricing and strategyDesigned and updated sales and product brochuresDeveloped pricing strategies and sales toolsWrote cover letters for direct mailings in U.S and CanadaFacilitated meetings to increase productivity on current projects

Bachelor, Business Administration Marketing/Information Systems

High School Diploma