Sophia Kharati

Bright exposure on pharmaceutical domain related projects ,specifically on commercial and finance projects.

I am part of many on-going IICS developmental projects. Realtime data processing and data management using ETL .

• End to end analysis ,development & prod validation with review by mentor .
• Expert in stakeholder management in requirement gathering and keep them informed about progress.
• Migration project in commercial team resulted into transparent and improved Data flow with latest technology like IICS and Redshift .
• Data gathering -> processing -> S3 Bucket upload.
• One to One data load in finance Projects.
• Cross team collaboration.

Data Quality Check for Audit Purpose

• Have developed a Master mapping to gather all information about other Mappings, Processing details and metadata of tables. This was used for audit purpose.

Successfully Completed IICS migration project(Informatica Intelligent Cloud Services)

• Pipeline Pilot application and Vertica database got decommissioned. IICS and Amazon RedShift database was introduced.
• As a part of this project, have done analysis on existing data processing,preparing design Logic, implementing those design in IICS . Have used RedShift as Target database. Various source files (.txt,.xlsx,.csv format) were used ,which were delivered in strategic source folders by upstream.
• Supported quality assurance teams in software module testing, verification and validation.
• Compiled technical specifications and software design information for technical documentation.
• Participated in collaborative communication and open discussions of design and implementation approaches.
• Investigated customer reported defects and implemented bug fixes accordingly.
• Optimized existing code by refactoring components for improved performance.
• Designed, tested, and maintained efficient code based on user feedback and product specifications.
• Reviewed application logs for signs of potential security threats or weaknesses.
• Resolved technical issues related to customer-facing applications.
• Implemented changes according to established coding conventions and best practices.
• Analyzed code and corrected errors to optimize output.
• Improved and corrected existing software and system applications.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.