Interfaces/etl/ Business Intelligence Architect Resume
PROFESSIONAL SUMMARY:
- Confidential is a DBA/System Architect/Software Engineer/ETL/Enterprise Developer.
- With extensive experienceUtilizing Oracle EBS, .NET Microsoft Frameworks, SSIS, SSAS, SSRS(BIDS).
- His background includes System design, ETL design, DBA, DB2, ERP systemeCommerce, and Disaster Recovery.
- Oracle Database Administration, SQL Database Administration, Data ArchitectureDB2 Database Administration. Data Warehouse development and design.
- Enterprise - wide Support for Database system, .NET, C#, and Web application.
- Have also work. Within legacy and Client Server environments. Perform Data modelingEntity Relationship Diagram (ERD) design, within multidimensional databases, Relational ModelingSystem architect. System enhancements, OOD, OOP. And Project Lead (Management).
TECHNOLOGY SUMMARY:
Software: T/SQL, & PL/SQL, SQL, .NET FRAMWORKS, HTML, XML, JAVA, J2EE ORACLEASP.NET (Web Pages), VISUAL STUDIO, C#, QMF. TELON, WPF, SQL SCRIPTINGOLAP,ORACLE EBS, MS ACCESS, DATA WAREHOUSING & DESIGN, MS VISIO, DB2, CICS, Oracle 9i/10g/11g Oracle 11i FINANCIAL & MANUFACTURING ERP APPLICATIONSIDMS, ADS/O, ADS/A, OLM, IDD, IMS, DL/1, ACCESS, EDI PROCESSING, VISIO, HL7, MICROSOFT SQL SERVER.2012/2016, RAC, RMAN LOAD BALANING.
BI SOLUTION TOOLS: ENDEVOR, COBOL, COBOL II, TFS(Microsoft Team Foundation Server).
Hardware: IBM mainframes, IBM390, RS/6000, HP 3000, AS/400, Server’s, and PC's
Operating Systems: MVS/OS, UNIX, AIX, VISTA, MICROSOFT WINDOWS and SERVER.
INTEGRATION EXPERIENCE
Confidential
Interfaces/ETL/ Business Intelligence Architect
Responsibilities:
- Have Created Interface/integration Tables between Legacy system and Oracle Applications, while applying Business rules, OBIEE (Oracle's BI strategy). Data transformation, and data Disaster Recovery for these systems.
- Defined additional/new reporting requirements and provided the programming necessary to ensure Integration implementation. Within a Data Warehousing environment.
- Created BI strategy, using .Net, Data Base Modeling, SSIS & SSAS packages, and SSRS Reports for ETL, and data validation. Perform data editing, and data auditing.
- All within .Net Frameworks (C#, VB, MVC, WPF). Using OOD & OOP. methodologies.
- Experience in Data modeling, XML-based data exchanges, setting up Business rules, data transformation, and data mapping.
Confidential
DBA, Application, and Interface support, Consultant
Responsibilities:
- DBA support, System architect support, Application support and Interface support.
- This support effort required working with Application user, Network manager, Database managers, System Administrator, and Department Directors.
- Utilizes Oracle 11g/12c, DB2, SQL Server, SSIS, and SFG(Secure File Gateway).
- For system and interface support.
- And Visual Studio(.Net) for front-end support..
Confidential
DBA Consultant
Responsibilities:
- Splitting the CTR Archives(DB2) Database. As the Primary system architect, and DBA on this project.
- That required taking 20 Years of data, and creating a methodology for archiving 18 years of data.
- And implementing a process that will maintain 2 years of data, and also implement the new archiving methodology.
- Provided Oracle 11g/12g, DBA support for WIA (Wounded In Action) Database.
Confidential
Lead SYSTEM CONSULTANT
Responsibilities:
- As the Primary system architect, DBA, and system/Net developer. Responsible for providing enhancements., and new application development for the Confidential System.
- This complex system, consist of a SQL Server Data Bases /Data Warehouse, Web servers.
- A User friendly front end utilizing Web Services, .Net Frameworks (ASP, C#, WPF,).
- The Backend processing concise of (T SQL), and the analytical processing environment.
- Utilizes the Microsoft business intelligence Stack ( SSIS, SSAS & SSRS).
- Provided major responsibility for architecting, and development.
- For conversion projects, that converts a SQL 2000 Data Base/DTS/ ETL System. Over to a SQL 2008 Data Base
- SSIS, System platform. Utilizing .Net Frameworks,. store procedures, SSIS, application and
- Data Base programming, C#, Database Administration, Visual Studio, Excel, Access
- And DTS ( SQL 2000 Server).
Confidential
CONSULTANT /Project Analyst / Net Developer
Responsibilities:
- Performed System analysis and Net design for conversion of legacy Cobol programs to .Net Frameworks OO programming modules and business objects modules
- Provided Data planning/analysis for utilization of SSIS, & SSRS data reporting.
- System On an SQL Server Data Warehouse/ Data Mart .platform
CONSULTANT / DBA / ETL Designer/Developer
Confidential, Cleveland, Ohio
Responsibilities:
- Provided direct Oracle DBA Administration support for all staging and ETL data bases.
- Perform interfacing, Net programming and analysis of vendors software for Web Services, Staging. and conversion.
- Working with Oracle, TSQL, PL/SQL SSRS, SSIS, ( BI strategy), within an Oracle 11g,SQL Server 2008, DB2 Data Warehouse and Data Marts. On an Client/Server platform.
- Responsible for Converting SQL 2000 DTS packages and Data Cubes. Over to 2005 SQL SSIS
- Data packages, and SSAS Data Cubes. This task Included. Net programming, ETL, Systems
- Staging, SQL 2005 Database Administration, Data Warehouse, SOA System and Design.
