ShasiRekha Pendyala
USA
Summary
Experienced software professional with around 13 years of experience in IT industry with strong interpersonal talents and client managing skills, handling various roles as Team Lead, Senior Developer/Analyst in Business Intelligence space. Experienced as ETL Lead and Senior Informatica Developer. Developed ETL processes in Informatica IISC to migrate data from external sources to Redshift. Extensively worked with Informatica client applications - Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager. Worked in Tuning mappings using Power Center Designer using techniques namely Partitioning, query tuning and PDO to provide maximum efficiency and performance. Hands-on experience in data extraction and transformation from different source systems like ORACLE, oracle ETRM, flat file, XML into TERADATA, ORACLE warehouses and Veeva SFDC environment. Used aggregate functions, analytic functions, materialized views, indexing, and Partitioning in Oracle. Prepared Technical design Document, Mapping Documents, Data Definition Documents, Detail Design Document for the Source/Target mappings and have done code review following the standard processes. Experience in data profiling, developing data quality rules and involved in cleansing the data using IDQ. Experience in scheduling the workflows using Autosys, $ Universe. Experience in Agile methodology. Trained in Python and Gen AI.
Overview
16
16
years of professional experience
Work History
ETL Lead
Life Accident Health Insurance (LAH)
, NJ
09.2023 - Current
- Led team in implementing ingestion process for premium and claims data into Yellow Brick database.
- Managed data loads and validated ingestion processes for accuracy and efficiency.
- Provided daily project updates to business and stakeholders via Kanban Board.
- Mentored offshore team to enhance collaboration and productivity.
- Ensured code quality through rigorous reviews and adherence to best practices.
- Automated workflows using Autosys for streamlined operations.
- Operated within Agile methodology to facilitate adaptive planning and iterative progress.
- Utilized Informatica PowerCenter 10.4, Yellow Brick, Autosys, Elément Tool, and ALM.
Sr Associate
Zurich
, USA
02.2021 - 08.2023
- Implemented changes to Claims data mart in AWS Redshift for MLCI project based on source system Access updates.
- Executed ETL processes using Informatica IISC across provisioning, curation, and data consumption layers prior to data ingestion into AWS Redshift.
- Integrated organization-level changes and profit line modifications from CIID and ADIT into Actuarian Data mart.
- Collaborated with Release Team, gathering requirements from functional users for multiple change requests, applying structural transformations across ZNAW and ZEA layers.
- Optimized mappings by implementing PDO and partitioning strategies.
- Included Canada data into existing US PZAC (Broker compensation) program.
- Automated workflows with Autosys to enhance operational efficiency.
- Utilized Agile methodology to streamline project management and development processes.
Technology Lead/Sr Developer
Bayer
Parsippany, USA
09.2019 - 09.2020
- Processed sales and lab data from Prometrics into ABBI warehouse in Azure SQL.
- Reported sales and lab data to downstream systems, including Incentive Compensation and Verix teams via Power BI.
- Developed mapping data flows in Informatica IISC to load data from Prometrics to AWS Redshift.
- Integrated Marketing Mix data for WHC business unit from MediaCom vendor into AWS data lake.
- Led end-to-end project implementation from requirements gathering to unit testing, including documentation of business and technical specifications.
- Provided weekly updates to stakeholders on key project milestones.
- Coordinated with offshore teams to communicate business requirements and ensure adherence to standards.
- Created rollout plans and runbook documents for production migration, supporting post-production during warranty.
Technology Lead
Bayer
Bangalore, IN
04.2017 - 09.2019
- Conducted reverse engineering of existing systems to refine business rules for oncology unit.
- Managed project identifying optimal sales contacts based on territory-level call and sales data.
- Performed data profiling to uncover scenarios impacting address selection for sales outreach.
- Collected requirements and analyzed data for technical design and mapping documentation.
- Led end-to-end project implementation from requirements gathering to unit testing phase.
- Utilized Informatica PowerCenter 9.6, Oracle 11g, and Teradata SQL Assistant v15 for data management.
Module Lead
Boehringer Ingelheim
Bangalore
06.2013 - 11.2014
- Developed Informatica mappings and workflows to load data into ODS Oracle tables from LND and STG layers.
- Created workflows to push data to Veeva Salesforce Cloud.
- Analyzed Veeva Salesforce objects to clarify functional requirements and dependencies.
- Coordinated with design team to clarify requirements and understand source-target data models.
- Drafted LLDD for data flow processes from various source systems to target system.
- Implemented data validation in mappings, enabling user-defined error handling.
- Enabled parallelism in loads by partitioning workflows using key range and pass-through partitions.
- Generated error reports via Informatica mappings and configured pre-and post-session commands for email notifications.
Sr.ETL Developer
Shell
Bangalore, India
12.2011 - 05.2013
- Analyzed Source system to identify areas for improvement.
- Contributed to creation of functional and technical design documents.
- Developed medium to complex mappings in Informatica for ODS and DW layers.
- Utilized Oracle Hints in SQL Queries to enhance performance.
- Conducted unit tests to ensure code quality and functionality.
- Engaged with Endure tool for project tracking and management.
- Produced weekly project status reports, monitoring task progress against schedule.
- Performed peer reviews, debugging mappings, and verifying adherence to Informatica standards.
Developer
United Health Group
Hyderabad, India
03.2010 - 12.2011
- Analyzed low-level design documents and prepared ETL design documentation.
- Developed medium to complex mappings, conducted unit testing, and delivered results to test team.
- Resolved defects reported by QA team while providing quality assurance support.
- Created and scheduled jobs utilizing Autosys tool for efficient task management.
- Coordinated with onshore team regarding offshore tasks for multiple releases.
- Participated in various releases, including CRP and BOSS.
- Compiled weekly project status reports, tracked task progress, and communicated updates to leads.
- Facilitated status meetings with onshore team to ensure project alignment.
Education
Master of Computer Applications -
Osmania University
IndiaSkills
- ETL tools: Informatica PowerCenter 10x, 9x, 8x
- Database management: Oracle 11g, 10g; Teradata; Netezza; AWS Redshift
- Database tools: Toad; SQL Plus; SQL Developer; TD SQL Assistant; SOQL
- Data modeling: Erwin
- Scheduling tools: Autosys, $U
- Scripting: UNIX shell scripting
- Operating systems: Windows NT/2000/XP, UNIX, IBM AIX
- Cloud technology: AWS S3, AWS Redshift Data Warehouse, Informatica IISC
- CRM software: Veeva SFDC
Timeline
ETL Lead
Life Accident Health Insurance (LAH)
09.2023 - Current
Sr Associate
Zurich
02.2021 - 08.2023
Technology Lead/Sr Developer
Bayer
09.2019 - 09.2020
Technology Lead
Bayer
04.2017 - 09.2019
Module Lead
Boehringer Ingelheim
06.2013 - 11.2014
Sr.ETL Developer
Shell
12.2011 - 05.2013
Developer
United Health Group
03.2010 - 12.2011
Master of Computer Applications -
Osmania University