SOUMYA SASI

BI DEVELOPER DATA ANALYST DATA ENGINEER

DUBAI, UAE PHONE: +971-********* E-MAIL: admfm4@r.postjobfree.com

Informatica Oracle Exadata Snowflake Sql/plsql Business Object Microstrategy SAFe Agile

A highly qualified and innovative Senior DWBI Developer, Database Specialist & Data Insights Analyst with above 9 years of experience in Data Analysis, Data Modelling, Design, Database Development, Production support and Testing.

Domain Experience in Airline industry and Banking & Financial services.

Proven experience in developing and mentoring teams in coding secure, reliable, reusable and high-quality software by following coding standards and using DWBI concepts.

Skilled in software engineering standard methodologies and Agile principles.

Expert in Informatica powercentre, SQL, PL/SQL, Oracle, Oracle exadata, Business Objects and Microstrategy.

Possess strong decision-making and analytical skills needed to lead time compliance as well as successfully estimate and implement operational efficiency gains.

Highly skilled in negotiation and communication with colleagues, key stakeholders, and clients while negotiating project requirements and designing technical solutions to satisfy customer’s needs.

Proven track record in producing qualitative deliverables within tight timeframes and simultaneously managing several reports.

Strong in troubleshooting and debugging DW&BI applications, performance tuning and monitoring and code analysis to make sure standards are followed while development for better memory management.

Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Module Lead for review

Develop reports, dashboards & scorecards, data exploration and visual analytics using existing and emerging tools and technologies like Microstrategy, Business Objects and Cognos.

CORE SKILLS AND COMPETENCIES

DWBI Development

Trouble shooting skills

Data Analysis and Modeling

Agile (SAFe, Scrum) Methodologies / Waterfall

CI-CD

Business Analysis

Process Tracking Tools

Communication

Problem Solving

Result Driven

Team Leadership

Analytical-Minded

Multi-Tasking

Structure Thinking

TECHNICAL PROFICIENCY

Primary Skills: Informatica Powercentre SQL PL/SQL Oracle Oracle Exadata Business Object Snowflake Microstrategy

Secondary Skills: UNIX Shell Scripting Snaplogic Informatica MDR (Metadata Repository) TOAD Undraleu JIRA Confluence Jenkins GIT Cognos C SSIS

WORK EXPERIENCE

Emirates Airlines Dubai, UAE

SENIOR SOFTWARE ENGINEER 07/2015– 06/2020

As a Lead Developer and a Technical Mentor, coordinated and involved in the development of DWBI applications using Informatica powercenter, SQL, PL/SQL, Oracle 19c, Oracle Exadata, Snowflake, Business Objects and Microstrategy. Performed quality assurance of programs and applications by providing unit and integration testing, code reviews using undraleu, application fine tuning and application support as part of Devops. Ensured data ingestion and processing in Exadata and Snowflake environment, conduct data analysis using Business Object and Microstrategy, participated in modelling and visualization of components for the commercial BI warehouse of Emirates Airlines. As an end-to-end Developer, took part in all the stages of software life cycle and design phases along with implementing and supporting applications software, providing valuable inputs on architectural decisions. Interpret requirements to application functions, elaborated business logic components in ETL tools. Maintain and regularly update project documentation related to the changes and modifications. Dealt with troubleshooting issues like Server hang, Application Deadlock, Out of Memory Issue and High memory usage. Provided support for production environments in activities such as load testing, troubleshooting, version upgrade and performance tuning along with daily application support.

Key accomplishments:

Involved in the development and delivery of high-potential dataware house applications using Informatica, SQL, PL/SQL, Oracle 19c, Oracle Exadata, Business Objects, Microstrategy, Snowflake and Snaplogic.

Manipulating, cleansing & processing data using ETL, Business Objects and SQL/PLSQL.

Analyzing raw data, drawing conclusions & developing recommendations and Writing SQL scripts to manipulate data for data loads and extracts.

Advising on the suitability of methodologies and suggesting improvements.

Supplying qualitative and quantitative data to colleagues & Business Users, using Informatica & Business Objects to extract, transform & load source data from transaction systems and to provide it as reports.

Involved in the decommissioning of different legacy systems by incorporating those attributes in the Commercial warehouse in strict timelines with less impact to the downstreams.

Ensured high quality code is delivered which is maintainable, reliable, reusable, secure and capable to avoid memory leakages or performance compromise in the production environment.

Involved in the implementation of GDPR guidelines in the commercial warehouse environment.

NIIT Technologies (Consultant in Emirates Airlines) Dubai, UAE

SENIOR SOFTWARE ENGINEER 03/2013 – 07/2015

Involved in the development of multiple ETL& BI integration projects using informatica,Business Objects and Oracle as part of ETL COE team.

Manage and contribute to all aspects of application development including functional and technical specifications, design, development and production support.

Cognizant Technology Solutions India Pvt.Ltd Chennai, Tamil Nadu, India

SOFTWARE ENGINEER 03/2010 – 03/2012

Developed numerous workflows,user defined functions,reusable transforamtions,mappings using Informatica powercenter,UNIX, Oracle 10g, MDR Client tool for Banking Domain(JP Morgan Chase Bank, Irving, TX, USA)

Involved in all the development and testing phases of the software development life cycle

Creation of daily and monthly job flow and Performance tuning of the mappings

Creation of detailed design documents based on business requirements.

Designing and Implementing several performance enhancements

Review and Code migration to production system

Providing test strategy and test execution plan

KEY PROJECTS

COMMERCIAL BI & DATA FOUNDATION

The project aimed to provide a unified and single source of truth across all the commercial business units of Emirates Airlines.

Commercial BI is the single data warehouse application that cater to all the business unit in Emirate Airlines and is developed in Informatica with the database as Oracle Exadata and user interface as Microstrategy.

Managed the elaboration and launch of different modules of the Commercial BI system at Emirates Airlines.

The system is designed and implemented for the usage by the company's personnel and external stations spreading across 70+ stations all over the world.

Involved in collecting, collating and carrying out complex data analysis in support of management & Commercial Business user requests.

Involved in the development of various modules within Commercial BI to facilitate the decommissioning of legacy systems.

Developed a key function to enable access to the commercial BI front end, managing the access restrictions based on the country of the user and their roles and rights using Informatica, Oracle and Microstrategy.

Involved in the migration of the data warehouse backend from oracle 19c to Oracle Exadata and fine tuning the process to adapt to the standards of exadata to achieve maximum performance.

Involved in the implementation of GDPR guidelines in the commercial warehouse environment.

The goal of Data Foundation project is to have a single data warehouse for entire Emirates Consisting of Commercial, Engineering and Operation data. Involved in snap logic development to export and import data from legacy source systems and genome and to transform those data in snowflake.

MANAGEMENT COCKPIT

As part of the various business needs, from different business units across Emirates group, there was a necessity of creating a unified high level KPI related dashboard summarizing the whole emirates operations. The logics were implemented through ETL processes.

Acted as a business analyst and involved in the creation of detailed design and logical documents based on business requirements after analyzing their requirements.

Analyzing raw data from different source systems, drawing conclusions & developing recommendations and Writing SQL scripts to manipulate data for data loads and extracts.

Involved in the requirement gathering and feasibility study of different business requirements.

DATA ANALYTICS & ETL COE TEAM

Collecting, collating and carrying out complex data analysis in support of management & Business user requests. Also involved in reporting statistical findings to work colleagues and senior managers.

Manipulating, cleansing & processing data using ETL such as Informatica Powercentre, SSIS, Business Objects and SQL /plsql.

Analyzing raw data, drawing conclusions & developing recommendations and Writing SQL scripts to manipulate data for data loads and extracts. Performing system checks, data auditing, creating data reports & monitoring all data for accuracy. Advising on the suitability of methodologies and suggesting improvements.

Supplying qualitative and quantitative data to colleagues & Business Users, using Informatica & Business Objects to extract, transform & load source data from transaction systems and to provide it as reports.

Drive best practices by planning and conducting code reviews, and incorporate lessons into work practices at the application and sub-department levels.

CERTIFICATIONS

Certified SAFe 4 Agilist 2019

ACADEMIC BACKGROUND

Government Engineering College, Calicut University, Kerala, India

B.Tech in Computer Science and Engineering 2009

LANGUAGE PROFICIENCY

English (Fluent)

Malayalam (Native)

Hindi

Tamil

Contact this candidate