SUMMARY:

• Over 20 years as Data Warehouse Manager/ Technical Architect, IT Manager/Director Banner ODS Adminstrator,ETL Architect, Sr. Data Architect, Oracle 11g DBA, Migrating Oracle Packages, Applying Oracle paches,Creating database Instances on MobaXterm Sr. SSIS, SSAS Developer, SqlServer 2005/2008 R2 developer, Creating RFC for change Management Processes, writing fairly complex sql to solve various data warehouse issues. Ability to create reliable sql test plan and other sqlserver implementation documents. Experienced Sqlserver R2 Administrator, SSIS, SSAS ETL Sr. Developer.Knowledge of IRB Procedure, BRIDG, CDISC, HL7, caBIG, and FDA Data reporting Standard and i2b2 application.
• Banner ODS Adminisrator/Oracle 11g DBA
• Certified Good Clinical Study Practice (Health Care and Pharmacology)
• Over Ten Years Managing IT Department including IT Infrastructure
• Fifteen years of software development experience in various applications
• Expert understanding of dimensional modeling, snowflakes, slowly changing dimensions, irregular dimensions, surrogate, compound and intelligent keys.
• Skilled Oracle Data Warehouse Builder Specialist, Loading Data from various Data Sources, Designing ETL Logic and Overall Data Warehouse Implementation Stages. Analyzing and implementing database systems and specifications
• Skilled Data Warehouse Manager, Dimension and Fact tables Modeling, Oracle Report, Data Modeling, Excel, PowerPoint, Eudora, Thunderbird and SPSS developer
• Very good knowledge of Informatica Power Center
• Skilled UNIX Shell, Korn, Sqlplus, Sqlloader, PHP, MySQL, Apache, HTML, Cobol, Perl and CGI Scripting developer
• Over Twenty years working with Window XP, 2000, Unix, Mac OS Operating Systems
• Skilled IT Project Manager and functional leader
• Lead a group ofTen Programmer/Analysts in converting mainframe legacy system to Oracle database Server applications
• Skilled Technical and Administrative Recruiter
• Lead a group of Six Programmer/Analysts in completing and implementing clinical research database applications
• Managed several IT projects successfully and completed several projects within budget

TECHNICAL SKILLS:

Platform: Banner ODS UI Oracle UNIX Solaris, PCs, MS Windows 95, Windows 2000, Windows 7, Mac OS Windows XP, MS DOS Mainframe Windows 8.

Technologies: Oracle,MobaXterm,SSIS,SSAS, BI, SqlServer Diagram, Oracle Data Warehouse Builder 10g - 11g, SQL*Loader Oracle 9i - 11g, Oracle Enterprise Management, Cognos 8 Pl/Sql, MS VisioSQL*Plus 11g, DataStage, ETL Data Mapping, MS Excel, Data Warehouse Design ETL Design, Data Warehouse Architecture, Data Modeling, Dimensional Modeling, MS Project, Dreamweaver, Sqlloader Control file, MS Access, Teradata,MySql, MS Word, Powerpoint, Tidal, HTML, MS SqlServer2005/2008, SPSS, Data Management, SOP Designer, Networks, Database design, Planview, Groupwise, ERP, TrackIT, PeopleSoft, LAN, WAN, Sybase, Sharepoint.

PROFESSIONAL EXPERIENCE:

Banner ODS Administrator/Oracle DBA

Confidential, Oklahoma City

Responsibilities:

• I am administering Banner ODS and Oracle databases, applying database patches, migrating oracle packages, cloning databases, and working on other database administration tasks, I monitor daily and nightly job loads, set up departments monthly and requested data freezes, trouble shoot all encounters during job runs. Trouble shoot pl/sql script issues and errors that may occur during ETL package processing. Reschedule and restart failed jobs and implement required upgrades of the data Oracle basses and Banner ODS.

Sr. Sqlserver Database Developer/Architect

Confidential

Responsibilities:

• I was responsible for designing the implementation of the department current data warehouse which extract and load all the company’s loans data, and servicers’ data. Responsible for the design of the dimensional data model and the ETL data mapping for the Finance and Human Resources segments of the data warehouse project.
• Provide the ETL architecture and data load strategies for the successful implementation of the project. Provide the SSIS and SSAS jobs development strategies and develop different stages of data for efficient and correct data load into the target data warehouse. Write the data mapping documents for the efficient data transformation from the source database and flat files into the staging of the data warehouse. Create request for change (RFC) documents for the change management process. Developed many jobs using sqlserver agent job scheduling steps. Developed several jobs using SSIS ETL tool, SqlServer 2005/2008 R2. Provide valuable report design input for BI group who design the various reports for the organization’s administrator’s daily decision making. Coordinate various group meetings to make sure that the project time line is followed accurately. Created SSIS Rollout, Rollback, Daily LoadsWeekly Loads, Reconcile, and weekend Load Packages for successful table data and flat file integration into the data warehouse. Created reliable Sql script test plan and designed several implementation documentations for successful data integration process.

Data Warehouse Manager/Architect

Confidential

Responsibilities:

• Managed the department data warehouse. Design the star schema and the ETL data mapping for the Finance and Human Resources segments of the data warehouse project. Provided the ETL architecture and data load strategies for the successful implementation of the project. Provided the SSIS jobs development strategies and develop different staging of the source data for efficient and correct data load into the target data warehouse. Wrote the data mapping document for the efficient data transformation from the source database into the target stage of the data warehouse. Created request for change (RFC) documents for the change management process.
• Developed many jobs using Tidal job scheduling software. Developed several jobs using SSIS ETL tool, SqlServer 2005/2008. Provide valuable report design input for BI group who designed the various reports for the hospital’s administrator’s daily decision making. Coordinated various group meetings to make sure that the project time line is followed accurately. Created SSIS Rollout, Rollback, Daily Loads, Weekly Loads, Reconcile, and weekend Load Packages for successful table data and flat file integration into the data warehouse. Created reliable sql test plan and designed several implementation documentations for successful data integration process.

Sr. Data Warehouse Developer/ Technical Architect

Confidential

Responsibilities:

• Designed dimensional data model and the ETL data mapping for the Finance and Human Resources segments of the data warehouse project. Provided the ETL architecture and data load strategies for the successful implementation of the project. Provided the IBM data stage jobs development strategies and developed different stages of data for efficient and correct data load into the target stage of the data warehouse. Wrote the data mapping documents for the efficient data transformation from the source database into the target stage of the data warehouse. Created request for change (RFC) documents for the change management process. Developed many jobs using Tidal job scheduling software. Developed several jobs using SSIS ETL tool, SqlServer 2005/2008. Provided valuable report design input for BI group who designed the various reports for the University’s administrator’s daily decision making.
• Coordinated various group meetings to make sure that the project time line is followed accurately. Created SSIS Rollout, Rollback, Daily Loads, Weekly Loads, Reconcile, and weekend Load Packages for successful tables’ integration into the data warehouse. Created reliable sql test plan and designed several implementation documentations for successful data integration process.

Clinical Research Data Warehouse Manager/Technical Architect

Confidential, Dallas

Responsibilities:

• Lead the data warehouse development group for over Two years and provided useful advice on the data warehouse/database development strategy to the entire Confidential group. Mapped several source table columns into Target and wrote effective control files for the sqlldr that loads the flat file data into the current data warehouse. Designed and created several external tables that hold the source data before loading into the data warehouse. Provided guidance for the source data extract scripts and written several extract scripts in Pl/Sql for the projects I worked on. Did in-depth data analysis for the projects I worked on, I also did detailed project requirement gathering from different levels of management and primary research investigators, converted the requirements into successful systems implementation. Created the SCD strategy, the CDC strategy to insure accurate and updated data load. Created the multiple Confidential t number integration strategy and successfully implemented my integration strategy.

IT Manager/Director (Hands-on)

Confidential

Responsibilities:

• I reported to the President/CEO of the organization. Managed and oversee the entire Corporate IT department. Contributed to the overall organization decision making process. Responsible for leading the daily operation of IT department. Developed long term strategies for the IT department that ware consistent with those of the organization. Ensured that appropriate information technology processes ware in place regarding contracts deliverables. I ensured information security and data confidentiality. Developed and managed IT personnel, facilities, projects and maintain budgets. Assisted in responding to request for proposals. Provided valuable input in the hiring process of some of the management and senior staff of the company. Provided regular IT advices to the President/CEO of the organization that helped her in making important decisions regarding the organization’s IT infrastructure.

Data Warehouse Project Lead

Confidential

Responsibilities:

• Designed the National Institute drug Addiction research Project Data Warehouse, Provided the structural Architecture and oversee the overall data Warehouse Implementation. Provided mentoring for the junior developers and data source analysis and extraction method for the successful data load. Provided ETL strategy, data quality and cleansing that helped to achieve accurate data load into the Data Warehouse. Worked with the data source group to make sure that SCD issues are handled correctly and accurate updated data are loaded in the data warehouse at all time
• Prepared and submitted project budget proposals for all the projects assigned to me. Lead the budget strategic group to come up with strategic plans for the projects.

Sr. Programmer/Analyst /Clinical Research Data Manager

Confidential

Responsibilities:

• Gathered project requirements and implemented software development life cycle from project specification to final implementation. Designed research database applications using dreamweaver, Java and Java Script HTML in Oracle DBMS.Wrote many PL/Sql scripts to check study defined medical research rules and derivations. Wrote several PL/Sql procedures and packages to check inconsistency in Clinical Investigators reported data. Designed and implemented clinical research data entry screens, analyzed and managed clinical data using SPSS.
• Wrote Several SOPs for new Studies and upgraded existing SOPs to reflect new study protocols.