SUMMARY

• 19 years of experience in IT software development, operations and consulting with emphasis on Big Data and Data Warehouse applications and architecture with multiple business domains such as Banking, Telecom, Analytics for CPG and Market research.
• I have thorough understanding and extensive hands on experience implementing end to end data centric solutions from conceptual to production ready. I am well versed utilizing cutting edge technologies such as MPP databases and open source Big data platforms.
• At Confidential, I am actively involved in building the next generation of Analytics platform utilizing Cloud centric data warehouse Snowflake and Big data technologies (Apache Hadoop / Spark) and cloud computing (Microsoft Azure). I successfully converged several Oracle based Analytics systems to Netezza MPP, thus resulting in unification of Analytics platform and significant savings in terms of operational and licensing costs. I am also involved in analyzing current technology trends and innovations and try to apply them within Confidential projects.
• At Confidential, I played a critical role in implementing financial regulatory reporting framework to address Dodd - Frank regulations and BASEL reporting. I was instrumental in setting up offshore ETL COE, which resulted in standardizing ETL platform within the enterprise and resulted in significant sustainable savings.

TECHNICAL SKILLS

Database Technologies: Netezza, Teradata, Oracle, UDB, Sybase

Snowflake: NO SQL Databases

Big Data Technologies: Apache SPARK, HIVE, OOZIE, FLUME, Impala, SQOOP

Big Data Frameworks: Cloudera CDH and Data bricks

Cloud Computing: Microsoft Azure and Azure Data Lake

Programming Languages: Python, Scala, JAVA, Cobol, REXX, SQLMPP Platforms

Netezza, Teradata, Snowflake: ETL Tools

Information Server 8.x, Informatica iPAAS, Azure Data factory: Modeling Tools

Erwin, Embarcadero Data Architect, TOAD: Scripting Languages

Shell Scripting: CI CD

Jenkins: Change Control

MKS, TFS, Bit bucketMetadata Tools: IBM Information Server Metadata Workbench

PROFESSIONAL EXPERIENCE

Confidential

Sr Principal Data Architect

Responsibilities:

• Leading an effort to revamp Reporting and Analytics platform at Confidential, which involves moving the Analytics landscape to Cloud.
• Responsible for evaluating cloud technofixes and conduct several POC exercises and provide recommendations.
• Responsible for creating a roadmap to build an enterprise data lake capabilities.

Confidential

Principal Data Architect & Principal Performance Engineering

Responsibilities:

• Leading the effort of building big data platform initiative for replacing legacy data analytics platforms based on Netezza to cloud Datawarehouse Snowflake
• Lead an effort to build Data Lake in Cloud to enable On Demand Computing & data processing using Databricks and Cloudera CDH platforms in Azure
• Analyze performance denigrating SPARK processes and provide code tuning techniques
• Conduct several POC on SPARK processing and create reference artifacts for Application Development teams.
• Leading a team of developers to convert shell scripting ELT process to Python
• Publish best practices and performance tuning techniques on Big Data processing using SPARK/ SCALA / HIVE / ADLS
• Responsible for evaluating Big Data technology stacks and provide recommendations
• Responsible for working with DEV OPS and infrastructure teams to oversee capacity planning for Cloudera Big Data platform
• Responsible for overseeing capacity planning for AOD Netezza platform
• Successfully migrated Oracle based Data Marts to Netezza MPP platform

Confidential

Data Warehouse Architect

Responsibilities:

• Designed ETL framework to support migration of master data from SAP MDM to Teradata MDM.
• Analyze SAP MDM functionality and map the functionality to Teradata MDM.
• Designed data integration architecture for data synchronization into MDM
• Translated business requirements to conceptual and logical data models
• Lead efforts in standardizing data models and data integration designs

Confidential

Enterprise Data Warehouse / ETL Architect

Responsibilities:

• Partnered with Risk, Finance and Technology groups to create a solution architecture for Finance regulatory Enterprise reporting framework.
• Served on Information Domain Architecture governance board responsible for setting ETL and Data Warehouse platform architecture standards.
• Enhance and maintain enterprise data models.
• Architected Imaging and workflow functionality for Consumer lending business unit.
• Responsible for Creation of Architecture Definition Document based on TOGAF ADM model to document technical solutions architecture across the organization
• Implemented best practices and performance tuning techniques for ETL and DW platforms
• Rolled out Information Server 8.1. at global level
• Translated business requirements into systems qualities and repeatable design strategies and patterns, such as adaptability, scalability, availability, and reusability.
• Assured enterprise application integration by selecting tools, specifying shared data and code resources, defining interfaces and data-flows, and monitoring progress.