Vishal Singh Email & Phone Number

Pune, MH, IN

India

Solution Architect in AWS Startup working with APAC customers to help them build strategy to migrate on AWS services. The work requires interaction with Cx level executives to help them innovate using AWS cloud services. As an accomplished AWS Solution Architect, I play a pivotal role in architecting and implementing robust cloud solutions that empower.

Pune, Maharashtra, India

Pune, Maharashtra, India

• Working in the Service Architecture, Governance & Enablement of team globally.
• Steering Implementation of advanced Microsoft Azure adaptation and transition from on-prem to Cloud -PaaS and SaaS models.
• Driving Cloud Governance on Enterprise-wide engagements and steering Data & BI Technology adaptations.
• Implementation of MS-O365 setup, configuration, and management including Teams, Power Platform (Power BI, Power Apps, Power Flow)
• Formulated Modern-Day warehouse using cloud database design techniques across data warehousing, SQL Server, MySQL, NoSQL & Postgres and Bigdata technologies.
• Onboarding Power BI for enterprise suites and Transition of existing dashboards to Power BI.

Pune, Maharashtra, India

• Completed end-to-end Cloud migrations for IaaS and PaaS for enterprise clients.
• Implementation of end-to-end Data Integration Projects based on Associative Data Modelling and Azure Data Stream (for IoTs) as well as AWS Kinesis for live streaming of Data.
• Completed Database Migration Projects from On-Prem to Azure Cloud (SQL Azure) and AWS Redshift with ~1.5 TB of Volume Involved
• Driving Technology roadmap with clear millstone presentation to stakeholders and other executives liable for decision making.
• Driving Cloud Governance on Enterprise-wide engagements and publishing Data & BI Technology Policies and this helped to reduce the data volume by 18% and total storage cost by 63% overall.

Pune Area, India

• Migration of 20 servers from On-Prem to Microsoft Azure as IaaS (total production data size of 11 TB)
• Leveraged the technical capabilities of the organization by introducing cutting edge technologies such as Azure, Power BI (replacing SSRS), ADF (replacing SSIS), Azure Cloud Storage (replacing FTP and file servers)
• Created service principal using SSL for automation using PowerShell and ARM templates.
• Design infrastructure based on HUB and SPOKE model for Big Data requirements
• Configure Azure AD Application Proxy connectors to work with outbound proxy servers
• Defined data model for each Confidential service for managing information and Established Azure Governance Committee for the organization and driving towards the cloud excellence

Pune Area, India

• Standardization of data warehouse design and ETL towards a dimensional model.
• Established the QlikView/NPrinting BI suite of tools as the preferred standard for DSS and worked diligently to optimize the DW architecture and performance.
• Became an early adopter of ITIL and established the Business Intelligence team as the model of effectiveness in Service Desk Management within Net-Link India
• Developed Solutions for real-time Data Analytics using Azure Stream and Power BI for NL Decision Support.
• Provide technical guidance on building solutions using Azure PaaS and other services to other teams.
• Troubleshoot and identify performance, connectivity, and other issues for the applications hosted in Azure

Pune Area, India

• Fixed major gaps in reporting and data management capabilities and developed mitigation strategies which helped the executive dashboards prediction by 36%
• Developed and presented customer database to internal database loading strategy that led to first-ever direct warehouse loading project at Fetter Logic resulting in significantly shortened development and warehouse.
• Implemented data extraction tool using metadata to generate Extract, Transform and Load (ETL) loader code for large warehouse (VLRDB) and Operational Data Store (ODS).
• Designed and implemented a financial dashboard to track the company's performance against the annual budget enabling the management to make better, faster, and more informed business decisions
• Implementation of GCP – Big table/Query setups as well designing cloud platform for a solution approach, cloud assessment workshops, POCs, and development/migration Plans.
• Engaging with customer base to understand their evolving business needs and align IT strategy on priorities

Pune Area, India

• Wrote Company's MetaData standards and practices, including naming standards, modelling guidelines and Data Warehouse Strategy.
• Built and tuned complex and large data load from various sources to ODS (Operational Data System), Financial Star Schema and Campaign Analysis Mart ETL (ADF/SSIS, Power BI and R)
• Re-designed SQL data warehouse to implement consistent naming conventions. Applied normalization as appropriate. Implemented Type 3 slowly changing dimensions. Created multiple calendars (including fiscal and 454)..
• Evaluation of Various technologies in Data and BI area as well as driving the overall vision for technology roadmap Business Intelligence.
• Published the enterprise wide tech specification for Databases and BI tech framework for Qlikview, Qliksense, Tableau, Microsoft Power BI, and MSBI which is a standard code of conduct for all technical implementation.
• Interfacing role for stakeholders including external and internal as well as hands on as consultation for various enterprise needs for many of the Tavisca’s clients.

Pune Area, India

• Created Technical Architecture for Synechron ERP system based over MVC framework 3.0/4.0, Microsoft SQL Server 2008 R2, SSIS, SSAS and Qlikview 11.20.
• Published the enterprise tech specification for Databases and storage and BI tech framework for Qlikview with Google Analytics and SAP connector and MSBI which is a standard code of conduct for all technical.
• Analyzing business requirements from technical & functional standpoint and planning future strategies.
• Working in the capacity of Solution cum Technical Architect to provide solutions to various business needs and then design the software product model.
• Managing delivery with strength of nearly 35 members in team utilizing Agile – Scrum management approach.
• Responsible for managing client and serving as single point of contact for Client Communication & Leadership Team. Participating in Business review meeting with various stakeholders and business heads for reviewing.

Hyderabad Area, India

• Functioning as a Subject Matter Expert (SME) for SQL Server and various Business Critical applications supporting Microsoft business worldwide.
• Facilitated and documented evaluation of business/IT systems for an internal IT systems Audit project (As-Is vs To-Be)
• Created "white papers" to direct data clean-up efforts and performance enhancement recommendations in an Oracle and MS SqlServer environment.
• Provided recommendations on data gathering and analysis based on best practices and emerging technologies.
• Led the implementation architecture effort for a large scale, multi-year client data integration Hub project spanning multiple business units. Successfully created the reference architecture, the implementation.
• Successfully tech-upgraded of mission critical applications from Windows to Cloud Platform.

Pune Area, India

Handling SQL Server Practices across projects as being part of "SQL Server Center of Excellence"Implementing SQL Server Best Practices and Database Standards.Handling SQL Server "Production DBA Team" for The digital Group Inc. - A CMM level 5 CompanyDexterously handled 9 projects with total strength of 15 people, which includes 5 business critical.

Involve in decision management where critical decision can be taken in favor of the business.

HSBC Technology and Services USA database support on SQL Server 2000/2005.End-to-End Database support.

Leeds, England, United Kingdom

Servers and Database Management, Fine Tuning, Planning and Supporting High Availability and Disaster Recovery for mission-critical environment.Design environment, security, and supported a wide variety of EFT (Electronic Fund Transfer) Application such as ‘Postilion’.Installation of Production Server and Databases across the business locations.

Assisting senior DBA in managing over 26 nos. of High-end SQL Database Servers that hosts Insurance, operations and development databases.Assisting in the availability of the Databases and optimum running of the Business Applications.Working with Multiprocessor and huge Memory IBM Blade Server, X440/342 series Virtual Server (VMware) technology, SAN.

Post Graduation, International Business

Activities and Societies: Successfully completed Project on TATA & Air Asia Joint Ventures in India which was awarded "Excellent" rating..

Six Sigma, Six Sigma

Activities and Societies: Defect prevention project Six Sigma Certified Professional.

Itil 2.0, Information Technology Infrastructure Library

ITIL 2.0 Certified Professional.

Bachelor (Computer Sciences), Information Technology

Activities and Societies: International IT user groups, PASS Studied Information Technology.