To secure a position in Data Architecture using my proven expertise in team mentoring, data management and data warehousing.

SUMMARY OF QUALIFICATIONS

• 10 years in Data Modeling and Architecture. Over 10 years experience in team leadership and consulting.
• Skilled in performance tuning tables of over 1 billion records in SQL Server 2008 R2.
• Ability to get IT and Business team energized while focused on deliverables. Ability to maximize existing resources while saving capital.
• Excellent analytical, organizational and interpersonal skills. Ability to think outside the cube.
• Communicates effectively with all levels of staff. Fortune 500 experience.
• Over 5 years of SQL Server database administration.
• Designs simple dimensional schemas from complex systems with Analysis Services.
• Experienced developing CRM and time entry applications for large organizations. Financial background.
• Strong knowledge of table partitioning, mirroring, Analysis Services development and administration.
• Over 10 years experience in SQL Server Architecture design and deployment.

PROFESSIONAL EXPERIENCE

Confidential

DATA WAREHOUSE DEVELOPER/LEAD

• Administered SQL Server and Netezza Data Warehouse infrastructure including backups, security, performance tuning and optimization. Tuned billion record data loads. Managed release cycles.
• Designed and implemented logical and physical dimensional data models on SQL Server 2008 R2 for revenue analysis. Created first ever self service automated reporting environment on an enterprise level at Landmark Digital Services and BMI using the MSBI stack.
• Designed analysis services cubes and used MDX to analyze radio performance data decreasing error rates and increasing quality of external client reporting.
• Led Warehousing Team meetings and gathered requirements from users. Transferred requirements into deliverables.
• Increased user productivity by delivering an enterprise self service reporting solution and automated data matching against master data.
• Worked alongside Scrum Master to deliver required functionality to business users. Led team on agile projects and ensured that sprints were completed with all functionality in a timely manner.
• Mentored new Business Intelligence team members and coached them on best practices on all available technologies.
• Designed ETL solutions using SSIS and IBM Data Stage from DB2, Oracle, SQL Server 2008 R2 and mainframe data sources.

SR. DATA WAREHOUSE DEVELOPER

Confidential

• Developed SSIS packages programmatically allowing code re usability by other developers.
• Developed XML web services solutions using SQL Server 2005, Tibco and C technologies.
• Created web service applications to communicate with Microsoft CRM-AIF application.
• Architected advanced re-usable ETL Web Services components to import client data.
• Trained DBAs and Architects on SQL Server Analysis Services disaster recovery strategies and security.
• Key liaison between Middle tier team and ETL Team providing solutions for the enterprise bus.
• Supported ETL services for data warehouse and integrated data marts across businesses.

Confidential

• Met with business leaders to gather requirements for re-design of their call system statistics to use predictive logic to drive the health coach call center.
• Developed backup and recovery procedures on transactional and dimensional database servers. Recovered databases from corruption. Tuned queries for performance and accuracy. Instituted best practices to prevent further data corruption.
• Modified existing transactional schema to allow creation of cubes from mirrored transactional databases. Trained users on analyzing transactional data to find trends that later helped on the design of a dimensional model.
• Created cubes in Analysis Services 2005. Configured SAN disk for optimal IO. Worked with infrastructure on deploying Share Point and Performance Point.
• Structured and maintained initial SQL Server infrastructure including disaster recovery and database mirroring.
• Met with Business Analysts to understand the existing system and used the gained knowledge to re-construct transactional data history and build conformed slowly changing dimensions on the data warehouse. Gathered business requirements for enterprise wide data warehouse project.
• Led team members and consultants ensuring that work was properly prioritized. Worked with Vice President on talent acquisition for the Business Intelligence and Informatics teams. Managed budget, vendor relations and a team of internal and staff augmentation resources.

Confidential

• Architected new development environments and implemented improvements on coding methodologies.
• Led a team of developers and oversaw project deliverables. Ensured that projects were completed on time.
• Developed cubes in MS Analysis Services 2005 SSAS to help find trends in data from external clients.
• Implemented new Integration Services methodologies across enterprise to allow packages to run more efficiently.
• Worked with Architects and DBA to revamp existing deployment methodologies and processes to minimize deployment errors.

Confidential

• Developed MDX reports in SQL Server Report Services 2005 for Enterprise Data Warehouse.
• Created SQL Server Integration Services packages. Integrated ETL with VS.NET.
• Performance tuned Master Data Management system improving query performance by over 95 .
• Transformed Data Warehouse into MDM system allowing business to perform faster more accurate searching and matching of company assets.

Confidential

• Upgraded existing databases from SQL Server 2000 to SQL Server 2005 64 bit.
• Re-created ETL processes in SQL Server Integration Services. Trained developers on 2005 functionality.
• Introduced T-SQL programming best practices to team members. Recovered corrupted databases and
• Implemented disaster recovery infrastructure.
• Performance tuned existing stored procedures to allow migration to SQL Server 2005 ANSI standards.

Confidential

• Interviewed users and management to gather system requirements.
• Created SQL Server application used for project management and allocation of 125 resources.
• Implemented a system for customer billing. Trained appropriate users on usage of tools.
• Created logical and physical database model based on business rules provided by users.
• Enforced several complex business rules with stored procedures, triggers and functions.
• Analyzed and cleansed mainframe and Oracle 8i data during migration projects.

Confidential

• Developed a SQL Server 2000 database and front-end application to track store leases and sub leases. Used application to report current status on all properties. Generated reports for Federal Trade Commission stating current and projected financials.
• Ensured referential integrity, data consistency and security of database. Automated all DBA tasks.
• Used ADO and Visual basic to validate data entry and business rules.
• Used SQL server database roles to manage user permissions.
• Created electronic library of leases/contracts and made this available through a front end application.

Confidential

• Used SQL Server and Visual Basic to create statistical reports and user interfaces.
• Analyzed data from SQL Server 2000 database identifying customer trends.
• Developed automated reporting applications allowing accurate, fast and reliable information while freeing up resource time.
• Used TSQL and Visual Basic to validate business rules during data entry.
• Ensured timely completion of projects increasing implementation rate by 40 .