Roles

• Senior Data Architect Analyst
• Senior Business Business Process Analyst
• Database Administrator
• Application System Developer
• Web Application Designer Developer
• Technical Team Lead

Methodologies

• Software Development Life Cycle SDLC , Agile Lean Development Methodology
• Unified Modeling Language UML , Technical and Business Use Cases, Pseudocode
• BPM, BPR, decision trees
• Pattern Analysis Ontology
• Reversed Business Process Re-Engineering, Process Improvement
• Data System Analysis and Re-Engineering
• OO methodology
• CRM System Design Development, 3-Tier Single System Architecture Middleware
• Procedure Package Optimization
• Microsoft Visual Studio 2005 IDE , Business Intelligence BI Suite

Tools

• SQL Server 2008, SSIS
• SQL Server 2005, SSIS, DTS to SSIS Migration, Server Optimization, Performance Optimization, Administration
• SQL Server 2000, DTS, SQL Server Analysis SSAS and Reporting Services SSRS , Job Scheduler, Form Interface Development, extensive Middleware application design, development and implementation
• ERStudio Embarcadero

Skills

• SQL, T-SQL, PL SQL
• SSIS Development
• TOAD, vi, shell scripts ksh and bash
• SAS
• Perl, PHP
• MS Office 2007/2010, MS Project, MS Visio, MS Access, MS Office
• Sharepoint

EMPLOYMENT

Sr. Data Warehouse Analyst Magellan

• Co-ordinate and lead efforts with members of various IT related teams for testing and data warehouse development related projects.
• Lead process development and automation of data integrity and testing tasks across multiple teams.
• Provide research and suggestions on data mining and meta data repository opportunities.
• Conduct research on best practices regarding exiting data warehouse and data mart system.

Data Architect, Sr. Enterprise DBA

Supported companywide enterprise system re-design project at UNOS. Responsibilities included conducting extensive system analysis, documentation and evaluation of such data systems and underlying processes, as well as the re-engineering of processes to make them more efficient, flexible, and consistent for future data systems at UNOS. This effort required extensive communication with end users, UNOS employees in various departments, as well as upper management and executives within an agile management environment.

• Graphic Design Documentation
• Architecture Design Documentation including Entity Relationship Diagrams ERDs , logical and physical models
• Unified Modeling Language Use Case Design, Behavior, Interaction Diagrams, Meta Modeling
• Process Flow, Dependency Diagrams
• Technical Process Design Documents
• High Level and Low Level Design Documents
• Business Requirements Documentation BRD , Functional Requirements Specifications FRS
• Primarily the following documentation methods are being utilized:
• Technologies: ERStudio, Sharepoint, SQL Server 2005/2008, SSIS, T-SQL, procedures.

ETL Developer, Sr. Markel Corporation

• Responsible for analyzing, designing, developing, and maintaining complete source to datawarehouse ETL processes. Deliver accurate and useful data to customers in a timely manner to support rapid reporting processes.
• Integrated data structures from various Oracle based source systems into a Microsoft environment.
• Advised on various data cleansing and data integrity strategies.
• Technologies: SQL Server 2005, Oracle 9i, SSIS, T-SQL, procedures.

Application Developer, Sr. Data Admin Analyst Sr

• Managed ETL processes integrating Teradata, Oracle, and SQL Server systems. Provided assistance in model integration and data quality services.
• Designed, implemented, and maintained ETL structures utilizing metadata driven strategies and models to support business processes, satisfying internal and external client requests. Responsible for working with diverse teams, establishing business requirements and deliverables.
• Accountable for development life-cycle aspects implementation, maintenance, data validation of internally developed reporting applications. Conducted SQL Server 2000 to 2005 conversion of applications systems.
• Provided technical knowledge and expertise for web .NET applications, ETL processes, and User Interface UI Design.
• Fluent with process modeling, functional design, coding methodologies, logical and physical database design, and modeling.
• Methodologies: UML, Business Process Management BPM , Business Process Re-Engineering BPR , decision trees, Pseudocode.
• Technologies: SQL Server 2000/2005, Proclarity, DTS, SSIS, .NET, T-SQL, procedures, command line functionality, SAS programming, server management.

Data Architect

• Lead the effort of re-engineering Membership ETL processes and automation across the company's client base.
• Managed company teams' in analysis, design, implementation, and testing of application as well as data architectures. Worked closely with the DBA lead to establish an access security schema for diverse ETL processes.
• Presented reports and comprehensive documentation in a professional and timely manner.
• Technologies : SQL Server 2000, T-SQL, ActiveX, VB, DTS packages, Job Scheduler.
• Employee of the Month March, 2004.

Consultant

• Managed technical aspects of discovery project concerning financial litigation 94 million Healthcare Industry .
• Technologies: Microsoft platform and applications, Perl.
• Supported design and development of CRM system for a global manufacturing company.
• Technologies: OO methodology, PHP, HTML, JavaScript, SQL, MySQL, Linux.
• Advised on modeling and managing database and data warehouse structures, targeting data mining efforts. Introduce data quality methodology.
• Technologies: SQL Server 2000, MySQL.

Data Architect

• Facilitated organization wide data migration project of financial and healthcare client data. Technologies and tools: AS/400, Oracle 9i, PeopleSoft 8, UNIX/AIX, Solaris.
• Responsible for developing migration strategies, managing project plans, implementing technical and procedural specifications and standards, conducting data mapping, cleansing, and profiling, developing and utilizing methodologies for evaluation and quality control of operational data, establishing data mining procedures for financial and customer services, fraud prevention, and general Business Intelligence BI .
• Managed Service Level Agreements SLA and vendor relationships.
• Fulfilled DBA functions, serving as the official company DBA backup. Worked closely with the network team to conducted performance tests and SAN backups.
• Tech Target SearchOracle.com Community Award Place alias Carmen Beitzer
• Topic: Merging datasets with NULL values March, 2004.

Consultant/Graduate Assistant

• Consultant - Information Systems Research Institute ISRI , Richmond, VA
• Consulted on enterprise solutions, business reengineering strategies, and workflow improvements for a global production and energy company.

Research/Teaching Assistant

• Conducted research on applied portal, siphoning and integration technologies.
• Designed and administrated synchronized database systems with thin client front end to optimize student enrollment management Oracle Access, PHP javascript .
• Extensive research on database, data warehousing, data mining technologies and methodologies as applied to large business environments.