SUMMARY:

I have more than 20 years IT experience with 12+ years dedicated to data warehousing and business intelligence development from which I provide technical guidance and direction in defining the data architecture strategy for enterprise data solutions. I work with senior management, project management, technical teams and business users to determine exact business needs, data requirements and best practices for advanced data manipulation, storage, performance and analysis strategies in a data warehouse environment.

TECHNICAL SKILLS:

Database: SQL Server, Oracle 7 - 11gR2, DB2 8.1-9.5

Platform: SSIS, SSAS, MicroStrategy, COGNOS, Informatica, DataStage, Discoverer

Environment: Windows Server, HP-UX, AIX

Proficient in: OLAP, OLTP, ETL, data modeling, replication, integration

Proficient in: T-SQL, PL/SQL, Shell Scripting (Bash and Korn)

Familiar with: Java, JavaScript, C, C++

PROFESSIONAL EXPERIENCE:

Sr. Business Intelligence Developer, Data Warehouse Architect

Confidential, Portland, OR

• Remodel develop existing processes to be cohesive to a new architectural strategy.
• Design, model and develop ETL data flows from multiple source systems through the data warehouse to various data marts.
• Ensure data integrity and continuity across multiple systems
• Work closely with third party vendors designing, developing and testing data exchanges.
• Work with end users to gather project requirements, define metrics, establish development roadmaps and make the appropriate design recommendations.
• Provide after-hours support for critical systems and data flows.
• Design and develop frameworks to enhance data warehouse performance and utilization.
• Ensure adherence to standards and best practices.
• Streamlined overall data warehouse design by consolidating multiple staging and warehouse databases into single database instances. This decreased the complexity of the environment by magnitudes, reduced the amount of data redundancy, reduced the number of break points, increased performance, increased stability and made the entire environment easier to support.
• Remodeled data flows from a primary data source to a third-party vendor to increase data stability. This was over a year-long effort with multiple interim releases.
• Remodeledfsf all dimension and fact ETL data flows and objects to adhere to revised architectural standards.
• Designed, modeled and implemented from scratch the MicroStrategy reporting data mart with over 400 database objects in the initial deployment.
• Converted unsupportable SSIS package logic to stored procedure calls within individual tasks. This greatly reduced the amount of time spent troubleshooting data quality issues and increased overall performance of the packages.
• Designed and developed a data publication framework for quickly and easily moving data across different databases and database servers.
• Introduced partitioning methodologies not previously used in the data warehouse environment. I also wrote a small suite of utility procedures that could be used within calling procedures to help facilitate partition functionality.
• Introduced the use of metadata to control process behaviors as opposed to business rules being imbedded or hard-coded within source code.
• SQL Server upgrade project. This affected all data warehouse, warehouse management, SAGE, COGNOS, Logility and MicroStrategy databases

Lead Data Warehouse Developer

Confidential

• Design, model and develop programming solutions for business needs in numerous OLAP and OLTP metadata driven environments.
• Worked closely with a wide variety of very large data warehouses using data warehousing paradigms such as dimension and fact tables, slowly changing dimensions, table partitioning, star and snowflake schemas, surrogate keys.
• Consolidated and integrated data from a wide variety of platforms and data sources including mainframe, AIX/UNIX servers, and other database platforms. Kept the flow of data consistent and as efficient as possible.
• Designed and developed Data warehouse (OLAP) packages, store procedure, configuration fields, tales, view and functions using Oracle 11g, PL/SQL, SQL Korn shell scripts on an AIX platform.
• Responsible for planning, measurement, coordination, implementation, and support of data acquisition and data propagation process, developing standards for internal and external data propagation.
• Performed query, data extraction, transformation and loading (ETL) processes.
• Developed and maintained multidimensional star schema and metadata based on business requirements, and to assist in continuous improvement of the data mart/data warehouse. Followed data quality and data validation practices of ensuring data integrity.
• Designed the Functional Requirements and Mapping Technical Specifications. Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the source data models to develop comprehensive Mapping Specs, Data cleansing, Data Conversion and Process Implementation.
• Developed mappings to ensure conformity with standards and functionality requirements.
• Worked extensively in the performance turning of the programs, ETL Procedures.
• Direct and coordinate with offshore development team to establish, monitor and maintain project objectives.
• Provide detailed reports and summarizations to the business analysts and management.
• Work with end users and business analysts to resolve data issues.
• Create data mappings and design data translations for data integration and the use between the end users and the data warehouse.

Sr. Software Engineer

Confidential, Greenville, SC

• Develop programming solutions for Confidential ’s Workbrain product.
• Project focus varied from UI development in JSP, Java class development and enhancement, database access layer optimization, core application data update XML scripting and product support.
• Implemented new Japanese language localization support.
• Implemented new single database creation process for deploying Oracle, DB2, and SQL Server databases. This new process provided greatly enhanced the automation of our database creation.
• Helped maintain schema layouts and data consistency in Oracle and DB2.
• Provided solutions to reduce application footprint and customer’s total cost of ownership.
• Certified mentor in company’s training program.