Applications

Financial, Health Care, Database Marketing, Pharmaceutical Sales and Marketing Information Systems, Campaign Management, Leads Distribution System, Marketing Automation, Sales Information Systems, Pharmaceutical, Clinical, Telecommunications, Insurance, Manufacturing, Semi-conductor

Application Software

SAS EBI 9.2, SAS 9- SAS Management Console, Scalable Performance Data Server SPDS 4.5 , Enterprise Guide, Data Integration Studio, Platform Scheduling LSF , SAS Information Map, Web Report Studio, SAS OLAP Studio, BASE SAS, SAS Macros, SAS/Access Oracle, Teradata, Informix, SQL, SQL Plus, PL/SQL, Microsoft Project Microsoft Office suite

Data Warehouse Models

Star Schema, Snowflakes, Federated, MDDB, ODS, OLAP and MOLAP designs

Business Intelligence/ Data Warehouse

SAS Enterprise Business Intelligence Suite

Database Administrator

Database Logical Design, Physical Implementation, SQL Loader, Export, Import, Oracle Installation

Databases

Oracle 8.x, 9.x, 10g, Teradata, Informix, DB2, SQL Server , ODBC

CASE Tools

Oracle Designer, BPWIN

Data Architect/Modeler

ERWIN, DB/Artisan

Project Management

Business Process Engineering Capability Maturity Model, Object Oriented Analysis and Design, Configuration Management SCM

Platforms Hardware

UNIX SUN Solaris and HP MVS IBM Windows NT, Win 2000, Win XP, AIX

Operating Systems Utilities

Quest Toad, SQL Lab , UNIX scripts C-shell, Bourne shell , LSF scheduler , Hummingbird Exceed , Reflection, Rational QA

SAS EBI Technical Architect /Platform Administrator

Confidential

Responsibilities: Technical Architect: End-to-End Design and Implementation of Consumer Risk Analytical Framework. Install and Configure SAS EBI 9.2 on 4/5 Tiers Metadata, Application, OLAP, Web, SPDS, And ETL Analytic , 3 Operating Systems AIX, LINUX, Windows and 5 Environments Prod, Dev, SIT, UAT and DR . Install and Configure Scalable Performance Data Server SPDS 4.5 . Install and Configure Platform Scheduling Software LSF 7.2 . Create ACLs to centrally manage User Administration and File Control Access. Design Metadata Security ACT and Custom Folder Structure for User Groups. Perform SAS Metadata Backup/Restore, Promotion, Replication and Migration. Perform SPDS Backup and Restore. Assist SAS users and DI Developers with application related problems. Design ETL Process to accommodate multiple tiers, and multiple custom/project respositories within each tier. Create/Manage/Update Multiple Custom Repositories in various Logical Partition LPARS . Define Servers and Data Libraries for Database Access to Data Sources Oracle, Teradata, SAS, and Informix, DB2, SQL/Server and ODBC to support ETL Development. Apply Hot Fixes, Maintenace Releases and renew Licenses. Support and Manage OLAP Servers and OLAP Application.

Tools/Environment: SAS EBI 9.2, 9.1.3 Data Integration Studio, SAS Management Console, Enterprise Guide, OLAP Studio, Web Report Studio, Information Delivery Portal, LSF, Tivoli, Unix AIX /Windows, Mid-Tier: WebSphere BOA , JBoss Wachovia

ETL Lead/Developer

Confidential

Responsibilities: Design process to integrate metadata and data sources from multiple systems and platforms. Design, Code and Implement Extraction, Transformation and Loading ETL code for Data Aggregation using SAS Data Integration Studio. Create job schedules using LSF. Setup SAS servers, database access, user group, security access using Management Console. Create user written codes and macros using Enterprise Guide. Create Stored Processes and User written Codes.

Tools/Environment: SAS DI Studio, Management Console, Enterprise Guide, LSF Unix AIX /Windows

Technical Lead/Data Architect

Confidential

Responsibilities: Primary consultant for implementing logical model to Physical Design which involves defining data attributes and domain, database sizing, creating Data Definition Language DDL and trigger scripts for database constraints implementation and verification. Interfaced with client Project Managers, Technical Leads, Application Developers and other Database Administrators to extract user requirements and formulate Data Warehouse architecture. Extensive hands-on experience in the analysis, design, development and implementation of Operational Data Stores ODS and Data Warehousing DW systems including STAR, SNOWFLAKE, Multi-Dimensional data base MDDB design. Designed the methodology for creating data stores/data marts, which entailed data scrubbing, transformation and grouping. Lead, planned and performed database migration on 6TB Oracle database e10000 - Sun . Designed application, development and production database environment to allow on-going development and enhancement on highly visible production system.

Tools/ Environment : Erwin, Oracle, TOAD, SAS, Visio, LSF Unix Solaris, SUN e10k, Windows

SAS9- Business Intelligence Software Installation and Configuration

Confidential

Responsibilities: SAS Installation and Configuration. Configured Servers, Database Access Oracle Banner , User group and Security Access using SAS Management Console. Designed, Code and Implement ETL code using ETL Studio. Create SAS Reports using Web Report Studio.

Tools/ Environment : SAS Software Navigator, SAS 9- BI, Xythos, Tomcat, Apache, IIS,Web Report Studio, EG, DI Studio, Information Map, Windows server 2005

Database Engineer

Confidential

Responsibilities: Integration of 6TB database with SAS Campaign Management Marketing Automation to support Automated Campaign Management and Leads distribution.

Tools/ Environment: SAS Base, SAS Marketing Automation, Oracle, Toad, LSF SUN Solaris e10k, Unix, Windows

AS Senior Consultant

Confidential

Responsibilities: Worked with Amgen's Technical Architect to develop an automated process to create a sales and marketing data repository for Amgen's Business Units. Involved in the design and implementation of these processes to extract, map, transform and load electronic data EDX submitted by various data vendors DDD data from IMS and NDC . Responsible for program design, programming, testing, implementation, and support of Automated Quality Assurance for Pharmaceutical Sales Information Data System to ensure data accuracy.

Tools/ Environment: SAS 8, Oracle, TOAD Unix/AIX

Data Modeler Database Engineer

Confidential

Responsibilities: Primary consultant for implementing logical model to Physical Design which involves defining data attributes and domain, database sizing, creating Data Definition Language DDL and trigger scripts for database constraints implementation and verification. Interfaced with client Project Managers, Technical Leads, Application Developers and other Database Administrators to extract user requirements and formulate Data Warehouse architecture. Extensive hands-on experience in the analysis, design, development and implementation of Operational Data Stores ODS and Data Warehousing DW systems including STAR, SNOWFLAKE, Multi-Dimensional data base MDDB design. Designed the methodology for creating data stores/data marts, which entailed data scrubbing, transformation and grouping. .

Tools: Erwin ALL Fusion, Erwin BPM, UML, Oracle, TOAD, LSF, SAS 8 - SUN e10K Solaris, Windows, DEC .

Data Modeler/Oracle DBA

Confidential

Developed data models logical and physical for WDC Manufacturing Process to support Oracle Application. OE, GL. AP, AR, etc. .

Tools: Erwin, Oracle Applications and Financials, Toad

Project Management

Confidential

Responsible for the on-time completion of all critical project tasks and the implementation of effective communication and training plans. Position required strong business assessment and project management, analytical, judgment and troubleshooting skills. Required exceptional oral and written communication skills, strong interpersonal skills and a strong technical background. Microsoft Project

Team Lead Advisory Analyst.

Confidential

Responsible for evaluation, testing, implementation, and software acquisition for a Change of Century Compliance Project for a Manufacturing Financial Company. Successfully led the evaluation of various software tools starting from the proof-of-concept stage to the final price negotiation stage. Led and implemented the process of evaluating various mainframe software tools. Designed Change of Century Project Plan. Designed Change of Century Test Plans Unit, Regression, Systems Tests . CA-IDMS, DB2, IBM MVS

Senior Healthcare Analyst/ Data Warehouse Developer

Confidential

Project involves gaining consensus among user departments on common data definitions and the identification of data sources for DOD's Health Care System. CHAMPUS, Tri-Care Tool: SAS, Unix-HP . Responsible for the on-time completion of all critical project tasks related to delivery of information crucial to making decisions on health care initiatives and the implementation of effective communication and training plans. Position requirements include strong business assessment and project management, analytical, judgment and troubleshooting skills, as well as in-depth knowledge of inpatient and ambulatory care, DRG and pharmaceutical data. SAS, Oracle, HP