Prathica Krishnamoorthy

Dara

• Developed complex ETL mappings using IICS (CDI), incorporating transformations such as Router, Lookup, and Aggregator.
• Built task flows, parameterized mappings, and reusable components to enhance efficiency.
• Implemented SCD Types 1, 2, and 3 for dimensional models with both incremental and full loads.
• Utilized file list and indirect methods for dynamic source handling, applying TCL logic for file generation.
• Executed SQL performance tuning to optimize query execution plans.
• Performed UNIX scripting to automate data processing tasks and improve productivity.

Cirrus

• Deployed ETL solutions in IICS, emphasizing data synchronization, replication, and mapping tasks.
• Ensured data accuracy and integrity through collaboration with data architects.
• Developed shared sequences and dynamic task flows to optimize workflow efficiency.
• Utilized fixed and key range partitioning techniques for effective source data management.
• Conducted unit testing, detailed documentation, and production support for various queries.

IT Support

• Managed Azure environments and Microsoft 365 administration, including Intune and Exchange roles.
• Enhanced system management and remote troubleshooting using ManageEngine, Bomgar, and PowerShell.
• Administered ServiceNow for over 200 users
• Created dashboards and reports for operational insights to support IT leadership.
• Maintained SLAs for incident, change, and service request modules to ensure service quality.
• Collaborated on system upgrades and patch testing to minimize disruptions.
• Developed role-based access controls and updated group assignments for streamlined permissions.
• Optimized IT infrastructure through workflow automation and resolution of complex technical issues.

Broadcom Inc

• Analysed business requirements to design effective ETL mappings.
• Developed ETL mappings and transformations using Informatica PowerCenter 9.1.
• Used Informatica PowerCenter to design and develop workflows by leveraging Task Developer, Worklet Designer, and Workflow Designer within Workflow Manager, and ensured successful execution by monitoring outcomes through Workflow Monitor.
• Implemented source and target definitions in PowerCenter Designer.
• Utilized various transformations including update strategy, lookup, and joiner to enhance mappings.
• Collaborated with cross-functional teams to deliver high-quality data solutions.
• Designed proactive monitoring solutions for ETL processes to prevent bottlenecks.
• Optimized data integration through efficient ETL process implementation.
• Wrote and optimized SQL statements within applications

Fleetcor Inc

• Executed ETL development for data migration from AFEX Dynamics to Fleetcor Salesforce using Talend.
• Managed transformation of prospect and customer datasets, developing ETL jobs per mapping documents.
• Proactively addressed defects by conducting thorough testing across multiple scenarios.

Kaiser Permanente

• Implemented end-to-end process flow for invoice processing, ensuring swift payments to vendors.
• Developed automation tools to enhance data formatting, packaging, and file movement efficiency.
• Served as subject matter expert for invoice processing, reducing database upload rejections through quality assurance.