amp templates

Hey Folks! I am Anurag

I help companies embrace Cloud and build efficient data modeles, database designs for SQL and NoSQL databases. 
When I am not working you will find me at some tech meetup or reading a book or hiking/travelling.

I am based out of Pune, MH, India. I currently am a co-organiser or AWS User Group Pune. I am also a part of other communities like AWS User Group India, Pune Developers Community etc.


Key Skills

Cloud Computing

Designing and Implementing cloud solutions for projects as per project requirement. 
AWS | Azure | GCP
Certified AWS Solutions Architect Associate. 

Data Modelling / DB Design

Creating data models and implementing them as per requirements in Relational and NoSQL Databases.

Data Management and Analytics

Master datamanagement and Exploratory Data Analytics with SQL and Python

Agile Project Management

Requirement analysis, stake holder management. Breaking projects into Epics, Stories, Tasks, Sub-Tasks for Sprint based developement.

My Public Talks

Overview of purpose built databases in AWS 

In this talk I discuss about all the databases offerings that are availabe in the AWS Cloud Read more..

DynamoDB DeepDive

In this talk we go deep into how DynamoDB works and opertates. This talk is of intermediate levelRead more..

Gentle introduction to Cloud Computing and AWS

Student Focused talk where I introduce Cloud Computing and AWS.  Read more..

DynamoDB for SQL Developer

In this talk I take a look at DynamoDB from the lens of a relational database developer.  Read more..

Professional Experience

IQ Innovation Hub, Pune

03/2018 - Till date

Employee # 1 at IQ.

Cloud Architecture | DevOps | Data Modelling

Worked with CTO and CEO to drive technology decisions for the company and our customers.

Delivered iTyrePro, a product for Fleet and Tire Life Cycle Management for German Market.Responsible for AWS Solution Architecture for the product along with database design. Worked with customer to get the requirements and translate them into meaningful data models and requirements for development.

Currently building a product for IQ to facilitate formal communication between businesses and customers. Also driving a custom web + mobile development project for a huge insurance broker based out of Germany.

Primary function : Solutions Architect / Cloud Architect for AWS, Azure and GCP
Secondary Functions : Data Modelling, SQL, DevOps

A team player and individual contributer working closely with developers, stakeholders, customers and testers.
Hands on coding experience with SQL, PLSQL, Python etc.

Functions Performed - 

1. Requirements Analyst
2. Cloud Architect
3. Database Developer
4. JIRA Project Management
5. Master Data Management
6. Stakeholder Management

Yardi Software, Pune

08/2016-11/2017

Consultant | SQL Developer | BI Reporting

Worked as a Consultant and TSQL developer. Responsible for creating custom solutions from database end that would meet the client's custom process and requirements.

Created custom reports in SSRS and in house tools as per client specifications. This required good understanding of product flows and data analysis skills. Wrote complex SQLs on OLTP databases to create the reports in runtime for clients.

Worked on : MS SQL Server, SSRS, Yardi's Voyager Product, Yardi's Rent Cafe, Windows Server

Tech Mahindra Limited, Pune

08/2014-08/2016

Software Enginner | PLSQL Developer | Java Developer

Worked as a Database (Oracle), PLSQL Developer. Handled 65+ production databases for client's in house POS system. Was responsible for PLSQL Development, build deployments, Release Management. Created and maintained bash scripts to automate repeated tasks. Often interacted with teams of from various backgrounds and supported their requirements from database end (by creating PLSQL Scripts or DDL/DML changes)

Also monitored and handed Golden Gate (CDC Tool) errors and fixed issues in run time. Interacted with all the upstream and downstream applications to make sure that the database changes are propagated appropriately to the downstream datawarehouse team. Created new databases and propagated/copied all master data to new instances.

Worked on : Oracle, PLSQL, Solaris, Golden Gate, Jira, SVN.

Education

M.Tech - Software Systems with Specialisation in Data Analytics
School - Birla Institue of Technology and Sciences, Pilani.
Grad Year - 2017
Mode - Work Integrated Learning Program. 

B.E. - Electronics and Telecommunication Enginnering
School - SSDGCT's Sanjay Ghodawat Insititue / Shivaji University, Kolhapur
Grad Year - 2014 
Mode - Full Time Education

AWS Certifed Solutions Architect Associate

Follow Me!