We provide IT Staff Augmentation Services!

Oracle Sql Developer Resume Profile

4.00/5 (Submit Your Rating)

NJ

Career Summary

  • 7 years of diversified IT experience in requirement study, system analysis design, coding, documentation, implementation and unit testing on integrated Web and Client Server applications.
  • Sound knowledge of DHTML, XML and HTML.
  • 7 years of development experience using ASP.NET, JavaScript, JQuery, AJAX, C , CSS and web services.
  • Good experience in working with banking/financial service industry.
  • Proficient in full lifecycle of project management, from requirements gathering to analysis and implementation.
  • Worked extensively in .Net 1.0/2.0/3.5/4.0 frameworks.
  • Worked extensively with integrated development platform like Visual Studio 2008, Visual Studio 2010 and source control software's like Visual Source Safe, Team Foundation server TFS and Subversion SVN .
  • Experience in Business and Functional requirement gathering, developing Use Cases, and Capturing System Specifications, prepare User Manuals.
  • Created class diagrams, use case diagrams, sequence diagrams, flow diagrams for various systems using Visio.
  • Knowledge in all stages of the Software Development Life Cycle SDLC beginning from definition and initiation to deployment and support.
  • Knowledge of various browsers Firefox, Safari, Opera, Google Chrome and IE-Internet Explorer.
  • Ability to read, interpret, and question complex technical documentation
  • Constructed and executed SQL queries and procedures to interact with different databases like MS SQL Server, SQL Server 2000.
  • Worked on complex multimedia compression algorithms consisting 4D matrices using C and C , on Windows and Linux systems.
  • Worked in development of mobile applications using J2ME, Symbian C .
  • Created high performance, live streaming financial trading applications.
  • Ability to handle multiple tasks simultaneously. Strong communication and presentation skills verbal and written within team environment, business contacts, and managers.
  • Excellent interpersonal skills and a good team player. Ability to work independently in a fast-paced environment with tight deadlines and changing priorities

Technical Skills

  • Operating System
  • Windows 98, 2000/NT/XP, 2003 Server, 7
  • Database
  • SQL Server 2000, MS SQL
  • Internet Technologies
  • HTML, DHTML, JavaScript, AJAX and JQuery
  • Languages
  • C, C , Symbian C , ASP.NET 3.5, C , SQL, PL/SQL, HTML, MVC 4, ASP.NET 4.0

Professional Experience

Confidential

Programmer Analyst

Confidential is one of the oldest financial institutions in the United States. The Credit Card Services offers huge amount. Confidential is a leading global financial services firm with assets of 2.4 trillion. Confidential is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity. Credit Card Services is a major part of Confidential. Huge amount of planning and strategizing of the consumer market is carried out by the bank to dish out different schemes and offers for the Credit Cards they offer. Internally all these processes go through a series of applications, which are used by the Chase Marketing professionals to plan, strategize, build, and validate the best schemes for the Consumers.

Responsibilities:

  • There are around 15 to 20 application used by the JPM Chase Credit Card Services department to work on the offers and plan provided for their credit card, and each application need user authentication and maintain its own set of user profiles. So the target of my application is to create a Centralized Access Portal, where in a user can be provided access to all these applications through a single UI.
  • To avoid the complication of each of these 15 to 20 applications making a code change and pointing to this central database, I devised a design, which also keeps that application specific database in Sync with this centralized database.
  • Responsible for design, analysis and development of this 3 tiered application/website using .NET 4.0, C as the front end and Oracle as the back end.
  • Created custom generic UI controls to support the front-end functionalities e.g. multi select control.
  • Usage of Update Panels from Ajax and UI service to create a better user experience.
  • Designed the database using Oracle SQL Developer for the application and wrote several packages and views used for operations on the database and getting information from the database.
  • Designed and developed the business layer and the data layer for this application using C as the development language.
  • Created design and other supporting technical documents for this project.
  • Used Tortoise Subversion SVN as the source control/version control software for the code base.

Environment: Visual Studio 2008, Visual Studio 2010, Subversion SVN , C , JavaScript, JQuery, AJAX, web services, Oracle11G, SQL Developer, SQL Navigator, SharePoint

Confidential

Module Leader/Developer

  • Confidential is a financial institution, serving individual consumers, small and middle market businesses, corporations and Governments with a range of banking, investing, asset management and other financial and risk management products and services. Through its banking and various nonbanking subsidiaries throughout the United States and in international markets, the Company provides a range of banking and nonbanking financial services and products through five business segments: Consumer Business Banking CBB , Consumer Real Estate Services CRES , Global Banking, Global Markets and Global Wealth Investment Management GWIM , with the remaining operations recorded in all Other.
  • My responsibilities have been on the GWIM side of the business, where I am involved in the development of several modules in the Wealth Management website.

Responsibilities:

  • Responsible for designing and development of reusable UI library consisting of several UI controls, with complex serve side and client side behaviors using Visual Studio 2008, 2010 and .NET 3.5 and 4.0 C .
  • Development of client side libraries using object oriented JavaScript prototype model on client side to ensure the performance of the website is better.
  • Designed and implemented a flexible and optimized way of page construction using C and ASP.NET 4.0. The concept behind this is, each page is created by putting together small views and the page layout is defined by the placeholders in the master page.
  • Implementing and deploying UI services asmx and calling the service methods from client side using asynchronous API's, to enhance client experience, and perform complex logic on server side without holding the main UI thread.
  • Maintenance of integrated dev servers by creating an automated deployment process for different applications to ensure smooth integration on lower environments before deployment on higher environments.
  • Used tools like FXCop to review the code correctness and take action accordingly.
  • Load testing using tools like Load Runner and customized profiling tools built in house and optimization the code based on those results.
  • Integration of Vendor libraries like Live Person to support live chat facilities on the website, chart FX for implementing different analytical charts like Asset Allocation pie charts, Historical Total value charts.
  • SRS review, BRS review, creating design documents, analyzing issues, creating diagrams to describe the design, task estimation etc, were some of the crucial tasks done before the actual start of the development.
  • Creating several utility applications to ease out and automate the day-to-day activities, like analyzing production error logs, merging code etc.
  • Maintaining multiple code bases for multiple releases at the same time and handling the process of reviewing and merging the code and building MSI's for deployment.
  • Create and maintain WXS files for generating MSI's for deploying web application.
  • As my experience has been at a framework level for this application, I have worked on most of the modules present in this Wealth Management Application. Below is a random breakup of the different tasks performed during my tenure with the Bank.

Confidential

Trade Widgets:

  • Created a widget which displays the real time quotes for a request market symbol using JavaScript, C , ASP.NET 4.0 and CSS. The widget follows a MVC kind of architecture, where the UI representation of the widget is independent of the data layer, and the controller is responsible of communicating between the view and the data. In this way this widget was used on multiple platforms.
  • Created widget to display real time holdings information for an account for the user. This was done using object oriented JavaScript, C , ASP.NET and web service. The widgets data is updated as and when the user places an order for a market symbol, and the user can also track the status of that order through this widget.
  • Worked on order management system, where users can place equity, options, MF and Fixed Income orders.

Confidential

Navigation Rule Engine:

  • Created a XML based Rule Engine that manipulates the site navigation for different users and different accounts per user using ASP.NET, XML, C .
  • The XML defines the rules for the site navigation for a particular user, e.g. a user having a Loan account cannot hold equity or any type of market symbol in that account.
  • The rule engine was optimized to ensure that it doesn't hamper the performance of the website, as it is executed on a global level.

Confidential

Simplified Site:

  • Simplified site is a mobile version of the wealth management site. Making use of the view based architecture of constructing pages the same data layer was reused with just additional UI representation for the views.
  • A separate master page was created with the look and feel for mobile devices and also usage of meta tags to ensure that the page resizes based on screen size.
  • So the only development involved in creating this whole new website was creating new views as per the mobile browser support.

Page Construction and Other UI Widgets:

  • Created several other widgets such as Help bubbles, customized Modal popup, account selectors, menu controls, customized date controls and other data oriented widgets.
  • All these control were created using JavaScript prototype model and extending Ajax toolkit controls, web services.

Environment: Visual Studio 2008, Visual Studio 2010, TFS, C , JavaScript, JQuery, AJAX, web services, SAHI, Firebug, Load Runner, SharePoint, WPF

Confidential

Sr. Software Engineer

  • Confidential in creating and operating technology-centric, next-generation financial markets that are transparent, efficient and liquid, across multi asset classes, including equities, commodities, currencies and bonds, among others.
  • Major responsibilities included the development and enhancement of mobile and web based real-time trading platform for Equities, Commodities, and options, Mutual's Funds.

Responsibilities:

  • Confidential is an equity and options trading portal which allows a user to get real-time quotes for securities and options, place orders for equities, options and commodities, and save customized portfolios. It also provides different tools and analytical reports with respect to strategizing and optimizing trading investment funds.
  • Responsible for development and enhancements of various trading modules with business layer and the UI layer and also the database layer using Symbian C , SQL Server 2000 and J2ME.
  • Responsible for requirement gathering, design documentation, SRS review.
  • Unit testing of this mobile app using simulators and device testing.
  • Worked on performance optimization on the database layer by optimizing stored procedures, and also ensuring less amount of memory usage and no memory leaks considering the device memory in picture.
  • Net Net is an online equity and options trading website. Real time market quotes are streamed to the website using Java applet or Active X objects. It also provides different tools and analytical reports with respect to strategizing and optimizing trading investment funds.
  • Responsible for re-designing portal to support a 3-tier architecture using ASP.NET 3.5, JavaScript, C , JQuery and Ajax.
  • Development of Java applet for displaying market data in real time using core java.
  • UI design and development to make the application user friendly and compatible on various leading browsers using ASP.NET, JavaScript and C .
  • Code optimization to improve performance, stress testing using load testing tools.
  • Responsible for designing and developing relational DB, tables with optimized stored procedures to fetch data using SQL.
  • Developed a windows scheduler desktop application to fetch bulk data from live market servers using FTP on a timely basis and then process the data and store the ready data into a database which will act as raw data for financial charts.
  • Developed the FTP client for fetching the data from the servers
  • Optimized those Stored procedures for processing the data, and also added Indexes to ensure that data retrieval is optimized.
  • Created triggers to maintain logs for any modification done to the database tables.
  • Designed SQL database structure for storage of the processed data.
  • Worked on Legacy buy side web trading portal for equities and derivatives
  • Responsible for UI design and development of business logic
  • Code optimization to improve performance
  • AJAX implementation to improve user experience
  • Updated the branding of the Net Net Website with respect to themes and also added support of the new currency exchange MCXSX. This included addition of business login related to currency trading and also the related UI changes.
  • Development of changes required for currency exchange trading which includes UI development, JavaScript validations, business logic, stored procedures.

Environment: Visual Studio 2008, Visual Studio, Visual Source Safe, Firebug, SQL Server 2000, Eclipse, Symbian Simulators, J2ME Simulators, JavaScript, JQuery

Confidential

Sr. Software Engineer

  • Confidential is a organization that strives to create better audio and video streaming experience by applying complex algorithms on compressing the data. This enables the real time media information to be processed and stored at a much faster rate.
  • The major work around this was in development and testing of H264 Encoder and Decoder.

Responsibilities:

  • Confidential that provides high level of compression using an advanced compression algorithm. A video compressed using an H264 codec generates an output that is much smaller than any other compression techniques in market.
  • Worked on developing C applications on H.264 Intra prediction. Development work involved complex codes with 4- D Matrices, 4-D pointers which represents the frame data and complex mathematical calculations
  • Optimized the H.264 Encoder for Windows and Linux platform using Assembly code
  • Ported the H.264 Decoder to ARM Processor and optimized it.
  • Ported the H.264 Decoder to Pocket Pc using various Win32 API's.
  • Designed the GUI for the Video Player in Symbian C
  • Modified the Mpeg2 Encoder without B bidirectional Frames to support the B frames.
  • Created a Symbian media player which used H264 encode and decoder as the compression and decompression algorithm.
  • Unit testing using Symbian simulators and actual devices
  • Creation of design documents and UML diagrams to explain the applications of the encoder and decoder

Environment: Visual Studio 2008, Visual C , Visual Source Safe, Firebug, Red Hat Linux, Symbian Simulators, J2ME Simulators

We'd love your feedback!