Business Intelligence Analyst Cork, Ireland

Might be available

(Updated 2020-01-01)

Business Intelligence Analyst

Cork, Ireland

Native English, Hindi

  • 6+ years of experience in Informatica BI tool
  • Oracle, Sql server, Linux
  • Experienced PL/SQL Developer

Skills (25)

MACOS

INTEGRATOR

CLINICAL TRIALS

Business Intelligence

TEST PLANS

SQL

PERFORMANCE OPTIMIZATION

TEST CASE

Quality Engineer

SHELL SCRIPTS

Unix shell

Change Management

Unix

MAC

MDM

Master Data Management

PUBLISHING

RETAIL

LINGUISTIC

INTEGRATION

USER ACCEPTANCE

LOGGING

SYSTEM TESTING

USER EXPERIENCE

SCHEDULING

Professional Experience

Software Quality Engineer
APPLE

2018-09 - Present

Working as an international software quality engineer to identify linguistic and functional issues in Apple
products for the Indian/European markets to provide world class user experience to end-users across the globe

Role & Responsibilities-
• Functional and linguistic testing of iOS/macOS/watchOS applications and operating systems
• Creation of unit test cases/ scenarios to be tested for all Apple products or enhancements due to be
released
• Identification of issues in the product using various testing approaches i.e. based on test scenarios,
exploratory, user experience testing, feedback from independent developers for Beta softwares
• Assess and investigate the issues raised by end-users and close them to completion
• Creation of projection reports for projects
Solution Designer- Data Warehousing
DELOITTE CONSULTING

2017-04 - 2018-07

Worked on end-to-end solution design for a Salesforce-Informatica integration project for the R&D division of a US based pharmaceutical client. The project involved transformation and publishing of clinical trials related data to and from Salesforce based client application and consolidating it with the report provided by an external
clinical data provider. The consolidated report was consumed by business users and research associates.

Role & Responsibilities-
• Designing and developing the Extract Transform Load plan for the project to read from and write into
salesforce platform.
• Work involved performance optimization of Informatica jobs, perform system testing, User Acceptance
Testing and defect fixing for existing and new jobs
• Coded Unix shell scripts to improve salesforce error file handling mechanism and to reduce effort in creating source file structure for error flow
• Worked on Autosys and JIL file creation for scheduling of Informatica jobs
Technical Lead/ ETL Developer
The project involved leading the activities for migration of one of the legacy systems to SQL Server platform. The
existing code was translated to new business requirement documents based on which the new platform was
designed writing the technical code to implement the logic.

Roles and Responsibilities:
• Involved in migration of 400+ Terabytes of data from old legacy system into SQL Server Platform
• Worked on development of the ETL design to consume and process incremental data daily
• Tuned performance of Informatica jobs and reduced the total run time from 14 hours/day to 4.5
hours/day thereby enhancing the performance and efficiency of the system

Achievements:
• Received recognition and monetary award for improving the error logging framework in the data
consumed from Salesforce platform saving 30hrs of manual effort per week
• Appreciated by Deloitte leadership for contributing to the organisation's knowledge base by completing
a white paper on a complex technical data scenario. Title- Oracle partition exchange for fast loading of large database tables.
Senior Software Developer- Data Warehousing
ACCENTURE

2013-01 - 2017-03

Worked with various clients in Retail, Products and Life Sciences.

Roles & Responsibilities-
• Worked with US based large beverages client to design ETL solution for enabling their business
reporting needs
• Worked with a Life Sciences client to develop their data warehouse. The role involved customising a re-
usable solution to support specific needs of the client to handle clinical trials
• Created end-to-end Informatica workflows, unix shell scripts for scheduling and execution of the Informatica jobs as per fixed schedule and support on post-production SLA bound activities
• Automated daily data load and login activity monitoring report and saved ~60 hours of effort per
month.
• Ensured best practices are applied and integrity of data is maintained through security, documentations
and change management using IBM Rational tools (RTC and RQM)
• Worked on data quality tool - Informatica developer for creation of data cleansing mapplet.
• Created an application for data deletion and modification taking into consideration all the entity
relationships which significantly reduced the number of requests raised for such issues making it more
cost effective for client.

Achievements-
• Accenture Life sciences individual award (Quarterly Awards) for zero defect delivery & various
recognitions by leadership during my tenure
• Awarded 2 consecutive promotions by Accenture between 2014 and 2016

Academic Background

Bachelor of Engineering (Hons.) in Electrical and Electronics
RAJIV GANDHI TECHNOLOGICAL UNIVERSITY

2024-03 - 2024-03

Contact contractor

/