● Spearheading the end-to-end design, implementation of and migration onto a Cloud Enterprise DataWarehouse on Snowflake, orchestrating every aspect from conceptualization to execution.● Established and enforced rigorous Data Architecture and development standards, elevating operationalefficiency, and ensuring alignment with organizational goals.● Formulated comprehensive Data Governance and Security frameworks, encompassing robust principles tosafeguard sensitive information and maintain compliance standards.● Executed the integration of Cloud infrastructure security measures, including Single Sign-On (SSO)integration across Snowflake, Fivetran, and Azure platforms with Okta, fortifying data assets against potentialthreats.● Architected and implemented Cloud EDW Snowflake security model further advancing data security withinCloud Datawarehouse.● Directed the entire lifecycle of EDW development, assuming responsibility for quality assurance andseamlessly integrating Data Analyst functions to optimize insights extraction.● Orchestrated Cloud infrastructure administration activities, managing Snowflake and Fivetran environmentswhile leveraging tools like Jira for streamlined project management.● Fostered collaboration with development teams, actively contributing expertise to Azure Data Factory (ADF)and Data Build Tool (DBT) pipeline development initiatives, ensuring seamless integration and optimalperformance.

Leading T-Mobile Data Architecture strategy, standards and design patterns, data storage, data modeling,data security, data quality and data access control as a member of Enterprise Data Architecture team.Collaborate with business engagement management, business, and technology teams to translate business requirements into technical specifications, create and maintain data dictionaries and data models.Design i360 Marketing Data Lake on Azure Databricks, customer PII collection from multiple front-line and billing systems and integration with external partners (Acxiom) to enable customer 360 identification across multiple brands and product lines. It enabled customized targeted marketing campaigns and decreased marketing budget spend by at least 20%.Design Finance Delta Lake, strategic enterprise project enabling new Customer Risk evaluation application. Itenhanced risk management models efficiency, cut credit losses, and improved revenue per customer.Performed comprehensive data analysis across pre- and post-paid data domains.Data Steward (Data Governance) – ensure data observability – data quality and lineage, metadata collection.Design Data Security Model to comply with CDR, CPNI data protection and GDPR and CCPA regulations.Design and implemented Metadata Search app on Azure Databricks (Python)Proposed and implemented Unified Data Acquisition Layer on Snowflake – minimized data replication,protected data, provided source-like clean data to various T-Mobile business units.Design Enterprise Data Mesh architecture and security model – enterprise-wide platform on Azure Databricks as source-like data repository and Snowflake as data presentation layer. It allows publishing cross-domain data faucets for business users in multi-cloud environment. Platform enabled one click request and access to data which improved customer experience.Concurrently handle 3-5 projects, supporting 15-40 Data Engineers.

DW/BI Architect/Developer, responsible for overall design and development of SaaS Analytical Products line - Life Sciences, High Tech, Rx, GPM, GTM and CPQ Products. Each Product comes as a packaged solution comprised of ETL (Informatica PC), Analytical Data Mart (Oracle/MySQL) and Visualizations Engine (Looker).Key areas of responsibility include:Product Architecture - Design, enhance and fix Model N Analytics Data and Visualization Foundation – installer, ETL and Analytics framework. Migration to Cloud – migrated on premise product architecture onto AWS, Informatica Cloud (Python and APEX REST API based framework for data management process automation) and developed Cloud Data security policies (Data-at-rest and in transit) for every product component level: database, cross component communications. Developed Product extension methodology which cut product upgrades/migration time by 30% which boosted customer confidence and satisfaction with our product.Product Development - Developed Data Model, Data Integration with SFDC and Visualizations. Designed and developed Product Analytical platform – based on generic ETL framework with customer specific DW (Oracle/MySQL), Informatica (ETL) and Looker (migrated off Qlik Sense).Rx Analytics - Integrated Analytics based on syndicated data from IMS Plantrak, Medimedia Formulary and WK Claims/CoPayR&D - Developed Spark/Python based Data Integration application as a low-cost alternative to Informatica Power Center. Various Data Management and BI tools evaluations.Customer, Professional Services, Cloud Operations Support - Enhanced Data Foundation framework to efficiently work in cloud environment – developed relevant and timely notifications to be sent from various ETL stages, and productivity enhancing tools. Triage and resolve customer issues.Solutions/Pre-Sales Support - Trained SEs, prepared visualizations and data for demos, provided guidance on demos environment maintenance

Solution Architect, Revenue Management Analytics, Professional Services, responsible for all technical aspects of project delivery – working with client on project-level to detailed business requirements, architect and deliver appropriate solution – Data Model, DW (Oracle 11g or MySQL), ETL (Informatica 9) and BI (QlikView 11) . Define and drive PS methodologies, processes and best practices. Work in coordination with Product Development and Product Management on delivering DW/BI client specific solutions while maintaining cross-client generic approach. Provide technical guidance to junior members of PS.Clients: STMicroelectronics (High Tech) - Quote and Price Analytics Evaluation and Alert platform. Designed and built Data Model, Alert SQL and evaluation process in PL/SQL, Oracle 11g R2 Amgen (Life Sciences) – product deployments and customizations, troubleshooting, capacity planning Merck (Life Sciences) – gathering and assessment business requirements, product deployments, configuration, customization and development, sizing and capacity planning, managing client relationship – onsite meetings, research and recommendations presentations, client training, data security, architecture SOX compliance, design, embedding product into client infrastructure. Micrel (High Tech) – product cloud deployment and configuration, resolving client issues.

Coordinated, planned and executed business and technical strategy defining Data Management – Data Acquisition, Data Quality, Data Validation and Aggregation processes, overall ETL process and reportingCreated Data Management framework supporting Dannon, Nestle, Kellog – provided 30% efficiency improvement to client facing Implementation Management team

Brada LLC was a consulting company providing DW/BI solutions focusing on small businesses and utilizing Microsoft BI stack (SQL Server 2008, SSIS, SSRS, and SSAS) and Microstrategy.• Managed accounts, customer relationship and satisfaction• Design BI platform architecture; Data Analysis and Data Modeling• Developed and formulated testing methodologies for data validation, verification, DDL consistency, data types and data precision in one comprehensive solution• Designed framework for testing cross- platform ETL process for Data Warehouse projects• Developed diverse reporting solutions (Microstrategy 9, SSRS 2008) providing insights facilitating better business focus and improving revenue• Promoted and fine-tuned business requirements through agile prototype developmentAccomplishments• Migrated BI platform from Oracle to Teradata infrastructure. Data and reports reverse engineering, re-architecture and porting. Resolving data quality issues. End user training on converted reports and data structures, overcoming user distrust in new platform• Data Mining/Statistical Analysis – customer retention and SNR analysis. Built and provided data to clients for efficient deal negotiations, developing efficient buying models essentially enabling buying more relevant content at a better price.• Business user support - ad-hoc reporting, data analysis, resolving data quality issues

Designed and implemented Call Center Analytics, Trust site Dashboard, Employee Utilization Analytics, Server Availability Metrics based on Microsoft BI stack – SQL Server 2008, SSIS, SSRS and SSAS• Designed and implemented first DW/BI platform. • Coordinated, planned and created business and technical vision and strategy shaping Business Intelligence• Data Management & Governance, Data Analysis, Data Modeling, Database design and best practices• Developed DW/BI solutions – ETL, cubes, reports, dashboards, alerts• Project management and communications with stakeholders throughout lifecycle• Organized presentations and demos to executive level sponsors• Drove and refined business requirements through Agile development and rapid prototyping.• Integration with SharePoint and Reporting Services and Analysis Services, managed user subscriptions• End user training on BI products and information understanding and usageProjects Call Center Analytics – Built ETL (SSIS 2008), report suite (SSRS 2008). New BI capability allowed company to establish Call Center SLA metrics providing competitive advantage Trust site Dashboard – provide Call Center metrics to public facing dashboard Client Dashboard – designed a BI solution for external clients Employee Utilization Analytics – designed a cube for Finance using SSIS/SSAS 2008 to provide transparency into employee utilization Server Availability Metrics – analytics for Clients’ servers’ availability metrics, enabled company to establish SLA around uptime metrics creating additional competitive advantage

Business Intelligence Development,Essbase Development and Data Analysis for Risk Management.Relationship management between Information Management&Delivery and Risk Management organizationsOptimize data delivery for Loss drivers search patternsPerform Business Analysis for projects supporting PayPal Risk Management function

Pay Pal Information Management and Delivery (IMD) team is a Business Intelligence organization provides and maintains data for business decision makers. It is an ongoing effort of building and maintaining PayPal Data Warehouse which is becoming integral foundation of everyday decision making at PayPal. Responsibilities include defining strategies, project management, resource allocation, business and technical requirements analysis in collaboration with BA, Project and Product Managers; ensure high quality and timely delivery of the product; QA environment maintenance . Created, trained and lead a team of five QA engineers. Solid understanding at an expert level the source, content, and definitions of data residing in PayPal’s Operational and Data Warehouse tables. Worked on SOX IMD compliance audit.

Performance optimization - collaborated with application and database development teams identifying and analyzing performance bottlenecks in application (JMS, JASS) and database (physical layout, I/O, memory, SQL queries and PL/SQL procedures)Developed data pruning/cleansing stored procedures (Oracle 8i PL/SQL).Wrote test cases for database performance and upgrade testing, determined optimal I/O and memory parameters for initial deployment in production environment.

Responsibilities - data warehouse ETL process, Data Integration Manager (DIM) and installer. Designed and executed test cases for all areas of primary responsibility as well as for other application modules. Wrote a Perl application to verify Java Internationalization (i18n) of the entire code tree. Played a key role in training QA and Professional Services team members on Data Mart/ETL testing procedures, product installation and configuration. Wrote, reviewed and provided feedback on technical documentation. Worked on Oracle Apps 11i installation for use as a seed database.

 Designed and developed automated regression test suite (functional, configuration, robustness and stress tests) in Ora*Tst language for MTS white box testing increasing test coverage from 50% to 75% Tested Oracle7/8/8i network components backward compatibility on Solaris2.6 and NT 4.0(SP3/4) Conducted network components cross-platform interoperability testing of Oracle7/8/8i database Server releases across SunOS 5.51, Solaris 2.6 and Windows NT 4.0(SP3, SP4 and SP5) platforms