Kiran Kumar Email & Phone Number

United States

United States

Successfully leveraged Informatica PowerCenter tomigrate about 750million rows of legacy data from Sybase to Oracle, utilizing Slowly Changing Dimension (SCD) Type 1 methodology to ensure data integrity and consistency, and collaborated with cross-functional teams to ensure data migration aligned with business requirements and met stringent data governance standards.Ensured data integrity during data migration by designing and executing data validation and quality check processes, guaranteeing accurate and reliable data transfer.Designed and implemented an automated solution to load and validate ratings data, utilizing SQL to significantly reduce manual effort and dependence on the Technical Services team.Designed and implemented an automated solution for adding MISC and NEC 1099 forms for future years, leveraging SQL scripting and Omnis Studio reporting capabilities to streamline processes and reduce manual effort.Analyzed and refined SQL to achieve efficiency gains of up to 50%, driving substantial performance improvements in critical areas.Successfully assumed ownership and leadership of Adtraq, an older suite of Agency applications built on.NET and Pick Basic, ensuring seamless continuity and improvement of the system.Designed and developed scripts to synchronize vendor, client, and invoice data between LAS on Oracle and Adtraq on SQL Server, ensuring data consistency and integrity across both systems.Designed and developed an AI-powered chat-bot using LangChain, PostgreSQL, and Retrieval-Augmented Gen-éeration (RAG) to enable users to query product manuals in natural language, providing a more intuitive and user-friendly experience.Designed and implemented an automated solution to clear locks in Adtraq, utilizing Pick Basic and SQL, eliminating manual intervention and reducing the risk of data inconsistencies and errors.

Served as the de facto Subject Matter Expert (SME) for LAS, providing guidance and support to team members and stakeholders.Collaborated with cross-functional teams to identify training needs and develop targeted training programs, resulting in improved product knowledge and increased team efficiency.Successfully managed the end-to-end delivery of LAS with a significantly reduced team of under 5 people, demonstrating exceptional leadership and project management skills.Successfully integrated LDAP authentication with LAS, resulting in improved user experience, reduced adminis-étrative burden, and enhanced security posture.Designed and developed a comprehensive reportingmodule using Omnis Studio, providing users with a flexible and intuitive reporting experience that allows for customization of detail and summary data.Implemented additional checks in workfile posting routines, resulting in a significant reduction in workfile issues by over 50%, and improving overall data quality and integrity.Anticipated and mitigated issues caused by Apple ending support for 32-bit macOS applications, ensuring a seamless transition and minimal disruption to operations.

Successfully managed a 30-member team of offshore Developers, Quality Assurance engineers, and Technical Services engineers to ensure timely issue resolution of issues.Collaborated with Client SMEs to gather requirements formultiple product enhancements, developed functional and technical specifications, and came up with effort estimates and development plans.Successfully led the delivery of approximately 25 major enhancements.Successfully handled Level 1 (L1) tickets, providing timely and effective technical support to resolve customer issues and improve overall customer satisfaction.Performed thorough code reviews for Level 2 (L2) and Level 3 (L3) tickets, ensuring that code changes were accurate, efficient, and met the required quality standards.Successfully reduced data anomalies by 80% in under 12 months, demonstrating expertise in data quality improvement and root cause analysis.Designed and developed algorithms to calculate Reach and Frequency, two fundamental metrics for measuring the effectiveness of an ad campaign, using Omnis Studio and PL/SQL code.Rewrote major portions of EAS from Omnis Classic to the newer OOPS-enabled Omnis Studio coding paradigm.

Successfully maintained and fixed issues in EAS, resolving over 30% of issues in a team of 15 developers, demonstrating expertise in software maintenance and troubleshooting.Refined existing systems through targeted improvements and minor enhancements.Successfully developedmacOS implementations for Windows-only reportingmodules, demonstrating expertise in cross-platform development and implementation.Successfully implemented amajor portion of the TECC buy import module, demonstrating expertise in software development and implementation.

Bachelor Of Technology, Electronics And Communication Engineering

Bachelor Of Technology - Btech, Electronics And Communications Engineering