Home

Naveen - Snowflake/ETL/Data architect/Data warehouse)

[email protected]

Location: Cumming, Georgia, USA

Relocation: YES

Visa: H1B

Naveen Mandala . [email protected] +16787127608 PROFESSIONAL SUMMARY Data Architecture and Enterprise Data Warehouse (EDW) leader with 15+ years of experience in Data Modeling, Data Analysis, ETL development, and enterprise analytics platforms. Extensive experience designing and implementing cloud data architecture solutions using the Snowflake Data Platform and AWS, enabling scalable enterprise analytics and reporting environments. Strong expertise in dimensional modeling including Fact and Dimension tables, building scalable data models to support enterprise BI reporting and advanced analytics. Proven experience implementing data governance, data reconciliation, and data quality frameworks ensuring accurate reporting and trusted enterprise data assets. Skilled at working with business stakeholders and technical teams to translate requirements into scalable analytics platforms through strong stakeholder management and Agile delivery practices. Hands-on experience implementing Big Data analytics using Hadoop ecosystem technologies including Hive, Pig, MongoDB, Cassandra, Pentaho, Splunk, and Alteryx. Expertise designing interactive dashboards and enterprise BI reporting solutions using Tableau and Power BI, delivering actionable insights to business users. TECHNICAL SKILLS Data Modeling Tools Erwin 7.x/9.x, ER/Studio, Oracle Designer2000, Dimensional Modeling, Fact & Dimension Tables, Data Mart Design, Enterprise Data Warehouse (EDW) Modeling ETL Tools Informatica PowerCenter 8x/7x/6x, SQL Loader, SQL Server Integration Services (SSIS), Informatica Intelligent Cloud Services (IICS), ETL Pipelines, Data Integration Databases Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008/2012, Sybase, MySQL, MS Access, SAP HANA, Teradata, Snowflake Data Platform, Redshift, HBase, MongoDB Languages C, SQL, TSQL, PL/SQL, Python Case Tools Erwin, ER Studio, TOAD, PL/SQL Developer, BizTalkServer2010. Job Scheduling Tool &CM Control-M, Harvest, Zena, Workflow Scheduling, Batch Processing Legacy AS/400 Oracle Tools Oracle Forms, TOAD, PL/SQL Developer Other Tools Rational Clear Quest, Rational Clear case, Splunk, Data Zen ,ALM Data Analysis Paxata, IDQ, Data Governance, Data Quality, Data Reconciliation, Data Validation BI Tools Power BI, Tableau 9.x/8.x/7.x/6.x, Oracle Reports 2.5/6i/9i/10g, Hummingbird BI Query, Tibco Spotfire, BI Reporting, Executive Dashboards Big Data Ecosystem Hadoop, Hive, Zena, Jira, Pentaho, Hbase, Pig, Spark Cloud & Data Architecture Cloud Data Architecture, AWS (EC2, S3, EMR, RDS), Snowflake, Data Warehousing, Enterprise Data Warehouse (EDW) PROJECT EXPERIENCE VERIZON WIRELESS Atlanta, GA Project Lead Sep 2019 Present Designed and delivered end-to-end Data Integration and Enterprise Data Warehouse (EDW) solutions, including development, testing, deployment, and production support. Led development of ETL pipelines using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) to ingest data from flat files, APIs, and relational databases into Snowflake and cloud data warehouses. Designed dimensional data models including fact and dimension tables to support enterprise BI reporting and analytics platforms. Reviewed ETL code and architecture to ensure performance optimization, data quality, and adherence to data governance standards before deployment to production. Implemented data validation, reconciliation, and cleansing frameworks using Informatica Data Quality (IDQ)including fuzzy matching, address validation, and data standardization. Developed complex Informatica mappings using transformations such as Lookup, Aggregator, Router, Expression, Sequence Generator, and Stored Procedures to implement advanced business rules. Optimized ETL workflows using dynamic caching, parallel processing, and memory tuning, significantly improving performance and reducing processing time. Built real-time and batch data integration services using REST APIs, SOAP services, and Informatica Cloud integration tasks. Migrated legacy on-premise ETL pipelines to cloud-based architecture using Snowflake, AWS S3, and Informatica IICS, enabling scalable analytics workloads. Developed ingestion pipelines converting JSON, XML, CSV, and WSDL data sources using Apache Spark and loading into Hive and Snowflake environments. Improved application performance by optimizing web service processing from 900 milliseconds to 34 milliseconds. Built automated scheduling and orchestration workflows using UNIX shell scripts, PMCMD, and cron jobs. Led SQL Server to Snowflake migration, implementing multi-cluster virtual warehouses and data sharing across enterprise analytics applications. Provided guidelines to DevOps teams for cloud data migration strategies and data pipeline deployment. Collaborated with engineering and business stakeholders to deliver scalable cloud data architecture solutions supporting enterprise reporting and analytics. Environment: Informatica PowerCenter, Informatica IICS, Informatica Data Quality, Snowflake, AWS (S3, EC2, EMR, RDS), Spark, Hive, Python, SQL Server, Redshift, Unix Shell Scripting. National Science foundation -NSF Virginia, USA Sr. Data Architect / IT SPECIALIST Nov 2017 Aug 2019 Designed logical and physical enterprise data warehouse (EDW) data models and established data modeling standards and SOPs. Led migration and upgrade of ER/Studio data modeling environment, improving modeling efficiency and governance practices. Translated conceptual models into scalable physical database designs supporting enterprise reporting and analytics platforms. Improved processes for managing data model change requests, documentation, and version control. Facilitated architecture workshops and whiteboard sessions with stakeholders to align data architecture with business requirements. Qbe Insurance WI, USA Sr. Data Architect Feb 2017 Nov 2017 Defined enterprise data architecture strategy and governance framework supporting insurance analytics platforms. Designed integrated policy and claims data layers enabling enterprise reporting and business intelligence initiatives. Documented architecture standards translating logical data models into physical database implementations. Acted as liaison between business stakeholders, data governance teams, and engineering teams to align analytics solutions with business needs. Developed migration strategies transitioning AS-IS legacy systems to modern enterprise data architecture. Blue Cross Blue Shield Chicago, IL Data Architect /Solution Lead Aug 2016 Jan 2017 Designed architecture solutions and common enterprise data models for healthcare analytics platforms. Built data pipelines using Alteryx and SQL Server to integrate multiple data sources for analytics and reporting. Developed Tableau dashboards and BI reporting solutions supporting healthcare operations and business insights. Led onsite and offshore teams delivering data integration, ETL pipelines, and analytics dashboards. Conducted data analysis on EDI 835/837 healthcare transactions to generate operational insights. Collaborated with business stakeholders to define data mapping, cleansing, and transformation rules. Environment: Hadoop, Hive, Alteryx, SQL Server, Python, Tableau, Teradata, Erwin, Jira Cox Automotive (Manheim) Atlanta, GA Senior Data Modeler /Data Analyst Nov 2014 August 2016 Developed conceptual, logical, and physical enterprise data warehouse models supporting analytics initiatives. Created data dictionaries, metadata documentation, and mapping specifications for enterprise reporting systems. Implemented data governance workflows to improve data quality and data asset management. Built Tableau dashboards and analytics tools enabling business teams to monitor operational KPIs. Partnered with stakeholders to gather requirements and translate them into scalable data solutions. Participated in Agile development processes including sprint planning, demos, and retrospectives Environment: AS/400, Oracle 11g, Informatica Power Center 9.5.1, IDQ, Tibco 5.6.2.5, Splunk, My Sql, Erwin. MS Sql Server 2008, Hadoop, AWS, PIG, Python, Hive, Tableau. Bright House Networks Tampa, FL Data Architect / Senior Data Analyst May 2014 Nov 2014 Led historical data migration project supporting enterprise data warehouse modernization. Conducted data profiling and validation to ensure consistency and quality of legacy system data. Designed logical and physical data models supporting billing and analytics systems. Developed ETL scripts to extract and load data from legacy systems into modern EDW environments. Performed metadata testing, data validation, and mapping verification to ensure accurate data migration. Environment: Windows 7.0, AS/400, Sybase, ALM, Informatica ACE Smart Care Orlando, FL Technical Manager / Architect Jan 2013 - May 2014 Designed enterprise data architecture and ETL frameworks for healthcare analytics platforms. Developed multidimensional schemas and data marts supporting business intelligence reporting. Built data integration gateway connecting external healthcare data providers to internal systems. Led architecture reviews and provided technical leadership to development teams. Conducted stakeholder meetings to define business processes and data requirements. Environment: Windows 7.0, Oracle9i, UNIX shell scripts, SQL*Loader, MS SqlServer 2008, Net Framework 4.0, Windows workflow Foundation 4.0, Erwin, Oracle 10g PEP-HIPAA 5010, Orlando Health Orlando, FL Data Architect /Senior Data Modeler Oct 2011 - Dec 2012 Provided architecture leadership for HIPAA 5010 compliance data integration systems. Designed conceptual, logical, and physical data models for enterprise healthcare portals. Led development lifecycle including planning, architecture design, and risk management. Mentored development teams and led customer architecture and status meetings. Environment: Windows 7.0, Sql Server 2008, .Net Framework 4.0, SilverLight4.0 Windows workflow Foundation 4.0, Erwin, BizTalk Server 2010, Visual Studio2010 AFP EUROPE Lancaster, PA Data Architect /Senior Data Modeler Nov 2010 - Oct 2011 Led architecture and system integration initiatives for enterprise analytics platforms. Designed enterprise data models and ETL frameworks supporting reporting applications. Managed development lifecycle including project planning, architecture documentation, and delivery. Mentored development teams and conducted architecture reviews Environment: Windows 7.0, Oracle 10g, SQL Server 2008, .Net Framework 4.0, SilverLight4.0 Windows workflow Foundation 4.0 , Erwin, BizTalk Server 2010,Visual Studio2010 EDUCATION Kakatiya University Warangal, India Bachelor s in technology (B. Tech) Keywords: cprogramm business intelligence sthree information technology microsoft mississippi procedural language Florida Georgia Illinois Pennsylvania Wisconsin