Data Architect Resume Phoenix, AZ - Hire IT People

SUMMARY:

Proficient architect with extensive experience who can provide technical leadership, strategy and architecture governance with special emphasis on Data architecture - data design, data modeling, data governance, security, metadata, master data, data analytics, data migration and integration.
Strong experience in working with multi-tier application (Java and .NET) teams/architects on end-to-end solution architecture.
Worked in Finance, Education, Manufacturing and Insurance functional domains and strong ability to work in any functional domain as an individual contributor or manage a team.

TECHNICAL SKILLS:

Concepts/Methodologies: Requirements analysis/design, Relational (OLTP/OLAP) data architecture, SQL tuning (explain plan, tracing/tkprof, hints), Star/Snowflake schemas, Big data architecture, Object oriented analysis and design, Agile and Waterfall methodology, Messaging frameworks, REST/SOAP frameworks, HTML/XML/JSON

Databases: Oracle (10g, 11g), MongoDB, Microsoft SQL Server, MySQL, NoSQL databases (Hive, HBase), Apache Hadoop

Software/Tools: ER/Studio, PL/SQL Developer, Toad, Oracle ERP, Microsoft Visio, SQL Developer, Microsoft Office, Tableau, SSIS, SSRS, SSAS, R - Studio

Languages: SQL, PL/SQL, Unix scripts, C, Java script, R, Apache Spark

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, Phoenix, AZ

Responsibilities:

Built an API strategy for Credit Risk domain along with setting up a Resource model that would be the reference model for existing and future APIs.
Provided recommendations based on research of existing HBase access patterns, data distribution and data ingestion (into the Hadoop data lake) processes.

Core technologies: MapR Hadoop, Hive, HBase.

Data Architect

Confidential, Phoenix, AZ

Responsibilities:

Delivered dimensional data models using ER/Studio to bring in the Employee and Facilities domain data into the oracle data warehouse.
Delivered data contracts and structures for a MongoDB database that can be used for segmentation of students for various marketing campaigns, regulatory initiatives, etc.
Migrated email subscription information from legacy system to new system of record in a phased manner that enabled the business to access the information from the system of record and eliminate synching data to multiple systems.
Delivered data contracts for sending data from Hadoop to external vendors so that the business has access to accurate data on the vendor applications.

Core technologies: Oracle 11g, ER/Studio, MongoDB, Cloudera Hadoop, PL/SQL Developer.

Team Lead/Data Architect

Confidential, Phoenix, AZ

Responsibilities:

Secured PII master data in databases using tablespace encryption and managed the transition from direct access to SOA services based access for PII information thereby avoiding moving data around multiple systems.
Delivered performance improvements by cutting down access time from over 10 minutes to less than 10 seconds using Oracle partitions.
Provisioned centralized data store for master data in the education domain.
Provided quantitative/qualitative data analysis for multiple teams to identify trends and insights in the data.
Delivered data contracts for creation of SOA services by working closely with multiple application teams.
Consulted with D&B to periodically extract company information from the Hoovers FTP site and provide SOA services.

Core technologies: Oracle 10g, Oracle 11g, ER/Studio, PL/SQL Developer.

Senior Software Developer

Confidential, Phoenix, AZ

Responsibilities:

Enabled business to gradually transition from legacy system to the new system by developing a two-way data synch (synchronous and asynchronous) process between two schemas in a database.
Resolved performance issues that helped the business to access the data within the applications in a timely manner.

Core technologies: Oracle 9i, Oracle 10g, PL/SQL Developer.

ERP Consultant

Confidential, Edison, NJ

Responsibilities:

Migrated data related to Inventory, Bill of material, Work in process and MRP modules from Oracle to SAP through an intermediate system ‘SPEED’ and resolved any performance issues using tracing, Tkprof, explain plan and hints.

Core technologies: Oracle ERP 10.7, Oracle 7.3 RDBMS.

Software Developer

Confidential, Phoenix, AZ

Responsibilities:

Created custom printable forms using Document Library Services (DLS) to read document/form structure and contents from Oracle databases.
Delivered performance improvements, validated and balanced the data imported from the legacy system.

Core technologies: Oracle 8i, Power builder 6.0, Document Library Services (DLS), TOAD.

ERP Consultant

Confidential, Phoenix, AZ

Responsibilities:

Customized various Oracle ERP modules - Purchasing, Inventory, Payables, Work in Process, Bill of Material, Order Entry, and Supply Chain Planning.
Delivered a process to fax/email a Purchase Order from Oracle ERP to the supplier/buyer through Workflow management system.

Core technologies: Oracle ERP 10.7, Oracle 7.3, Forms 4.5, Reports 2.5.

We provide IT Staff Augmentation Services!

Data Architect Resume

Phoenix, AZ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship