Solution Architect/sr Lead Resume
SUMMARY
- Over 16 years of experience in Data Management with expertise in end - to-end solutions in implementing and supervising Data Governance, Master Data Management and Cloud Data Architecture along with PII, GDPR and CCPA regulations act.
- Interacted and worked with diverse levels of management ranging from CxOs, VP, Business Heads along with Data Stewards, Architects, and IT Professionals in implementing Data Governance Practice, Master Data Management and Data Architecture solutions.
- Mentor for Data Governance and Master Data Management to managers, project managers - and leaders. Coach others and encourage them to take ownership of their development.
- Worked in various capacities and involved in strategizing data management process, defining Blueprint Planning, Deriving Roadmap, Data Strategy Planning, Current and Future State of Data, Gap Analysis, Target Operating Model, Metadata, Data Lineage, Data Lakes for M&A (Mergers & Acquisitions) initiatives.
- Certified Big Data, Master Data Management and Data Governance specialist.
- Facilitated deep technical and functional discussions with customers, partners, and internal technical teams. Acted as a Mentor in Data Governance and Master Data Management initiates.
- Hosted training sessions and seminars in Data Governance and MDM on customer onboarding and regulations.
- Able to make direct impact to business outcomes by architecting end-to-end solutions for customers with data management program and cloud platform.
- Well versed in enterprise technology buying and evaluation processes paired with strong understanding of large-scale computing solutions and experience building, architecting, designing, and implementing highly distributed global cloud-based
- Defined Data Ingestion, ETL/ELT process design documentation, business glossary, data security standards and data privacy techniques.
- Proven track record in Project Management in Traditional Methodologies and Agile Methodologies
TECHNICAL SKILLS
Data Management: EDC, Collibra, Alation, Power Center, IDQ, Informatica MDM, Oracle MDM and IBM MDM
Project Management: MS Office Suite, JIRA, MS Project, MS Teams, MS Visio, Lucid chart, and Agile Methodologies
Databases/Tools: Oracle, SQL Server, NoSQL, Oracle, ADW, HBase, Snowflake, RedShift, Azure SQL, Teradata, DB2, SAP, Hana, Oracle ERP, OIBEE, SFDC, Glue, S3, EMR, Kinesis, Stitch, RDS, Aurora, Devops, Hadoop, DynamoDB, Jenkins, GitHub, BigID, One Trust, IICS, Informatica, Talend, Kafka, Spark, ADF, Databricks, Tableau, Qlik, Power BI, OTBI, DNB and Bloomberg
Cloud Platforms: AWS, Azure and Oracle
Languages: Java, Python, PL/SQL, T/SQL, VB and PB
Project Management: MS Office Suite, JIRA, MS Project, MS Teams, MS Visio, Lucid chart, and Agile Methodologies
PROFESSIONAL EXPERIENCE
Confidential
Solution Architect/Sr Lead
Responsibilities:
- Oracle Cloud, Oracle ERP, AWS, Redshift, S3, EC2, Glue, SFDC, Jira, SFDC, Oracle MDM, Erwin, SQL Server, JSON
- Conducted Global Design for Oracle Cloud ERP, Cloud Data warehouse, Customer and Product and Location domain integration with SFDC, Oracle ERP and SAP applications.
- Closely interacted with Vendors, business leads and users and internal teams to make sure every process goes smoothly tracking the program management developments in migrating legacy applications into the cloud environment
- Designed data architecture to migrate MS SQL Server to Oracle Autonomous Data warehouse
- Integrated MDM with Oracles Sales cloud, Order Management, CPQ, Subscription Management and Financial, HCM and OTBI reports.
- Designed and configured MDM hub, match and merge rules, MDM solution architecture for downstream/upstream applications for Oracle Cloud ERP, SFDC and SAP environment.
- AWS, Snowflake, Oracle, SAP, MDG, SFDC, DNB, IDQ, MuleSoft, Informatica, Erwin, SIF, BES, Collibra, Tableau, Jira, JSON and MS Office
- As a Lead for enterprise customer analytics and insights involved in defining the Data Architecture, ETL/ELT architecture for Data Lake and Cloud Data warehouse in migrating the legacy systems into cloud environment.
- Designed solution architecture for automation of customer and product data integration across the enterprise as part of digitalization program.
- Involved in migration of legacy data warehouse into cloud data warehouses.
- Defined data management standards and MDM as part of Data Governance program.
- Closely interacted with Vendors (both onsite and offshore), business users and internal teams to make sure every process goes smoothly tracking the program management developments
- AWS, Redshift, EC2, Athena, Glue, Informatica MDM, Erwin, Oracle, SQL Server, JSON, MuleSoft, EDC, Jira, Tableau, SFDC, IDQ and DNB
- Conducted MDM and DG workshops and sessions to assess current and future state analysis to define MDM target-oriented model, MDM strategy, road map for customers 360 view and products in retail and wholesale banking industry improvements and saved multi million dollars.
- Defined Data Quality Framework and data quality processInvolved in solution architecture for data integration, customer data analytics for wholesale and retail banking customer consolidation across the banking applications.
- Designed and implemented technical and business metadata and data lineage.
- Designed framework process for customer onboarding/offboarding.
- Worked with Closely interact with Vendors (both onsite and offshore), business users and internal teams to make sure every process goes smoothly tracking the program management developments
Confidential
Sr Data Architect and Sr Manager
Responsibilities:
- IBM MDM, SQL Server, ER Studio, Guidewire, SAP, SFDC, QualityStage, ADS, AWS, Redshift, HBase, Linux and Tableau
- Worked within the Enterprise Architecture team to lead a Customer MDM and Product MDM effort responsible for the design and implement of Insurance’s Customer Master Data Management hub and Product Data.
- Defined data quality processes and data quality rules.
- Strengthened company’s business KPIs by leading customers end-to-end touchpoints.
- Designed and developed technical metadata management.
- Migrated legacy data warehouse to cloud data warehouse for customer, policy, and claims
- Managed Data Management staff and leads projects/studies/ initiatives to achieve departmental quality/time/cost objectives. Built teams by different talent and skills by requirements and manpower requirements and involved in hiring process.
- Lead the Data Architecture Team in evaluating Vendor and Products Evaluations and Selection.
- Informatica MDM, TOAD, Power Center, Oracle, SAP, SFDC, DB2, DNB, Java, and MS Office
- Provided technical management for definition, estimation and delivery of data modeling, configuration, and integration
- Maintain corporate master data management policy and recommend changes to management as necessary
- Created roadmaps that set a direction for managing the organization's portfolio of "to be" and "as is" solutions that deliver cost-effective, reusable, and flexible solution Data Architecture solutions.
- Informatica Power Center, Erwin, Model Mart, SQL Server, DB2, JBoss, and Cognos
- Prepare GAP Analysis, analyzing the GAP Analysis to improve the existing process of Data and Schema Management
- Designed and tested existing schemas and re-engineered OLTP and OLAP schemas. Coordination with the ETL & Reporting Development team with Design/Development approach to create a DataMart and Data Integration from source systems into Operational Data Store-ODS
- Implemented data architecture and party data model for Patient and Provider Master Data Management Domains by interacting with business heads and data stewards. Worked extensively with Data Quality, MDM Hub
- Worked with DBA's to get the Database design approved and implemented
- Timely communication to the Project participants and management team about the progress
