Uploaded File
add photo
Dipesh
drana8000@gmail.com
774-285-1564
12 Kendall Drive
Westborough, MA 01581
Cloud Solutions Engineer, Security & Architecture
24 years experience W2
0
Recommendations
Average rating
5
Profile views
Summary

Summary

  • Resourceful Integration Engineer adept at exceeding expected results, even when faced with unique change management challenges.
  • Strong interpersonal and leadership skills that facilitate the enhancement of multi-disciplined work teams, including technical and non-technical members.
  • Exceptional problem-solving abilities and outstanding track record of delivering innovative software solutions across a wide range of customers.

Experience
Cloud Solutions Engineer, Security & Architecture
Information Technology
Nov 2019 - Nov 2019
Responsible for:
  • Working on cost reduction processes in AWS cloud infrastructure.
  • Worked on setting up data archiving process to S3 and optimization within EC2, in addition to setting up CloudWatch at AWS
  • Developing custom interfaces using C# to integrate to auditing and compliance platform
  • Documenting all work and training installation team on how to support the custom interfaces
  • Developing stored procedures, views, and functions in SQL Server for product development
  • Working and fixing all defects related to C# parsers for healthcare EDI file imports
  • Assisting with SQL Consolidation project to migrate multiple databases to different servers
  • Building SSIS package for archiving data from tables and restoring based on timeframe
  • Building Powershell scripts to import data into AI tool by executing SSH commands
  • Point of escalation for all client support tickets
AWS AWS EC2 AWS S3 Cloud Infrastructure Cloud Solutions Cloudwatch Compliance EDI PowerShell SQL SQL Server SSH SSIS Stored Procedure
Remove Skill
ead Data Integration Engineer, Professional Services Group
Information Technology
May 2018 - Nov 2019

Responsible for:

  • Installing and configuring MDAudit Professional and MDAudit Enterprise software for clients
  • Developing custom extraction routines utilizing SSIS into clients billing systems
  • EDI File Extractions
  • Database Extractions using ODBC (EPIC, GE/IDX, SQL Server, Oracle)
  • Developing custom stored procedures and views in SQL Server to transform data from staging to billing tables
  • Developing ETL packages in SSIS to transform data for supplemental data
  • Developing custom tools in C# for automating installation tasks
  • Working with Development team on identifying and fixing defects in product
  • Mentoring and coaching other implementation engineers
  • All escalations related to projects
Data Integration EDI ETL Oracle SQL SQL Server SSIS Stored Procedure
Remove Skill
IAM Engineer, Professional Services Group
Information Technology
Apr 2013 - May 2018
Westborough, MA

Responsible for:

  • Teaming with Solutions Delivery Consultants to provide solutions addressing the customer's technical environment and requirements
  • Installing and configuring Courion software products at a customer location or by remote access
  • Documenting on-site work and train customers on how to support the solution going forward
  • Developing custom stored procedures, views, and functions in SQL Server
  • Building SSIS packages to manage file/data import processes
  • Building custom workflows utilizing JavaScript, XML, HTML, ASP, XSLT, VBS, C#, and other technologies for password reset, provisioning, and compliance
  • Working with Active Directory, Novell, LDAP, SAP, Oracle, and other target systems for provisioning
HTML JavaScript LDAP MS Active Directory Oracle SQL SQL Server SSIS Stored Procedure XML
Remove Skill
Technical Specialist, Professional Services Group
Information Technology
Apr 2007 - Apr 2013
Responsible for:
  • Providing specialized product support to customers communicate directly with customers regarding technical issue resolution and workarounds via email, phone, and other electronic mediums
  • Diagnosing and resolving software, user, and system issues research recurring problems to determine a root cause devise viable solutions and workaround for customers or escalate issues as necessary to Engineering
  • Documenting resolutions to calls and/or emails to support development of the group knowledgebase
  • Work in professional services to implement software installations and configurations. Work involved troubleshooting and modifying custom stored procedures in backend SQL Server database.
  • Install, configure, and test ADT, Lab, Vitals, Chemo Orders, Nurse Notes, MAR, Lynx, Relay Connector, EPrescribe interfaces in IntelliDose. All interfaces utilizing HL7 in an SQL Server backend database.
  • Work with product support and account management to transition new clients to product support
  • Troubleshoot and document technical issues
No skills were added
Remove Skill
Web Engineer
Information Technology
Nov 2001 - Apr 2007
Responsible for:
  • Supporting web hosting services, domain name registrations, maintaining existing accounts, and answering customer requests
  • Wrote custom stored procedures for supporting frontend in SQL Server 2005 backend database
  • Built data cube to support analytics in SQL Server 2005
  • Built websites for customers built in HTML/CSS, ASP, and AJAX
  • Escalation point for support team to troubleshoot any issues reported
AJAX CSS HTML SQL SQL Server Stored Procedure
Remove Skill
Technical Support Engineer
Information Technology
Jan 2000 - Nov 2001
Responsible for:
  • Supporting Powerbuilder 6/7/8 and EAServer. Powerbuilder written in VBA
  • Supporting Powerbuilder DB integrations in Sybase SQL Anywhere, Microsoft SQL Server 2000, and Oracle 8i
  • Working with clients in diagnosing and troubleshooting issues. Differentiated differences between project code issues versus bugs.
  • Entering core product bugs to internal bug ticketing system.
Oracle SQL SQL Server
Remove Skill
Help Desk Support
Jan 1997 - Nov 1999
Responsible for:
  • Setting up Network Server to enhance productivity for GTS group.
  • Imaging and configuring laptops used by Business Analysts.
  • Responding to HelpDesk tickets in GTS Group.
  • Installing MS Office, Lotus Notes, and other software on laptops used by PWC team.
  • Deploying and walking Business Analysts through MS Office, Internet Applications, and Lotus Notes
Business Analysis Laptops
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer Information Systems
Bentley College 2003
Skills
SQL
2019
13
SQL Server
2019
13
Stored Procedure
2019
12
HTML
2018
10
Oracle
2019
8
SSIS
2019
6
AJAX
2007
5
CSS
2007
5
JavaScript
2018
5
LDAP
2018
5
MS Active Directory
2018
5
XML
2018
5
Business Analysis
1999
2
Laptops
1999
2
Data Integration
2019
1
EDI
2019
1
ETL
2019
1
AWS
2019
1
AWS EC2
2019
1
AWS S3
2019
1
Cloud Infrastructure
2019
1
Cloud Solutions
2019
1
Cloudwatch
2019
1
Compliance
2019
1
PowerShell
2019
1
SSH
2019
1