Sailaja

RESUME Sailaja S - Mobile :- Objective: competitive position in the industry which would make best use of my skills and to be a part of progressive organization that gives a scope to enhance my knowledge and skills in a productive way for the growth of organization and individual. Professional Summary Senior Software Engineer with over 6+ years experience in Requirement gathering, analysis, design, development and support of software applications. Experience in design, development, support and maintenance of applications for Healthcare, Travel and Airlines domain Highly adept at promptly and thoroughly mastering new technologies Proficient Knowledge in SQL and PL/SQL Excellent experience in performance tuning. Having good knowledge about Data Ware Housing and ETL concepts. Ability to drive and translate business requirements into technical architecture and design Solid understanding of Data Integration concepts using ETL technologies 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 Airline and Banking domains Onsite experience with Qatar Airways, DOHA Self Starter and Team Player with excellent analytical, communication, organizational and interpersonal skills Experience Summary Sr. Engineer in IMS Health India Pvt. Ltd. from Oct 2013 to Nov 2014 Senior Consultant in Oracle Financial Services Software from Dec 2011 to Oct 2013 Systems Analyst in Sonata Software from Aug 2008 to Dec 2011 Technical Skills Functional Areas: Healthcare, Banking, Airlines Operating Systems :UNIX, Windows Languages :SQL, PL/SQL Database :Oracle 11g/10g/9i, MS-Access, SQL Server Database Tools:Oracle SQL *Plus, Toad, PL/SQL Developer, SQL Developer, SQL Server 2005/2008 ETL Tools: PL/SQL, SSIS Reporting Tools: SSRS, Microsoft Office Performance Point Server 2007, Business Scorecard Manager 2005 (BSM), Proclarity 6.3, Dundas Chart and Gauge Defect Management Tools: Rational clear Quest, Bugzilla Achievements Microsoft certified in SQL Server 2008 1Z0-047 - Oracle Database SQL Expert Got Spot appreciation award for timely Oracle Interface changes Got appreciation from the client for the business solutions provided Projects Handled For IMS Health India Pvt. Ltd. (Oct 2013 – Nov 2014) #1.Title: SDI DataMart Duration:Oct 2013 – Nov 2014 Tools:PL/SQL Developer, TOAD, PVCS, Cybermation Role : Developer/Business Analyst Team size : 11 Responsibilities: Development of new datamarts for client specific requirements. Management of pharmaceutical data acquired globally and utilizing it for providing business intelligence solutions as per business user’s requirements Monitoring the loading process of acquired data over the month and resolving the issues during the run time. Automating the regular deliverables to reduce the human intervention and schedule it using cybermation tool. Work on compliance and persistency of the patients on drug consumption as prescribed and generate the report over it. Have worked on 2 source conversion projects and has gone live successfully. To tune the processes that take longer time to run and to save the run time hours. For OFSS (26DEC11 – present) #1.Title: MASHREQ Bank, UAE Duration:Jun 12 to till date Tools:PL/SQL, JavaScript, BIP, RAD Tool Client: Mashreq Bank Role : Developer/ UAT support/ Production Support Team size : 18 Description: The purpose of this project is to implement our product FLEXCUBE in Mashreq Bank, UAE with the customizations required in specific modules of the product according to customer’s requirements. Installation and customization is done at onsite by onsite team and is supported by offshore consulting team. Responsibilities: Work closely with the Quality Assurance team to ensure professional delivery of technical implementations Instrumental in generating the trace files and analyzing them for optimal performance of queries. Preparing the Impact analysis for the enhancements planned Coding in the respective PL/SQL blocks, Java script files BIP Reports development and support Independent Unit Testing Performance tuning Production support – L0/L1 support Consolidating & Reporting the team’s daily status report #2.Title: ASKARI Bank, Pakistan Duration:Feb 12 to Jun 12 Tools:PL/SQL, JavaScript, RAD Tool Client: Askari Bank, Pakistan Role : Developer Team size : 4 Description: The project involves upgrade and Enhancements for Askari Bank Release 3.0 of banking product FLEXCUBE. The main idea was to make additional changes to the product as per client’s requirements like Customer initiated transaction during "Dormancy" not to be allowed, Utilization of missing sequence, Cheque numbering change, etc. Responsibilities: Schema Setup using Import and Export utility of Oracle 10g Client 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 clear case, DDL tool Unit Testing For SONATA Software Ltd (27AUG08 – 22DEC11) #1.Title: QOSMOS Duration:Oct 09 to Dec 11 Tools:Oracle 10g, Linux, PL/SQL. Client: Qatar Airways Role : Developer/DB team lead Team size : 15 Description: QOSMOS is a web application developed from scratch in SONATA to help Qatar Airways have a process oriented application to manage their in-flight catering operations. Various modules the application provides are Equipment Management, Meal Planning, Bonded Stores and Finance. 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 Creation and maintenance of 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 #2.Title: CargoBI Duration:August 09 – Jan 10 Tools:Oracle 10g, Linux, PL/SQL, Business Objects Client: Qatar Airways Role : Developer Team size : 7 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 #3.Title:Travel Analyzer Duration: April 09 to July 09 Tools:SSIS2008, SSAS2008, SSRS2008, MOSS 2007 Client: Internal Role : Analyst/Developer Team size : 3 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. Academics Master of Computer Applications (MCA) from Jawaharlal Nehru Technological University Bachelor of Commerce (Computer Applications) from Sri Venkateswara University Passport details Passport No: H- Place of issue: Hyderabad Valid Until: 29/07/2018 PERSONAL DETAILS Sex: Female DOB: 08/10/1984 Languages known : English, Hindi, Telugu, Kannada Nationality: Indian Marital status: Married Date: 18-Feb-2017 Place: Bangalore