m

• Developing efficient SQL,TSQL, and SSIS packages to automate manual intensive processes.• Creating data assets and sproc to speed the reporting process for the Data Visualization team.• Building KPI's, scorecards and dashboards for the executive team.

Re-engineered and developed efficient SQL, TSQL and SSIS packages to automate manual intensive processes and replace legacy dts packages.. Created a SSIS master dataload process using an ETL framework to download and update all SalesForce.com Objects hourly, replacing the costly informatica cloud.Work with other departments to decommission all Applications on a SQL 2000 Database platform, these applications include salesforce.com, epicor front and back office, lyris

Created new automatic pricing system that enables price changes based on competitor prices, qoh, and current price of products. This process uploads price changes to Amazon every 20 minutes. It was built using SSIS packages, TSQL and a .Net application.Used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor and other means, execution plans, dmv views, index creation and query rewrites to increase SQL and website performance.Create user defined functions, derived tables, temp tables, and CTE’s to facilitate efficient data manipulation and data consistency and better performance.

·Create dimensional datamarts using ssis and ssas.·Creating, updating and reengineering SSIS packages that load the data warehouse, incrementally.·Automating manual processes for multiple business groups using efficient SQL, TSQL and SSIS packages.·Develop data driven solutions through full SDLC using various tools: including vb.net, asp.net, javascript, SSIS, SSRS, AND TSQL.· Built SSRS reports for all functional groups to answer business questions.· Model data warehouse fact and dimension tables to support Reporting and SSAS Cube development.

• Created and updated stored procedures to incorporate new functionality into our online web stores and speed up searching ability.(ex Circuit city, sears)• Supported all production databases, with focus on integration and development of new and existing products and services. • Rebuilt load process, using stored procedures and SSIS packages to load data into a stage environment, from flat files, and then to massage it and update our normalized structures that replicate down to the content servers.• Created administrative stored procedures to manage hardware space, log size, and create snapshots daily.

• Migrated data warehouse system to SQL 2005 database, migrated all crystal reports to Microsoft Reporting Services, updated all stored procedures to use new metadata and built robust SSIS packages to migrate data.• Developed new SSRS reports to meet the needs of business units, thereby enhancing the company’s ability to generate more revenue.• Designed, created and tested complex stored procedures that process data against the data warehouse.

• Responsible for monitoring and making recommendations for performance improvement of production databases. This involved index creation, index deletion and adding scheduled jobs to fix fragmentation.• Implemented log shipping, using scheduled jobs, on production databases.• Participated in logical data model and universe development of Business Objects system.• Extracted data from Transsoft DB, using VB, to update SQL Server 2000 data warehouse.• Created Web Intelligence reports for various business groups including operations, finance and marketing.

• Responsible for building and supporting multiple production databases, used by our web products. This includes creating all the database objects that reside in these databases including tables, triggers, views, stored procedures and functions.• Creating reports to monitor daily backup and maintenance jobs on SQL 2000 and 2005 db’s. • Defining and configuring interfaces to real estate (mls) data sources using DTS and SSIS packages, ftp scripts, vbscripts and stored procedures. • Lead data analyst and implementation specialist for Wyldfyre software and parallel database architecture, responsibilities include training and mentoring junior Data Specialists.• Create TSQL queries and scripts to manipulate data and investigate data related issues.• Built 2005 Microsoft Reporting Service reports, based on user requirements.

• Developed customized Oracle Report Writer and Discoverer reports for various functional groups, including Loss Prevention, Sales Audit, Point of Sale, Accounting, Merchandising, and Customer Service.• Created, tested and implemented PL/SQL functions, stored procedures, packages and triggers to transform, manipulate, massage and load data.• Programmed Java servlets to interrogate an Oracle database and return HTML based reports.• Built shell scripts to parse files and run PL/SQL programs, Oracle reports and other nightly processes that update reporting tables.• Designed and developed complex SQL queries to generate reports.