IT Consultant
Kuwait Airways
Total years of experience :10 years, 3 Months
• Installation and configuration of IBM Information server on AIX and Windows.
• Data mining expertise & Ability to quickly learn technologies.
• Develop and Support ETL jobs to extract the source data from various sources and load into data warehouse schema.
• Support the team in Testing the reports / ETL Jobs developed.
• Create Alerts for the Data load delayed from the Source areas.
• Involved in the creation of dimension schema including dimension tables, fact tables and aggregate tables.
• Configured versioning Platform for the team to have a shared access to the required documents.
• Conduct unit tests using various test cases as well as conducted QC testing.
• Monitoring the jobs and providing Production Support during weekends as well when required.
Checking the requirements of client divisions and developing the OBIEE reports.
Development & Maintenance of DashBoards.
Responding to the concerns of the users with the Dataware house.
Hands on Experience in modifying and Enhancement of the reports in DashBoards.
Troubleshooting the issues and fine tuning the SQLs to improve the performance .
Resolving the issues raised by the users in BMC Remedy .
CIS activities that include Deployment of the reports as per the schedule.
Coordinating with the DBA for changes in the Dataware house .
My work in this organization includes Installation and Maintenance of SQL Server, Creation of new instances based on the requirement, Adding users in the server and maintain security by providing necessary access to the database, Monitoring and optimizing the performance of the database, Tuning the long running SQL Queries and all other activities that a DBA does. in addition to that i am handling development tasks as well
Worked with Tech Mahindra since Dec 2013 as a Software Developer (Work experience of 3 years 5 months ).
Expertise in Developing PeopleSoft Applications, PS9 Upgrade (9.0 to 9.2 ), Application Engines, SQR Reports, Peoplecode, File Layout, Workflow, Business Applications in Analysis, Coding, Design, Development, integration broker, Implementation and Unit Testing of applications..
Strong at SQL and PLSQL .
Successfully completed my Engineering in the stream of Electronics and Communication in Distinction with a percentage of 75 . Along with academics, i have taken active part in National Symposiums, Technical Meets and Seminars During my Engineering .
I have been the best throughout my academics and was a part of outdoor games as well .