Nicholas Rivera Email & Phone Number

Orion Charter Township, Mi, Us

Orion Charter Township, Mi, Us

Southfield, Michigan, Us

Implement, Manage and Maintain Data Platform Components within a data warehouse and Operational Data Store(ODS). Working directly with business leaders and subject matter experts to understand, validate and implement solutions based on business requirements. Maintain high data quality and integrity standards and performance tuning of database objects. Develop and maintain Business Intelligence Reports, Dashboards, and Analytic solutions. Drive adoption and leverage of the Data Platform, Reporting, and Self-Service Analytic solutions.

Oak Brook, Il, Us

Developing and managing data integration, warehousing and business intelligence solutions utilizing Microsoft technologies: SSIS, SSRS, SSAS, and PowerShell. Analysis, design, develop and document databases, Analysis Services cubes, ETL tasks, store procedures that supplement and support existing and new BI solutions. Defining new and strategic reporting techniques and supporting integrations with the teams.

Brighton, Mi, Us

Responsible of building data warehouse for various BI applications. Construct effect and efficient ETLs, store procedures, functions with advance T-SQL query techniques. Build SSRS reports to specification for business users. Leveraging the latest full BI stack (SSRS, SSAS, SSIS) in SQL Server 2014/2016 in construct various BI solutions. Standardize and insure data quality for the business.

Develop ETL workflows using TALEND / T-SQL query. Build reports and excel data files from client requirements and specifications. Collaborate with Quality Analysis and Business Analysis during report development process to insure quality and accuracy of reports. Building effective and efficient ETLs, stored procedures, and functions with advance T-SQL queries techniques. Modify SQL tables and table fields to align with new client reporting requirements. Meet deadlines with SCRUM AGILE methodology techniques. Provide feedback and suggestions for process improvements for development cycle of reports. Update JIRA and Service NOW ticket and tracking system for project progress.

Paris, Fr

· Monitored and supervised projects as well as recommended necessary changes. Facilitated with the development and implementation of various IT systems used by clients. Developed stored procedures, functions, triggers, and indexes used for new BI reports and ETL queries. Built advance SSRS reports that included drill-downs and content aggregations. Upload data files into database. Reintegrated ETLs from one database system to another. Scrubbed and cleansed data as well as created error checking code to maintain data integrity. Created and updated SSIS packages and ETL workflows for data transfer between SQL servers. Created MOLAP cubes for with SSAS using MDX syntax. Designed Power Pivot chart/diagrams, KPIs and Dashboards for SharePoint report site. Managed new installations of software and hardware to IT system as well as migrations. Resolved computer system, network issues and reporting systems errors for clients. Developed SharePoint sites utilizing manage metadata. Designed eForms solutions using InfoPath / Nintex workflow. Created workflow using SharePoint designer in 2010/2013. · Identified and developed new business opportunities with client as well as continued renewing existing client relationships.· Consulted clients: Delphi and Waterford School District.

London, Gb

· Facilitated the development and implementation of IT systems used by client. Developed store procedures and functions for new SSRS reports from legacy reporting system. Built advance SSRS reports that included drill-downs and content aggregations. Upload data files into database. Identified and resolve database/query performance issues using performance profiling tools and optimization strategies. Planned, developed, and migrated client from standard MOSS 2007 to Enterprise SharePoint 2010. Architected a high available SharePoint farm to accommodate 30,000 concurrent users. Updated SharePoint 2010 farm with FAST search. Trained client’s staff on latest IT additions. Created and updated SSIS packages and ETL workflows for data transfer between SQL servers. Performance tuning SQL server database. · Identified and developed new business opportunities with client as well as continued renewing existing client relationships.· Consulted client: Waterford School District.