SUMMARY:

• I have held positions with increasing responsibility in Information Technology and Management. I am highly motivated, with backgrounds in Confidential and MBA.
• I am a detail - oriented leader with 18 years of Information technology (IT) experience. My broad skill set includes Data Architecture, Requirements gathering, Software Design, Business Analysis, Application Data Analysis, Development, Data Mining, data migration, integration and Project management.

TECHNICAL SKILLS:

Database Applications/Tools: Oracle 11g/10g/9i/8i/8.0/7.3.X Enterprise/Standard Database/ RAC, Oracle Enterprise Manager (OEM), Oracle Manager Server (OMS), Oracle Data Guard, Oracle Performance Tuning Pack, Sybase., SQL*Plus, Oracle Forms, SQL*Loader, PL/SQL, Microsoft SQL Server 6.5/7/2000, Microsoft Access 2003/2000/97/2.0 , Visual Basic 5 & 6, FreeBalance Financial System, Crystal Report 10, IDEAS-Procurement Desktop, Erwin and Toad.

Web Applications/Servers: Dreamweaver, Flash, FrontPage, GoLive, HTML, CSS, ASP and Microsoft IIS.

Graphic Applications: Adobe PhotoShop, Image Ready, Paint Shop Pro and Image Styler.

Operation System Platforms: All versions of MS OS desktop and server, UNIX and IBM Mainframe.

Office Tools: All versions of Microsoft Office (Word, Excel, PowerPoint, Visio, and Project.

Other Programming Languages: Java, Basic, Pascal, FORTRAN 77, Assembly, LISP, C++ and JCL

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Architect

Responsibilities:

• Lead the database architecture effort and model business data requirements as part of integrated project teams (business process reengineering, app development, etc.)
• Develop logical and physical Data Models and Entity Relationship Diagrams using Erwin.
• Design and model both Logical and Physical layer databases using Erwin.
• Executing large-scale data migrations for critical enterprise systems to include use of authoritative sources, data conversion strategies and issue resolution processes.
• Migrating data from Oracle to MySQL in supporting efforts to refactor code to support a service oriented architecture.
• Perform MySQL/Oracle DBA functions in the Development and System Test environments, in coordination with developers.
• Perform requirement analysis and provide data mapping guidance to application and development teams
• Assist application development teams with interaction related to the transactional database, Operational Data Store.

Confidential, Washington, DC

Deputy project manager

Responsibilities:

• Organize, direct, and coordinate planning and implementation of program support activities.
• Interface with government personnel.
• Determine and monitor project costs.
• Ensure conformance and manage direct project personnel to ensure contract objectives and performance standard are met. Assist project manager to Identify, acquire, and use company resources to achieve project technical objectives

Confidential, Columbia, MD

Database / Project Manager

Responsibilities:

• Gather requirements from users, regularly interact and meet with 16 other release managers to plan and provide support to the development teams.
• Ensure clear and timely communications with the client, key stakeholders, and the contract teams.
• Facilitate daily communication between all parties developers and Confidential: Monitor interaction with Lines of Business ( Confidential 's) to ensure proper communication with respect is occurring and monitor and document issue conflicts and resolutions as they occur.
• Lead 15 Database Administrators (DBA) and developers for the Confidential project - Confidential .
• Direct, manage, monitor and control project work.
• Manage database administration and developments effort activities within scope and budget.
• Identify and manage risks to the DECC Program.
• Provide weekly status reports to the upper management using various metrics.
• Attend daily management meetings and provide status on key project activities.
• Design database architecture and plan the implementation in support of meeting customer goals and ensuring that schedules are met. Develop and implement standards and procedures to improve team efficiency and accuracy. Evaluate database processes and provide suggestions to senior management on necessary changes.
• Provide technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS. Function as a decision-making authority on database design decisions to ensure that application solutions exhibit appropriate levels of performance, security, scalability, maintainability, and reliability upon deployment. Provide work guidance and mentoring to less experienced personnel. Provide database related technical expertise to application development and global infrastructure efforts. Organize and motivate teams. Ensures communication and understanding of deadlines, assignments, and objectives. Prepare periodic reports regarding unit activities and goal attainment progress.
• Provide input to development of vision, specifies key performance requirements and define technical critical success factors. Provide estimates for required database activities to project and account teams.
• Review and perform complex analyses of DBMS products and features regarding their impact on database performance. Research hardware and software products, recommend solutions and implement approved products.
• Review database models with the DBAs and developers.
• Generate database scripts from database models and implement them in the databases.
• Ensure that product development issues are tracked, managed, and resolved.

Confidential, DC

Data / Project Manager

Responsibilities:

• Gather requirements from users and implement agile development projects for the organization.
• Direct, manage, monitor and control project work.
• I function as a liaison between business owners, stakeholders, development teams, managers, systems administrators, vendors and system-users. Manage scope, effort / cost, schedule, and quality, while continuously identifying and mitigating underlying risks. Collaborate with stakeholders to elicit and review requirements and design.
• Evaluate Client’s database architecture requirements and database administration strategies.
• Review Database models and make modifications as agreed with the developers, based upon requirements.
• Identify, assess and execute migration of the Client’s Oracle databases and portal environment to latest versions. Interact professionally with diverse groups, executives, managers, and subject matter experts. Present technical recommendations to various teams and management, carrying out a wide range of database administration services. Develop and implement policies, best practices and procedures to ensure the availability and confidentiality of NIFA’s mission critical databases. Create database upgrade plans, track milestones, provide status updates and ensure that requirements are understood executed according to the project plan. Collaborate with developers and subject matter experts to establish the technical vision and provide a strategic database direction for the organization.
• Lead the DBAs to provide technical help to developers and users. Perform regular and ad-hoc database maintenance and troubleshooting problems regarding the databases, applications and access to ensure the optimal performance of client’s key database applications; Design, develop and implement critical disaster recovery and data backup processes - recovery manager (RMAN) and exports; Administer access and security privileges for users; Maintain the Oracle Application Server; Provide leadership and oversight of work performed by junior database administrators.

Confidential, Mclean, VA

Lead Systems Engineer / DBA

Responsibilities:

• Was responsible for Administering and maintaining multiple Network Attached Storage (NAS) and Storage Area Network (SAN) and documenting end- user / systems setup guides. Setting up NAS to support distribution of incoming data feed files to all the nodes in the RAC. Develop scripts to handle moving the data feed files into the correct location to support OWB.
• Configured the NAS/SAN nfs files to mount automatically on RAC nodes upon reboot. Document setup/operation/risks in the SAM and IP (install procedures).
• Setting up Network Attached Storage (NAS) Sun StorageTek 5220 Storage directories to support distribution of incoming data-feeds to all the nodes in the Oracle RAC systems. This includes Server set up, Email Notifications, language, Hot-Spare drive, File Volumes, Security, Users, Host and HostGroups set up, Exports and Checkpoints.
• Set up Storage Area Network (SAN) Sun StorageTek 6140 Storage directories to support Network backups and network storage for the Oracle RAC systems.
• These included Server set up, Notification for Fault Management, language, Hot-Spare drive, Created Storage Pools, Security, Users, created Host and Host Groups set up, Created Initiators to Assign to Hosts and map volumes.
• Installed VMWare Version 5.0.0 build 13124 on Windows XP professional. I downloaded and installed the pre-built Oracle 10gR2 RAC on Linux Red Hat (RHEL ) environment. This RAC virtual system has two nodes each running an instance of the database communicating over a private network (interconnect) and using virtual IP addresses to communicate with the clients.

Confidential, Fairfax, VA

ETL Data Architect

Responsibilities:

• Provided service to Confidential eGov initiative. Responsible for Data Analysis, ETL design and data model creation.
• Led the development of the Extraction data load (ETL) design and implementation development phases. Used both the Informatica PowerCenter Designer and Workflow Manager.
• Worked closely with users and technical team to ensure technical solutions are met and any gaps are identified in early stages of development.
• Developed and documented data Mappings/Transformations and sessions.
• Involved in performance tuning both ETL Informatica mappings and SQL statements using explain plan.
• Designed and developed the ETL processes for loading data into dimension tables, fact Tables, handling the slowly changing dimension support.
• Formulated various mappings using various active and passive transformations, mapplets and reusable transformations.
• Was involved with Code change migration.

Confidential, Columbia, MD

Senior Consultant/ ETL Data Architect

Responsibilities:

• Provided independent Extraction Transformation Load (ETL) subject matter expertise to Confidential on a contract basis.
• Responsible for architecting, developing, and implementing solutions to receive, cleanse, transform data into an enterprise data warehouse. Defined the ETL development strategy, developed an ETL test strategy, and designed the ETL unit integration and system test plans. Additionally developed the source to target mappings using Infomatica version 7.1.3.

Confidential, Alexandria, VA

Database Specialist

Responsibilities:

• Supported the Confidential Asset Servicing Technology Enhancement Project.
• Provided Database analysis and data modeling subject matter expertise to Confidential .

Confidential, Silver Spring, MD

Data warehouse Lead and Database Administrator

Responsibilities:

• As a team lead, gathered user requirements, created work plans (WBS), and monitored multiple projects. Mentored other DBAs, analysts and developers working under me, reported monthly status and identified problems associated with the Data Warehouse and brought them to upper management’s attention.
• As a Database Administrator (DBA), performed various duties such as, Integrate the organization’s IT architectural components to support its mission-related strategies and goals, Data Architecture, Data Modeling, Data model Reverse Engineering, Data Administration, meta-data standardization, Databases creation, database administration, Space extensions, capacity planning, database performance monitoring, tuning, optimization and indexing. Backed up and restored data for an Oracle staging database. Performed annual data archives and migrations, data distribution, data conversion and integration. Created Data Warehouse architecture and ETL using Informatica and data marts development. Extracted data from operational data sources as needed. Ensured that both production and Loading Databases were available 24x7 hours with minimum downtime. Ensured that the Sybase software was kept up to date. Met the Data Warehouse reporting needs, and performed fault isolation on query problems which users encountered.
• Provided technical expertise and direction in designing, developing, deploying, monitoring, supporting and administering the Data Warehouse needs. Identified the end-user pains and points of need. For example the end-users sometimes ran queries which accessed multiple tables in pharmacy database for hours without getting the appropriate results. Met with customers, stakeholders, and end-users and determined the need for data marts to simplify datasets retrieval. With my leadership we elicited requirements using Joint application Design (JAD) sessions. Documented analysis and requirements. Designed pharmacy department logical and physical data models. Reverse engineered the pharmacy database and designed the data marts. Using data marts, the end-users experienced better query performance with minimal time usage.
• Performed monthly loads for10 databases which contained over 900 tables occupying over 600 GB of disk space. Dropped old tables and prepared new tables for monthly data loads. Executed over 100 SQL scripts for the Data Warehouse databases. Fixed loading errors related to data quality, failed indexes and database space issues. Created views for eleven databases and granted the necessary permissions to users. Implemented user requested schema changes and built new data marts models using Erwin.
• On the Health Connect project for Lab Misys Data Extract, did analysis, created ETL mappings. Wrote SQL and shell script code, built interfaces and delivered data extracts. Analyzed the impact of the Health Connect project on the Data Warehouse, as well as the downstream impact.
• Led the migration of the legacy Sybase Membership system to a new system called Common Membership (CM). Implemented the full life cycle of the CM migration from the DB2 data source to the targeted databases in Sybase and Oracle. My responsibilities included JAD sessions in which he worked closely with user communities to define requirements, project work plan, system analysis and documentation, data modeling, connectivity issues associated with DB2 connect and ODBC for Informatica ETL tool which were used for mappings development, system interfaces and architecture design.
• Designed the initial logical and physical data model for Confidential, a membership claims system. Led the team to upgrade the Confidential claims system in Sybase and ODS Oracle to synchronize with the upgraded Oracle Human Services Department ( Confidential ) Online Transaction Processing (OLTP) system. Responsible for Confidential project assessment, analysis, design, development, testing, documentation and implementation. Reverse engineered the Sybase model to obtain current Data Warehouse specifications to compare with the Confidential new version upgrade specifications. Reviewed the upgrade impact on the existing Informatica pathway mappings.
• Designed, developed and implemented the ETL mappings to convert legacy C programs into Informatica mappings. Wrote SQL and shell scripts to automate the load process and the file archiving process.