Sharepoint Sql Server

OBJECTIVE

Looking for a forward-thinking company that invests in growth where a long-term contribution to the implementation of applications and upgrades is desirable in both front end and back end sides.

SUMMARY

Reliable, innovative, and experienced individual with 19+ years of databases (Oracle and SQL Server) Administer/Developer expertise in Data Warehouse development administration as well as 13+ years as a SharePoint Administrator/Architect/Developer on WSS 3.0, MOSS 2007, SharePoint 2010, 2013 and 2016.

Works well individually and in interdisciplinary teams with an appreciation for challenges, steep learning curves, and high-pressure deadlines in IT department for more than 27 years.

Outstanding ability to develop and implement technological solutions in areas such as project management, large scale databases (Oracle/SQL Server), user support and client relation.

EDUCATION

California State Polytechnic University, Pomona - Bachelor of Science – Computer Science - 06/1990

CERTIFICATIONS / TRAINING

US Citizen with Active Security Clearance (Secret) worked for Federal Contractor to support Navy

iNAVY SharePoint 2010 Tenant Administrator (TA) certificate

iNAVY SharePoint 2010 Site Administrator (SA) certificate

iNAVY SharePoint 2010 Site Collection Administrator (SCA) certificate

TECHNICAL PROFFICIENCIES

Operating Systems: Windows Server (2000-2016), UNIX (Sun OS, Solaris, AIX, HP and SCO), Linux

Databases: SQL Server (6.5, 7.0, 2000, 2005, 2008 up to 2016), ORACLE (6 – 11g), ACCESS, FOX-PRO

Software: K2 Visual Studio/Designer, SharePoint Designer/InfoPath, JavaScript, JQuery, AngularJS, D3.js, ASP.NET MVC, VB .Net, C#, C++, Visual Studio, Cognos, Oracle (Form/ProC), Erwin

Virtual Environments: Microsoft App-V & Hyper-V, Oracle VM VirtualBox, VMWare

PROFESSIONAL EXPERIENCE

Data Warehouse Developer The Gill Corporation: El Monte, CA 04/2017 – Present

Setup the SharePoint 2016 Integration with SQL Reporting services 2012 to use se SharePoint document management and collaboration features and use SharePoint permissions and authentication providers to control access to reports, models, and other items.

Generate report models in Model Designer in SharePoint Services and then publish them to SharePoint sites.

Migrated SharePoint 2013 to SharePoint 2016 for both testing and production environment.

Installed and configured Project Server Service Application (PWA) on SharePoint 2016.

Gathered User-Requirements for Business Requirements and then translated business rules into data modeler via CA Erwin and then reverse-Engineered legacy systems and create production data models for reporting solutions and data warehouse.

Created and assembled all SQL Server Integration Services (SSIS) packages using Work Flows, Data Flows, Container, Parameter-Driven configurations for all ETL (Extract, Transform, Load) processes including CDC (Changed Data Capture) on both stages: staging and target.

Built and designed Online Analytical Processing (OLAP) Cubes on SQL Server Analysis Services (SSAS) to create SharePoint KPI and Dashboard on both SharePoint 2013 and SharePoint 2016.

Created and managed SharePoint Server Project Management Office (PMO) portal for each department.

Generate report models in Model Designer in SharePoint Services and then publish them to SharePoint sites.

Design SharePoint Custom Master Page with Mega Menu contains all sites or departments for Description of each site/department and Contact Members in each site/department including images and photos.

SharePoint Developer Airbus–DS Communication: Temecula, CA 09/2015 – 09/2016

Evaluate and create Proof-Of-Concept (POC) and provided recommendation for SharePoint 2016, PowerApps and Flow including provided testing best practice guide line and review for Salesforce cloud and Dynamics AX (2013 and 2016) and provided recommendation for ServiceNow, Salesforce cloud and Dynamics AX (2013 and 2016) migration and integration.

Generate all data sources for report models from Dynamics AX, Salesforce and ServiceNow.

Migrate and design the IQP (Interactive Qualifying Project) from Intranet to SharePoint to manage ISO internal/external audit, including all workflows to ensure compliance with processes and corrective action associated with identified deficiencies certifications.

Design SharePoint VESTA Solutions on both Intranet and Extranet to maintain all product lines, documents and services (Training, Support, Project Management and Field Engineering, etc.) and dynamic SharePoint IT and HR Sites for Data Visualization and Data-Driven.

Design SharePoint Project Management Office (PMO) Site to integrate between SharePoint and Project Server/SharePoint Project Web Access (PWA).

Create notification workflow on the SharePoint PWA Timesheets on approval/rejected.

Configure user profile synchronization by using Active Directory Domain Services (AD DS) in SharePoint Server 2013.

Design dynamic SharePoint Sales Readiness for Marketing Department to support all locations (Brentwood, TN; Gatineau, QC Canada; Richardson, TX; Temecula, CA and Westchester, IL).

Design SharePoint Custom Master Page for both Application and Out-of-the-Box SharePoint views.

SharePoint Architect Engineering/Documentation Systems, Inc.: Fallbrook, CA 08/2014 – 09/2015

Generate report models in Model Designer in SharePoint Services and then publish them to SharePoint sites.

Design Expeditionary Systems Evaluation Division (ESED) Portal and demo to Boards on the enterprise solution.

Design ESED Portal project and demo both departments: Division and Project Branch.

Initialize the ESED Portal project (implement calendars, discussions and work flow).

Develop and complete Technical Resource Center (TRC) SharePoint migration project.

Develop and complete Request for Documentation Processing (RDP) SharePoint migration project.

Work with EDSI Programmer/Analyst to identify TRC & RDP source codes and databases for migration to SharePoint portal to implement the enterprise solution.

SharePoint Administrator/Developer Secure Mission Solutions: SPAWAR San Diego 06/2011 – 08/2014

Configure user profile synchronization by using Active Directory Federation Services (AD FS) in SharePoint farms.

Support client in debugging, testing SharePoint Web Parts/Workflows for all four regions: "Far East", "Europe", "Middle East" and "ONE-NET CONUS" and Troubles shoot SharePoint issues for all regions including SharePoint Security.

Configure user profile synchronization by using Active Directory Domain Services (AD DS) in SharePoint Server 2013.

Design and develop SharePoint Master Page Custom Tool for all regions. This custom tool let SharePoint Administrators set up “Classified/Un-Classified” security label on each SharePoint list, document library and page.

Develop and support “Approve Form” to add, update and delete records in a SharePoint list working with multiple SharePoint Workflow levels. SharePoint Workflow moves each record from approver Owner to other approvers: Supervisor, IAM/Appointee, Security Manager, and TNOSC Director. It is designed with SharePoint People Picker to provide more convenience to the users.

Design and develop “Automate export SharePoint Workflow to .csv file” project. It loops through all required fields in a SharePoint Workflow and build a data set to export to .csv file. It helps SharePoint Administrator and Databases Administrator synchronization between servers to servers.

Design and develop Obsolescence Management system using SharePoint Business Connectivity Services (BCS)/Business Data Connectivity (BDC) to retrieve BMC Software (Remedy-Oracle Database) data on the real-time concept. System is using BDC application definition files for applications to track down warranty date and using Report Data Models in SQL Server Report Services (SSRS) SharePoint Mode to generate reports and charts.

Design and develop Windows Migration Tracking system using SharePoint BCS/BDC to retrieve Microsoft Systems Management Server data on the real-time concept. Currently, system is using SharePoint notification to users and using BDC application definition files for applications to track down work station status when deploying Windows image. It uses Report Data Models in SSRS SharePoint Mode to generate reports and charts for next migration.

Data Warehouse Developer Arcadian Management Services: San Dimas, CA 12/2005 – 05/2011

Setup the SharePoint 2007 Integration with Microsoft Dynamics Customer Relationship Management (CRM) 2011 to implement a customizable, scalable to larger applications for claim processing for Healthcare Provider Network.

Migrated SharePoint 2007 to SharePoint 2010 and then integrated Microsoft Dynamics CRM 2011 in order to create SharePoint folders automatically from Microsoft Dynamics CRM 2011.

Installed and configured Microsoft Dynamics CRM List Component on SharePoint 2010 farm.

Created and managed SharePoint Server document location records on Microsoft Dynamics CRM by using the SharePointDocumentLocation entity.

Developed Web Parts/Solutions for SharePoint 2010/MOSS 2007 using Client Object Model.

Developed entire BCS for SharePoint 2010/MOSS 2007 on both security modes PassThrough authentication and RevertToSelf authentication.

Served as technical lead for number of Electronic Data Interchange (EDI) processes involving Pharmaceutical, Claims and Encounter Data, CMS (Authorizations data for Centers for Medicare and Medicaid Services), STAR (Standardized Testing And Reporting program) and HEDIS (Healthcare Effectiveness Data and Information Set) reporting using Data Transformation Services (DTS) and SSIS on both Oracle (10g) and SQL Server databases.

Built and designed OLAP Cubes on SQL Server Analysis Services (SSAS) to create SharePoint KPI and Dashboard on both MOSS 2007 and SharePoint 2010.

Designed data models with OLAP structures (STAR schema) including facts, dimensions with Software Components Description Library (SCDL) using Ralph Kimball methodologies.

Gathered User-Requirements for Business Requirements and then translated business rules into data modeler via CA Erwin including update and maintain all Erwin data modelers.

Reverse-Engineered legacy systems and create production data models for reporting solutions.

Created and assembled all SSIS packages using Work Flows, Data Flows, Container, Parameter-Driven configurations, etc. for all ETL (Extract, Transform, Load) processes including CDC (Changed Data Capture), Dimension Attribution, Data Marts, and data integrity validations.

Configured SharePoint (2010/MOSS 2007) with SQL Server 2008/2005 SSRS integration mode for both environments for different configurations such as Stand Alone and Multi-Servers farm on Windows Servers.

ORACLE + SQL SERVER DATABASE ADMINISTRATOR/DEVELOPER (19+ Years) 11/1990 – 7/2009

Maintained (Administrator/Developer) to all Oracle/SQL Server databases for the following companies:

Fontana Unified School District: Fontana, CA 92335 03/2008 – 07/2009

Oracle/SQL Server Database Consultant 09/2007 – 03/2008

Arcadian Management Services: San Dimas, CA 91773 12/2005 – 09/2007

Inland Empire Health Plan: San Bernardino, CA 92408 08/2000 – 11/2005

Locus Marketing Group: San Bernardino, CA 92408 05/1997 – 08/2000

Electronic Data Systems (EDS): Diamond Bar, CA 91765 11/1990 – 05/1997

Data Processing Manager at Locus Marketing Group 05/1997 – 08/2000

Contact this candidate