Professional Summary

• Senior Systems Analyst with over 3 years experience in Requirement gathering, analysis, design, development and support of software applications.
• Experience in design, development, support and maintenance of applications for Banking and Finance domain
• Highly adept at promptly and thoroughly mastering new technologies
• Sound Knowledge in SQL and PL/SQL
• Excellent experience in performance tuning.
• Having good knowledge about Data Ware Housing.
• Ability to drive and translate business requirements into technical architecture and design
• Solid understanding of Data Integration concepts.
• Extensive experience in data analysis and logical/physical modeling
• Proficient in leading team, developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives.
• Good knowledge in Finance and Banking domains
• Onsite experience with Rak Bank Implementation
• Self Starter and Team Player with excellent analytical, communication, organizational and interpersonal skills

Technical Skills

• Operating Systems : Win9x/NT/2k/XP, UNIX, LINUX Languages : SQL, PL/SQL, C, C , and Java,Vb.Net,C .Net
• Database : Oracle 11g, Oracle 10g, Oracle 9i, SQL Server
• Database Tools : Oracle SQL Plus, Oracle iSQL Plus, Toad, PL/SQL
• Developer, SQL Developer, SQL Server 2005/2008.
• Web Technologies : Asp.Net,HTML,JavaScript,VBScript
• Reporting Tools : Microsoft Office Performance Point Server 2007,
• Business Scorecard Manager 2005 BSM , Proclarity 6.3, Dundas Chart and Gauge

Projects Handled

Confidential

Role : Developer

Responsibilities:

• Preparing the Impact analysis for the Change Request or Work Requests
• Preparing the Functional Requirement Specification
• Preparing the Design Specification
• Coding in the respective PL/SQL blocks, Javascript files and RADXMLs
• Preparing the Program Specification
• Preparing the Unit Test Plans
• Code deployment in clearcase, DDL tool
• Unit Testing

Confidential

Role : Developer

Responsibilities:

• Convert the Business use cases into Technical specification documents
• Involved in complete development of database support required for application for the Equipment, bonded stores modules. Support involved
• Creates and maintains all databases required for development, testing, and production support usage
• Creation of DB links to get data from databases, Loading data from XML, excel source files
• Writing complex procedures, functions, schedule jobs
• Performance tuning
• Backing up and restoring of databases using GUI as well as cold back up
• Creation of final script to be deployed on the UAT Database
• Suggestions to better data modeling
• Documentation involving ICD, MOM, Status updates
• Involved in daily status calls and coordinated with developers, testers, team lead and all stakeholders to finish task assigned smoothly within stipulated time frame
• Involved in giving a walkthrough to the development team about the new requirement, also involved in getting all the clarifications being answered and updating the FS and getting it signed off from the Business team
• Code deployment in UAT and PROD systems
• Preparing the Impact analysis for the Change Request or Work Requests to be raised and tracking the progress.
• Data migration from QOSMOS to Oracle interfaces and vice versa
• Has been part of the application Roaster support team onsite

Confidential

Role : Developer

Description :

The objective of this project is to create a Data Warehouse Solution for Qatar Airways Cargo. The Conceived data Warehouse will extract information from multiple systems to give a more holistic view of the data and will help Qatar Airways to monitor operations better and to take informed decisions.

Responsibilities:

• Convert the Business use cases into Technical specification documents
• Involved in development of data warehouse involving:
• Writing the shell scripts and control files for data extraction process
• Development and maintenance of Dimensions and Facts for ETL process
• Documentation involving ICD, MOM, Status updates
• Performance tuning
• Code deployment in UAT and PROD systems
• To study performance related issues and improve performance of the existing code
• Preparing the Impact analysis for the change request to be raised, raising the New work requests and tracking the progress
• Was able to quick fix production issues
• Coordinated with Qatar Business team and got sign off for the critical reports
• Has given KT on the whole flow to the other team members - data extraction from source systems to data loading into DW
• Got appreciations for cracking out history maintenance in Facts and exception handling logics

Confidential

Role : Analyst/Developer

Description :

• This Project is a Business Intelligence application developed to analyze international travel costs and help in cost cutting measures. The Travel Analyzer application analyzes the travel costs across parameters like sector, carrier, project, groups and travel agent helps us take some very important decisions like
• Which is the most economic airlines
• Which travel agent to be chosen based on the discounts offered
• How to route the travel

Responsibilities:

• Database design using SQL Server 2008.
• Design and development of the dimensional model.
• Extraction, Transformation and Loading of data through SQL Integration Services 2008.
• Designing and creating cube solution by SQL Analysis Services 2008 on top of data ware house built.
• Creating SSRS reports using SQL Reporting Services 2008 by fetching data from SSAS using MDX and also from data warehouse using SQL.
• Developing front end application using MOSS 2007.Integrating reports in the front end application.