Summary of Qualifications

• Senior Architect, Developer in SSIS ETL, SSRS, C , Enterprise Data Warehouses, Microsoft Business Intelligence, Databases, Systems, Applications Security, SQL DBA, ASP.NET. Some Java, MVC, Web Services. Process automations, data cleansing, data extraction, data movement data quality. 15 years cross platform developer mainly on Microsoft platform but also on Open source / Sun Java / IBM Websphere / BEA Weblogic platforms.
• Also a seasoned qualified Windows System Engineer, Security Administrator, Architect, Storage / SAN Architect, System Application Management, Operations Production Support, Migrations and Consolidations of Databases, Servers and Applications. Disaster Recovery Architect, Solution Architect.
• Positive verifiable work history in US federal and military agencies NASA, WASHINGTON AIR NATIONAL GUARD - United States Air Force, State of Oregon , and in private consulting Microsoft Corp, Intel Corp, IBM Global Services etc.

Technical Skills

• SQL, SQL Server: 15 years all versions. SQL Server 2014, 2012, 2008 R2, 2005, 2000, 7, 6.5. Stored Procedures, Views, Tables, Indexes, Functions, Triggers, T-SQL, Performance Tuning, OLAP, OLTP. IBM DB2 v7 8 4 years , Oracle 8 / 9i for NT/2000 3 years , MySQL 6 years , SQL. Access, DBASE: 14 years.
• SQL Server Integration Service or SSIS 6 years , DTS 6 years , ETL design Extract transform - load including replication, publishing, data import, export. Database design, data schemas, OLTP normalization denormalization for reporting databases.
• SQL Server Reporting Service or SSRS 6 years , some Analysis Service 2005 / 2008 / 2012. Data warehouse / data mart multidimensional database design .
• KPI, Cube design 2 years
• Visual Studio All versions: 2013 / 2012 / 2010 / 2008 / .NET / 6. Visual Basic.Net, ASP.NET, Classic ASP, ADO.NET, C 2012 / 2010 / 2008 / .NET , Web Services: 12 years. Entity Framework: 2 years for a windows form application, a command and control system at USAF / Washington National Guard / Quantum Dynamics Inc
• MVC in J2EE: 6 years. MVC in ASP.NET: 3 years.
• Java, JSP, Servlet, EJB, J2EE, open source, cocoon, XSP, LDAP, Tomcat, Xerces, Struts Framework, Websphere Studio WSAD 4 and 5.1 : Apache, Eclipse, MyEclipse, Tomcat, JBoss, SUSE, Ubuntu, Linux: 9 years
• Scripting Languages:
• PowerShell: 2 years JavaScript, Jscript, VBScript, DHTML, XML, XSL, XLST, XHTML / HTML, CSS: 12 years
• Virtualization: 5 years including VMWare,Vcenter, VSphere, Virtual PC, MS Virtual Server 2005, Hyper V. Install, Configurations. Virtual Box.
• Change Management and Source Control: 10 years. Experience level in descending order: VSTS, SVN, Visual Source Safe, Team Foundation Server, TFS, PVCS, CVS, ClearCase
• Builds: Wix, MSI, source depot. Ant. 5 years.
• Firewalls, SSL, SSH, Routing, DNS: configuration, setup: 10 years.

Professional Experiences

Confidential

ETL, Architect - Developer. Data Mart team. Developed and added new data fields to existing SSIS packages based on Microsoft data warehouse design pattern cbf common BI framework to onboard new metrics rapidly. Used Powershell to automate database build and deployment dacpac . Analyzed and developed indexes to improve ETL performance. Developed ETL SSIS packages to push data to Windows Azure storage. Developed data pulls from Cosmos using Scope scripts. Deployed SQL database projects using Octopus. Developed CDM Consumer Datamart SSAS cubes and cube security. Developed stored procedures using T-SQL. Resolved issues for Exact Target ET data mart, ETL process, and data quality. Determined complex ETL jobs dependency. Transferred knowledge from another vendor. Optimized ETL performance eg optimized one task from 45 min to 10 min . Developed ETL SSIS packages, .NET applications and SQL data processes. Developed stored procedures and parameterized SSRS reports. SRA service risk assessment status change tracking. T-SQL. Visual Studio VS 2015 / 2014 / 2013 / 2012 Ultimate, MS SQL Server 2014 / 2012 / 2008 R2, SSIS, SSAS, SSAS Tabular, Sharepoint 2013, Powerpivot, Power BI, Excel, SSRS. T-SQL, SSDT, GIT, TFS / VSTS change processes, shelveset / Code Flow / Code Review.

Confidential

Developer SQL DBA. Business Intelligence Developer. Developed SSIS T-SQL data processes, stored procedures, designed SSAS cubes and sales metrics KPI to drive growth in sales, as part of the enterprise EDW BI analytics team. Worked as development SQL DBA. Developed utilities in C / .NET to scan space info for hard drives / mountpoints, scan SQL databases for data / log files, developed CLR stored procedures to load delimited files and Excel files into SQL databases. Developed a SSIS package to test write permissions using specified credential. Teradata 13 / 14, SQL Server 2012 / 2008 R2, Visual Studio 2012 / 2010. T-SQL, C . ADO.NET, ASP.NET, SSIS.

Confidential

Developer. Business Intelligence. Built a prototype business intelligence solution for GuildWars game to identify suspicious players, hackers and bots in a game play, aggregated hourly loads of game play data. Prototyped data mart. T-SQL, performance tuning, added proper indexes which speeded up report rendering from fact tables with more than 5 millions of records.

Confidential

DW BI Architect / Developer. Delivered reports to project managers of HP and Vale executives for a large scale windows 7 upgrade and migration project Application Remediation . Designed enterprise data warehouses and data marts, reporting solutions using Microsoft BI stack. T-SQL,SSIS, SSRS, SSAS, Visual Studio 2010, MS SQL Server 2008 R2.

Confidential

September 2010 July 2011. Sr Architect - Developer, Database Engineer. Developed security tools to scan hosts and devices on the network, developed reports with a goal to discover host or network vulnerabilities. Developed T-SQL procedures, SSIS / ETL packages to cleanse, extract and load data into custom databases for analysis and reporting. C , Visual Studio 2010 Ultimate, entity data framework EF , LINQ, ICS industrial control systems , network and security tool development. Hands on experiences in Virtualizations with VMware Server 2.0.X, VMware workstation, VSphere, VCenter management and Microsoft Virtual Server.

Confidential

• Developer and Platform Evangelism team / DPE: Sr Developer. System Administrator DBA. Developed SSIS packages to extract and load data from sharepoint portals into SQL Server, developed the data warehouse database. Created test OLAP cubes for reporting.
• Specialized Devices Applications Group / SDA, Sr Developer. Developed databases and Web services in C and ASP.NET, Visual Studio 2008. ASP.NET 3.5.
• MSIT Windows Services Security Group. Sr Developer. Developed reporting and auditing systems using SSRS, SSAS, SSIS. Set up dev infrastructure on x64 windows server 2008, x64 SQL Server 2005 / 2008 and visual studio 2005 / 2008. Designed database for reporting, developed ETL processes, stored procedures and SSRS reports. ASP.NET.
• MS ONLINE SERVICES Security identity - MSN GFS LIVE Ops , Lead SDE / Lead Database Engineer. Developed and maintained SSIS packages for data feeds, and developed FOPE subsystems for a Silverlight business intelligence application for enterprise dashboard reporting and monitoring of server operation metrics and performance counters. Developed database schemas and SSIS to store and display complex hierarchy data. Reporting Metrics, Reporting portals, Dashboards, Scorecards, Scoreboards, Business Intelligence, Data warehouse, RIA WCF RIA Services. C , Visual Studio 2010 Ultimate, MS SQL Server 2008, SSIS, SSRS, SSAS. Also installed and maintained sharepoint servers sharepoint server 2010 on windows server 2008 R2 x64 in a farm engaged in a multiforest AD.

Confidential

Architect, Developer. Migrating a payment system written in Access Reports / Forms VBA with some data on MS SQL Server 2000. Migrated / converted some Access 2000 queries to MS SQL 2000 stored procedures and views which in turn are used by Access reports / forms. Expert in creating Access passthrough queries to use SQL server 2000 procedures / views to feed access reports, dramatically improving performance.

Confidential

Database Architect. Design, model, architect and integrate database for mobile phone ad campaigns. Provided design spec for data center documentation, migrated / ported Atlas / Accipiter databases major 1 ad serving database used by USA media and ad agencies to MSSQL from MySQL and Oracle using SQL Server DTS / SSIS, and reverse engineered all relevant databases to produce ERD, ORM / UML diagrams and data models using tools like ER Studio, DB Designer and Visual Paradigm, to assist developers utilize these databases and understand data structure. Provided database architecture document.

Confidential

System Engineer. Lead web developer for Project Deuce, a data collection tool using ASP and SQL server 2005. Wrote stored procedures, triggers, views, DTS packages to pull data from diverse data sources etc. Designed most of the front pages in ASP and backend database in SQL server. Deuce database backup and system maintenance, and troubleshooting application errors / debugging. Recognized system administrator and database storage architect, and windows systems architect / SME for SCON. Designed SAN / storage, recommended Infrastructure /Architecture. Configured HA High Availability clustering, load balancing for MS SQL, IIS, SQL server and windows server data collection and sizing of databases / partitions / SAN volumes For example design and migration of Onyx databases on SQL Server clusters for Ameriprise.