Monoranjan Mohapatra

Teradata platform analyst having knowledge on Teradata, SAS, Python, Unix, Data Visualization in Excel and Qlik. 

A data driven innovative professional with over 13+ year of experience who likes to challenge real massive raw data and platform problems. Ability to deal directly with business functions and interpret their thoughts into successful data and analytics solution with standards, architectural principles, and practices.

DBMS Programming and Management

• Proficient and hands on working on Enterprise Datawarehouse, ranging from design, development, architecture, and database administration.
• Excellent lessoning skill with business to glean requirements and converting them into conceptual and logical data model.
• Strong Knowledge in TASM Workload design and analysis.
• Proficient on data archival, data compression and well versed on backup policies and backup/restore framework model.
• Expertise on Space Management, User Management, Access Management, Security Management, Statistics Management.
• Good understanding of Audit / Control testing requirements.
• Hands on experience in SAS studio, user access management.
• Good understanding of working on Cloud ecosystem like AWS and GCP. 
• Hands on experience in Qlik sense dashboard using various components like KPIs, Filters, straight tables, Pivot tables, Container, Slider, Buttons, charts, bookmarks, drill down and master detail relationships.
• Developed two layered architectures in Qliksense which involved data extraction layer to fetch data from sources and store as QVD’s, transformation layer to build the data model and finally building dashboard layer.
• Implemented data level security using Section access that hides selected areas of the dashboard & filters data dynamically depending upon user privileges.
• Strong knowledge on system maintenance (PDCR, Scandisk, check table etc) and query optimization.

     Reporting and visualization

• Process optimization to summarizing data using advanced charts and expressions, calculations using functions and formulas.
• Automate the reporting process using Excel or migrating to advanced data visualization tool like Excel/Qlik.
• Managed to migrate 40% of excel base reporting to Qlik. 

     Strategy Building and Reporting

• Developing strategy to manage complex workload model to handle multiple business.
• Developing strategy to avoid/ clear audit and control testing items. 
• Developed dashboards, macros to generate data for performance analysis.
• Platform/Application standard document preparation.
• Decision making based on DQBL/Application data analysis and reporting.