Rani Raghupathi

Experience

• 

  Blue drive India

  Jun 2014 - Aug 2015

  SQL Developer & Data Validator

  I collaborated with the Business Analysts team to gather requirements and translate them into functional and technical specifications. I utilized SQL to extract data from production databases to fulfill Campaign data needs. Additionally, I wrote PL/SQL statements and stored procedures in DB2 for data extraction and manipulation. I created and modified SQL joins and sub-queries to implement business rules effectively. In IBM Infosphere DataStage, I developed mappings to load data from various sources such as SQL Server, DB2, Oracle, and flat files into the Data Warehouse, employing transformations like Joiner, Update Strategy, Lookup, and Rank. My skillset includes MS Office, Crystal Reports, PL/SQL, MS-Access, and IBM Infosphere DataStage Analyst. Show less

• 

  Facebook Advertising

  Oct 2015 - Apr 2016

  Business Analyst/Data Modeler

  I served as a liaison between business users and the technical team, facilitating analysis and design processes. I identified opportunities for enhancing business processes through information systems. I conducted JAD sessions with stakeholders, end users, and subject matter experts to gather requirements and develop functional and technical specifications. Using SQL queries, I manipulated data in databases and generated reports to support daily business activities. I actively participated in User Acceptance Testing and Deployment, ensuring the portal's functionality met user expectations. I conducted training sessions and updated the Product Manual after successful sprint deliveries. I utilized Informatica Power Center for ETL processes, extracting and transforming data from diverse source systems into the target database. I created mappings and performed data extraction and transformation as per requirements. My skillset includes Informatica, SQL, Tableau, Unit Testing, and JIRA. Show less

• 

  Cognizant

  Apr 2016 - Sept 2018

  Senior Process Executive

  I generated energy consumption reports using SSRS, showcasing trends over different time periods. I performed ad-hoc analysis and data extraction to address critical business issues effectively. I am well-versed in Agile SCRUM development methodology, which I applied in the development of Building Automation Systems (BAS). I streamlined and automated Excel/Tableau dashboards for improved speed and efficiency using Python and SQL-based solutions. I conducted data analysis and validation by extracting records from multiple databases using SQL in Oracle SQL Developer. I designed ETL specification documents and wrote SQL test scripts for data validation. Additionally, I developed stored procedures for data retrieval and created various reports using SQL reporting services (SSRS). My skills include SQL, Python, Microsoft Excel, SSRS, and Oracle SQL Developer Tool. Show less

• 

  Policybazaar.com

  Aug 2020 - Jul 2021

  INFORMATICA MDM DEVELOPER

  I collaborated with business users to gather requirements and perform business analysis, preparing Technical Specification documents (TSD) and data models for new requirements. I configured and installed the Informatica MDM Hub server, cleanse, resource kit, and Address Doctor. My work primarily involved Master Data Management (MDM) for Customer Data Integration using the Siperian tool. I handled various configurations in the MDM Hub Console and worked closely with ETL developers to create complex mappings, mapplets, and reusable transformations. I analyzed background tables for data analysis purposes and created cleansing functions for improved mapping results. I also worked with Informatica Data Director (IDD) to perform Match and Merge operations. Additionally, I assigned workflows to business users and managers for task review. In terms of the environment, I have experience with SQL, Python, Microsoft Excel, SSRS, and Oracle SQL Developer Tool. Show less

• 

  Archer Daniel Midland

  Aug 2021 - May 2022

  INFORMATICA MDM DEVELOPER

  I successfully resolved high-priority address issues in production by modifying the existing Address Doctor mapping. I actively participated in data cleanup activities and developed new functions for mapping purposes. I added new source systems by creating landing tables, base objects, staging tables, mappings, and cleanse functions. I fixed various issues within IDD, implemented IDD Bulk Import functionality, and extended IDD applications. I worked on IDD User Exits and hub cleanse functions, displaying error/warning messages and performing backend processes. I attended business meetings and provided MDM solutions for various scenarios. Additionally, I created a new manual match rule and an Oracle script to address a specific business scenario. I also developed an Oracle-stored procedure to retrieve the latest golden record. In terms of the environment, I worked with Informatica Multidomain MDM 10.2 HF1, Oracle 11g, SQL Developer, IDD, SoapUI, and Eclipse Show less

• 

  Toyota Financials

  Jun 2022 - now

  Informatica MDM Developer

  I successfully upgraded MDM from 10.1 HF2 to MDM 10.3 HF2 and solved high-priority production issues after the migration. I worked in both the Production Support team and DevOps, handling user stories for development. I had experience with provisioning tools, IDD, Active Vos, SQL, and external calls. I fixed IDD issues, created workflows in Active Vos Designer, and performed mass updates and file imports. Additionally, I worked on building new UI screens and provided MDM solutions for business scenarios. I handled production tickets and problem tickets in ServiceNow. Overall, I gained valuable skills in Active Vos and provisioning tools. My environment included Informatica Multidomain MDM 10.3 HF2, SQL Developer, IDD, Active Vos Designer, and Eclipse. Show less

• 

  McKesson

  Jun 2023 - now

  Informatica Developer/Prod Support

  Informatica MDM Developer/Prod SupportMckesson Corporation, IrvingJune 2023 - PresentResponsibilities:• Successfully upgraded MDM from 10.1 HF2 to MDM 10.3 HF2, enhancing data management capabilities within the Enterprise Supplier Portal (ESP).• Expertly resolved high-priority production issues and challenges post-migration, ensuring uninterrupted operations.• Collaborated within a dynamic Production Support team while concurrently managing DevOps board user stories, bridging the gap between development and operations.• Leveraged Provisioning tools, IDD, Active Vos, SQL, and external calls to analyze requirement specifications and actively participated in Business meetings to capture essential Business requirements for seamless implementation.• Effectively addressed IDD issues, such as File Import and IDD search result enhancements, optimizing data governance.• Applied hands-on expertise in Active Vos Designer to create workflows that trigger actions after creating, updating, or deleting records. Crafted diverse email workflow structures tailored to specific business needs.• Developed Soap UI scripts for comprehensive testing, utilizing XML scripts to validate data across various individual data sets for each ORS.• Spearheaded the design and implementation of a new S360 screen UI in collaboration with the provisioning tool and SQL scripts, aligning with user requirements.• Actively engaged in Business meetings, offering MDM solutions for diverse Business scenarios and contributing to strategic decision-making.• Managed production tickets through ServiceNow and initiated problem tickets to address and resolve production issues promptly.• Achieved comprehensive skill enhancement in Active Vos and the Provisioning tool, strengthening expertise in data management and governance.Environment: Informatica Multidomain MDM 10.3 HF2, SQL Developer, IDD, Active Vos Designer, Eclipse, Enterprise Supplier Portal (ESP), MIR3, ServiceNow, GitHub, Jira. Show less