Data Architect/Lead Resume Monterey, CA - Hire IT People

SUMMARY:

I.T Professional with over 18 years of experience in Data Warehouse, ETL and Legacy platforms.
Extensive knowledge in P&C Insurance, Health Care, Insurance, Telecom and Manufacturing domains.
Strong RDBMS knowledge and concepts of Data Warehouse and Dimensional modeling. P rovided value additions, process automation and optimization savings withprocess improvements.
Key strengths include:Architecture,Design & Development,Technical Lead,Exceptional Technical Skills,Detailed Analytical skills,Data Modeling,Development,High Quality deliverables.

TECHNICAL SKILLS:

ETL Tools: Business Objects Data Integrator (BODI), Informatica Power Center 9.5/9.1/8.6.1, Data Stage 7.5, SQL Server Integration Service 2015 (SSIS)

Products: Guidewire Policy Center, Guidewire Billing Center, SAP Data Services 4.2 (BODS)

Reporting Tools: Tableau 9.1, COGNOS 10.0, Business Objects 6.5

Languages: SQL, PL/SQL, Unix Shell Scripting KSH, COBOL, C, C++

Databases/Files: Oracle 9i/8i/10g/11g/12c, DB2 9.7, Teradata V2R5/V2R4,SQL Server2016, 2008 R2, Flat files, VSAM, COBOL files

Operating Systems: Windows 7, XP, UNIX/Linux

DB Utilities: SQL Loader, SQLPlus, MLOAD, Fast load, Fast export, BTEQ

Other Tools: CA Erwin R 7/7.5/8.2.06, Advanced Query Tool(AQT), Toad 4.7,CoreFTP, Putty, Quality Center, File Zilla, Attachmate, Data Loader, TOAD Data Modeler.

PROFESSIONAL EXPERIENCE:

Confidential, Monterey, CA

Data Architect/Lead

Responsibilities:

Worked on Physical Data Modeling, ER Diagrams, Reverse and Forward Engineering using TOAD Data Modeler.
Architected & Designed ETL processes.
Executed Data Services Initial and Delta loads in DATAHUB and INFOCENTER.
Finetuned Batch SQL to improve the performance.
Developed and configured Data Services jobs for extracting Business Owners (BOP) from Policy Center in to INFOCENTER Warehouse.
Worked on POCs to extract Legacy BOP history in to ODS layer.
Supported Daily and Monthly batch cycles in DATALAKE used in Tableau Dashboards.
Provided User support for questions regarding Tableau reports.
Designed and Developed back end database scripts.
Performed Tableau deployments, post deployment validation, set up user permissions and Job schedules.

Confidential, Orange, CA

Architect/Tech Lead

Responsibilities:

Used Erwin to analyze the Physical data model relationships.
Generated ER Diagrams, Logical & Physical Models.
Established Data Architecture Naming standards by using nsm file.
Analyzed requirements and Developed PRXo leakage DataMarts (Opt - In and De-Identified).
Worked on enhancements to support FDS reconciliation process.
Prepared Approach/Design and developed ETL processes for CPA buying group interface.
Worked on INSITE enhancements.
Architected, Designed and developed ODS Archival Process.
Suggested improvements to existing ETL processes as value addition.
Developed stored procedures and incorporated push down optimization in ETL.
Optimized ETL queries to reduce the number of ETL transformations.
Developed Mapplets, re-usable sessions, Worklets and shell scripts.

Confidential, Los Angeles, CA

Data Architect/Modeler

Responsibilities:

Extensively worked on Physical data model updates, Forward Engineering, Reverse Engineering and Alter scripts preparation using Erwin.
Worked on Erwin models compare, Bulk editor, Option sets and Templates.
Improved the reverse engineering efficiency by modifying the option set.
Prepared DDLs, DCLs for Table changes, Environment synchronization, Production Migration.
Prepared load scripts for data copy requests.
Worked on SQL fine tuning to improve the performance.
Developed scripts towards Grants Automation and Table/Index/Referential constraints compare across environments.
Prepared stored procedures to restart the Identity column values.
Reviewed the team's change requests to ensure better design in choosing distribution key, Indexes for the join, column naming standards and standard columns for FDR tables.
Worked on Multi Dimensional Cluster tables (MDCs), BLOK, DIM and CLUSTER Indexes.
Turned on Index compress to reduce the Index usage.
Developed Materialized Views (MQTs) and Range Partitioned Tables to improve the ETL performance.

Confidential, San Ramon, CA

Sr. Tech Lead

Responsibilities:

Worked with the heavy enhancement projects and prepared the Solution Approach to assist with integrating the projects in to the system
Extensively worked with Solution Approach, High level design and provided Architectural guidance/support to the development team.
Assisted development team by providing the design tips, impact analysis and data mapping.
Prepared conceptual/logical, physical data models and performed reverse and forward engineering.
Worked with the User community in analyzing the production issues, and suggested the permanent fixes
Reviewed the Business requirements and the design documents and suggested changes to build a failsafe system.
Identified changes to the daily ETL and Mainframe process that resulted in optimization savings.
Experienced in multi-tasking with heavy enhancement projects.

We provide IT Staff Augmentation Services!

Data Architect/lead Resume

Monterey, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship