PROFESSIONAL SUMMARY:

• Seasoned IT Professional with over 12 years of progressive experience as Windows & Web Developer; Database Developer & Administrator, Business Intelligence Architect & Developer, and Experienced Technical Lead. Mostly interested in Data Warehouse, Business Intelligence, Database Administration & Development projects using Microsoft SQL Server products.

TECHNICAL SKILLS:

Technology and Tools: 8+ yrs in Database Development using T - SQL 6+ yrs in Microsoft BI stack using SSIS & SSRS 2005 6+ yrs in Visual Studio 2005 Database Edition & BIDS 2005 6+ yrs in SQL Server Backup/Restore, Business Continuity & Disaster Recovery Setup 6+ yrs in SQL Server Installation, Architecture, in-place and side-by-side Version Upgrade 6+ yrs in SQL Server Database Archiving, Testing & Consultation 6+ yrs in SQL Server 2000 to SQL Server 2005 6+ yrs in DTS 2000 to SSIS 2005 Conversions 6+ yrs in SQL Server Performance Tuning Optimization utilizing Query Execution plans, Activity Monitor, Dynamic Management Views, Database Tuning Advisor, SQL Profiler & Perfmon 6+ yrs in Feed Aggregation (Thompson Reuters, Russell Investment, IDC, Cyber Source, Morning Star, Google Analytics and Adobe Omniture) 6+ yrs in ETL development for XML, Flat Files, Raw Files and Excel files 4+ yrs in Microsoft SQL Server 2008/2008 R1/R2 OLTP Database Administration 4+ yrs in Visual Studio 2008 Database Edition, BIDS 2008 R1/R2 4+ yrs in SQL Server 2005 to SQL Server 2008 Migration 4+ yrs in SSIS/SSRS 2005 to SSIS/SSRS 2008 R1/R2 Conversions 4+ yrs in Logical & Physical Data Modeling on SQL Server 4+ yrs in SQL Native, Quest LiteSpeed, RedGate SQL Backup & HyperBac backup tools 4+ yrs in RedGate sqlTOOLBELT: SQL Compare, Data Compare, SQL Prompt & Source Control 4+ yrs in Source Control tools: VSS 6.0, TFS 2005/2008 4+ yrs in SQL Server Database Snapshot, Log Shipping, Mirroring, Replication & Clustering 3+ yrs in Backup & Data Compression, Table Partitioning, MDW, CDC and Change Tracking 2+ yrs in Integration with MS-Access 2000, MySQL 5, Oracle 9i, PostgreSQL & IBM DB2 VMS/UDB/AS400 1+ yrs in OLAP, SSAS 2008, Visual Studio 2010, ReportViewer 2010, TFS 2010, WCF 1+ yrs in SQL Monitoring tools: Quest SpotLight/FogLight, Red Gate SQL Monitor, Idera SQL Diagnostics, SQLIO 1- yrs in MelissaData, Experian QAS and OneSource iSell data providers 1- yrs in VLDB (5TB and less) 1- yrs in SSIS/SSRS 2005/2008 R1/R2 to SSIS/SSRS 2012 Conversions 1- yrs in SQL Server 2012, SSIS 2012, SQL Server Data Tools, DQS, FileStream & FileTable Personal highlights include Passionate, ambitious, proactive, persistent, motivated, organized and responsible Member of both Professional Association for SQL Server ( PASS ) and Google Webmaster Tools Regular contributor to SQL Server Microsoft Connect and SQLServerCentral.com forums Member of Friend of Red Gate 2012

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Data Architecture Consultant / Advisor

Responsibilities:

• Analyzed business requirements and designed DW solution using SQL Server 2008 R2, SSIS & C# Designed ETL processes to consume data from Adobe Omniture/Google Analytics sources
• Implemented complex business logic for analytical purposes using SQL Server 2008 R2, SSIS & C#
• Experienced in handling multilingual data (Windows 1251: Cyrillic)
• Data Acquisition Framework (Database Development):
• Gathered requirements and evaluated existing solutions
• Created database objects to support the framework
• Designed and implemented highly reusable SQL Server table - driven SSIS-based solution
• Utilized FileStream with FileTable to act as a File Watcher process
• Implemented various delivery methods (FTP/HTTP/Open Socket) and archive functionality
• Employed the Framework to act as a trigger to different feeds
• Database Administration:
• Installed, configured and maintained SQL Server 2008 R2
• Completed migration of SQL Server environment from on-premises to a dedicated server hosting
• Researched incompatibilities between SQL Server 2008 R2 and SQL Server 2012
• Finalized in-place upgrade to SQL Server 2012
• Created separate SQL Server accounts for each SQL Server service
• Configured Management Data Warehouse to monitor performance
• Enabled backup compression to utilize disk space more efficiently
• Established Resource Governor to limit resource utilization between various SQL Server services
• Documented SQL Server installation, configuration & setup settings
• Outlined and defined business continuity using Maintenance Plans
• Implemented SQL Server and SSIS performance tuning optimization & best practices
• Identified and improved Recovery Point Objective ( RPO ) & Recovery Time Objective ( RTO )
• Very large database ( VLDB ) setup:
• Pre-sized and configured TempDB files
• Enabled Instant File Initialization to speed up data file allocations
• Boosted performance using Page-based Data Compression
• Utilized database snapshot for deployment rollback purposes
• Archived data out to increase performance
• Partitioned large tables between different File Groups/Database Files
• Prevented creation on new objects on PRIMARY File Group using DDL triggers

Confidential, Burbank CA

Sr. Production SQL Server DBA/Developer

Responsibilities:

• Installed, upgraded and configured SQL Server 2008/2008 R2
• Applied SQL Server 2008 Service Packs
• Administered clustered (Active/Passive) and stand - alone SQL Server 2005/2008/2008 R2
• Implemented Business Continuity policy using SQL native and Quest LiteSpeed backup utilities
• Analyzed dependencies, implemented, delivered and documented replacement of SQL Server boxes
• Performed proactive performance tuning optimization
• Utilized PerfMon to measure Batch Requests, Disk Read/Write per sec counters
• Delivered database code reviews
• Mentored SQL Server best practices
• Enforced database objects naming convention using SQL Server 2008 Policy Framework
• Produced process to correct orphan database/job ownership using SQL Server
• Released code to Production
• Technical Lead and DB Developer for StrongMail MTA Appliance enhancement project:
• Analyzed existing StrongMail to SQL Server data pull process for reporting purposes
• Mitigated the risk by switching to an official 64-bit compatible PostgreSQL OLEDB driver
• Researched and implemented brand new process using SSIS, SQL Server and C#
• Boosted performance by utilizing parallel processing capability of SSIS
• Revised the process to accommodate for PostgreSQL blobs objects
• Achieved higher data availability leveraging SSIS Raw File Component
• Upgraded the process to support simultaneous work of 2 StrongMail boxes using Indexed Views
• Rewritten and enhanced Email Feedback Loop (FBL) process using AAMailServer, SSIS and C#
• Rebuilt and improved Email Soft & Hard Bounce processes using SSIS, SQL Server and C#
• Introduced a process to help correct subscribers email addresses using SSIS Fuzzy Lookup
• Created real-time drill-through performance SSRS reporting for SSIS packages
• Produced up to 20 SSRS reports for Marketing/Finance/Executive Teams
• Database Development initiatives:
• Demonstrated SSRS 2008 R2 features and capabilities
• Finalized SQL Service Reporting Services adoption as a companywide reporting tool
• Produced full documentation for Company Reporting environment
• Implemented fully automated maintenance task to fine-tune indexes/statistics
• Enforced SQL Server Security by downgrading login/user access rights & permissions
• Implemented SQL Server Audit Trail via server-level DDL triggers
• Upgraded DEV environments from SQL Server 2005 to SQL Server 2008 (in-place upgrade)
• Upgraded PROD environments from SQL Server 2005 to SQL Server 2008 (side-by-side upgrade)
• Researched third-party SQL Server Monitoring tools: SCOM, SpotLight/FogLight & SQL Monitor
• Created fully automated DB refresh for DEV environment
• Evaluated and prepared detailed ROI comparison between SQL Enterprise vs. Standard Editions
• Created SSRS Admin reports on SSRS environment to showcase reports inventory, daily user usage, resource utilization and subscription information
• Provided full code transparency in SSRS reports (attaching source code to the data on-the-fly)
• Demonstrated Microsoft Excel 2010 PowerPivot add-in capabilities to enable self-service access to vital company metrics

Confidential, Los Angeles CA

SQL Server Development DBA

Responsibilities:

• Enforced naming convention using SQL Server 2008 Policy Framework Implemented SQL Server 2008 Resource Governor to isolate various SQL Server services
• Introduced Full - Text Index Search to improve text-based execution performance
• Developed scripts to automate repetitive database administration tasks
• Provided performance tuning optimization (PTO)
• Established Database Mail to enable fast & streamlined status reporting
• Mentored SQL Server Standards and Best Practices
• Performed regular T-SQL code reviews
• Applied advanced T-SQL Error Handling
• Database Development:
• Redesigned Agent Accounts Merge process to offer scalability and fail-safe execution
• Lead alternative solutions for SSIS repository, deployment & error handling
• Created SSIS real-time performance monitoring using SSRS
• Trained SSIS naming convention
• Demonstrated SSIS framework architecture design
• Presented BIDS Helper Visual Studio add-in

Confidential, Los Angeles, CA

SQL Server Database Administrator / Data Warehouse Analyst

Responsibilities:

• Technical Lead for relocation of Royalty Reporting System from SJ Office to SD Data Center:
• Performed compatibility assessment & risk analysis of upgrading the process (SQL Server 2000 OLAP sourced from Oracle 9i OLTP) to the newer SQL Server technologies
• Transitioned & combined 150 DTS 2000 packages into 30 SSIS 2008 packages
• Rebuild SQL Analysis 2000 into SQL Server 2008 Analysis Services cubes (including dimensions, fact tables and cubes)
• Verified data using Oracle SQL Developer, Oracle SQL Plus and PL/SQL Analyzed output data - files using SweetScape 010 Editor
• Compared and synced folder/files between old and new FTP servers using FileZilla FTP Client
• Validated data-files between old and new systems using Scooter Confidential Compare content
• Royalty Reporting System Database enhancements:
• Implemented file upload through FTP Proxy
• Built secured FTP (SFTP) file upload functionality utilizing WinSCP client
• Created file archiving functionality using 7Zip software
• Decoupled, combined and optimized SSIS packages to extract data from Oracle 9i
• Utilized Attunity high-performance drivers for Oracle on Windows Server bit
• Produced SSRS reports for Treasury & Financial Systems
• Database Administration:
• Installed and configured new SQL Server 2008 servers
• Applied SQL Server 2008 Service Packs
• Restored databases and SQL Server agent jobs
• Implemented Disaster Recovery/Business Continuity strategy
• Installed Oracle 11g Client Tools and configured TNS on Windows Server bit
• Applied Policy-Based Management policy to track ownership of databases and jobs
• Established Resource Governor to isolate & limit SQL Server related services

Confidential, Los Angeles, CA

SQL Server Business Intelligence Architect & DBA

Responsibilities:

• Technical Lead & Developer for company-wide SSIS implementation:
• Researched and demonstrated SQL Server Integration Services capabilities and weaknesses over existing Business Objects Data Integrator ETL tool ( BODI )
• Reorganized various separated/decoupled processes, DTS & BODI packages into single SSIS 2005 platform
• Mentored and supported new SSIS developers
• Created short movie to emphasize the simplicity and value of programming SSIS packages
• Technical Lead & Developer for WON proprietary ratings Data Feed product:
• Analyzed and implemented Data Quality (Zero/NULLs %) drill-through set of SSRS 2005 reports
• Implemented feed files creation and distribution systems using SSIS 2005
• Utilized 7Zip for file archiving/space saving
• Delivered final product, produced product documentation and trained Production Support Team staff members
• Technical Lead & Developer for Historical data migration:
• Designed a single SSIS package to transfer data from 600 de-normalized template based Excel files into normalized data storage in SQL Server (included PIVOT, UNPIVOT, LOOKUPs and Data Flow .NET Script Components)
• Technical Lead & Developer for History snapshot project:
• Lead product from development to production
• Designed daily data capture infrastructure
• Implemented a unique Data Profiling on Column Value tool using T-SQL
• Delivered final product, produced product documentation and trained Production Support Team
• Technical Lead & Developer for Mail notification enhancement project:
• Researched replacement of custom stmpsend DLL with SQL Server 2005 Database Mail
• Identified related objects for migration
• Completed one-click migration script ready to run on any Database server
• Data Acquisition Framework project:
• Researched, designed and implemented reusable ETL processes
• Defined and streamlined the process of feed acquisition
• Substantially reduced the time it takes to acquire new feeds (from weeks to days)
• Presented & documented new framework in details
• Completed migration of existing feeds into the new framework
• Data Architecture project for Investors.com:
• Analyzed, refactored and normalized existing data structure
• Performed performance tuning optimization
• Implemented 20+ marketing/financial reports using SSRS 2005/2008 & Report Builder 1.0/2.0
• Business Intelligence projects:
• Implemented Auto Deployment feature for SSIS packages
• Created real-time SSIS performance reports using SSRS 2008
• Aggregated various 15+ financials feeds from Thompson Reuters, Standard & Poor's, Russell Investment Group, IDC Financial & more using SSIS 2005
• Upgraded SSIS & SSRS from SQL Server 2005 to SQL Server 2008
• Database Administration projects:
• Applied Policy-Based Management policy to validate company naming convention
• Established Resource Governor to isolate SSIS & SSRS services running on the same server

Confidential, Los Angeles, CA

ASP.NET / SQL Server Developer

Responsibilities:

• Lead Developer for AgentSite product - client-facing, high-traffic, highly customizable Web-based application that manages 4,000 Real Estate professionals web sites:
• Supported, maintained and enhanced the product using ASP.NET 1.1/C# w/SQL Server 2005 Supported, maintained and enhanced Admin Page using ASP/VBScript w/SQL Server 2005
• Incorporated and optimized dynamic SQL statements into store procedures, views and user-defined functions to prevent SQL injection attacks and boost performance
• Redesigned featured property rotation feature
• Implemented automatic image re-size and optimization functionality for custom uploaded images
• Replaced Expedia-based interactive maps in listing details page with Google Maps by implementing Google Maps API (using single registered Google Maps API Key)
• Researched, analyzed and developed new features:
• Incorporated YouTube video under Agent video profile page
• Enabled instant web page translation to Spanish & other languages using Google Translator
• Introduced and integrated web site analytics by utilizing Google Analytics Integrated web site diagnostics tools by incorporating Google Webmaster Tools and Yahoo Site Explorer Implemented email address masking to protect against Spam Bots email harvesting
• Analyzed and created a database-based run-time General Exception Collector (similar to Microsoft Windows Error Reporting application)
• Mail Server Migration projects:
• Analyzed and implemented a Windows-based application to migrate up to 6000 email aliases from file system-based IMail server to a database-based Mail server
• Analyzed and implemented a Windows-based application to transfer up to 6000 email aliases from Windows registry-based Mail server to a database-based Mail server

Confidential, Los Angeles, CA

Business&Technology Consulting (part-time)

Responsibilities:

• Created a Windows - based application using VB 6.0 w/Access 2000
• Implemented a custom-built 3-color indication scheduling module to manage appointments, technician availability and their assignments
• Database Administration and Development:
• Installed, configured and maintained SQL Server 2005/2008 on Windows Server 2003
• Applied Service Packs on SQL Server 2005/2008
• Migrated SSIS & SSRS from
• Administered SQL Server 20 x7x365)
• Utilized Integration Services to bring data from MS-Access over to SQL Server
• Utilized Reporting Services to expose valuable company key performance data
• Implemented Disaster Recovery strategy
• System Administration:
• Configured Domain and Off-site DNS settings
• Configured IIS 6.0 on Windows Server 2003
• Created and maintained SMTP and Email Forwarding accounts
• Secured web applications via SSL s
• Applied Service Packs on Windows Server 2003
• Configured HP Array RAID 5 and HP Network Teaming
• Maintained Compaq/HP ProLiant DL120 / DL140 / DL380 / DL380 G3 servers
• Company web presence development:
• Analyzed and created Web site using ASP.NET 2.0/C# w/SQL Server 2005
• Implemented .NET 2.0 Health Monitoring
• SEO & SEM
• Analyzed & produced automatic sitemap file generator
• Achieved Google's PageRank of 4 - out-of-10 with daily traffic of 30-50 unique visitors
• Improved Search Engine Optimization through on-page & off-page optimization
• Implemented MaxMind Geo-location by IP address
• Created real-time web site statistics
• WMS - Warehouse Management Web-based System
• Analyzed business requirements
• Created a Warehouse application using ASP.NET 2.0 w/SQL Server 2005
• Implemented inventory, purchase and sales orders management modules
• Implemented part's cross- requirement
• Utilized ASP.NET Master Page, Authentication & Authorization features
• Business Development:
• Created various marketing campaigns to promote company's products and services
• Increased Company revenues by 50%
• Assisted in acquisition of up-to 40 new business partners
• Promoted income diversification going from 5 to 30 business partners

Confidential, Agoura Hills, CA

Responsibilities:

• ASP.NET/.NET & SQL Server DeveloperAlvarion (formerly Floware Wireless Systems), Tel-Aviv, Israel Production Support Enginee