Business Analyst Software Developer

Resume of Shruthi Prescilla *

SHRUTHI PRESCILLA

Doha,

State of Qatar.

Mobile : +974-********, +974-********

Email : ad5wt0@r.postjobfree.com

PROFESSIONAL SUMMARY:

13+ years of professional experience as a Software Developer, Data and Business Analyst, Database Administrator, Nagios Administrator in the domains of Data Warehousing and Business Intelligence, Database Administration, Data Analysis and Applied Intelligence, Web Development, System Monitoring etc.

Proven leadership in driving Quality Processes and exceeding client expectations for efficient product delivery.

Expertise in solution design, Analysis, database building, Coding, Reporting and Demonstration, 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, coupled with conflict resolution techniques.

Possess a unique blend of interpersonal skills, business intelligence and customer relationship management.

Focal point in Business process analysis and modeling, Requirements analysis and negotiation etc, whilst promoting a collaborative environment.

Participated in modeling, design, development, integration, testing, configuration, scheduling and maintenance/support of systems solutions, along with the scope of future enhancements, coupled with the user support and training, which encompasses but not limited to, reporting and presentation.

Created various test plans and system documentation to monitor testing for the implementation of the systems and its enhancements, modifications, application fixes and new releases etc.

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

BAE Systems Applied Intelligence (International) Ltd Doha, Qatar Technical Support Engineer 2020 April – 2024 April Freelancing Doha, Qatar

IT Consultant (BI – ETL / MSBI / Data and Business Analyst / Data Architect) 2018 May – 2020 April University College of London (UCL), Qatar Foundation. Doha, Qatar Database Administrator 2015 March- 2018 March

Freelancing Bangalore, India

IT Consultant 2011 January - 2012 December

iGATE Global Solutions Ltd. Bangalore, India

Software Developer (BI / ETL) 2008 June- 2010 September SKILL SET

Domain

Data Warehousing and Business Intelligence, Database Administration, Data Analysis and Applied Intelligence, Web Development, Monitoring

Programming languages PL/ SQL and Unix Shell scripting, C, C++, Java, Python (Basics) Database System

Relational Database Management Systems (Eg: Oracle, DB2, MySQL, MS SQL Server), Graph Database System (Eg: ArangoDB), NoSQL Database (Eg: Elastic Search, ArangoDB) etc. Technology Web and Client/Server Applications, Standalone Applications, Cloud Applications Resume of Shruthi Prescilla 2

Web & Client-Server

Technologies

PHP, HTML, JavaScript, J2EE Basics(JSP-Servlet/Struts, SpringMVC) Application/Web

Servers

Basics of Apache Tomcat, IIS Server

Cloud Technologies

Salesforce (SAAS), Google Applications, Office 365, Citrix, Lucidchart, Workday, ERP, HRMS, HRIS, CRM applications.

Configuration

Management

TFS, Jira, Confluence, Sostenuto - ITSM

Operating Systems Linux, Windows, Ubuntu

Quality ITIL4 Foundation, Six Sigma Methodology (DMAIC), GDPR Tools

Keycloak, Nifi, Nagios, SQL Sql Assistant, putty, Informatica PowerCenter, Teradata Sql Assistant, Power BI, Secure Shell, TOAD, Jira, Confluence, Cognos (Basics), Power Shell, Redwood Cronacle, QlickView, SQL Server Management Studio, SQL Server Migrating Agent, Vignette Application Portal

(VAP), Vignette Content Management (VCM), Eclipse, phpMyAdmin, Task Scheduler, SPSS, MS Suite of products (E.g. MS Visio etc), Bit Bucket and GIT Bash basics. ROLES PERFORMED

1. Database Administrator

Collaborated with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

Created Business-Crucial data objects to support efficient data storage and manipulation. Created DB procedures, functions and triggers, and performed periodic and continuous review of the DB loading process, application related jobs, and data replication activities.

Worked on SQL Server Integration Services (SSIS) to integrate i.e., Extracting, Transforming and Loading (ETL) data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL) and analyze.

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation and Slowly Changing Dimension, Merge, Join, Union all.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.

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.

Gathered Report Requirements, designed and developed complex queries to generate various reports and visualizations accordingly.

Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.

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 job scheduling and recommended/created automated database solutions to improve workflow. Hence carry deep experience in the application of information technologies to business solutions.

Assessed and resolved complex issues with 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. Resume of Shruthi Prescilla 3

2. ETL / MSBI Developer, Data/Business Analyst, Data Architect

Involved in complete SDLC life cycle. 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.

Demonstrated expertise in data analysis and reporting resulting in improved company performance.

Exposed to data cleansing and data processing resulting in improved data accuracy.

Proven ability to translate complex data into actionable insights for business stakeholders resulting in improved decision- making.

Developed ETL jobs like data transformation using Microsoft SQL Server Integration services.

Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.

Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.

Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services.

Administered minor databases of the facility using SQL Management Studio.

Filtered data from Transient Stage to EDW by using complex queries and using various transformations. Additionally, implemented various Constraints and Triggers for data consistency and to preserve data integrity.

Conducted code review. Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.

Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.

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 lookups 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 made to the existing mappings and provided 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.

Created various dashboards for easier and quicker understanding whilst data visualization.

Managed team and cross team’s 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 developers/analysts and worked along with the data architects to resume steady state operations.

Gifted with excellent communication skills and experience of working with non-technical stakeholders, was exposed to project management whilst meeting the deadlines and delivered the results. 3. Technical Support Engineer, Database and Nagios Administrator, Data/Business Analyst

• Apart from the regular DBA tasks, I engaged in a range of activities related to the SQL/NoSQL databases. Played a vital role in performing various effective data and business analysis, aiding in design, implementation and maintenance of the operational data systems. This also helped in support, maintenance and integration of the current and future data sets. Furthermore, generated monthly data quality reports and recommended corrective actions for data inconsistencies/latencies, leading to better and increased accuracies.

• Demonstrated expertise in handling, analyzing and deriving valuable insights from large and extensive data sets. Resume of Shruthi Prescilla 4

• Being exposed to Nagios: core and XI – was part of the Nagios Installation and Setup. Achieved the System Monitoring by configuring the Nagios. Implemented Nagios as a monitoring tool – which comprises of several other aspects, and not limiting to shell scripting, network and database connectivity, or basic Linux administration etc.

• As part of my daily responsibilities, I handled troubleshooting tasks that encompassed resolving issues with databases, the overall environment, Nagios Server, client objects, and other servers and components. Assisted in maintaining the Production Live Environment and played a crucial role in troubleshooting, identifying, and resolving customer environment issues.

• As a Nagios Administrator was always required to demonstrate a strong dedication and commitment to customer service with an innovative yet practical approach to troubleshooting, coupled with reporting and client presentations, demonstrations etc.

• In addition to my assigned roles, I was involved in ETL development, analysis, design, testing, and rectification. I also handled database tasks, such as manual scheduler job executions and other related tasks, data analysis and validation, and design-related aspects.

• Timely evaluation and the debugging of the component which deals with real time big data – For example: dealing the Nifi related issues and hence tracing the root causes - leading to rectification of the issues.

• Engaged in different facets of Nifi - such as its role as a transport component, Elastic Search etc

• Collaborated across the team, i.e. developers, Business Analysts, DB Architects and modelers etc and set up various interfaces, which are pivotal to daily functioning, whilst establishing/recommending various best methods and practices.

• By demonstrating a keen eye for detail and a strong desire to learn, along with excellent interpersonal and communication skills, I was able to anticipate and address potential future issues and incidents before they even happened. This proactive approach allowed me to effectively collaborate with colleagues of different technical abilities and ensure smooth operations.

• I have played a crucial role in various aspects of data management, including data retention, data handling, debugging of legacy data, tracing raw data, managing processed data, and archiving data etc.

• Periodically assessing the dockers, microservices, and their operational status to ensure their availability and proper functioning.

• Responsible for ensuring the system remains available and operational, while also detecting any latency or data flow issues that may arise at any point in the system.

4. Software & Web Developer

Created various CRM (Customer Relationship Management) and Content Management System (CMS) applications (Eg: Employee Management system, Student Information System etc.), 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 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).

Created various dashboards and developed reports with consistent drill-down functionality including Drilldown report and Summary report.

Used Power BI to create, execute and deliver tabular, matrix, charts reports etc. PERSONAL DETAILS

Nationality : Indian

Marital status : Married

Languages Known : English, Hindi, Kannada, Konkani and Tulu; Learning Arabic Driving License : Hold valid Qatari driving license. Visa Status : Resident Permit

Hobbies & Interest : Travelling, listening to music, learning new technologies, solving numerical puzzles, outdoor group games.

References will be provided upon request.

Contact this candidate