PARANAWITHANA

About PARANAWITHANA

7years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems inFinancial, Insuranceand Education domains. 4+years of experience in Data Integration, designing and development of ETL Methodology using Informatica Power Center. 4+ years of experience in working with ORACLE 12c/11g/ 10g/ 9i/ 8i. 1+ years of Experience in Designing ER&Dimensional Data Models using ERWIN Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements. Worked extensively in design and analysis of Requirements, Development, Migration, Testing and Production support. Worked on documentation of requirements, Testdata, DatamovementschemaandMapping between applications. Extensive knowledge of ETLtuning and SQL/PL SQL tuning. Experience in integration of various data sources like Oracle, SQLserver and sequentialfiles into stagingarea. Conducted System, UAT and Functionality testing and investigated software bugs. Create and modify UNIXShell Scripts. Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources. Worked on Data Integration from various source files such as flatfiles, CSV files, RelationalDatabases etc. into a common analytical DataModel. Production support experiencewithExtensive understanding of Production issues and Data issues. Excellent communicationskills, ability to communicate effectively with different levels of management, strong analytical, problem solving skills. Experience in Agile and Waterfall methodologies. Designed and developed complex mappings (Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner and Update Strategy) from varied transformation logics in ETL. Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in ETL. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures. Extensively used Slowly Changing Dimension (SCD) technique in business application. Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT). Experience in OLTP/OLAP System Study, Analysis, E-R modeling. Developing Database Schemas like Star schema and Snowflake schema used in relational,dimensional and multidimensional modeling.