SHRUTHI PRESCILLA M
State of Qatar.
Mobile : +974-********
Email : email@example.com
Carry an experience of 7+ years, as a Software Developer and Database Administrator, in the domain of ‘Data Warehousing’, ‘Database Administration’ and ‘Web Development’.
Proven leadership in driving Quality Processes and exceeding quality expectations for efficient product delivery.
Expertise in solution design, database building, Coding, troubleshooting and issue management of various projects.
Expertise in testing methodologies, defect logging, tracking and regression testing.
Modularized and resolved problems with structured thought process and models.
Possess unique blend of top notch interpersonal skills, business intelligence and customer relationship management.
Successfully developed various projects and provided maintenance and further enhancements. EDUCATION
St. Joseph Engineering College,
(Affiliated to Visveswaraiah Technological University) Mangalore, India Bachelor of Engineering (BE) - Computer Science 2003-07 EXPERIENCE
University College of London (UCL), Qatar Foundation. Doha, Qatar Database Administrator 2015 March - 2018 March
Freelancing Bangalore, India
IT Consultant (Software & Web Developer) 2011 January - 2012 December iGATE Global Solutions Ltd. Bangalore, India
Software Developer 2008 June - 2010 September
Domain Data Warehousing / Database Administration
Programming languages PL/ SQL and Unix Shell scripting, C, C++, Java 5.0 Relational Database
Oracle 9i, DB2, MySQL, MS SQL Server 2012
Web & Client-Server
Apache Tomcat, IIS Server
Operating Systems Linux (Basic), Windows 2010
Informatica PowerCenter, Teradata Sql Assistant, Secure Shell, TOAD, Redwood Cronacle, QlickView, SQL Server Management Studio, SQL Server Migrating Agent, Vignette Application Portal (VAP 7.3), Vignette Content Management (VCM 7.3.1), Eclipse, phpMyAdmin, Task Scheduler, SPSS, Windows Task Scheduler, MS Suite of products. 2
1. Database Administrator
Created DB procedures, functions and triggers, and performed periodic and continuous review of the DB loading process, application related jobs, and data replication activities
Responsible for the implementation of the DB security roles, users, accesses and assigned privileges
Participated in the design, development, testing, implementation and maintenance of the database structures (E.g. Tables, indexes, etc.),
Worked closely with ETL development team and other DB architect and developers to set up interfaces and procedures by following the best practices / conventions within the team (including peer code review), whilst helping to deploy applications to UAT and production environments.
Created/Programmed many PL/SQL and UNIX Shell Scripts. Hence, carry, strong programming experience in PL/SQL and UNIX Shell Scripting.
Provided Query tuning suggestions to Application teams to improve Application performance, performed jobs scheduling and recommended/created automated database solutions to improve workflow. Hence carry deep experience in the application of the information technologies to business solutions.
Assessed and resolved complex issues with the strong analytical and problem solving skills, coupled with effective facilitation, communication and teaching/mentoring skills. Hence, carry organizational proficiencies of working in cross functional teams, multitasking and managing time independently, in a fast-paced environment with little direction; along with the ability to adjust to changing business needs, quickly.
Strong ability to prepare and present technical documentation coupled with the ability to communicate in a professional manner when interacting across staff levels and internal/external customers. Hence, proven ability to work independently or as an integral member of a team.
Demonstrable experience with project management, system implementation, and integration, coupled with excellent people management skills in a team environment
Proven ability to maintain leading edge skills in a rapidly changing information systems environment. 2. ETL Developer
Gathered requirements, designed and developed database solution; which included database configuration, data modeling, and identification of trusted data sources, database creation, and ETL processes etc.
Served as the data analyst/expert and created views for Cognos developers to complete reporting requirements.
Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems that comprise databases, flat files to the Staging area, ODS/EDW
(Operational Data Store/Enterprise Data Warehouse) and then to the Data Marts whilst focusing on reusability, standardization, cleansing of the data and validation of the addresses. (Mappings were created using different look-ups like connected, unconnected and dynamic look-up with different caches such as persistent cache, whilst using reusable components like worklets, mapplets using other reusable transformation).
Additionally, compatible views from ODS/EDW were also created, which were used to build reports from tool called QlikView.
Subsequently, automation was achieved by undertaking multiple jobs scheduling, which was achieved through Redwood Cronacle.
Created BTEQ, MLOAD and FLOAD scripts for loading and processing input data, whilst creating and executing macros using Teradata SQL Query Assistant (Queryman) and TOAD.
Performed Impact Analysis of the changes done to the existing mappings and provided the feedback.
Involved in the performance tuning of targets, sources, mappings, and sessions. Hence, wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
Used Erwin for Logical and Physical database modeling of the warehouse, hence, responsible for database schemas creation based on the logical models; whilst created and monitored sessions using workflow manager and workflow monitor.
Analyzed and executed the test cases for various phases of testing - integration, regression and user testing.
Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools.
Managed team and cross teams knowledge sharing system whilst coordinated and documented project's lessons learnt; coupled with the abilities of prioritizing and handling multiple tasks in high-pressure environment.
Provided training and mentoring for junior database developer to resume with steady state operations. 3
3. Web Developer
Created various Content Management System (CMS), CRM (Customer Relationship Management) applications, which served as an interface for clients, thereby helping in visualizing large datasets for analysis, hence, a great help in gaining deeper insights whilst ensuring, cross-browser compatibility and the user ease.
Designed, developed and maintained web applications, dynamic websites and user interfaces for various clients, including the new database-driven web interfaces for rapid file transfer and data communication, thereby offering an efficient, faster and paperless solution, hence increasing the customer satisfaction.
Performed software enhancement and tested newly implemented processes, along with the validation of the completed sites including the debugging and the testing of the code.
Created user accounts and managed access control of desktop and network applications whilst implementing Single Sign On.
Managed several Web and FTP /SMTP servers in production and development through IIS on Windows Server.
Responsible for the Page Layout & Graphic Design and Web Content. Subsequently, uploaded content and graphics to the website. Hence exposed to Vignette Application Portal (VAP) and Vignette Content Management (VCM). Detailed project specific information will be provided upon request. PERSONAL DETAILS
Nationality : Indian
Marital status : Married
Languages Known : English
Visa Status : Resident Permit (under husband sponsorship) Hobbies & Interest : Listening to music, reading, solving numerical puzzles DECLARATION: I hereby declare that the information furnished above is true to the best of my knowledge. Date:
Place: DOHA (Shruthi Prescilla M)