Profileimage by VISHAL SINHA Solution Architect - AWS Cloud from NEWDELHI

VISHAL SINHA

available
Contact

Last update: 30.05.2021

Solution Architect - AWS Cloud

Graduation: Masters in Computers Management
Hourly-/Daily rates: show
negotiable for Remote and part time projects
Languages: English (Full Professional)

Keywords

etl aws AWS (Lambda Redshift AWS Glue REST API Development Kinesis terraform Airflow Informatica

Attachments

Vishal_Sinha_TechM_Del_UK_2305 (2).pdf

Skills

  • 17+ years of overall IT experience with expertise in Business requirement analysis, Application design and development, management and Pre-Sales of Cloud and Big Data applications.
  • 5+ yrs of exp in AWS Cloud, providing design, development and consulting for Data Analytics platform in aws cloud environment.
  • Good hands-on experience in design, development and delivery of Data Lakes on Cloud-AWS Platform.
  • Strong Technical hands on with AWS big data stack - S3, Glue, EMR, Sagemaker, Kinesis, Lambda, DynamoDB, Redshift, Athena and Tableau..
  • Lead team of Data Engineers and Data Scientists, to design Real time Machine Learning Models for Fraud Detection, Credit Risk Scoring and Customer Lifetime valuation.
Worked extensively in following key technical skills -
S3, Glue, EMR, Sagemaker, Kinesis, Lambda, DynamoDB, Redshift, Athena, Tableau, AWS, Cloud, Big DataAnalytics, ETL, data modelling, Spark, Python, APIs, Informatica PowerCenter, Informatica 8.6

Project history

03/2017 - 07/2020
Solution Architect - AWS Cloud
TechMahindra

02/2015 - 02/2017
Team Lead - Data Analytics
Accenture

01/2011 - 09/2014
Tech Lead - ETL
Wipro Technologies

06/2005 - 12/2010
Technical Associate
Tech Mahindra Ltd

08/2009 - 09/2010
Tech Lead
Tech Mahindra Ltd
BTGS Solution Design
BT Global Services is a division of British Telecomunication Group. It delivers a combination of
communications and IT services to over 10,000 organisations and governments worldwide. [1] Its
customers include over35% of the global Fortune 500 and it is the largest supplier of networked
IT services in UK and Europe .
BTGS is using Oscar Datawarehouse to leverage its platform for business information gathering .
Solution design is architected to extract relevent information for reporting purpose .


Role : Tech Lead
Responsibliies :
Collecting, understanding, and transmitting the business requirements for the project, and
translating these into detailed development process.
Coordinate with BT solution designers across global BT GS locations to design and develop
technical process and solution to achieve the client business requirement .
Translate the technical design process into application architecture along with a team of
component designers .

creation of schema objects (tables, views, indexes, packages, triggers) in an Oracle9i environment
.
Sql query optimization / performance tuning for data extraction from data warehouse to
datamart .
Client : British Telecom - UK
Tools / Technology : ORACLE 10g , PL/SQL , Unix , Informatica , MS Visio

06/2007 - 06/2009
Solution Architect
Business Intelligence - OSCAR Datawarehouse
Business Intelligence - OSCAR Datawarehouse (onsite - London UK )




OSCAR is t-mobile's enterprise datawarehouse system that is used to create datamarts for invoice and
billing purpose . Datamarts consist of an Oracle database that holds several types of call data record (
CDR) information. The different types of call data records are held in separate schema's within the
datamarts developed using OSCAR datawarehouse .

CDRs are loaded (along with other source of data ) into various database tables from network components
via loader programs (input interfaces). CDRs that are held in the tables are analysed and extracted by
PL/SQL packages/scripts, to analyze and summaries information pertaining to business requirement .
Business Objects applications are run on the tables to produce visual reports.
There are several output interfaces in the form of summary report applications. These are Oracle packages
that are called from Korn scripts, which are run usually on a routine basis by crontab entries, in order to
provide summarised results and reports from OSCAR tables that have been loaded with CDRs or log/test
data via the input interface loaders.

The output data is made available to management and revenue assurance staff.


Role : Solution Architect

Responsibilities :

Requirement gathering with clients, Identify and analyze business requirements .

translated business requirements into dimensional data model to support the billing/invoice data mart

functional and technical specifications of business requirement .

System Analysis and design , conceptual , logical and physical database design .

creation of schema objects (tables, views, indexes, packages, triggers) in an Oracle9i environment .

development of ETL processes (PL/SQL Packages ).

source-to-target mapping and logical structures for the data warehouse/data mart .


Client : T-Mobile - UK
Environment : ORACLE , PL/SQL ,UNIX , ProC/C++ , UML , Informatica , Business Objects

06/2005 - 05/2007
Switch Manager Development
21 CN
Switch Manager is BT's PSTN and ISDN network support system within UK that provides a single point
interface between local and trunk exchanges , maintenance users , administrative users , exchange data
users , system data and other network support system .

SM is continually subject to enhancements to support new ISDN services , regulatory requirements ,
upgrades to exchange builds and growing telecom traffic volumes .


Role : Software Developer




Respnsibilities :
(with a team size of 120 ) was inviolved with the following :
development of various tool for data transfer and migration between different SM interfaces .
development of the system for three transition phases .
development of modules that covers call routing , call diversion and Pbxname generation for exchanges .
Act as a central coordination point for various support activities on Switch Manager .
Building up a very strong customer support and communication structure

Client : British Telecom - UK
Environment : ORACLE , PL/SQL , ProC , UNIX , C++

Time and spatial flexibility

I am based in India - only open for Remote oppurtunities, preferably Part time. Not looking for Visa Sponsorship.

Contact form

Contact details