• Gender: Male
• Age: 29
• Designation: Systems Engineer
• Highest Education Level: Masters - Degree
• Notice Period: 30  Days
• Preferred Location: Mumbai
• Work Experience: 7.9 Year(s)

Education

Master Of Science In Information Technology In Information Technology

Skill Sets

Skills
• Tools: MS SQL Server Management Studio,
• Language: Python(beginner), SQL. ALM, Visual Studio, SQL Server Data Tools, Putty.
• Databases: MS SQL Server, MySQL, Maria DB.
• SQL Server Integration Services
• SQL
• HTML5
• Python
• Agile

Work Experience

Systems Engineer
From February 2018 to Present
Company profile- multinational information technology company that provides business consulting, information technology and outsourcing services

Job profile-
• Experienced all facets of SDLC including requirements gathering, designing, coding, testing and
deployment.
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Currently developed an intermediary application (Master Data Management) which is used to fetch the
Products and Sales data from different sources, i.e. from JD Edwards and SAP Sunrise
and SAP Turbo systems into the Application.
• Developed various Stored Procedures, Indexes, Triggers, Views for the application functionality
to push the data from the application to the successive applications for Business reporting.
• Additionally, developed various SSIS packages for the application to run the flat file data import
from excel source to the SQL Database using SSDT.
• Familiar with using JD Edwards system for data import into the application using IBM Windows
software hosted on the application servers.
• Developed various SQL server JOBS in SSMS 2014 hosted on the Shared SQL cluster to execute
the SSIS packages.
• Written queries for SQL fine Tuning as per business requirement when using complex JOIN and sub
queries for business reporting requests.
• Serving Ad hoc business reports by writing SQL queries in minimal time for data analysis and
management.
• The application had 3 successive systems hosted on different database clusters, responsibility
was to enhance/manage the data and routines in all the successive systems of the application.
• Recently developed a whole "UPDATE ROUTINE" as per business requirement for the Products
and Sales figures in all the three aforementioned systems where the data from Master Data
Management application travels.
• Skilled in using tools like HPQC and ALM for creating, testing and managing test scripts and defects.
• Additional logical experience of Application lifecycle management respective of the servers, the hosting
DB clusters, hosted Citrix farms.
• Participated in all Agile meetings like Daily standup, Iteration Planning, Pre-Estimation and
Code review. Also, used to drive meetings for bug fixes, requirement gathering and for bits and parts
of application level issues.
• Documented technical workflows like URS and FRS as per the Business and Technical
requirements.
• Skilled in business communication since it was a front facing client and Business connect,
weekly meeting, status update meetings were very frequent.

GIS Analyst
June 2017 to February 2018
Company profile- multinational group dealing with mapping, location data and related automotive services to individuals

Job profile-
• Coded different navigation schemas like RDMs, Manoeuvres, navigation directions using the tools
EarthScape.
• Used to attend daily meetings, Weekly meeting, status update calls for tracking the progress.
• Was simultaneously managing the Error reduction data tool, which needed initial review to check the
coding was correct or not.
• Business interaction and communication exposure was on weekly or monthly basis.