SUMMARY

• Microsoft certified SQL Server 2000/2005/2008 professional experienced with all aspects of SQL including: T-SQL, SSIS/DTS , OLAP Analysis Server SSAS , Reporting Services SSRS and Data Replication.
• Experienced working in all phases of data warehouse development - from gathering requirements to project scope and analysis, design, development, testing, implementation and support.
• Demonstrated expertise using ETL Tools, including SQL Server Integration Services SSIS , Data Transformation Services DTS , and IBM Webshpere Datastage v8.1.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

SKILLSET:

• Crystal Reports, Cognos, Datastage v7.5/v8.1, Erwin, DB2 Hit Software Replication, Serena PVCS, Microsoft SQL Server 2000/2005/2008, DB2 UDB, ACCESS, EXCEL, FOCUS, WEBFOCUS, Silverrun BPM/ERX modeling, and Summit/D Project Management Case Tools, HP PPM, MS Office, MS Projects and MS Visio.
• MCTS : Microsoft Certified Technology Specialist - SQL Server 2005
• Certified: SQL Server 2000 DBA Professional
• Certified: SQL Server 2000 Application Developer

EXPERIENCE

Confidential

Director Database Administration and Data Warehousing

• Responsible for strategically designing, developing, and implementing Business Intelligence software systems, including integration with databases. Architectured and developed the first Enzo Biochem Lifesciences Data Warehouse to support an ERP System based on Microsoft Dynamics Navision.
• Collaborate with Executive Management, Finance, Clinical Labs, and Information Technology teams to evaluate business needs, propose optimal solutions, and translate them into functional requirements.
• Create and maintain relevant reporting and business process documentation, such as requirements, business rules, visio flow charts, etc
• Developed OLAP cubes Datamarts based on STAR schema for Enzo Line of Businesses using SQL Server 2008 RDBMS and Analysis Services.
• Collaborated with Seacoast Labs Data Systems LIS to develop Enzo's Clinical Labs Data Warehouse running on SQL Server 2012 platform.
• Developed Extract Transfer Load ETL procedures using SQL Server Integration Services SSIS in support of all Data Warehouse initiatives.
• Sharepoint, Standard Operating Procedures
• Served as project manager and DBA on an internally developed web-based Change Management System which is SOX audited.
• Collaborated with Executive Management to develop a Disaster Recovery and Business Continuity plan.

Confidential

Sr. SQL Server Developer / Business Intelligence Developer

• Responsible for day-to-day support of Outlooksoft Financial business software which included planning, consolidation, forecasting, budgeting, dashboards, and reporting in a SQL Server 2005/2008 environment.
• Developed and maintained a data warehouse used by the Service Review Office for reporting on Service Level Agreements SLA .
• Created SSRS reports for use in strategic planning and supported analysis functions used by Outlooksoft Corporate Performance Management software SAP/CPM version 4.2.
• Served as project coordinator during the upgrade of Outlooksoft SAP/CPM v4.2 to SAP/BPC v7.5 running on SQL Server 2008. Assisted in the remediation of SQL Server DTS packages to SQL Server 2008 SSIS packages.
• Developed Extract Transfer Load ETL procedures using MS SQL Server Data Transformation Services DTS , SQL Server Integration Services SSIS , and IBM Datastage v8.1.
• Supported data migration environments in Development, QA, and Production and utilized Serena PVCS software to maintain program code, stored procedures, database/table scripts, and documentation.
• Created and maintained SLA application using reports developed in Cognos v8.3 Report Studio and Query Studio.
• Lead Coordinator for Business Continuity Planning and Disaster Recovery in Application Development Department.

Confidential

Sr. SQL Server Developer / Consultant

• Participated in reengineering the Companies legacy Travel Reservation System TRS to utilize Graphical User Interfaces GUI and relational database technology in an AS400 DB2 and SQL Server 2005 environment.
• Responsible for developing Extract Transfer Load ETL procedures using MS SQL Server Data Transformation Services DTS and SQL Server Integration Services SSIS .
• Migrated large sums of data from SQL 2000 to SQL 2005 and from SQL 2005 to AS400 DB2.
• Participated in Joint Application Development JAD meetings with Senior IT Management and assisted with defining business requirements which were later translated into programmable specifications.
• Maintained project Entity Relationship Diagrams ERD and performed data movement between various programming environments on the AS400 and within SQL.
• Supported Epicor Financial Application and other SQL based applications while developing new reports using Crystal and SQL Server Reporting Services SSRS .
• Developed several OLAP cubes datamarts based upon STAR Schema's for Finance and Sales Departments.

Confidential

Database Developer/ Architect Consultant

• Assisted in the re-engineering and conversion efforts of a small financial application designed in Microsoft Access. Applications which were re-coded, updated, and re-deployed in a Microsoft SQL Server 2005 RDBMS production environment.
• Created new SQL stored procedures, job schedules, and data transformation packages DTS/SSIS and converted Microsoft Access reports to Crystal Reports and Microsoft SQL Server Reports SSRS .
• Served as technical liaison to Executive Management and provided weekly status reports of all activities.

Confidential

Sr. Director Data Warehouse Development

• Spearheaded the creation, implementation, and maintenance of the companys first mission-critical data warehouse, which served as the primary resource for analytics, inquiries, and measures of Financial Performance. The data warehouse empowers senior management to easily analyze customers, sales rep activity, orders, commissions, advertising and shipping costs, and perform detailed sales analysis.
• The sales and marketing data warehouse was developed completely in-house using data from an AS/400 DB/2 database replicated via Hit Softwares DBmoto product to:
• o SQL 2000 /2005 RDBMS, SQL Server Analysis Services SSAS
• o T-SQL and Data Transformation Services DTS - to extract, cleanse and ensure data integrity for ETL SSIS data staging.
• o SQL Server Analysis Services was used to create a 200 gig sales marketing datamart, based on a star schema.
• o Data presentation tools used to communicate with OLAP cubes were: SQL Server Reporting Services SSRS , Microsoft Excel Pivot Tables, Microsoft Office Web Components, Crystal Reports, Crystal Analysis, and COGNOS.
• Regularly participated in JAD sessions with various business units to analyze, define, scope, and document business requirements, rules, changes, issues, and signoffs for all data marts.
• Logical, physical, and dimensional data models were created using ERWin and Microsoft Visio.
• Served on the corporate disaster recovery team responsible for all SQL Server database functions including: installs/upgrades, backup/restores, performance monitoring, data replication and job schedules.
• Analyzed all production data imports and exports from corporate database s to ensure data integrity and maintain application functionality.
• Responsible for all data appearing on the companys B2B and E-commerce websites and created reports using Crystal Reports and SQL Server Reporting Services.

Confidential

Project Manager / Consultant

• Independently contracted to plan, manage, and coordinate all year 2000 compliance activities relative to Legal Services FOCUS application systems.
• Remediation efforts focused on the Case Management System, Reserve Settlement System, and disparate legacy data systems. Year 2000 remediation efforts were completed using the Federal Best Practices Guidelines, emphasizing 5 phases: Awareness, Assessment, Renovation, Validation and Implementation. Developed and implemented procedures and documents for communicating project status, issues, change requests, client deliverables, and project acceptance criteria. Prepared and administered Year 2000 remediation work plans, staffing requirements, and final documentation throughout project life cycle.

Confidential

Programmer / Analyst

• Reporting to the Vice President of Professional Services, I was responsible for supporting Information Builders FOCUS and WEBFOCUS product lines at major client sites and significant internal projects at corporate headquarters.
• Remedied situations where clients were disillusioned with the outcome of the project or where projects were running over budget or behind schedule.
• Provided technical and functional expertise in the analysis, design, development, testing, and implementation of FOCUS application systems.
• Collaborated with sales and marketing representatives providing technical support when designing, negotiating, or presenting Request For Proposal RFP .
• Led the effort in evaluating and selecting a comprehensive Year 2000 compliance methodology for FOCUS applications. Raised client end-user FOCUS skill set levels through in-house formal training and off-site training programs.
• Prepared weekly and monthly status reports for internal management, clients, and co-workers.

Confidential

Senior Information Systems Officer

• Managed technically and administratively a staff of four and two consultants supporting applications relative to: International Staff Payment Processing ISP , Domestic Payroll, Payroll Account Record Keeping System PARKS , Human Resource Information Processing HRIP , and Core Business Performance Award System CBPA .
• Acted as a single point of contact and primary interface for an environment, which encompassed numerous departments supporting over 400 end-users.
• Responsible for overseeing daily work schedules and assigning projects.
• Served as technical liaison to marketing group during new client prospecting, analyzed and scheduled IT Request for Modification RFM and produced weekly and monthly project status reports.
• Researched, evaluated and recommended software products and productivity tools such as code repositories, integrated development environments IDE and software packages used by developers.
• Led re-engineering and conversion efforts on the International Staff Payment Processing system originally written in DATABUS and converted to FOCUS.