PANDURANG K. RAMADE

Oracle Certified Professional Developer

ac8pv1@r.postjobfree.com

Cell: 713-***-****

I have 18+ years of experience in every aspect of Software Development Life Cycle (SDLC) Actively participated in resolving complex project issues concerning multi-modular interfaces and integration. Worked in areas of business analysis, database analysis, design, development and implementation of business applications.

Hands-on leader skilled in balancing user requirements, corporate objectives and technology capabilities. Innovative thinker adept at leveraging technology to improve operations and productivity of an organization Important Aspects in Work Experience

Technical skills

» Solid management experience in the electricity utility industry. Hands-On Leader skilled in balancing user requirements, corporate objectives and technology capabilities. Innovative thinker adept at leveraging technology to improve operations and productivity.

» Program Management with an emphasis on delivering complex technical solutions and managing development teams

» Solution architecture, integration design, and technical leadership

» Designing and developing business intelligence and complex applications in Microsoft SQL Server, Oracle, database environments and Sales Force

» Data Scientist, Data architecture and database design and administration experience includes designing and building highly scalable, high-availability environments, database server clustering, database site replication, infrastructure planning and design, physical implementation and performance tuning, Experience with BI Presentations Technology Solutions

» Salesforce APEX/ Salesforce Administrator

» Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking, testing and migrating complex data sets in Oracle Database

Technical Skills

Operating System : HPUX 10.11, IBM AIX, VAX, WINDOS Languages : Oracle PL/SQL, SQL*PLUS, Microsoft. NET (ASP.Net,C#.Net and VB.NET, Tsql, SQL WEB Technologies: JavaScript, XML, HTML, Salesforce APEX

GUI Programming : Developer 2000 Forms 3.0/4.5/6i,9i Reports 2.5/3.0/6i Databases : Oracle 10/11G/12C, Oracle Data Warehouse, Oracle Apps, MS SQL Server Web Server : IIS Web Server, Apache, Tomcat

Tools : SQL Navigator, Toad, MS Excel, MS Word, MS PowerPoint, MS project BI Tools :Tableau Desktop 8, SSIS/SSRS, SAS, Cognos Analytics, Crystal Report, PowerBI Desktop

ETL Tools : Informatica, SSIS, Data Loader (Sales Force) Training : Oracle Financial 11i (Training included General Ledger, Accounts Receivable, Accounts Payable and Purchasing)

: Agile Foundation workshop - (Scrum Master, Agile Principals, Tasking Meetings, Retrospectives, Relative Estimation, Project Management, Story-Based Development, Iteration/Sprint Planning Meetings, Conflict Resolution, Kanban)

: DevOps workshop

: ITIL workshop

: MongoDb NoSQL,Python

Certification : Scrum Alliance Certified CSM, Oracle Certified Professional Developer EDUCATION:

Bachelor of Economics, University of Mumbai India

Advanced Diploma in Computer Science

EXPERIENCE:

IT Lead / Developer

Constellation Energy (Exelon Company) Houston

Tx from Jan 2007 to Present

Manage System:

C&I/MM Credit and Collection

and Billing System

Primo/Primera (Pricing System)

VPay – Vendor Commission

StartexPower(ISTA) Third party

vendor supported application

on AWS

Business Connect (C&I Credit)

– SalesForce platform

Transformation Projects:

Managed team that designed, developed and implemented strategy for converting an SQL Server based (Billing/CRM) system for industrial and commercial billing into Oracle Utilities Billing Expert application within 7 months thereby avoiding substantial penalty. Coordinated with the consultant integration team to develop database revisions, develop rate structures necessary to bill and do Collections activity on all of customers using Oracle Utilities Rules language, SQL, Pl/SQL redesign/convert all existing interfaces and Credit & Collection System.

Responsibilities

● Created PL/SQL stored procedures, triggers and

packages and created scripts for purging of data.

● Created cursor, collections and database triggers for maintaining complex integrity constraints and

implement the complex business rules.

● Developed sql scripts for creating database objects such as tables, views and sequences.

● Created SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.

● Worked in Agile environment and participated in

day to day processes like scrums and sprints using Rally.

● Worked with dev-ops team for flyway migration in different Dev and stage environments and solve

complex problem during migration.

● Hands on experience in writing, maintaining, testing and debugging code in applicable programming

languages.

● Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.

● Participated and interacted with different teams from off shore and on shore from different countries for requirement gathering and solve complex

problems.

● Develop multiple of dynamic dashboards, grids,

graphs, scorecards, and statistical reporting utilizing Business Intelligence Tools, Proficient in Business Intelligence architecture, dashboard using

Tableau/PowerBI report

Environment: Oracle 11g, Data warehouse, .NET and Sun Solarix, SQL*PLUS, PL/SQL, Tableau Desktop 8, PowerBI Sr. Analyst/Developer

Stage Store Inc from Mar 2006 to Dec 2006

Retek System

Responsible for:

Tasks included analysis and designing new oracle

database for integrating new hierarchy. Developing interface for downloading data from other system,

Designing and developing module enhancements and

maintenance support.

Environment: Oracle 8, SQL*PLUS, PL/SQL

involved in back-end designing and written extensive backend code on the Oracle server-side using PL/SQL, including packaged procedures, functions, database triggers, and SQL*PLUS. Oracle Developer 2000

Forms/Reports

Sr. Analyst/Developer

FDC – Telecheck Inc from Oct 2001 to Feb 2006

Collection System

Responsible for:

Tasks included analysis and designing new oracle

database for integrating collection module with other subsystems like sub02, sub03, sub17, developing

interface for downloading data from other system,

Designing and developing module.

Environment: Oracle 11g, Data warehouse, .NET and Sun Solarix, SQL*PLUS, PL/SQL

involved in back-end designing and written extensive backend code on the Oracle server-side using PL/SQL, including packaged procedures, functions, database triggers, and SQL*PLUS. Expertise, Involved in Oracle Database Tuning using tools like TK_PROF and SQL

TRACE with Explain Plan, Shell script

Analyst/Developer/Consultant/DBA

QED Solutions Inc from Aug 1998 to Sep 2001

Clients for QED Solution:

IPMS 2000 at Brown & Root,

Houston

WISE at Woodward-Governor,

Denver

SEPCo Year Renew 2000 at Shell

Continental Services, Houston

Responsible for:

Developed an application containing over 300 reports and 400 forms on Oracle 8.x, Developer 2000, and Windows NT, Designer2000. This subsystem registers, records, and determines progress for the supplier and engineering documents, such as drawing and specification logs and general project

My responsibilities included integrating this module with other subsystems, developing interface for downloading data from other system, Designing and developing module enhancements and maintenance support.

Environment: Oracle 7/8, Sun Solarix, SQL*PLUS,

PL/SQL

involved in back-end designing and written extensive backend code on the Oracle server-side using PL/SQL, including packaged procedures, functions, database triggers, and SQL*PLUS. Expertise, Involved in Oracle Database Tuning, Shell script, Oracle Developer 2000 Forms/Reports

Analyst/Developer for client

Chenab Pvt. Ltd India/USA From Feb 1996 to Jul 1998 March 98’ to July’ 98

ORION at Millipore Corporation,

Boston USA

Capital Market Listing System at

National Stock Exchange, India

Responsible for:

Configured software and converted data from an IBM system into Forms 4.5 with an Oracle back-end for a large manufacturing corporation. This involved converting data from the current IBM system, and customization of reports and functions to meet Nihon Millipore business practices. I Designed and built customized reports using Reports 2.5, Created Database packaged procedures, functions,

Triggers for complex business transactions and conducted user training. Successful implementation of this system resulted directly in faster reporting turn around time. Environment: Oracle 7/8, SQL*PLUS, PL/SQL

involved in back-end designing and written extensive backend code on the Oracle server-side using PL/SQL, including packaged procedures, functions, database triggers, and SQL*PLUS. Expertise, Involved in Oracle Database Tuning, Oracle Developer 2000 Forms/Reports Developer

Syspro System India from Feb 1995 to Jan 1996

Contact this candidate