SUMMARY

• Accomplished and high performing Enterprise Data Architect / Snowflake with 15+ years of experience in designing and implementation of Data Models for data warehousing, operational data stores, data science, Business Intelligence across all industry verticals. Excellent experience in healthcare domain.
• Designed and implemented data models optimized for Snowflake Architecture
• Designed and developed ETL processes to load data into snowflake using snow pipe and third party ETL tools
• Developed Security framework for maintain the access controls and confidentiality and integrity of data Extensive experience as Data Architect, Data warehouse Architect, ETL, Data Integration, Business Intelligence and Data exploration for Data Science teams.
• Extensive experience in migrating and deploying AWS cloud - based solutions using AWS Data Migration Services and Schema conversion tool.
• Design and develop ETL processes in AWS Glue to migrate the claims data from external sources like S3 into AWS Redshift.
• Experienced in ER Studio - Data Architect version 16.x, 17.x & 18.x, Erwin, Toad Data Modeler, SQL Data Modeler, ETL (Informatica),Talend, BI Tools (Tableau, OBIEE & MicroStrategy)
• Skilled in developing and managing Data warehouse, ETL, BI and associated cross-departmental teams resulting in efficient design, development, and implementation of predictive, analytical and operational reporting projects.
• Experienced in data transformation, data mapping from source to target database schemas and data cleansing procedures.
• Extensive experience in aggregating data, exploring data, building and validating predictive models, deploying completed models using python libraries such as scikit learn, pandas etc.
• Strong in building Oracle/PostgreSQL database schemas, tables, views, procedures, roles and permissions.
• Extensive experience with Type-1, Type-2 and Type-3 Dimensions.
• Extensive experience with Slowly changing dimension methodology and slowly growing target methodologies.
• Designed Big Data strategy, including designing multi-phased implementation roadmaps
• Data wrangling of heterogeneous data and explore and discover new insights
• Skilled in conception and execution of key strategic initiatives with a unique mix of delivering technical and business goals.
• Excellent knowledge and experience with a wide range of Oracle software applications with unique specialization in data warehousing (Oracle, Teradata, PostgreSQL, AWS Redshift & Sql Server), ETL (Informatica & ODI) and Business Intelligence software (OBIEE 11g/OBIA - BI Apps 7.9.6.x).
• Strong in Oracle. PostgreSQL, Teradata, SQl Server Database administration, performance tuning & sizing of Databases.

Areas of Expertise

• Snowflake Architect
• Snowflake Administration
• Conceptual, Logical & Physical Models
• AWS Redshift & PostgreSQL
• Metadata & Data Dictionary
• Requirements Gathering /Gap Analysis
• Design and Delivery of ODS, DW & BI Projects
• ETL Design (Informatica & AWS Glue)
• Database Design - Star/Snowflake Schemas
• Global Delivery-Onshore/Offsite model
• Data Lineage, Source to Target Mapping
• Oracle Database Administration
• Data Governance & Processes
• Cloud Data Migration - AWS DMS
• Data Science - Data Exploration and Mining
• Machine Learning Models
• Data Mining & Data Preparation for Predictive models
• Data Lakes Architecture
• Snowflake Data Migration
• Snowflake Database

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix, Python

RDBMS: Oracle 12c/11g/10g/9i, Teradata, MS SQL Server 2000, PostgreSQL

Cloud Technologies: Snowflake, AWS - Redshift, Aurora, PostgreSQL

Big Data Technologies: Hadoop, HDFS, Sqoop, Hive, Distributed data file systems

ETL Data Integration Tools: Informatica Power Center 9.x/8,x/7,x( Designer, Workflow Manager, Repository Manager, Repository Server Administration Console, Pyspark, AWS Glue. Talend, Snowflake Streams, Snowflake Data Pipe lines

Reporting Tools: OBIEE, Tableau, Power BI, MicroStrategy

Cloud Technologies: AWS Redshift, AWS Storage Service, Security, IAM, Route 53, SNS,, Azure Data Bricks

Data Modeling Tools: ER Studio 17.x, Erwin, SQL Developer, Toad Data Modeler

Operating Systems: Windows, Unix/Linux

Data Science: Data processing, Data Mining, Data preparation and delivery to Data science teams

Machine Learning Models: Supervised & Unsupervised ML models, Multiple Regression, Logistic Regression, Deep Learning, KNN, Naive Bayes, SVM, Decision Trees, Random Forest, Gradient Boosting, Cox Proportional Model

PROFESSIONAL EXPERIENCE

Snowflake Architect/ Data Architect

Responsibilities:

• Designed and developed multiple data loading architectural patterns using Snowpipe, Streams for data migrations.
• Solution presentation to both technical and executive audiences i.e senior ML Architects, product management, and sales teams to help customers build and implement innovative ML solutions on Snowflake by developing POC's, presentations, white board sessions and demos.
• Good knowledge with data engineering technologies and tools(dbt, Airflow, etc)
• Working knowledge of Data Science and ML fundamentals
• Designed and implemented Data Governance policies, Data standards, Data privacy and data masking policies
• Developed Row level access policies to restrict access to specific roles in organization i.e., create secure access views
• Designed and developed dynamic data masking procedures to mark sensitive data for unauthorized access
• Implemented data archival processes using time travel, fail safe, cloning and data retention policies
• Designed and implemented Snowflake security - Authentication, Authorization using RBAC, Network policies, Dynamic Masking and Row level access policies.
• Configured Snowflake SSO with Azure Active directory with SAML 2.0.
• Configured the private VPN gateway between cross-cloud environments for Data sharing and Security.
• Automated deployment of Snowflake objects from DEV to Test and QA using GIT, Performance tuning
• Designed and created different warehouses of different sizes for etl workloads and query performance
• Performance tuning and reviewing the query profiles to analyze and improve performance by reducing query execution time
• Created clustering keys to improve query performance by reducing the amount of data that needs to be scanned and efficient query pruning.
• Implemented dynamic multi-clustered environment for better query performance and data loads.
• Excellent experience in implementing snowflake security - RBAC, Network policies, Dynamic Masking and Row level access policies.
• Optimized data loading by executing the loads in parallel using snow pipe for continuous data loading
• Created materialized views and automatic clustering and automatic optimization of table storage
• Used Query Acceleration service and snowflake hints for better performance
• Knowledge in implementing Power BI (Desktop) - private Connectivity with Snowflake

Snowflake Architect/Data Architect

Responsibilities:

• Designed and developed enterprise data models and architectural frameworks utilizing best practices for Supply Chain division of JnJ.
• Analyzed and performed data profiling and data mining tasks for exploring data for ODS and Product management teams
• Designed and implemented data governance and architecture standards for changes in policy, processes related to data architecture design principles ensuring adherence to Clients Architectural Standards.
• Developed and documented the enterprise data architecture standards in Erwin which includes the principal standards and models for transactional and analytical systems serving both strategic and tactical needs.

Data Architect / Data Integration Architect

Responsibilities:

• Designed and developed enterprise data models and architectural frameworks utilizing best practices for Claims, Provider, Pharmacy and other subject areas.
• Designed and implemented data governance and architecture standards for changes in policy, processes related to data architecture design principles ensuring adherence to Clients Architectural Standards.
• Developed and documented the enterprise data architecture standards in ER Studio which includes the principal standards and models for transactional and analytical systems serving both strategic and tactical needs.
• Defined data model review processes to ensure that data model designs adhere to enterprise data standards
• Implemented data governance and naming standards using ER Studios Team server for data models, Terms and Glossaries to have a one definition of each term across the enterprise.
• Analyzed and performed data profiling and data mining tasks for exploring data for ODS and data science teams.
• Created data models for operational data stores, data marts and data science teams, the models include 3NF, Star Schemas and Snowflake schemas.
• Implemented data models meeting Bill Inman’s Data Modeling concepts (Logical and Physical) for transactional systems including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables
• Implemented data models meeting Ralph Kimball’s Data Modeling concepts - Dimensions, Conformed Dimensions, Facts, slowly changing dimensions
• Identify the downstream usage pattern of data and design and deliver the data ensuring the data security across the enterprise.
• Prepared Solution presentations/white boarding of conceptual and logical models with different teams and provided a strategic solution on how to ingest and integrate data using various ETL/ELT tools

Data Architect/Consultant

Responsibilities:

• Client facing role setting up Architecture Designs scoping and strategies and showcasing ROI.
• Providing technical leadership for enabling the successful design and delivery of enterprise solutions through strategic business development and high-level system design.
• Take the ownership of Big data strategy, data warehouse & BI strategy and and draw the roadmap and design new data pipelines from the legacy systems and recommend the Best practices and lay down the blue prints for the project deliverables.
• Work with vertical sales team to identify all Business Intelligence, Data Integration and analytical opportunities.
• Identify new business, revenue and profit from Financial/Health/Insurance/Manufacturing Services companies using analytics and cognitive computing.
• Identify and advance new business opportunities to closure.
• Respond to RFP's by discovering, designing and implement solutions.
• Oversee Big Data, Data Warehouse, Business Intelligence, Data Integration, Enterprise Information Management, Master Data Management and/or Data Consolidation projects.
• Client facing role setting up Architecture Designs scoping and strategies and showcasing ROI.
• Build, grow, and steward client and business partner relationships
• Assist in assuring client satisfaction and maintaining a strong client relationship through delivery excellence.
• Manage pre-sales activities, assessments, and the delivery of these first-of-a-kind solutions.
• Big Data Lead Architect - Real-Time Data Ingestion using Big data stack of technologies.
• Established a Reference Architecture for Big Data Blueprint and create a road map for a centralized operation in coordination with all verticals and cross functional teams.
• Prepared Solution presentations/white boarding for various client based on the requirements.
• Participate in Strategic discussions about Data Integration, Data Ingestion, Data ETL / ELT
• Coordinate and drive the project initiatives successfully with a blend of onsite/Off-Shore resources.
• Real-Time 360° Customer View/ Personalized offerings /Risk Management / Customer Segregation/ Customer Churn Analysis / Sentiment Analysis hashtag using social media.
• Managed Saks account by leading a team of BI functional & technical developers/analysts to develop a vision, strategy and roadmap for SAKS BI Retail Analytical System.
• Conducted workshops/interviews with Saks subject matter experts for analytical and operational reporting requirements. Created a gap document by analyzing the Out of the box retail analytical system and Saks reporting requirements.
• Delivered a strategy and road map to take SAKS BI from current state to future state architecture.
• Conducted feasibility of Reports and Dashboards and provided technical and functional guidance to the SAKS technical team by developing mockups on the key reports.
• Developed custom OBIEE reports for MFP module.
• Created technical ETL mapping document for custom reporting requirements.
• Developed custom subject areas and custom star schemas for custom reports by utilizing the conformed dimensions.

Confidential

Responsibilities:

• Installation and configuration of OBIEE11g on Linux/Windows 2008 environments.
• Infrastructure and Strategy design for OBIEE11g for custom financial and payroll DataMart.
• Implemented single sign on (SSO) and SSL with Iplanet LDAP Server with Verisign SSL Certificates.
• Designed storage and partitioning strategy for various Datawarehouse’s and DataMart’s.
• Designed and implemented OBIEE Caching Strategy for better performance.
• Designed and created aggregate tables/materialized views and configured OBIEE repository to use the aggregate Tables for better performance.

Data Modeler/Data Architect/BI Architect

Responsibilities:

• Managed BI group and associated cross-departmental team of onsite and offshore and delivered a custom reporting module for Confidential Aviation.
• Provided vision and design of a robust advance supply chain management business intelligence warehouse/system unique to Confidential Aviation requirements.

Confidential

Sr. Principal Consultant/Solution Architect - Oracle BI

Responsibilities:

• Implemented HR Analytics with custom extensions.
• Involved in optimizing the datamart and created index organized tables for efficient query and application performance.
• Responsible for guiding, creating, and maintaining custom PL/SQL packages, functions, procedures and cursors.
• Involved in extraction, cleansing and integration of data from different data sources.
• Implemented Financial Analytics with custom extensions at Confidential ’s UTI.
• Designed and configured security with SSO with EBS financials and Microsoft ADI.
• Managed BI team in the design, development and implementation of Operational financial reports.
• Converted key discoverer reports into OBIEE.