SUMMARY

• Seasoned Sr. Principal Enterprise Data and DW Architect with 23+ years of IT experience in various technology stacks to provide cutting edge solutions within the Data governance framework including Data Architecture and Analysis, Database Development and Operations Management, Reference and Master Data Management, Data Warehouse and Business Intelligence, Metadata Management, Document and Content Management, Data Security Management and Data Quality Management, Big data and Analytics.
• Vast range of Industry domain experience including Banking and Finance, Accounting, Retail, Healthcare, Oil and Gas, Automobile, Logistics (Cargo Freight Station), Federal government and Insurance.
• Designed, Developed and Implemented many large - scale Enterprise Resource Planning (ERP) applications.
• Hands-on experience in Data Management, managing Information as an Asset, as defined by DAMA DMBOK.
• Strong implementation experience in Enterprise Data Warehouse & BI, Data Marts, ODS, ETL, OLTP, OLAP, MOLAP, ROLAP, Master Data Management (MDM), Reference Data Management and Metadata Management solutions.
• Expert in various Data Modeling techniques such as ER, Dimensional (Star and snowflake), Data Vault Models and NoSQL Data models such as XML and XSD, JSON.
• Expert in creating Enterprise Data models, Subject Area model, Canonical Models, Conceptual, Logical and Physical Models.
• Experience in Defining, Planning, Implementing and governing enterprise information architecture artifacts and Business Domain Capability Model in EA Repositories.
• Expert in conceptualizing, evangelizing Data management principles and initiatives.
• Experience in TOGAF Enterprise Architecture Framework, FEAF and familiar with Zachman framework.
• Experienced in Capacity Planning, Gap Analysis, Data Quality, Impact Analysis, Lineage Analysis, Documenting Baseline/Current and Target/Future state, Reference Architectures and recommendations.
• Experience in defining roadmaps and architecture blueprints for entire Data Lifecycle Management, collaborating with Data Quality and Stewardship groups to promote Data Quality, Integrity, Transparency, reusability, consistency, accountability, Stewardship, Standardization and Change Management.
• Experience in defining Data modeling standards and guidelines, templates, Data Dictionaries to enforce the enterprise standards across projects.
• Experience in architecture and development of Data Integration Interfaces and Services (SOA) and ESB, technology architecture protocols such as REST, SOAP, OData for interoperability between Cloud (AWS, Azure) and on-premise applications.
• Experience in cloud offerings such as Infrastructure as a Service(IaaS), Platform as a Service (PaaS), Software as a Service (SaaS), Data as a Service(DaaS).
• Experience in in-memory Oracle Exadata, NoSQL databases (Columnar Amazon Redshift, Graph and Key value), Composite data virtualization and Big Data (HDFS), TIBCO Spotfire Data Visualization, Splunk, BW HANA, Neo4J graph Database, Marklogic, Document MongoDB, Google Firebase (BaaS).
• Expert in on-premise to Cloud Data migration using AWS Cloud.
• Expert in Query and Application performance tuning, Database programming using PL/SQL, T-SQL.
• Hands-on experience in developing prototypes, POCs to demonstrate various tool capabilities to wider audiences.
• Hands-on Project Management and Leadership experience, worked on On-site Offshore Model and interacting with different cross-functional portfolio business units at all levels.
• Trained and practiced different System development life cycle (SDLC) methods, Six Sigma methodologies, CMMi & ISO standards, Agile SCRUM.
• Expert in developing database Row and Column level security solutions (PII & PCI, PHI compliance) using Oracle Real Application Security(RAS), Voltage and familiar with ABAC IAM solutions.
• Familiar with Oracle Advance Analytics, Python libraries such as Pandas, Matplotlib, Scikit Learn for Data Mining and machine learning, Disruptive technologies such as Blockchain, WorkFusion Process automation(RPA).
• Expert in transforming any raw data into meaningful information.
• Experience in On-premise to Cloud Data migration in cross account environments.
• Passion to learn new tools and technologies, capable of developing Android applications, Nodejs, HTML5, Vanilla Javascript.

TECHNICAL SKILLS

Databases: Oracle 7.3 thru Oracle 12c Exadata, MS SQL Server, Sybase, MySQL, Access, SQLite, ParAccel, Amazon AWS Redshift, Neo4J, CISCO composite server, Marklogic NoSQL, MongoDB, Google Firebase, Hadoop HDFS (Hortonworks, Cloudera, MapR), Cassandra, PostgreSQL9.6, AWS Redshift, Snowflake

Tools: Oracle PL/SQL, SQL, T-SQL, ERWin3.5 thru ERWin 9.8, Visio, ER/Studio, PowerDesigner, Unix, Windows, Cognos 10, Informatica Power Center 10.1, Informatica Data Quality(IDQ) 9.5 with Accelerators, Informatica MDM, Metadata Manager, Toad, Oracle Enterprise Manager, Data stage 7.5.1, MS Visual Source Safe 6.0, Monarch, Oracle Forms and Reports, Oracle Discoverer, Oracle Warehouse Builder, Business Object, Tableau, Qlikview, TIBCO Spotfire 6.5, TIBCO BW, TIBCO EMS, Voltage data encryption, Sparx EA, Troux EA, GitHub, Jenkins, Redgate, TortoiseSVN, Pega 6,Python 3.6, Java, Shell Script, Oracle Advance Security, Python, Android Studio, Gradle, Splunk, Docker Toolbox, Power BI, AWS, Apache Drill, Kafka, AWS DMS, Kinesis, Nodejs, Javascript, HTML5,CSS, Jenkins

PROFESSIONAL EXPERIENCE

Sr. Principal Enterprise Data Architect

Confidential

Responsibilities:

• Defined CMS-CCSQ(Center for Clinical Standards and Quality) Data Governance strategy and roadmap for AWS Cloud Data migration contract .
• Analyzed Databases, Data Models and applications documented dependencies and impacts, maintained an inventory of asset metadata in a searchable repository using SQL Developer Data Modeler in an innovative way.
• Conducted POC on FedRAMP certified products for Enterprise Application and Database monitoring, API Management, Data Migration, Data Governance and architecture, Data Backup and retrieval, Data security and de-identificatio n(PII, PHI Data), Cloud Data Warehouse and Data Lake.
• Presented current state and future state architecture artifacts, ideas to the Architecture Review Board (ARB) as well as Client’s Technical Review Board(TRB).
• Worked with the approved product Vendors, negotiated price and contract terms on behalf of the client that saved millions of dollars .
• Migrated huge volume of Healthcare data (Structured, Unstructured, semi-structured) using Snowball Edge, AWS DMS, Oracle Physical Standby and RMAN over a high speed AWS Direct Connect network in a Hybrid Cloud environment.
• Researched, conducted POCs and architected solutions using various technologies such as AWS Data Pipeline, AWS Glue, AWS Catalog, EMR, Athena, Spectrum, DMS, AWS SCT, Apache Drill, S3, Snowflake, Redshift, AWS RDS, SAS Viya, AWS QuickSight, AWS Kinesis Firehose, Lucidchart Cloud Insights, ERWin Data Governance, ER-Studio Data Architect, AWS Backup Service, ELB, Auto Scaling, Spark, SnowSQL, Snowpipe
• Configured IAM Users, Roles, Groups and Policies to securely control access to various AWS Resources for users and programmatic access.
• Migrated on-premise Enterprise Data Warehouse to the architected AWS Data Lake.
• Worked with the DBA, infrastructure, Network, Cloud team to implement New Relic, MuleSoft GovCloud API Management platform, Symantec VIP Multi-factor Authentication Solutions.
• Integrated New Relic with Splunk, ServiceNow, Slack, JIRA, Saviynt, Okta and AWS single tenant, Multi tenant accounts.
• A trusted advisor to the Director of Architecture and Deputy CTO.
• Closely worked with CMS-CCSQ Government Technical Advisors and Application Development Organizations(ADO).
• Worked with the proposal team to bid new contracts for Confidential Solutions.
• Conducted market research for new product development.

Sr. Principal Data and DW Architect

Confidential

Responsibilities:

• Defined strategy and roadmap for the WBG Data Privacy Program to address the GDPR compliance and other regulatory compliances.
• Successfully completed Data Protection Impact Assessment(DPIA) to identify the highly risky mission critical applications that store Personally Identifiable Information (PII) in various repositories such as Database, Data Models, Database Scripts, Metadata.
• Effectively collected Metadata/Data Models from around 100 systems across WBG and performed PII discovery and classified in short period of time using unique techniques to meet tight deadline.
• Prioritized the system for remediation based on the risk score and control category.
• Worked on PII data governance framework, GDPR and security control tools that are capable of Machine Learning and AI for discovery from unstructured and document based systems, Database, recommend them to the management for procurement and implementation as per the roadmap.
• Implemented ERWin Model Mart and established governance around Team Data modeling.
• Reviewed Investment Portfolio Data Models for new application re-engineering project.
• Defined access control rules for PlainID Attribute Based Access Control(ABAC) Tool.

Sr. Principal Data and DW Architect

Confidential

Responsibilities:

• Proposed and presented Party Canonical Model based on NIEM and reviewed with stakeholders to get buy-in to exchange party data with different systems across the organization that avoids the point to point mapping and improves overall data quality and better governance. This approach complemented the MDM implementation and, the technique followed helped onboarding more sources quickly.
• Piloted Canonical Model with a MDM architecture blueprint that consists of different components such as ESB, Web services (REST and SOAP), PL/SQL, and Composite Data virtualization.
• Data Architect for SAP BPC (Budget Planning and Consolidation) project modeling for SAP BW.
• Data Warehouse and BI architect for implementing Integrated HR Data Mart (HRIDR), defined Data Architecture, developed Data Modeling, SQL Performance tuning, ETL Architecture, Security Architecture and Reporting and Analytical Architecture.
• Integrated data for various HR Analytical Reports from core PeopleSoft HCM, Position Management, MyJobworld, ePerformance, Leave Management(LARS), Learning Management(OLC), Payroll and Pension, CISCO Voice, Visa and Driver’s License Systems by understanding HR operations Business process so quickly.
• The architecture framework followed drastically reduced the cost, implementation time, resource requirements and project risk. Delivered HR Data mart on schedule with a huge budget savings and reduced staff workload by 30%.
• Integrated cloud APIs using Informatica ETL to address token based authentication challenge, developed Java components to encrypt and decrypt the signature to call REST API data services using OData protocol.

Principal Data Architect/Sr. Manger Enterprise Data Architecture and Strategy

Confidential

Responsibilities:

• Responsible for Architecting a multi-tenant, Multi time zone, multi-currency and localized Horizon platform Data Model for Device Protection data platform to support Claim Management and Supply Chain Management.
• Took over and lead the Data architecture effort when the project was at risk and delivered Conceptual, Logical and Physical data models successfully in time in an agile (SCRUM) SDLC.
• Defined the Data Management strategy, roadmap for future state Horizon Real-time Data warehouse with the Directors of Enterprise Architecture and Strategy.
• Published Data Architecture articles and artifacts in Architecture insight EA Portal.
• Established and presented data governance for the entire program including Data dictionary, Business glossary, As-is and to-be processes, Domain Capability Model, Taxonomy, Standard and guidelines, Data definitions, Data quality, Data security, metadata management using InfoSphere repository.
• Piloted several Big Data components for Data Lake such as HortonWorks HDFS, ParAccel MPP columnar database, Amazon Redshift AWS, Cassandra, Neo4J Graph database, IBM Optim for TDM, Spotfire Analytics (churn analysis, enrollment, drops, adds and finance KPI reports) in a fast-paced environment.
• Database capacity planning, Database release management process through Continuous Integration tool Jenkins, maven and Redgate.
• Conceptualized and implemented Oracle 12c RAC Logical Standby and Active Data guard, Flashback Archive, Change Data Capture(CDC) for real time replication for transactional reporting that guaranteed zero data loss.
• Developed strategy for new client migration from legacy Microsoft Dynamics (DAX) supply chain management system to new platform.
• Collaborated with security architects to implement Voltage data security to encrypt PII data on-premises and cloud, Integrated Experian QAS address validation service for customer address verification and validation.
• Managed and Trained team of data modelers and database developers.