Sai Sharma Gonugopula

• Malayan Banking Berhad is a Malaysian universal bank, with key operating "home markets" of Malaysia, Singapore, and Indonesia. They offer clients a comprehensive suite of investment banking and stockbroking products and solutions to the retail, mid-market, corporate and institutional segments, through their two business pillars, namely Investment Banking & Advisory and Investment Management, with services including debt advisory and arrangement via bonds, project financing, leverage financing and loan syndication.
• Developed ETL mappings and workflows using Informatica Power Center 10.5.2 to implement the business requirements. Responsible for converting functional requirements into technical documents.
• Effectively worked on Onsite and Offshore work models using JIRA tool and Agile methodology. Good in maintaining, planning and delivering within the sprints.
• Worked on Bug Fixes, New Enhancements and designed solution documents.
• Implementation of SCD Type1/Type2 logic in Informatica power center.
• Designing incremental loading using Last Refresh dates and Record_Deleted_Flag.
• Good Knowledge on ODI, Teradata SQL and HIVE/HDFS concepts.
• Developed Scenarios and mappings in ODI.
• Worked on loading Flat file sources (.xlsx, .dat) to Hadoop server having target tables in HUE (cloud).
• Effectively worked on Data Lake views and Procedures in various DataMart’s like UDL (Universal Data Lake).
• Have been closely interacting with customers as part of gathering any requirements or mapping documents, also attending the scrum calls with the Business associates and end users to update the status of the team.
• Performed deployments to higher environments by maintaining versioning in GITHUB.
• Performed Unit Testing and Data Quality Checks

Bristol Myers Squibb is an American multinational pharmaceutical company, headquartered in New York City. BMS is one of the world's largest pharmaceutical companies. The company is known for biological and pharmaceutical research. Bristol-Myers Squibb has agreed to merge with Celgene in a deal that will boost its presence in oncology and immunology and make it the fourth-largest drugmaker.

• Developed ETL programs using Informatica to implement the business requirements.
• Effectively worked on Onsite and Offshore work model.
• Worked on New Enhancements and designed solution documents.
• Implementation of SCD Type1/Type2 logic
• Designing incremental loading using Last Refresh dates
• Debugging data issues and coding issues in the OBIA stack using session logs and workflow logs
• Enhancement activities like adding new target columns, introducing new tables into the existing mappings based on requirements
• Tuned the performance of mappings by following best practices.
• Monitoring ETL and DAC loads and fixing in case of any failures.
• Validating Data using SQL queries against OLAP and debugging the data issues.
• Coordinate with different teams for support and deployments.
• Performed unit testing at various levels of ETL and actively involved in team code reviews.
• I identified problems in existing production data and developed one-time scripts to correct them.
• Involved in Admin activities like migration of workflows and mappings from one environment to another environment.
• Expert in performing Informatica & DAC Sync up’s of lower environments with that of Production.
• Worked extensively on Informatica Administrator Console. Used to debug server logs incase if there are any issues with Integration services and Repository services.
• Restarting Informatica and DAC services in putty when they were down and Scheduling Cronjobs in all environments.
• Extensively worked on OBIEE report level access to users, Columns backtracking in rpd in Physical, BMM and Presentation layers.

Celgene is a global biopharmaceutical company committed to improving the lives of patients worldwide. At Celgene, we seek to deliver truly innovative and life-changing treatments for our patients. Celgene builds a warehouse for each business segment which helps users to look at reports briefly. Celgene able to grow business in Finance, Manufacturing and SCOM since users take decisions by analyzing OBIEE reports.

• Monitoring DAC jobs for the OLAP daily and monthly loads.
• Debugging mappings in informatica whenever the Dac job fails.
• Developed customized mappings using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router.
• Created various tasks like session, command, email
• Worked with Flat files using Direct and Indirect methods by loading data into other flat files and relational tables.
• Involved in Admin activities like migration of workflows and mappings from one environment to another (Training, Development, Testing, Validation and Production) environment.
• Restarting Informatica and DAC services in putty when they were down and Scheduling Cronjobs in all environments.
• Extensively worked on OBIEE report level access to users, Columns backtracking in rpd in Physical, BMM and Presentation layers.