Karthikeyan Kannan

A High‐performing and self‐motivated professional with around 12 years of experience in the IT Industry, working in IBM Info Sphere Information Server suite as a developer in Data Warehousing. Extensive experience in managing large‐scale projects from the requirements gathering phase to successful completion. Over 10 years of experience in code optimization and performance tuning of both ETL code and queries. Highly skilled in tracking details, communicating deadlines, and following‐up with internal and external partners to ensure on‐time completion within budget. Obtained very good work experience with some of the major clients in banking verticals and had performed the role of Senior ETL lead, involved in requirement analysis, development, designing, quality reviews and testing. Highly capable of handling ETL projects from offshore by leading the development team to interact with the client and the business users for requirement gathering and technical design. Experienced in working in various phases like requirement analysis, coding, testing and provided support to production environment. Provided assurance in the quality of the deliverables. Skilled at resolving incidents and service requests within SLA. Excellent domain knowledge in Banking and Finance with the great ability to learn and adapt to new technologies quickly and able to cope up and work well in any environments. Implemented various end-to-end projects following Agile methodologies. Extensively worked on Real time stages and developed shell scripts to automate the process. Excellent problem-solving skills with strong technical background. Good interpersonal skills to adapt well to the environment and assessing needs, generating opinions, and implementing solutions in collaboration with clients and stakeholders. Took ownership in challenging tasks and provided creative problem-solving solutions, which helped to save manual effort on daily project activities. Experienced in integration of various data sources like Oracle, SQL, and Sybase into operational data store and warehouse environments. Experience in main frame tool named JCL for scheduling the jobs. Automated many of the manual tasks and daily activities in the projects, yielding productivity.

• RBC ITAS ET-PPM/ODIN APP, 15/02/2020- Till Date, Toronto, Canada, RBC ITAS ET-PPM/ODIN APP is a legacy RM system. ODIN Receives trade and market data from almost 30 source systems, including currently around 110 trade source feeds in the data repository. There are combinations of RBCCM, and vendor supplied sources used in the repository. ODIN is a batch-based system, which runs every Monday to Friday year-round. It receives daily end-of-day positions (with instrument attributes) from FO, BO, and middle office systems globally. It maps those positions and instruments into a normalized database. Using an in-house built tool, it creates instrument file inputs to its calculation engine Risk Watch. The models in Risk Watch are a mix of in-house and ready made from Algorithmic. Input from the back office is used to load daily rates, produce both historical, and stress scenarios for input into Risk Watch. Risk Watch outputs resultant P&Ls at the instrument/scenario level. ODIN runs on Oracle in a Solaris environment, using Autosys for scheduling and Data stage for mapping., The most significant corporations, institutional investors, asset managers, private equity firms, and governments around the globe recognize RBC Capital Markets as an innovative, trusted partner with an in-depth expertise in capital markets, banking, and finance. Locations span 70 offices in 15 countries across North America, the UK, Europe, and the Asia-Pacific region. Employment estimates for RBC professionals are roughly 7,200 per company reports. Services provided include insights required to raise capital, access markets, mitigate risk and acquire or dispose of assets for clients worldwide. RBC Capital Markets is part of Royal Bank of Canada (RBC). Operating since 1869, RBC is the fifth largest in North America and the 11th largest bank globally as measured by market capitalization. With a strong capital base and consistent financial performance, RBC is among a small group of highly rated global banks., Participate in the establishment of project scope/requirements with more senior project managers, business representatives and/or Business Analysts., Validate & prepare Design and estimation document and obtains sign-off from clients for functional requirements/specifications., Design the new data model using Cognizant proprietary tools Intraday Data Modelling for ILM to address the limitations of the current ILM data model., Perform analysis of the existing data flow in the current data model and migrate it successfully to the new data model using Cognizant proprietary tool Intraday Data Modeling., Manage project by developing project plans; communicate all requirements to sub-contractor, managing the project schedule, developing and posting status reports, checking on the quality and timeliness of work., Having ODIN in agile methodology, actively participate in SCRUM calls on daily basis and update the ongoing task details., Chair and facilitate meetings with sub-contractor and communicates all information to team member to ensure a seamless process., Create a project management calendar for fulfilling each goal and objective., Review the job to determine code quality & ensure that all jobs meet the criteria., Responsible to promote the code from development to higher environments, which is automated through Jenkins, RMT and NEXSUS., Ensure batch is scheduled for QA/UAT/Pre-Prod and finally share the test results with business and get sign off from business and support team., Create a change request (CR) to deploy the code in production., Do PIV to ensure code works as expected and determine a course of action to resolve most routine project related problems and updates team members., Contribute to the Cognizant tools like XML Shredding & Analysis tool and Intraday Data Modeling by creating the code for XML parsing in creating the new data model and shredding the XMLs to the new flat model., Provide solutions to client by suggesting best tool to develop the code which involves cost effectiveness., Perform tuning activities (optimizing the ETL jobs, Reports and tuning SQL query) to save time, money & avoid bottlenecks., Prepare system design document containing the detailed description about the project, mapping rules for Data Stage jobs, Audit Mechanism, ETL Architecture and Job Sequence., Hands-on experience in real time stages like XML Hierarchical, SAP IODC and MQ stages to handle complex XML’s and SAP IODC posting., Involve in migrating DS jobs to Talent and also worked in Mainframe based scheduling tool named JCL., Develop strong and positive working relationships with discipline leads and project stakeholders, while maintaining adherence to objectives, process, & timelines., 2 Years 10 Months
• Global Market Risk Management, 11/01/2018- 14/02/2020, Chennai, India, ETL – shared services helps to bring together several current data services under common program, to deliver in a consistent fashion with common integration and deliver mechanisms, common data standards, common control and metrics, The Services includes: Financial Enterprise Data Repository (FEDR), Global Equity Repository Database (GERD), Cam Connect., The most significant corporations, institutional investors, asset managers, private equity firms, and governments around the globe recognize RBC Capital Markets as an innovative, trusted partner with an in-depth expertise in capital markets, banking, and finance. Locations span 70 offices in 15 countries across North America, the UK, Europe and the Asia-Pacific region. Employment estimates for RBC professionals are roughly 7,200 per company reports. Services provided include insights required to raise capital, access markets, mitigate risk and acquire or dispose of assets for clients worldwide. RBC Capital Markets is part of Royal Bank of Canada (RBC). Operating since 1869, RBC is the fifth largest in North America and the 11th largest bank globally as measured by market capitalization. With a strong capital base and consistent financial performance, RBC is among a small group of highly rated global banks., Participate in the establishment of project scope/requirements with more senior project managers, business representatives and/or Business Analysts., Validate & prepare Design and estimation document and obtains sign-off from clients for functional requirements/specifications., Design the new data model using Cognizant proprietary tools Intraday Data Modelling for ILM to address the limitations of the current ILM data model., Perform analysis of the existing data flow in the current data model and migrate it successfully to the new data model using Cognizant proprietary tool Intraday Data Modeling., Manage project by developing project plans; communicate all requirements to sub-contractor, managing the project schedule, developing and posting status reports, checking on the quality and timeliness of work., Having GMRM in agile methodology, actively participate in SCRUM calls on daily basis and update the ongoing task details., Chair and facilitate meetings with sub-contractor and communicates all information to team member to ensure a seamless process., Ensure batch is scheduled for QA/UAT/Pre-Prod and finally share the test results with business and get sign off from business and support team., Prepare Deployment document and create a change request (CR) to deploy the code in production. CR follow-ups to get it approved., Post implementation check involving PIV to make sure the code runs as expected without any defects. Prepare Operational manual/guide for the project., Enhancements also follow the above SDLC processes. Enhancements involve design changes and code changes., The data fix involves cleaning up of invalid data and populating the valid data into the data warehouse., Help customer in testing and provide timely solutions in case of problems being coming up in production environments., Do PIV to ensure code works as expected and determine a course of action to resolve most routine project related problems and updates team members., Performing the tuning activities like optimizing the ETL jobs, Reports and tuning the SQL query to save time and money avoiding bottle necks., Perform migration from DataStage ETL jobs to SSRS Reporting jobs., Transferring files/reports to different downstream in adhoc basis daily., Provide solutions to client by suggesting best tool to develop the code which involves cost effectiveness., Perform tuning activities (optimizing the ETL jobs, Reports and tuning SQL query) to save time, money & avoid bottlenecks., Prepare system design document containing the detailed description about the project, mapping rules for Data Stage jobs, Audit Mechanism, ETL Architecture and Job Sequence., Develop strong and positive working relationships with discipline leads and project stakeholders, while maintaining adherence to objectives, process, & timelines., 15 Months
• Ally Financial Inc, 11/12/2015 - 10/26/2018, Chennai, India, CARS is a mainframe-based system, enables the servicing of Ally’s broad product base across a diverse set of dealer/OEM relationships at market-leading scale. While Ally has benefited from a stable and comprehensive servicing platform, in CARS, Ally now seeks options to replace CARS while advancing business and technology capabilities and agility. Responsiveness, enabled through configurable business rules and workflow, will be at the heart of Ally’s next generation servicing platform. The Retail Program is seeking to replace the existing Retail Installment Sales Contract (RISC) and lease receivables accounting and servicing platform with a leading automotive RISC and lease receivables platform. The process capabilities considered in scope for this initiative begin once a RISC or lease is boarded to the platform, through the life of the RISC or lease, and terminating once the RISC or lease balance is paid in full or charged-off., Ally Financial is a bank holding company organized in Delaware and headquartered in Detroit, Michigan. Ally Financial is one of the largest providers of automotive financing products and services in the U.S., powered by a leading direct banking franchise, ally bank which offers 24/7 online retail banking products. Ally offers innovative products and services through its auto financing, insurance, online banking and corporate finance businesses. The company was known as GMAC, an acronym for General Motors Acceptance Corporation, until 2010. Ally is ranked 19th on the list of largest banks in the United States by assets, is the largest car finance company in the U.S. by volume, and serves over 6 million customers Via its Smart Auction online marketplace for auto auctions, launched in 2000, the company has sold more than 5 million vehicles including 281,000 vehicles sold in 2018, Primary responsibility was to involve in the system design, data modeling and the development of the ETL jobs to meet the requirements., Interacted with onsite technical architects and SME’s to gather and clarify the requirements and to communicate the status of the project., Prepared system design document containing the detailed description about the project, mapping rules for Data Stage jobs, Audit Mechanism, ETL Architecture and Job Sequence., Developed unit test cases for Data Stage jobs and also involved in root cause analysis and bug fixing for the technical ETL issues., Prepared system design document containing the detailed description about the project, mapping rules for Data Stage jobs, Audit Mechanism, ETL Architecture and Job Sequence., Hands-on experience in Real time stages like XML Hierarchical, SAP IODC and MQ stages to handle complex XML’s and SAP IODC posting., Involved in design document walkthrough and getting approval., Developed SQL queries for requirements and scenarios in the project and also involved in performance tuning., Developed unit test cases for Data Stage jobs and also involving in root cause analysis and bug fixing for the technical issues., Continuously delivered ETL code to higher environment., Involved in code reviews and peer reviews before delivery., Involved in developing reusable components and optimization of existing complex ETL jobs., Involved in data stage migration from DS 8.7 to 11.5., Implemented the framework components for audit and reconciliation., Involved in setting up the coding standards to adhere standards., Active participation in QA meetings and regularly interacted with the business analysts to validate and fixing the defects., Supported the QA testing and assisted until sign off., Coordinated with Control-M team for job scheduling., 35 Months

AZ-900 Microsoft Azure Fundamentals