SUMMARY

• Ambitious Senior Software Engineer with approx. 14 years of IT experience as Web/UI & Java Developer, Encryption Architect, Database administrator, Asst. Systems administrator.
• Dynamic, perseverant, determined, open minded and result - oriented with a realistic approach towards issues, enthusiastic in up skilling and self-driven in keeping up-to-date about latest technologies.
• Working on building User Interface application (Web) components using Angular 5.0 framework, ReactJS, HTML5, CSS3, java script and typescript
• Hands on experience in handling JSON and complex JSON manipulation using JavaScript, JQuery and Angular.
• Experience on using Angular APIs like @angular/http For making HTTP requests, @angular/common Common core things including form validation, @angular/router Routing for our entire app, data binding, event bindings, property binding, dependency injections etc.,
• Experience in developing applications with Java, spring boot, Spring MVC with Restful, SOAP Web services, PL/SQL, Unix Shell scripting
• Experience in developing and consuming Micro-services, Web services with different technologies like SOAP, Restful.
• Familiarity with OOP and implementation of software design patterns.
• Extensive experience in Database Administration, development, migration, Business Requirements Analysis, Capacity Planning, Database and Application design, testing, implementation and maintenance of databases using DB2 for z/OS, DB2 for LUW and Sybase in Logistics and Banking sectors.
• Experience in installing and configuring Sybase and DB2 on UNIX and Windows.
• Managing database security, design, develop, and implement automated data backup and restoration procedures.
• Extensively worked with DB2 Explain, Runstats, Reorg, and other utilities.
• Good skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, setting up Backup and recovery strategies, scheduling jobs, developing database procedures, functions and packages.
• Experience in DB maintenance using BMC, Toad, Data Studio
• Experience in query writing and performance tuning.
• Good Experience in Data Modeling and DB design using ER Studio Data Architect.
• Experience on administration of OS like IBM AIX, Unix, Windows Server, Linux.
• Knowledge of Encryption methods in distributed environment
• Experience in the areas of Application Development using Power Builder, Power shell etc.,
• Experience in managing portfolios as part of company’s internal responsibilities
• Worked as Database Administrator and encryption architect handling Encryption for applications built on Java with database as Oracle and DB2 UDB.
• Experience in working with designers, product managers & software engineers to come up with breakthrough product ideas.
• Proficiency with AGILE and Scrum process of development.
• Extensive use of Rally, Confluence and power point for tracking status
• Team player with excellent client facing and handling skills.
• Exceptional planning and implementation capabilities.
• Strong interpersonal and communication skills.

TECHNICAL SKILLS

Database Management Systems: DB2 on zOS V9, V10, DB2 UDB 9.7, 10.5, Sybase ASE 11.x, 12.x, 15.x, IMS, Oracle 11g

Frontend frameworks: Angular 5, React JS, Java script, TypeScript, HTML, CSS

Languages: Java (Spring Boot, Spring MVC, SOAP, RESTful), Power Builder, JCL, COBOL, Shell scripting, PowerShell

Development Tools: IntelliJ, Visual Studio Code, IBM Data Studio, Toad for DB2, SQL Advantage, SQL Developer, Eclipse, JBoss developer, Netbeans, SOAP UI, Postman, Abinitio IDE, MS PowerPoint, Excel Dashboards

Version Control: SVN, Git, Stash/Bit Bucket, Maven, Jenkins

Deployment & Logging: JBOSS, Apache Tomcat, WAS, XLR, Splunk

Team collaboration tools: Rally, JIRA, Confluence, Powerpoint

Encryption tools: Voltage API, Voltage Secure File

Change Management: Service-Now

Hardware: IBM P7025-6F1, P550 (Database servers), P51, IBM x3400 (Tivoli), HP Proliant ML 570 (Domain Controllers), HP Proliant DL580 (Lotus Notes), IBM 3090 (MainFrame)

Operating Systems: AIX 4.3/5.3/6.1, Windows Server 2000, 2003, 2012, Windows XP, Vista & Windows 7, Windows 8, z/OS, Linux RHEL

Networking: TCP/IP, OFC LAN (10/100/1000 MBPS), 2MBPS & 64KBPS WAN

EMS Solutions: Tivoli Configuration Manager, Tivoli Enterprise Console, NetView and WAN Insight

Messaging system: Lotus CCMail 8.3, Lotus Notes 6.5, 8.5, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Software Engineer

Technology: Angular, React, DB2 UDB, Java, Abinitio, ePaaS

Responsibilities:

• Currently working on building front end applications using custom react framework integrating web-services using iguazu.
• Developed Class Component and Functional components, created test cases for 100% coverage using jest and enzyme.
• Built User Interface application components using React, Angular 5.0 framework, HTML5, CSS3
• Developed Web content by building UI screens from scratch using One-App and integrating with One-Data functions
• Used GEM (One-CMS) for content management and integrated with iTags for journey tracking
• Used Observable pattern for saving and retrieving data by invoking REST services
• Created RESTful services using Spring and defined mappings to support MVC and Spring framework
• Worked with WEB API’s to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server
• Collaborated and coordinated with the UX team to ensure the designs are met with the user requirements.
• Writing components that hold model data and call back functions for the actions triggered from view.
• Writing controllers that are responsible for transferring control between components, routing and rendering views.
• Developed data insertion forms and validated them using JavaScript.
• Implemented various Validation Controls for form validation with JavaScript validation controls.
• Developed test scripts to automate process of testing in Protractor. Contributed to write e2e and unit tests with Protractor and Jasmine with Karma as tests runner.
• Used karma, jasmine, jest and enzyme for testing the code and its coverage for Angular and React
• Developed automated JUnit test cases for testing functionality and code coverage
• Deployed application packages through Jenkins in all the development environments
• Adhered to SAFe principles while participating in all train level SAFe ceremonies
• Managed the lifecycle of code development, from ideation to sprints to deployment.
• Prepared table design based on product requirement
• Developed new stored procedures or change them as per need of application
• Developed ETL graphs to extract data from table and write data to files
• Mad e changes to Java code to integrate the product being developed by the team
• Tested the code in all lower environments by writing test cases
• Fixed the code issues with troubleshooting via ePaaS console logs
• Created change requests following change management policies
• Released application code via XLR
• Provided support to resolve ongoing issues

Confidential

Encryption Architect, Database & Java Developer

Technology: DB2 UDB, Unix, Linux, Golden Gate, Power shell, Voltage, Java

Responsibilities:

• Setting up local DB2 database for extensive use of team
• Checking the consistency of the database using different db2 commands.
• Working with DDL and DML statements
• Develop new stored procedures or change them as per need of application
• Install Golden Gate OGG 12.x on Unix and Linux servers
• Setup extracts, pumps, replicates for replication
• Configure replicates for better performance
• Monitoring all GG process using alerts with cron jobs
• Centralized implementation of encryption as per Amex EDPP standards
• Deep dive discussions with application teams to understand the application architecture, flow and dependencies
• Analyze the java classes, tables, stored procedures, web services, etc., to check PII impact
• Engage EDPP team to get suitable encryption recommendations for every application
• Providing suitable encryption solution to application team and suggesting right encryption format viz., eFPE, FPE, IBSE, AES, File encryption etc.,
• Raise requests for encryption IDs, passwords and PRK groups
• Code changes to java classes, database interfaces to ensure encryption/decryption as per specific requirement
• Built encryption script using Power shell and deployed in all environments
• Setup HP encryption APIs and crypto SDK for data in transit
• Help the team develop DB tool by providing necessary DB details including tables and SP names
• Testing java classes, web services, stored procedures, Db tool, file encryption tool etc.,
• Document all encryption changes completed for the application as per compliance
• Provide encryption related troubleshooting and root cause analysis for application teams
• Help team design decryption tool to integrate with Golden Gate to decrypt data from source and update target database
• Test web services to check encryption/decryption using SOAP UI
• Extensive use of JBOSS, Netbeans, IBM Data Studio, Toad for DB2, Citrix, Eclipse for encryption related development and testing
• Deploy EARs, WARs in JBOSS & WAS environments
• Deploy EARs in ePaaS through XL Release
• Verify logs through JBOSS and Splunk to troubleshoot issues
• Provide KT and handover of the code to applications

Confidential

Encryption Architect / Database Administrator

Technology: DB2 UDB, Oracle, Linux, Voltage

Responsibilities:

• Deep dive discussions with application teams to understand the application architecture, flow and dependencies
• Thorough investigation on the PII data in the databases to know the data types, field lengths, whether specific PII field is being used in searched/sorts etc.,
• Providing suitable encryption solution to application team and suggesting right encryption format viz., eFPE, FPE, IBSE.
• Setting performance baseline w.r.t PII fields after encryption
• Verifying the db configuration and update parameters wherever required to suit encryption
• Helping team complete data at rest encryption using bulk loads
• Help teams setup HP encryption APIs and crypto SDK for data in transit

Confidential

Database Administrator

Technology: DB2 UDB, SQL Server, Linux, Windows Server

Responsibilities:

• Understanding the application architecture, flow and dependencies
• Verifying the database structures, schemas, tablespaces, tables etc
• Reverse Engineering the existing databases to generate physical model
• Verifying the dbm and db configuration and update parameters
• Taking snapshots for databases and monitoring locks
• Monitoring database health using Data Studio web console
• Scripting and scheduling cron jobs for backup and maintenance of DBs
• Gathering the requirement from app teams
• Design of new databases and maintaining database objects
• Manage different database objects like bufferpools, tablespaces, tables, indexes, views, constraints
• Manage the database backup, restore and refresh
• Worked with data movement utilities Export, Import and Load
• Strong exposure in DB2 utilities like db2look, db2move, Runstats, Reorgchk and Reorg
• Database monitoring using db2pd & db2top