QA Analyst/ Developer
Resume:
SOUMENDRA DAS
*********.*****@*****.***
Senior Oracle PL/SQL Developer
SUMMARY:
• 7+ Years of strong experience in Information Technology as Senior Oracle PL/SQL and UNIX Shell Scripting Developer having in-depth knowledge in Analysis, Design and Development of Database and Web Service applications.
• Have expertise knowledge in Oracle Database, BO WebiReports, Corda and Oracle-RDBMS Concepts, for reporting solution for Operational Reporting System.
• Extensively worked on all the phases of Database life cycle from Requirement Gathering, Analysis and Design to Project Support
• Extensively worked on all types of Project (Development, Migration & 24*7 Support).
• Experienced in designing & developing (OLAP & Non- OLAP) Database reporting solutions for Operational Reporting System.
• Expertise in Oracle 9i/10g/11g & PL/SQL Reporting and writing complex and scalable solutions using stored packages, procedures, functions, views and triggers.
• Have expertise knowledge and experience in Supply Chain Management.
• Have expertise knowledge in Database Concepts, PL/SQL and advanced Oracle concepts, such as: Performance Tuning, Query Optimization, Materialized Views, Parallel Option, and Partitioning.
• Experienced working as liaison between IT and Business Users and supporting the users.
• Experienced working proactively in identifying the issues and escalating and communicating the issues to the business clients.
• Experienced in preparing test cases of the business process or application.
• Experienced in presenting trainings to the wider audience.
• Strong Oracle database experience.
• Excellent communication skills, Passion for analysis and reporting, Fast Learner; Dedicate, Hard worker and Good Team player.
• Have expertise knowledge in CMM and CMMI Quality measures.
• Have expertise knowledge of complete SDLC.
• Dedicated team player with proven analytical, and communication skills.
• Demonstrated ability to learn Newer Technologies.
TECHNICAL PROFICIENCY:
• Languages: Oracle PL/SQL, UNIX Shell Scripting, JDBC-Spring Frameworks
• Databases: Oracle 11g/10g/9i, SQL Server 2005/2000, MSAS and MS Access 7.0.
• Operating Systems: UNIX, MAC OS X, Windows 2003, 2000, 95, 98, XP,
Windows NT 4.0, MS DOS.
• Front End Tools: Corda, TOAD, SQL developer, Eclipse
• Application Software Adobe Works, Photoshop, Omnigraffle, MS-Office Suite, Visio.
EDUCATIONAL QUALIFICATIONS:
Degree/Graduate: Bachelor of Engineering in Electrical & Electronics 2004
CAREER PROFILE: (PROJECT WISE)
Senior Lead Oracle, UNIX and Corda Consultant: Mar 2011 to Till Date
Client: Apple Computer Inc, Cupertino
Project Title: Apple Enterprise Technology Services
JMET Monitoring Dashboard - is a web portal used for monitoring of the performance and health of various JMET applications and the infrastructure components (such as the machines, databases and servers on which these applications run). All the performance and health information are shown as charts. The portal provides each of its users with a highly customizable and personalized UI to help track, monitor, diagnose and alert on capacity and performance related metrics. This will enable the business users, System Administrator, Database Administrators to proactively manage and tune the growing infrastructure in the Apple area.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, Corda, SQL developer, MAC OSX
Senior Lead Oracle and UNIX Developer: Oct 2009 to Feb 2011
Client: Apple Computer Inc, Cupertino
Project Title: Apple iTunes Dashboard Support and Maintenance
The project involves maintaining the iTunes dashboard application through production support and software solution for any enhancements to the US iTunes Stores thus minimizing downtime and providing fast issue resolution leading to better sales. This directly impacts the revenue of Apple if Store issues are resolved. This will enable iTunes engineers, System Administrator, DBA's to proactively manage and tune the growing infrastructure in the iTunes area. They use the portal to track and manage different business processes.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, JDBC-Spring Frameworks, MAC OSX
Senior Oracle and UNIX Developer: Jul 2008 to Sep 2009
Client: Apple Computer Inc, Cupertino
Project Title: Apple Online Store Support and Maintenance
The project involved the re-engineering and development of the Apple Online Store. The current application was not able to cater to the critical needs of users with respect to correctness of software and hardware product, interoperability, feature and functions, support information and report generation based on such information. Therefore it was deemed necessary to redesign and develop a new version of the application.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, SQL developer, MAC OSX, WebIReports, Windows
Oracle and UNIX Consultant: May 2007 to Jun 2008
Client: Canadian Pacific Railways, Calgary
Project Title: Canadian Pacific Railway SADB
SADB is the central repository of corporate data used by the various applications. Many applications send and receive data through the SADB. The purpose of the SADB is to integrate all corporate data required by the organization. Basically SADB deals with two key aspects, which are creation and maintenance of relationships between data elements and managing of the consistency of information when data is sourced and used by multiple.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, TOAD, Windows
Oracle and UNIX Developer: Jan 2005 to Apr 2007
Client: Apple Computer Inc, Cupertino
Project Title: Supply Chain Integration Project
Apple Computer Inc. has implemented i2 Technologies Supply Chain Planner and Demand Planner to support it's move to a build-to-demand (BTD) environment. SCI is a single point application for Apple's Finished Goods Supply Chain Management. It is the means of communication between SCP & DP. The users can access SCI from a front-end Cocoa application to view data. Also finished goods related information such as price, capacity etc is updated through this front-end application of a Finished Good [FG]. The scope of this project is to maintain and enhance this application.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, Jade, Cocoa, MAC OSX, Windows
Oracle and UNIX Developer: Aug 2004 to Dec 2004
Client: Indian Seamless Metal Tubes Limited, Pune
Project Title: Engineering Services and Technology Solutions Project
ISMT Limited, manufacturer of seamless tubes and alloy steels has a large capacity (150,000 metric tons per annum) and also has a much wider size range (from 6mm to 273 mm). The Engineering Services and Technology Solutions project provides solutions in Product Design and Innovations, Product Enhancements, Value Engineering, Cost Reductions, Product Optimization, Process Planning, Concurrent Engineering, Virtual Simulation and Manufacturing Optimization.
Responsibilities:
• Worked directly with the business users and capture simple, moderate and complex business requirements.
• Responsibilities included requirement gathering/analysis, estimation, design& development, test planning and testing, review, deployment and production support.
• Responsible for planning and managing offshore delivery.
• Gathered the complex business requirements and did business analysis to write functional specification document for new reports.
• Assisted in defining the scope of the project, technical and business specifications
• Creating complex reports by linking data from multiple data providers, using free hand SQL, stored packages, procedures and functions.
• Presented Trainings to the higher managements using PowerPoint.
• Involved in documenting the business process by identifying the requirements.
• Task Allocation, Estimation, Task tracking, Quality Assurance, Project planning.
• Coding, Code Review, Technical assistance to team.
• Test developed program modules against prepared test cases.
• Ensuring quality and timeliness of product delivery.
• 24*7 Support of the Project.
Environment: Oracle PL/SQL, UNIX Shell Scripting, Windows
Contact this candidate