Project Developer

FASEELA E K

Email: *********@*****.***

Contact Number: +971-*********(Dubai)

Professional Summary

Database consultant with 10 years of experience in designing and building database applications for Airline, Retail and Healthcare business domains.

Experience in Designing, Developing and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL and in MS SQL server 2012 using T-SQL in Windows and UNIX environments.

Substantial experience in creating complex SQL and T-SQL queries, PL/SQL stored procedures, functions, packages and triggers.

Extensive experiences in SQL query optimization, performance tuning of PL/SQL code and Data migration.

Good understanding of DW concepts of fact-dimension model and star- snowflake schema structure.

Experience of using ETL tools Informatica PowerCenter 8.5 and Pentaho kettle for ETL development and testing.

Managed a team of size 5 successfully all through Requirements gathering, design, development, testing and implementation.

Technical Expertise

Databases:

Oracle 10g/11g, MS SQL Server 2012

Programming Languages:

SQL, T-SQL, Oracle PL/SQL, Pro*C

Design Tools:

Rational Rose, Oracle J-Developer, Toad Data Modeler

Development Tools:

Toad 9, Oracle SQL Developer

ETL Tool:

Informatica Power Center 8, Pentaho 5.0

Operating System:

Windows, Unix, Linux

Configuration Tools:

Visual SourceSafe, Rational clear case, Tortoise SVN

Test Management Tool:

Quality Center 8.0

CRM Solution

Salesforce

Employment Record

Organization:

FlyDubai, Dubai, UAE

Duration:

2014-2015

Designation:

Database Consultant – Served as Data architect and Lead ETL developer in Designing, Developing and Maintaining database applications in Oracle and MS SQL server and data warehouse applications for FlyDubai.

Profile of the Organization:

FlyDubai is Government of Dubai’s, low-cost airline. FlyDubai is operating more than 1,100 flights a week, taking thousands of passengers to destinations throughout the region.

Organization:

Cognizant Technology Solutions India Pvt Ltd.

Duration:

2010-2014

Designation:

Oracle Consultant – Served as Solution Architect in Designing, Developing and technically leading the team for database applications in Oracle and MS SQL server and data warehouse applications for various retail and healthcare insurance clients.

Profile of the Organization:

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services.

Organization:

IBS Software Services Pvt Ltd, India.

Duration:

2005-2010

Designation:

Team Leader – Served as Solution Architect in Designing, Developing and Maintaining airline PSS (passenger service system) in Oracle for various airline clients.

Profile of the Organization:

IBS is a leading new-generation IT solutions provider to the global Travel, Transportation and Logistics industry.

IBS is SEI CMMI Level-5 and PCMM Level 5 assessed and

ISO 9001:2000, TickIT and ISO 27001:2005 certified.

Certifications & Achievements

Oracle 10g certified Database SQL Expert.

Completed the Oracle University course Oracle Database 10g: SQL Tuning.

Oracle 10g Database Administrator Certified Professional.

Got outstanding performance award as a developer.

Project Experience

Project Name:

Crystal Reports Datawarehouse

Project Description:

Crystal Reports Datawarehouse project is for building a primary data source, for all the crystal report requirements of different departments of FlyDubai.

Clients:

FlyDubai - Dubai

Duration:

Jan 2015 – Mar 2015

Environments:

Oracle 11g, MS SQL Server 2012, Pentaho 5.0, SQL Developer, Windows, Unix

Role in Project:

Data architect and Lead ETL developer

Responsible for defining and developing the framework for ETL process that collected, cleansed, and integrated FlyDubai’s performance data from various operational source systems.

Worked closely with Project Managers, Technical Managers, subject-matter experts to obtain requirements, objectives and business rules for the project.

Design and implement transformations and jobs to extract data from different source databases and load into Datawarehouse, by writing SQL and PL/SQL programs and using the ETL tool pentaho.

Project Name:

Salesforce CRM Implementation

Project Description:

The Salesforce CRM implementation project is for implementing Salesforce as FlyDubai’s CRM solution. Data from different modules of FlyDubai’s passenger reservation system will be loaded to Salesforce cloud to better analyze the system to improve customer services.

Clients:

FlyDubai - Dubai

Duration:

Jun 2014 – Dec 2014

Environments:

Salesforce CRM, Pentaho 5.0, MS SQL Server 2012, Oracle 11g, SQL Developer, Windows, Unix

Role in Project:

Data architect and Lead ETL developer

Responsible for integrating different modules of FlyDubai’s reservation system with Salesforce cloud.

Design and implement transformations and workflows to extract data from different source databases and load into Salesforce cloud, by writing SQL and PL/SQL programs and using the ETL tool pentaho.

Automating different upload process to Salesforce cloud using Pentaho transformations and jobs.

Ensure the quality of data loaded to Salesforce cloud.

Project Name:

EDW Claims Solutions

Project Description:

Enterprise Data Warehouse (EDW) is the primary data source for Enrollment of medical Claims data (historical and ongoing) for all Analytic and Reporting requirements within the organization. The project is for developing transformations and jobs for data upload to EDW, testing and ensuring the data quality of the data warehouse against different source databases.

Clients:

Wellcare, Blue Cross Blue Shield of Michigan – BCBSM - USA

Duration:

Sep 2011 – Jan 2013

Environments:

EDW, SQL, Oracle 10g, MS SQL Server 2008, Informatica Power Center 8, Quality Center 8.0, PLSQL Developer, Windows, Unix

Role in Project:

Offshore Team Lead

Designed workflows using Informatica PowerCenter 8.5 tools -Mapping Designer, Repository manager, Workflow Manager/Monitor for data upload to EDW.

Prepared Test Plans and Test schedules and ensured the testing activities are completed as per schedule.

Reviewed the ETL mappings to ensure the transformation rules are applied correctly.

Prepared and Reviewed Test Scenarios and Test Cases for ETL to compare source and Target database systems.

Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline views and Union in Oracle for data validation of EDW tables and columns against source data.

Executed the workflows in the Informatica workflow manager, to start the ETL process.

Executed the Test Cases.

Used Quality Center for creating and documenting Test Plans and Test Cases, register the expected and actual results and defect reporting and tracking.

Technically leading the team and interacting with clients and senior managers and update the status and provide daily and weekly status reports.

Project Name:

Inventory Management System

Project Description:

The Inventory Management System is for building a single consolidated inventory system which contains all the statistical data of different store operations. This system will allow organization to leverage inventory data for decision making and to improve data integrity.

Clients:

RadioShack, HEB - USA

Duration:

Sep 2010 – Aug 2011

Environments:

SQL, PL/SQL, Pro*C, Oracle 10g/11g, Oracle SQL Developer, Toad 9, VSS, Windows, Unix

Role in Project:

Oracle Consultant

Designed and developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Prepared DDL scripts for creating and altering database objects like Tables, Views, Indexes, Synonyms and Sequences.

Identified performance bottlenecks in SQL queries, PL/SQL Stored Procedures, functions and in Pro*C code.

Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN.

Analyzed and computed statistics to improve response time for queries.

Used partitioning and sub partitioning of tables to improve performance.

Done performance testing of SQL scripts and PL/SQL packages.

Technically leading the team and interacting with clients and senior managers and update the status and provide daily and weekly status reports.

Project Name:

iFly Res 2.0/2.1

Project Description:

iFly Res is an Airline Passenger Services System addressing passenger reservations, flights and schedules management, inventory control, fares & ticketing, and departure control functions of commercial airlines.

Clients:

Virgin America Airlines, Energet Airlines, Vision Airlines, Fuji Dream Airlines, Amakusa Airlines.

Duration:

Oct 2008 - Jun 2010

Environments:

Oracle 10g, SQL, PL/SQL, JDBC, Weblogic 9.2, jdk1.5, Solaris/Linux, Toad, Oracle SQL Developer, Rational Rose, Oracle J-Developer, VSS, Rational clear case, Tortoise SVN

Role in Project:

Team Lead

Responsible for requirements gathering, developing data models and designing the database.

Analyzed the functional specs provided by the data architect and created technical spec documents for all the enhancements.

Designed and developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Prepared DDL scripts for creating and altering database objects like Tables, Views, Indexes, Synonyms and Sequences.

Debugging PL/SQL procedures, functions and packages.

Identified performance bottlenecks in SQL queries, PL/SQL procedures, functions and packages using ASH and ADDM reports.

Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and SQL tuning advisor.

Used Bulk Collect feature to improve performance.

Responsible for designing the data migration strategy for the application version upgrade, developing and optimizing scripts for data migration as well as roll back (Fall back strategy).

Analysis and defect fixes for the issues reported in production environment.

Involved in production database monitoring and performance issues analysis using Oracle Enterprise Manager Database Control.

Worked as Team lead responsible for mentoring and guiding the team members

Educational Qualification

Course

Institution/University

Specialization

% of Marks

Year Of Passing

B-Tech

M. G. University

Electrical & Electronics Engineering

76

2005

Pre Degree

M. G. University

Mathematics, Physics, Chemistry

86

2001

S.S.L.C

Kerala State Board

S.S.L.C

94

1999

Personal information

Name:

Faseela E K

D.O.B:

20-May-1984

Gender:

Female

Marital status:

Married

Permanent Address:

Firos Manzil, Puzhavath, Changanacherry, Kottayam - 686101, Kerala, INDIA

Address for Communication:

Flat No: 201, Hussein Obaid Ghubash Building, Al Qusais First, Dubai, UAE.

Phone Number:

+971-*********(Dubai), +91-940*******(India)

Nationality:

Indian

Passport No:

L4175333 valid till 07-Aug-2023

Visa Details:

Residence VISA valid till 26-Nov-2015

Languages known:

English, Hindi, Malayalam

Contact this candidate