Summary
Overview
Work History
Education
Additional Information
Timeline
Generic

Suresh Guglani

Dell Boomi Architect
Noida

Summary

IT Expert: Task-oriented professional, with the capability to manage multitasking and work under pressure; sticks on to processes & procedures set by the management, targeting senior-level assignment in Data Warehousing/ Data Integration/ Dell Boomi Experience Summary Data professional with over 13+ years of experience in Data Integration, Data Migration, Data Management, Data Administration across Games/E-commerce/Sales/Finance/HR/Supply Chain industry/domain with 6+ yrs experience as Dell Boomi Architect/Developer. Excellent in Microsoft BI Stack Solutions/Dell Boomi (Data Analytics, ETL, DWH, CDATA, and Reporting) & SQL Server development Proven expertise in managing various project related activities including planning, execution, and management in tune with the core business objectives; extending post-implementation support to project team by defining SLA norms Proven expertise in designing and developing Dell Boomi Integration for Salesforce/Remedy/D365/ /JIRA/DynamicsAX/JDEdwards/SAGE/GreatPlains/Anaplan/Concur(SAP)/Get paid/Workday/Azure Datawarehouse/Big Query(GCP)/Azure Blob/SQL Server Expertise in the Software Development Lifecycle (SDLC) right from requirement analysis, documentation (functional specifications, technical design), coding and testing (preparation of test cases along with implementation), Peer Reviews to maintenance Experience in resolving complex integration problems using Dell Boomi Proficient in analyzing and translating business requirements to technical requirements and architecture Working Knowledge of web technologies XML, XSLT, XSD, WSDL, HTML, CSS Strong Knowledge in (SOAP, REST) Web Services & API Management Worked different profiles XML, JSON, DATABASE, FLATFILE Profound experience in building different Mapping Functions using standard functions and custom functions using JavaScript and Groovy Script. Hands-on design, development, deployment, and management of multiple integration processes created on Dell Boomi, detailed configuration of Dell Boomi Atom clouds, local Atoms, and Molecules enabling integration landscapes for the proposed architecture for integration processes. Agile Methodology using Azure DevOps Knowledge of CI/CD tools Have worked as SQL DBA and MS BI Developer Strong leader & team player; excellent motivational skills to sustain forward growth momentum while motivating peak individual performance from team members Hardworking, enthusiastic, and competent in working in groups as well as independently. Efficient in communicating with clients and resolving critical issues Very strong analytical, interpersonal, and problem-solving skills

Overview

14
14
years of professional experience
4
4
years of post-secondary education

Work History

Associate Architect

Aristocrat Technologies India Pvt Ltd
06.2014 - Current
  • Developing Interface/Process for time-sensitive projects while considering business and system requirements
  • Maintaining projects, drafts, files, codes, and scripts in an organized manner that allows other team members to make edits/suggestions/ changes
  • Performing validation and testing for achieving the client objective before the deadline
  • Interacting with the clients for updating them about the status of the project
  • Managing various technical aspects like interface design, coding of modules, monitoring critical paths & taking appropriate actions
  • Providing technical support in the design and development assisting in the development of new processes or enhancement of existing systems based on customer requirements
  • Helping Product manager to convert requirements in Azure Devops user stories and provide estimation and efforts
  • Lead a team of Dell Boomi consultants
  • Anaplan Finance & Anaplan S&OP

Sr. Analyst

Torus Business Solutions Pvt. Ltd, Torus Insurance
10.2011 - 06.2014
  • IT Infrastructure
  • Eam Size 3
  • Escription: Managing over 90+ SQL Server instances with 2000+ databases in Production, UAT, Development and DR environment comprising SQL Server 2008/R2 and 2012 servers
  • Tools: SCOM, Service-Now, TFS,HP Evault ,SharePoint 2010,T-SQL,Powershell,VBScript
  • Oles & Responsibilities:
  • Performing BAU activities and Daily checklist
  • Responsible for deployment, maintenance, performance tuning of Central Data Warehousing Solution used by Senior Management for critical reporting
  • Deployment of SQL Scripts, SSIS packages, SSAS Cubes and SSRS reports
  • Participate in projects calls, deliverables, infrastructure team calls
  • Implementation and maintenance of SQL Server 2012 Always On
  • Installation and maintenance of Analysis Services, Reporting Services(Scale-out) native and SharePoint mode, Integration Services
  • Configuring/Troubleshooting and managing database mirroring and replication for DR and data availability
  • Monitoring, applying patches and Service Packs
  • Automating administration tasks, managing SSIS packages, managing security, monitoring server performance and activities
  • Reviewing SQL Server Error Logs, Windows Event Logs, and Cluster Logs on daily basis
  • Working with backup team to ensure proper backup strategy exists as per requirement
  • Ntegration Projects
  • Nvolved in various integration projects for SSIS using: Payroll, Leave Balance, Biometrics, Responsible for Enterprise Datawarehouse support built on Data Vault 2.0 strategy
  • Worked in role of developer for data migration, integration and reporting requirements
  • ETL packages design and development for data import need for reporting based on SSRS
  • Working with Business Analysts, Application Administrators, End Users, System Admin team, Storage Team, Backup Team
  • Automation of Database refresh activities from production to development/UAT environment

Sr. System Engineer

Larsen & Toubro Infotech Ltd
Mumbai
07.2008 - 10.2011
  • Ingram Micro helps businesses fully realize the promise of technology—helping them maximize the value of the technology that they make, sell or use
  • With its vast global infrastructure and focus on cloud, mobility, technology lifecycle, supply chain and technology solutions, Ingram Micro enables business partners to operate more efficiently and successfully in the markets they serve
  • Achievements
  • Support 200+ SQL Server Instances from SQL 6.5 till SQL Server 2008 R2
  • Migration/Upgrade of SQL Server 2000 to SQL Server 2008 R2
  • Supported backend database infrastructure of e-commerce website
  • Supported backend database infrastructure of Cloud SAAS solution

Education

B.E - Computer Science & Engineering

Kumaon University
01.2003 - 01.2007

XIIth - undefined

Jaycees Public School

Xth - undefined

Jaycees Public School

Dell Boomi Professional Architect - undefined

Additional Information

  • Achievements: , Received “Certificate of Appreciation” Annual Award of Excellence for outstanding contribution to key areas helping the team to meet

Timeline

Associate Architect

Aristocrat Technologies India Pvt Ltd
06.2014 - Current

Sr. Analyst

Torus Business Solutions Pvt. Ltd, Torus Insurance
10.2011 - 06.2014

Sr. System Engineer

Larsen & Toubro Infotech Ltd
07.2008 - 10.2011

B.E - Computer Science & Engineering

Kumaon University
01.2003 - 01.2007

XIIth - undefined

Jaycees Public School

Xth - undefined

Jaycees Public School

Dell Boomi Professional Architect - undefined

Suresh GuglaniDell Boomi Architect