RADHIKA KODEPAKA

Design, develop and support various ETL processes in the Data Warehouse environment including Operational Data Stores, Canonical and Enterprise Dimensional Models and various other Business Intelligence databases.
Worked for production support team for few months and ensured to clear up the existing defects created by the data governance team.
Tested all the modules and transported data to target Warehouse tables.
Scheduled, ran extraction and load process and monitored sessions and batches by using Informatica Workflow Manager and log files.
Tier3 production support for SONAR GCNET /GONET.
Made sure all the reports are running fine for the customers.
Handled production incident tickets and meeting the SLA.
Programmed PL/SQL stored procedures, functions and UNIX shell scripting.
Developed Business data readiness dashboard to make sure the data is received from source systems.
Tuned the repeated jobs failures in production.
Developed mappings and workflows.
Automation using shell script.
Developed Control-M jobs.
Tier3 production support for SONAR Product.
Played a key role in production support as Team Leader.

· Around 13 years of experience in software design & development at various roles like ETL devel-oper, Oracle Developer and ETL Technical Lead.
· Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses by Using Informatica Power Center 10.2.0/9.6/9.5/9.1/9.0/8.x.
· Proficient in the Integration of various data sources with multiple relational databases like Ora-cle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
· Superior SQL skills and ability to write and interpret complex SQL statements and also skillful in SQL optimization and ETL debugging and performance tuning.
· Informatica Certified developer & worked in multiple Informatica versions ( 7.x, 8.x & 9.1,9.6.1S ) for multiple client implementations
· Expert in PL/SQL programming (Stored procedures, functions , packages
· Worked with major clients TELUS & BcHydro. Received multiple appreciations from different cli-ents for providing optimal solutions and excellent feedback as a team player ( recent being at cur-rent client TELUS , Vancouver Canada)
· Experienced in Unix ( shell scripting)
· Extensively used multiple tools like Toad, Control M, Clear Team, Clear Quest ,SVN, TFS.
· Proficient With software development lifecycle methodologies ( Waterfall & Agile )
· Knowledge in Hadoop Hive and hands-on experience in Pig scripting
· Experience using PostgreSQL, Greenplum database
· Experienced in coding spring XML in Contrl-M and basic HTML
· Experience in Database Administration Console
· Excellent communication and documentation skills
· Working closely with Stake holders
· Self trained in R programming language
· Tier3 production support for SONAR
· PoC on GCP tools like PySpark, Vertex AI Notebooks and BigQuery

Understanding the business requirement clearly.
Communicating with business stakeholders and clarifying the issues.
Coding in PLSQL programming.
Development of Informatica mappings and workflow.
Closely working with stakeholder in Unit Testing, Regression Testing and User Acceptance testing.
Documentation on ETL design.
Built new DAC job to run the Informatica code.
Documentation of best practices to help the team.
Handling the CAB meetings.
Monitoring production jobs.
Built an automation email alert using shell script.
Worked within project team to design, implement, support, maintain, and troubleshoot enterprise data management.
Identified problems or potential problem areas and recommends solutions.
Continuously monitored and fine-tuned ETL jobs.
Involved in DAC 10g to 11g upgrade testing and deployment process.
Accomplished UBCO Okanagan campus to build Tuition Allocation Model same as UBCV Vancouver Campus.

Handling customer incident tickets on data missing report on EVP portal.
Test track for the data fix and enhancements.
Closely working with users to understand the issue and addressing the resolution.
Daily activities.
Sending reports to business users.
Understanding the data model for the application support.
Working on Greenplum database.
Create CRQ for deployment task.
Create Remedy tickets for incidents.
Monitoring production jobs.
Enhancement of Informatica mapping and workflows.
Bug fixes to the Informatica code.
Working on HPQC defects.
Unit testing of code.

Development/Review/Testing of the ETL for populating DW from different sources like Oracle sources and flat files.
Testing of eHealth data from Oracle DB to Hadoop.
Programming PL/SQL stored procedures, functions and UNIX shell scripting.
Understanding PIG scripting and help in performance testing.
Documentation of File only process developed.
Developed mappings and workflows.
Automation using shell script.
Development of Control-M jobs.
Agile methodology work environment.
Automation code using PL/SQL which will be reusable to the project for multiple datafeeds.
Analyzing the Functional Specifications and changing necessary modifications required through Team.
Testing the result both functionally and technically.
Involved in the Performance tuning at Database level and mappings.
Documentation of each process.
Development of Control-M jobs.
Automation using shell script.
Development of Control-M jobs.

Development/Review/Testing of the ETL for populating DW from different sources like Oracle sources and flat files.
Analyzing the Functional Specifications and changing necessary modifications required through Team.
Testing the result both functionally and technically.
Involved in the Performance tuning at Database level and mappings.
Programming PL/SQL stored procedures, functions and UNIX shell scripting.
Documentation of each process.
Developed mappings and workflows.
Implemented a Generic framework to load data for Utilization reports.
Automation report to alert SPOC with data load missing in html format in mail.
Development/Review/Testing of the ETL for populating DW from different sources like Oracle sources and flat files.
Developed mappings and workflows.
Analyzing the Functional Specifications and changing necessary modifications required through Team.
Testing the result both functionally and technically.
Involved in the Performance tuning at Database level and mappings.
Programming PL/SQL stored procedures, functions.
Documentation of each process.
Analyzing the Tables and testing COGNOS reports.
Analyzed unused indexes and backup tables to gain the DB space.
Played additional role of Business Analyst.
Worked on Cognos power play to see the cubes and it logic behind.

Development/Review/Testing of the ETL for populating DW from different sources like Oracle sources, Siebel, GEMSSANP, and Quick Base etc.
Analyzing the Functional Specifications and changing necessary modifications required through onsite Team.
Testing the result both functionally and technically.
Involved in the Performance tuning of mappings.
Programming PL/SQL stored procedures, functions.
Involved in Code deployment process for production move.
Documentation of each process.
Preparing UTP (Unit Test Plans) documents.
Played a key role in Production support.
Preparing documents for Quality and Audit.
Design and development of ETL.
Involved in upgrade project of Informatica 7.1.4 to Informatica 8.6.

Design and development of ETL.
Analyzing the Functional Specifications and changing necessary modifications required through onsite Team.
Testing the result both functionally and technically.
Involved in the Performance tuning of mappings.
Programming stored procedures, functions.
Documentation of each process.
Involved in Code deployment process for production move.
Preparing UTP (Unit Test Plans) documents.
Preparing CIME report.
Production Monitoring.
Preparing documents for Quality and Audit.
Involved in upgrade project of Informatica 7.1.4 to Informatica 8.6.