SUMMARY

• As an Enterprise Data Architect, I have designed and modeled the Enterprise Data Warehouse and Data Marts OLAP and MDM and other OLTP Systems both in Cloud and on premise. Defined standards for Data Modelling, Migration, Conversion, Message Ingestion, Message Publication and Database Designs.
• As a Data Engineer and Solutions Architect, I have designed and built multiple Data Marts to help business in Business Intelligence and Analytics, designed and implemented strong Auditing, Logging and Housekeeping processes for ETL and ELT processes. Provided timely Solutions and Architectural inputs, creation and maintenance of Enterprise Architectural Diagrams and Design Disaster Recovery Strategies.
• Have worked on various new Cloud Technologies Snowflake, Azure, AWS and GCP and have implemented various cloud solutions for the clients.
• As a Project/Program Manager, I have managed and lead teams having members in both onsite and offshore from various technologies and vendors.
• As an MDM consultant implemented MDM and provided MDM solutions for the client.
• As a Data Analyst have extensive experience using ANSI/PL SQL and have worked in multiple Databases and done multiple complex data corrections in Production during critical escalations, on the fly.
• As a Domain and Process Consultant, have worked on various activities such as requirement analysis and solution recommendation, conducting client workshops, requirements gathering, documenting functional specifications & use cases, participating in design sessions, and authoring standard operating procedure documents.
• As a Mainframe Analyst/Developer have designed and built complex Cobol Programs.

TECHNICAL SKILLS

• Merchant Acquiring
• Credit Card Processing
• Retirement Business
• Investments
• Data/Solution Architect
• Data Engineer
• Data Analysis
• Data Profiling
• Data Science
• Data Modeling
• Erwin
• Power Designer
• Data Vault 2.0
• Dimensional
• Project Management
• Business Intelligence
• Master Data Management
• EBX5
• UNIX
• R
• Python
• Databases
• Oracle
• Netezza
• Sybase
• Microsoft SQL Server
• DB2
• MongoDB
• CouchDB
• Neo4j
• ANSI SQL
• PL SQL
• Tableau
• Hive / Hue / Impala / Hadoop
• HBase / Pig / Spark / Kafka
• Cloud Technologies
• SNOWFLAKE
• AWS
• EC2
• S3
• RDS
• AWS Data Pipeline
• Lambda
• AWS Glue
• Redshift
• Aurora
• Athena
• DMS
• IAM
• GCP
• Cloud Storage
• Compute Engine
• Cloud Dataprep
• Cloud Dataflow
• Cloud Functions
• Cloud SQL
• BiqQuery
• Azure
• Blob Storage
• Virtual Machines
• Azure SQL Database
• Data Factory
• Data Bricks
• Azure Functions
• Synapse
• Cosmos DB
• Agile Tools
• Version One
• JIRA
• Confluence
• Bit Bucket
• CI / CD
• CA Harvest SCM Workbench
• Schedulers
• Autosys
• CA7
• ETL Tools
• IBM DataStage
• Informatica
• Ab Initio
• Visio
• PowerPoint
• Mainframe
• COBOL
• JCL
• VSAM
• DB2
• CICS

PROFESSIONAL EXPERIENCE

Confidential, Springfield, MA

Responsibilities:

• Leading conversations/meetings with various Business Teams, Application Development Teams, Data Engineering Team and Data Team to resolve issues as well as conflict of interests and arrive at an optimal solution for the program.
• Identifying current state and future state processes and provide strategic and tactical solutions based on the program timelines.
• Providing solutions for Data Management involving Data Architecture, Data Modeling, Data Governance, Metadata Management, Data Security, Data Integration and Data Quality.
• Introduced and implemented the concepts of Reference Data and its Management, Product Data and Party in Mass Mutual.
• Evaluating current Datawarehouse implementation of Teradata FSLDM In Aurora and identifying issues and areas of improvements and create a plan for the redesign.
• Evaluating Snowflake and Apache Couch Database as part of redesign to replace the current Datawarehouse implementation.
• Evaluating NoSQL Data Modeling tools.
• Azure and GCP POC Initiatives.
• Designing Data flow and other architectural diagrams and leading conversations along with Enterprise Architects in explaining the solutions to various teams.
• Managing and Prioritizing Epics and User Stories as part of PI planning.
• Establishing standards for Data Modelling, Date Model Documentation, Metadata Management and Data Model Versioning and Change Management Process using Model Marts standards for the team.
• Designing code generators that can be reusable for Data Engineering team while loading data and for the application team in generating triggers for auditing and Public ID generation.

Confidential, Atlanta, GA

Project Manager

Responsibilities:

• MDM tool Evaluation and Implementation of EBX5 for the client.
• Conduct Technical Interviews to add New Resources to the Team.
• Analyzed and brought in multiple Legacy Data Sources and External Reference Data for MDM.
• Designed and Modeled the Normalized MDM Data Model for Person, Partner, Products and Customer for OLTP using Power Designer and Erwin.
• Prepare Conceptual, Logical and Physical Data Models and Data Flow Diagrams.
• Define Data Modeling Standards, Naming Convention, Mapping Documents.
• Lead the MDM Data Architecture Team.
• Implemented the Data Model in EBX5 and designed the Batch and Online Process for Data Ingestion and Publishing.
• Provide various solutions to ingest/maintain/publish data for MDM application from SFDC.
• Designed and Built ELT Process, Bash Scripts and Autosys Jobs to Load MDM from Legacy Systems and External Reference Data Sources.
• Created Complex SQLs in extracting Custom Reports, Data Analysis and Complex Data Correction in Live Production Environment in Oracle.
• Built all the Database Objects Required for Batch Loading of MDM in ELT approach and for Strong Auditing and Housekeeping Activities.
• Invented a Scalable Dynamic SQL generator to load MDM from Source Data Views.
• Performing Scrum Master Roles, conducting Backlog Refinement and Story Grooming, Sprint Planning, Daily Scrum/Standups, Mid Sprint Review of Stories, Retrospectives, Demos for the Program Increment.
• Assisting Java team in implementing various complex validation rules in our MDM tool EBX5.
• Cleanse, Match and Merge Data in MDM and using SQL.
• Evangelize use of MDM Cleansed Data and Normalized Data Models to Various Teams.
• Helping Admins in Installation of Oracle/Java/ WGET in Linux/Unix/Solaris Servers
• Helping DBA in Performance Tuning and Load Balancing of the Batch Process and SQL Queries.
• AWS and SNOWFLAKE POC Initiatives

Confidential, Atlanta, GA

Responsibilities:

• Managed and Lead the ETL, MDM and Data Analysts team.
• Architected the end to end solution for the implementation of the Merchant Data Warehouse for Confidential .
• Analyzed and brought in multiple Data Sources for the Enterprise Data Warehouse (EDW) in Data Vault 2.0 and Data Marts using ELT/ETL.
• Data Modeled EDW in Data Vault and Dimensional Modeling for OLAP using Erwin.
• Data Modeled Staging Layer in Data Vault using Erwin.
• Re - engineered the warehouse to use Source Staging Tables and ELT approach instead of using Data Vault because the Load process using ETL tool Ab Initio was slow.
• Define Data Modeling Standards, Naming Convention, Mapping Documents,
• Prepare Conceptual, Logical and Physical Data Models.
• Defined business solution for the to be state solution and documented the High-Level Business needs for various Projects.
• Designed and Built Data Marts for the Users to track Products, Pricing, Revenue and Sales Activity associated with Merchants for Analytics and for Commission Calculation for Salespersons.
• Designed and Built ELT Process, Bash Scripts and CA7 Jobs to Load Data Warehouse and Data Marts.
• Built the entire Data warehousing SQL Scripts and Processes for loading all Relational Dimension, Facts and Data Marts using ELT approach.
• Created Complex SQLs in extracting Custom Reports, Data Analysis and Complex Data Correction in Live Production Environment in multiple Databases Netezza, SQL Server, DB2.
• Used Tableau to build Dashboards from the Data Marts.
• Setup Data Lake in Hadoop to land transaction files and used HIVE, PIG, IMPALA for access and data analysis, to aggregate the data needed to be brought into the Data Marts.
• Compiled BRD, Functional Specifications, RTM.
• Documented use cases, business process flows and system process flows.
• Conducted user interview and requirement elicitation sessions.
• Creation of Project Plans, resource onboarding, Cost forecasts and validation of testing strategy.