SUMMARY:

Creative and business - savvy information technology professional with 14 years of progressive experience (11 years work experience in USA) across a broad range of software product lines and diverse industry segments. Proven ability to combine vision, creativity, strong technical knowledge and business acumen with well-developed project management and leadership qualities to support successful, dynamic, highly energized, and focused teams that exceed expectations on go-to-market efforts, product launches, positioning companies and products for success. Clientele include Financial Services, Insurance, Telecommunication, Healthcare analytics, Document & Business process services and Electronics segments.

CORE COMPETENCIES INCLUDE:

• Software Development Life Cycle (SDLC): analysis, design, coding, testing, deployment, maintenance
• Leadership, Project Management, & Mentoring Technology Architecture & Integration
• Product launch, decommission and disaster recovery Client communication and vendor management
• Oracle PL/SQL; PostgreSQL, Unix Shell scripting, Amazon Cloud Services

TECHNICAL SKILLS:

Operating System: UNIX (AIX, Solaris, Linux, HP UX, HP Nonstop or Tandem), MS DOS, WINDOWS

Languages: C, C++, Pro*C, Java, HTML, DHTML, CGI-PERL, VBScript, JavaScript, ASP, JSP, Informix 4GL, XML

Relational Database: Oracle, Amazon Aurora, Maria DB. Microsoft SQL Server, HP Nonstop SQLMX, IBM Informix

Software Tools: Microsoft Office (Word, PowerPoint, Outlook, Excel, Access), Microsoft Visio Microsoft Visual Studio, Cisco WebEx, Cisco AnyConnect remote login, WinSCP File transfer, Citrix Metaframe, Oracle sqlplus, SQL navigator 5.5, PL/SQL Developer (V7.0),TOAD, SSH Secure Shell for Workstations 3.2, FFFTP Ver.1.96d, R4.4.1,Smart draw, PL/SQL Object Browser (V), DRDA Gateway (10.2), Oracle 10G BPEL SOA tool XEAN extranet access Client, FileZilla client 3.3.0.1, Autosys job scheduler, Tandem Netbatch job scheduler tool, PVCS version control, SAP BW object browser, SAP HANA 1.0, Oracle Forms 9i, Oracle Reports 9i, Eclipse, Oracle data integrator (ODI) Clearcase, Informatica Power center, OraExcel, IBM Lotus Notes, CA APM Wily Introscope, HP quality center, HP service manager, enterprise ServiceNow, Tableau AWS EC2 cloud web service tool, Beyond Compare, Git version Control; Control-M job Scheduler

Web services: Apache 2.2, Tomcat 8, J2EE, Amazon Cloud

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Senior PL/SQL developer

Responsibilities:

• performed successful research & designing on proof-of-concept (POC) to migrate medical claim data from Hadoop system to Oracle 12c database using Oracle PL/sql advance techniques like bulk collect, collection, merge, dynamic sql etc.; completed POC and testing on the same and made the product production ready.

Confidential, Dallas

Senior Software Engineer

Responsibilities:

• developed and maintained Confidential Billing Analytics application written by Oracle PL/SQL, Unix, Java Spring batch; job scheduling using Linux crontab; monitoring and analyzing Java / Oracle 12c application performance through Wily and AWS CloudWatch. performed research & designing on proof - of-concept (POC) to migrate application component from On- premise Oracle DB and application servers to Amazon AWS EC2, RDS cloud servers. Key highlights of POC consists of implementing migration strategy on Amazon EC2, Amazon s latest Aurora (Postgre SQL) database Amazon Maria DB RDS services. performed successful AWS aurora postgresql production migration of wireless and wireline billing analytics application and supported production issues for the same.

Confidential, Fort Worth

Senior Oracle PL/SQL Developer

Responsibilities:

• Associated to the project relating to Electronics Distribution Industry; dedicated on technology transformation from existing Mainframe - cobol application to Java-Oracle 12C Exadata application.
• Involved in full development life cycle to write and test business logic using Oracle PL/SQL, Unix, Java Spring, Jasper Report by analyzing cobol programs of existing application.
• Used Erwin tool to perform data modeling as part of data transportation from Mainframe to Oracle.
• Applied PL/SQL best practices to perform performance tuning of several PL/SQL applications. SQL Performance tuning is the key role to this project. worked with different business users to understand their requirements on advanced business functionality and implemented those requirements to new PL/SQL program.
• Used Java spring and Jasper report to generate Oracle reports which are exact match of existing Mainframe reports.

Confidential, Houston

Senior Oracle PL/SQL, Unix, J2EE Consultant/ Tech Lead

Responsibilities:

• Analyzed financial fraud risk management business and secured different financial institutions from potential real time and near real time fraud by launching, maintaining Discover Fraud risk management products as well as planning, consulting and performing disaster recovery for the same.
• Managed to lead product development, research & 24*7 production support of fraud related applications and their interfaces with other financial system by utilizing languages like Oracle 11G SQL, PL/SQL, UNIX shell script, Perl, along with Apache 2.2 /Tomcat 6 based web services and J2EE based application.
• Used Erwin tool to perform data modeling.
• Wrote business rules and logic for detecting, alerting and blocking real time account or transactional level financial fraud; proven ability to write and analyze Oracle PL/SQL, packages, procedures and other database objects & build application, daily maintenance and data warehouse jobs using Unix shell and perl scripting. developed technological solution of any complexity independently for the intended delivery competency and met business requirements by analyzing and applying Logical & physical data modeling, normalization & denormalization, star schema techniques analyzed & applied best PL/SQL coding standard for declaring variables, executable statements, control structures, composite data types, cursors, handling exceptions & ORA errors, creating packages, procedures, functions, database triggers, indexes, collections, ref cursors, Bulk Processing, oracle supplied packages, dbms job scheduler, dynamic SQL, SQL loader, hint, transaction SQL, autonomous transaction, performance tuning of business logic, database upgrade from 10g to 11g etc. set up password less secure SSH/SFTP authentication among Cross - functional application servers. wrote perl script which cryptographically hashed PAN (i.e. Debit or Credit card account number) using Digest::MD5 technology wrote unix korn and bash shell scripts to automate the tasks related to FTP, SFTP and file system administration tasks, data loading from flat file to database, data extract from database to send to data warehouse system as well as email alert system, daily maintenance or housekeeping nightly jobs run by Autosys job scheduler, application monitoring jobs etc. wrote application business logic & invoked database objects using shell scripts & maintained the uptime of all live application scripts. wrote script to perform data transfer & maintenance between Oracle OLTP database & Teradata data warehouse database system.
• Involved in complete infrastructure, middleware and GUI frameworks for all J2EE web client servers. Below are some highlights of J2EE web client support experience.
• J2EE Web Client Network VIP configuration and firewall testing.
• SSL security certificate update for web client
• Apache 2.2 server configuration - writing scripts for web application load balancing and vulnerability fix
• Tomcat 6 server configuration for load balanced J2EE application servers writing JDBC connection pool, Log4j and XML scripts
• Error analysis & fix for java code installation - Knowledge on Java threads, tomcat processes, spring framework, hibernate, Soap & external tieback configuration among multiple related applications working knowledge to set up SSO login for java application, working knowledge on socks proxy setting to work on java application in development, benchmark and production environment.
• Web application URL login validation after Java code installation application log file validation writing automated background unix job to monitor Java log and user activities
• Web application performance analysis ( CPU, JVM Heap, Threads etc ) using CA Wily performance monitoring tool
• Java code version upgrade, periodic tomcat recycle as per application maintenance
• Java heap dump analysis using IBM heap analyzer to analyze garbage collection, this is used for application performance tuning apache, tomcat, wily version upgrade for webclient application
• Webclient switchover and switchback from Primary to failover servers as per of disaster recovery
• Web application decommission for legacy system
• Performed product Quality assurance, Vulnerability assessments, vendor management; also adhered best practices of Payment Card Industry Data Security Standard (PCI DSS).
• Managed a large pool of resources by providing business and technical training, by scheduling working hours for shift, by assigning and evaluating their project work to meet SLA.
• Involved in data science by analyzing and preparing statistical monthly or yearly fraud report using Tableau & Python.

Confidential, Oregon

Consultant/Senior Software engineer/Tech Lead

Responsibilities:

• Managed a vast stock and demand repository and financial online system for selling range of color and black - and-white printers, multifunction systems, photo copiers, digital production printing presses, and related consulting services and supplies.
• Involved in data science by analyzing and preparing statistical report using Tableau.
• Supported AWS EC2 Cloud based application.
• Leaded onsite & offshore technical team to perform Application development & its 24*7 production support, preventive maintenance that maximize equipment uptime and employee productivity. Technologies include J2EE web services, Oracle 10G SQL, PL/SQL & UNIX shell script, XML gateways & Metrix CRM OUT application, Oracle Forms & Oracle Crystal Reports, Windows cron jobs, espresso jobs, BPEL SOA architecture. Below are highlights on webclient support experience
• Below are some highlights of J2EE web client support experience.
• SSL security certificate update for web client
• Apache 2.2 server configuration - writing scripts for web application load balancing and vulnerability fix
• Tomcat 6 server configuration for load balanced J2EE application servers
• J2EE application code installation into tomcat servers
• Web application performance analysis ( CPU, JVM Heap, Threads etc ) using CA Wily performance monitoring tool
• Java code version upgrade, periodic tomcat recycle as per application maintenance
• Java application log file validation & error Fix
• Provided consulting services for Confidential clients and end users for business requirements & analysis
• Built up Confidential Labor & Parts financial reports using oracle batch jobs which depict all historical & current financial scenario of the organization.
• Performed data modeling using ERWIN tool, Data Mapping, data profiling/ Scrubbing, mechanical data loading & reporting using ETL tool Informatica power center 8 & OraExcel, Reverse engineering, Data Pumping. Database administration & Performance tuning.

Confidential, Delaware

Software developer

Responsibilities:

• Analyzed, designed and implemented various interfaces related to Supply Chain Management requirements of product lines like Audio Video (AV), Personal Computer (PC) & Storage Device (SD) of Toshiba electronics unit.
• Whole solution was supported on 24X7 basis.
• The major activities in the project were classified broadly into Level 2 and Level3.
• Level2 involved handling automated batch Job related issues and investigations.
• Level3 involved PL/SQL and Java development, complex JAVA Web client issues investigation/ resolution

Confidential, Hartford

Software developer

Responsibilities:

• Devised an end - to-end testing strategy for a Hartford s direct billing system and analyzed best practices of Hartford s direct billing system, agency Billing, Risk Management system, Reinsurance, policy audit and Payroll Alliance system involved in application Coding, Testing and maintenance of components using Pro*C & PL/SQL

Confidential, Chicago

Software developer

Responsibilities:

• Devised an end-to-end testing strategy for MEID Field Conversion and coding for the same using JavaScript, HTML, Unix Shell script, Perl, Oracle PL/SQL.