Quality Assurance Project
Resume:
SOUMENDRA DAS
*********.*****@*****.***
Senior BI Developer
SUMMARY:
• 9+ years of strong experience in Information Technology as Senior BI
Developer having in-depth knowledge in Analysis, Design and
Development of Database and Web Service applications.
• Have expertise knowledge in Oracle Database, Cognos, Oracle APEX,
BO WebiReports, Informatica, ETL, UNIX Shell Scripting, 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, ETL packages,
PL/SQL and advanced Oracle concepts, such as: Performance
Tuning, TKPROF, SQL Trace, Explain Plans, Indexing, Query
Optimization, Materialized Views, Compression, 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, Oracle APEX, SQL, Java
Script, CSS and Ajax.
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: Cognos,TOAD, SQL developer, Informatica Power
Center 9, Eclipse, Oracle APEX, Adobe Works, MS-
Office Suite, Visio, Corda.
EDUCATIONAL QUALIFICATIONS:
Degree/Graduate: Bachelor of Engineering in Electrical & Electronics 2004
CAREER PROFILE: (PROJECT WISE)
Database Analyst
( Jan 2012 to TILL DATE )
Client: The Pampered Chef, Addison IL
Project Title: Business Intelligence Reporting & Analytics
The Pampered Chef® headquartered in Addison, IL, is the largest direct seller of
high-quality kitchen tools serving 12 million customers worldwide. For over 30
years, it has helped thousands of Independent Consultants reach financial
independence through a Pampered Chef® business. The Pampered Chef* is the
premier direct seller of essential kitchen tools and part of the Berkshire Hathaway
family of businesses. The company and its sales force of independent Pampered
Chef Consultants offer multipurpose kitchen tools, easy recipes that produce
dramatic results and time-saving techniques that make cooking and entertaining
quick, easy and fun. As a part of the BI team handled and developed high quality
sophisticated reports which affect the business decisions.
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.
Performance Tuning, TKPROF, SQL Trace, Explain Plans, Indexing, Query
Optimization, Materialized Views, Compression, and Partitioning
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, Cognos 8, SQL, APEX, Informatica ETL
Technical Analyst
( Mar 2011 to Dec 2011 )
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.
Performance Tuning, TKPROF, SQL Trace, Explain Plans, Indexing, Query
Optimization, Materialized Views, Compression, and Partitioning
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, Cognos, APEX, SQL
developer, MAC OSX, Informatica ETL
Senior Lead Oracle/ETL and UNIX, Corda 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, Corda, JDBC-Spring
Frameworks, MAC OSX, Informatica ETL
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 PL/SQL and UNIX Developer
( 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 apps.
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 PL/SQL 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 its 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
Contact this candidate