Vaibhav Bansal Email & Phone Number

Offenbach, He, De

Frankfurt, Hesse, Germany

Understanding customers’ overall Banking, finance applications portfolio, IT and businesspriorities and success measures to design implementation architectures and solutions (Microsoft and 3rd party solutions) using PAAS, DEVOPS & AMP; Advanced Application Config. Preparing infra pipeline to deploy with Open shift, Kubernets clusterPreparing code build to release CI pipelines to deploy specific services in Open shift, Kuber nets& amp; aks cluster. Experience debugging deployment and operational issues. Works with experienced team members to conduct root cause analysis of issues,review new and existing code and/or perform unit testing.

Bulk loading from the external stage (Aws S3), internal stage to snowflake cloud using the copy command. Loading data into snowflake tables from the internal stage using snow SQL. Used Copy, List, PUT and GET commands for validating the internal stage files. Used import and export from the internal stage (snowflake)from the internal stage(AWS S3) Writing complex snow SQL scripts in snowflake cloud data warehouse to business analysis and reporting. Used FLATTEN table function to produce a lateral view of VARIENT, OBJECT, and ARRAY column. Used SNOW Pipe for continuous data ingestion from the s3 bucket. Develop snowflake procedures for executing branching and looping.  Worked as AWS Cloud Database Engineer (Oracle, MySQL, Maria DB, POSTGRES and Mongo/Document DB). Building EC2 instances in AWS and installation and configuration of Oracle in EC2 (AWS). Designed and developed load balancing Mongo applications.

 SQL tuning and Database performance tuning Database automation project Databases monitoring using OEM 12c/13c Implemented Silent installation of grid, oracle and Creation of database by silent mode. Database inventory handling

Check Mail & Alert Log File Errors and Make Necessary Actions to Rectify Them  Export/Import of Tables, schemas, Table space, Database using traditional and data pump tools RMAN Configuration and Physical Incremental Backup, RMAN Scheduling Online Backups RMAN Cloning Database Creation, Online Cloning and Offline Cloning Design and implementation of Table space, database, file system monitoring scripts Implementing Cold and Hot backup strategies for database management

 Participated in client business need discussion and translating those needs into technical execution from a data standpoint Translated business requirement into BI application designs and solutions. Assisted in definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues. Developed highly optimized stored procedures, functions, and database views to implement the business logic also created clustered and non-clustered indexes. Involved in performance monitoring tuning and capacity planning Tuned the slow performance queries by looking at Execution plan. Used various SSIS tasks such as conditional split, Multicast, Fuzzy Lookup, slowly changing Dimension etc. This did Data scrubbing including data validation checks during staging before loading the data into Data Warehouse from flat files, Excel and XML files. Responsible for implementation of data viewers, Logging, error configurations for error handling the package. Involved in the complete life cycle in creating SSIS packages, building,deploying and executing the packages in both environments.(Development and Production) Designed, deployed and maintained complex canned reports using SQL server 2008 Reporting services (SSRS). Created reports to retrieve data using Stored Procedures that accept parameters. Customized reports by adding filters, calculation, Prompts, summaries and functions. Created Parameterized queries, generated tabular reports, sub-reports, cross tabs, drill down reports using expressions, functions, charts, maps, sorting data, Defining data sources and subtotals for the reports

Education record

Bachelor Of Engineering - Be