SUMMARY

• About 12 years of result oriented professional experience in Perl, shell and database
• Comprehensive experience in applications on Oracle and MS SQL Server databases in UNIX, LINUX, and Windows Environments.
• Work as a team member to deliver data and application solutions (ETL development) onto Enterprise Data Warehouse platforms
• Administer development infrastructure and services. Troubleshoot system issues and perform root cause analysis
• Perform Baseline/Product support work in the technology areas listed
• Perform unit and regression testing of code for major development releases
• Perform production code deployments on a regularly scheduled basis
• Opportunity to work on challenging environment and new technologies
• Drive effective teamwork, communication, collaboration, and commitment across multiple groups with competing priorities
• Provide input for improvements of existing infrastructure
• Reverse engineer any existing Informatica workflows and migrate it to Shell and Perl
• Deliver solutions which meet Service Level Agreement and performance criteria
• Administer development infrastructure and services
• Ability to effectively resolve issues/problems to reach a workable and successful solution
• Ability to provide detail information and summarize to various levels of staff including management
• Ability to work in ambiguous situations
• Ability to learn, understand and develop large systems of simple - to-moderate complexity
• Development of platform components using object-oriented Perl and Unix shell scripting
• Enhance, develop and deliver training material
• Develop thorough tests to prevent outages in the infrastructure
• Prepare presentations and demo on solutions developed
• Work with operations team to help debug complex issue of deployment services
• Debug and fix bugs reported by operations or customers

TECHNICAL SKILLS

• Perl scripting
• Shell scripting
• Sybase
• Db2
• Teradata
• PL/SQL
• Ansible
• AWS
• Upgrade Assistant
• Release Management
• Change Assistant
• Configuration Management
• Disaster Recovery / Business Continuity
• Tools & Application Upgrades
• Tibco EMS

PROFESSIONAL EXPERIENCE

Confidential

Developer (Q A Automation)

Responsibilities:

• Assess current state of Windstream architecture and develop target state Powerstream blueprints and transformational roadmaps to achieve strategic organizational objectives.
• Analyze Windstream system resource usage, transform, and implement Powerstream based solutions using modules.
• Monitor production installation and support application break fixes, Overnight batch failures
• Write test cases to complete Unit testing and leverage by automating testing through unit test scripts using perl and shell.
• Developed and executed test plans and test cases
• Designed, wrote, and executed system-wide test plans and test case suites for automation test frame components
• Worked on SQL* Loader to load the data from flat files.
• Experience in Data migration using import and export.
• Developed Pl/SQL triggers and master table for automatic creation of primary keys.
• Wrote cursors as per the requirement
• Created indexes on tables for faster retrieval of data to enhance database performance
• Write perl code in powerstream platform to accommodate the requirements as per the applications
• Write shell and perl scripts for automation of task.
• Interpreted and converted manual test cases into automation smoke and regression suites.
• Did performance testing, scheduling, maintenance, and database backup/restore.
• Performed backend testing of application using SQL, writing queries to confirm correctness of data entered via UI, and data manipulation.
• Led and mentored junior automation and manual QA engineers to execute and analyze automation smoke and regression tests.
• Mentored and provided guidance for QA automation team member in India

Skills/technologies used to perform the job : Perl, ETL, Unix, Shell script, SQL, PL/SQL, Agile Development Environment Jira, HP Quality, Tibco EMS

Confidential

Responsibilities:

• Interaction with the client to understand their expectation
• Analyse the insurance updates and fix the error
• Worked on defect analysis and provided a solution like a database issue
• Co-ordinate with team members to get with the resolution for the issues.
• Developed libraries, object repositories and optimized configurations for QTP and QC.
• Converted manual functional and regression scripts to keyword data-driven automated scripts.
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose
• Developed SQL scripts to validate relational database tables.
• Created stored procedures and did performance tuning
• Created views as per the requirement
• Responsible for performance tuning activities in the project.
• Expertise in SQL and PL/SQL programming, developing complex code units.
• Provided automation training to manual testers and offshore resources.
• Created Test Plans, Cases and Scripts for UAT, functional and regression testing.
• Produced Quality Center and Excel metrics/reports from scheduled execution test run

Skills/technologies used to perform the job: Perl, ETL, Unix, Shell script, DB2,Pl/SQL,Agile Development Environment, Autosys, Ansible, Jira, HP Quality

Confidential

Computer Programmer

Responsibilities:

• Project involves Analysis, Design, Development and Maintenance
• Interaction with the client to understand their expectation
• Works with team members to identify areas of focus, where training may improve team performance, and improve incident resolution
• Works with Prod Support Lead and or Prod Support Manager to discuss potential process improvement opportunities identified
• Liaise with Delivery, Infra, Network and vendor teams on support matters - performance & upgrades/migration
• Provide continuous monitoring and improvement of systems - job automation, performance tuning, capacity planning
• Manage Production workflow
• Assist with troubleshooting and issue resolution relating to current applications, providing assistance to the development
• Manage and coordinate hot fix and maintenance releases
• Provide support to the business during day-to-day activities and ad-hoc requests
• Migration of Legacy Informatica services. Maintenance of CDC subscriptions and Legacy Informatica services
• Handling Disaster Recovery drills
• Wrote sequences for automatic generation of key
• Created and modified the SQL* loader scripts
• Develop triggers and functions
• Did performance tuning
• Port the existing Scripts and Utilities to Linux Environment and make Code changes to UNIX.
• Perl and shell scripts for automating the tasks
• Written stored procedure for task automation
• Managing the releases for middle tier services and for data integration platform

Skills/technologies used to perform the job: Perl, ETL, Unix, Shell script, PL/SQL, Teradata,Agile Development Environment, Autosys, Ansible, Splunk, dynatrace, jira,Tibco, HP Quality

Confidential

Computer Programmer

Responsibilities:

• Analyse the entire Daily Pricing system
• Perform functional testing.
• Conduct backend testing for various applications
• To work with Production Support Manager for system support matters for respective delivery, infra & network teams and external vendors/service providers
• Provides business specific metrics for production management for current and potential issues - provide thresholds to ensure timely remediation
• Analyze production issues to determine root cause and provides fix recommendations to the development team
• Support applications in production. Note interruptions or bugs in operation and perform problem solving exercise to determine problem and ensure continued use of the application.
• Trouble-shooting production incidents requiring detailed analysis of issues on web and desktop applications, Autosys batch jobs, and databases
• Develop a strategy for preparation of manual testing.
• Created scripts for automation testing for E*rcp, *rcp and ocp. Perl script to send mail regarding cpu utilization on our NYP PRICING server
• Resolve issues when encountered to ensure smooth stability of system
• Automated process where manual intervention require
• Co-ordinate with team members to provide them with resolution for the issues
• Interact with client for requirement gathering, with developers and other project related people to know issue and for resolution
• Conduct training session for offshore. Do Knowledge transfer from onsite to team members based at different location’s
• Raise defect in quality center.
• Perform regression testing and conduct defect reviews on a daily basis

Skills/technologies used to perform the job: Perl, ETL, Unix, Shell script, DB2, Sybase,Agile Development Environment, Autosys, Cobol, Jira, HP Quality