Summary:

●Over ** years of experience in the Information Technology industry

●An Oracle Certified Professional (OCP)

●Over 2 decades of experience in application development using Oracle database

●Multiple industry experience – Finance, Hospitality, Education, Airline & Automobile

●Very comfortable playing multiple roles and multi-tasking between various projects

●Expertise in developing optimized solution against High Volume Database (HVD)

●Expertise in developing complex application using Cloud platform, Big Data, Hadoop, HBase, HDFS, Hive, Unix/Linux, Java, .NET, Oracle, SQL, PL/SQL and Shell Scripting

●Deployment using CI/CD pipeline

●Hands on experience extracting data from BigData - HBase, HDFS, Teradata using tools like Hue, DBeaver, Informatica, QueryMan for various financial processing and reporting

●Experience creating reports using Cognos, SSRS, Crystal Reports and Business Objects

●Excellent inter-personal, oral and written communication skills

●Possess Analytical, Critical Thinking and Problem Solving skills

●Experience as a team lead mentoring the team members, managing resources and delivering

Technical Summary:

Cloud Technology : Azure, GM Private Cloud, Kubernetis, Docker

OS : Linux, Ubuntu, Solaris, UNIX (HP, AIX, SCO), Windows

Database : HDFS, Greenplum, Oracle, MS-SQL Server and MS Access

Data Warehouse : Teradata, Informatica

Database Modeling : ERWin, Oracle Designer, Microsoft Visio

Modeling Language : UML

Web Server : iPlanet, IIS

Web App Server : Oracle iAS, Oracle Application Server (OAS), BEA WebLogic

Mobile Server : Oracle 8i/9i Lite

Framework /Arch &

Languages : Java, J2EE, MVC, Struts, .NET Framework, C#, VB.NET, C, SQL, PL/SQL,

Mod PL/SQL, T-SQL, MSQL, HTML, DHTML, XML

Web development : Java Beans, JSP, Servlets, Java Script, SOAP, XSLT, Macromedia Dream weaver

API interaction : Soap UI, cURL, Google REST Console, Firefox Rest Client

IDE : Visual Studio Code, Microsoft Visual Studio, Eclipse, NetBeans, JBuilder

Query Tools : SQL Navigator, TOAD, SQL Query Analyzer, QueryMan, Visual SQL Designer,

DB Visualizer, Oracle SQL*Plus

Reporting Tool : Cognos, Power BI, Crystal Reports, Oracle Reports,

SQL Server Reporting Services (SSRS), Business Objects, Jasper Reports

Rational Software : RequisitePro, ClearQuest, TestManager

Project Management : Enterprise Project Management (EPM), Microsoft Project

Source Code Mgmt. : Git, Team Foundation Server (TFS), Harvest, Anthill, Microsoft Visual SourceSafe,

WinCVS, ChangeMan DS

Change Control : ITSM, Peregrine/ServiceCenter

Forms Development : Oracle Developer, Oracle Forms

Vi Editor & Scripting : Putty, QVT Term, Shell Scripting

FTP : Telnet, Win SCP3, WS_FTP Pro

ETL : Datastage, Informatica, Ab Initio, SQL*Loader, DTS, SSIS, Export/Import

Job Scheduler : Tidal, Autosys, Maestro, SQL Server Agent

Document Mgmt. : SharePoint, Discovery

Microsoft Office : MS Outlook, MS Word, MS Excel, MS Power Point, MS Access

Technical Training : Safe Agile, Rational Software, Architecture Risk Analysis, .NET, BPM (Tibco)

Education : Bachelor’s Degree, Diploma in Computer Applications

Experience Highlights :

General Motors Jul 2014 – Current

Senior Software Engineer

General Motors is the largest automaker in the United States.

Responsibilities:

●Responsible for design, develop and manage multiple applications

●Subject Matter Expert (SME) & Development Lead

●Created application using Hadoop, HDFS, HIVE, Greenplum, Hue & PySpark in EDW environment

●Database modeling for various projects

●Management and modernization of legacy applications

●Involved in the migration of Oracle databases and implementing encryption of sensitive data.

●Created Autosys jobs for batch processing

●Co-ordinated with various teams to implement better business solutions

Environment: Linux, Unix, Windows, Hadoop, HBase, Hive, Hue, Greenplum, Oracle 11g/12c/19c, SQL, PL/SQL, SQL*Loader, Packages, Stored procedures, Functions, performance tuning, Shell Scripting, SQL Developer, DBeaver, IBM Infosphere Datastage, Autosys, Tidal, Cognos Reporting, Tableau Reporting, SharePoint, Team Foundation Server (TFS), Microsoft Office

American Airlines Nov 2013 – May 2014

Analyst – Technologies Lead

American Airlines after the merger with US Airways is the largest airline in the world with nearly 6700 daily flights to more than 330 destinations in over 50 countries. The company has about 90,000 employees.

Responsibilities:

●Responsible for design, develop, implement and support migration of legacy US Airways Ticket, Coupon, Flown Revenue data from Oracle database to Teradata.

●Lead a small team of developers in Enterprise Data Group.

●Analyzed the source and target data sources.

●Created design documents with mapping for migrating data from source and target.

●Created Informatica power center tools as ETL solution for data migration.

●Created Oracle routines to extract the source data from various large partitioned table.

●Created Shell scripts to parameterize and automate the Informatica workflow execution.

●Implemented and supported the data migration solution.

●Co-ordinated with various team members for requirement gathering and tailoring the optimal solution for migration of data related to merger.

Environment: Linux, Windows7, Oracle 11g R2, Informatica Power Center(Repository Manager, Designer, Workflow Manager, Workflow Monitor), Teradata, SQL Plus, PL/SQL, SQL*Loader, Packages, Stored procedures, Functions, performance tuning, Shell Scripting, TOAD, Teradata SQL Assistant, SharePoint, Team Foundation Server (TFS), Git, SVN, Microsoft Office

Client: Diamond Resorts International, Las Vegas, Nevada May 2013 – Sep 2013

Senior Oracle Consultant

Diamond Resorts International has a network of 300 vacation destinations in over 33 countries. They own, operate and manage vacation ownership and partner affiliation agreements through CLUB membership.

Responsibilities:

●Responsible for creating Restful web service using PL/SQL in Oracle 11g database for Affiliates to view their property reservations.

●Consumed OpenText (previously EasyLink) SOAP web service using PL/SQL to extract the opt out option.

●Created routines to insert XML response into CLOB.

●Created routines to update the consumer preference by processing the XML response in CLOB.

●Resolved code violations in existing code as per CAST standards.

●Created design specification and test plans as part of implementation process.

●Created reports using Jasper Reports.

Environment: Unix, Windows, Oracle 11g R2, Soap UI, REST Console, SQL Plus, PL/SQL, SQL*Loader, Packages, Stored procedures, Functions, Jasper Reports, TOAD, Code Analysis, CAST, Microsoft Office

Client: Maricopa Community College District Office, Tempe, Arizona Nov 2012 – May 2013

Senior Consultant

Maricopa Community Colleges district office serves as a central operation of 10 community colleges and two skill centers in the Maricopa County by providing IT solutions and various educational source and solutions that can be implemented across the board.

Responsibilities:

●Responsible for managing the interface between Student Information System (SIS) and Canvas (Learning Management System - LMS).

●Migration of enrollments from legacy LMS Blackboard to Canvas.

●Gathered student information for batch processing using Stored Procedure, Functions from Oracle database on a cloud server.

●Extraction of student enrollments, class information from Canvas (LMS) using Canvas API by submitting cURL http requests.

●Parsed JSON output file from cURL request of Students Enrollment and loaded in SQL Server database and pushed the data over to HR Oracle database.

●Utilized REST Console for Request and Response of Canvas API.

●Created scripts to compare database objects like tables, views, indexes, stored procedures and functions between databases for migration of SQL Server 2000 to SQL Server 2008 and Cognos 10.0 to 10.04.

●Scheduled batch processing using SQL Server Agent jobs and batch files.

●Code migration to test and production in SQL Server 2008 R2 and Oracle 10g/11g database.

Environment: SQL Server 2000/2008 R2, Oracle 10g/11g, Cognos 10.0/10.4, Business Objects, cURL, SQL Plus, PL/SQL, SQL*Loader, Packages, Stored procedures, functions, TOAD, REST Console, Microsoft Office

Client: Wells Fargo, Charlotte, North Carolina Jan 2011 – Oct 2012

Senior Oracle Developer

Client: Bank of America, Jacksonville, Florida Sep 2001 – Dec 2010

Systems Engineer/ Lead Developer

Client: Bandwidth 9, Atlanta, Georgia Feb 2001 – Aug 2001

DBA/Developer

Client: The Planning Council & Qatar Central Bank (QCB), Doha, Qatar July 1999 – Jan 2001

Senior Programmer Analyst/DBA

Client: University of Microfilms International, Ann Arbor, Michigan Oct 1998 – Jun 1999

Data Modeler/ Programmer Analyst

Precision Techserve Pvt. Ltd., Chennai, India Feb 1998 – Sep 1998

Programmer/Analyst

Client: Oman Trading Establishment, Muscat, Oman Jan 1997 – Jan 1998

Programmer Analyst

Bharat Software Systems, Chennai, India Aug 1994 – Dec 1996

Programmer

Contact this candidate