Post Job Free

Resume

Sign in

Lead Pl SQl dEVELOPER

Location:
Norristown, PA
Salary:
$75/hr
Posted:
September 12, 2017

Contact this candidate

Resume:

Karthik Rao

ac19u7@r.postjobfree.com

732-***-**** * ***

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 - and always meet the cut off time.

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

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.

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

Substantial knowledge in query tuning, identifying the performance bottlenecks and fixing them.

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.

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

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

Technical Skills:

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

EXPERIENCE:

SEI Investments, Oaks, PA May 2013 – Current

Developer and Technical Lead

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.

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.

Participate in a forum of technical leads to identify best practices, common problems and discuss about them.

Deutsche Bank AG: DBRex 2.0 Aug 2012 – Mar 2013

PL/SQL Developer

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

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.

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

Design review and Coding review of the deliverable.

Tata Consultancy Services

Client: Deutsche Bank AG: DBValuations 2.0 and DBCamm Bangalore, India

Application Support Engineer (Level 3) and PL/SQL Developer Jan 2010 – Aug 2012

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 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.

Implement change requests using PL/SQL and .NET.

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

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

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

Design and code review of the deliverable.

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

Tata Consultancy Services

Client: Deutsche Bank AG: eCAS 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 Javascripts and JSP.

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

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

Design review and Coding review of the deliverable.



Contact this candidate