It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan vara tillgänglig
(Uppdaterat 2020-01-01)Business Intelligence Analyst
Cork, Ireland
Modersmål English, Hindi
- Oracle, Sql server, Linux
- Experienced PL/SQL Developer
- 6+ years of experience in Informatica BI tool
Kompetenser (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
Professionell bakgrund
Software Quality Engineer
APPLE
2018-09 - Pågående
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
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.
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
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
Akademisk bakgrund
Bachelor of Engineering (Hons.) in Electrical and Electronics
RAJIV GANDHI TECHNOLOGICAL UNIVERSITY
2024-12 - 2024-12