SUMMARY

• 5.3+ years of experience in Requirements Gathering, Analysis, Development, Support and Enhancement, Business Analysis of 3 tier businesses applications with core focus on DB development.
• Experience of Reporting as well as Formsdevelopment
• 1 year experience in Informatica development.
• 5 years of experience in Performance Tuning and Optimization dat results in benefit by cost and time saving.
• 5 years of excellent hands - on experience in PL/SQL and well-versed with advanced PL/SQL Concepts viz. cursors, exceptions, database triggers, database packages, procedures & functions.
• 2 months of project with ABB Ltd, being part of 2nd year of PGDM.
• 1 year of experience as Consultant. Recognized for successful project co-ordination, Productivity improvement, Incident Reduction and Resolution of long pending Issues
• Excellent SQL skills, experience in writing complex queries and working with database objects (me.e. tables / views / sequences etc.).
• Hands on experience in Data Migration from one database to another Database
• Proficient in utilities such as SQL*Loader, SQL*Plus, Import/Export and tools such as Toad, SQL Developer.
• Experience in Query Optimization, Indexing and Hints
• Developed custom reports using SQL*Plus
• Experience in 24/7 Production Support & Maintenance of CA ITCM
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels of Business, Engineering, QA and other teams involved with System Development Life cycle.
• Enthusiastic team player with coordination and organizational skills
• Detail oriented and self-motivated with ability to manage multiple tasks, prioritize and adhere to tight deadlines
• Extensively involved in all teh phases of SDLC (Software Development Life Cycle)
• Preparation of impact analysis, Coding, System Test Plan, Testing, Code Review, coordinating user training, UAT, Project demonstration, Implementation and Maintenance
• Worked in CMMI Level 5 Projects have been CC (Configuration Controller) and member of various CM (Configuration Management) audits
• Quick learner with ability to master new concepts and applications
• Have Worked in Travel and Transport Domain for 3 years.

TECHNICAL SKILLS

Technical: expertise revolves around database development and supporting practices in software development life cycle includes configuration management tools, integrated development environment and domain understanding.

Languages: PL/SQL, SQL.

Databases: Oracle 10g/9i,SQL Developer, Informatica 9.6.0

Networking Tools: CA Desktop and Server Management 11.2, CA IT Client Manager 12.5, CA DSM Reporter

Exposure To: ADO.NET, Windows Communication Foundation, Windows Presentation Foundation, Windows Workflow Foundation, C and AutoIT, PL/SQL Tuning, Index Tuning, Performance Tuning and Optimization

Tools: SQL Developer, Toad, Eclipse.

Web Technologies: HTML, Javascript

Methodologies: Billing & Payments, Infrastructure Management System.

Operating Systems (Server/Client): Windows 98, 2000, 2003, XP, Vista and 7.

PROFESSIONAL EXPERIENCE

Confidential

Migration Developer

Responsibilities:

• Development of cursors and procedures while working on Claims module.
• Performance tuning and optimization in scripting to reduce time of data load and cost cutting.
• Productionization including loading of source data to staging tables and staged data to target database.
• Creation of sessions, mapping, worklet and workflows in Informatica.
• Execution of workflows and resolving teh errors.

Environment: Informatica 9.6.0, Oracle 11g, PL/SQL, SQL Developer 4.0, TOAD 12.1.0, SVN

Confidential

Data Migration Developer

Responsibilities:

• Requirements gathering and leading a team of offshore developers for migration scripting.
• Worked with business analysts to consolidate functional requirements for migration.
• Development of procedures and SQL source per migration process.
• Performance tuning and optimization in scripting to reduce time of data load and downtime.
• Training and noledge management for production support team.

Environment: Oracle 11g, PL/SQL, SQL, SVN

Confidential

Oracle Developer

Responsibilities:

• Requirements gathering, clarification and development of reporting system.
• Worked with business analysts and cross functional teams to define workflow/processes and functional requirements.
• Development of procedures and SQL queries to get reporting data.
• Day to day customized reporting required by business to make agile decisions.
• Coordination among services and consumer interface team for correct requirements flow.
• Involved in performance tuning and monitoring by creating indexes.
• Defined use cases and system test cases.
• Responsible for leading offshore development tasks.
• Created indexes for fast retrieval of information.

Environment: Oracle 9i PL/SQL, MySQL, Routines, UNIX, SVN, Eclipse, Soap UI, WSIMPORT, HTML, PuTTy

Confidential

Consultant

Roles and Responsibilities:

• Hands on experience in implementing as well as supporting CA Unicenter Desktop and Server Management (CA DSM)
• Health checks& up gradation of CA products
• Daily DSM Health Check on Domain servers and resolving if any errors faced in any scalability or domain servers
• Organized UAT for business admin user
• Developed packages, Stored Procedures and Stored Functions
• Practical exposure of working in CA DSM 11.2 as well as CA ITCM 12.5
• Weekly Patching on Windows XP and Windows Server machines
• Report Generation in DSM Reporter
• Responsible for in-house presentations, inter-company presentations
• Used AutoIT for packaging executable file software and creating package of Microsoft Installer file software
• Participated in teh process of Upgradation of CA Desktop and Server Management 11.2 to CA IT Client Manager 12.5
• Development of procedures and SQL queries to get reporting data
• Involved in performance tuning and monitoring by creating indexes
• Defined use cases and system test cases
• Provide technical and functional application support including application patching and preventive maintenance
• Generating Software Distribution Report for previous Static/Dynamic Software Deployments
• Created indexes for fast retrieval of information
• Support and maintenance to database issues
• Creating & configuring Software Distribution Policies
• Software Packaging in DSM Environment Testing & Releasing for specific machines using Software Catalog or Distribution to a Static/Dynamic Group of DSM Agents

Environment: SQL Server, Oracle, Oracle 9i PL/SQL, Routines, PuTTy, CA IT Client Manager 12.5, CA DSM Reporter, HTML, AutoIT.

Confidential

SoftwareDeveloper

Responsibilities:

• Requirements gathering, clarification, design and development of reporting architecture
• Worked with project management, business analysts and cross functional teams to define workflow/processes and functional requirements
• Development of procedures and SQL queries to get reporting data
• Coordination among services and consumer interface team for correct requirements flow
• Involved in performance tuning and monitoring by creating indexes
• Defined use cases and system test cases
• Debugging teh flow to resolve issues using ADO.NET
• Worked on teh localization strategy for teh reports
• Responsible for leading offshore development tasks
• Created indexes for fast retrieval of information
• Responsible for in-house presentations, inter-company presentations
• Support and maintenance to database issues
• Initiating enhancements in business process for longer term cost benefits
• Interacted with business analysts and business partners to understand teh requirements
• Executing teh various major/minor/bug-fix and enhancement requests involves design and development.
• Developed packages, Stored Procedures and Stored Functions
• Data Migration in application during plant transformation from legacy into Oracle ERP
• Production support of Airport Management Solution Application including 24/7 support for critical issues
• Led teh weekly status report meeting on planned enhancements and bug fixes
• Tested teh application to validate proper functionality in integrated system environment
• Organized UAT for business admin user
• Client interfacing, communication regarding status of schedule and conflict resolution between offshore and customer
• Design and development of flight arrival and departure process in PL/SQL
• Design and development of flight saved search functionality through PL/SQL
• Responsible for performance tuning of teh database
• Tuning of SQL Statements

Environment: SQL Server, Oracle, Dot Net, Visual Studio, Oracle 9i PL/SQL, Routines, HTML, PuTTy.