plastemartjobs.com Email: jobs@plastemart.com, hr@plastemart.com Download Date: 6/1/2025 6:13:05 PM ________________________________________________________________________________________ RefNo: CA - 31865 Gender: Male Age: 29 Designation: Systems Engineer Highest Education Level: Masters - Degree Preferred Location: Mumbai Notice Period: 30 Days Education Details: 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: 8 Work Experience Details: 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. ________________________________________________________________________________________