We provide IT Staff Augmentation Services!

System/data Architect, Engineer Resume

5.00/5 (Submit Your Rating)

Plymouth, MN

SUMMARY

  • Information systems professional with over 19 years of corporate IS experience. Have design and analysis experience in sales/product reporting, merchandising, financial, insurance, manufacturing process, government, law enforcement, health care/EDI, customer service applications, OLTP, CRM, ETL, MDM, CDI, PIM, data warehousing on VLDB, OLAP, data mining, clustering configuration management and others.
  • Possess strong communication, research and technical skills, which allow me to translate concepts into practical and timely solutions.

TECHNICAL SKILLS

  • Data Architect
  • Enterprise DW Architect
  • BI Architect
  • SOA Architect
  • OLAP
  • MDX
  • SQL
  • ETL Architect
  • MDM Architect
  • Data quality assurance
  • Data Modeling
  • DBA (Oracle RAC, Exadata, MS SQL, MS PDW
  • Sybase ASE, Sybase IQ, Teradata, Informix
  • DB2, PostgreSQL, Progress)
  • GoldenGate replication. Oracle Data Guard..
  • NoSQL (HBase, Cassandra, MongoDB, CouchBase)
  • VLDB (Very large databases) deployment Architect
  • Database Developer
  • Application architect
  • Application Developer
  • ERP (financials, manufacturing).
  • Middle tier and messaging developer (C/C++, Java)
  • Security
  • Compliance
  • Change Control
  • Hadoop
  • HPC (High Performance Computing)
  • Simulation software support.

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MN

System/Data Architect, Engineer

Responsibilities:

  • Implementing data management and MDM (PIM), SDM (Simulation data management), data governance practices within R&D departments.
  • Analyzing data sources for various application data. Analyzing pre and post processing data modeling data structures, metadata design.
  • Gathering and documenting a functional and technical requirement for computational and simulation modeling deployment on HPC platform: hardware, storage configurations, modeling network topologies. Working with HPC vendors (IBM, HP, Dell, SGI and others) for turnkey solutions options. Assessing feasibility of deployment of cluster file and parallel file systems on Linux. (Lustre, GPFS), cluster workload management software, job schedules and etc. System configuration (CPU, cores, GPU, memory storage, network, infiniband, etc.)
  • Supporting (installation, configuration, license management) modeling and simulation software Abaqus, Ansys, SolidWorks, Matlab and others.
  • Scripting with Perl, Python, and Linux Shell scripts. Database design with PostgreSQL for various internal web and client - server applications. Large data set analysis with Python.
  • Microsoft CRM, MDS 2012(Master Data Services) as PIM (Product MDM).
  • MS SSIS 2012 as ETL platform.
  • MS SSAS, SSRS 2012 as reporting and analytics platform.

Confidential

Enterprise Data Architect, MDM Architect, ETL designer

Responsibilities:

  • Lead data architect, head of data modeling team. Responsible of architecture and design of EDW, Corporate BI solution, MDM solution. Enterprise ETL architecture design and implementation with data lake concept.
  • Erwin 9.5 workgroup edition with model mart.
  • SAP Customer Master, SAP Org, SAP Product, Salesforce integration design.
  • Working with MS CRM, BI Stack (MS SQl 2014, SSIS, SSSRS, SSAS, Tabular, MDS, Informatica Customer 360 MDM Cloud, Profisee MDM).
  • Designing multitenant databases on Microsoft Azure SQL.
  • Migration of in-house MS SQL databases into Microsoft Azure SQL databases. (Cloud multitenant database)
  • Evaluation of EBX5 for multi-domain MDM solution.
  • Configuring an existing applications to work with Azure SQL.

Confidential

Business Process owner

Responsibilities:

  • Responsible for multi-domain MDM implementation, Data Governance program organization and management.
  • Design and implement multi-domain (Party, Product, Finance, Location, Asset, Contract) solution with global presence with Stibio Systems STEP for multi-domain MDM.
  • Installation, configuration and extending Microsoft Dynamics 2013.

Confidential

Enterprise Data Architect

Responsibilities:

  • Consulting in area of Enterprise data management and modeling in Agile development environment.
  • Helping to define a new a governance processes and practices for Enterprise data management, modeling and deployment in Agile development environment.
  • Designing data structures for Java objects data access and persistent layers (Hibernate, Sprint Data and others).

Confidential

MDM architect, Data Architect

Environment: Discrete manufacturing, large SAP implementation.

Responsibilities:

  • Analyzing product and product publication data sources (SAP manufacturing, PTC-PDMLink, Windchill)
  • Requirements gathering, data analysis, MDM data modeling with ER/Studio 9.6 (conceptual, logical, physical)
  • Designing a data governance policy and procedures.
  • MDM (PIM (Product Master), CDI (Customer Master)) architecture design and implementation.
  • Design and implementation of metadata repository.
  • Installation and configuration and administration MDS (Master Data Service) 2012
  • Implementing Product, Customer, and Account (Finance) MDM domains in MDS 2012.
  • Integration DAM (Digital Asset Management) with product MDM.
  • Designing data movement (ETL), CRM, architecture and mapping documents. Implemented with SSIS
  • Integration SaleForce.com, Force.com customer information with corporate MDM solution.
  • Implementation of MS 2012 DQS (Data Quality Service)
  • MS Sql 2012 Service (message) Broker implementation.
  • Active team member of Enterprise SOA implementation that responsible for designing data services and access layers.
  • Developing Enterprise taxonomies, implementing taxonomies in SharePoint 2013.
  • Managing SharePoint term store, term sets and metadata services.
  • Designing and implementing security procedures, process and standards.
  • Design new web applications with NoSql platform (CouchBase, MongoDB)

Confidential, Richfield, MN

Enterprise Data Architect, BI Architect

Responsibilities:

  • ODS, Integration layer, Data Warehouse data modeling and schema design. PowerDesigner 16.5 is a modeling tool. PowerDesigner administrator.
  • Enterprise Architecture with TOGAF framework.
  • 3rd Normal form, Start schema (dimensional) design and deployment in PDW (Microsoft Parallel Data Warehouse appliance).
  • MDM (CDM) modeling and design, deployment with MDS 2012.
  • PIM, Location MDM, CRM, Assets MDM implementation with IBM InfoSphere.
  • Migration from Teradata to PDW.
  • Application and PDW DBA role. ETL design and development with SSIS 2012 and Informatica.9.1
  • MDS (Master data services) 2012 design and development.
  • Data governance team member.
  • Migration, re-design and new design and development BI architecture with MS BI Stack 2012 (SSIS, SSRS, SSAS).
  • Deployment SSRS power view and excel services through SharePoint Server 2013.
  • Planning and implementing scale-out SSRS deployment. (NLB and cluster)
  • Design and development MS SSAS tabular and multidimensional models (Cubes).
  • Logical and Physical modeling clickstream application for Hadoop with PDW implementation. Working with Amazon RedShift database (Big Data). Creating migration plan from AWS Redshift to PDW (Hadoop).
  • Migration of some Teradata databases into HADOOP Data Lake and AWS Redshift.
  • Designing cloud ETL.
  • Deployment and administration of Cassandra, HBase and Mongdb for real time data ingestion. Evaluating various application with NoSQL platforms. Python, PHP, Perl scripting for internal web applications utilizing Google MAP Confidential, PosgtGIS database.

Confidential, Bloomington, MN

Enterprise Data Architect

Responsibilities:

  • Application DBA (Oracle 11.2, MS SQL 2008 R2)
  • Logical and Physical data modeler with PowerDesigner 15.1
  • Main role is to create a logical model for “Medical Benefit product” MDM application (Aka: PIM) that will function as a master data for downstream applications (claims, operations, regulatory, DW, BI, reporting system).
  • Contribution for creation of data governance procedures and policies.
  • Physical database design and deployment on Oracle 11.2 and MS SQL 2008R2
  • Working with .NET team to help UI application design and deployment with ASP .Net MVC framework.

Confidential, Minneapolis, MN

Data architect, Teradata application DBA

Responsibilities:

  • Semantic layer architect.
  • BI Architect and developer.
  • Migration DW from DB2 into Teradata 13.10.
  • Migration DW application from DB2 into Teradata 13.10:
  • Logical reverse engineer existing physical DW.
  • Add a new functionality.
  • Create a new Teradata specific physical data models.
  • New application and functionality design:
  • Worked with Confidential SME in area of brick mortar store inventory management, return, back room inventory, sales floor inventory, logistics to design a logical data models.
  • Created a physical data models in Erwin 7.3 for Teradata 13.10 database as a Confidential platform.
  • Worked with off shore team to design and implement ETL objects, deployment scripts and test scripts.
  • Participated in design and development performance layer of the DW and Bi applications.
  • Designing semantic layer and performance layer that being consumed by Microstrategy.
  • Working with Microstrategy and related team member to improve BI aspect of the reporting tools including Microstrategy.
  • Involved with performance tuning effort.
  • Oversaw all the deployment stages off the application from development, test and production environments.

Confidential

Enterprise Data Architect, Data Warehouse Architect

Responsibilities:

  • Design Enterprise data model, data ware house data model with Erwin 8.1:
  • Gather requirement and analyze existing data marts.
  • Create subject area conceptual models, DW logical models.
  • Participate and recommend naming standards, model management standards.
  • Design and deploy DW and mart schemas onto Oracle 11.1
  • Create a physical data models. (Indexes, partitions and other schema details maintained in the Erwin model).
  • Generate DDL(s) and create deployment scripts.
  • Work with operation DBA(s) to deploy application and monitor performance.
  • Design and deploy custom ETL scripts.
  • Creating mapping documents. Creating custom scripts in PLSQL and shell scripts
  • Data sources; Epic, Clarity external providers, HL7 (v2) messages, EMR information design.
  • Interfacing with Siebel CRM (Oracle) system for data extraction.

Confidential

Data, MDM Architect, Database Engineer

Responsibilities:

  • Data Architect, Data Analyst, BI Architect, Deployment Architect. SQL Server 2008 R2 (2005 and 200) DBA and developer, Oracle DBA 10g-11g R2, Oracle developer PL/SQL, Oracle forms, Oracle report.
  • SSRS, SSIS, SSAS designer and developer.
  • Standard SSRS deployment, administration of SSRS and related metadata.
  • Deployment of SSRS and MS Sql Server into VMware virtual servers.
  • MS Sql, SSAS, SSRS administration (deploy, monitor, security configuration, performance management)
  • Vivisimo’s Velocity platform administrator and developer. ERP (Ross, iRen) package developer.
  • Technical lead for DW design and implementation effort.
  • Enterprise data modeling,
  • Process Modeling.
  • Design; develop reporting system from Process Manufacturing, AR, AP, HR and other sources.
  • Search Engine implementation using Velocity platform. Designing enterprise search application.
  • XML, XPATH, XSL, XLST development.
  • Oracle 11gR2 installation on Windows 2008.
  • Migration applications from Oracle 10g to Oracle 11gR2.
  • Designing messaging system with MS SQL Service Broker 2008 R2
  • MDM architecting with PIM (Product Information Management).
  • Creating MDM deployment roadmap.
  • Modeling data structures for MDM deployment.
  • Architect and development of CRM system with Microsoft Dynamics CRM 2011
  • Deploying reference data and building data governance strategies around that.
  • Creating Data HUB for analytical, operational and collaborative use.
  • Product catalog web application design with MongoDB.
  • Creating a custom extension for Pivotal CRM, creating an integrated solutions for customer and marketing information.

Confidential, Minneapolis, MN

Data Architect, Data Analyst, BI Architect

Responsibilities:

  • Technical lead for DW design and migration project.
  • Design, develop and deploy Enterprise Data Warehouse.
  • Implement Corporate Card product master database.
  • Design, develop and deploy ETL architecture for DW loading from TSYS (Total System) and other sources.
  • Working with AML (Anti-Money Laundering) system Actimize software.
  • Dimensional Database modeling with Erwin 7.3
  • ETL design with SSIS 2008 R2.
  • OLAP design with SSAS 2008 R2
  • Design Data Warehouse. Migrate/deploy from MS SQL 2000 to MS SQL 2008 R2 64 Bit.
  • Data Sources: Mainframe DB2, MS SQL 2008
  • Physical deployment with SQL server partitioning.
  • Storage design recommendation for best practice DW deployment.
  • Working with Oracle Exadata X2 platform for Syncada project. Large DW and OLTP application deployment,. Architecting and designing a custom ETL/ELT data load solution for Exadata load.

Confidential, Golden Valley, MN

System Architect, Data Architect, BI Architect

Responsibilities:

  • Platform Migration from UNIX to MS Windows 2008.
  • Migrating Oracle 10G databases to MS SQL Server 2008.
  • Migrating Application with Oracle backend to Window platform with MS SQL 2008 backend.
  • Managing ERP manufacturing system, administration, development and support.
  • Designing Efficacy test application for microbiology test department and lab.
  • Designing Efficacy test data mart. Deploying BI Application from departmental data mart and with Confidential software.
  • Enterprise data modeling, physical database design and deployment. Data quality assurance process design and implementation, ETL design and development with SSIS 2008. OLAP Cube development with SSAS 2008.
  • Oracle and MS SQL DBA, Oracle Forms 10g, Reports 10g
  • Oracle 10g Windows DBA, MS SQL: 2000/2005/2008 DBA
  • Installation Liferay Portal 6.1 and administration.
  • Migrating Linux based PostgreSQL database and application into Oracle 10g.
  • Migration Sybase database and applications to Oracle 10g.

Confidential

Data/System Architect, Team Lead

Responsibilities:

  • Installing Oracle Fusion Middleware. WebLogic server deployment. Oracle Identify management deployment. Installation Oracle database 11g R2 on Linux. Migration databases from 10g to 11gR2,
  • Deployment oracle forms 10Gg onto Forms 11g.
  • Deploying Oracle SOA suite and administration.
  • Install and deploy OBIEE 11 on Linux.
  • Create a reporting and analytical application with OBIEE and BI Publisher.
  • Linux shell scripting, Perl, Python 2.7 scripting.
  • Installation Oracle RAC 11gR2 on two node cluster. ASM storage deployment. Installation Oracle Grid Control and deployment of grid control agents on clustered and non-clustered nodes. DBA tasks.
  • Installation and setup ODI (Oracle Data Integration).
  • MDM (Master Data Management) project technical leader and architect. Designing and implementing data governance processes.
  • Enterprise Data Modeling with Oracle designer, Oracle SQL Data Modeler (new oracle modeling product).
  • Migration Oracle Designer 10 model object into Oracle Data Modeler 2.0.
  • Enterprise data warehousing, ODS design. Working with Fiserv source systems.

Confidential

Data Architect, Lead Application DBA

Responsibilities:

  • Enterprise Data modeling (Conceptual, Logical, Physical) with Power Designer 15.
  • Model administration, model quality, standards control procedure creations and maintenance.
  • Install Power Designer 15 with repository. Migration of existing models from Power Designer 12 to 15. Set up repository version control and user groups in PowerDesigner 15
  • Domain modeling for deployment on Oracle 10g /11g and Sybase Adaptive Server 15.
  • Oracle ERP Application DBA, MS SQL Server and Sybase Adaptive Server 12, 15.
  • Migration Oracle designer into Sybase PowerDesigner 15
  • Migration Sybase ASE 15 to Oracle 11G (database and applications)

Confidential

Data/System Architect, Team Lead

Responsibilities:

  • Data Architect. (Oracle Designer, PowerDesigner, Conceptual, Logical, Physical Modeling)
  • Architecting database and application security framework. (Masking, Encryption, Enterprise role deployment)
  • DBA Oracle 10G, 11G. Migration from 10g to 11g. Deployment of RAC, ASM. DBA (RMAN, Performance Tuning).
  • Oracle portal developer and admin.
  • Java developer: J2EE, SOA, Integration.
  • Oracle Discoverer developer and admin.
  • Oracle Application Server 10g Admin and developer.
  • Oracle Forms & Reports 10g developer and admin. Form generation with Oracle Designer.
  • Oracle Collaboration Suite 10g Admin, developer.
  • Oracle 9i, 10g, 11 developers.
  • DW/BI Architect.
  • Project Lead.
  • Linux administration.
  • Storage Architect (SAN, ISCSI)
  • Installing VMware and consolidating servers.
  • .Net design with C# and Share Point 2007.
  • Design Analytical and Reporting system with MS SQL 2008 BI technology. (SSIS, SSAS, SSRS)
  • Design and deploy MS BI stack, administration of MS Sql, SSAS, SSRS.
  • Ongoing, migrating reporting system from Oracle Discoverer, Oracle Reports 10g. Currently in Prototyping stage.

Confidential

Data Architect/Data warehouse Architect

Responsibilities:

  • Data architect.
  • Integration architect.
  • Lead of data warehousing, application integration, CDI, MDM initiatives.
  • E-Commerce project lead, WCS (WebSphere Commerce Suite), Store Fronts, Customer.
  • Customer data integration with E-Commerce data (channel sale).
  • Customer data de-duplication, matching, maintaining reference data.
  • MS SQL 2000/2005 DBA. Oracle DBA
  • Migration Sybase Anywhere 9 to 10.
  • Migration PowerBuilder 8 to 11.
  • Application development with PowerBuilder 11.
  • Data Modeling with Power Designer 12.
  • Designing OLAP cube on MS Analysis Services (SSAS 2005).
  • Deploying ETL with SSIS 2005.
  • Deployment of ProClarity Analytical Server 6.3 and ProClarity Desktop 6.3.

Confidential

Database Consultant

Responsibilities:

  • Sybase DBA/AIX Administrator.
  • Migration Sybase database and AIX application from version 4.3 to 5.1
  • Migration from 32 bit to 64 environments.
  • Performance tuning of application and OS.
  • C/C++ application development with Sybase backend.

Confidential, Minnetonka, MN

DW/BI Architect

Responsibilities:

  • DW/BI project technical lead.
  • Migration DTS packages to SSIS 2005.
  • Migrating OLAP cubes to 2005
  • Migration MS SQL 200 databases to MS SQL 2005 (64-bit platform).
  • Architecting and designing ETL processes.
  • Database storage analyst for DW.
  • Database centric custom .Net application with C#

Confidential, Maple Grove, MN

System / Data Architect

Responsibilities:

  • Applications, shell scripts, C/C++ code Migration from Sun Solaris 9 to Linux Read Hat 3 (Intel)
  • Database application development with MFC and Sybase backend.
  • Migration Sybase Adaptive Server 12.5 from Sun Solaris into Linux (Intel) platform
  • On-line (hot) Migration Sybase Replication Server from Sun Solaris into Linux.
  • Sybase database and replication administrator.
  • Architecting and designing ETL processes.
  • Architecting distributed transaction management system.

Confidential, Eden Prairie, MN

Data Warehouse / ETL architect

Responsibilities:

  • Designing real time Data Warehouse/ BI.
  • MS OLAP developer. Cubes/Dimensions. MDX development.
  • Migration MS SQL 2000 database to MS SQL 2005.
  • MS SQL Server DBA.
  • Migration/ Design MS Analysis Server to MS Analysis Server 2005.
  • Project Technical lead.
  • Physical database deployment, storage architect.
  • Equipment repair management system design.

Confidential, Minneapolis, MN

Lead Oracle DBA

Responsibilities:

  • Financial Trading floor support. Fast-pace application development with PowerBuilder, C, Perl and others.
  • Support FIX network providers: Bloomberg and others for trading transaction and other activities.
  • MS SQL Server support DBA.
  • Sybase Adaptive Server 11.5/12 DBA/developer.
  • MS Report Service Admin.
  • ETL development.
  • PowerBuilder developer. Migration from PB 6.5 to 10. Migration Sybase ASE 11.9.2 to ASE 12.5.2 on Sun Solaris.
  • Sybase stored procedures migration for 3rd party applications.
  • Designing database replication processes and procedures.
  • Implementing Sybase replication. Designing warm standby application with Sybase 12.5 and Replication Server 12.6 on Sun Solaris and Suse Linux.
  • Proof of concept project: Installing Sybase IQ 12.6 on Sun Solaris 9. Configuration for large database for query performance. Migrating Oracle data warehouse to Sybase IQ. Migrating stored procedures, functions, queries. Rewriting existing reports.
  • Migration Sybase ASE 12.5 to Oracle 10g using Oracle migration workbench and custom coding.
  • Database security manager.
  • Architecting and designing database, UNIX, Windows security procedures.
  • SOX database compliance implementer.
  • Designing, implementing company wide database access control, monitoring and audit reporting procedures for Sarbanes-Oxley compliance for databases (Oracle, MS SQL Server, Sybase ASE)
  • Deploying Oracle Label security and encryption using DES algorithm. Oracle DBA (RMNA, ASM,RAC)
  • Mainframe elimination project member. Migration mainframe application into UNIX, Oracle.
  • Supporting stock trading applications (C/C++ real time messaging system, C++ applications on Solaris.
  • Developing a new functionality for existing financial/trading applications using Sybase open client libraries with C/C++ and Oracle OCI, Informix 4GL

Confidential, Golden Valley, MN

Sun Solaris Admin/Oracle / BI Architect / Developer/Project Manager, Team Lead

Responsibilities:

  • Setting up Sun Solaris hardware/storage systems. Installation Solaris 9 and designing raid configurations. Solaris Administrator.
  • Custom ETL design and development for near real time data warehousing system and various data marts
  • Setting up Oracle Application Server 10g.
  • Migration/Conversion of Oracle Forms6i and Reports to Forms/Reports 10g. Conversion and deployment of custom PLSQL and C/C++ (user exits) routines from client/server to multi-tier Oracle 10g environment.
  • Migration Oracle 9i databases to Oracle 10g.
  • Migration Sybase 11.9 on Linux to Oracle 10g on windows.
  • Deployment of business application to Mobile device (Blackberry 7290).
  • Porting OLAP and database applications from Intel/Windows into AMD64/Opteron with Windows 2003 64-bit extended version.
  • Mobile Java application development using Blackberry Java SDK. Designing .Net based Web Services.
  • Oracle BPEL installation and configuration.
  • Database/Application Security manager.
  • Data Architect / Oracle and MS SQL DBA / Data Warehouse-OLAP Designer/Modeler
  • Modeling, designing, deployment of data warehouse applications and various data marts.
  • Metadata modeling and design.
  • Integration MS SQL Server with Oracle 9i databases and applications. RMAN, ASM. Data Guard.
  • Implementing Oracle Data Guard (v 9.0.4) on Windows 2000.
  • Working with Ross ERP package to extend the system functionality and implement BI system.

Confidential, Minneapolis, MN

SCM (Software Configuration Management) Project Lead

Responsibilities:

  • Change Management Integration.
  • Designing a custom scripts for version control process automation using PVCS Version Manager.
  • Designing a custom build scripts in Korn shell for Solaris 9 and in batch scripting in Windows.
  • Training staff in version control process and software tools.
  • Architect /Project Lead for OLAP Project
  • Capacity planning for deployment of OLAP and reporting applications.
  • Making hardware, cube-dimension design and deployment recommendations for MS SQL Analysis Server with 1500 online users.
  • Implementing dynamic dimensional security for domain users.
  • Designing efficient ETL processes with minimal batch window.
  • Optimizing existing and designing custom MDX queries.

Confidential

Data Warehouse Designer / Developer

Responsibilities:

  • Designing schema and ETL processes, tuning database and optimizing for large batch load and ad hoc query.
  • Migration from Oracle 7.x to Oracle 8i/9i.
  • Implementation of VERITAS clustering / cluster server with Oracle 9i.
  • Administration Oracle Warehouse Builder, Discoverer, Oracle 9ias.
  • Working with mainframe source data. Mainframe data cleansing, transforming, loading into DW.

Confidential, Golden Valley, MN

Database Engineer

Responsibilities:

  • Project lead, analyst, designer and developer of a chemical manufacturing application. Data Warehouse and various data marts were designed from Cimpro Manufacturing operational source.
  • Designed OLAP applications with MS SQL OLAP Services and Crystal Analyzer.
  • Multidimensional database design, DTS, dimensions, cubes, MDX, mining model developments.
  • Migrated existing applications to a Java platform with Oracle 9i server, Oracle Designer 6i, Oracle Forms 6i, Oracle Reports, Oracle Application Server 9i and Oracle Portals.
  • Migrated PowerBuilder 6.5 applications into PowerBuilder 8.0.
  • Developed new applications with PowerBuilder 8.0 with Oracle 9i as the backend.
  • BizTalk developer and administrator. Application integration with BizTalk 2000/2002. XML development.
  • Installed Oracle 9ias release 2 with Oracle Portals Release 2. Upgraded from Portal release 1 to release 2.

Confidential, Minneapolis, MN

System Architect/Developer

Responsibilities:

  • Change Management, Code Management and Build Management.
  • Installation and configuration of Oracle Collaboration Suite (Oracle Email, Calendar Server) on Windows 2000 with multimode configuration.
  • Migration Microsoft Exchange into Oracle Email.
  • Connection of Outlook and web mail clients with Oracle Email Server and Oracle Calendar Server (Oracle Collaboration Suite).

Confidential, Minneapolis, MN

System Architect/Developer

Responsibilities:

  • Designed the plan and implementation of the migration of insurance applications from PowerBuilder 6.5 to PowerBuilder 8.0.2.
  • Applied patches and optimized an application for performance with Oracle backend.
  • Drafted the technical plan to migrate existing client/server application into a web environment.
  • Migrated 9ias applications from Oracle 8.1.6 into Oracle 8.1.7.4 on an HP UNIX platform.
  • Applied patches to HP UNIX 11, installed 9ias and web enabled Oracle Forms application.

Confidential, Minneapolis, MN

System Architect/Developer

Responsibilities:

  • Installed and configured SAN system with Linux cluster servers.
  • Installed and configured Linux OS, cluster software, CFS (GFS from Confidential ).
  • Installed Oracle RAC (Real Application Cluster former OPS) on Linux clusters.
  • Migrated Data Warehouse Applications from MS SQL Server into Oracle RAC.
  • Migrated T-SQL procedures, functions, and triggers into PL/SQL.
  • Migrated C/C++ code within windows DLL into a Linux shared library.

Confidential

Database Engineer

Responsibilities:

  • Installed, configured, and administered HP-Unix 11.
  • Installed Oracle 8.1.7 on HP-UNIX, configured Apache web server in SSL mode.
  • Migrated Oracle WebDB applications into Oracle portal.
  • Defined and implemented the company’s data security policies.
  • Migrated Oracle web server and OAS 4.X to Oracle Application Server 9i.
  • Migrated older Oracle databases and applications to latest versions.
  • Installed Oracle 9i Application Server on Solaris, HP-Unix 11, and Linux.
  • Installed and migrated Oracle 8.1.6 to Oracle 9i.
  • Oracle 9i development on Linux and Solaris.
  • DBA responsibilities on Solaris, HP-UNIX, and NT.
  • Designed a backup system with RMAN and Omni Back for multi node Oracle installations.
  • Integrated Oracle with VERITAS backup software.
  • Upgraded and tuned the database.
  • Created Data Warehouse Applications for a banking system with MS SQL Server and Oracle 8i.
  • Installed Oracle Clinical 4.0 on NT and Unix platforms.
  • Installed and Configured Oracle Fail Safe on Microsoft Cluster Server.
  • Designed database applications for Packet PC (Windows CE Operating System) with synchronization with the Oracle Database on the Server.
  • Project Manager and Lead developer of PowerBuilder 6.5 and Oracle project.
  • Integrated PowerBuilder, Oracle, and VB applications in a heterogeneous environment consisting of Mainframe and Client /Server.
  • Migrated PowerBuilder client/server applications to a J2EE platform, using Tomcat, OAS 9i (OC4J).

Confidential

Database Engineer

Responsibilities:

  • Oracle DBA on NT and Linux.
  • System programmer (C/C++, OCI): Created mission critical communication servers and interfaces between Oracle and third party products. Deployed servers as Win32 service on NT with event logging capabilities.
  • C++ and Java socket programming with Cerulean Packet Cluster Server.
  • Multithreaded middle tier socket multiplier, interfaced with mainframe and clients on the web, deployed as Win32 service on NT.
  • Designed the database and performed the install.
  • Built Data Warehouse and Data Marts using Oracle tools.
  • Created custom template classes with C++ and OCI to enable DBI wireless communication services to connect and interact with Oracle.
  • Developed Oracle Forms and Reports.
  • Published forms on the web with Form Server.
  • Performed WebDB site administration and development.
  • Installed and configured Oracle 9i Application Server on NT and Linux.
  • Migrated existing WebDB applications into Oracle 9i Application Server (OAS).

We'd love your feedback!