About Me
Currently employed as a Senior Systems Engineer at Infosys Ltd, I have accumulated 3.5 years of experience working with various tools and technologies in the fields of data warehousing, integration, and reporting concept…
Currently employed as a Senior Systems Engineer at Infosys Ltd, I have accumulated 3.5 years of experience working with various tools and technologies in the fields of data warehousing, integration, and reporting concepts. This experience spans across different domains including banking and finance
• Utilized various tools including MicroStrategy, Cognos, Azure Synapse Analytics, and Informatica to fulfill the following key responsibilities.
• Gathered client requirements and leveraged to create new reports, dashboards and dossiers in MicroStrategy. Conducted sanity testing for report enhancements.
• Mastered the ability to design and deploy rich Graphical visualizations with advance option and parameters using MicroStrategy.
• Employed MicroStrategy admin tools such as Object Manager for seamless migration of objects/ packages to across different environments and Integrity Manger for comparison of bulk report across the MSTR project.
• Implemented performance optimization techniques to enhance report speed and user-friendliness.
• Led the migration of on-premises data warehouse (SQL Server) to a cloud database (Azure SQL DB) using Azure Synapse Analytics.
• Demonstrated proficiency in creating pipeline jobs, scheduling triggers and mapping data flows with Azure Synapse Analytics.
• Developed custom classes and templates using PySpark to facilitate data transformation and cleansing based on specific business requirements.
• Utilized Informatica Power Center to create ETL programs supporting data extraction, transformation, and loading.
• Created and managed UNIX scripts and SQL files to execute Informatica workflows and oversee the ETL flow.
Experience
Technology Analyst
Utilized various tools such as MicroStrategy, Cognos, Azure Synapse Analytics, and Informatica. Led migration of on-premises data warehouse to cloud database using Azure Synapse Analytics. Developed custom classes and templates using PySpark.
Technology Analyst
Utilized various tools including MicroStrategy, Cognos, Azure Synapse Analytics, and Informatica to fulfill key responsibilities.
Gathered client requirements and created new reports, dashboards, and dossiers in MicroStrategy.
Conducted sanity testing for report enhancements.
Designed and deployed rich graphical visualizations with advanced options and parameters using MicroStrategy.
Employed MicroStrategy admin tools such as Object Manager for migration of objects/packages across different environments.
Used Integrity Manger for comparison of bulk reports across the MSTR project.
Implemented performance optimization techniques to enhance report speed and user-friendliness.
Led the migration of on-premises data warehouse (SQL Server) to a cloud database (Azure SQL DB) using Azure Synapse Analytics.
Created pipeline jobs, scheduling triggers, and mapping data flows with Azure Synapse Analytics.
Developed custom classes and templates using PySpark for data transformation and cleansing.
Utilized Informatica Power Center to create ETL programs supporting data extraction, transformation, and loading.
Created and managed UNIX scripts and SQL files to execute Informatica workflows and oversee the ETL flow.