Senior Data and ETL Architect Resume

SUMMARY

Leading roles in 24 successful projects in Finance, Insurance, Telecommunication, Government, Education, Mining, Manufacture, Retail industries
Solid experience in ERP, Data Warehouse and Business Intelligence solutions, including highly complex systems with enterprise - wide impact
16+ years of experience as a Business Intelligence/Data Warehouse consultant
Combined 23+ years of client-server and multi-tier application and database experience
Remarkable leadership skills, able to effectively lead, manage and support teams
Demonstrated ability to work successfully in high paced environment
Responsible, creative, results-oriented professional
Excellent communication and interpersonal skills
Oracle Certified Professional

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server, DB2, Hadoop (Hive and SparkSQL)

Data Modelling Tools: Erwin, Power Designer, Oracle Designer, Microsoft Visio

ETL Tools: Oracle Data Integrator, Informatica, Datastage, Microsoft SSIS, Business Objects Data Integrator, HPLSQL

BI Tools: Cognos, Business Objects, OBIEE, Tableau, Microsoft SSRS

PROFESSIONAL EXPERIENCE

Confidential

Senior Data and ETL Architect

Responsibilities:

Designed an ETL automation framework by creating a metadata model on a remoted relational database and ETL processes in Hive with comprehensive QA checks
Designed Data Architecture and Data Models for Retail and Insurance Domain
Improved Forecast accuracy
Led cloud migration to GCP
Designed a set of Tableau dashboards to monitor the ETL framework
Led a team of onshore and offshore ETL developers
Extensive ETL Package development
Performance tuning

Environment: Hadoop, Erwin, Hive, Spark SQL, GCP cloud, HPLSQL, Tableau, DB2, SQL Developer, Linux, Shell Scripts

Confidential

Senior Solution Architect/ Lead

Responsibilities:

Created Solution Design documents for various components for a regulatory compliance project
Reviewed Data Architecture, Architectural Blueprint and BRD documents
Led a team of onshore and offshore ETL developers
Addressed database and application performance issues

Environment: Oracle 12c and 11g, ODI, PL/SQL, Java, Erwin, TOAD, Microsoft Office