Karthik Rao Mallige

Phone: 610-***-****

Email: ac2a68@r.postjobfree.com

LinkedIn: /karthikraom

SUMMARY

8+ years of hands-on IT experience in analysis, design and development of complex software solutions in client reporting and wealth management sectors.

Experienced in requirement analysis, development and testing various modules in a software development life cycle.

Excellent team player and proven track record working in various team sizes performing cross-functional roles.

Currently working as a Technical lead and senior developer in an agile team helping the team with estimation, identification of risks and dependencies and managing them.

Developed key validation processes in an order management system that helped the client process 100K orders within 20 minutes - which otherwise was taking 5 hours. This helped the client to ensure that orders were always sent before the cut off time to the street.

Designed and implemented an ETL solution for a complex requirement of tax reporting of income on Common Trust Funds to third party tax vendor using Informatica Power center 9.1 and Oracle PL/SQL. The timely delivery of this solution helped the client to onboard one of their biggest customer.

Proven track record as a problem solver and developed multiple solutions using Fitnesse, SQL*Plus and Windows scripts that was used for Integration Testing, Volume Testing and User Acceptance Testing.

Strong experience in Query tuning and fixed a long running income payment process by using better partition and purging strategies and by using the global temporary tables with better stats. This process gained at least two hours by these performance improvement changes.

Strong interpersonal skills and wore multiple hats as a Developer, Support Engineer, Technical Lead and proxy- scrum master.

ITIL certified professional with experience with supporting the service management for multiple applications across geographies.

Oracle certified Professional with substantial knowledge in query tuning, identifying the performance bottlenecks and fixing them.

Hands on experience in data modeling and redesigned purging and partitioning strategies for some of the Income Payment processes and significantly brought down their processing time.

Efficient in design test strategies for performance testing and volume testing of PL/SQL solutions.

Worked on various oracle concepts like views, triggers, materialized views, parameterized views, collections, types, functions, procedures, packages and exception handling.

Knowledge in different application frameworks like Struts, Spring and N-Tier frameworks across JAVA and .NET languages.

Demonstrated proficiency in executing Agile and Waterfall methodologies

Proficient in PL/SQL programming – Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects – Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.

Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.

Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, TK-Prof and Table Partitioning.

Received “On the Spot Award” thrice by the employer as an appreciation for handling the key deliverable to the client.

Received appreciation email from the CTO of a BSP client, for a deliverable which helped the client to increase its client base.

Consistently recognized by both client and employers as a fast learner with excellent problem solving and technical troubleshooting abilities.

Strong communication skills and experience of executing projects for prestigious clients at multiple customer locations.

SKILLETS SUMMARY

Methodologies and Framework

Agile/Scrum and Waterfall SDLC methodologies, Change Management, Release Management, Database Design (RDBMS),

Domain Knowledge

Client Reporting, Portfolio Management, Trade Management and Execution.

Operating System

Windows, UNIX, Linux

Databases

Oracle 10g/11g/12c, SQL Server

Languages

SQL, PL/SQL, C, C++, C#, JAVA

Testing Tools

Fitnesse, SoapUI.

Configuration Tools

Tortoise SVN, Star Team, VSS, GIT, Source Tree

Code Review Tools

SonarQube, Stash

Documentation

Atlassian Confluence, Windows Office, OpenOffice

EDUCATION

Visvesvaraya Technological University, Karnataka, INDIA

B.E., Information Science June 2008

CERTIFICATIONS

Oracle Database Administrator Certified Associate, Issued by Oracle, 2012.

ITIL V3 Foundation Certificate, Issued by ITIL, 2011

Oracle Certified Advanced PL/SQL Professional, Issued by Oracle, 2010

Oracle Certified Associate, Issued by Oracle, 2010

EXPERIENCE

Tata Consultancy Services

Client: SEI Investments Oaks, PA

Developer and Technical Lead May 2013 – Current

SEI is a financial services firm, provides Innovative solutions for creating and managing wealth, including asset management, investment processing and investment operations.

SEI Wealth Platform (SWP):

SEI Wealth Platform is a multiple technology platform delivered via the Internet that provides customers with the information and functionality needed to enable sales, marketing, advice, service, administration, and business management. The technology provides enterprise architecture, shared components, and an enhanced user experience, which supports all markets and solutions. SEI Wealth Platform has various different modules which cover the various business processes like Relationship Management, Portfolio Management, and Activity management, Client Portfolio Management, Corporate Actions, Reporting, Transaction Services and Reconciliation. Platform is used to capture the entire trade life cycle of various securities. It includes trading and settlement.

Responsibilities:

Worked on different modules of the wealth platform which included

oPortfolio Management, Strategy Management and Portfolio Auto-Rebalancing

oTrading and Settlement Calendars

oMutual Fund Order Generation

oDaily Rate Fund Processing and Execution

oNSCC Income posting

oTaxation of Client Accounts

Currently working as a tech lead to bridge the gap between the product architecture and detailed designing.

Also working as a senior database developer and data architect involved in data modeling and designing data purging and partitioning strategies.

Make necessary changes to the Tax Reporting data transformation job using Informatica power center 9.1 based on the requirements from the Tax Vendor.

Analyze the features that are loaded and split them into user stories and work with the product owner to prioritize them.

Identification of risks, dependencies, cross track impacts and managing them within the agile teams.

Design, Review and performance test the code to make sure it scales appropriately.

Working with the Product Owner to identify the opportunities for improvement and add them to the technical debt of the agile team.

Ensuring the critical technical lessons learned from the agile PSI (Potentially shippable implements) are discussed in the retrospective and are documented.

Create test plans for Volume testing of code that is developed in a sprint / PSI.

Create Fitnesse pages for acceptance testing and writing stored procedures related to them.

Worked in different teams within the same client that involved cash processing, cash disbursement, portfolio strategy management, mutual fund execution, trade calendar management, daily rate funds and US tax processing.

Developed a flat file generator application using Windows Script and SQL*Plus, that was used to performance test income processing flow – which otherwise would have taken a lot of manual effort to create a test file.

Create a user interface using Fitnesse which was used by quality analysts – which helped them to sign off some of the Agile Stories related to daily rate fund postings. Without this interface testing of these stories was impossible and the delivery of the code would have been impacted.

Part of an automation initiative that did the POC on moving GIT commits between branches using Python and SourceTree.

Working with DBMS_XMLGEN and DBMS_XMLSTORE package to generate and insert XML files in Oracle 11g.

Working with developers to repair and enhance current base of PL/SQL packages to fix testing issues and build new functionality and improve processing time through code optimizations and indexes.

Creating PL/SQL triggers, sequences, and stored procedures using Toad and SQL Developer.

Continuous review of Business critical Database to proactively identify space issues, performance tuning issues

Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.

Created new mappings, modified existing mappings using Informatica Powercentre9.1.

Handled errors using System defined exceptions and User defined exceptions like INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Developed Row level and Statement level Triggers for auditing tables in PL/SQL.

Developed Views and Materialized Views for specific data retrieval for the reports.

Involved in backup of Oracle Database instance

Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries

Involved in the continuous enhancements and fixing of production problems.

Developed and maintained Oracle Forms and Reports for various applications using SQL*Plus and PL/SQL.

Implemented necessary monitoring scripts for Golden gate in Unix/Perl scripting.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.

Developed SQL *Loader scripts to load data in the Staging tables.

Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.

Environment: Oracle 11g, 12c, Java Spring, WebLogic, Informatica

Tools Used: SQL Developer, SQL*Plus, Informatica Powercenter 9.1, SourceTree, BitBucket/Stash, GIT, SonarQube, Fitnesse, ServiceNow, CA Agile, Confluence

Tata Consultancy Services

Client: Deutsche Bank AG Bangalore, India

PL/SQL Developer and Application Support Engineer (Level 3) Jan 2010 – Apr 2013

DBValuations, DBCamm and DBRex were three main applications used by Deutsche Bank in the Collateral Management and Valuations (CMV) platform.

DBRex was a clearing and settlement platform in which Deutsche Bank (DB) acts like clearing broker between the clearing houses and clients. DB will get the trade exposure data from different central counterparties (CCP’s) and clear that trades with their respective settlement dates and DB will send statements to the clients.

DBCamm was an application used by the operations team to create agreement between party and counterparty, and send margin calls and other important economic data like FX Rates etc. to those clients. This application was also used to maintain such agreements and also was used to maintain a set of static data would be used for reporting purposes.

DBValuations was a reporting platform that gives a user interface to the Deutsche Bank operations team to create/edit and maintain Securities. Apart from this it was also used to create report requests based on which the application was generating the report in different client languages and in different formats.

Responsibilities:

Participate in the Design Workshops with the different stakeholders of the application and come up with the finalized approach.

Design Technical design document based on the business requirements.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collections in PL/SQL objects for improving the performance.

Adapted the agile methodology and delivered the DBRex solution in two sprints - Application that supports the single currency clearing in the first sprint and multi-currency clearing in the second sprint.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Written PL/SQL Cursors for transaction processing.

Used Bulk collect feature to process the data from Cursor/Ref Cursor.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Co-ordinate with the Business Analysts and with the users and compile the Low Level Design for the application.

Liaise with all the development teams involved and take necessary design decisions, when needed.

Create PL/SQL procedures using Global Temporary Tables and Dynamic SQL that will be used by the UI to bring up trade details on the dbRex UI.

Create reusable views and materialized views that will source data from different tables within or across schemas.

Used Parameterized views approach to tune some of the performance issues encountered on the DBRex pages.

Co-ordinate with dbMargin and dbRex 1.0 teams and create or modify tables’ suit the requirements.

Participate in the Developmental Activities - Development, Unit Testing and Integration testing.

Acted as the single point of contact for all Level 3 service requests.

Co-ordinate with the incident managers from different geographies and with other stakeholders for incident resolution.

Effectively worked with a multi-vendor supported, interconnected set of applications, during service incidents for their resolution.

Provide estimates for the change request and work with the change request management team to prioritize the change requests.

Co-ordinate with the Business Analysts and with the users and compile the Low Level Design for the change requests.

Developed many loader-like applications for security and price management that helped the DB operations since it saved a lot of manual effort.

Created new reports for the operations user using PL/SQL, Global Temporary Tables and PL/SQL collections.

Effectively used PL/SQL collections for BULK actions in DBCamm which resulted in very good user experience while searching large number of trades on the DBCamm application.

Create new Perl and shell scripts that can be called by the Control M jobs.

Migrated all the Cron jobs into Control – M.

Developed UNIX Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.

Worked extensively with the universe team and database team and users to analyze the gaps.

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.

Upgraded the existing database from Oracle 10g to Oracle 11g.

Involved in Logical & Physical Database Layout Design.

Created queries to minimize transactions, table data size and copy into historical tables.

Use SQL*Loader and SQL*Plus to make necessary changes in the reporting platform so that the new report formats can be seamlessly integrated with DBValuations.

Liaise with all the development teams involved and take necessary design decisions, when needed.

Design and code review of the deliverable.

Mentor the new team members with Client Margin and Valuation Reporting platform and with the technologies used.

Environment: Oracle 10g, 11g and ASP .NET 2.0,

Tools Used: SQL Developer, SQL*Loader, SQL*Plus, Tortoise SVN, Symphony, BMC Remedy, Visual Studio 2010 and Control M

Tata Consultancy Services

Client: Deutsche Bank AG, Singapore Bangalore, India

Application Developer Jan 2009– Dec 2009

Part of a development team that designed the conference and events management portal for the client.

Used the Hibernate technology to display the conference and events on the application using JavaScript and JSP.

Create new Java Methods and Delegates to access the information from the Oracle Data base using Hibernate.

Deploy the code in Apache Tomcat and Unit Test the changes.

Develop new JSPs to display the conferences and events and make necessary changes as per the requirement.

Develop new Java Script functions which will be triggered on page events.

Participate in the Developmental Activities – Development, Unit Testing and Integration testing.

Environment: Oracle 10g, Java Hibernate and Apache

Tools Used: SQL Developer, Eclipse, BMC Remedy.

Contact this candidate