Rudrik Gandhi
7587 Hearth Dr; Hanover Park, IL 60133
Cell# 847-463-0337 email: rudrik.gandhi2025@gmail.com
PROFESSIONAL OVERVIEW
As a Technical consultant, I am analytic, detail oriented and problem solving skills in configuring,
supporting and modifying platform. I am involved in gathering requirements, preparing business
solution and technical documents, analyzing data, planning, reporting and executing testing.
Technologies
· Databases: MS SQL Server 2008 R2, MySQL, Oracle 11g, DB2, Access
· SSMS, SSIS, SSRS, SSAS, ETL tools
· Programs: NetBeans, Oracle Dev., Toad
· Software: MS Office, Project, Visio, VPN client, Remote Desktop
· Server: Weblogic, Tomcat, WAS
· Methodology : Waterfall, Agile, SCRUM
· CMS: Wordpress, Drupal, Joomla
· Search Engine Optimization, Google Analytics tool, Google SVN repository
· OS: Windows, Linux
· Mobile: Android
· HTML, CSS, JavaScript, XML, JSP, SOAP
· WebSphere Integration Developer, IBM ESB, WSo2 ESB
· Protocol: JMS, Web Services
· Sterling OMS, WebSphere Application Server, WC, Yaardi
· Eclipse, RAD, Java, Python
· Testing Tool: HP Quality Center (QC)
· Testing Methodology: smoke, functional, integration, regression
Education
·
Professional Training/Certification
B.S. Information Systems
DePaul University
Chicago, IL, US
· Sterling Commerce 9.0
· WebSphere Commerce 7.0
· SQL Server 2008 R2 Business Intelligence
PROFESSIONAL AND BUSINESS EXPERIENCE
Perficient Inc
Chicago, IL - Technical Consultant
I was working on client project where I gained hands on experience on Sterling 9.1 and service
framework. I was responsible for executing OMS functional, integration and unit testing. I was
involved in build process for DEV and QA machine. I collaborated with team member to resolve
implementation issue and defects. I worked on POC for Web Sphere Commerce and Sterling Order
management integration. I developed process flow, sequence, use cases, data flow, and data model
diagrams.
Responsibility:
•
•
•
Planning and execute OMS functional test cases; raise and track defects in QC
Analysis and minor changes to custom code
Involved in QA data purge and performance test case
Page1
06/2011 11/2012
–
•
·
Examine xml message going to external system
Created UML diagram on MS Visio
Skills Acquired:
•
•
•
•
•
•
•
Install and Implement Sterling commerce to Windows/Linux
Configure pipeline, transaction, agent, events, and services
CDT process on local machine
Extend Sterling application and database columns
API tester and services to verify orders in OMS
SQL queries to verify order and item data in database
Debugging Application through verbose utility
Project: Tractor Supply Co.
I was responsible for planning test cases and executing OMS functional and End-to-End test cases in
HP QC. I was involved in configuration and troubleshooting Sterling and ESB integration.
• Install and Implement Sterling commerce in Windows and Linux
· Generate XMLs mapping from ESB to OMS integration solution
· Validate output XMLs in database table
• Extending Sterling application and DB2 database
• Executing functional and integration testing; raise\follow-up defect in HP QC
• Using API tester and services to verify inbound\outbound order in OMS
• Write SQL queries to data analysis in OMS DB
Chicago Housing Authority
Chicago, IL Application Support Intern
–
08/2010 05/2011
–
I was responsible for supporting Yaardi application and assisting the development team in writing
SQL queries to generate reports; updating and modifying security matrix for user group on
application
· Provided & Maintained Yaardi Application for internal and external user
· Troubleshoot user’s ticket and write SQL queries code in Toad software to generate user’s
report
· Maintained and updated IT Asset Explorer Management software
· Debug SQL queries to generate correct output
· Call end user to troubleshoot or escalate on current ticket
DePaul University
Chicago, IL Class Project
–
08/2009 06/2011
–
A class project provided experience in developing a large-scale application and business solution.
This project gave skills in developing Web applications and the confidence to work on large-scale
applications.
· Designed an Web Application that involved car rental account transactions and data
processing; analyzed data for invalid and valid transaction
· Experience with unit and integration testing on web application modules
· Designed and implemented project solution and design document; created UML diagram
· Created business solutions for web application which include project planning,
requirement, design, testing, deployment
· Designed database schema and wrote PL\SQL queries in functions, procedure, trigger
· Implemented SSIS packages for data extraction and load; created various reports using
SSRS and Report builder; developed multidimensional cube in SSAS for data drilling and
data mining
Page2