PROFILE

• Certified Business Intelligence Professional by TDWI Certified Oracle Professional by Oracle Certified Teradata Professional
• Seasoned data warehouse expert with hand-on experience of full life cycle of data warehouse development for large and complex data processing. Experienced in implementation of EDW, FDW, and business performance management ScoreCard and DashBoard .
• Repeatedly demonstrates the ability to apply technical skills to achieve the tactical and strategic business solutions, and also leverages and interpersonal skills to motivate, direct and inspire project teams. Shares vision and big picture views with senior management and technical and business sponsors.
• For over ten years, career focus has been centered on Business Intelligence and Data Warehouse design, development and deployment. Experienced of saving DW/BI projects from failure, starting and succeeding the delivery of small data marts to big complex data warehouse.

PROFESSIONAL EXPERIENCE

Confidential

Application Developer

• Led in building and operating operation data store, and multiple data marts to support the operational, tactical and analytical reporting services in sales, and bank product implementation service, liquidity and other financial services.
• Led in Informatica Power Center ETL platform upgrade from 7.4 to 8.6.1 and Oracle data warehouse server re-platform. Set up high available and disaster recovery proven technical architecture that supports multiple team usage, easy maintenance, and optimal performance.
• Built strong partnership with business subject matter experts and business analyst teams to meet and exceed business expectation.
• Interfaced with multiple software and hardware vendors including Informatica and Oracle on upgrading and new purchasing. Conducted many POC projects to help program management spend budget wisely.

Technical Environment: Oracle 10g, Business Object, Informatica 8.6, Control-M, PVCS, Shell, Perl, PL/SQL

Confidential

Senior Technical Consultant

• Architected and developed ETL codes to support the company sales and marketing data warehouse.

Technical Environment: Oracle 10g, DB2, Cognos, Informatica 8.6, AutoSys, Shell, Perl, PL/SQL

Confidential

ETL development lead

• Led and mentored a four developer team as part of a project team in an efforts of building sales and marketing DW/BI delivery.
• Led in the ETL design and coding for product domain and customer domain master data management. Applied the template based fast development method in the Informatica development and exceed tight time line of delivery.
• The technology environment: Oracle 10g Data Warehouse, Informatica PowerCenter 7, PL/SQL, Shell Scripting

Confidential

ETL Architect

• Designed and implemented the sound ETL architecture to allow processing batch loading of multiple submissions to meet and exceed the client's expectation.
• Provided additional expertise and advice on application design, technical architecture and data warehousing physical design to help the project team meet the deadline of delivery.
• The project addressed the clients' challenges of integrating hundreds of sources of datasets into a centralized repository, hospital data factory.
• The technology environment: Oracle 10g Data Warehouse, Informatica PowerCenter 6.2, ActiveBatch, PERL/DBI, DataStage TX, SUN Solaris, CVS

Confidential

Data Warehouse Architect

• Performed a technical assessment of the overall data warehouse architecture, ETL architecture, and practices of the development enterprise data warehouse at Novartis. Assessment identified key architectural issues and practice problems within the existing data warehouse and data integration components.
• Conducted a presentation demonstrating the best practices of Oracle data warehousing, Informatica PowerCenter.
• The technology environment: Informatica PowerCenter 6.2, Oracle 9i, and AIX

Confidential

ETL Specialist, Teradata Developer

• Performed ETL development using Informatica and Teradata utilities, delivering solutions for archiving and purging terabytes of patient financial data in HCA enterprise data warehouse. Used a number of different methods to benchmark ETL processes and specified the best design for client's requirements of easy maintenance and minimal operation time for processing extremely high data volumes.
• Contributed to the project by applying his strengths in database technology and Informatica. Intensively involved with ETL development, BTEQ programming, and shell scripting.
• The technology environment: NCR Teradata, BTEQ, MLOAD and SQL Assistant, Informatica PowerCenter 6.2, AIX, and shell scripting

The Employment Solution, Raleigh, NC 1/2003 5/2004

Confidential

Senior DWA/DBA

• Was a key member of a specialized team of consultants from the Federal Division of Northrop Grumman IT. This team provided BI/DW solutions to US Postal Service.
• Provided technical leadership in the areas including database administration, data integration development, defining ETL strategies, database programming and shell scripting standards, and enforcing strategies and standards.
• Reviewed the postal service EDW data models which consisted of thousands of tables and views. Audited the quality and availability of subject areas and provided database administration services to the ETL development and MicroStrategy reporting teams. In addition, performed performance tuning on both ETL processes and databases to improve the speed of data transformation and loading.
• Contributed to system design by developing the functional ETL transformation specifications. In this role, worked with business users, business analyst, and subject matter experts. During the implementation phase, developed ETL mappings, sessions, and associated shell, perl, and PL/SQL scripts. Conducted unit/system testing, data QA, managed version control and change management.
• Presented 3rd Normal Form and Dimensional Modeling to educate the peer consultants and clients.

Technical Environment: Oracle 8i/9i, Teradata, Solaris 8, MicroStrategy, Informatica Power Center 5.1, ERwin 4.1, Toad 7.2, OEM 9.0.1

Confidential

DBA, Data Warehouse Developer, Architect

• Interacted with vendors and assessed the data warehouse tools and platforms that includes Ab Initio, Data Satge, Oracle Data Warehouse Builder and Informatica Power Center.
• Conducted logical and physical design for the data warehouse applying Ralph Kimball's dimensional modeling techniques and Oracle data warehouse methodology and was responsible for the overall architecture for data warehouse, ETL platform, and metadata management.
• Also intensively involved in ETL development, including coding mappings and sessions, associated shell scripts, PL/SQL programs to load and populate data marts from flat file, and loading XML and relational data sources.