Senior Architect
Mindtree Ltd
Total years of experience :24 years, 2 Months
Responsibilities/ Accomplishments:
• Provided and Implemented solution to store, search, share, visualize, and analyze data
• Designed the framework for jobs in staging, mart and reporting layers
• Designed and developed real-time, bash and custom ETL jobs.
• Migration of data from Legacy systems by performing data validation, cleansing and profiling
• Developed and Implemented standards for Data Modeling and Development
• Design and Develop Data Migration tool
• Migration of data from Legacy systems by performing data validation, cleansing and profiling
• Performance Benchmark Testing for Clustrix 5.5 & 5.6 release
• Develop Script for validation and verification of data
• Developed and Implemented standards for Backward Compatibility and Scalability
Projects Undertaken:
• Strategic Identity Entitlement
• Data Migration Tool
• Central Enterprise Warehouse
• Integrated Data Store
• Identity Entitlement Metadata Repository
• Cirrus Database
• WS02 Database
• SAP Data Migration
• Clustrix 5.5 & 5.6 Release
Lead, define, and design cloud solution with technology SME for client discussions/workshops, and facilitates conversations to ensure stakeholder alignment on strategic cloud solutions
Design and implementation Framework for Errors tracking, monitoring and restartability of jobs
Provide solution for value proposition and transformational direction which build on the synergies and benefits across service offering
Managed stakeholder expectations and responsible for on-time delivery of quality solution for Signoff
Performance Benchmarking, Diagnostics, Capacity Planning and Sizing
Define and Develop Data Policy for structured and unstructured content
Responsibilities/ Accomplishments:
• Built common Database Integration patterns for Products Integration
• Provided and Implemented solution to store, search, share, visualize, and analyze data
• Categorized the product data as per Storage and retrieval pattern
• Developed and Implemented standards for Data Modeling and Development
• Developed and Implemented standards for Backward Compatibility and Scalability
• Built and Mentored team to support the LIVE website
• Created Script for checking and verification of data
• Analyzed and studied of the existing system
• Designed and Implemented Fraud Analysis Database
• Designed and Implemented Reporting Solutions
• Designed and Implemented Parcel Tracking Engine
• Design and Develop MDM Architecture, process flows and data models.
• Designed and Build Graphs, plans for processing data from source systems.
Projects Undertaken:
• Fraud Analysis Database
• Reporting Solution
• Parcel Tracking Engine
• General Merchandizing Online
• Change Program 2.1
• Change Program 2.0
Role: Data Architect
Responsibilities/ Accomplishments:
• Analysis and translate Business requirement into Solution
• Proposing Database Architecture for Projects
• Designed and Developed Metadata Repository
• Analysis and study of the existing system
• Reverse Engineering and Redesigning
• New features Recommendation and Implementation
• Resolving transaction segregation issues
• Responsible for creating and refining levels of categorizations for Data at Organization level
• Developed and Implemented standards for Database Development
• Defined and Implemented Data Security Methodology and data retrieval pattern
Projects Undertaken:
• Enterprise Warehouse
• Global Integrated Data Store
• Metadata Repository
• International Product Pages
• International Transfer Agency System Solution
Role: Database Architect
Responsibilities/ Accomplishments:
• Analysis and study of the existing Product
• Provided and Implemented solution to store, search, share, visualize, and analyze data
• OLAP Schema creation for Reporting System
• Database Migration to Oracle
• Categories the product data as per Storage and retrieval pattern
• Defined and Implemented Data Security Methodology and data retrieval pattern
• Resolving transaction segregation issues
• Defining Standard and Process
• Metadata Management
Projects Undertaken:
• Lorenzo Regional Care
• Lorenzo Care Management
• Lorenzo 2.0
Role: Database Architect
Responsibilities/ Accomplishments:
• Design and Develop Fraud Analysis Database
• Design and Develop Reporting Solution
• Build common Database Integration patterns for Products Integration
• Categories the product data as per Storage and retrieval pattern
• Managed Oracle database daily routine maintenance including standby database management, user
management, daily hot backup & weekly cold backup routine, storage management
• Develop and Implement the standard for Database Development
• Build and Mentor team
• Metadata Management
Projects Undertaken:
• AFS Oracle Migration
• Dual Card Automation
• Theatre Clipboard Portal
• Appointment And Scheduling
• Guest Fulfillment System
Role: DBA / Data Modeler
Responsibilities/ Accomplishments:
• Installed and configuration of the database
• Defined access security through user roles and privileges
• Performed Oracle database daily routine maintenance including standby database management,
user management, daily hot backup & weekly cold backup routine, storage management
• Creating Database exports
• Optimizing the performance of the database
• Fine tuning the database
• Create Logical/ Physical Datamodel
.com +91 767 482 2284
• Develop ETL jobs for Data Loading and Transformation
• Metadata Management
Projects Undertaken:
• GEFRe RDB Oracle
• ERC Oracle Database Administration Support
• GE AE Master Modeling
• Life Cycle Model
Role: Senior Database Developer / Data Modeler
Responsibilities/ Accomplishments:
• Prepared Data Flow Diagrams and process specifications for the system
• Models design evaluation
• Process Documentation and Evaluation
• Develop data feed and automation processes
• Create Logical/ Physical Datamodel
• Data profiling, Data load, data verification and other related operations
• Metadata Management
Projects Undertaken:
• Technical Education Management Information System
• Development of Database for Narmada Hydro Development Corporation
• Distributive Counseling Software
• Interactive Voice Response System
Role: Database Developer
Responsibilities/ Accomplishments:
• Prepare Low Level Design
• PLSQL/ SQL coding as per LLD
• Code review and integration
• Develop and Implement the code as per standard for Database Development
• Implementation and Testing
• Training and Knowledge Dissemination
• Generated test data and test cases
• Developed master and transaction forms and reports
Projects Undertaken:
• Management Information System
• Health Care System
• Office Automation System
• Process Flow Activity Management System
• Job Value Estimation Software
Certificate is Business Administration
Diploma in Advance Computing
Bachelor of Engineering in Mechanical Engineering