SUMMARY:

• Attentive thinker and results - oriented technology enthusiastic with breadth and depth of experience in software development, automation processes, and organizational development. Key strengths include utilizing my entrepreneurship mindset, efficiency, and best practices
• Take new approaches to expand business and product capabilities. Effectively align goals, development, and implementation strategies to promote organizational objectives and ensure exceptional, on-time completion of projects. Foresees and plans for possible risks/contingencies with a keen ability to shift priorities and bring flexibility to dynamic situations.

TECHNICAL SKILLS:

Data: Analysis, Collection, Integration, Migration, Cleansing, Quality, Storage, Distribution, Visualization, analytics, Metadata management, Master data governance, Data modeling, ML modeling.

Environment: Cloud, On-prem, Internet, Intranet, Client-server, MPP/Distributed computing/Data Lake/Data warehouse, DataMart.

Applications: Products, Tools, BI, Analytics ML/AI, Data-driven applications, Data pipeline (ETL/ELT//Lambda), Enterprise Datawarehouse EDW, Data Lake, Datawarehouse, Datamart, Analytics, Reports, KPI's, Scorecards.

Data Structure: RDBMS, MDDB, Structured, Unstructured.

Data Modelling: - CDM, LDM, PDM, Star-schema, 3NF/CIF, Data Vault.

Security: Data-driven PII, Data, Applications, Objects, System.

SDLC: Discovery, Requirements gathering, Discovery, Analysis, Develop, Test, UAT, Package, Release, Deploy.

Technology: SQL Server, Snowflake, Netezza, MS PDW/SDW, Hadoop Stack, Synapse, SSAS, Power BI, SSRS, Excel, Tableau, SharePoint, Looker, SSIS, dbt, ADF, Visual Studio, Airflow, SQL, Python, MDX, DAX, C#, VB, JavaScript, VB Script, .NET, GitHub, TFS, JIRA, YAML, JINJA, Confluence, Erwin, Visio, Azure, AWS

PROFESSIONAL EXPERIENCE:

Independent Consultant Architect/Dev

Confidential

Technology: SQL DW, SSAS, Power BI, Netezza.

Responsibilities:

• I quit Microsoft and became an independent consultant to explore multiple domains.
• Played multiple roles in various projects as a product manager, project manager, program manager, dev, and architect
• Product Owner: First GUI-based SAAS/PAAS data pipeline tool for bigdata DevOps. Marketing platform for competitive analysis.
• Project/domain: Taxonomy ML data platform, Customer/Product support data, Retail data, Finance data, HR data, Supply chain, Hospital/Patient data, Datacenter data, more than 20 end-to-end reporting systems, including heterogeneous data pipelines, storage, distribution, visualization, data quality, and governance.
• Assembled and managed strategic teams on-demand basis by bringing members from geographically dispersed companies, including C-level members.
• Earned loyal employees by ensuring employees possess adequate training to meet and exceed job responsibilities, recognized, rewarded them appropriately, and treated them with empathy.
• Managed diverse projects at the client site: Removed ambiguities by providing clear responsibilities, escalation paths, templates, and made people accountable to achieve the results and deliver well-documented projects.

Confidential

Architect, Development Lead, Sr Application Developer

Responsibilities:

• Project management/analysis/architecture/design/development/delivery.
• Extensive work experience in data-focused applications, data Modeling and architecture, CDM/LDM/PDM, ETL/ELT Design/Process, Metadata Management, OLAP, Multidimensional cubes, OLTP, Data Dictionary, Data Governance Data Quality, Data profiling, Data Security, Application Health, Application Monitoring, Master Data Management, Data archive, and data visualization.
• Being one of the first people to introduce new and out-of-box ways of solving problems which solutions became popular
• In 1999, I created catalog-based data access to address memory and performance issues.
• Motivated and developed the first metadata-driven ETL/ELT automation with an orchestration engine dat extracts, transforms, and loads data from heterogeneous sources for Microsoft using worldwide distributed data. A dedicated team enhanced this ETL/ELT engine, and multiple groups have still used it within Microsoft coz of the stability and flexibility of this engine, a.k.a. Metal.
• Designed and implemented a data-driven Global Data Security for Microsoft to overcome worldwide PII government regulations. This data security system handled matrix rules based on different PII regularity of international governments and complex geographically dispersed multi-level reporting personals requirements.
• Introduced a new application architecture for data warehouse/ETL design: Configurable metadata-driven Procedure/SQL Server Objects/SQL Jobs/SSIS packages, which can be created dynamically on the fly or created and stored to adopt rapidly changing business demands. Introduced metadata-driven switches to track different types of SCD/history tracking. Introduced ID factory and interface views to enable dynamic business/data transformation rules. This approach still exists within Microsoft.
• Designed and developed an automated, self-correcting built-in-intelligence data health and data quality system to monitor data processing systems from heterogeneous data sources. This tool also TEMPhas AI algorithms, and it can detect and predict anomalies and ETL failures, including processes.
• Implemented Microsoft's first's cloud data warehouse and analytics system on cloud and on-prem servers by collecting usage data of Microsoft's worldwide datacenters for the Microsoft Azure Service Intelligence group.
• Designed the first GUI-based drag and drop ELT data processing tool on the Hadoop ecosystem.
• Designed a marketing platform for a marketing campaign with competitive analysis and sentimental analysis using competitors' data, social media and web data, demographic data.