SUMMARY:

• With many years of experience in most aspects of IT, I am in search of a solid IT position in a stable company.
• I am a strong BI Architect/Developer and DB Developer with background in OLTP, Data Warehousing and Predictive Analytics / Machine Learning applications in SQL Server BI suites such as Cortana Intelligence Suite, SSAS, SSIS, SSRS and POWER BI with new exposure to Big Data and Cloud (Azure) technologies. My practical knowledge of Data Modeling has been an asset in all of these areas of expertise.
• My recent experiences, have also given me the people’s skills as well as public relations and leadership.

TECHNICAL SKILLS:

SKILLS: Microsoft Cortana Intelligence Suite Azure ML (Machine Learning), Azure Data Factory, Azure Data Lake, Azure SQL DB, R - Server, Power BI, R SQL Server 2005/2008R2/2012/2016 Business Intelligence (SSDT, SSAS, SSIS), Reporting Services (SSRS), T-SQL, Performance Point, SharePoint, PowerPivot, Power View, Power BI Big Data, Hadoop, Azure HDInsight, Azure Data Lake, Hive, Pig Power BI, Tableau, Qlik Sense ETL SSIS, Informatica 7 and 8 ORACLE 8, 9i, 10g, 11g PL/SQL, TOAD, SQL Developer DB2, DB2/UDB 7.2/EEE, 8.2, ESSBASE (OLAP) ER Studio, ER/WIN HTML, XML, MDX, DAX, PowerShell, C#, U-SQL, JSON, Java Script Agile, Waterfall, RATIONAL ROSE VSTS, TFS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, Arizona

Sr. BI Architect/Developer

Responsibilities:

• Played a leading role in establishing Octo Predictive Analysis project as part of Project Suite SaaS.
• Designed Predictive Analysis Software for the suite.
• Designed and developed Machine Learning Algorithms using Azure ML, R and R-Server.
• Architected and implemented Big Data solution using Azure Data Factory and Azure Data Lake.
• Interviewed technical staff for hiring on/off shore team.
• Established and developed BI/Reporting system for Project Suite using Qlik Sense, Power BI.
• Converted HD Reporting from Business Object to Power BI, Power BI Embedded and Java Script.
• Implemented Agile Development Life Cycle and participated in daily standups, pruning and retrospective.
• Utilized Azure ML, Azure Data Lake, Azure SQL DB, Azure Data Factory, R, R-Server, SQL Server 2016, SSIS, SSAS, SSRS, Power BI, Qlik Sense, Power BI Embedded, TFS, VSTS, JSON, T-SQL, U-SQL, Microsoft Cortana Intelligence Suite and Java Script.

Confidential, Phoenix, Arizona

Group Manager

Responsibilities:

• Played a leading role as a liaison between SME (system Matter Experts) and Offshore Team.
• Accountable for Knowledge Transfer of the Security systems and DBA teams.
• Established Technical, Question and Answer meetings.
• Designed and planned upgrades of the new release of software and development of SSIS, SSAS packages and cubes.
• Developed Minutes of Meetings (MOM), Status Reports and Systems Understanding Documents (SUD) and Meeting Recordings.
• Introduced Azure cloud as collaboration tool and experimented Big Data using Azure HDInsight.
• Utilized SQL Server 2012, SSIS, SSRS, SSAS, Azure HDInsight, Cloud.

Confidential, Scottsdale, Arizona

Sr. BI Developer

Responsibilities:

• Developed Aces and Member States Client Entry System.
• Production and Development Support of OLTP, ODS, Data-Warehouse and OLAP Systems.
• Heavy SSIS development for the support of SSAS cubes and Tableau Reports and Dashboards.
• Developed SSRS for QI system.
• Developed T-SQL and Stored Procedures for Member-Inventory System.
• Developed Tableau Reports and Dashboards.
• Performance Tuning of SQL and SSIS packages.
• Utilized SQL Server 2008 R2, SSIS, SSRS, SSAS, T-SQL, Tableau, Smart Bear.

Confidential, Chandler, Arizona

BI Architect/Developer

Responsibilities:

• Established BI Foundation for SaaS Online Software Developing Company.
• Gathered requirements by interviewing the leaders of each department.
• Studied OLTP by Reverse Engineering the model.
• Designed and built Academic Star Schema Data Warehouse.
• Developed the Star Schema model using SSIS ETL and T-SQL.
• Developed Academic Multidimensional Cube using SQL Server Analysis Services (SSAS) based on the developed Star Schema.
• Researched Third Party BI Vendors (i.e. Tableau, Birst, and more) as Analytical and Visualization tool.
• Developed Dashboards in Excel 2013.
• Introduced Power-Pivot and Power-view to the power users.
• Utilized SQL Server 2008-R2, SSIS, SSAS, SSRS, Power Pivot, Power view, MDX, DAX, Agile, and Tableau.

Confidential, Chandler, Arizona

Sr. Software Developer

Responsibilities:

• Established BI foundation in the company.
• Converted ODS Business Objects/Oracle Reporting System to Microsoft BI Suite.
• Designed and developed a new Data Warehouse Star Schema/Snow Flake model.
• Developed SSIS ETL to build the Data Warehouse.
• Introduced and developed SSAS Tabular Model.
• Developed SSAS Semantic Model using DAX to write Calculated Measures.
• Introduced PowerPivot and Power View on Excel 2013, SharePoint 2010 and SharePoint 2013.
• Converted Business Object reports to SSRS reports.
• Designed and developed impressive looking Dashboards using Performance Point (PPS), Power view, SSRS and Excel Services.
• Engineered complete Microsoft BI Suite on SharePoint 2013.
• Emphasized on Agile methodology for SDLC of the project.
• Participated in the requirement gatherings and user interface.
• Utilized SQL Server 2012, Oracle 11g, T-SQL, PL-SQL, SSAS, SSIS, SSRS, SharePoint 2013, Performance Point, PowerPivot, Power View, Excel Services, SQL Developer, DAX, MDX, Agile.

Confidential, Chandler, Arizona

BI Developer

Responsibilities:

• Developed EHS Compliance Reports including: designing and writing technical specification also developing T-SQL stored procedures, ETL and SSRS reports, UAT and deployment.
• Developed Energy Conservation System including: design, data model, ETL creation, Star Schema design, Cube Creation, Dimensional Hierarchies design, writing MDX calculations, writing SSRS and Performance Points reports and dashboards.
• Supported Ops Capital System including: MDX calculations, Cube changes, ETL changes and more.
• Utilized SQL Server 2008-R2, T-SQL, SSAS, SSRS, SSIS, Performance Point, TFS, SVN, ER Studio, Agile, MDX

Confidential, Laguna Hills, California

Data Warehouse Architect/Developer

Responsibilities:

• As Data Warehouse Architect,designed enterprise models and translating it to Star Schema for clients using Erwin.
• Creating logical and physical data models by reverse engineering the legacy systems and conversion to SQL Server.
• Responsible for design, development and support of new Data Warehouse systems for Promotions, and Financial Reporting applications.
• Responsible for requirements and data source analysis.
• Created cubes and data marts and aggregations on SQL Server 2005/2008-R2 using SSAS.
• Developed/Implemented ETL process and daily maintenance loads and procedures from OLTP databases to Data Warehouse using SSIS.
• Developed T-SQL stored procedures for ETL supporting, Reporting and more.
• Developed and Supported reports using SSRS utilizing SQL and MDX against tables and cubes.
• Utilized SQL Server 2005/2008-R2, T-SQL, SSAS, BIDS, SSRS, OLAP, SSIS Excel 2007, Erwin 7.3

Confidential, Los Angeles, California

DA/DB Developer

Responsibilities:

• As Data Architect, designed, created and maintained logical/physical models along with gathering, analyzing and profiling of data.
• As a Database Developer, developed PL/SQL, T-SQL for converting business functions from SQL Server to Oracle Middle tier as an engine rule.
• Migration of SQL Server database to Oracle 10g as target database.
• Performance tuning of all Stored Procedures and Functions.
• ETL development from Oracle to Distributing Servers used by outside users
• Developed and Supported Informatica 7/8 Mappings, Sessions and Workflows ETL to build Oracle Fact and Dimensions Tables for Siebel Analytics 7.7 reports.
• Created Multi Dimensional Cubes using SSAS for the Data Warehouse.
• Help Desk Support as a higher level for Siebel Analytics and ETL applications.
• Designed and implemented Purge Strategies by partitioning tables and writing stored procedures.
• Utilized Oracle 10g, SQL Server 2005, UNIX, Stored Procedures, Triggers, Functions, Erwin, ER Studio, Windows 2008, SSIS, SSAS, TOAD

Confidential, Woodland Hills, California

Real Estate/Loan Agent

Responsibilities:

• Assisting and supporting clients in providing financing by negotiating banks.
• Residential and Commercial Listings and Financing.

Confidential, Bothell, Washington

DBA

Responsibilities:

• As DB2 DBA and ORACLE Developer, worked on architectural design of Fraud System and possibility of 3G changes.
• Designed and developed stored procedure for all ETL process within ORACLE and DB2 Databases.
• Installed and migrated to UDB 7.2/EEE and trained other DBAs.
• Performed Capacity Planning and Performance Tuning of FDW (Fraud Data Warehouse) system under DB2/UDB/EEE 6.1 with database size of 3 terabytes on RS6000/SP under AIX.
• Production support, troubleshooting, day-to-day procedures, and 24/7 on call activities.
• Utilized ORACLE 8,9i, DB2/UDB/EEE 6.1-7.2, AIX 4.3.3, HP-UX 11, RS6000 /SP/S80/S70A, HP9000.

Confidential, Torrance California

DBA/DA

Responsibilities:

• Responsible for design, development and support of new Data Warehouse systems for Dealer Performance, Lease, Retail, Program Promotions, and Financial Reporting applications. The Data Warehouses were kept on DB2 and the Data Marts, on ESSBASE Multi-dimensional OLAP system.
• Led the benchmarking and selection of OLAP software products. Designed the logical data model based on dimensional modeling using S-Designer. Defined facts, dimensions and granularity of data for the Data Warehouse.
• As a liaison to Business Analyst team, converted RATIONAL ROSE Class Diagram UML to a conceptual Data Model and forward/backward engineered between logical and physical models of each environment.
• Implemented and lead JAD sessions, gathering requirements and interviewing the users.
• Performed project planning, project tracking, risk management, change management, and project issue tracking and resolution.
• Day to day support of production DB2, ORACLE and ESSBASE including upgrade, analyzing cubes, performance tuning, capacity planning, back up/recovery, and maintenance.
• Studied conversion of the DW system to IBM Visual Warehouse architecture using UDB with ESSBASE interface.
• Utilized DB2/390-Version 5/6, UDB 6.1, ESSBASE-Version 5/6, ORACLE 8.05, OEM, BMC, TOAD, OMEGAMON/DB2, S-Designer, ERWIN, QMF, INFOPUMP, Visual Basic Application (VBA), EXCEL, OS/390, NT, COBOL, CICS.

Confidential, Schaumburg, IL 

DBA

Responsibilities:

• As a Database Administrator, responsible for full support of production and development of up to 50 applications in Advantis located in Schaumburg, Illinois.
• Transferred to Wellington New Zealand for the development of INCIS project for the New Zealand Police.
• Involved in the logical and physical design and implementation of DB2 databases and models in DRDA distributed environment.
• Utilized DB2, DB2/NT, DB2/2, DDCS, LOTUS APPROACH, CAYENNE (BACHMAN),
• ER/win, PLATINUM, DBA-EXPERT.