Consultant/Analyst/Programmer/Data/ETL Architect Resume

SUMMARY:

Looking for dev role in Data/ETL Architect in OLTP/EDW/OLAP/MDM development.
Excellent managerial skills in SDLC development. 17 years experience.
Hands - on T-SQL, PL-SQL, ETL, BI design/visual. Kimball/Inmon, DataVault, Big Data
Versed in Microsoft/Oracle technologies. Work in implem./data convert/integration/big data
Master Data Architect - EDW/Mart background. Customer/Vendor/Product, etc.
Knowledgeable in facets of healthcare, ERP, SCM, FI, retail, distribution, sales/marketing.

TECHNICAL SKILLS:

Hardware: HP(Unix - Bourne,(awk, sed). (AIX), Windows 8/10(Powershell), Exadata
Software: Oracle Financials - 10x/11x/12 Mfg., FI, HR, SCM, BOM, ASM
Oracle: Designer/Developer: PL/SQL, SQLLoader, SQLPlus, ODI, OBIEE
Peoplesoft 9x/10x HCM/SCM/GL, AP, AR, OE, Billing, Mfg., Pro. Mgmt.Tools, EPM 8/9, Risk Mgmt., FTP, Student Admin.
Microsoft SSIS, SSRS, SSAS, Visual Studio, SSDT, T-SQL MDS, (registry, hybrid), HDInsight
Databases: Oracle v11/12, SQL 2012/2014/2016/2017, Access 2010/2013/2016, Azure, Teradata, GreenplumModeling: 2Nf, 3Nf, dimensional, Data Vault, BigData, canonical, tabular, dimensional/relational.
BIG Data: NoSql, Mongo, MySql, Postgress
Data warehouse: Data Architect/Data Modeler, ETL Architect, Kimball/Inmon/Linstedt. Data Vault v CIF.
Informatica PowerCenter/PowerMart 8.x/9.x/IDQ, Cognos DecisionStream, ImpromptuPowerplay, Cognos ReportStudio., Bus. Obj. Data Integrator, Universes
Visualization: PowerBI, R, Tableau
Change Mgmt: PVCS, SCCS, Quest STAT, Team Foundation, JIRA, GIT, SVN
CASE Tools: Erwin, PowerDesigner, and ERStudio
TOAD Modeler, SQL Architect
Medical Ind: CPT, ICD-9/10, NDC, NPI, HIPAA, HCFA 1500, NCPDP, Medicaid, Medicare, Obamacare: Affordable Care Act. State exchanges.
EDI: 270, 271, 272, 832, 834, 835, 837, HL7

PROFESSIONAL EXPERIENCE:

Confidential

Consultant/Analyst/Programmer/Data/ETL Architect

Design/Programmer: Data Architect/Modeler with design efforts using Erwin, ERStudio and/or Power Designer as a method of forward/reverse engineering applications. Able to use each product to generate conceptual/logical/physical models, and I had assumed both designer/modeler roles. Have designed MDM dB’s and metadata repositories for managing ETL quality and integration . I have used Informatica, SSIS, Data Integrator, and ODI for ETL processing and reporting structures. SSAS and Powerplay have been used to load/build cubes for business analytics. Dimensional design methods via Kimball/Inmon/Linstedt.
Technical/Project Leader: Recently, I have led several groups, from 3 to 10 professionals involved in an entire SDLC implementations. Project Mgmt. tools such as Microsoft Project, Tool Workbench, and Peoplesoft Projects were used to manage deliverables and costs. Took part in hiring process. Interactions with C-level management were conducted and budget requirements, planning and staff augment. were reviewed constantly.
Automation/Accurac: TimeXtender
Programmer Analyst/System and Data Analyst: My current efforts lie in implementation of BI projects from OLTP to OLAP reporting and cloud computing to multiple devices. In addition, efforts lay within Oracle, SQL development projects. Taken a programmer/analyst’s role in the OOD design and the conversion of the back end. I have assisted in the development of test plans for unit, system/production testing and at times, have utilized PVCS/SCCS/STAT to track changes and moderate version control.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship