Summary
Overview
Work History
Education
Skills
Timeline
Generic

VENUGOPAL MANUBOLU

North Brunswick Township,New Jersey

Summary

Adept at orchestrating complex IT solutions, I significantly enhanced Sesame Workshop's Talent Payment and Report systems using Oracle PL/SQL and Cold Fusion. My analytical prowess and collaborative approach streamline operations and foster innovation. Expertise in Cold Fusion and Oracle, coupled with strong problem-solving skills, drives efficiency and supports strategic objectives.

Overview

29
29
years of professional experience

Work History

Senior programmer

Sesame Workshop
New York
06.2010 - Current
  • Applications worked on: Talent Payment system and Talent Report system
  • Talent Payment System: Gathered requirements from the users and designed better Talent payment system using oracle report builder
  • Talent Report System: Worked with producers and directors and gathered business requirements and successfully designed and developed new Talent report system for the producers and directors
  • Tuned Queries and improved performance for the existing search screens
  • Environment: Oracle Report builder, Oracle PL/SQL, Cold fusion 2023, cold fusion administrator, cold fusion report builder, JavaScript, html, xml, oracle 9i

Technical Lead

UBS
Weehawken, New Jersey
10.2007 - Current
  • Projects: Profits and Losses (P&L), Uniform, UniTrack, L&C Data Migration, Legal and Support Group
  • P&L Request system facilitates the collection management and transmission of statement data to UBS P&L vendors
  • This system provides the UBS Legal Division with an extensible online form delivery system
  • This system provides a customizable view for the tracking of above online forms
  • Migrated Legal and Compliance Data from Oracle to Sybase using pl/sql stored procedures, Informatica and Autosys
  • Responsible for requirements gathering based on the complex rules of Sox 404 Compliance and analysis of the same
  • Analysis of internal controls and developing data models to accommodate the controls
  • Involved in the complete cycle of the project
  • This includes analysis, design, development and implementation
  • Front-end UI is designed using Cold fusion MX 7, HTML, CSS, JavaScript and AJAX
  • Used UML modeling for designing the system
  • Modified stored procedures code as per changed requirements
  • Involved in gathering requirements from users and perform requirement analysis
  • Was responsible for writing Unit Test Plans
  • Maintaining the code repository using PVCS
  • ETL design, development, administration, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation
  • Developed stored procedures and complex packages using PL/SQL
  • Developed shell scripts to pull & process data from Mainframe system
  • Single point of contact for development and technical enhancements
  • Environment: Oracle 10G, PL/SQL, JavaScript, Cold fusion MX 7.1, html, Java, J2EE, Struts 1.1, EJB 2.0, JSP, UNIX shell scripts, Oracle SQL Loader, Informatica 7.3 and Informatica 8.6

Sr. Programmer

Sesame Workshop
New York
12.2004 - 10.2007
  • Developed organization's Financial Applications and all custom Web applications using Cold Fusion MX 7.1, cold fusion report builder, oracle 9i, Macromedia Dream weaver, JavaScript, HTML, and XML
  • Applications included extensive e-commerce functionality, content management system, and site administrative
  • Worked on backend, as well as other mission-critical applications
  • Upgraded previous CF 5 site to CFMX, including the creation and addition of custom CFCs and user-defined functions
  • Managed Cold Fusion Administrator, DNS, FTP, and other related Web server functions
  • Developed financial reports using cold fusion report builder
  • Extensively worked on oracle triggers, oracle functions, stored procedure and packages
  • Environment: Cold fusion mx 7.1, cold fusion administrator, cold fusion report builder, JavaScript, html, xml, oracle 9i

Business Analyst/ Sr. Programmer

CSC- The Corporation Service Company
New York
11.2000 - 12.2004
  • Orchestrate cross-functional team effort to translate customer/user needs and technology directions into product definitions
  • Act as a liaison between business users, IT development team participants and QA for web-based applications
  • Analyze and evaluate business requirements, identify and document use cases, write functional specifications
  • Designed and developed Oracle PL/SQL packages, procedures, Triggers
  • Generated Reports using SQR, CGI, Perl and Cold fusion and optimized queries for performance
  • Architect solutions, data modeling and database design including APIs using Oracle
  • Develop software design specifications, design system-to-system interfaces using XML
  • Project planning and managing activities to ensure a smooth implementation from development to rollout
  • Design electronic document management solutions to file the documents directly with Secretary of State
  • Document workflow and processes
  • Formatted (using Macromedia Homesite) the web documents to comply with the common look and feel standards
  • Add new content and edit and validate content for code accuracy with html using macromedia Home Site
  • Designed and developed Oracle PL/SQL packages, procedures, Triggers
  • Generated Reports using SQR, CGI, Perl and Cold fusion
  • Tuned queries for the performance
  • Handle requests for new functionality/ enhancements to existing applications and ongoing production support
  • Strong communication and organizational skills
  • Diffuse controversies and handle emergencies in all stages of project life cycle
  • Environment: Cold Fusion 4.5, Cold Fusion 5.0, Cold Fusion MX, Cold fusion MX 7.1 Homesite 5.0, Cold Fusion Server Admin, Flash Programming, Action Script, Perl, SQR, HTML, JavaScript, Oracle 8i and Fuse Box

System Analyst/Project Leader

Babygear.com
New York, New York
07.1999 - 07.2000
  • Company Overview: Online shopping for baby products
  • Designed and developed the reports using Cold Fusion 4.5, HTML and JavaScript
  • Customized able commerce software to fit into baby gear business needs
  • Migrated site from asp to cold fusion
  • Designed search screen to pull up products based on the brand id
  • Developed reports using crystal reports and brio SQR reports
  • Incorporated online credit card processing
  • Migrated data from ms-access to ms-sql server
  • Setup cold fusion server
  • Online shopping for baby products
  • Environment: Able commerce, for-site design, Cold Fusion 4.0 on Cold Fusion Studio 4.0, HTML, Java Script, SQL
  • Server 7.0

Liveprint.com
VA
06.1998 - 06.1999
  • Company Overview: Online Printing and Processing System
  • This is an online web interface that helps in the organization of messages for the electronic displays
  • The users can create, edit, delete, schedule, send messages, group displays, check the status of the queued messages etc through this interface
  • The admin section helps in organizing the users and company profiles
  • The status of the queued messages and usage of the displays can be graphically represented over a period through bar diagrams
  • The testing section in the interface helps the in-house engineers to test the status of the displays, and the combo boxes that are used for the transmission of the messages to the displays
  • Online Printing and Processing System
  • Role: Developed the modules that manage and organize the messages, schedules
  • Designed and developed the Scheduling, Folder Management, Testing, and Graphical modules
  • Involved in bug fixing for various modules of the interface
  • Environment: Cold Fusion 4.5 on Cold Fusion Studio 4.5, HTML, JavaScript and MySQL on Linux Server

GRE (General Re-Insurance)
Chicago, IL
09.1997 - 03.1998
  • SSI application is a Sales Tracking Application in Cold Fusion developed for the salespeople to submit the sales reports to their managers while traveling
  • The managers can view the reports of the salespeople over a period of time to keep track of the sales
  • Reports can be previewed and printed directly from the application
  • This application runs a Perl script on a routine basis to download the Freight Log file, which is an Excel Spreadsheet
  • The requests are made to this file to retrieve the appropriate records based on Sales Order or Purchase Order
  • Requests Handling Application is a Cold Fusion Application developed to implement paperless office in GRE
  • This application enables the employees to submit various requests like Travel Reservation Request, Report Request, Sales Analysis Request, Special Handling Request, Password Request etc through different forms from their desk
  • These requests then go to their manager for approval and once approved are forwarded to the corresponding department for processing
  • Role: Designed, developed and maintained the company's Intranet
  • In-charge for the implementation, bug fixing, testing and maintenance of Sales Tracking Application
  • Developed, implemented, and maintained the Freight Log and Requests Handling applications
  • Environment: Cold Fusion 4.0 on Cold Fusion Studio 4.0, ASP on Visual InterDev, HTML, JavaScript and DB2

Day Software Technologies Inc.
St. Louis, M. O
11.1996 - 08.1997
  • For a major nationwide health care network, participated in design and development of three Application packages using Visual Basic 6.0
  • Role: Designed and generated various reports using crystal reports
  • Created of manuals for all three applications (Both user and system manuals)
  • Environment: Novel Netware, Visual Basic 6.0 ms-access and crystal Reports

SPS Payment Systems
Chicago, IL
02.1996 - 10.1996
  • This project is for maintaining bill of material, periodical production plan, Daily production, Daily rejection, Shop floor inventory, Job work opening stock, Job work-indirect expenses, Machine maintenance
  • After making the production plan user can view material requirement for that period which gives information such as quality in stock, quantity required, shortage quantity and quantity to be ordered for each item planned
  • Role: Developed front end screens in power builder
  • Generated reports using oracle reports
  • Used brio SQR for internal reports
  • Environment: Perl, SQR, power builder, DB2, html

Education

MS - Computer Applications

BS - Mathematics

Skills

  • Windows NT 40
  • UNIX
  • Linux
  • Windows 2000 Professional
  • BEA Web Logic 71
  • Macromedia JRun 30
  • Cold Fusion 30
  • C
  • C
  • Java
  • JSP
  • Cold Fusion Markup Language
  • ASP
  • Perl
  • HTML
  • JavaScript
  • XML
  • Oracle 9i
  • MS SQL
  • Server 70
  • Power Builder
  • Cold Fusion 2023
  • Cold Fusion MX 61
  • Cold Fusion Studio 50
  • Cold Fusion 40
  • IBM Weblogic 71
  • People Soft
  • PC Anywhere
  • PVCS
  • Homesite 5
  • Visual Source Safe
  • Autosys
  • Informatica 73
  • Informatica 86

Timeline

Senior programmer

Sesame Workshop
06.2010 - Current

Technical Lead

UBS
10.2007 - Current

Sr. Programmer

Sesame Workshop
12.2004 - 10.2007

Business Analyst/ Sr. Programmer

CSC- The Corporation Service Company
11.2000 - 12.2004

System Analyst/Project Leader

Babygear.com
07.1999 - 07.2000

Liveprint.com
06.1998 - 06.1999

GRE (General Re-Insurance)
09.1997 - 03.1998

Day Software Technologies Inc.
11.1996 - 08.1997

SPS Payment Systems
02.1996 - 10.1996

MS - Computer Applications

BS - Mathematics

Similar Profiles

CREATE PROFILE
VENUGOPAL MANUBOLU