Scroll To View More
Venkateswararao Bollu, SQL Developer in Farmington Hills, MI, United States
Venkateswararao Bollu

SQL Developer in Farmington Hills, MI, United States

Member since December 19, 2016
Venkateswararao is an Oracle Certified associate with 13+ years of experience in large-scale environments. He has extensive expertise in PL/SQL, SQL, tuning, and code optimization. He has worked on projects with ETL processing with external tables, implemented parallel execution in Oracle to reduce ETL duration, and led a team of PL/SQL and Cognos resources as well as several projects for telecom, retail, and pharmaceutical industries.
Venkateswararao is now available for hire

Experience

  • SQL, 13 years
  • Oracle PL/SQL, 13 years
  • SQL Performance, 10 years
  • SAP Business Objects Data Service (BODS), 2 years
  • T-SQL, 1 year
  • Microsoft SQL Server, 1 year
  • IBM Cognos, 1 year
Farmington Hills, MI, United States

Availability

Part-time

Preferred Environment

Windows

The most amazing...

...thing I've done is parallel execution of procedures in Oracle, which included aggregation of multiple row values into a single row.

Employment

  • Senior Associate

    2011 - PRESENT
    Cognizant Technology Solutions
    • Worked with USA based clients Novartis, Avon, and Baxter.
    • Gathered and analyzed the requirements, including impact analysis.
    • Created and modified sub-programs.
    • Provided unit testing.
    • Designed ETL processes using SAP BO Data Services.
    • Developed new mappings, including data flows and workflows for the ETL process.
    • Designed new objects like tables and views.
    • Identified the existing manual processes to automate the clearing of performance bottlenecks and provide estimates to the customer.
    • Improved the ETL process by reducing the execution time to 30%.
    • Developed a couple of Cognos reports.
    • Prepared weekly status reports and presentations to the customer and stakeholders in weekly calls.
    Technologies: Oracle PL/SQL, SAP BODS, Cognos
  • Senior Consultant

    2010 - 2011
    Sierra Atlantic – A Hitachi Consulting Company
    • Communicated with clients to gather requirements.
    • Designed and created new objects such as tables and views.
    • Wrote and modified functions.
    • Provided unit and integration testing with the middleware team.
    Technologies: PL/SQL, PostgreSQL
  • System Analyst

    2009 - 2010
    20th Century Fox (via PB Systems, Inc.)
    • Liaised with client representatives to gather requirements.
    • Enhanced the existing code for Tuscany and fixed bugs.
    • Updated the existing code for Prophet for better performance.
    • Reduced critical report execution from ninety minutes to thirty minutes.
    • Reduced ETL processes by thirty minutes from four hours to three hours.
    • Performing unit testing and integration testing.
    Technologies: PL/SQL
  • System Analyst

    2007 - 2009
    Cisco Systems USA (via Satyam Computer Services)
    • Mentored five team members on technical aspects.
    • Built the code and modified the existing packages per FSD and TD.
    • Reviewed code.
    • Prepared unit test cases and provided unit testing.
    • Contributed to integration testing and UAT.
    Technologies: PL/SQL
  • Senior Software Engineer

    2005 - 2007
    Lifetree Convergence
    • Developed for a variety of clients including MTC Namibia, Emtel Mauritius, MTNL India, MTN Zambia, Data Stream Technologies Brunei, and TELMA Madagascar.
    • Developed procedures for modules Registration, POS, and Dealer Management.
    • Customized procedures for modules Customer Care and Change of Services.
    • Provided unit testing and customized procedures for the modules.
    • Prepared low-level design documents as part of the CMM level transformation of the company.
    Technologies: PL/SQL
  • Software Engineer

    2003 - 2005
    Metal Tubes Manufacturing Company (via Global Soft Technologies)
    • Built and customized forms and reports.
    • Developed stored packages, procedures, functions, and database triggers.
    • Provided unit testing for the programs we developed.
    • Helped prepare technical design documents and unit test plans.
    • Helped prepare user's manuals.
    Technologies: PL/SQL, Forms 6i, Reports 6i

Experience

  • Automation of Client's Internal Tool (Development)

    My customer had an internal tool developed some years back in an outdated Java framework. As the lead, it was very hard for me to get the resources to fix it. The client was losing confidence in management and panicked even though the tool had been stable without a single issue for over six years.

    I decided to view the whole thing as a challenge. I learned the coding standards and proposed a change to PL/SQL, completing the entire task in just a month with some help from junior team members.

  • ETL Code Performance Issues (Development)

    A pair of projects I led to improve a client's ETL process. They had to wait for over a day to see the latest data and were facing temp space issues at the database level. I optimized the temp storage issue by breaking the complex SQL queries into smaller and more feasible ones and by reducing unnecessary inserts into staging tables. The speed issue was fixed---or at least sped up by over 75%---with a parallel execution of a procedure in Oracle.

  • Excel Price Function in Oracle (Development)

    A little practice project that I developed early on in my freelance career, reproducing an Excel function for price calculation in an Oracle snippet.

Skills

  • Languages

    SQL, T-SQL
  • Storage

    Oracle PL/SQL, SQL Performance, Microsoft SQL Server
  • Other

    SAP Business Objects Data Service (BODS)
  • Tools

    IBM Cognos

Education

  • Bachelor's degree in Computer Science Engineering
    1998 - 2002
    JNT University - Hyderabad
I really like this profile
Share it with others