SUMMARY:

• More than twenty years of experience in Enterprise Data Management, real - time control systems, and commercial software development. A very strong, intellectual and hard-working professional with excellent analytical skills.
• Experienced in Business Intelligence solutions: multidimensional data warehousing, Master Data Management, ETL processing, Analysis and Data-mining services, FOSH (Four Key Business Metrics Areas), and reporting
• Experienced in designing and developing scalable OLAP Multidimensional Cubes using SSAS as well as in administering them.
• Expert in Relational and Dimensional data modelling using ERD in MS Visio, Ralph Kimball and Bill Inmon methodologies.
• Experienced in SDLF using Scrum based Agile Methodology including requirements gathering and analysis, solution architecture, design, development, testing and Implementation as well as in translating business requirements into technical specifications / solution concepts and designs and providing technical governance and guidance throughout the complete solution delivery lifecycle
• Experienced in project management as project scope, cost, time, issue, risk, resource as well as in mentoring the project team (MS Projects, Jira, MFS).
• Also experienced in SQL Server Database administration and software design and implementation using client/server object-oriented (three-tiered) architecture.

TECHNICAL SKILLS:

BI Architect: Data warehousing, Master Data Management, Data Modeling, OLAP, SSAS, MDX/DMX, Data Mining, FOSH (financial, operational, sales, and HR KPIs), ETL, SSRS, VBA Excel, Tableau, Interop Word/Excel, MS Visio

Data Warehousing: MSBI (SSIS, SSRS and SSAS), MDS, MDX, AWS

Data Modelling: Erwin, MS Visio

The back end: MS SQL Server 6.5/7.0/2000/ 2005/20 , MS Access 2000/2010, Oracle 8i/10g, Microsoft Dynamics AX, AWS RDS

The middle: ADO/ ADO.NET, ADOMO, MDX/DMX, SQL/T-SQL, COM (ActiveX-DLL/Exe)SQL Server Web Services (End-Points), COM (RPC), ASP/ASP.NET, DAO, RDO

The front end: MS C#, C/C++ for DOS, MS VC/C++ 4.0-6.0, QC and QB for DOS

MS Visual Studio 6.0/2003/2005 with VB/VB.NET and C# .Net, HTML, VBScript, JavaScript/AngularJS, InterDev 6.0, Crystal Reports 7.0/9.0/11.0

Data Visualization: Power BI, PowerPivot, PowerView, Tableau, SSRS, VBA Excel

Version Control: Team Foundation Server, Visual Source Safe

Beta test: User and Hot-Line support

Installation: Stand-alone and network versions, Client - Server parts

Maintenance: Customer and system support

WORK EXPERIENCE:

Confidential

BI/DW developer

Responsibilities:

• Designed and implemented Data Marts for Records, AA and AR Taxes
• ETL Process from Thompson-Reuter Aumentum Property tax system into Data Marts
• Optimize existing queries for ETL SQL batches

Confidential, San Diego, CA

Web Project Leader/Developer (contract)

Responsibilities:

• Architect and built AWS S3/CE2/RDS SQL Server 2014 infrastructure for intranet and Extranet web sites for a recruitment company: VPC, Users, Roles, IAM, S3 Buckets, Security Groups, EC2, RDS, Load Balancers with SSL s.
• Designed and implemented Intranet/Extranet back-ends using SQL Server 2016
• Designed and implemented Intranet/Extranet front-end using JavaScript /AngularJS, C#, ASP
• Set up Window Server 2012 R2 on AWS
• Built and set up IIS on Window Server 2012 R2
• Configured the SSRS server on Window Server 2012 R2
• Implemented SSIS to pull data from HR, Financial Excel spreadsheets into Intranet database
• Built modules to pull candidates, jobs, companies, and activities data from CATS, ADP, Insightly using RESTful APIs
• Implemented 7-step HR onboarding process with autogenerating emails and offers using MS Office 365 on line as well as resource tracking and reporting
• Implemented Asset management, PO tracking, and reporting for Financial, Recruitment and Engineering departments
• Set up and implemented TFS environment for Intranet and Extranet projects

Confidential, Carlsbad, CA

BI Team Leader, Contract

Responsibilities:

• Replaced multiple ETL packages with SSIS framework to allow processing and easy-to-integrate-new-clients various-type ad files - up to 30 files per client once a week - such as web, phone, and media.
• Designed and implemented Data Marts for Analytics and Direct-Ad Response teams
• Designed and implemented multiple KPI views for Tableau dashboards as well as pulling data from Google Analytics

Confidential, San Diego, CA

BI Architect/BI Administrator (contract)

Responsibilities:

• Designed and implemented OPEX SQL/SSAS/MDX/VBA - Digital Design Resource Planning system to run scenarios by VP, departments, projects, skills, etc. to calculate project costs and needs
• Designed and implemented Tableau dashboards to generate up to 24 pivots and charts per scenario
• Designed Data Mart and ETL packages to pull data from Oracle databases to support OPEX
• Provide DBA assistance for an in-house DBA team in Performance tuning, AlwaysOn, and Replication

Confidential, Sacramento, CA

BI Architect/Manager

Responsibilities:

• Designed and developed Provider Performance/Tiering tool to provide detailed longitudinal analyses of the practice patterns of individual practitioners using T-SQL
• Designed and developed up to 60 ETL to process claims, providers, files from insurance companies and analyze received data to match Provider Performance tool
• Designed and implemented multidimensional data warehouse, Master Data Management, ETL, and business intelligence solutions for analytical, case management, and financial departments.
• Designed and developed claim and provider data analysis tools based on revenue, procedures, visits per episodes, and line of business using SSAS.
• Designed and implemented SSAS cubes for 30+ Insurance company’s claim data
• Managed a team of three DBAs to support Staging, Testing, Pre-production, and Production environments as well as up to 30 OLAP servers
• Managed a team of four in-house Web developers and 6 contractors
• Managed Migration projects from R2-2012

Confidential, Sacramento, CA

Sr. BI Architect/Team Leader

Responsibilities:

• Upgraded SQL Server 2000 ODS and DTS packages into SQL Server 2005 and SSIS
• Designed and implemented Data Mart for analysis and reporting
• Designed and implemented MDM for Sutter Enterprise Data Warehouse
• Designed and implemented ETL using SSIS - Best Practices
• Designed and implemented OLAP services and built reports using SSRS
• Assisted in Dash Board design for SharePoint 2007

Confidential, Bellevue, WA

Sr. BI Architect/ Team Leader

Responsibilities:

• Provided business solutions to Plum Creek Timber company
• Designed and implemented Data Marts for Financial, Inspection, and Harvest departments
• Designed and implemented MDM for Financial, Inspection, and Harvest Data Marts
• Designed and implemented reports for Financial, Inspection, and Harvest departments using Excel and word
• Designed and implemented SSIS to pull data from NGTS, HSP, IFMS, and Lawson Financial DBs into Plum Creek SQL Server data warehouse and provide reconciliation, analysis, and reporting services for various business needs.
• Designed and implemented Excel and Word enhancements into an existing C# application to allow loading lease payments into MS SQL server and print lease renewal and confirmation letters.

Confidential, SF, CA

Sr.DBA, CA

Responsibilities:

• In-place upgrading SQL Server 2000 to SQL Server 2005
• Migrating DTS packages to SSIS
• Building five SSRS reports running against SharePoint 2003
• Design and implement C# SSRS Deployment Utility to deploy reports with SharePoint links to across multiple Report Servers

Confidential, Rocklin, CA

BI Team Leader

Responsibilities:

• Provided DBA to the EMF SQL servers
• Designed and implemented EMF data warehouse and OLAP cubes to provide Analysis and Data mining services for Donor Development, Engineering and Finance departments
• Design and implement twenty four reports for these departments
• Assisted in implementation MS Navision 4.0for Finance and HR departments
• Designed and implemented SSIS to pull Finance data from MS Navision DB to the EMF data warehouse
• Designed and implemented Revenue and Budget Financial analysis and forecasting reports
• Designed and implemented SSIS to pull data from FTP

Confidential, Sacramento, CA

Sr. SW developer/DBA

Responsibilities:

• Responsibilities include and not limited to requirements, specifications, design, development, and support the SchoolMax Student Information System. The SchoolMax system is a multi-module system that consists of up to three hundred screens and nine hundred reports. Eighty percents of them had been re-evaluated and modified for California and other states needs.
• Designed and implemented I-Cue and I-Grade modules to allow school staff access SchoolMax over the Internet. (C#.NET-ASP.NET-ADO.NET-JavaScript-Oracle-Crystal Reports)
• A member of the Confidential SchoolMax Web Site development team (C# .NET-ASP.NET-ADO.NET-JavaScript-Oracle-Crystal Reports)
• Designed, developed and implemented the SchoolMax Project Tracker system to help accounting department in processing and maintaining SchoolMax projects. The SchoolMax Project Tracker is a three-tier application implemented in C# .NET, SQL Server and Crystal Reports
• Designed and implemented School level SQL Server databases for Off-Line attendance scanning, Grade assigning and State reporting.
• Data warehousing for OLAP and State reporting using MS Analysis and Reporting Services
• Provided DBA for SchoolMax SQL portals

Confidential, Sacramento, CA

Sr. SW Developer (contract)

Responsibilities:

• Designed, developed, and supported the Case Tracker 2000 application for the State of California Confidential Offices of Administrative Hearings and Appeals, Legal Services and Licensing and to track case numbers and their pertinent data in four distinct areas: Case Information, Parties Information, Staff, Reports, and Utilities.
• Designed, developed and implemented an Outlook module to allow DHS staff schedule meetings and send invitations to all parties involved into the particular case using Public Calendar.
• Integrated MS Word templates into Case Tracker to allow building Action Letters using Case information.
• Provided DBA, installation, and support after DHS approval.

Confidential, Sacramento, CA

SW developer

Responsibilities:

• Assisted DSS development department in converting CAPI (Cash Assistance Program for Legal Immigrants) MS Access database to the DSS MS SQL Server (see the CAPI contract below).
• Designed, developed and implemented SQL Server maintenance and recovery procedures
• Designed, developed and implemented the CAPI Visual Basic application to allow DSS staff access CAPI SQL Server, maintain and track recipient and recipient’s payments, print state reports, and upload data received from counties.
• Member of team responsible for design and development CAPII Internet application to allow counties access state CAPI SQL Server database and print monthly reports.

Confidential, Sacramento, CA

Application Developer

Responsibilities:

• Provide technical assistance in designing a combined STAR/SIS system at Data Workgroup meetings between the Confidential and the Office of Criminal Justice Planning.
• Establish a telephone Hotline and provide customer support to help shelters maintain their current SIS systems.
• Through review of technical specifications, input from local shelters, and evaluation of software programs, assess and evaluate strengths and weaknesses of the Shelter Information System (SIS 3.0) which tracks information about the services provided by Domestic Violence Agencies funded by the Maternal and Child Health Division (MCH) of the Confidential .
• Determine what modifications and enhancements are necessary for the SIS system to be compatible with other Domestic Violence and Criminal Justice databases network compatible, and web-compatible.
• Upgrade SIS 3.0 system to the most current MS Access version, fix problems, and add enhancements. Pilot-test modifications with MCH staff and at least five shelters, distribute updated version of SIS shelter-based agencies and to MCH, and provide technical assistance in using the SIS 2000 system.
• Determine what enhancements are necessary for the DHS SQL Server database to be compatible with SIS 2000 MS Access database and have possibility to combine data received from shelters.
• Designed, developed and implemented DHS SQL Server database
• Designed, developed and implemented SQL Server maintenance and recovery procedures
• Designed, developed and implemented a Visual Basic application to allow DHH staff work with DHS SQL Server database.
• Member of team responsible for design and development Internet SIS application to allow shelters access DHS SQL Server database, upload MCH reports, and print Ad-hoc DHS reports using Visual Basic, HTML, ASP, and JavaScript.

Confidential, Sacramento, CA

SW developer

Responsibilities:

• Designed, developed and implemented the CAPI (Cash Assistance Program for Legal Immigrants) information system using Visual BASIC 5.0 and MS Access 97. The CAPI system allows DSS staff to maintain and track recipients, payment, and finance information between Confidential and counties in California.

Confidential, Sacramento, CA

SW developer

Responsibilities:

• Responsible for development, maintenance, and support of the Audit and Registration production systems. Audit and Registration are parts of the IRIS system, and they allow auditors to maintain account information using On-line programs, reports, special reports, and nightly batch jobs.
• Designed, developed and implemented the Special Calls system to assist BOE customers in obtaining non-confidential account information. This system is based on several COBOL programs on A-15 side, VC - MS SQL Server Special Call System, and MS Excel workbooks on PC workstations. Special Call System is used to download data from Unisys A-15, and upload them into MS SQL Server database. Using information stored in MS SQL Server, this system can generate user-defined forms, print account information, and create Avery labels and letters. Also it can be used to dump account information on tapes, disks, and floppies.
• Using VB Extra for IBM and VC++ 6.0, Designed, developed and implemented a VC++ file transfer process to allow Visual Basic applications on PC workstations connect to IBM mainframe. This process supports logins on IBM, sending/receiving files, and logoffs from IBM mainframe in fully automated mode. It consists of one VC++ module, which can be included in any VB applications. VB application can fill a request file and call a VC method to initiate the file transfer process. A file presence on IBM triggers a COBOL program, which extracts data and sends them back to VB application.
• Designed, developed and implemented the BT-530 system to allow auditors analyze and maintain downloaded information on their workstations. The first version was designed using VB 3.0 for Windows 3.11 then BT-530 system was converted for Windows 95 using VB 5.0. BT-530 system can request and obtain information from BOE Registration System through the file transfer process. Received data is uploaded into MS SQL Server. Users can work with received Registration information using Visual Basic application, print several forms by BT-530 system, and analyze data using MS Excel.
• Designed, developed and implemented Windows 95 version of the BT-1210 print system. It allows auditors print notices and letters on their workstations. BT-1210 can request, obtain, and update requested data using the file exchange process. MS Access is used as local database. Also BT-1210 is used to generate forms and notices based on received data and user's status.

Scientist

Confidential

Responsibilities:

• Developed software for mathematical modeling and engineering applications.
• Developed real-time control systems for turret punch press and flexible manufacturing system for sheet metal cutter using MS C/C++ and MS Assembler.
• Developed CAD control program in MS C/C++ to optimize sheet metal cutting processes.
• Developed input control system and video image processing systems for Micro Eye processor using MS C/C++ and MS Assembler.
• Developed pulse code modulation software application based on V.21 standard and G.711 recommendation using C++ and MS Assembler.