MAHESH PRASAD

Working on data migration project of 1000 of wells and wellbores in energy domain, migrating the data from old system to the new cloud environment. Used GIT for versioning and repository. Designing the 2-3 data pipeline per week using INFORMATICA cloud (IICS) / AWS Glue, Python, API and SQL. Used Complex logics and unstructured data like JSON file creation for the data uploading to Snowflake cloud database. Gathering the Business requirement, design documents preparing and lead the team of 5-6 members present in India. Advance Unit testing of API used in IICS mapping using Postman.

Lead the team of 5- 6 members for day-to-day activity related task, updating the task details in SNOW and communicating to other team's members and users for the requirement gathering on the Banking Risk management (Capital Market) domain. Involved in solution designing for Database objects, ETL framework and completed standardization of the components. Resolved performance issue and development on Oracle SQL PLSQL, INFORMATICA (Power Centre, IDQ, IICS), AWS and Tableau. Involved in Logical and Physical Data modeling using Erwin for Data warehouse design. Creating, modifying, scheduling and running the Control-M jobs and using Jenkins and GIT for the deployments.

Worked on Banking Credit Risk, Market Risk for project for MAS643/MAS639A (Non-Exposure), MAS639 (Large Exposure), UOBV Bessel II Implementation. Responsible for the development and support activity on Oracle SQL PLSQL, INFORMATICA, UNIX shell scripts in Jira. Actively involved in writing complex query and involved in performance tuning in Oracle DB and ER diagram using Visio. Involved in Logical and Physical Data modeling using Erwin for Data warehouse design and used Control-M jobs and used SVN as a version control system for the deployment activity.

Coordinated with the front-end design team to provide them with the necessary Oracle objects and the necessary insight into the data on Banking KYC compliance domain. Responsible for the development and support activity on Oracle and UNIX shell scripts, IDQ, Performed SQL and PL/SQL tuning. Involved in fixing of production problems in SNOW to update the resolution of the PRB's & Incidents and SVN as a version control system.

Involved in building the ETL architecture for Data warehouse in Dimensional modeling (Star Schema) of the Data warehouse. Used principles of de-normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures. Cleaned the existing Oracle PL/SQL packages to maintain the standards defined.

Responsible for the development and support activity on Oracle SQL, PL/SQL and UNIX shell scripting on telecom project. Generating, modifying and scheduling jobs in CRONTAB and excel formulas for the test data verification and JIRA fixing. Interacting with On-Site Coordinators and Support activity with Business analyst for technical clarification.