SUMMARY

• Over 15+ years of experience in teh Information Systems/Technology field. Proven technology leader, wif a wide breadth of experience across various technologies.
• Strong technical experience in Informatica, ETL, SQL, PL/SQL, Unix, Unix Shell Scripting, Perl, Java scripting, VB scripting, SQL tuning, Oracle 12g, DB2 and SQL Server Databases, Confidential Aix, Linux, Java, Crystal reports, SQL Stack, SSIS, SSRS, JDK
• Strong experience in Healthcare, Pharmacy, Banking, Financial and manufacturing domain
• Exceptional interpersonal skills, can TEMPeffectively communicate, collaborate and lead projects wif teammates, clients, and vendors in order to accomplish responsibilities and objectives
• Exceptional process improvement skills: focusing on automation, simplification, streamlining
• Exceptional Incident and Problem Management skills
• Subject Matter Expert in SQL, PL SQL, Informatica, VB, Perl and Shell Scripting, Data modeling.
• Worked in scrum based Development, maintenance and support of applications.
• Global Disaster Recovery Lead for Oracle, DB2 and Unix applications.
• As part of assignments, was involved in leading team, application development, support and maintenance work, development of functional and technical specification and product implementations, documentation, writing test cases, release management, performing Confidential .
• Experience in DBA level work like creating and managing tables, table spaces, rollback segments, database performance monitoring, tuning of queries, database backups, Import and export of schemas etc,
• Experience in SDLC, development using agile methodologies, waterfall model, ballpark estimation.
• Good experience in areas like Loan origination, recovery management and collection system, Purchase Order, Health care, health insurance claim system.
• Good experience in identifying operational issues and recommending and implementing strategies to resolve problems.
• Strong experience in using tools like Toad, Erwin, Clear Case, HPSM, Remedy, MS VSS, Maestro Confidential Tivoli Job scheduling console.
• 2+ experience in Pega PRPC application support.
• Extensive experience in software project delivery & implementation
• Played a role of Team/Technical Lead in multiple projects.
• Currently working in Confidential

TECHNICAL SKILLS

• SQL, MySQL
• PL/SQL
• Unix Shell Scripting
• Informatica, Ubentu
• VB Scripting, MS BI
• ETL,SSIS,SSRS
• Data Modeling, SQL Stack
• SQL, PL/SQLTuning
• Java Scripting
• Oracle 8,9,12G
• DB2, Crystal Reports
• MS SQL server
• Perl Scripting
• MySQL, Tableau
• Ms projects, visio, excel
• MS Visual Source Safe
• Websphere, Hadoop
• WebLogic, ErWin
• Application development
• Application support
• Tera Data
• Java JDK
• Hadoop,Data Modeling
• Pega, Sun O.S, AIX

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Involved in enhancement, support and maintenance of applications, performing Confidential
• Data modeling, managing ETLs, Creating and managing technical and functional documentation, creating/modifying HLD, LLD, functional and requirement specifications, creating/modifying UML, data flow, ER diagrams etc.
• Involved in daily support activities, batch monitoring, resolving batch failures, automation of batch jobs and automation of business reports, creating knowledge base, performing root cause analysis, taking calls wif business, dev team and all stake holders.
• Creating, modifying Oracle procedures, functions, packages, unix shell scripts, Informatica flows, SSIS ETLS, SSRS reports, VB.Net and C# modules, Java libraries, Crystal reports, Data migration etc.
• Improving application performance by tuning sql’s, plsql code and rewriting optimized code/sql, enhancements for performance improvements etc.
• Supported Pega PRPC version of application, Data modeling
• Release management, Planning, allocation and monitoring of tasks of team members
• Attending change management meetings, also attending meetings wif dev and business teams for ongoing Change requests
• Identifying operational issues and recommending and implementing strategies to resolve problems.
• Involved in requirement analysis, impact analysis, design, coding & deployment of change requests.
• Proposed and implemented value addition and enhancements in teh application., Identified and fixed bottlenecks and painful areas in teh application code like, writing test cases for testing teams
• Maintaining teh health of teh project
• Involved in tuning of informatica flows, queries, procedures, functions and packages, reports.

Confidential,

Responsibilities:

• Involved in support and maintenance of teh application, Handling high - severity problem incidents and scenarios, Release management.
• Patching application, performing shakeout, automation
• Creating, modifying Oracle procedures, functions, packages, Java libraries code, shell scripts and Informatica flows, performing Confidential
• Data modeling, Creating and managing technical and functional documentation, creating/modifying HLD, LLD, functional specifications, UML, data flow diagrams etc.
• Involved in daily support activities, batch monitoring, resolving batch failures, automation of batch jobs and automation of business reports

Confidential,

Responsibilities:

• Team Lead, Involved in scrum base development, requirement analysis, impact analysis, design, coding & deployment.
• Creating, modifying Oracle procedures, functions, packages, unix shell scripts, Informatica flows, SSIS ETLS, SSRS reports, VB.Net and C# modules, Java libraries, Crystal reports, Data migration etc.support and maintenance of teh application, migration of data from other databases
• Review of code changes, test plans, documentation,
• Facilitating smooth and TEMPeffective onsite-offshore coordination
• Implementing SOX audit, compliance monitoring, database architect, data modeling
• Creating, modifying Java libraries code, Oracle procedures, functions, packages, shell scripts and Informatica flows, performing Confidential

Confidential,

Responsibilities:

• As a Database Architect was responsible for designing and Modeling of Application's Database.
• Preparation of teh HLD for Application Development Project
• Provides Database design consultation to teh development team.
• Designing and Modeling teh Database (Logical and Physical database Design)
• Review & Optimize teh Code.
• Development of Oracle procedures, functions, packages.
• Development of UNIX Shell Scripts, Java libraries, maintaining VB modules.

Confidential,

Responsibilities:

• Implementing interfaces between GPS and Oracle Apps, Mainframe ERP system
• Implementing changes in app per compliance and audits.
• Technical lead in Oracle, Unix, Java and migration of data
• Application support and maintenance.
• Creating, modifying Oracle procedures, functions, packages, unix shell scripts, Informatica flows, VB.Net and C# modules, Java libraries, Crystal reports.
• Database designing and modeling for oracle apps purchasing module.
• Involved in requirement analysis, impact analysis, design, coding & deployment

Confidential,

Responsibilities:

• Scrum based development of applicationVB Front end and Oracle backend developer, release management.
• Involved in requirement analysis, impact analysis, design, coding & deployment and change requests.
• Involved in support and maintenance of teh application.
• Proposed and implemented value addition and enhancements in teh application. Identified and fixed bottlenecks and painful areas in teh database and UNIX shell scripting code.
• Involved in tuning of queries, database objects, creating active X components.
• Worked on resolving high-severity problem incidents and scenarios analysis, performed root cause analysis and fix high-severity problem incidents in production.Migrated data

Confidential,

Responsibilities:

• Understanding teh requirement documents and prepared technical specification, test plans and test cases.
• Worked on debugging/understanding teh Java pages code to find out issues related to database objects.
• Worked on adding Java scripting for input validations in Oracle Procedures.
• Design, Coding, testing and deployment of new enhancements and change requests
• Handling high-severity problem incident and scenarios
• Developed Store Procedure, Functions and Packages in Oracle SQL and PL/SQL.
• Involved lot of Client Interaction and Business communication