Harsha Gummadavelli

I have been working on projects that involve providing data management and data integration solutions for different clients working on Informatica’s Cloud platform – IICS/IDMC (Informatica Intelligent Cloud Services/Intelligent Data Management Cloud) using different services like CDI, CAI, CDQ, CIH, CDCG and C-TDM.

My responsibilities include:

• Responsible to set up IICS/IDMC environments (secure agent installation, groups creation, roles creation, SSO integration, version control setup, code migration)
• Building data integration solutions using CDI for batch-processing and CAI for real-time integrations.
• Instrumental in setting up Data Governance functionality using CDGC service on IICS/IDMC platform.
• Involved in a Data Migration project to migrate data from legacy Oracle CRM into Salesforce CRM. Dealt with Cloud Data Quality, Cloud Data Integration for migration efforts for profiling and building integration/migration solutions respectively
• Familiar with SFDC’ standard and bulk APIs, Workbench, Data Loader and other assets of Salesforce domain to facilitate proper data migration
• Involved in technical implementation for CDCG activities, like resource scanning, connection assignments, establishing data lineage, workflow enablement, etc.
• Collaborated with cross-functional teams to deliver high-quality software products on schedule.
• Helped business data stewards for creating glossaries, business terms, policies and domains.
• Built collection via data sets to enable Cloud Data Marketplace implementation.
• Worked on security framework implementation for CDCG access via policy based roles to access different types of assets.
• Built migration checklist and templates for migration planning and implementation.
• Built data classification rules based on the business requirements for PHI/PII guidelines along with other industry compliance needs like CCPA and GDPR
• Worked on data integration use cases with multiple applications like SAP, MS Dynamics, Tableau Reports, PowerBI reports, Workday, Salesforce
• Worked on a migration project that involves moving data from SQL Server to Snowflake. Different integration techniques like Cloud Data Integration and Mass Ingestion was used as part of this.
• Worked on integration pipeline building for different AWS data sources like AWS Redshift, S3 buckets, etc. Worked on administrative activities for secure agent servers installed in AWS.
• Worked with the AWS Administrative personnel in setting up the right security groups, VPC, etc. for establishing connectivity with different data sources.
• Worked on data integration projects where data from Peoplesoft was moved to Workday. Used Workday connector, REST API endpoints, EIB process for data load into Workday.
• Worked on data movement use case from SQL Server to Azure Synapse and ADLS datastores per the requirements.
• Instrumental in setting up CI/CD pipeline via Azure DevOps integration with IICS REST APIs.
• Mentored junior engineers, providing guidance on best practices and fostering professional growth.
• Led architecture discussions, guiding the team in making informed decisions about technology choices for various projects.
• Increased system reliability by proactively addressing potential security vulnerabilities.

• As an independent contractor, I worked as a Informatica Engineer helping different customers to adopt and implement data solutions on IDMC platform.
• List of customers served:

State of Massachusetts (08/2021 – 01/2022)

Inseego (06/2021 – 08/2021)

• Integrated disparate data sources to create comprehensive informatica solutions.
• Enhanced system performance with thorough debugging and code optimization techniques.

• At Informatica, I worked as a solution architect providing architecture and solutioning guidance on Informatica suite of products. My responsibilities include –
• Provide technical leadership and act as a subject matter expert on using Informatica platform for data integration and data governance needs
• Designed and developed data migration between disparate systems using Informatica Cloud platform (also known as IICS – Informatica Intelligent Cloud Services)
• Built solutions for both batch processing integration (CDI) and real-time integration (CAI) including event-based orchestration use-cases
• Experience in working with Cloud Data Quality (CDQ) and Operational Insights
• Act as a trusted advisor and provide guidance to customers to quickly adopt to Informatica platform
• Part of strategic initiative team to migrate existing PowerCenter customers to IICS platform. Involved in repository assessment, migration utility enhancement, planning and delivery of the migration efforts
• Work closely with the broader Informatica teams, customers, and channels to deliver the right solution and help drive innovation of product capabilities
• Worked on AWS and Azure instances for product deployments and data storage like S3, Redshift and SQL Data Warehouse, ADLS Gen2 and Azure Synapse
• Extensive implementation experience in working with different SaaS applications like, Salesforce, MS Dynamics CRM, Workday, NetSuite, Marketo, etc.
• Instrumental in delivering data migration projects from legacy applications like SAP to Cloud based applications like MS Dynamics CRM, Snowflake, etc.
• Expertise in performing scanning operations across different data sources: relational, flat file, mainframe systems, etc.
• Created and loaded resources from multiple data sources to build data lineage
• Designed and developed complex masking rules and out of the box masking rules
• Provide guidance to customers on the required sizing for different products and environments
• Developed pipelines to read and write from APIs
• Created Shell scripts for housekeeping needs (log file cleanup, etc.) on the secure agent server and published to multiple customers
• Helped customers setup CI/CD pipelines via Jenkins. Involved in initial setup and execution of a pipeline.
• Worked on PC 2 IICS migration factory engagements. Performed migration reporting on Tableau using internally built data model for all conversion needs

• As an Informatica Architect/Manager of the Data Engineering team, my roles and responsibilities include the following –
• Provide technical leadership and act as a subject matter expert on using the Informatica products
• Lead the Platform Maintenance team, which is responsible for deployments, monitoring and Informatica infrastructure maintenance
• Responsible for setting up Informatica Center of Excellence to drive product usage across different departments and line of businesses
• Liaise with various stake holders like Business Analysts, Application owners, etc. to gather requirements and create technical documents as required
• Participated in multiple forums to showcase Data Management capabilities, product stack and their usage
• Managing FTEs and Vendor team members (onsite & offshore)
• Provide Best Practices in implementing the Informatica products, especially Informatica ILM Data Archive, Application Retirement and Test Data Management, Power Center, Power Exchange for replication and Data Quality
• Successfully implemented data privacy program across the organization that saved multimillion-dollar potential fines
• Implemented enterprise wide Test Data Management framework for provisioning non production environments by using Data Subset and Data Masking functionalities of the product.
• Instrumental in setting up DevOps strategy for Informatica platform for deployments
• Participated in vendor selection process by conducting thorough POCs, and evaluations
• Created UNIX shell scripts for different project requirements, job executions, etc.

• As a Senior Consultant-II with Informatica Professional Services organization, my roles and responsibilities include the following –
• Be a thought leader and provide advisory services for Informatica suite of products
• Provide technical leadership to infrastructure design
• Provide technical leadership in solution design for ILM product suite (Informatica Data Archive, Application Retirement & Informatica Test Data Management)
• Some of the clients received potential savings of more than $1 million USD per annum due to the projects that I have helped implement
• Sole responsibility of the project delivery from Informatica for all the projects
• Liaise with cross-teams for any required information/support in implementation
• Create and publish high-level design documents, technical design documents for the implementation
• Provide framework design to extend the implementation for multiple applications
• Provide Best Practices in implementing the products – Informatica Data Archive, Application Retirement and Test Data Management
• Provided assistance to the Sales & Pre-Sales organization by handling POCs, answering RFPs and writing SOWs along with product enablement