Senior Software Engineer - Team Leader
Emirates Airline
Total years of experience :16 years, 3 Months
Database - Oracle 12c, 11g, SQL Server, Elastic Search and Hadoop Big-Data.
Warehousing Tools - Business Objects, TOAD, PL/SQL Developer
Web Technologies - ASP, ASP.Net, VBScript, XML, HTML, DHTML and JSON
Applications/ Tools - VB 6, VB.NET, C, C#, COM, DCOM and Java
Operating Systems - Win10, Win7, XP, NT/ 2000/ 98
- Application / DB Development - Database Management - Project Execution
- Business analysis - Training & Development - Team Management
- Requirement Gathering - Technical Support - System Administration
A competent professional with nearly 15 years of experience in:
Presently associated with Emirates Airline (Dubai), assigned to PSS department on development and support real time data interfaces of passenger check-in, booking, ticketing from MACS, MARS system to other applications.
Environment: VB.NET, ASP.NET, SQL Server2000, 2005 and Seagate Crystal Report 2008.
Key Highlights:
Performed analysis of EPR functional specifications/ requirements.
Created and managed new database objects: tables, indexes, views, triggers, functions, stored procedures, etc. using SQL Server 2000, SQL Server 2005.
Wrote SQL store procedures to enforce login on the server side.
Converted database objects from SQL Server 2000 to SQL Server 2005
Developed Export, Backup Utilities using SSIS and Reports, Cubes in SSRS using SQL Server 2005.
Involved in feasibility study analysis of the database design and development.
Implemented the business rules by writing SQL Functions and Procedures.
Performed day to day production database monitoring activities.
Worked with the users to identify the business requirements and integrated them into the ERP Applications.
Looked after the tuning database and SQL statements and schemas for optimal performance.
Managed the documentation of each module for user level and system level maintenance.
Environment: Visual Basic 6.0, Oracle 9i and Seagate Crystal report 9.
Key Highlights:
Involved in defining system requirements, designing, developing, testing, training & implementing the application.
Created scripts to insert static records and execute them using SQL*Plus.
Implemented the business rules by writing PL/ SQL Functions, Procedures and Trigger.
Worked with the users to identify the business requirements and integrated them into the Oracle Applications and Performance Tuning.
Wrote complex SQL’s using joins, sub queries and correlated sub queries.
Looked after the documentation of each module for user level and system level maintenance.
Environment: Visual Basic 6.0, SQL Server 2000 and Seagate Crystal Report 8.5.
Key Highlights:
Involved in defining system requirements, designing, developing, testing, training & implementing the application.
Created scripts to insert static records and execute them using SQL*Plus.
Performed:
o Database Design, Coding, and Reporting.
o Unit Testing and Implementation Testing.
Provided database support and worked closely with the development team as they submitted daily changes recorded as releases to the production database.
Wrote complex SQL’s using joins, sub queries and correlated sub queries.
Provided input into project plans for database projects providing timelines and resources required.
Looked after the documentation of each module for user level and system level maintenance.
Environment: Visual Basic 6.0, SQL Server 7, Oracle 8i and Seagate Crystal Report 8.
Key Highlights:
Involved in project plans, collection specifications and project reviews.
Designed and coded visual basic forms involved in forms screen designing.
Maintained and modified the existing user Interface Applications.
Error-Handling Features and VB Built-in Debugging Tools.
Generated reports for various data tables for each module using Crystal Reports
Bachelor in Science (Computer Science) from Nagpur University, India in 1998.