Shikha Plawat

• Developed expertise as a Functional Analyst utilizing Riskpro App for UAT of LCR and NSFR reports.
• Mapped business requirements and coordinated with technical team to ensure accurate implementation.

• Design and develop the data warehouse to have the unified solution for Insurance

bank to meet the International Financial Reporting Standard-17.

• Project involves the gathering of data from different six European countries &

loading it into different layers of data warehouse.

• Working on Shared Data Mart,Application Data Mart / Access Layer

• Participated in requirement gathering with client

• Development of aggregate table for business intelligence team for data analysis

• Fine tuning of SQL to optimize the performance, spool space usage

• Data loading from different stages of data warehouse

• Report Data validation against the data base by writing the SQL queries

• Practical understanding of the Dimensional modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

• Working as a Technical Lead

• Tools
• Informatica PowerCenter 9.6
• Teradata 14, Mainframe, UNIX, Within this project, Blue Cross had to send post-payment letter and consequently, send a file to third party to check if the claim was to be provided by Blue Cross or by A third party insurer
• All the claims processed in a week were taken into consideration
• Roles & Responsibilities:
• Led the team of three members and was responsible for successful delivery of the project
• Involved in all the stages of the project; from the analysis of requirements, converting the functional description to the technical aspects
• Workflow design, realization of the design into Teradata-Informatica
• Worked on Data Profiling to validate data-related assumptions
• Suggested data model changes as required
• Involved in code review and test case review
• Coordinating with the onsite team, oversee the testing of the entire workflow
• Provided Development support for System Testing/Business acceptance testing
• Involved in identifying the bottlenecks and tuning to improve the performance