Started working as Google Cloud Architect with an architectural vision followed by adopting organization specific security guidelines & generating best practices as per client need.Domain: ProcurementRoles & Responsibilities:• Requirement Study on new initiative/applications in GCP & Preparing the design diagram.• Determine cloud services at the time of design.• Determine risks in case of change in functionalities.• Build and coordinate cloud architecture.• POC implementation for the new initiatives or enhancements.• Automate cloud services.• Ensuring cloud security• Customized Mail monitoring Alerts.• Governance & Cost Management by having a close look on the billing.• Assisting/solving development teams on technical issues in GCP-Development phase.• End to end product technical ownership by understanding all source code and documenting source code detail. • Create sample code to enforce standards for developers ensuring scalability, performance, and security. • Communicating/training development team on GCP concepts and guidelines.• Defining coding standard and making sure that same is used across products by working with Product Owners. • Reviewing GCP estimation done by various application development teams.

Started working as Cloud Engineer & was assigned with the responsibility of setting up Google Cloud platform Data Lake from scratch.Domain: ProcurementKey Responsibilities• Onboarding of GCP BigQuery, GCS Bucket.• BigQuery Schema Design of 3 applications.• IAM (Identity & Access Management) configurations for ETL jobs, Application developers.• GCS Bucket Design & configurations.• Query Optimization.• Training to Newcomers on GCP & BigQuery

Leading team of 8 members & 2 applications. Applications are having technologies like Oracle APEX, UNIX, Shell Scripting, Oracle 12c database, Python.Domain: BankingKey Responsibilities:• DB Migration—Tech Refresh activity of setting up new Dev/Prod database.• Job Configuration in Oracle Data Integrator.• Designing, data modeling & creating its associated structures for new requirements.• Implementation of Customized Database logging mechanism in PLSQL.• Tuning of SQL statements related to performance issues & defects.• Data Migration using SQL Loader from Flat file/Excel.• Debugging & solving Production database issues like data related errors, PL/SQL exceptions.• Going through AWR reports, DBMS.SQL-Tune outputs for tuning recommendation.• Preparation of System requirement specification (SRS), System Design Document (SDD), test-cases for the given requirement.• Developing new functionalities, enhancement requests received from clients.• Creating JSON queries for API calls from External tools.• Creating/Modifying shell scripts for API calls.• Conducting Daily stand-up & participating in Code Review.

Client: BMWDomain: AutomobileTechnical Responsibilities :-->• Designing, data modeling & creating its associated structures for new requirements.• Implementation of Customized Database logging mechanism in PLSQL Procedure/Functions/Packages/Triggers.• Tuning of SQL statements related to performance issues & defects.• Creating constraints, PL/SQL code for backend stored procedures, functions, triggers and packages, db-links as per business requirement.• Tuning of existing Design using materialized views, partitions.• Data Migration using SQL Loader from Flat file/Excel.• Debugging & solving Production database issues like data related errors, unhandled PL/SQL exceptions in existing code.• Going through AWR reports, DBMS.SQL-Tune outputs for tuning recommendation.• Creating Reports using complex queries based on user requirements.• Requirement Gathering & Estimation of maintenance Database deliverable.• Preparation of System requirement specification (SRS), System Design Document (SDD), test-cases for the given requirement.• Developing new functionalities, enhancement requests received from clients. • Conducting & participating in Code Review.Management Responsibilities:-• Leading team of 19 members & 33 applications. Applications are having technologies like Java, Mainframe, Dot net, Oracle, DB2, PostgreSQL.• Managing the complete operation support project & taking care of incident management, problem management, change management• Change Manager for coordinating Major Functional Release or Big Fix release for each application.• Conducting L1, L2 calls with team & Client POC/stakeholders.• Taking care CSI (Customer Satisfaction Index)• Presenting Weekly statistics of Maintenance & Operation performance to Leadership.• Monthly review call with Client in order to identify the pain area & finalizing the corrective measures.• Accountable for Quality assurance of entire operation support based BMW defined framework.

Module Leader of Application System based on Financial and Sales Accounting. Primary Skill- Oracle sql & pl/sqlPrimary Skills:- Oracle 10g Database Server (SQL, PL/SQL)Oracle Developer Suite 10g - (Reports Builder).UNIX.GLOBAL CERTIFICATIONS:-Oracle Certified Associate (Database) in Oracle 9i Platform. Certified on 30th June'2008Oracle Certified Associate (PLSQL) Certified on 22nd Apil-11Advanced Oracle Certified Proffessional (PLSQL) Certified on 5th August-2011Major Project experience Details:-1.Current Project - Switching Over IISCOEmployer: - CMC LIMITED.Description – The existing system is maintained in different platform like FoxPro, oracle, excel and COBOL which is going to be migrated in a single platform of ASP.NET with Oracle 10g as backend. The project includes different domains like Financial Accounting, Sales Invoicing, Cost system & Payroll. • Role : Finance Module Leader2.Project - SECR I-Net, Chattisgarh.Employer: - CMC LIMITED.Description – the project is maintaining payroll, finance, material management, bill passing & commercial functionalities of South East Central Railway (Bilaspur, Raipur, Nagpur) zone. • Role: Team Member.3.Project - ECR MIS AMC, Bihar.Employer: - CMC LIMITED.Description – The project was under AMC phase & maintaining payroll, finance & commercial functionalities of East Central Railway Zone Head Quarter (Hajipur) zone.• Role : Team Member.

Tech support to HCL & Toshiba clients. In payroll with Pages Consultancy Limited