Senior Consultant
Systems Limitied
Total years of experience :9 years, 5 Months
Working extensively on Microsoft’s BI Stack (SSIS, SSAS & SSRS), Power BI platforms, HP Vertica & TeraData.
Data Modelling & ETL for data warehouses.
Database Development & Administration activities.
Creating databases, ETL measures and perform unit testing of new activities.
Developing reporting portals/reporting sections for various applications developed by Systems Ltd.
As per business needs collecting key consumer insights for analysis using SQL(TeraData)
Data modeling to extract data from multiple sources with maximum accuracy in most efficient way
Queries Optimization to utilize least asset with high effectiveness.
Developing Adhoc reports to assist the business users to create dashboards for different analysis to support management decisions
Creating & modifing in ETL and Framework Models to incorporate the new data elements in Source Applications.
Development of various reports for all modules (Underwriting, Claims and Finance) using IBM Cognos Report Builder.
Alerts development for management for Daily, Weekly, Monthly, Quaterly & Yearly basis and scheduleing them through Event Studio.
Identify and troubleshoot business process and data quality issues on new or existing reports.
Interacted with users for requirement gathering, effective analysis & also to provide end-user training.
Provide daily support on operation regarding to MIS.
Perform design and development of Oracle applications according to project requirements.
Design, code, and maintain the Oracle systems based on established standards.
Development of application libraries to enhance the reusability for other developers.
Creating & modification of Database objects like: tables, triggers, indexes, sequences, constraints, functions, procedures & packages.
Maintain working knowledge of technical enhancements and new functionality.