SUMMARY

• Worked as AWS Architect and provided various critical solutions to migrate On - Prem application to AWS Cloud by implementing various best practices and taking architectural design decisions for ETL and Database
• Worked as solution Architect and provided best solution in industry for various OLTP & OLAP systems from design to implementation and delivered high quality & satisfactory solution in timely manner
• Very good hands on experience in Oracle and Teradata SQL query Performance Tuning activities like analyzing indexes, optimizing stored procedures, implementing table partitions and troubleshooting
• Worked as Lead Data Modeler on Database Design and System Architecture Design for various complex projects
• Worked on Business Intelligence design & development work using Business Objects and Cognos
• Worked as Technical Project Manager for big projects with resource strength (>35) and experienced in Project planning, Capacity planning, effort estimation, risk & issue analysis, resource management, coordination with client, preparing various presentations and giving demonstration to Client and other stakeholders
• Profound knowledge in understanding and analyzing business requirements and converting it into logical and physical data model by following naming standards, create views based on the Reporting needs
• Execute DDL scripts in Development, Test and Production environments and document the scripts for creating tables/views, loading the test data in development and test environment
• Create data migration & technical installation strategy, create & maintain data dictionary
• Setup and configure the Development, Test and Production environments
• Document scripts to support maintenance activities
• Have very good experience in Archival & Decommission Architecture and provided various solution for various Banking and Pharmaceutical Clients
• Worked on Oracle Reports 6i/9i/10g and Autosys Job scheduler Tool
• Successfully implemented major releases in different projects with full SDLC
• Good communication, coordination, presentation skills and team/people management skills

PROFESSIONAL EXPERIENCE

Confidential

AWS Architect curm Data Architect

Responsibilities:

• Perform AWS Architect cum Data Architect to Analyze the requirement, estimate and provide solution on critical requirement and assess the required AWS components as part of architectural requirement
• Prepare presentation on the solution blueprint, provide demonstration, create SRS, Design Architecture, prepare Design Document
• Perform system/architecture study of various system and provide AWS enable solution with the goal of faster AWS adoption
• Perform Architecture assessment and recommend various best practices to be followed through workshops and working sessions
• Perform System study and requirement Analysis of the existing legacy system and understand the existing data model and design the new Logical & Physical data model and Semantic data model with Naming standards using
• Prepared and presented the Data Models to the clients and implement industry standard naming standards
• Involved in Effort estimation, Develop project plan, maintain RAID log, Ensure effective quality control processes are in place to monitor deliverables
• Analyzed the business requirement and existing source systems to capture data flow in Conceptual model
• Design the Physical data model using Erwin 9.5 for the system as per the naming standards and do reverse/forward engineering of the physical model
• Guide team for defining framework for ETL data load based on the Reporting needs, create indexes & used hints for efficient data access.
• Work with the Project team to setup the Development, Test and Production environments
• Pull data from AWS RDS(SQL Server) for one of the data source and load it into DW
• Perform few POCs to provision AWS Redshift for future state Architecture
• Define data migration strategy, scripts creating tables/views, loading the data in the development and test environment
• Organize weekly and monthly meeting with all the project stakeholders for project review
• Maintaining client relationships, ensuring timely and quality delivery for overall success of the project
• Giving various functional & technical solutions and implementing the best practices

Confidential

Data Architect cum ETL Architect

Responsibilities:

• Prepare presentation on the solution blueprint, provide demonstration, create SRS, Design Architecture, prepare Design Document
• Perform System study and requirement Analysis of the existing legacy system and understand the existing data model and design the new Logical & Physical data model and Semantic data model with Naming standards
• Resource management, delivery tracking, recruitment, people management, performance review and appraisal
• Risk management and provide mitigation plan, project planning and project tracking, organizing huddle board session for delivery reporting
• Prepared and presented the Data Models to the clients and implement industry standard naming standards
• Involved in Effort estimation, Develop project plan, maintain RAID log, Ensure effective quality control processes are in place to monitor deliverables
• Analyzed the business requirement and existing source systems to capture data flow in Conceptual model.
• Design the Physical data model using Erwin 9.5 for the system as per the naming standards and do reverse/forward engineering of the physical model
• Guide team for defining framework for ETL data load based on the Reporting needs, create indexes & used hints for efficient data access.
• Work with the Project team to setup the Development, Test and Production environments
• Define data migration strategy, scripts creating tables/views, loading the data in the development and test environment
• Organize weekly and monthly meeting with all the project stakeholders for project status review
• Maintaining client relationships, ensuring timely and quality delivery for overall success of the project
• Giving various functional & technical solutions and implementing the best practices

Confidential

Lead Data Modeler cum Data Architect

Responsibilities:

• Worked as Data Architect cum Technical Manager and perform System study and requirement Analysis of the existing legacy system and understand the existing data model and design the new Logical & Physical data model with Naming standards implementation
• Prepared and presented the Data Models to the clients and implement industry standard naming standards
• Analyzed the business requirement and existing source systems to capture data flow in Conceptual model
• Design the Physical data model using Erwin 9.5 for the system as per the naming standards and do reverse/forward engineering of the physical model
• Generate DDL scripts of the Physical data model using Erwin 9.5 and Execute DDL scripts in Development, Test and Production environments
• Guide team for defining framework for ETL data load based on the Reporting needs, create indexes & used hints for efficient data access.
• Work with the Project team to setup the Development, Test and Production environments
• Define data migration strategy, scripts creating tables/views, loading the data in the development and test environment
• Organize weekly status call with Client on project status review
• Involved in Effort estimation, Develop project plan, maintain RAID log, Ensure effective quality control processes are in place to monitor deliverables

Confidential

Data Architect

Responsibilities:

• Worked as Technical Manager and actively participated in requirement gathering, analysis
• Worked closely with business for verification and validation of business rules
• Analyzed the existing heterogeneous databases and build conceptual, logical & physical data model for Staging & Operation Database by representing the Entities, Attributes, Primary Keys, Foreign Keys and Relationships among the entities
• Converted the Logical to Physical Data model as per the naming standards, created indexes
• Create the ODS based on the hierarchical database IMS database, Vision+ etc. structure
• Provided various recommendation which includes Performance Tuning, Partitioning, rebuilding Indexes and updating Statistics
• Worked with the Project team setup the Development, Test and Production environments.
• Executed DDL scripts in Development, Test environments.
• Defined data migration strategy, scripts creating tables/views, loading the data in the development and test environment.
• Monitored for performance issues after implementation and worked on fixing them.
• Involved in Creating/Scheduling jobs, Alerts
• Allocated tasks to team members on daily, weekly basis and ensured the deliverables were delivered on the agreed time.

Confidential

Technical Project Manager curm Data Architect

Responsibilities:

• Performed Solution Architect cum Project Manager Roles for a big Team
• Technical & Business Requirement gathering with Client Interactions & co-coordinating with other Business Partners.
• Designing of system & workflow to fetch data from Legacy System, Processing the data using the laid out business rules/requirement & at the end loading the processed data into Global Data Mart.
• Forward/Reverse engineering of the data model using Erwin & create ERD and get sign off
• Responsible for laying out business rules into logical & physical data model for staging, ODS & DataMart area
• Create Effort estimation sheet, Develop project plan for the project using Microsoft Project Plan, create RAID log for Risk and issues and suggest for mitigation plan & Ensure effective quality control processes are in place to monitor deliverables
• Responsible for infra setup to run the Syncsort DMExpress ETL.
• Responsible for Storage (SAN), Firewall & Network setup for all Syncsort environment
• Change Management for the product using Serena Version Manager
• Automation using Advanced UNIX Shell Scripting.
• Final baseline code release into production system after testing rigorously using Mercury Quality Center 9.0 test automation tool
• Supporting & maintaining the application production environment
• Daily sync up with the onshore & offshore team members for regular status update

Confidential

Technical Lead

Responsibilities:

• Analysis of the Business requirement and design the OLTP system
• Create ERD and logical & physical data model and demonstrate to client & get sign off
• Implementing various changes by doing feasibility study on the existing system
• Defining various strategies for processing daily feed files coming from various sources
• Used various technologies like Oracle PL/SQL, Performance Tuning, Autosys Job scheduler, Unix Shell Scripting.Net framework etc.
• Create various types of analytics based on the client demand and focus on that particular area of business
• Helped client to prepare Architecture Roadmap for overall project implementation
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling for the data warehouse.
• Managing team for successful delivery of the project

Confidential

Technical Lead

Responsibilities:

• Create logical & physical data model and create DDL scripts and implement them in production
• Designed and developed various user screens, process the data coming from various source systems and generate various reports on DSS for production, planning, equipment etc.
• Ensured applications run without any issues, as the applications were used by Road Sales Department hence becoming a highly business-critical project.
• Performance & tuning of application done by rebuilding indexes, update statistics wherever necessary
• Install & maintain various Application & Database servers & monitor AIX server load using SMIT tool
• Create various analytical cubes based on the production & planning data and B2B
• Monitored for performance issues after implementation.
• Involved in creating, scheduling jobs, alerts
• Database backup/restore including copying databases from production to test environments
• Involved in Backup & Recovery
• Worked on Performance tuning, troubleshooting bugs, developing and implementing emergency fixes