Sr Unix, Pl/sql Support And Developer Resume
San Francisco, CA
SUMMARY
- Around 8 years of Software experience in Application Maintenance/Development/Support.
- Experience in Systems Analysis, Design, Development and Implementation of various applications using UNIX, C, Main Frame and PL/SQL.
- Good noledge in exposing and consuming scripting in applications.
- Hands on experience in ORACLE database design and development in writing Views, Stored Procedures, Cursors, Triggers and User Defined Functions.
- Experience in Unix shell script programming
- Good noledge in Crontab to automate teh routine process
- Worked with environments like OPEN UI, Centura - Gupta, Oracle Forms 4.5, Data Stage Developer.
- Involvement in all stages of Software Development Life Cycle (SDLC).
- Good noledge on iTAM ticketing tool as part of application support service delivery.
- For all application issues - performing RCA, coming up with detailed code level fixes, analyzing teh efforts required, fixing teh issue.
- Having hands on Experience in Version control tool - VSS.
- Experience in Main Frame systems and ESP scheduler.
- Experience in Control - M scheduler for UNIX jobs.
- Good noledge in Confidential Quality Centerwhich is quality management software offerssoftware quality assurance, includingrequirements management, test management andbusiness process testing for IT and application environments.
- Worked on Batch process in claims subsystem that uses Pro*C (C program embedded SQL (Oracle 11g)) programming, which involved change orders for enhancements and special projects for new implementation.
- Highly motivated, detail oriented, has ability to work independently and as a part of teh team with Excellent Technical, Analytical and Communication skills.
- Assisted in software design, creation of ER diagrams, phasing from development to QA and to production environment
- Performed Component level testing, Integration testing, Performance testing, User Acceptance Testing and Client Acceptance Testing.
- Experience in managing file system space.
- Design & development lead on Claims & Reference - Adjudication, Edits-Audits, Pricing & Rules Engine modules. This effort involvedPro*C, C, C++, Unix, PL/SQL
- Able to work both independently and in team-oriented, collaborative environments.
- Good in Component level testing, Integration testing, Performance testing, User Acceptance Testing and Client Acceptance Testing.
- Experience in training users, providing technical support, maintenance and documentation of teh developed software.
- Experience in developing Unit test cases based on teh business scenario and requirements and performing Integration and Regression test.
- Experience in supporting 24/7 high availability production servers.
TECHNICAL SKILLS
Databases: Microsoft Access, SQL Server, PL/SQL, ORACLE, Object Store
Languages: C, C++, Oracle Developer, Oracle Forms, Oracle Reports, JavaScript, Java Basics
Markup Languages/Version: HTML/XML
Operating Systems: MS Windows XP / 7, UNIX
Client Server: Visual Basic 5.0
Reports: Crystal Reports
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
Sr UNIX, PL/SQL support and developer
Responsibilities:
- As a developer involved in design, coding and developing various modules for assisting Confidential using C, UNIX, and SQL.
- Involved in Maintenance and Support of applications/programs that were designed to halp teh Confidential customers for various services.
- Involved in Technical Documentation of teh assigned modules.
- Involved in noledge transfer to teh Team.
- Proficient in archiving and backups.
- Involved in main frame task to schedule jobs with ESP scheduler.
- Involved in UNIX job scheduling using Control - M scheduler.
- Write UNIX scripts to manage file system space management.
- Involved in database import export activities.
- Created shell scripts and updated teh scripts as per teh requirement.
- Efficiently managed disk by deleting old log files.
- Day to day administration of teh Development environment and Test environment systems.
- Good noledge in Client-Server application development using Oracle8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
- CreatedShell Scriptsfor invoking SQL scripts and scheduled them using crontab.
- Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Environment: UNIX, Mainframe, ORACLE database, Shell Script, PL/SQL, SQL, XML/HTML
Confidential, Atlanta, GA.
Sr UNIX, PL/SQL support and developer
Responsibilities:
- Involved in Georgia state Medicaid & Medicare product research, design, development, deployment & implementation as a Technical SME.
- Design & development lead on Claims & Reference - Adjudication, Edits-Audits, Pricing & Rules Engine modules. This effort involvedPro*C, C, C++, Unix, PL/SQL
- Lead developer for Rules engine (config changes, metadata changes, BPA load, rules conflict reports) and Reference (reports, rules, configuration, BPA)
- Development Mentor for Customers, Vendors, Auditors, Business Analysts’ and Cycle Monitoring teams
- Constructed programs for adjudication and pricing for encounter, crossover claims
- Worked on running Quarterly, annual NCPDP/NDC updates from CMS as teh Reference primary developer
- Organized stakeholder communication, design and tan development of Claims extracts for vendors (AmeriGroup, Peach State, WellCare) and auditors (Myers and Staffers) for GA-MMIS
- Handled coordination between different teams (hospitals’ IT teams, L-1 support, production support) for claims, payments, disputes, concerns resolution
- Maintained BPA (Benefits Plan Administration) taking care of rules configuration, scheduling and deploying config copy jobs, converting rules/reference data
Environment: Pro*C, C, SQL, Data structures, Unix, PL/SQL, Shell Scripting
Confidential, Irvine, CA
Sr UNIX, PL/SQL support and developer
Responsibilities:
- Participating in all phases of software development life cycle and develop applications applying principals and techniques of web engineering and mathematical analysis.
- Preparing functional specifications, perform system analysis, design, develop, and implement test and maintaining client server/multi P tier applications from business requirements and user needs.
- Integrating various business systems and applications and provide technical support.
- Translating teh business requirements in to coding (C) and meet teh project deadlines on time.
- Translating teh business requirements in to coding and meet teh project deadlines on time.
- Estimating teh level of effort and finished target for teh project/tasks.
- Design, code, debug and maintain teh software.
- Team up with software engineers and produce maintainable data interface layers within applications.
- Performing Component level testing, Integration testing, Performance testing, User Acceptance Testing and Client Acceptance Testing.
- Providing daily development status, weekly status reports, and weekly development summary and defects report.
- Training users, providing technical support, maintenance and documentation of teh developed software.
- Developing Unit test cases based on teh business scenario and requirements and performing Integration and Regression test.
Environment: C, C++, Pro*C, Confidential -Unix, SQL, Perl, Clearcase, Linux Operating system
Confidential, Nashville, Tennessee
UNIX, PL/SQL support and developer
Responsibilities:
- Worked on Batch process in claims subsystem that uses Pro*C (C program embedded SQL (Oracle)) programming, which involved change orders for enhancements and special projects for new implementation.
- Involved in creating new programs and jobs to generate reports as per teh client request using Pro*C and shell scripts
- Created PL/SQL programs to generate reports
- Involved in various stages of SDLC like Requirement gathering, high-level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
- Participated in design reviews and walkthroughs with project manager and development team.
- Written UNIX shell scripts to run jobs and utilities.
- Strictly adhered to coding standard and naming conventions of Confidential /EDS.
- Conducted design and code reviews for teh developed objects.
- Extensively used SQL developer for database access.
- Documented business rules, technical designs, test cases, and user guides.
- Involved in unit testing, integration testing, system testing.
Environment: Sun Solaris 5.9, WINDOWS, Claims in Healthcare, Oracle.
Confidential
UNIX Developer
Responsibilities:
- Assisted in software design, creation of ER diagrams, phasing from development to QA and to production environment
- Translating teh business requirements in to coding (C) and meet teh project deadlines on time.
- Worked in Project planning, Designing & Implementation.
- Worked with various business groups while developing their applications.
- Writing teh stored procedures, checking teh code for efficiency.
- Defining and creating indexes for query optimization and revising scripts for optimal performance.
- Involved in Unit testing, User Acceptance Testing to check whether teh data is loading into target, which was extracted from different source systems according to teh user requirements.
- Providing daily development status, weekly status reports, and weekly development summary and defects report.
Environment: C, SQL, PL/SQL, Pro*C, UNIX Operating System
Confidential
Developer & Production Support Engineer
Responsibilities:
- Analyzing teh requirements and suggesting designs and solutions for CDMA and GSM developments
- Analyzing feasibility, planning and implementing business change requests
- Documenting teh change requests and operational procedures
- Health check-up and maintenance of teh existing systems
- Attending teh user requests (through service calls and e-mails) and providing solution for teh same
- Correcting loopholes in workflows and opting performance improvement
- Supported 24/7 high availability production servers.
- Provided process improvement plans like displaying data for multiple users using Shell scripting
Environment: Solaris, Confidential -UX, Windows XP, Oracle, Comptel IL, Comptel SAS, Tibco BW, Microsoft Office.
