SKILL

MongoDB,DB2 LUW,MS SQL,

Sybase, Oracle,
Cassandra,Cosmos,DynamoDB
Azure synapse, DataBricks, Data
Factory, Pipeline, Power BI, Data
Ingestion AWS services etc.

BHAGWATIBEN(TINA) PRAJAPATI
Programming: Python, PySpark,
Scala, Java, C, Shell script, Perl DATA ENGINEER/DEVELOPER
script, SQL,VBS

PROFESSIONAL SUMMARY :
Cloud Technologies: AWS,
Microsoft
Azure I have over 11 + experience into IT. Data ensures facts, when pointed in right perspective. Skilled in

various databases and Programming. At this point of time, data is the need of the hour and there is

extensive need of understanding patterns in data, scale systems through distributed computing and
Database Modelling:
provide long lasting solutions from the ever-expending data points for any resource.
Dimension Modeling, ER
Modeling, Star Schema
I am a go-getter and a believer in perseverance, that solutions come to those who seek it until found.
Modeling, Snowflake
Modeling

ACCOMPLISHMENTS:
CERT I F I C A TIONS Migrated in-house database from 32bit LINUX to 64bit AIX. Assisted development team with improving
the performance of the OLTP system to meet all business requirements.

Migrated existing db2 version from 10.5.4 to11.1.4 with disaster recovery including db servers, db2
1.Azure Data Engineer
connect and db2 client (nearly 12000 servers) production system without the need for human
Associate certified
interaction.
2.M001-MongoDB
Successfully configured DSM tool for the LUW production servers, which made easier performance and
3.CSM - ScrumMaster
SQL tuning for the db team and provide best performance to the business & etc
4.DB2-730
Migrated 2005 SQL servers to 2012.

Implemented db2 AutoStart script using db2fault monitor on all db2 environment to avoid business
impact
RECOGNIZATION AND
AWARDS: EXPERIENCE SUMMARY :

Highly adaptable and experienced Database engineer,Developer and DBA with a proven track record
1. Employee of the month of high client satisfaction.
March and Adept at adapting work pace to evolving client deadlines.
OCT -2018. Superior ability to support and develop analysis solutions and data transformations
3. Shining star- 2016 Excellent ability to develop and implement data and reporting solutions
4.Employee of the year -2017. High achievement record in process quality improvement and efficient data solutions management

Superb maintenance of all working relationships
develop tests, improves and maintains existing and new databases as a way to help users in their data
EDUCATION retrieval process.
Focus on data warehouse architecture in MongoDB, DB2, Sybase, Greenplum, MSSQL, Datastage with

administration,design, development, end-to-end testing and implementation.

1.Master of Computer
Applications, Bangalore Excellent ability to handle tools like DBArtisan , Jira , Github and PowerBI.
University Experience in designing and creating RDBMS Tables, Views, User Created Data Types, Indexes, Stored

Procedures, Cursors, Triggers and Transactions.
2.Bachelor of Commerce, Gujarat Developed one-on-one mentoring program for engineers which resulted in a 30% decrease in engineer
University. staff turnover.

Experience of Partitions, bucketing concepts in Hive and designed both Managed and External tables
in Hive to optimize performance . Experience with different file formats like Avro , parquet , Json and
FIND ME AT: XML .
Worked with software developers to monitor implementation of new applications.
Telephone: 1-437-223-5577
Assisted data engineers with data warehousing projects.
Email: Big Data Engineer with expertise in designing data intensive applications using Hadoop Ecosystem ,
dbprofessional.ca@outlook.c Big Data Analytical , Cloud Data engineering , Data Warehouse / Data Mart, Data Visualization ,
om Reporting , and Data Quality solutions .

In - depth knowledge of Hadoop architecture and its components like YARN , HDFS, Name Node, Data
LinkedIn: Node, Job Tracker, Application Master, Resource Manager , Task Tracker and Map Reduce
www.linkedin.com/in/bhagw programming paradigm.
Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load
ati-tina-p-50865022
Balancing, Auto Scaling, CloudWatch, SNS, SES, SQS, Lambda, EMR and other services of the AWS

family.
Toronto, Canada

Trainings and badges:
Blog Web Site : Advanced db2 v11.5 and DB2 LUW Problem Determination from the Toronto lab, Hadoop & Big Data
https://dbtut.com/index.php/20 Foundations and MSSQL server
18/10/13/db2-database-
monitoring-2/
Visualization/ Reporting: Tableau, QuckSight, Power BI , Zappdb , Leela ,MMS
Frameworks: Django REST framework, MVC, Hortonworks
Tools: PyCharm, Visual Studio, SQL*Plus, SQL Developer, TOAD, SQL Navigator, Query Analyzer, SQL Server Management Studio, SQL Assistance, Eclipse, DBArtisan
Versioning tools: Git, GitHub
Operating Systems: Windows 7/8/XP/2008/2012, Ubuntu Linux, MacOS

WORK HISTROY:
Company: Morgan Stanley - Aug 2021 – Present
Database engineer

Experienced in high availability and data modelling, database performance tuning, and data migration
Experienced in Business intelligence include SSIS, ETL, ELT, Data Integration, Data warehousing, data modelling, creating VM & ingesting data and Power BI.
Knowledge of building big data pipeline using related technologies such as GitLab with CI/CD, Docker, and Mapping data Flow and many more.
Experienced in cloud-based computing and cloud deployment models, cloud data migration, AWS and SQL Azure, Cosmos DB, NoSQL, MongoDB and Cassandra.
Hands-on experience on big data, spark streaming, prediction model and data mining
Experience working with Azure Databricks, Azure Data Factory and Azure Data Lake
Familiar with machine learning frameworks
Worked on Azure Data Factory to integrate data of both on-prem (MY SQL, Cassandra) and cloud (Blob storage, Azure SQL DB) and applied transformations to load
back to Azure Synapse.
Managed, Configured and scheduled resources across the cluster using Azure Kubernetes Service.
Monitored Spark cluster using Log Analytics and Ambari Web UI. Transitioned log storage from Cassandra to Azure SQL Datawarehouse and improved the query
performance.
Involved in developing data ingestion pipelines on Azure HDInsight Spark cluster using Azure Data Factory and Spark SQL. Also Worked with Cosmos DB (SQL API and
Mongo API).
Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products
like SQL Server Reporting Services (SSRS) and Power BI.
Performed the migration of large data sets to Databricks (Spark), create and administer cluster, load data, configure data pipelines, loading data from ADLS Gen2 to
Databricks using ADF pipelines.
Created various pipelines to load the data from Azure data lake into Staging SQLDB and followed by to Azure SQL DB
Created Databrick notebooks to streamline and curate the data for various business use cases and also mounted blob storage on Databrick.
Utilized Azure Logic Apps to build workflows to schedule and automate batch jobs by integrating apps, ADF pipelines, and other services like HTTP requests, email
triggers etc.
Worked extensively on Azure data factory including data transformations, Integration Runtimes, Azure Key Vaults, Triggers and migrating data factory pipelines to
higher environments using ARM Templates.
Ingested data in mini-batches and performs RDD transformations on those mini-batches of data by using Spark Streaming to perform streaming analytics in Data
bricks.
Importing & exporting database using SQL Server Integrations Services (SSIS) and Data Transformation Services (DTS Packages).
Coded Teradata BTEQ scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
Developed reusable framework to be leveraged for future migrations that automates ETL from RDBMS systems to the Data Lake utilizing Spark Data Sources and Hive
data objects.
Conducted Data blending, Data preparation using Alteryx and SQL for Tableau consumption and publishing data sources to Tableau server.
Developed Kibana Dashboards based on the Log stash data and Integrated different source and target systems into Elasticsearch for near real time log analysis of
monitoring End to End transactions.
Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker related tasks such as publishing data to S3, training ML model and deploying it
for prediction.
Integrated Apache Airflow with AWS to monitor multi-stage ML workflows with the tasks running on Amazon SageMaker.

Environment: Azure SQL DW, Databrick, Azure Synapse, Cosmos DB, ADF, SSRS, Power BI, Azure Data lake, ARM, Azure HDInsight, Blob storage, Apache Spark.

Company: IBM Canada, Toronto lab - Oct 2019 – Aug 2021

Subject Matter Expert - DB2 Software Developer for North America region

Lead development team in designing/migrating DB based solutions

Work with distributed teams to design and develop frameworks, solution accelerators, consultants and external customer facing products
Investigate and debug issues in the Database and Services you create and work with QA & Data Analysts to ensure highest quality within the system
Knowledge of agile software development practices and release management
Db2 Advance Technical Development & Support and act as Lab Advocate for UPS
Db2 Consultation
Backup and Recovery, Performance Monitoring / Tuning, Memory Management, debugging.
Internal Architecture (DMS, BPS – Data/Index Page Structures etc), Crash, Hang, Slow Performance, High CPU, Corruption Analysis
Installation, Upgrade/Migrate Database/Instance, DB2 Pure scale and latest release/fix pack 
Tools (mission critical tools – db2pd, db2fodc, db2dart etc), Multi-partition Database (DPF), High availability disaster recovery.
Facilitate problem solving and collaboration.
Coordinate team logistics and Deliver Product/Process Trainings as needed
 Project -2 at IBM Canada
Responsibilities: database engineer/Database developer

Designed and setup Enterprise Data Lake to provide support for various uses cases including Analytics, processing, storing and Reporting of
voluminous, rapidly changing data.
Responsible for maintaining quality reference data in source by performing operations such as cleaning, transformation and ensuring
Integrity in a relational environment by working closely with the stakeholders & solution architect.
Designed and developed Security Framework to provide fine grained access to objects in AWS S3 using AWS Lambda, DynamoDB.
Set up and worked on Kerberos authentication principals to establish secure network communication on cluster and testing of HDFS, Hive
and MapReduce to access cluster for new users.
Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3.
Implemented the machine learning algorithms using python to predict the quantity a user might want to order for a specific item so we can
automatically suggest using kinesis firehose and S3 data lake.
Used AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon Simple
Storage Service (Amazon S3) and Amazon DynamoDB.
Environment: AWS EMR, S3, RDS, Redshift, Lambda, DynamoDB, Amazon SageMaker, Apache Spark, HBase, Apache Kafka, HIVE, Map Reduce,
Snowflake, Apache ,Python, Tableau

Company: IBM India - March 2016 –Oct

2019
Client: UPS- Technical Services Specialist- Senior DB2 LUW DBA (Team Lead)

Administration and maintenance over 200 schemas on 8000/10000 servers with over 52TB of data.
Supported multiple concurrent projects from development to production implementation for a variety of client initiatives (R1/R2/ISAS) on DB2
for Data Warehouse replace project(s).
Addressed performance related issues in Production, Test and Dev environments to meet or exceed business requirements utilizing
solutions.
Developed and optimize automated installation/uninstallation processes and procedures to reduce overall man-hours needed to support
existing/new DB2 infrastructure using PowerShell, Shell, VBS, batch and windows scripting.
SSL (Secure Sockets Layer)/TLS (Transport Layer Security) configuration for the critical databases.
Contributes in the effort estimation, task allocation, PMR presentation review meetings, audits, lessons learn documents to the organization
domain.
Creating databases ,redesigned database architecture to consolidate database servers and remove unneeded database hardware for the
existing environments.
Installed db2 ODBC drivers on the SQL servers and catalog db2 databases.
Planned HADR with multiple standby or suitable disaster recovery after discussing with the UPS client.
Worked on the db2 migration and upgrade/backout process to automate different versions for the DB2 projects.
Worked on Conceptual, Logical and Physical data modelling using Erwin, Toad and IBM data studio tools.
Applied fix packs, monitor IBM maintenance releases and communicate them to business.
Installation, Migration and administration of DB2 Connect and Client gateways used to access DB2 ZOS Subsystems.
Solely responsible for setup, installation, configuration, performance monitoring and issues resolution for DB2 DB/Connect/client servers
during the production cut-over project.
Configured Data Server Manager -DSM tool which is highly used for performance issues.
Contributed in the effort estimation, task allocation, PMR presentation review meetings, audits, lessons learn documents to the organization
domain
Established and maintained backup strategy and recovery policies and procedures
Monitoring and optimizing the performance of the database through Runstats, Reorgs, db2advis ,db2 optimizer using db2 utilities and DB2
AutoStart on all db2 servers by using the db2fm process.
Scheduled Jobs in the ESP scheduler mainframe Z/OS tool (Changeman package, docutext)
Provided cross platform training and mentored associates to provide working knowledge of DB2.
Developed the implementation process for database releases to match Agile/Sprint release methodology.
Efficiently resolving problem tickets of different severity levels (change control & HDFS case, ServiceNow Tool)
Technical and organizational process design, documentation and implementation
Day-to-day attending to the user queries in sorting out database problems.
Refine the physical design to meet system storage requirements.
Ensure that storage and archiving procedures are functioning correctly.
Ensure the performance, integrity and security of the databases.
Coordinating with user departments and attending their requirements for smooth functioning.
Understand the strategic directions of our clients to ensure the best consistency between existing systems and current and future goals.
Ability to organize and plan work independently.
Ability to multi-task between different activities and teams.
.
Company: Birla Soft - October 2015 – Jan 2016
Clients: BBG, Diageo and Heinz - Senior Software Engineer – DB2 LUW

Highly available and fault tolerant database design took advantage of technologies such as Clustering, RAID, log shipping, replication,
federated and parallel servers in DB2 UDB, SQL Server and Oracle RDBMS platforms.
Monitor, analyse and improve existing DB2 Database environments.
Handled the database installation including extent sizing, backup/restore policies, security settings (users/roles), file allocation,
application integration and release/upgrade management for all major systems.

Company: Cognizant Technology Solutions - March 2014 – October 2015

Clients: ING Vasya Bank, Liberty Mutual - Technical Lead – DB2 LUW DBA

Managed file systems and storage space issues

Demonstrated Strengths in Database Administration, Backup & Restore Management, Performance Management, Security Management,
Space Management & Reporting.
used problem solving tools: DB2 Audit, DB2 Governor, Export, Import, Load, DB2PD, DB2TOP, DB2ADVIS, DB2LOOK etc.
Lead capacity for the DBA team in the planning, development and maintenance of databases systems for all of the apps
Demonstrate accountability for completing work assignments, meeting commitments and deadlines
DBA expertise and best practices to scale and optimize the data base services.
Ensure the performance, integrity and security of the databases.
Understand the strategic directions of our clients to ensure the best consistency between existing systems and current and future goals.
Ensure that storage and archiving procedures are functioning correctly
Developed migration strategy to move from SQL 2005 to SQL 2012.
Investigated, migration related performance issues, provided analysis and rewrote part of the existing application to address long
standing issues with complex transactions. While correctly interpreting the business’ and client's business rules.

Company: IBM India - May 2012 – March 2014

Clients: RSA, JLR, EBHS – DB2 LUW DBA

Handling DDL, DCL and DML

Granting/revoking various database privileges based on the grant form requests
Investigating and resolving problems arising in all aspects of the DB2 LUW environment
Contributes to the effort estimation, task allocation, PMR presentation review meetings, audits, lessons learn documents to the
organization domain
Creating databases and database objects, allocating and effectively troubleshooting the database issues
Setup Replication between Operational Database and Reporting Database using HADR and cluster server.
Establishing and maintaining backup strategy and recovery policies and procedures
Monitoring and optimizing the performance of the database through runstats and reorgs
Technical and organizational process design, documentation and implementation
Coordinating with customer departments and attending their requirements for smooth functioning and sorting out database problems
ompany: Artech Infosystems Pvt. Ltd - May 2010 – October 2011
Clients: IGA Singapore, L&G and Bank of Ireland – DB2 LUW DBA
Monitor, analyse and improve existing DB2 Database environments
Developed the upgrade and OS migration strategy for DB2 v8 to DB2 v9.5.
Responsible for DB2 and SQL Server environments on various OS environments.
Review and Promoted Stored procedure, triggers, views, packages, functions, indexes, table spaces, users, schemas and jobs to all
database environments.
Identified and resolved numerous performance bottlenecks and deadlocks in projects in order to meet business needs for system
response and wait times.
Improved system database performance by tuning of buffer pools, lock lists and collection of statistics.

Company: Artech Infosystems Pvt. Ltd - May 2010 – October 2011

Clients: IGA Singapore, L&G and Bank of Ireland – DB2 LUW DBA

Monitor, analyse and improve existing DB2 Database environments

Developed the upgrade and OS migration strategy for DB2 v8 to DB2 v9.5.
Responsible for DB2 and SQL Server environments on various OS environments.
Review and Promoted Stored procedure, triggers, views, packages, functions, indexes, table spaces, users, schemas and jobs to all
database environments.
Identified and resolved numerous performance bottlenecks and deadlocks in projects in order to meet business needs for system
response and wait times.
Improved system database performance by tuning of buffer pools, lock lists and collection of statistics.

I solemnly declare that all the information furnished in this document is free of errors to the best of my knowledge.