Data Developer

PUNNAM CHANDER AKUBATHINI

E: adiorz@r.postjobfree.com P: 484-***-****

Professional Summary:

Having 10+ Years of experience in Banking & Financial Services domain and Oracle PL/SQL, SQL, Informatica Power Center 9.5.1, Data Warehousing, UNIX, Shell Scripting and other tools& technologies.

Hands on experience in ETL Transformations, Oracle SQL Query Performance tuning, PL/SQL optimization using SQL Trace, Explain Plan, Indexing and Hints. Proficient in writing complex SQL queries, normalization, database design, creating Indexes and sub queries.

Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).

Used Informatica Power center 9.5.1 for bug fixes from various OLTP databases and other applications to the data mart and downstream applications.

Creation of database objects like Packages, Tables, Indexes, Constraints, Triggers, Stored Procedures, Functions, Triggers and Materialized Views.

Hands on experience in data modeling concepts such as creating entities, properties and defining relations between the entities etc.

Techno-Functional expertise in dealing a variety of Reporting Tools, Database Solutions and

Business Problems.

Pretty Good exposure in Crystal Reports and oracle forms with hands on experience.

Worked in multiple software development lifecycle best-practices, methods, and conventions such as AGILE & SAFE framework including but not limited to Test Driven Development, Source Code Management and Quality Assurance.

Acquired strong business process knowledge throughout career which will drive project execution. Dedicated team member with great communication and mediation skills.

Participated in many team level activities like CSI (Continual Service Improvement), Ideas and Innovations practice, “Hackathon” account level technical competition to improve business in more Innovative way.

Capable and proved to handle major & minor enhancements, bug fixes, adhoc requests to provide resolution within SLA. Flexible enough to adopt new technology and tools in the project.

Skills:

Oracle 11g/10g/9i, SQL, PL/SQL, Informatica Power Center 9.5.1, UNIX, Shell Scripting.

Pro*C, HTML, XML, MS SQL Server, PL/SQL Developer, Toad, WINSCP.

SQL*PLUS, SQL*Loader.

Oracle Forms, Crystal Reports, ControlM jobs, Oracle Scheduler.

ER Studio Data Architect 11.0, RALLY, SVN.

Bit Bucket, Tool Box, Confluence, Source Tree, Open Grok.

AGILE and SAFE methodology.

Accomplished problem solver with the ability to perform multitasking. Excellent reading comprehension skills with the ability to quickly learn new software languages.

Competent with analyzing the possible outcomes of different actions and choosing the best one. Capable to explain complex problems with internal and business teams to understand and assist in troubleshooting them. Person of great integrity with experience keeping internal practices confidential.

Work Experience:

Project 1:

Project Name: SEI – Eco Habitat

Location: SEI Global Inc, One Freedom Valley Drive, Oaks, PA, USA 19456

Duration: 06/19/2017 to Till Date

Project Summary:

SEI is a leading global provider of asset management, investment processing, and investment operations solutions for institutional and personal wealth management. SEI follows SAFE framework to deliver high quality services to customers. So, there are multiple trains across the platform and all teams under each train works with cross track dependencies while delivering a feature. So, Eco-Habitat is one such team under the Paddy Wagon train and here will maintain the existing and new portfolios which is a part of wealth management. Design and develops the changes as per the business discussions and documents that was prepared as part of PSI planning. He received many appreciations, awards from client for his outstanding performance.

In Eco-Habitat he worked for below modules.

Loader batch framework: Loader batch framework is a platform where many loaders that belongs to several other teams will run using this framework. Individual Loaders which run using loader framework are used to load the data in bulk into SWP system instead of loading the data individually through UI which consumes more time and effort. There are 18 loaders which are developed baselining this loader framework.

Reversal Loader: Reversal loader is one such loader which runs using Loader batch framework in SWP system. This Loader will reverse multiple different types of transactions in bulk and reversing all these transaction type in one go is really a complex task to handle as each transaction follows its own pattern for reversal and combining all such transactions in one file and reversing is achieved using this loader. Whereas users can reverse only one transaction at a time on UI without using this loader.

Free Movement Loader: Free Movement loader is one such loader which run using Loader batch framework in SWP system. The Free delivery/receipt (These two are called as Free Movement Transactions) functionality allows user to settle securities transactions by making book entry deliveries to another participant's account from SWP. This Loader will create free delivery/receipt transactions in bulk. Whereas users can create only one transaction at a time on UI without using this loader.

Roles & Responsibilities:

In SEI – Eco Habitat working as ‘Senior Oracle Database Developer & ETL consultant’ at onsite and Responsible for developing strategies for data management practice and implementing process to align Data Management vision with strategic business initiatives to have bulk data in automated flow.

Developing and Unit Testing Informatica, PL/SQL, UNIX shell scripting changes as per business requirement and building test data for different test cases for QA & PE Teams.

Design and develop data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX.

Data Analysis and reducing data discrepancy for the source and target schemas. Build Ad-Hoc SQL queries to verify data integrity and data analysis.

Creation of clone databases for QA testing. Development of SQL Scripts to pull the data from Service systems.

Creating SQL reports, data extraction and data loading scripts for different databases and schemas.

Build various stored PL/SQL blocks including Stored Procedures, Functions and Packages to manipulate and transform data according to the requirements.

Working closely with Performance Engineers and Quality Analyst for the data requests.

Data modeler for multiple teams to manage data structure of the application.

Member of Loader Framework Architecture COE who takes the responsibility of addressing the issues and concerns raised by loader teams related to framework issues.

Project 2:

Project Name: Credit Suisse-ZPAS

Location: Cognizant technology Solutions, DLF Cyber city, Hyderabad, India

Duration: 02/07/2016 to 06/18/2017

Project Summary:

Credit Suisse Group is a Swiss multinational financial services holding company, headquartered in Zurich that operates the Credit Suisse Bank and other financial services investments. The company is organized as a stock corporation with four divisions: Investment Banking, Private Banking, Asset Management, and a Shared Services Group that provides marketing and support to the other three divisions. ZPAS-Zurich Portfolio Accounting System is an intermediate portfolio management system which holds the upstream and downstream systems. It is a virtual accounting system for the main source multifonds and manages the ZPAS portfolios. Code changes are implemented based on the requirements specified by BA from client end. Assignment of the work & logging the effort will be handled using the Jira tool. Agile software development methodology is followed.

Roles & Responsibilities:

In ZPAS worked as 'Senior Oracle Database Developer' and responsible for database requirement gathering, Developing SQL queries, PL/SQL, ETL changes for ZPAS Application.

Developing, Designing Oracle Forms and Crystal Reports to meet the business demands of ZPAS application as per client standards.

Build SQL queries for backend testing and rollback plans as standard for fixes going into System and UAT phases of the application for monthly fix release to production.

Performing SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.

Build ad- hoc reports for clients upon short notice requests Developing and Unit Testing Informatica, PL/SQL, UNIX shell scripting changes as per business requirement and building test data for different test cases for QA & PE Teams.

Monitoring daily activities for production control to ensure timely and effective reporting, tracking, follow-up and communication of problems with the client.

Responsible for carrying out solution designing, obtaining efforts, managing suppliers/build through development, testing pre-release, implementation and post-release management.

Project 3:

Project Name: World Bank IT Support

Location: Cognizant technology Solutions, Chennai, India

Duration: 03/14/2014 to 02/06/2016

Project Summary:

The World Bank is like a cooperative, made up of 188 member countries. These member countries, or shareholders, are represented by a Board of Governors, who is the ultimate policymakers at the World Bank. Generally, the governors are member countries' ministers of finance or ministers of development. They meet once a year at the Annual Meetings of the Boards of Governors of the World Bank Group and the International Monetary Fund. World bank has a sub -division for Borrowings, Investment and Pension which gets accounting entries from various system.

Roles & Responsibilities:

In World Bank worked as 'Oracle Database Developer' and responsible for database requirement gathering for TAS Application.

Developing and Designing Forms and Reports to meet the business demands of World Bank application as per client standards.

Build SQL queries for backend testing and rollback plans as standard for fixes going into System and UAT phases of the application for monthly fix release to production.

Creating Views and Triggers to implement security for the users. Build ad-hoc reports for clients upon short notice requests.

Develop complex queries, Functions, Stored Procedures and Triggers using PL/SQL.

Monitoring daily activities for production control to ensure timely and effective reporting, tracking, follow-up and communication of problems with the client.

Responsible for carrying out solution designing, obtaining efforts, managing suppliers/build through development, testing pre-release, implementation and post-release management.

Project 4:

Project Name: CITI Bank – GILS

Location: Polaris Financial Technology, Navalur, Chennai-603103

Duration: 07/01//2013 to 03/13/2014

Project Summary:

Citi offers consumers and institutions a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, and wealth management. Citi's franchise in India includes businesses such as equity brokerage, equities distribution, private banking (Citi Private Bank) and alternate investments and private equity (CVCI). Citibank Personal Loan division have a system called Generalized Installment Lending System. It has multiple modules right from the Booking to Closure which has to be developed and maintained within the project. The project includes implementation of new features, handling major & minor enhancements, UAT support.

Roles & Responsibilities:

In Citi Bank worked as ‘Oracle Database developer’ and participated in business discussion for new Requirement Gathering.

Involved in the Enhancement of the Repayment Options, Development of Past Due Data (Delinquency Processing).

Analyzing issues in existing Lending System. Providing solutions for the client issues.

Develop complex queries, Functions, Stored Procedures and Triggers using PL/SQL.

Monitoring daily activities for production control to ensure timely and effective reporting, tracking, follow-up and communication of problems with the client.

Responsible for carrying out solution designing, obtaining efforts, managing suppliers/build through development, testing pre-release, implementation and post-release management.

Project 5:

Project Name: CITI Bank – CFIL

Location: Polaris Financial Technology, Navalur, Chennai-603103

Duration: 10/27//2010 to 06/30/2013

Project Summary:

Citi offers consumers and institutions a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, and wealth management. Citi's franchise in India includes businesses such as equity brokerage, equities distribution, private banking (Citi Private Bank) and alternate investments and private equity (CVCI). Citibank Personal Loan division have a system called Generalized Installment Lending System. It has multiple modules right from the Booking to Closure which has to be developed and maintained within the project. The project includes implementation of new features, handling major & minor enhancements, UAT support.

Roles & Responsibilities:

In Citi Bank worked as ‘Systems Trainee’ and participated in business discussion for new Requirement Gathering.

Analyzing the requirements and preparing the design logic.

Design and implement Pro*C, SQL, PL/SQL code changes and Unit testing.

Worked on cursors, stored procedures, functions and packages.

Developed PL/SQL Triggers on one table for automatic replication of data.

Code review for the application developed by peer developer. Handling support issues.

Application tuning. User interaction for issue clarification.

Education:

Bachelor of Technology – Information Technology, JNT University, Hyderabad, India (Aug 2006 – June 2010)

Certifications:

Oracle Certified Associate (11g) - 2018

Contact this candidate