Project Oracle

Vinaya Kumar Golla

Address: Apt *, ****, Jefferson Avenue, Cincinnati, Ohio-45220

Email: ***********@*****.*** Phone: 513-***-****(Office), 513-***-**** (mobile)

Educational Qualifications

University of Cincinnati, Cincinnati, Ohio GPA 3.6/4.0

Masters in Business Administration, Information Systems & Business Analytics

Graduate Certification in Operations Excellence

Nagarjuna University, AP, India

Bachelor of Technology, Electrical and Electronics

MBA Course WorkMicrosoft SharePoint 2010 Advanced Analytics with Big data, Hadoop, AWS

Work Experience

Business Intelligence Analyst (IT Co-Op) - Business Intelligence and Predictive Analytics Team

Great American Insurance Corporation, USA Current

Tools/technologies: Cognos, Power play, Transformer, PL/SQL, ASP.netWorked with Claims and Underwriting business users to gather, document and analyze business requirements for the development of new Cognos reportsFacilitated collection of functional requirements from system users and preparation of business requirement documents for the migration of Cognos 8.2 to Cognos 10Developed standard reports, charts, drill -through reports, master detail reports and bursting reports using Report Studio Created, maintained and optimized new and existing Cognos reports, business insight dashboardsCreated Transformer Models, Power-Cubes and Drill through and detail reports, catalogs, folders filters, prompts, calculated columns and conditions for multi dimensional analysis.Updated the Framework Model when new metadata is imported, Created and published Packages using Framework ManagerWorked with framework manager to modify the existing business models for new business and system changesCreated complex reports that involve query prompts, layout calculations, conditions, and filtersScheduled and distributed reports through schedule management in Cognos Connection Portal.

Technology Consultant (Graduate Assistant)

University of Cincinnati Information Technology August 2011-June 2012

Tools/technologies: Java, ASP.Net, PL/SQL, XML, HTML, JavaScript, IBM Big InsightsDeveloped and maintained several UC web applications like UC onestop, UC commencement, UCflex, UC veterans, UC Getit, etc.Developed the additional modules in the existing web applications using ASP.Net, JavaScript, Ajax, CSS and HTML for developing frontend UI.Developed Client applications to consume the Web services using XML and JSPDesigned advanced dash boards, scorecards and KPI’s using Active reports, Cognos Set up a Hadoop cluster on AWS using RightscaleWorked with Pig, Hive and JAQL to query the data

Oracle Applications Techno Functional Consultant

Cognizant Technology Solutions, India August 2009-August 2011

Tools/technologies: Oracle Applications ( E-business suite), Oracle Forms, Oracle Reports, PL/SQL, Pro CEvaluated design, quality, stability and maintainability of legacy systems’ custom code and fill gaps between standard Oracle Applications functionality and business requirements; recommended and implemented solutions as neededInvolved in the design, development and implementation of the Enterprise Pipeline forecasting tool and M-Vision, a data ware house project using Oracle Forms and ReportsIntegrated the existing Custom Enterprise Billing System with Oracle EBSAuthored SQL and PL/SQL scripts to analyze underlying data for inconsistencies and integrity issuesPerformed rigorous analysis to fix data issues, created a plan to resolve the bug, and then test and implement the solution; handled the issues using Oracle forms/reports, PL/SQL,Pro CInvolved in requirements gathering, estimation, design, development and testing of the Custom forms for Order Management, General ledger and Accounts Payables modulesDevelopment included: custom components to interface Service module to Order Entry (OE/OM), Inventory (INV), Accounts Receivables (AR), and Purchasing (PO); data conversion from a legacy system (customers and existing service contracts); custom imports and exports of vendor data; custom pricing module; expanded use of the Accounts Receivables (AR) module to store end user informationWorked with senior business analysts to understand high level business requirements and transform them into system-specific functional requirements Acted as an off shore lead for a team of 3 members and created detailed project plans, work assignments, target dates.

IT Analyst

Idzyne Pvt ltd, India June 2008-Aug 2009Interfaced with business users to prepare and update Business Process Requirements and Software System Requirements for the central admin application of the client Created the data driven Central Admin Web application with rich UI using C#, ASP, Ajax, JavaScript and Oracle as back endAuthored SQL procedures, triggers, cursors and packages Prioritized outstanding defects and system problems and ensured the issues are fixed within deadlinesPerformed GAP analysis of business rules, business and system process flows, user administration, and requirements. Designed and developed Use Cases, Activity Diagrams using UML for the admin application of the client Created project schedules, project resource and cost estimation using MS project

Intern and Project

Accel Frontline Limited, India Gathered and documented business requirements, functional design specifications for the HR payroll portal development Performed GAP analysis on existing system and evaluated benefits of migration of Foxpro to OracleValidated technical designs created by IT developers against functional specifications.Wrote SQL queries in Oracle, MS Access for data related issues in the production environmentDeveloped the HR payroll portal modules (employee self details, tax details and flex benefit) using JSP and OracleDeveloped SQL reports and Visual Fox Pro based forms for the payroll department

Technical SkillsProgramming Languages: C, C++, Java, Dot Net Packages: MS Office (Word, Excel, Power Point, Access) ERP: Oracle E-Business Suite (EBS) / Applications:11i- AP,GL,OM and Finance Business Intelligence: Cognos 8.2,8.4, 10 Analytics tools: SAS, Crystal Ball, Risk SolverProject Management: MS ProjectDatabases: Oracle 9i (PL/SQL and Advanced SQL), SQL server 2005Web content and Document Management: SharePoint 2010UI design: HTML, CSS, Jscript, Dreamweaver, Ajax, Flash 8 Other : MS InfoPath, Microsoft and Oracle Workflow Builder, SQL*Plus, SQL*Loader, Pro*C,ToadData Analytics: IBM Big Insights and Hadoop, Pig, Hive and JAQL

Other Certifications Graduate Certification in Operations Excellence from university of CincinnatiPost Graduate Diploma in Information Technology(PGDIT) Brain Bench Certification on Oracle and Dotnet technologies

Contact this candidate