PROFESSIONAL SUMMARY:

• Experience in Software Development Life Cycle (SDLC) process including user requirements analysis, design, development, implementation, testing, maintenance and system performance tuning
• Broad skill sets in both systems and application area (UNIX, Linux, Windows, Java, J2EE C, Pro*C, C++, VB, ASP.net,Ruby, Oracle PL/SQL, Posgres, MySQL)
• Extensive experience in relational databases, SQL, PL/SQL, Procedures, Functions, Triggers, Views, etc.
• Strong programming skills in shell scripting including KORN shell, C shell, Bash, Perl, Python, groovy
• Developed Client/Server, web based n - tier and distributed database applications using Struts framework, Java, J2EE, Servlets, JSPs, JDBC, JNDI, HTML/DHTML, XML, .Net, SQL and PL/SQL
• Experienced in Object-Oriented Analysis and Design, UML & J2EE (EJB, web service, etc.), DAO, Service Locator, Session Bean
• Administered application Servers, web servers and Database servers including Weblogic, Websphere, Oracle AS, Postgres, MySQL, Windows SQL servers, etc.
• Experienced with ESP on Mainframe for job scheduling ( to trigger jobs on UNIX).
• Experienced with ETL, OLAP and data warehouse like technology for data analysis and processing for a large supply chain corporation
• Used SQL developer and Toad to access Oracle and develop stored procedures, triggers, views and functions and Enterprise Manager to access SQL server DB .
• Strong analytical, troubleshooting, and problem solving skills on tickets when working in a technical support role
• Team Player and capable of working independently.

WORK EXPERIENCE:

Confidential

Responsibilities:

• Jira/Confluence/Teamcity/Fisheye(Crucible)/Bitbucket/Polarion application admin and software engineer, managing user accounts/permissions, projects, workflows, spaces, code repositories, build jobs(ant/maven/gradle), test cases/test runs and wiki doc for dev and QA teams, handling build job monitoring and notification automation, build job setup, groovy scripting for Jira workflow and monitoring automation using shell script and REST api. Bitbucket pre hook implementation in Groovy to ensure commit message in standard format, troubleshooting user-reported issues with all the applications on a daily basis.
• Unix/Linux system admin and software engineer, managing GIT(version control), Crowd(Application account/access management), Bamboo(application build), CFEngine(configuration management), etc. Coding for AWS EC2, R53, S3, dns, vm security group, load balancer, etc.
• Creating automation scripts in Bash, perl, Python, Java, sql for dump DB/load DB/list DB/ create DB/drop DB/create user/ drop user .
• Working on application and database backup and restore.
• Creating template for application build. Installing software and deploying for new releases of in-house developed and vendor developed applications.
• Used MySQL/Oracle/Postgres/Mongo DB.
• Created vm, accounts to onboard new clients and users.
• Resolving user tickets regarding access and environment setup.
• Worked closely with DBA team, infrastructure Unix, Windows and networking teams through complex projects such as application server migrations, NAS volume migration, server decommissioning, DB migration, massive data migration, software upgrades and web application deployments.
• Helped dev group with Cyberark (highly secure server/data access) project, data migration and cleansing projects using different technology ( SVN, Java/Tomcat, Python programming on MAC and Windows machines, AWS, Azure, html, Ruby on Rails, Unix scripting,.net, oracle, SQL server, Postgres, MySQL, cron, vmware, maven, hadoop,…).

Tools: used Jenkins(for automated build and deploy), Eclipse, Service Manager(ticketing system), Jira( for issue tracking), New Relic/IPsoft/Zabbix( for monitoring), TOAD(for oracle access), PGAdmin III(for Postgres access), SQL server Management Studio(for SQL server access), Fiddler and Firebug, etc.

Confidential

Responsibilities:

• Used application monitoring tools such as CA Wily and Keynote and scheduling tool Control-M.
• Monitored data intensive Unix batch job status(for loaders, reports, mappers, etc.) and resolved job/data issues.
• Understood OLTP app data and created complex queries to extract app data for internal and external businesses.
• Tuned Oracle queries for better performance.
• Investigated with Dev on prod issues, found root causes and suggested solution(code fix, query rewrite) or workaround.
• Coded shell scripts for automatic data file and log file processing based on user requests and sent results to them for issue analysis.
• Troubleshot migration related data issues.
• Supported BusinessObjects(BOBJ) reporting application.
• Processed requests from other groups to get environment property and log file info from Unix servers.
• Was in charge of enterprise change(app data/configuration change) management - interpreted and consolidated data change requests from CAS(, which stands for client app support, i.e. app Level 1 support), created data change scripts(sql, PL/SQL) based on business requirements, proof read others’ scripts to ensure they went by company standards, created change implementation plan document and drove the change process working with DBA, Techops system admin and app (such as datastage, control-M) admin.

Tools: used: Wily Introscope, Keynotes, TOAD