Kiruthika K Email & Phone Number

Chennai, Tn, In

Bengaluru, Karnataka, India

• Head SQL functions, utilizing Joins, Procedures, Macros, Sub-queries, Set Operators, and functions.• Exercise in-depth understanding of Teradata Architecture and Data Warehouse Architecture, including protection concepts such as Fallback, Journals, and more; with complete understanding of data warehousing development life cycle.• Conduct comprehensive root cause analysis on recurring issues, developing and implementing tailored solutions for long-term remediation. • Pilot initiatives based on metrics data to drive vulnerability remediation efforts.• Support users, resolving questions and concerns while recommending changes for optimal functionality; research, delegate, and follow-up on each request through to completion. • Identify appropriate data for follow-up, notifying application managers of upcoming deadlines. • Deliver specifications for system changes; review and approve game plans.• Advise and guide team members as the Shift Lead in Level 2 role; and manage a team of 5 in Level 1 role.

Chennai Area, India

• Collaborated with around 15+ colleagues on Mainframe and Teradata Application and Platform Maintenance and Support Team, as well as the ETL team of bank’s data warehouse, to effectively manage and protect data. • Executed operations involving the loading of data from different domains, including Channels, Deposits, GCIB, Interact, Cards, eCommerce, Marketing and Loans, as per Service Level Agreements (SLA).• Optimized processes for extracting data and loading to the Warehouse after transformation. • Utilized the ETL (Extraction, Transformation and Loading) Technology, applying expertise in this vital component of the Data Warehousing Architecture; the ETL software extracts data, transforms values of inconsistent data, cleanses "bad" data, filters data and loads data into a target database.• Delivered daily support while also providing specific DR support, hardware upgrades, outage management, and query resolution for users, the development team and the DR Team. • Performed continuous systems analysis in order to identify opportunities for improvement or enhanced risk management, implementing technology solutions on a proactive basis. • Liaised with senior leadership to ensure all production support operations align with overarching business goals and strategic objectives.

• Partnered with clients in order to understand business requirements, analyzing and designing the ETL process to meet goals and objectives. • Pioneered the development of BTEQ scripts to populate data into Teradata database.• Wrote SQL queries and delivered results as per the client requirement.• Produced ABC (Audit Balancing and Control) entries for the wrapper, process group and parm tables.• Championed strategic data Extraction, transformation and loading from source to target system using BTEQ and Informatica PowerCenter; completed various types of loading (Direct, Incremental, SCD Type2, and more) using scripts and configuration files.• Produced various queries (duplicates, tops, aggregates operations, etc.) to support essential business logics validation.• Remediated bottlenecks, identifying long-running queries and scripts. • Resolved unplanned outages with swift problem-solving. • Tuned performance by leveraging expertise in Explain and Collect Statistics commands. • Imported objects from development environment and to SIT environment (QA) in Informatica PowerCenter.• Knowledgeable in dry run for projects in QA; as well as mocking of data in development environment for Testing; Unit Testing; and preparing Unit Test Report for the entire project.• Crafted a range of documentation, including: Implementation and Backout Plan, Teradata Developers Checklist, Process Manual, Maestro Schedule, Maestro Questionnaire, and Attributes Worksheet.• Cooperated with interdisciplinary on-site teams throughout development, aligning goals and setting expectations; participated in weekly status meetings.

• Gathered credit decisions for Citibank credit products across various regions, based on the various levels of checks for the Credit Decision Engine tool, and performed all related analysis. • Designed and implemented the policy for deciding the credit limit and approving loans for CITI Bank customer for APAC countries. • Established the requirements form the business, and implemented the rules in the CDE (Credit Decision Engine).• Developed the Policy Understanding Document (PUD) and Design on Paper (DOP) for APAC countries.• Demonstrated expert knowledge in credit card and loan processing flow in the banking domain.• Worked with the HP quality center and resolved a key defect for APAC countries; attended Query Call and Defect Call to solve business queries.