Using Agile Methodology, participated sprint plans, accept stories and developed the code as per acceptance criteria.

Configured Elastic search look-up end points for read and write attributes based on GraphQL configuration.

Prepared data migration strategy and Involved in migration from SQL Server to PostgreSQL

Using Agile Methodology, participated sprint plans, accept stories and developed the code as per acceptance criteria. Configured Elastic search look-up end points for read and write attributes based on GraphQL configuration. Participate in daily scrum meetings with scrum masters to complete accepted stories in timely manner Involved into Schema design modifications according to the current requirement. Responsible for backup and recovery processes, provide system and SQL performance tuning and assist in business process. Performed Auto-vacuum to clime free space in database and monitoring the disc usage. Creating databases, sachems according to application need and manage the permissions. Involved into Development activities and write complex queries according to CRs. Create and rebuild the Indexes, created constraints according to data logic . Prepared data migration strategy and Involved in migration from SQL Server to PostgreSQL

Created MS Project plan for new project planning attribute resources, evaluate costs, set the baseline, track the project.

Worked on multiple supporting and developing projects on MySQL and SQL Server databases

As a data architect, created a data warehouse model for OLAP from different data marts.

Created MS Project plan for new project planning attribute resources, evaluate costs, set the baseline, track the project. Working on multiple supporting and developing projects on MySQL and SQL Server databases As a data architect, created a data warehouse model for OLAP from different data marts. Created multi-dimensional star schema for MSBI for reporting purpose. Created stored procedures, Views based on the requirements. Giving support for Banking related projects debug the issues and fix in a timely manner. Performing query optimization and performance tuning to reduce the application downtime. Created ETL jobs for data transformation from difference sources of DataMarts Supporting application developers if any database related issues and giving solutions from database.

Develop the new requirements or change existing functionalities in database according to customer requirement.

Understand business requirement and design or change the components structure accordingly

Very Good Knowledge in developing & customizing the product using MYSQL, PostgreSQL. Design the database to store the customer data with tables, functions, views, FD Ws constraints and indexes. Understand the customer requirement and design or change the components structure accordingly Refresh the customer data with multiple complex logics for application. Transfer the data between databases using FD Ws, DB link and using batch file for backup and restore the data. Develop the new requirements or change existing functionalities in database according to customer requirement. Vacuum and archive the historical data to increase the performance of the database. Backup and restore and transform the tables between schema s using the DB link. Create the ETL jobs using the TALEND ETL tool. Load the data from raw files to database and transform data from one database to another database based on the requirement using Talend. Create the Talend jobs with different formats and use them for different projects base on the customer data and specification.

Worked on Compensation Support Team for giving the support to Vincent users. Expertise on code migration, saved imports, Data publication using WinScp. Tested the applications assigned by the leads according to test plan and migrate the code to production environment. Giving the support to users using VM Sales Force (SFDC) and fix the issues which we have received from users. Involved actively in Archival process. Created Intra model, Cross model imports to get data from same model or from a different model. Run the extraction from bookings to Varicent to calculate the commission in a daily basis. Set up the meetings and work closely with the developers to resolve the production issues.

Performance tuning which includes rebuilding indexes, analyze tables. Well acquainted in SQL sub queries, applying constraints, creating views and indexes. Proficient in analyzing clients business process and delivering the accurate solution to incorporate the same business logic in software product. Having rich experience in end- to- end product development and implementation right from requirement analysis to Documentation, Customization & Testing. Involved in error tracking and troubleshooting complex product issues using various debugging techniques. Very Good Knowledge in developing & customizing the product using Postgresql PL/SQL Programming as per requirement analysis.

Analyze the Dimensions and Facts to design the DW. Perform the transformations for the DW. Developing an ETL jobs for the reports. Through this generating the reports for the analytic purpose. Mapping the columns with different transactional database and performing ETL for those columns. Write a SQL Queries to perform ETL testing and validating the data to check DW have correct data or not. Analyzing the DIM and Fact Tables. Maintain the star schema. Mapping the columns with the transactional database. Create DIM and Fact tables To performs ETL write scripts procedures, functions and Views. Publish the project, creating a Report.

Worked on Compensation Support Team for giving the support to Vincent users.

Expertise on code migration, saved imports, Data publication using WinScp.

Tested the applications assigned by the leads according to test plan and migrate the code to production environment.